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