可對物料進行出入庫登記、查詢、統計等操作

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();
            }
        }


    }
}