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);
}
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 <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);
}
public static BorrowApplication Get(int id)
{
return((BorrowApplication)borrowService.Get(id));
}
