public tb_SpGoodsInfo FindByID(string _goodid)
{
tb_SpGoodsInfo goods = new tb_SpGoodsInfo();
string sql = "select GoodId,GoodName,ItemNO,ModelNO,GoodMaterial,FImagePath,FColor from tb_SpGoodsInfo where GoodId ='" + _goodid + "'";
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.strGoodsId = ds.Tables[0].Rows[i][0].ToString();
goods.strGoodsName = ds.Tables[0].Rows[i][1].ToString();
goods.strItemNO = ds.Tables[0].Rows[i][2].ToString();
goods.strModelNO = ds.Tables[0].Rows[i][3].ToString();
goods.strGoodMaterial = ds.Tables[0].Rows[i][4].ToString();
goods.strFImagePath = ds.Tables[0].Rows[i][5].ToString();
goods.strFColor = ds.Tables[0].Rows[i][6].ToString();
}
}
}
}
return(goods);
}
public int tb_SpgoodUpdate(tb_SpGoodsInfo good, string goodid)
{
int intFalg = 0;
try
{
string str_Update = "update tb_SpGoodsInfo set ";
str_Update += "GoodId='" + good.strGoodsId + "', ";
str_Update += "Goodname='" + good.strGoodsName + "',";
str_Update += "ItemNO='" + good.strItemNO + "',";
str_Update += "ModelNO= '" + good.strModelNO + "',GoodMaterial='" + good.strGoodMaterial + "',FImagePath ='" + good.strFImagePath + "',";
str_Update += "FColor= '" + good.strFColor + "',FTypeSteps1='" + good.strFTypeSteps1 + "',FTypeSteps2 ='" + good.strFTypeSteps2 + "',";
str_Update += "FTypeSteps3= '" + good.strFTypeSteps3 + "',FColorSteps='" + good.strFColor + "',FIsStop =" + good.iFIsStop + ",FMaterialQty = '" + good.strFMaterialQty + "'";
str_Update += " where GoodId='" + goodid + "'";
intFalg = dbc.ExeInfochange(str_Update);
return(intFalg);
// conn.Dispose();
//return intFalg;
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
public int tb_SpGoodsInfoAdd(
tb_SpGoodsInfo good
)
{
int intFalg = 0;
try
{
/* if (ishaspics)
* {
* string str_Add = "insert into tb_GoodsInfo(GoodId,GoodName,ItemNO,ModelNO,GoodMaterial,FCreater,FCreateDate,fImage) values( ";
* str_Add += " '" + good.strGoodsId + "','" + good.strGoodsName + "',";
* str_Add += " '" + good.strItemNO + "',";
* str_Add += " '" + good.strModelNO + "','" + good.strGoodMaterial + "','" + good.strFCreater + "','" + good.dFCreateDate + "',@img )";
* intFalg = dbc.ExeInfochange(str_Add, "@img", good.image);
* }
* else
* {
*/
string str_Add = "insert into tb_SpGoodsInfo(GoodId,GoodName,ItemNO,ModelNO,GoodMaterial,FCreater,FCreateDate,FImagePath,FColor,FTypeSteps1,FTypeSteps2,FTypeSteps3,FColorSteps,FIsStop,FMaterialQty) values( ";
str_Add += " '" + good.strGoodsId + "','" + good.strGoodsName + "',";
str_Add += " '" + good.strItemNO + "',";
str_Add += " '" + good.strModelNO + "','" + good.strGoodMaterial + "','" + good.strFCreater + "','" + good.dFCreateDate + "','" + good.strFImagePath + "',";
str_Add += " '" + good.strFColor + "','" + good.strFTypeSteps1 + "','" + good.strFTypeSteps2 + "','" + good.strFTypeSteps3 + "','" + good.strFColorSteps + "'," + good.iFIsStop + ",'" + good.strFMaterialQty + "')";
string sql = "select Count(1) from tb_SpGoodsInfo where GoodId='" + good.strGoodsId + "'";
//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)
{
MessageUtil.ShowError("新增失败!");
return(intFalg);
}
}
private void btnCancleClick(object sender, EventArgs e)
{
//throw new NotImplementedException();
//新增取消
if (toolbar1.flag == 0)
{
ClearControls();
UpdateBindings(context);
SetControlsReadOnly(true);
isEdit = false;
}
else
{
//BindControls();
//FreshJch();
GridRow selectRow = superGridControl1.PrimaryGrid.ActiveRow as GridRow;
good = goodmethod.FindByID(selectRow["GoodId"].Value.ToString());
//good = goodmethod.Find(superGridControl1.PrimaryGrid.ActiveRow.GetCell(superGridControl1.PrimaryGrid.ActiveRow.RowIndex,2).ToString());
if (good != null)
{
tbgoodid.Text = good.strGoodsId;
tbgoodname.Text = good.strGoodsName;
cmbColor.SelectedValue = good.strFColor == null ? "" : good.strFColor;
tbftypestep1.SelectedValue = good.strFTypeSteps1 == null ? "" : good.strFTypeSteps1;
tbftypestep2.SelectedValue = good.strFTypeSteps2 == null ? "" : good.strFTypeSteps2;
tbftypestep3.SelectedValue = good.strFTypeSteps3 == null ? "" : good.strFTypeSteps3;
tbfcolorsteps.SelectedValue = good.strFColorSteps == null ? "" : good.strFColorSteps;
tbmono.Text = good.strModelNO;
cmbMaterial.SelectedValue = good.strGoodMaterial == null ? "" : good.strGoodMaterial;
pictureBox1.ImageLocation = good.strFImagePath;
ckbifstop.Checked = good.iFIsStop == 1;
tbmqty.Text = good.strFMaterialQty;
}
//UpdateBindings(context);
SetControlsReadOnly(true);
isEdit = false;
}
}