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");
}
}
object IApplicationResourseService.Get(int type, int arid, int riid)
{
ApplicationResourseInfo item = null;
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@ARType", type),
new SqlParameter("@RIID", riid),
new SqlParameter("@ARID", arid)
};
using (SqlDataReader reader = DBHelper.ExecuteReaderProc(GET_APPLICATIONRESOURCE, parms))
{
if (reader.Read())
{
if (type == 1)
{
item = new ApplicationResourseInfo((BorrowApplication)bas.Get(reader.GetInt32(0)), reader.GetInt32(1), (ResourceInfo)rs.Get(reader.GetInt32(2)), reader.GetInt32(3));
}
else if (type == 2)
{
item = new ApplicationResourseInfo((StockApplication)sas.Get(reader.GetInt32(0)), reader.GetInt32(1), (ResourceInfo)rs.Get(reader.GetInt32(2)), reader.GetInt32(3));
}
else
{
item = null;
}
}
}
return(item);
}
IList <ApplicationResourseInfo> IApplicationResourseService.Search(ApplicationResourseInfo item)
{
List <ApplicationResourseInfo> items = new List <ApplicationResourseInfo>();
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@ARType", item.ARType),
new SqlParameter("@RIID", item.Resource.RIID),
new SqlParameter("@Number", item.Number),
new SqlParameter("@ARID", item.ARType == 1?item.Borrow.BAID:item.Stock.SAID)
};
using (SqlDataReader reader = DBHelper.ExecuteReaderProc(SEARCH_APPLICATIONRESOURCE, parms))
{
while (reader.Read())
{
ApplicationResourseInfo val = null;
if (item.ARType == 1)
{
val = new ApplicationResourseInfo((BorrowApplication)bas.Get(reader.GetInt32(0)), reader.GetInt32(1), (ResourceInfo)rs.Get(reader.GetInt32(2)), reader.GetInt32(3));
}
else if (item.ARType == 2)
{
val = new ApplicationResourseInfo((StockApplication)sas.Get(reader.GetInt32(0)), reader.GetInt32(1), (ResourceInfo)rs.Get(reader.GetInt32(2)), reader.GetInt32(3));
}
else
{
return(null);
}
items.Add(val);
}
}
return(items);
}
public static ApplicationResourseInfo GetApplicationResourse(int arid, int riid)
{
ApplicationResourseInfo item = new ApplicationResourseInfo();
item.ARType = 1;
item.Borrow.BAID = arid;
item.Resource.RIID = riid;
return((ApplicationResourseInfo)(ars.Search(item))[0]);
}
public static IList <ApplicationResourseInfo> GetAllApplicationResource(int type, int id)
{
ApplicationResourseInfo item = new ApplicationResourseInfo();
item.ARType = type;
if (type == 1)
{
item.Borrow.BAID = id;
}
if (type == 2)
{
item.Stock.SAID = id;
}
return(ars.Search(item));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (IsValid)
{
UserInfo user = new UserInfo();
if (Session["user"] != null)
{
user = (UserInfo)Session["user"];
}
else
{
Response.Redirect("../login.aspx");
return;
}
if (ApplicationResources.GetItems.Count == 0)
{
this.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('你还没有选择资源！')</script>");
return;
}
else
{
StockApplication stock = new StockApplication();
stock.User.UID = user.UID;
stock.SATime = this.txtSATime.Value.Trim();
stock.NeedCharge = Convert.ToDouble(this.txtNeedCharge.Text.Trim());
stock.SACause = this.txtSACause.Text.Trim();
stock.SARemark = this.txtMark.Text.Trim();
stock.IsExamine = "待办";
//borrow.User.UID = ((UserInfo)Session["user"]).UID/*1*/;
//borrow.BATime = this.txtBorrowTime.Value.Trim();
//borrow.BAType = Convert.ToInt32(this.ddlType.SelectedValue);
//borrow.ExigentGrade = this.txtExigentGrade.Text.Trim();
//borrow.BARemark = this.txtMark.Text.Trim();
//borrow.IsExamine = "未审批";
int id = StockApplicationManager.Add(stock);
stock.SAID = id;
Hashtable list = ApplicationResources.GetItems;
foreach (int str in list.Keys)
{
ApplicationResourseInfo item = (ApplicationResourseInfo)list[str];
item.Stock = stock;
ApplicationResourceManager.add(item);
}
list.Clear();
Response.Redirect("ApplyStockList.aspx");
}
}
}
int IDAL.IBaseFace.Update(object obj)
{
int val = 0;
if (obj is ApplicationResourseInfo)
{
ApplicationResourseInfo item = (ApplicationResourseInfo)obj;
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@ARType", item.ARType),
new SqlParameter("@RIID", item.Resource.RIID),
new SqlParameter("@Number", item.Number),
new SqlParameter("@ARID", item.ARType == 1?item.Borrow.BAID:item.Stock.SAID)
};
val = DBHelper.ExecuteNonQueryProc(UPDATE_APPLICATIONRESOURCE, parms);
}
return(val);
}
IList <ApplicationResourseInfo> IApplicationResourseService.SearchByResourceNameAndBorrowType(string resourceName, int borrowType)
{
IList <ApplicationResourseInfo> items = new List <ApplicationResourseInfo>();
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@ResourceName", resourceName),
new SqlParameter("@BorrowType", borrowType)
};
using (SqlDataReader reader = DBHelper.ExecuteReaderProc(SEARCH_APPLICATIONRESOURCE_BY_RESOURCENAME_AND_BORROWTYPE, parms))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.Name = reader.GetString(3);
ApplicationResourseInfo item = new ApplicationResourseInfo(new BorrowApplication(reader.GetInt32(0), user, reader.GetDateTime(2).ToString(), 0, "", "", ""), 1, new ResourceInfo(reader.GetInt32(5), reader.GetString(1), new ResourceType(), new ResourceStore(), new ProviderInfo(), 0, 0, "", "", 0, ""), reader.GetInt32(4));
items.Add(item);
}
}
return(items);
}
public static int add(ApplicationResourseInfo item)
{
return(ars.Add(item));
}
