/// <summary> /// 更新一条数据 /// </summary> public bool Update(Cao.WMS.Model.caowms.Goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Goods set "); strSql.Append("GName=@GName,"); strSql.Append("GPrice=@GPrice,"); strSql.Append("GProvider=@GProvider,"); strSql.Append("n_bak=@n_bak"); strSql.Append(" where GID=@GID "); SqlParameter[] parameters = { new SqlParameter("@GName", SqlDbType.NVarChar, 50), new SqlParameter("@GPrice", SqlDbType.Money, 8), new SqlParameter("@GProvider", SqlDbType.NVarChar, 50), new SqlParameter("@n_bak", SqlDbType.NVarChar, 200), new SqlParameter("@GID", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.GName; parameters[1].Value = model.GPrice; parameters[2].Value = model.GProvider; parameters[3].Value = model.n_bak; parameters[4].Value = model.GID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Cao.WMS.Model.caowms.Goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Goods("); strSql.Append("GID,GName,GPrice,GProvider,n_bak)"); strSql.Append(" values ("); strSql.Append("@GID,@GName,@GPrice,@GProvider,@n_bak)"); SqlParameter[] parameters = { new SqlParameter("@GID", SqlDbType.NVarChar, 50), new SqlParameter("@GName", SqlDbType.NVarChar, 50), new SqlParameter("@GPrice", SqlDbType.Money, 8), new SqlParameter("@GProvider", SqlDbType.NVarChar, 50), new SqlParameter("@n_bak", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.GID; parameters[1].Value = model.GName; parameters[2].Value = model.GPrice; parameters[3].Value = model.GProvider; parameters[4].Value = model.n_bak; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Cao.WMS.Model.caowms.Goods DataRowToModel(DataRow row) { Cao.WMS.Model.caowms.Goods model = new Cao.WMS.Model.caowms.Goods(); if (row != null) { if (row["GID"] != null) { model.GID = row["GID"].ToString(); } if (row["GName"] != null) { model.GName = row["GName"].ToString(); } if (row["GPrice"] != null && row["GPrice"].ToString() != "") { model.GPrice = decimal.Parse(row["GPrice"].ToString()); } if (row["GProvider"] != null) { model.GProvider = row["GProvider"].ToString(); } if (row["n_bak"] != null) { model.n_bak = row["n_bak"].ToString(); } } return(model); }
private void ShowInfo(string GID) { Cao.WMS.BLL.caowms.Goods bll = new Cao.WMS.BLL.caowms.Goods(); Cao.WMS.Model.caowms.Goods model = bll.GetModel(GID); this.lblGID.Text = model.GID; this.lblGName.Text = model.GName; this.lblGPrice.Text = model.GPrice.ToString(); this.lblGProvider.Text = model.GProvider; this.lbln_bak.Text = model.n_bak; }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtGID.Text.Trim().Length == 0) { strErr += "GID不能为空!\\n"; } if (this.txtGName.Text.Trim().Length == 0) { strErr += "SKU不能为空!\\n"; } if (!PageValidate.IsDecimal(txtGPrice.Text)) { strErr += "单价格式错误!\\n"; } if (this.txtGProvider.Text.Trim().Length == 0) { strErr += "供应商不能为空!\\n"; } if (this.txtn_bak.Text.Trim().Length == 0) { strErr += "n_bak不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string GID = this.txtGID.Text; string GName = this.txtGName.Text; decimal GPrice = decimal.Parse(this.txtGPrice.Text); string GProvider = this.txtGProvider.Text; string n_bak = this.txtn_bak.Text; Cao.WMS.Model.caowms.Goods model = new Cao.WMS.Model.caowms.Goods(); model.GID = GID; model.GName = GName; model.GPrice = GPrice; model.GProvider = GProvider; model.n_bak = n_bak; Cao.WMS.BLL.caowms.Goods bll = new Cao.WMS.BLL.caowms.Goods(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 新增商品sku /// </summary> public void addGoods() { bool addGoods = true; Cao.WMS.BLL.caowms.Goods bllgoods = new Cao.WMS.BLL.caowms.Goods(); addGoods = bllgoods.Exists(this.txtRGID.Text.Trim()); if (!addGoods) { Cao.WMS.Model.caowms.Goods modelgoods = new Cao.WMS.Model.caowms.Goods(); modelgoods.GID = this.txtRGID.Text.Trim(); modelgoods.GName = ""; modelgoods.GPrice = 0; modelgoods.GProvider = ""; modelgoods.n_bak = "入库新增SKU"; bllgoods.Add(modelgoods); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Cao.WMS.Model.caowms.Goods GetModel(string GID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 GID,GName,GPrice,GProvider,n_bak from Goods "); strSql.Append(" where GID=@GID "); SqlParameter[] parameters = { new SqlParameter("@GID", SqlDbType.NVarChar, 50) }; parameters[0].Value = GID; Cao.WMS.Model.caowms.Goods model = new Cao.WMS.Model.caowms.Goods(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }