public IList<Core.Business.AcquisitionMission> GetAllAcquisitionMission() { IList<Core.Business.AcquisitionMission> acquisitionMissionlist = new List<Core.Business.AcquisitionMission>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectAcquisitionMissionsAll"); if(reader != null) { while(reader.Read()) { Core.Business.AcquisitionMission acquisitionMission = new Core.Business.AcquisitionMission(); if (!reader.IsDBNull(0)) acquisitionMission.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) acquisitionMission.Name = reader.GetString(1); if (!reader.IsDBNull(2)) acquisitionMission.ModuleID = reader.GetGuid(2); if (!reader.IsDBNull(3)) acquisitionMission.RulesTitleStart = reader.GetString(3); if (!reader.IsDBNull(4)) acquisitionMission.RulesTitleEnd = reader.GetString(4); if (!reader.IsDBNull(5)) acquisitionMission.RulesContentStart = reader.GetString(5); if (!reader.IsDBNull(6)) acquisitionMission.RulesContentEnd = reader.GetString(6); if (!reader.IsDBNull(7)) acquisitionMission.RulesLinkStart = reader.GetString(7); if (!reader.IsDBNull(8)) acquisitionMission.RulesLinkEnd = reader.GetString(8); if (!reader.IsDBNull(9)) acquisitionMission.RuleListStart = reader.GetString(9); if (!reader.IsDBNull(10)) acquisitionMission.RuleListEnd = reader.GetString(10); if (!reader.IsDBNull(11)) acquisitionMission.AcquisitionHour = reader.GetInt32(11); if (!reader.IsDBNull(12)) acquisitionMission.AcquisitionMinute = reader.GetInt32(12); if (!reader.IsDBNull(13)) acquisitionMission.AddTime = reader.GetDateTime(13); if (!reader.IsDBNull(14)) acquisitionMission.AcquisitionSiteName = reader.GetString(14); if (!reader.IsDBNull(15)) acquisitionMission.AcquisitionSiteURL = reader.GetString(15); if (!reader.IsDBNull(16)) acquisitionMission.Status = reader.GetInt32(16); if (!reader.IsDBNull(17)) acquisitionMission.WebEncode = reader.GetString(17); if (!reader.IsDBNull(18)) acquisitionMission.ContentKeyWord = reader.GetString(18); acquisitionMission.MarkOld(); acquisitionMissionlist.Add(acquisitionMission); } reader.Close(); } return acquisitionMissionlist; }
public Core.Business.AcquisitionMission Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@ID", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectAcquisitionMission"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.AcquisitionMission acquisitionMission = new Core.Business.AcquisitionMission(); if (!reader.IsDBNull(0)) acquisitionMission.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) acquisitionMission.Name = reader.GetString(1); if (!reader.IsDBNull(2)) acquisitionMission.ModuleID = reader.GetGuid(2); if (!reader.IsDBNull(3)) acquisitionMission.RulesTitleStart = reader.GetString(3); if (!reader.IsDBNull(4)) acquisitionMission.RulesTitleEnd = reader.GetString(4); if (!reader.IsDBNull(5)) acquisitionMission.RulesContentStart = reader.GetString(5); if (!reader.IsDBNull(6)) acquisitionMission.RulesContentEnd = reader.GetString(6); if (!reader.IsDBNull(7)) acquisitionMission.RulesLinkStart = reader.GetString(7); if (!reader.IsDBNull(8)) acquisitionMission.RulesLinkEnd = reader.GetString(8); if (!reader.IsDBNull(9)) acquisitionMission.RuleListStart = reader.GetString(9); if (!reader.IsDBNull(10)) acquisitionMission.RuleListEnd = reader.GetString(10); if (!reader.IsDBNull(11)) acquisitionMission.AcquisitionHour = reader.GetInt32(11); if (!reader.IsDBNull(12)) acquisitionMission.AcquisitionMinute = reader.GetInt32(12); if (!reader.IsDBNull(13)) acquisitionMission.AddTime = reader.GetDateTime(13); if (!reader.IsDBNull(14)) acquisitionMission.AcquisitionSiteName = reader.GetString(14); if (!reader.IsDBNull(15)) acquisitionMission.AcquisitionSiteURL = reader.GetString(15); if (!reader.IsDBNull(16)) acquisitionMission.Status = reader.GetInt32(16); if (!reader.IsDBNull(17)) acquisitionMission.WebEncode = reader.GetString(17); if (!reader.IsDBNull(18)) acquisitionMission.ContentKeyWord = reader.GetString(18); reader.Close(); return acquisitionMission; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }