public int Insert(Instore 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_InStore",ps);
return num;
}
protected void btnAdd_OnClick(object sender, EventArgs e)
{
var instore = new Instore();
instore.gno = this.gno.SelectedValue.ToString();
instore.stno = this.stno.SelectedValue;
instore.number = Convert.ToInt16(txtNumber.Text.Trim());
instore.mno = Session["mno"].ToString();
DateTime nowTime = DateTime.Now;
int num = bllinstore.Insert(instore);
if (num > 0)
{
Response.Write("<script>alert('入库成功');window.location.href='InventList.aspx';</script>");
}
else
{
Response.Write("<script>alter('入库失败');</script>");
}
//string mno = // 缺登录功能，在登录成功时候保存当前登录者信息
//往入库表中插入入库记录 缺入库表的模型层、数据访问层（添加、修改（权限） 删除不能开、查询需要些）、业务逻辑层
//入库成功需要往库存表中写输入数据
}
/// <summary>
/// 添加入库信息
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
public int Insert(Instore instore)
{
return(bllinstore.Insert(instore));
}
