public IList<Core.Business.StimulationAppliction> GetAllStimulationAppliction() { IList<Core.Business.StimulationAppliction> stimulationApplictionlist = new List<Core.Business.StimulationAppliction>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectStimulationApplictionsAll"); if(reader != null) { while(reader.Read()) { Core.Business.StimulationAppliction stimulationAppliction = new Core.Business.StimulationAppliction(); if (!reader.IsDBNull(0)) stimulationAppliction.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) stimulationAppliction.StimulationAndTypeId = reader.GetGuid(1); stimulationAppliction.MarkOld(); stimulationApplictionlist.Add(stimulationAppliction); } reader.Close(); } return stimulationApplictionlist; }
public IList<Core.Business.StimulationAppliction> GetStimuAppListWhere(string SQLWhere, string tableName) { IList<Core.Business.StimulationAppliction> stimulationApplictionlist = new List<Core.Business.StimulationAppliction>(); SqlServerUtility sql = new SqlServerUtility(); string sqlstr = "SELECT [StimulationAppliction].* FROM [dbo].[StimulationAppliction] join " + tableName + " on [StimulationAppliction].Id=" + tableName + ".Id where " + SQLWhere + " order by " + tableName + ".Score desc"; SqlDataReader reader = sql.ExecuteSqlReader(sqlstr); if (reader != null) { while (reader.Read()) { Core.Business.StimulationAppliction stimulationAppliction = new Core.Business.StimulationAppliction(); if (!reader.IsDBNull(0)) stimulationAppliction.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) stimulationAppliction.StimulationAndTypeId = reader.GetGuid(1); stimulationAppliction.MarkOld(); stimulationApplictionlist.Add(stimulationAppliction); } reader.Close(); } return stimulationApplictionlist; }
public IList<Core.Business.StimulationAppliction> GetStimuAppListByTypeId(Guid ID) { IList<Core.Business.StimulationAppliction> stimulationApplictionlist = new List<Core.Business.StimulationAppliction>(); SqlServerUtility sql = new SqlServerUtility(); string sqlstr = "SELECT * FROM [dbo].[StimulationAppliction] where [StimulationAndTypeId]='"+ID+"'"; SqlDataReader reader = sql.ExecuteSqlReader(sqlstr); if (reader != null) { while (reader.Read()) { Core.Business.StimulationAppliction stimulationAppliction = new Core.Business.StimulationAppliction(); if (!reader.IsDBNull(0)) stimulationAppliction.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) stimulationAppliction.StimulationAndTypeId = reader.GetGuid(1); stimulationAppliction.MarkOld(); stimulationApplictionlist.Add(stimulationAppliction); } reader.Close(); } return stimulationApplictionlist; }
public Core.Business.StimulationAppliction GetStimuAppWhere(string SQLWhere) { SqlServerUtility sql = new SqlServerUtility(); string sqlstr = "SELECT * FROM [dbo].[StimulationAppliction] where "; sqlstr += SQLWhere; SqlDataReader reader = sql.ExecuteSqlReader(sqlstr); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.StimulationAppliction stimulationAppliction = new Core.Business.StimulationAppliction(); if (!reader.IsDBNull(0)) stimulationAppliction.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) stimulationAppliction.StimulationAndTypeId = reader.GetGuid(1); reader.Close(); stimulationAppliction.MarkOld(); return stimulationAppliction; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public Core.Business.StimulationAppliction Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@ID", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectStimulationAppliction"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.StimulationAppliction stimulationAppliction = new Core.Business.StimulationAppliction(); if (!reader.IsDBNull(0)) stimulationAppliction.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) stimulationAppliction.StimulationAndTypeId = reader.GetGuid(1); reader.Close(); return stimulationAppliction; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }