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