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