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

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