public IList<Core.Business.UserAnswer> GetAllUserAnswer() { IList<Core.Business.UserAnswer> userAnswerlist = new List<Core.Business.UserAnswer>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllUserAnswer); if(reader != null) { while(reader.Read()) { Core.Business.UserAnswer userAnswer = new Core.Business.UserAnswer(); if (!reader.IsDBNull(0)) userAnswer.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) userAnswer.VoteRecordID = reader.GetInt32(1); if (!reader.IsDBNull(2)) userAnswer.VoteItemID = reader.GetInt32(2); if (!reader.IsDBNull(3)) userAnswer.AnswerContent = reader.GetString(3); userAnswer.MarkOld(); userAnswerlist.Add(userAnswer); } reader.Close(); } return userAnswerlist; }
public IList<Core.Business.UserAnswer> GetUserAnswerByVoteItemList(IList<VoteItem> vIList) { IList<Core.Business.UserAnswer> userAnswerlist = new List<Core.Business.UserAnswer>(); foreach (Core.Business.VoteItem vI in vIList ) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@voteItemID", SqlDbType.Int, vI.Id); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetUserAnswerByVoteItemID); if (reader != null) { while (reader.Read()) { Core.Business.UserAnswer userAnswer = new Core.Business.UserAnswer(); if (!reader.IsDBNull(0)) userAnswer.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) userAnswer.VoteRecordID = reader.GetInt32(1); if (!reader.IsDBNull(2)) userAnswer.VoteItemID = reader.GetInt32(2); if (!reader.IsDBNull(3)) userAnswer.AnswerContent = reader.GetString(3); userAnswer.MarkOld(); userAnswerlist.Add(userAnswer); } reader.Close(); } } return userAnswerlist; }