www.pudn.com > FORU(SMS).rar > DataClass.cs

using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using System.Data.SqlClient; 
using System.Windows.Forms; 
 
namespace FORU_SMS_.BaseClass 
{ 
    public class DataClass 
    { 
        BaseClass.DataConn Dconn = new DataConn(); 
        SqlDataAdapter Mysda; 
        DataSet Myds; 
        DataTable Mydt; 
        SqlCommand SqlCom; 
 
        //返回一个DataSet 
        public DataSet GetDataSet(string sql, string dt) 
        { 
            Mysda = new SqlDataAdapter(sql, Dconn.OpenConn()); 
            Myds = new DataSet(); 
            Mysda.Fill(Myds, dt); 
            return Myds; 
        } 
        //绑定ComboBox控件 
        public void BindComboBox(string sql, string dt, string Par_Name, ComboBox cbox) 
        { 
            Myds = GetDataSet(sql, dt); 
            cbox.DataSource = Myds.Tables[dt]; 
            cbox.DisplayMember = Par_Name; 
        } 
         
        //执行SQL语句，无返回值 
        public void ExecuteSql(string sql) 
        { 
            try 
            { 
                SqlCom = new SqlCommand(sql, Dconn.OpenConn()); 
                SqlCom.ExecuteNonQuery(); 
            } 
            catch (Exception e) 
            { 
                throw new Exception(e.Message); 
            } 
            finally 
            { 
                Dconn.CloseConn(); 
            } 
        } 
 
        //验证用户登陆 
        public bool ChkLogin(string txtUser, string txtPass) 
        { 
            bool strEnter = false; 
            SqlCom = new SqlCommand("select count(*) from SMS_User where UserName=@txtUser AND Password=@txtPass", Dconn.OpenConn()); 
            SqlParameter para = new SqlParameter("@txtUser",SqlDbType.VarChar,20); 
            para.Value = txtUser; 
            SqlCom.Parameters.Add(para); 
            para = new SqlParameter("@txtPass", SqlDbType.VarChar, 20); 
            para.Value = txtPass; 
            SqlCom.Parameters.Add(para); 
            int intCount = Convert.ToInt32(SqlCom.ExecuteScalar()); 
            if (intCount > 0) 
            { 
                strEnter = true; 
            } 
            else 
            { 
                strEnter = false; 
            } 
            return strEnter; 
        } 
 
        public SqlDataReader GetRead(string sql) 
        { 
            SqlCom = new SqlCommand(sql, Dconn.OpenConn()); 
            SqlDataReader sqlRead = SqlCom.ExecuteReader(CommandBehavior.CloseConnection); 
            return sqlRead; 
        } 
 
        public DataTable GetDataTable(string sql) 
        { 
            SqlCom = new SqlCommand(sql, Dconn.OpenConn()); 
            Mydt = new DataTable(); 
            Mysda = new SqlDataAdapter(); 
            try 
            { 
                Mysda.SelectCommand = SqlCom; 
                Mysda.Fill(Mydt); 
            } 
            catch (Exception) { } 
            finally 
            { 
                Dconn.CloseConn(); 
            } 
            return Mydt; 
        } 
 
        private bool isNumber(string s) 
        { 
            int Flag = 0; 
            char[] str = s.ToCharArray(); 
            for (int i = 0; i < str.Length; i++) 
            { 
                if (Char.IsNumber(str[i])) 
                { 
                    Flag++; 
                } 
                else 
                { 
                    Flag = -1; 
                    break; 
                } 
            } 
            if (Flag > 0) 
            { 
                return true; 
            } 
            else 
            { 
                return false; 
            } 
        } 
 
 
        public void saveGoods(AddGoods _Add) 
        { 
            string sql = ""; 
            sql = sql + "insert into SMS_Goods(GoodsID,GoodsName,StoreName,SupName,SpecName,UnitName,GoodsNum,GoodsPrice,GoodsAPrice,GoodsPeople,GoodsRemarks) values (@GoodsID,@GoodsName,@StoreName,@SupName,@SpecName,@UnitName,@GoodsNum,@GoodsPrice,@GoodsAPrice,@GoodsPeople,@GoodsRemarks)"; 
            SqlCom = new SqlCommand(sql,Dconn.OpenConn()); 
            Mysda = new SqlDataAdapter(); 
            Mysda.SelectCommand = SqlCom; 
            SqlCom.Parameters.Add("@GoodsID", SqlDbType.VarChar, 20, "GoodsID").Value = _Add.GoodsID; 
            SqlCom.Parameters.Add("@GoodsName", SqlDbType.VarChar, 50, "GoodsName").Value = _Add.GoodsName; 
            SqlCom.Parameters.Add("@StoreName", SqlDbType.VarChar, 50, "StoreName").Value = _Add.StoreName; 
            SqlCom.Parameters.Add("@SupName", SqlDbType.VarChar, 50, "SupName").Value = _Add.SupName; 
            SqlCom.Parameters.Add("@UnitName", SqlDbType.VarChar, 10, "UnitName").Value = _Add.UnitName; 
            SqlCom.Parameters.Add("@GoodsNum", SqlDbType.Int, 4, "GoodsNum").Value = _Add.GoodsNum; 
            SqlCom.Parameters.Add("@SpecName", SqlDbType.VarChar, 50, "SpecName").Value = _Add.SpecName; 
            SqlCom.Parameters.Add("@GoodsPrice", SqlDbType.Float, 10, "GoodsPrice").Value = _Add.GoodsPrice; 
            SqlCom.Parameters.Add("@GoodsAPrice", SqlDbType.Float, 10, "GoodsAPrice").Value = _Add.GoodsAPrice; 
            SqlCom.Parameters.Add("@GoodsPeople", SqlDbType.VarChar, 20, "GoodsPeople").Value = _Add.GoodsPeople; 
            SqlCom.Parameters.Add("@GoodsRemarks", SqlDbType.VarChar, 50, "GoodsRemarks").Value = _Add.GoodsRemarks; 
            try 
            { 
                SqlCom.ExecuteNonQuery(); 
            } 
            catch (Exception) { } 
            finally 
            { 
                Dconn.CloseConn(); 
            } 
        } 
 
 
    } 
}