goodsbor.cs

库存管理系统,对企业仓库的产品进行管理,使用C#语句 .net 平台开发

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace FORU_SMS_.BaseClass
{
    public class GoodsBor
    {
        DataConn Dconn = new DataConn();
        DataClass Dclass = new DataClass();
        public string _GoodsID;
        public string _GoodsName;
        public string _SupName;
        public string _SpecName;
        public int _GoodsNum;
        public string _BorName;
        public string _GoodsPeople;
        public string _BorDeparment;
        public string _GoodsRemarks;

        public string GoodsID
        {
            set { _GoodsID = value; }
            get { return _GoodsID; }
        }

        public string GoodsName
        {
            set { _GoodsName = value; }
            get { return _GoodsName; }
        }

        public string SupName
        {
            set { _SupName = value; }
            get { return _SupName; }
        }

        public string SpecName
        {
            set { _SpecName = value; }
            get { return _SpecName; }
        }

        public int GoodsNum
        {
            set { _GoodsNum = value; }
            get { return _GoodsNum; }
        }

        public string BorName
        {
            set { _BorName = value; }
            get { return _BorName; }
        }

        public string GoodsPeople
        {
            set { _GoodsPeople = value; }
            get { return _GoodsPeople; }
        }

        public string BorDeparment
        {
            set { _BorDeparment = value; }
            get { return _BorDeparment; }
        }

        public string GoodsRemarks
        {
            set { _GoodsRemarks = value; }
            get { return _GoodsRemarks; }
        }

        public void barGoods()
        {
            string sql = "";
            sql = sql + "insert into SMS_Borrow(GoodsID,GoodsName,SupName,SpecName,GoodsNum,BorName,GoodsPeople,BorDeparment,GoodsRemarks) values "
                + "(@GoodsID,@GoodsName,@SupName,@SpecName,@GoodsNum,@BorName,@GoodsPeople,@BorDeparment,@GoodsRemarks)";
            //sql = sql + "delete from SMS_Goods where GoodsID='" + this.GoodsID + "'";
            sql = sql + "update SMS_Goods set GoodsNum=GoodsNum-@GoodsNum where GoodsID=@GoodsID";
            SqlCommand sqlcom = new SqlCommand(sql, Dconn.OpenConn());
            SqlDataAdapter adpter = new SqlDataAdapter();
            adpter.SelectCommand = sqlcom;
            sqlcom.Parameters.Add("@GoodsID", SqlDbType.VarChar, 20, "GoodsID").Value = this.GoodsID;
            sqlcom.Parameters.Add("@GoodsName", SqlDbType.VarChar, 50, "GoodsName").Value = this.GoodsName;
            sqlcom.Parameters.Add("@SupName", SqlDbType.VarChar, 50, "SupName").Value = this.SupName;
            sqlcom.Parameters.Add("@SpecName", SqlDbType.VarChar, 50, "SpecName").Value = this.SpecName;
            sqlcom.Parameters.Add("@GoodsNum", SqlDbType.Int, 4, "GoodsNum").Value = this.GoodsNum;
            sqlcom.Parameters.Add("@BorName", SqlDbType.VarChar, 20, "BorName").Value = this.BorName;
            sqlcom.Parameters.Add("@GoodsPeople", SqlDbType.VarChar, 20, "GoodsPeople").Value = this.GoodsPeople;
            sqlcom.Parameters.Add("@BorDeparment", SqlDbType.VarChar, 100, "BorDeparment").Value = this.BorDeparment;
            sqlcom.Parameters.Add("@GoodsRemarks", SqlDbType.VarChar, 1000, "GoodsRemarks").Value = this.GoodsRemarks;
            try
            {
                sqlcom.ExecuteNonQuery();
            }
            catch (Exception) { }
            finally
            {
                Dconn.CloseConn();
            }
        }
    }
}