public int tb_JhGoodsInfoMenthodUpdate(_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();
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int tb_JhGoodsInfoMenthodAdd(_JhGoodsInfo tbGood)
{
int intFalg = 0;
try
{
//string str_Add = "insert into tb_JhGoodsInfo values( ";
//str_Add += "'" + tbGood.strGoodsID + "','" + tbGood.strEmpId + "','" + tbGood.strJhCompName + "',";
//str_Add += "'" + tbGood.strDepotName + "','" + tbGood.strGoodsName + "','" + tbGood.strGoodsNum + "',";
//str_Add += "'" + tbGood.strGoodsUnit + "','" + tbGood.deGoodsJhPrice + "','" + tbGood.deGoodsSellPrice + "',";
//str_Add += "'" + tbGood.deGoodsNeedPrice + "','" + tbGood.deGoodsNoPrice + "','" + tbGood.strGoodsRemark + "',";
//str_Add += "'" + tbGood.Falg + "')";
string str_Add = "insert into tb_JhGoodsInfo values( ";
str_Add += "'" + tbGood.strGoodsID + "','" + tbGood.strEmpId + "','" + tbGood.strJhCompName + "',";
str_Add += "'" + tbGood.strDepotName + "','" + tbGood.strGoodsName + "','" + tbGood.strGoodsNum + "',";
str_Add += "'" + tbGood.strGoodsUnit + "'," + tbGood.deGoodsJhPrice + " ," + tbGood.deGoodsSellPrice + " ,";
str_Add += "" + tbGood.deGoodsNeedPrice + "," + tbGood.deGoodsNoPrice + ",'" + tbGood.strGoodsRemark + "',";
str_Add += "'" + tbGood.DaGoodTime + "'," + tbGood.Falg + ")";
_getSqlConnection getConnection = new _getSqlConnection();
conn = getConnection.GetCon();
cmd = new SqlCommand(str_Add, conn);
intFalg = cmd.ExecuteNonQuery();
conn.Dispose();
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int tb_JhGoodsInfoMenthodDelete(_JhGoodsInfo tbGood)
{
int intFalg = 0;
try
{
string str_Add = "update tb_JhGoodsInfo set ";
str_Add += "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();
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
