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

using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using System.Data.SqlClient; 
 
namespace FORU_SMS_.BaseClass 
{ 
    public class GoodsReturn 
    { 
        DataConn Dconn = new DataConn(); 
        DataClass Dclass = new DataClass(); 
 
        public string _GoodsID; 
        public string _GoodsName; 
        public string _SupName; 
        public string _SpecName; 
        public int _ReturnNum; 
        public int _NoReturnNum; 
        public string _ReturnPeople; 
        public string _GoodsPeople; 
        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 ReturnNum 
        { 
            set { _ReturnNum = value; } 
            get { return _ReturnNum; } 
        }    
 
        public int NoReturnNum 
        { 
            set { _NoReturnNum = value; } 
            get { return _NoReturnNum; } 
        } 
 
        public string ReturnPeople 
        { 
            set { _ReturnPeople = value; } 
            get { return _ReturnPeople; } 
        } 
 
        public string GoodsPeople 
        { 
            set { _GoodsPeople = value; } 
            get { return _GoodsPeople; } 
        } 
 
        public string GoodsRemarks 
        { 
            set { _GoodsRemarks = value; } 
            get { return _GoodsRemarks; } 
        } 
 
        public void returnGoods() 
        { 
            string sql = ""; 
            sql = sql + "insert into SMS_Return(GoodsID,GoodsName,SupName,SpecName,ReturnNum,NoReturnNum,ReturnPeople,GoodsPeople,GoodsRemarks) values " 
            + "(@GoodsID,@GoodsName,@SupName,@SpecName,@ReturnNum,@NoReturnNum,@ReturnPeople,@GoodsPeople,@GoodsRemarks)"; 
            sql = sql + ";"; 
            sql = sql + "delete from SMS_Borrow 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("@ReturnNum", SqlDbType.Int, 4, "ReturnNum").Value = this.ReturnNum; 
            sqlcom.Parameters.Add("@NoReturnNum", SqlDbType.Int, 4, "NoReturnNum").Value = this.NoReturnNum; 
            sqlcom.Parameters.Add("@ReturnPeople", SqlDbType.VarChar, 20, "ReturnPeople").Value = this.ReturnPeople; 
            sqlcom.Parameters.Add("@GoodsPeople", SqlDbType.VarChar, 20, "GoodsPeople").Value = this.GoodsPeople; 
            sqlcom.Parameters.Add("@GoodsRemarks", SqlDbType.VarChar, 1000, "GoodsRemarks").Value = this.GoodsRemarks; 
            try 
            { 
                sqlcom.ExecuteNonQuery(); 
            } 
            catch (Exception) { } 
            finally 
            { 
                Dconn.CloseConn(); 
            } 
        } 
    } 
}