protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { ERP.Model.Materials model = new ERP.Model.Materials(); model.MID = Convert.ToInt32(((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text); model.MCode = Convert.ToInt32(((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text); model.MName = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString(); model.MModel = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString(); model.MMaterial = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text.ToString(); model.MStandard = ((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text.ToString(); model.MUnit = ((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text.ToString(); model.MNumber = Convert.ToInt32(((TextBox)GridView1.Rows[e.RowIndex].Cells[7].Controls[0]).Text); model.WName = ((TextBox)GridView1.Rows[e.RowIndex].Cells[8].Controls[0]).Text.ToString(); try { bool TrueOrFalse = bll.Update(model); if (TrueOrFalse) { Response.Write("<script language=javascript>alert('保存成功!')</script>"); } else { Response.Write("<script language=javascript>alert('保存失败!')</script>"); } GridView1.EditIndex = -1; LoadList(); } catch (Exception erro) { Response.Write("错误信息:" + erro.Message); } }
private void ShowInfo(int MID) { ERP.BLL.Materials bll = new ERP.BLL.Materials(); ERP.Model.Materials model = bll.GetModel(MID); this.lblMID.Text = model.MID.ToString(); this.lblMCode.Text = model.MCode.ToString(); this.lblMName.Text = model.MName; this.lblMModel.Text = model.MModel; this.lblMMaterial.Text = model.MMaterial; this.lblMStandard.Text = model.MStandard; this.lblMUnit.Text = model.MUnit; this.lblMNumber.Text = model.MNumber.ToString(); this.lblWName.Text = model.WName; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ERP.Model.Materials model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Materials set "); strSql.Append("MCode=@MCode,"); strSql.Append("MModel=@MModel,"); strSql.Append("MMaterial=@MMaterial,"); strSql.Append("MStandard=@MStandard,"); strSql.Append("MUnit=@MUnit,"); strSql.Append("MNumber=@MNumber,"); strSql.Append("WName=@WName"); strSql.Append(" where MID=@MID"); SqlParameter[] parameters = { new SqlParameter("@MCode", SqlDbType.Int, 4), new SqlParameter("@MModel", SqlDbType.NVarChar, 50), new SqlParameter("@MMaterial", SqlDbType.NVarChar, 50), new SqlParameter("@MStandard", SqlDbType.NVarChar, 50), new SqlParameter("@MUnit", SqlDbType.NVarChar, 50), new SqlParameter("@MNumber", SqlDbType.Int, 4), new SqlParameter("@WName", SqlDbType.NVarChar, 50), new SqlParameter("@MID", SqlDbType.Int, 4), new SqlParameter("@MName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.MCode; parameters[1].Value = model.MModel; parameters[2].Value = model.MMaterial; parameters[3].Value = model.MStandard; parameters[4].Value = model.MUnit; parameters[5].Value = model.MNumber; parameters[6].Value = model.WName; parameters[7].Value = model.MID; parameters[8].Value = model.MName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ERP.Model.Materials DataRowToModel(DataRow row) { ERP.Model.Materials model = new ERP.Model.Materials(); if (row != null) { if (row["MID"] != null && row["MID"].ToString() != "") { model.MID = int.Parse(row["MID"].ToString()); } if (row["MCode"] != null && row["MCode"].ToString() != "") { model.MCode = int.Parse(row["MCode"].ToString()); } if (row["MName"] != null) { model.MName = row["MName"].ToString(); } if (row["MModel"] != null) { model.MModel = row["MModel"].ToString(); } if (row["MMaterial"] != null) { model.MMaterial = row["MMaterial"].ToString(); } if (row["MStandard"] != null) { model.MStandard = row["MStandard"].ToString(); } if (row["MUnit"] != null) { model.MUnit = row["MUnit"].ToString(); } if (row["MNumber"] != null && row["MNumber"].ToString() != "") { model.MNumber = int.Parse(row["MNumber"].ToString()); } if (row["WName"] != null) { model.WName = row["WName"].ToString(); } } return(model); }
protected void ButtonSubmit_Click(object sender, EventArgs e) { ERP.BLL.Materials bll = new ERP.BLL.Materials(); ERP.Model.Materials model = new ERP.Model.Materials(); model.MCode = Convert.ToInt32(TextBoxMCode.Text); model.MName = TextBoxMName.Text.ToString(); model.MModel = TextBoxMModel.Text.ToString(); model.MMaterial = TextBoxMMaterial.Text.ToString(); model.MStandard = TextBoxMStandard.Text.ToString(); model.MUnit = TextBoxMUnit.Text.ToString(); model.MNumber = Convert.ToInt32(TextBoxMNumber.Text); //仓库名称-由下拉菜单选择 model.WName = DropDownList.Text.ToString(); try { bll.Add(model); Response.Write("<script>alert('插入成功');history.back()</script>"); TextBoxMCode.Text = ""; TextBoxMName.Text = ""; TextBoxMModel.Text = ""; TextBoxMMaterial.Text = ""; TextBoxMStandard.Text = ""; TextBoxMUnit.Text = ""; TextBoxMNumber.Text = ""; } catch (Exception) { Response.Write("<script>alert('插入失败');history.back()</script>"); TextBoxMCode.Text = ""; TextBoxMName.Text = ""; TextBoxMModel.Text = ""; TextBoxMMaterial.Text = ""; TextBoxMStandard.Text = ""; TextBoxMUnit.Text = ""; TextBoxMNumber.Text = ""; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ERP.Model.Materials model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Materials("); strSql.Append("MCode,MName,MModel,MMaterial,MStandard,MUnit,MNumber,WName)"); strSql.Append(" values ("); strSql.Append("@MCode,@MName,@MModel,@MMaterial,@MStandard,@MUnit,@MNumber,@WName)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MCode", SqlDbType.Int, 4), new SqlParameter("@MName", SqlDbType.NVarChar, 50), new SqlParameter("@MModel", SqlDbType.NVarChar, 50), new SqlParameter("@MMaterial", SqlDbType.NVarChar, 50), new SqlParameter("@MStandard", SqlDbType.NVarChar, 50), new SqlParameter("@MUnit", SqlDbType.NVarChar, 50), new SqlParameter("@MNumber", SqlDbType.Int, 4), new SqlParameter("@WName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.MCode; parameters[1].Value = model.MName; parameters[2].Value = model.MModel; parameters[3].Value = model.MMaterial; parameters[4].Value = model.MStandard; parameters[5].Value = model.MUnit; parameters[6].Value = model.MNumber; parameters[7].Value = model.WName; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ERP.Model.Materials GetModel(int MID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MID,MCode,MName,MModel,MMaterial,MStandard,MUnit,MNumber,WName from Materials "); strSql.Append(" where MID=@MID"); SqlParameter[] parameters = { new SqlParameter("@MID", SqlDbType.Int, 4) }; parameters[0].Value = MID; ERP.Model.Materials model = new ERP.Model.Materials(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtMCode.Text)) { strErr += "MCode格式错误!\\n"; } if (this.txtMModel.Text.Trim().Length == 0) { strErr += "MModel不能为空!\\n"; } if (this.txtMMaterial.Text.Trim().Length == 0) { strErr += "MMaterial不能为空!\\n"; } if (this.txtMStandard.Text.Trim().Length == 0) { strErr += "MStandard不能为空!\\n"; } if (this.txtMUnit.Text.Trim().Length == 0) { strErr += "MUnit不能为空!\\n"; } if (!PageValidate.IsNumber(txtMNumber.Text)) { strErr += "MNumber格式错误!\\n"; } if (this.txtWName.Text.Trim().Length == 0) { strErr += "WName不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int MID = int.Parse(this.lblMID.Text); int MCode = int.Parse(this.txtMCode.Text); string MName = this.lblMName.Text; string MModel = this.txtMModel.Text; string MMaterial = this.txtMMaterial.Text; string MStandard = this.txtMStandard.Text; string MUnit = this.txtMUnit.Text; int MNumber = int.Parse(this.txtMNumber.Text); string WName = this.txtWName.Text; ERP.Model.Materials model = new ERP.Model.Materials(); model.MID = MID; model.MCode = MCode; model.MName = MName; model.MModel = MModel; model.MMaterial = MMaterial; model.MStandard = MStandard; model.MUnit = MUnit; model.MNumber = MNumber; model.WName = WName; ERP.BLL.Materials bll = new ERP.BLL.Materials(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }