public int tb_WareHouseAdd(tb_WareHouse good)
{
int intFalg = 0;
try
{
string str_Add = "insert into tb_WareHouse(WareID,WareName,Remark) values( ";
str_Add += " '" + good.strWareID + "','" + good.strWareName + "','" + good.strRemark + "')";
string sql = "select Count(1) from tb_WareHouse where WareID='" + good.strWareID + "'";
//SqlCommand cmd1 = new SqlCommand(sql, conn);
int count = dbc.ExecuteSelect(sql);
if (count > 0)
{
MessageUtil.ShowError("仓库编号已存在!");
return(0);
}
else
{
intFalg = dbc.ExeInfochange(str_Add);
return(intFalg);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int tb_WareHouseUpdate(tb_WareHouse ware)
{
int intFalg = 0;
try
{
string str_Update = "update tb_WareHouse set ";
str_Update += "WareName='" + ware.strWareName + "',";
str_Update += "Remark='" + ware.strRemark + "'";
str_Update += "where WareID = '" + ware.strWareID + "'";
intFalg = dbc.ExeInfochange(str_Update);
// conn.Dispose();
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public tb_WareHouse Find(string _id)
{
tb_WareHouse goods = new tb_WareHouse();
string sql = "select WareID,WareName,Remark from tb_WareHouse where WareID ='" + _id + "'";
DataSet ds = dbl.GetDataset(sql);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
goods.strWareID = ds.Tables[0].Rows[i][0].ToString();
goods.strWareName = ds.Tables[0].Rows[i][1].ToString();
goods.strRemark = ds.Tables[0].Rows[i][2].ToString();
}
}
}
}
return(goods);
}
