public IList<Core.Business.VoteItem> GetVoteItemByVoteID(int id) { IList<Core.Business.VoteItem> voteItemlist = new List<Core.Business.VoteItem>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@voteid", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetVoteItemByVoteID); if (reader != null) { while (reader.Read()) { Core.Business.VoteItem voteItem = new Core.Business.VoteItem(); if (!reader.IsDBNull(0)) voteItem.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) voteItem.VoteID = reader.GetInt32(1); if (!reader.IsDBNull(2)) voteItem.IsMutiChoose = reader.GetInt32(2); if (!reader.IsDBNull(3)) voteItem.IsUserDefine = reader.GetInt32(3); if (!reader.IsDBNull(4)) voteItem.VoteItemContent = reader.GetString(4); voteItem.MarkOld(); voteItemlist.Add(voteItem); } reader.Close(); } return voteItemlist; }
public Core.Business.VoteItem Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Key", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectVoteItem); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.VoteItem voteItem = new Core.Business.VoteItem(); if (!reader.IsDBNull(0)) voteItem.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) voteItem.VoteID = reader.GetInt32(1); if (!reader.IsDBNull(2)) voteItem.IsMutiChoose = reader.GetInt32(2); if (!reader.IsDBNull(3)) voteItem.IsUserDefine = reader.GetInt32(3); if (!reader.IsDBNull(4)) voteItem.VoteItemContent = reader.GetString(4); return voteItem; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }