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