protected void ButtonSubmit_Click(object sender, EventArgs e) { ERP.BLL.Warehouses bll = new ERP.BLL.Warehouses(); ERP.Model.Warehouses model = new ERP.Model.Warehouses(); model.WName = TextBoxWName.Text.ToString(); model.WArea = Convert.ToInt32(TextBoxWArea.Text); model.WAddress = TextBoxWAddress.Text.ToString(); model.WDescribe = TextBoxWDescribe.Text.ToString(); try { bll.Add(model); Response.Write("<script>alert('添加新仓库成功');history.back()</script>"); TextBoxWName.Text = ""; TextBoxWArea.Text = ""; TextBoxWAddress.Text = ""; TextBoxWDescribe.Text = ""; } catch (Exception) { Response.Write("<script>alert('未知错误,添加新仓库失败!');history.back()</script>"); TextBoxWName.Text = ""; TextBoxWArea.Text = ""; TextBoxWAddress.Text = ""; TextBoxWDescribe.Text = ""; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ERP.Model.Warehouses model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Warehouses("); strSql.Append("WName,WArea,WAddress,WDescribe)"); strSql.Append(" values ("); strSql.Append("@WName,@WArea,@WAddress,@WDescribe)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@WName", SqlDbType.NVarChar, 50), new SqlParameter("@WArea", SqlDbType.Float, 8), new SqlParameter("@WAddress", SqlDbType.NVarChar, 50), new SqlParameter("@WDescribe", SqlDbType.NVarChar, 500) }; parameters[0].Value = model.WName; parameters[1].Value = model.WArea; parameters[2].Value = model.WAddress; parameters[3].Value = model.WDescribe; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ERP.Model.Warehouses model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Warehouses set "); strSql.Append("WArea=@WArea,"); strSql.Append("WAddress=@WAddress,"); strSql.Append("WDescribe=@WDescribe"); strSql.Append(" where WID=@WID"); SqlParameter[] parameters = { new SqlParameter("@WArea", SqlDbType.Float, 8), new SqlParameter("@WAddress", SqlDbType.NVarChar, 50), new SqlParameter("@WDescribe", SqlDbType.NVarChar, 500), new SqlParameter("@WID", SqlDbType.Int, 4), new SqlParameter("@WName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.WArea; parameters[1].Value = model.WAddress; parameters[2].Value = model.WDescribe; parameters[3].Value = model.WID; parameters[4].Value = model.WName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ERP.Model.Warehouses DataRowToModel(DataRow row) { ERP.Model.Warehouses model = new ERP.Model.Warehouses(); if (row != null) { if (row["WID"] != null && row["WID"].ToString() != "") { model.WID = int.Parse(row["WID"].ToString()); } if (row["WName"] != null) { model.WName = row["WName"].ToString(); } if (row["WArea"] != null && row["WArea"].ToString() != "") { model.WArea = decimal.Parse(row["WArea"].ToString()); } if (row["WAddress"] != null) { model.WAddress = row["WAddress"].ToString(); } if (row["WDescribe"] != null) { model.WDescribe = row["WDescribe"].ToString(); } } return(model); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { ERP.Model.Warehouses model = new ERP.Model.Warehouses(); model.WID = Convert.ToInt32(((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text); model.WName = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString(); model.WArea = Convert.ToInt32(((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text); model.WAddress = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString(); model.WDescribe = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].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 WID) { ERP.BLL.Warehouses bll = new ERP.BLL.Warehouses(); ERP.Model.Warehouses model = bll.GetModel(WID); this.lblWID.Text = model.WID.ToString(); this.lblWName.Text = model.WName; this.txtWArea.Text = model.WArea.ToString(); this.txtWAddress.Text = model.WAddress; this.txtWDescribe.Text = model.WDescribe; }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtWName.Text.Trim().Length == 0) { strErr += "WName不能为空!\\n"; } if (!PageValidate.IsDecimal(txtWArea.Text)) { strErr += "WArea格式错误!\\n"; } if (this.txtWAddress.Text.Trim().Length == 0) { strErr += "WAddress不能为空!\\n"; } if (this.txtWDescribe.Text.Trim().Length == 0) { strErr += "WDescribe不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string WName = this.txtWName.Text; decimal WArea = decimal.Parse(this.txtWArea.Text); string WAddress = this.txtWAddress.Text; string WDescribe = this.txtWDescribe.Text; ERP.Model.Warehouses model = new ERP.Model.Warehouses(); model.WName = WName; model.WArea = WArea; model.WAddress = WAddress; model.WDescribe = WDescribe; ERP.BLL.Warehouses bll = new ERP.BLL.Warehouses(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public ERP.Model.Warehouses GetModel(int WID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 WID,WName,WArea,WAddress,WDescribe from Warehouses "); strSql.Append(" where WID=@WID"); SqlParameter[] parameters = { new SqlParameter("@WID", SqlDbType.Int, 4) }; parameters[0].Value = WID; ERP.Model.Warehouses model = new ERP.Model.Warehouses(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }