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