public static void ChangeNum(MODEL.InStockdetail instockdetail)
{
string sql = "select distinct GoodsID from stockgoods_table where GoodsID='"
+ instockdetail.GoodID + "'";
DataSet a = Datameans.getDataSet(sql);
if (a.Tables[0].Rows.Count == 0)
{
string sql1 = "insert into stockgoods_table(GoodsID,Storename,GoodNum) values('"
+ instockdetail.GoodID
+ "','"
+ instockdetail.Inventory
+ "','"
+ instockdetail.Amount + "')";
Datameans.getsqlcom(sql1);
}
//如果表中有ID，根据入库单商品ID在库存表里增加相应数量Amount
else
{
string sql2 = "update stockgoods_table set GoodNum = GoodNum + '" + instockdetail.Amount + "' where GoodsID='"
+ instockdetail.GoodID + "'";
Datameans.getsqlcom(sql2);
}
//如果表中没有该商品ID插入以下信息
//Datameans.getsqlcom(sql1);
}
public static void InputDetail(MODEL.InStockdetail instockdetail)
{
String sql = "insert into stockdetail_table(GoodinID,GoodsID,Goodsname,Suppliername,Storename,GoodsinNum,Goodsinprice) values('"
+ instockdetail.InID
+ "','"
+ instockdetail.GoodID
+ "','"
+ instockdetail.GoodName
+ "','"
+ instockdetail.Supplier
+ "','"
+ instockdetail.Inventory
+ "','"
+ instockdetail.Amount
+ "','"
+ instockdetail.goodinprice + "')";
Datameans.getsqlcom(sql);
//插入入库单从表
}