public IList<Core.Business.CommissionedApplication> GetAllCommissionedApplication() { IList<Core.Business.CommissionedApplication> commissionedApplicationlist = new List<Core.Business.CommissionedApplication>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectCommissionedApplicationsAll"); if (reader != null) { while (reader.Read()) { Core.Business.CommissionedApplication commissionedApplication = new Core.Business.CommissionedApplication(); if (!reader.IsDBNull(0)) commissionedApplication.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) commissionedApplication.CommissionedUint = reader.GetString(1); if (!reader.IsDBNull(2)) commissionedApplication.AdmissibilityID = reader.GetGuid(2); if (!reader.IsDBNull(3)) commissionedApplication.InstrumentID = reader.GetGuid(3); if (!reader.IsDBNull(4)) commissionedApplication.Address = reader.GetString(4); if (!reader.IsDBNull(5)) commissionedApplication.Zip = reader.GetString(5); if (!reader.IsDBNull(6)) commissionedApplication.CommissionedPerson = reader.GetGuid(6); if (!reader.IsDBNull(7)) commissionedApplication.Phone = reader.GetString(7); if (!reader.IsDBNull(8)) commissionedApplication.ProjectName = reader.GetString(8); if (!reader.IsDBNull(9)) commissionedApplication.Fax = reader.GetString(9); if (!reader.IsDBNull(10)) commissionedApplication.ProjectContractNo = reader.GetString(10); if (!reader.IsDBNull(11)) commissionedApplication.ProjectLeader = reader.GetString(11); if (!reader.IsDBNull(12)) commissionedApplication.ProjectType = reader.GetGuid(12); if (!reader.IsDBNull(13)) commissionedApplication.ContenAndRequirements = reader.GetString(13); if (!reader.IsDBNull(14)) commissionedApplication.Status = reader.GetInt32(14); if (!reader.IsDBNull(15)) commissionedApplication.AdmissibilityDes = reader.GetString(15); if (!reader.IsDBNull(16)) commissionedApplication.Feedback = reader.GetInt32(16); if (!reader.IsDBNull(17)) commissionedApplication.Advice = reader.GetString(17); if (!reader.IsDBNull(18)) commissionedApplication.AdviceFillTime = reader.GetDateTime(18); if (!reader.IsDBNull(19)) commissionedApplication.ApplicateTime = reader.GetDateTime(19); commissionedApplication.MarkOld(); commissionedApplicationlist.Add(commissionedApplication); } reader.Close(); } return commissionedApplicationlist; }
public IEnumerable<CommissionedApplication> GetCommissionApplications(Guid instrumentId) { try { IList<Core.Business.CommissionedApplication> commissionedApplicationlist = new List<Core.Business.CommissionedApplication>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@instrument", SqlDbType.UniqueIdentifier, instrumentId); SqlDataReader reader = sql.ExecuteSqlReader(Sql_GetCommissionApplications); if (reader != null) { while (reader.Read()) { Core.Business.CommissionedApplication commissionedApplication = new Core.Business.CommissionedApplication(); if (!reader.IsDBNull(0)) commissionedApplication.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) commissionedApplication.CommissionedUint = reader.GetString(1); if (!reader.IsDBNull(2)) commissionedApplication.AdmissibilityID = reader.GetGuid(2); if (!reader.IsDBNull(3)) commissionedApplication.InstrumentID = reader.GetGuid(3); if (!reader.IsDBNull(4)) commissionedApplication.Address = reader.GetString(4); if (!reader.IsDBNull(5)) commissionedApplication.Zip = reader.GetString(5); if (!reader.IsDBNull(6)) commissionedApplication.CommissionedPerson = reader.GetGuid(6); if (!reader.IsDBNull(7)) commissionedApplication.Phone = reader.GetString(7); if (!reader.IsDBNull(8)) commissionedApplication.ProjectName = reader.GetString(8); if (!reader.IsDBNull(9)) commissionedApplication.Fax = reader.GetString(9); if (!reader.IsDBNull(10)) commissionedApplication.ProjectContractNo = reader.GetString(10); if (!reader.IsDBNull(11)) commissionedApplication.ProjectLeader = reader.GetString(11); if (!reader.IsDBNull(12)) commissionedApplication.ProjectType = reader.GetGuid(12); if (!reader.IsDBNull(13)) commissionedApplication.ContenAndRequirements = reader.GetString(13); if (!reader.IsDBNull(14)) commissionedApplication.Status = reader.GetInt32(14); if (!reader.IsDBNull(15)) commissionedApplication.AdmissibilityDes = reader.GetString(15); if (!reader.IsDBNull(16)) commissionedApplication.Feedback = reader.GetInt32(16); if (!reader.IsDBNull(17)) commissionedApplication.Advice = reader.GetString(17); if (!reader.IsDBNull(18)) commissionedApplication.AdviceFillTime = reader.GetDateTime(18); if (!reader.IsDBNull(19)) commissionedApplication.ApplicateTime = reader.GetDateTime(19); commissionedApplication.MarkOld(); commissionedApplicationlist.Add(commissionedApplication); } reader.Close(); } return commissionedApplicationlist; } catch (Exception ex) { throw ex; } }
public IList<Core.Business.CommissionedApplication> GetAllCommissionedGroup() { IList<Core.Business.CommissionedApplication> commissionedApplicationlist = new List<Core.Business.CommissionedApplication>(); SqlServerUtility sql = new SqlServerUtility(); string sqlwhere = "SELECT TOP 5 COUNT([InstrumentID]) AS A,[InstrumentID] FROM [dbo].[CommissionedApplication] GROUP BY [InstrumentID] ORDER BY A DESC"; SqlDataReader reader = sql.ExecuteSqlReader(sqlwhere); if (reader != null) { while (reader.Read()) { Core.Business.CommissionedApplication commissionedApplication = new Core.Business.CommissionedApplication(); if (!reader.IsDBNull(0)) commissionedApplication.InstrumentID = reader.GetGuid(1); if (!reader.IsDBNull(1)) commissionedApplication.Status = reader.GetInt32(0); commissionedApplication.MarkOld(); commissionedApplicationlist.Add(commissionedApplication); } reader.Close(); } return commissionedApplicationlist; }
public Core.Business.CommissionedApplication Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectCommissionedApplication"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.CommissionedApplication commissionedApplication = new Core.Business.CommissionedApplication(); if (!reader.IsDBNull(0)) commissionedApplication.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) commissionedApplication.CommissionedUint = reader.GetString(1); if (!reader.IsDBNull(2)) commissionedApplication.AdmissibilityID = reader.GetGuid(2); if (!reader.IsDBNull(3)) commissionedApplication.InstrumentID = reader.GetGuid(3); if (!reader.IsDBNull(4)) commissionedApplication.Address = reader.GetString(4); if (!reader.IsDBNull(5)) commissionedApplication.Zip = reader.GetString(5); if (!reader.IsDBNull(6)) commissionedApplication.CommissionedPerson = reader.GetGuid(6); if (!reader.IsDBNull(7)) commissionedApplication.Phone = reader.GetString(7); if (!reader.IsDBNull(8)) commissionedApplication.ProjectName = reader.GetString(8); if (!reader.IsDBNull(9)) commissionedApplication.Fax = reader.GetString(9); if (!reader.IsDBNull(10)) commissionedApplication.ProjectContractNo = reader.GetString(10); if (!reader.IsDBNull(11)) commissionedApplication.ProjectLeader = reader.GetString(11); if (!reader.IsDBNull(12)) commissionedApplication.ProjectType = reader.GetGuid(12); if (!reader.IsDBNull(13)) commissionedApplication.ContenAndRequirements = reader.GetString(13); if (!reader.IsDBNull(14)) commissionedApplication.Status = reader.GetInt32(14); if (!reader.IsDBNull(15)) commissionedApplication.AdmissibilityDes = reader.GetString(15); if (!reader.IsDBNull(16)) commissionedApplication.Feedback = reader.GetInt32(16); if (!reader.IsDBNull(17)) commissionedApplication.Advice = reader.GetString(17); if (!reader.IsDBNull(18)) commissionedApplication.AdviceFillTime = reader.GetDateTime(18); if (!reader.IsDBNull(19)) commissionedApplication.ApplicateTime = reader.GetDateTime(19); reader.Close(); return commissionedApplication; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }