public IList<Core.Business.View_stimulationapply> GetAllView_stimulationapply()
{
IList<Core.Business.View_stimulationapply> view_stimulationapplylist = new List<Core.Business.View_stimulationapply>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectView_stimulationapplysAll");
if (reader != null)
{
while (reader.Read())
{
Core.Business.View_stimulationapply view_stimulationapply = new Core.Business.View_stimulationapply();
if (!reader.IsDBNull(0)) view_stimulationapply.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) view_stimulationapply.TypeId = reader.GetGuid(1);
if (!reader.IsDBNull(2)) view_stimulationapply.MemberId = reader.GetGuid(2);
if (!reader.IsDBNull(3)) view_stimulationapply.FieldType = reader.GetInt32(3);
if (!reader.IsDBNull(4)) view_stimulationapply.StimulationContentType = reader.GetInt32(4);
if (!reader.IsDBNull(5)) view_stimulationapply.DraftWriter = reader.GetString(5);
if (!reader.IsDBNull(6)) view_stimulationapply.DetailWriter = reader.GetString(6);
if (!reader.IsDBNull(7)) view_stimulationapply.FillDate = reader.GetDateTime(7);
if (!reader.IsDBNull(8)) view_stimulationapply.State = reader.GetInt32(8);
if (!reader.IsDBNull(9)) view_stimulationapply.Hours = reader.GetInt32(9);
if (!reader.IsDBNull(10)) view_stimulationapply.Score = reader.GetInt32(10);
view_stimulationapply.MarkOld();
view_stimulationapplylist.Add(view_stimulationapply);
}
reader.Close();
}
return view_stimulationapplylist;
}
public Core.Business.View_stimulationapply Select(System.Guid id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectView_stimulationapply");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.View_stimulationapply view_stimulationapply = new Core.Business.View_stimulationapply();
if (!reader.IsDBNull(0)) view_stimulationapply.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) view_stimulationapply.TypeId = reader.GetGuid(1);
if (!reader.IsDBNull(2)) view_stimulationapply.MemberId = reader.GetGuid(2);
if (!reader.IsDBNull(3)) view_stimulationapply.FieldType = reader.GetInt32(3);
if (!reader.IsDBNull(4)) view_stimulationapply.StimulationContentType = reader.GetInt32(4);
if (!reader.IsDBNull(5)) view_stimulationapply.DraftWriter = reader.GetString(5);
if (!reader.IsDBNull(6)) view_stimulationapply.DetailWriter = reader.GetString(6);
if (!reader.IsDBNull(7)) view_stimulationapply.FillDate = reader.GetDateTime(7);
if (!reader.IsDBNull(8)) view_stimulationapply.State = reader.GetInt32(8);
if (!reader.IsDBNull(9)) view_stimulationapply.Hours = reader.GetInt32(9);
if (!reader.IsDBNull(10)) view_stimulationapply.Score = reader.GetInt32(10);
reader.Close();
return view_stimulationapply;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public List<View_stimulationapply> SelectStimulationApplyByTypeId(System.Guid typeid)
{
if (typeid == System.Guid.Empty)
return null;
List<Core.Business.View_stimulationapply> view_stimulationapplylist = new List<Core.Business.View_stimulationapply>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@typeid", SqlDbType.UniqueIdentifier, typeid);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectStimulationApplyByTypeId");
if (reader != null)
{
while (reader.Read())
{
Core.Business.View_stimulationapply view_stimulationapply = new Core.Business.View_stimulationapply();
if (!reader.IsDBNull(0)) view_stimulationapply.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) view_stimulationapply.TypeId = reader.GetGuid(1);
if (!reader.IsDBNull(2)) view_stimulationapply.MemberId = reader.GetGuid(2);
if (!reader.IsDBNull(3)) view_stimulationapply.FieldType = reader.GetInt32(3);
if (!reader.IsDBNull(4)) view_stimulationapply.StimulationContentType = reader.GetInt32(4);
if (!reader.IsDBNull(5)) view_stimulationapply.DraftWriter = reader.GetString(5);
if (!reader.IsDBNull(6)) view_stimulationapply.DetailWriter = reader.GetString(6);
if (!reader.IsDBNull(7)) view_stimulationapply.FillDate = reader.GetDateTime(7);
if (!reader.IsDBNull(8)) view_stimulationapply.State = reader.GetInt32(8);
if (!reader.IsDBNull(9)) view_stimulationapply.Hours = reader.GetInt32(9);
if (!reader.IsDBNull(10)) view_stimulationapply.Score = reader.GetInt32(10);
view_stimulationapply.MarkOld();
view_stimulationapplylist.Add(view_stimulationapply);
}
reader.Close();
}
return view_stimulationapplylist;
}
