public int tb_JhGoodsInfoMenthodUpdate(tb_JhGoodsInfo tbGood)
{
int intFalg = 0;
try
{
string str_Add = "update tb_JhGoodsInfo set ";
str_Add += "EmpId='" + tbGood.strEmpId + "',JhCompName='" + tbGood.strJhCompName + "',";
str_Add += "DepotName='" + tbGood.strDepotName + "',GoodsName='" + tbGood.strGoodsName + "',GoodsNum='" + tbGood.strGoodsNum + "',";
str_Add += "GoodsUnit='" + tbGood.strGoodsUnit + "',GoodsJhPrice='" + tbGood.deGoodsJhPrice + "' ,GoodsSellPrice='" + tbGood.deGoodsSellPrice + "' ,";
str_Add += "GoodsNeedPrice='" + tbGood.deGoodsNeedPrice + "',GoodsNoPrice='" + tbGood.deGoodsNoPrice + "',GoodsRemark='" + tbGood.strGoodsRemark + "',";
str_Add += "GoodTime='" + tbGood.DaGoodTime + "',Falg='" + tbGood.Falg + "' where GoodsID ='" + tbGood.strGoodsID + "'";
getSqlConnection getConnection = new getSqlConnection();
conn = getConnection.GetCon();
cmd = new SqlCommand(str_Add, conn);
intFalg = cmd.ExecuteNonQuery();
conn.Dispose();
tb_KcGoods kc = new tb_KcGoods(tbGood.strGoodsID, tbGood.strJhCompName, tbGood.strDepotName, tbGood.strGoodsName, tbGood.strGoodsNum, 0, tbGood.strGoodsUnit, tbGood.DaGoodTime, tbGood.deGoodsJhPrice, tbGood.deGoodsSellPrice, tbGood.strEmpId, "");
tb_KcGoodsMenthod kc1 = new tb_KcGoodsMenthod();
kc1.tb_KcGoodsUpdate(kc);
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int tb_SellGoodsAdd(tb_SellGoods tbChGood)
{
int intFalg = 0;
try
{
string str_Add = "insert into tb_SellGoods values( ";
str_Add += "'" + tbChGood.strSellID + "','" + tbChGood.strKcID + "','" + tbChGood.strGoodsID + "',";
str_Add += "'" + tbChGood.strEmpId + "','" + tbChGood.strGoodsName + "','" + tbChGood.strSellGoodsNum + "',";
str_Add += "'" + tbChGood.daSellGoodsTime + "','" + tbChGood.deSellPrice + "',";
str_Add += "'" + tbChGood.deSellNeedPay + "','" + tbChGood.deSellHasPay + "','" + tbChGood.strSellRemark + "'," + tbChGood.intSellFalg + ")";
getSqlConnection getConnection = new getSqlConnection();
conn = getConnection.GetCon();
cmd = new SqlCommand(str_Add, conn);
intFalg = cmd.ExecuteNonQuery();
conn.Dispose();
tb_KcGoodsMenthod kc1 = new tb_KcGoodsMenthod();
/*qlddr = kc1.tb_ThGoodsFind1(tbChGood.strGoodsName);
*
* int ykc = Convert.ToInt32(qlddr["KcNum"]);
* MessageBox.Show("sdd"+ykc);
* Console.WriteLine();
*
* int xkc = ykc - tbChGood.strSellGoodsNum;
* tb_KcGoodsMenthod kc2 = new tb_KcGoodsMenthod();
* kc2.tb_KcGoodsUpdate1(tbChGood.strGoodsName, xkc);*/
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
