public Core.Business.StimulationCriterionAnswer GetAnseerByQuest(Guid Quaguid,Guid appId) { SqlServerUtility sql = new SqlServerUtility(); string sqlstr = "SELECT * FROM [dbo].[StimulationCriterionAnswer] where QuestionID='" + Quaguid + "' and [ApplicationId]='" + appId + "' "; SqlDataReader reader = sql.ExecuteSqlReader(sqlstr); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.StimulationCriterionAnswer stimulationCriterionAnswer = new Core.Business.StimulationCriterionAnswer(); if (!reader.IsDBNull(0)) stimulationCriterionAnswer.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) stimulationCriterionAnswer.QuestionID = reader.GetGuid(1); if (!reader.IsDBNull(2)) stimulationCriterionAnswer.Credit = reader.GetInt32(2); if (!reader.IsDBNull(3)) stimulationCriterionAnswer.ApplicationId = reader.GetGuid(3); if (!reader.IsDBNull(4)) stimulationCriterionAnswer.ExpertID = reader.GetGuid(4); if (!reader.IsDBNull(5)) stimulationCriterionAnswer.Content = reader.GetString(5); reader.Close(); stimulationCriterionAnswer.MarkOld(); return stimulationCriterionAnswer; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Core.Business.StimulationCriterionAnswer> GetAllStimulationCriterionAnswer() { IList<Core.Business.StimulationCriterionAnswer> stimulationCriterionAnswerlist = new List<Core.Business.StimulationCriterionAnswer>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectStimulationCriterionAnswersAll"); if(reader != null) { while(reader.Read()) { Core.Business.StimulationCriterionAnswer stimulationCriterionAnswer = new Core.Business.StimulationCriterionAnswer(); if (!reader.IsDBNull(0)) stimulationCriterionAnswer.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) stimulationCriterionAnswer.QuestionID = reader.GetGuid(1); if (!reader.IsDBNull(2)) stimulationCriterionAnswer.Credit = reader.GetInt32(2); if (!reader.IsDBNull(3)) stimulationCriterionAnswer.ApplicationId = reader.GetGuid(3); if (!reader.IsDBNull(4)) stimulationCriterionAnswer.ExpertID = reader.GetGuid(4); if (!reader.IsDBNull(5)) stimulationCriterionAnswer.Content = reader.GetString(5); stimulationCriterionAnswer.MarkOld(); stimulationCriterionAnswerlist.Add(stimulationCriterionAnswer); } reader.Close(); } return stimulationCriterionAnswerlist; }
public IList<Core.Business.StimulationCriterionAnswer> SelectStimulationCriterionAnswerDynamic(string whereCondition, string orderByExpression) { IList<Core.Business.StimulationCriterionAnswer> stimulationCriterionAnswerlist = new List<Core.Business.StimulationCriterionAnswer>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@WhereCondition", SqlDbType.NVarChar, whereCondition); sql.AddParameter("@OrderByExpression", SqlDbType.NVarChar, orderByExpression); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectStimulationCriterionAnswersDynamic"); if (reader != null) { while (reader.Read()) { Core.Business.StimulationCriterionAnswer stimulationCriterionAnswer = new Core.Business.StimulationCriterionAnswer(); if (!reader.IsDBNull(0)) stimulationCriterionAnswer.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) stimulationCriterionAnswer.QuestionID = reader.GetGuid(1); if (!reader.IsDBNull(2)) stimulationCriterionAnswer.Credit = reader.GetInt32(2); if (!reader.IsDBNull(3)) stimulationCriterionAnswer.ApplicationId = reader.GetGuid(3); if (!reader.IsDBNull(4)) stimulationCriterionAnswer.ExpertID = reader.GetGuid(4); if (!reader.IsDBNull(5)) stimulationCriterionAnswer.Content = reader.GetString(5); stimulationCriterionAnswer.MarkOld(); stimulationCriterionAnswerlist.Add(stimulationCriterionAnswer); } reader.Close(); } return stimulationCriterionAnswerlist; }
public Core.Business.StimulationCriterionAnswer Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectStimulationCriterionAnswer"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.StimulationCriterionAnswer stimulationCriterionAnswer = new Core.Business.StimulationCriterionAnswer(); if (!reader.IsDBNull(0)) stimulationCriterionAnswer.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) stimulationCriterionAnswer.QuestionID = reader.GetGuid(1); if (!reader.IsDBNull(2)) stimulationCriterionAnswer.Credit = reader.GetInt32(2); if (!reader.IsDBNull(3)) stimulationCriterionAnswer.ApplicationId = reader.GetGuid(3); if (!reader.IsDBNull(4)) stimulationCriterionAnswer.ExpertID = reader.GetGuid(4); if (!reader.IsDBNull(5)) stimulationCriterionAnswer.Content = reader.GetString(5); reader.Close(); return stimulationCriterionAnswer; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }