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