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