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_KcGoodsUpdate(tb_KcGoods kcGood)
{
int intFalg = 0;
try
{
string str_Add = "update tb_KcGoods set ";
str_Add += "KcDeptName='" + kcGood.strKcDeptName + "',KcNum=" + kcGood.intKcNum + ",";
str_Add += "KcAlarmNum=" + kcGood.intKcAlarmNum + ",KcTime='" + kcGood.daKcTime + "',";
str_Add += "KcGoodsPrice=" + kcGood.deKcGoodsPrice + ",KcSellPrice=" + kcGood.deKcSellPrice + ",KcEmp='" + kcGood.strKcEmp + "',";
str_Add += "KcRemark='" + kcGood.strKcRemark + "' where GoodsID ='" + kcGood.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_KcGoodsAdd(tb_KcGoods kcGood)
{
int intFalg = 0;
try
{
string str_Add = "insert into tb_KcGoods values( ";
str_Add += "'" + kcGood.strGoodsID + "','" + kcGood.strJhCompName + "',";
str_Add += "'" + kcGood.strKcDeptName + "','" + kcGood.strKcGoodsName + "'," + kcGood.intKcNum + ",";
str_Add += "" + kcGood.intKcAlarmNum + ",'" + kcGood.intKcUnit + "','" + kcGood.daKcTime + "',";
str_Add += "" + kcGood.deKcGoodsPrice + "," + kcGood.deKcSellPrice + ",'" + kcGood.strKcEmp + "',";
str_Add += "'" + kcGood.strKcRemark + "')";
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 void tb_ThGoodsFind(object DataObject, int intFalg, tb_KcGoods kcGood)
{
}
public int tb_KcGoodsUpdate(tb_KcGoods kcGood)
{
int intFalg = 0;
return(intFalg);
}
public int tb_KcGoodsAdd(tb_KcGoods kcGood)
{
int intFalg = 0;
return(intFalg);
}
public void tb_ThGoodsFind(object DataObject, int intFalg, tb_KcGoods kcGood)
{
int intCount = 0;
string strSecar = null;
try
{
switch (intFalg)
{
case 1:
strSecar = "select * from tb_KcGoods where GoodsID like '%" + kcGood.strGoodsID + "%'";
break;
case 2:
strSecar = "select * from tb_KcGoods where KcGoodsName like '%" + kcGood.strKcGoodsName + "%'";
break;
case 4:
strSecar = "select * from tb_KcGoods ";
break;
}
getSqlConnection getConnection = new getSqlConnection();
conn = getConnection.GetCon();
cmd = new SqlCommand(strSecar, conn);
int ii = 0;
qlddr = cmd.ExecuteReader();
while (qlddr.Read())
{
ii++;
}
qlddr.Close();
System.Windows.Forms.DataGridView dv = (DataGridView)DataObject;
if (ii != 0)
{
int i = 0;
dv.RowCount = ii;
qlddr = cmd.ExecuteReader();
while (qlddr.Read())
{
dv[0, i].Value = qlddr[1].ToString();
dv[1, i].Value = qlddr[4].ToString();
dv[2, i].Value = qlddr[3].ToString();
dv[3, i].Value = qlddr[5].ToString();
dv[4, i].Value = qlddr[6].ToString();
i++;
}
qlddr.Close();
}
else
{
if (dv.RowCount != 0)
{
int i = 0;
do
{
dv[0, i].Value = "";
dv[1, i].Value = "";
dv[2, i].Value = "";
dv[3, i].Value = "";
dv[4, i].Value = "";
i++;
} while (i < dv.RowCount);
}
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
}
}
