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