/// <summary>
/// 添加出库信息
/// </summary>
/// <param name="instore">出库类型的商品</param>
/// <returns></returns>
public int Insert(Outstore instore)
{
SqlParameter[] ps =
{
new SqlParameter("@gno", SqlDbType.Char, 6)
{
Value = instore.gno
},
new SqlParameter("@stno", SqlDbType.Char, 3)
{
Value = instore.stno
},
new SqlParameter("@number", SqlDbType.Int, 4)
{
Value = instore.number
},
new SqlParameter("@mno", SqlDbType.Char, 6)
{
Value = instore.mno
}
};
int num = DBHelper.ExecuteProc("proc_OutStore", ps);
return(num);
}
protected void btnAdd_OnClick(object sender, EventArgs e)
{
var outstore = new Outstore();
outstore.gno = this.gno.SelectedValue.ToString();
outstore.stno = this.stno.SelectedValue;
outstore.number = Convert.ToInt16(txtNumber.Text.Trim());
outstore.mno = Session["mno"].ToString();
int num = blloutstore.Insert(outstore);
if (num > 0)
{
Response.Write("<script>alert('出库成功');window.location.href='InventList.aspx';</script>");
}
else
{
Response.Write("<script>alter('库存不足，出库失败！');</script>");
}
}
/// <summary>
/// 添加入库信息
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
public int Insert(Outstore outstore)
{
int num = blloutstore.Insert(outstore);
return(num);
}
