/// <summary> /// 得到一个对象实体 /// </summary> public Cao.WMS.Model.caowms.Warehouses DataRowToModel(DataRow row) { Cao.WMS.Model.caowms.Warehouses model = new Cao.WMS.Model.caowms.Warehouses(); if (row != null) { if (row["WID"] != null && row["WID"].ToString() != "") { model.WID = 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); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Cao.WMS.Model.caowms.Warehouses model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Warehouses("); strSql.Append("WID,WName,WArea,WAddress,WDescribe)"); strSql.Append(" values ("); strSql.Append("@WID,@WName,@WArea,@WAddress,@WDescribe)"); SqlParameter[] parameters = { new SqlParameter("@WID", SqlDbType.NVarChar, 50), 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.WID; parameters[1].Value = model.WName; parameters[2].Value = model.WArea; parameters[3].Value = model.WAddress; parameters[4].Value = model.WDescribe; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(string WID) { Cao.WMS.BLL.caowms.Warehouses bll = new Cao.WMS.BLL.caowms.Warehouses(); Cao.WMS.Model.caowms.Warehouses model = bll.GetModel(WID); this.lblWID.Text = model.WID.ToString(); this.lblWName.Text = model.WName; this.lblWArea.Text = model.WArea.ToString(); this.lblWAddress.Text = model.WAddress; this.lblWDescribe.Text = model.WDescribe; }
/// <summary> ///新增仓库货位 /// </summary> public void addWarehouses() { bool addWarehouses = true; Cao.WMS.BLL.caowms.Warehouses bllWarehouses = new Cao.WMS.BLL.caowms.Warehouses(); addWarehouses = bllWarehouses.Exists(this.txtRWID.Text); if (!addWarehouses) { Cao.WMS.Model.caowms.Warehouses modelWarehouses = new Cao.WMS.Model.caowms.Warehouses(); modelWarehouses.WID = this.txtRWID.Text; modelWarehouses.WName = ""; modelWarehouses.WArea = 0; modelWarehouses.WAddress = ""; modelWarehouses.WDescribe = "入库新增货位"; bllWarehouses.Add(modelWarehouses); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtWName.Text.Trim().Length == 0) { strErr += "仓库名称不能为空!\\n"; } if (!PageValidate.IsDecimal(txtWArea.Text)) { strErr += "仓库容积格式错误!\\n"; } if (this.txtWAddress.Text.Trim().Length == 0) { strErr += "仓库地址不能为空!\\n"; } if (this.txtWDescribe.Text.Trim().Length == 0) { strErr += "简单描述不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string WID = this.lblWID.Text; string WName = this.txtWName.Text; decimal WArea = decimal.Parse(this.txtWArea.Text); string WAddress = this.txtWAddress.Text; string WDescribe = this.txtWDescribe.Text; Cao.WMS.Model.caowms.Warehouses model = new Cao.WMS.Model.caowms.Warehouses(); model.WID = WID; model.WName = WName; model.WArea = WArea; model.WAddress = WAddress; model.WDescribe = WDescribe; Cao.WMS.BLL.caowms.Warehouses bll = new Cao.WMS.BLL.caowms.Warehouses(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体WCode /// </summary> public Cao.WMS.Model.caowms.Warehouses GetModel(string 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.NVarChar, 50) }; parameters[0].Value = WID; Cao.WMS.Model.caowms.Warehouses model = new Cao.WMS.Model.caowms.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); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Cao.WMS.Model.caowms.Warehouses model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Warehouses set "); strSql.Append("WName=@WName,"); strSql.Append("WArea=@WArea,"); strSql.Append("WAddress=@WAddress,"); strSql.Append("WDescribe=@WDescribe"); strSql.Append(" where WID=@WID "); 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), new SqlParameter("@WID", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.WName; parameters[1].Value = model.WArea; parameters[2].Value = model.WAddress; parameters[3].Value = model.WDescribe; parameters[4].Value = model.WID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; //if(!PageValidate.IsNumber(txtWID.Text)) //{ // strErr+="仓库编号格式错误!\\n"; //} if (this.txtWName.Text.Trim().Length == 0) { strErr += "仓库名称不能为空!\\n"; } if (!PageValidate.IsDecimal(txtWArea.Text)) { strErr += "仓库容积格式错误!\\n"; } if (this.txtWAddress.Text.Trim().Length == 0) { strErr += "仓库地址不能为空!\\n"; } if (this.txtWDescribe.Text.Trim().Length == 0) { strErr += "简单描述不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } bool addWarehouses = true; Cao.WMS.BLL.caowms.Warehouses bllWarehouses = new Cao.WMS.BLL.caowms.Warehouses(); addWarehouses = bllWarehouses.Exists(this.txtWID.Text.Trim()); if (!addWarehouses) { strErr += "编码重复\\n"; MessageBox.Show(this, strErr); return; } bool addWarehousesWName = true; addWarehousesWName = bllWarehouses.ExistsWName(this.txtWName.Text.Trim()); if (!addWarehouses) { strErr += "仓库名称重复\\n"; MessageBox.Show(this, strErr); return; } //int WID=int.Parse(this.txtWID.Text); string WID = this.txtWID.Text; string WName = this.txtWName.Text; decimal WArea = decimal.Parse(this.txtWArea.Text); string WAddress = this.txtWAddress.Text; string WDescribe = this.txtWDescribe.Text; Cao.WMS.Model.caowms.Warehouses model = new Cao.WMS.Model.caowms.Warehouses(); model.WID = WID; model.WName = WName; model.WArea = WArea; model.WAddress = WAddress; model.WDescribe = WDescribe; Cao.WMS.BLL.caowms.Warehouses bll = new Cao.WMS.BLL.caowms.Warehouses(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }