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