public IList<Core.Business.CommissionedCompletionRecord> GetAllCommissionedCompletionRecord() { IList<Core.Business.CommissionedCompletionRecord> commissionedCompletionRecordlist = new List<Core.Business.CommissionedCompletionRecord>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectCommissionedCompletionRecordsAll"); if (reader != null) { while (reader.Read()) { Core.Business.CommissionedCompletionRecord commissionedCompletionRecord = new Core.Business.CommissionedCompletionRecord(); if (!reader.IsDBNull(0)) commissionedCompletionRecord.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) commissionedCompletionRecord.ApplicationID = reader.GetGuid(1); if (!reader.IsDBNull(2)) commissionedCompletionRecord.FillPerson = reader.GetGuid(2); if (!reader.IsDBNull(3)) commissionedCompletionRecord.AchieveTime = reader.GetDateTime(3); if (!reader.IsDBNull(4)) commissionedCompletionRecord.SamplesNub = reader.GetDouble(4); if (!reader.IsDBNull(5)) commissionedCompletionRecord.MachineTime = reader.GetDouble(5); if (!reader.IsDBNull(6)) commissionedCompletionRecord.Charges = reader.GetString(6); if (!reader.IsDBNull(7)) commissionedCompletionRecord.FeesReceivable = reader.GetString(7); if (!reader.IsDBNull(8)) commissionedCompletionRecord.ActualCharges = reader.GetString(8); if (!reader.IsDBNull(9)) commissionedCompletionRecord.Units = reader.GetGuid(9); if (!reader.IsDBNull(10)) commissionedCompletionRecord.FillTime = reader.GetDateTime(10); commissionedCompletionRecord.MarkOld(); commissionedCompletionRecordlist.Add(commissionedCompletionRecord); } reader.Close(); } return commissionedCompletionRecordlist; }
public Core.Business.CommissionedCompletionRecord Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectCommissionedCompletionRecord"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.CommissionedCompletionRecord commissionedCompletionRecord = new Core.Business.CommissionedCompletionRecord(); if (!reader.IsDBNull(0)) commissionedCompletionRecord.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) commissionedCompletionRecord.ApplicationID = reader.GetGuid(1); if (!reader.IsDBNull(2)) commissionedCompletionRecord.FillPerson = reader.GetGuid(2); if (!reader.IsDBNull(3)) commissionedCompletionRecord.AchieveTime = reader.GetDateTime(3); if (!reader.IsDBNull(4)) commissionedCompletionRecord.SamplesNub = reader.GetDouble(4); if (!reader.IsDBNull(5)) commissionedCompletionRecord.MachineTime = reader.GetDouble(5); if (!reader.IsDBNull(6)) commissionedCompletionRecord.Charges = reader.GetString(6); if (!reader.IsDBNull(7)) commissionedCompletionRecord.FeesReceivable = reader.GetString(7); if (!reader.IsDBNull(8)) commissionedCompletionRecord.ActualCharges = reader.GetString(8); if (!reader.IsDBNull(9)) commissionedCompletionRecord.Units = reader.GetGuid(9); if (!reader.IsDBNull(10)) commissionedCompletionRecord.FillTime = reader.GetDateTime(10); reader.Close(); return commissionedCompletionRecord; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public List<CommissionedCompletionRecord> SelectCommissionedCompletionRecordByDynamic(string whereCondition, string orderExperssion) { List<Core.Business.CommissionedCompletionRecord> commissionedCompletionRecordlist = new List<Core.Business.CommissionedCompletionRecord>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@WhereCondition", SqlDbType.NVarChar, whereCondition); sql.AddParameter("@OrderByExpression", SqlDbType.NVarChar, orderExperssion); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectCommissionedCompletionRecordsDynamic"); if (reader != null && !reader.IsClosed) { while (reader.Read()) { Core.Business.CommissionedCompletionRecord commissionedCompletionRecord = new Core.Business.CommissionedCompletionRecord(); if (!reader.IsDBNull(0)) commissionedCompletionRecord.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) commissionedCompletionRecord.ApplicationID = reader.GetGuid(1); if (!reader.IsDBNull(2)) commissionedCompletionRecord.FillPerson = reader.GetGuid(2); if (!reader.IsDBNull(3)) commissionedCompletionRecord.AchieveTime = reader.GetDateTime(3); if (!reader.IsDBNull(4)) commissionedCompletionRecord.SamplesNub = reader.GetDouble(4); if (!reader.IsDBNull(5)) commissionedCompletionRecord.MachineTime = reader.GetDouble(5); if (!reader.IsDBNull(6)) commissionedCompletionRecord.Charges = reader.GetString(6); if (!reader.IsDBNull(7)) commissionedCompletionRecord.FeesReceivable = reader.GetString(7); if (!reader.IsDBNull(8)) commissionedCompletionRecord.ActualCharges = reader.GetString(8); if (!reader.IsDBNull(9)) commissionedCompletionRecord.Units = reader.GetGuid(9); if (!reader.IsDBNull(10)) commissionedCompletionRecord.FillTime = reader.GetDateTime(10); commissionedCompletionRecord.MarkOld(); commissionedCompletionRecordlist.Add(commissionedCompletionRecord); } reader.Close(); } return commissionedCompletionRecordlist; }