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"); } }
IList <SpoilageRegister> ISpoilageRegisterService.GetAllSpoilageRegister(SpoilageRegister item) { IList <SpoilageRegister> items = new List <SpoilageRegister>(); SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@BAID", item.Borrow.BAID), new SqlParameter("@RIID", item.Resourse.RIID), new SqlParameter("@UID", item.User.UID), new SqlParameter("@SRNo", item.SRNo), new SqlParameter("@SRGrade", item.SRGrade), new SqlParameter("@SRTime", item.SRTime), new SqlParameter("@SRCause", item.SRCause), new SqlParameter("@SRRmark", item.SRRemark), new SqlParameter("@SRID", item.SRID) }; using (SqlDataReader sdr = DBHelper.ExecuteReaderProc(SEARCH_SPOILAGEREGISTER, parms)) { while (sdr.Read()) { SpoilageRegister val = new SpoilageRegister(sdr.GetInt32(0), (BorrowApplication)bas.Get(sdr.GetInt32(1)), (ResourceInfo)rs.Get(sdr.GetInt32(2)), (UserInfo)us.GetAllUserById(sdr.GetInt32(3)), sdr.GetInt32(4), sdr.GetString(5), sdr.GetDateTime(6).ToString(), sdr.GetString(7), sdr.GetString(8)); items.Add(val); } } return(items); }
object IBaseFace.Get(int id) { SpoilageRegister item = null; using (SqlDataReader sdr = DBHelper.ExecuteReaderProc(GET_SPOILAGEREGISTER, new SqlParameter("@SRID", id))) { if (sdr.Read()) { item = new SpoilageRegister(sdr.GetInt32(0), (BorrowApplication)bas.Get(sdr.GetInt32(1)), (ResourceInfo)rs.Get(sdr.GetInt32(2)), (UserInfo)us.GetAllUserById(sdr.GetInt32(3)), sdr.GetInt32(4), sdr.GetString(5), sdr.GetDateTime(6).ToString(), sdr.GetString(7), sdr.GetString(8)); } } return(item); }
int IBaseFace.Add(object obj) { int val = 0; if (obj is SpoilageRegister) { SpoilageRegister item = (SpoilageRegister)obj; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@BAID", item.Borrow.BAID), new SqlParameter("@RIID", item.Resourse.RIID), new SqlParameter("@UID", item.User.UID), new SqlParameter("@SRNo", item.SRNo), new SqlParameter("@SRGrade", item.SRGrade), new SqlParameter("@SRTime", item.SRTime), new SqlParameter("@SRCause", item.SRCause), new SqlParameter("@SRRmark", item.SRRemark) }; val = DBHelper.ExecuteNonQueryProc(ADD_SPOILAGEREGISTER, parms); } return(val); }
public static int Add(SpoilageRegister item) { return(srs.Add(item)); }