IList <ResourceRestore> IResourceRestoreService.GetAllResourceRestore(ResourceRestore item) { IList <ResourceRestore> items = new List <ResourceRestore>(); SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@BAID", item.Borrow.BAID), new SqlParameter("@RIID", item.Resource.RIID), new SqlParameter("@UID", item.User.UID), new SqlParameter("@RRTime", item.RRTime), new SqlParameter("@RRNumber", item.RRNumber), new SqlParameter("@RRRemark", item.RRRemark), new SqlParameter("@RRID", item.RRID) }; using (SqlDataReader sdr = DBHelper.ExecuteReaderProc(SEARCH_RESOURCERESTORE, parms)) { while (sdr.Read()) { ResourceRestore val = null; val = new ResourceRestore(sdr.GetInt32(0), (BorrowApplication)bas.Get(sdr.GetInt32(1)), (ResourceInfo)ris.Get(sdr.GetInt32(2)), (UserInfo)uis.GetAllUserById(sdr.GetInt32(3)), sdr.GetDateTime(4).ToString(), sdr.GetInt32(5), sdr.GetString(6)); items.Add(val); } } return(items); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (IsValid) { SpoilageRegister item = new SpoilageRegister(); item.Borrow.BAID = Convert.ToInt32(this.txtBorrowNo.Text.Trim()); item.User.UID = Convert.ToInt32(this.hfUID.Value.Trim()); item.Resourse.RIID = Convert.ToInt32(this.ddlName.SelectedValue); item.SRNo = Convert.ToInt32(this.txtPreNum.Text.Trim()); item.SRGrade = this.txtGrade.Text.Trim(); item.SRCause = this.txtCause.Text.Trim(); item.SRTime = txtDrawTime.Value.Trim(); item.SRRemark = txtRemark.Text.Trim(); ApplicationResourseInfo resource = ApplicationResourceManager.GetApplicationResourse(item.Borrow.BAID, item.Resourse.RIID); ResourceRestore restore = ResourceRestoreManager.GetRestoreByBAIDAndRIID(item.Borrow.BAID, item.Resourse.RIID); if (restore != new ResourceRestore() && restore != null) { if (item.SRNo > resource.Number - restore.RRNumber) { ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('您输入损耗数量超出了需要归还的数量!')</script>"); return; } } SpoilageRegisterManager.Add(item); Response.Redirect("UseList.aspx"); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (IsValid) { ResourceRestore restore = new ResourceRestore(); restore.Borrow.BAID = Convert.ToInt32(txtBorrowNo.Text.Trim()); restore.Resource.RIID = Convert.ToInt32(ddlName.SelectedValue); restore.User.UID = Convert.ToInt32(hfUID.Value); restore.RRTime = txtTime.Value.Trim(); restore.RRNumber = Convert.ToInt32(txtRebackNum.Text.Trim()); ApplicationResourseInfo appResource = ApplicationResourceManager.GetApplicationResourse(restore.Borrow.BAID, restore.Resource.RIID); if (restore.RRNumber > appResource.Number) { ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('您的输入归还数量有误!')</script>"); return; } restore.RRRemark = txtMark.Text.Trim(); if (ResourceRestoreManager.Add(restore) != 0) { restore.Resource = ResourceInfoManager.Get(restore.Resource.RIID); restore.Resource.Number += restore.RRNumber; ResourceInfoManager.UpdateResourceInfo(restore.Resource); this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('录入成功!')</script>"); } Response.Redirect("UseList.aspx"); } }
public static ResourceRestore GetRestoreByBAIDAndRIID(int baid, int riid) { ResourceRestore item = new ResourceRestore(); item.Borrow.BAID = baid; item.Resource.RIID = riid; return((ResourceRestore)rrs.GetAllResourceRestore(item)); }
object IBaseFace.Get(int id) { ResourceRestore item = null; using (SqlDataReader sdr = DBHelper.ExecuteReaderProc(GET_RESOURCERESTORE, new SqlParameter("@RRID", id))) { if (sdr.Read()) { item = new ResourceRestore(sdr.GetInt32(0), (BorrowApplication)bas.Get(sdr.GetInt32(1)), (ResourceInfo)ris.Get(sdr.GetInt32(2)), (UserInfo)uis.GetAllUserById(sdr.GetInt32(3)), sdr.GetDateTime(4).ToString(), sdr.GetInt32(5), sdr.GetString(6)); } } return(item); }
int IBaseFace.Add(object obj) { int val = 0; if (obj is ResourceRestore) { ResourceRestore item = (ResourceRestore)obj; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@BAID", item.Borrow.BAID), new SqlParameter("@RIID", item.Resource.RIID), new SqlParameter("@UID", item.User.UID), new SqlParameter("@RRTime", item.RRTime), new SqlParameter("@RRNumber", item.RRNumber), new SqlParameter("@RRRemark", item.RRRemark) }; val = DBHelper.ExecuteNonQueryProc(ADD_RESOURCERESTORE, parms); } return(val); }
public static int Add(ResourceRestore item) { return(rrs.Add(item)); }