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