public IList<Core.Business.VoteRecordDetail> GetAllVoteRecordDetail()
{
IList<Core.Business.VoteRecordDetail> voteRecordDetaillist = new List<Core.Business.VoteRecordDetail>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllVoteRecordDetail);
if(reader != null)
{
while(reader.Read())
{
Core.Business.VoteRecordDetail voteRecordDetail = new Core.Business.VoteRecordDetail();
if (!reader.IsDBNull(0)) voteRecordDetail.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) voteRecordDetail.VoteRecordID = reader.GetInt32(1);
if (!reader.IsDBNull(2)) voteRecordDetail.VoteItemID = reader.GetInt32(2);
if (!reader.IsDBNull(3)) voteRecordDetail.VoteAnswerID = reader.GetInt32(3);
voteRecordDetail.MarkOld();
voteRecordDetaillist.Add(voteRecordDetail);
}
reader.Close();
}
return voteRecordDetaillist;
}
public IList<CY.GFive.Core.Business.VoteRecordDetail> GetVoteRecordDetailByItemAndAnswer(int ItemID, int AnswerID)
{
IList<Core.Business.VoteRecordDetail> voteRecordDetaillist = new List<Core.Business.VoteRecordDetail>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@voteItemID", SqlDbType.Int, ItemID);
sql.AddParameter("@voteAnswerID", SqlDbType.Int, AnswerID);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetVoteRecordDetailByItemAndAnswer);
if (reader != null)
{
while (reader.Read())
{
Core.Business.VoteRecordDetail voteRecordDetail = new Core.Business.VoteRecordDetail();
if (!reader.IsDBNull(0)) voteRecordDetail.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) voteRecordDetail.VoteRecordID = reader.GetInt32(1);
if (!reader.IsDBNull(2)) voteRecordDetail.VoteItemID = reader.GetInt32(2);
if (!reader.IsDBNull(3)) voteRecordDetail.VoteAnswerID = reader.GetInt32(3);
voteRecordDetail.MarkOld();
voteRecordDetaillist.Add(voteRecordDetail);
}
reader.Close();
}
return voteRecordDetaillist;
}
public IList<VoteRecordDetail> GetVoteRecordDetailByVoteItemList(IList<VoteItem> vIList)
{
IList<Core.Business.VoteRecordDetail> voteRecordDetaillist = new List<Core.Business.VoteRecordDetail>();
foreach (VoteItem vI in vIList)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@voteItemID", SqlDbType.Int, vI.Id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetVoteRecordDetailByVoteItemList);
if (reader != null)
{
while (reader.Read())
{
Core.Business.VoteRecordDetail voteRecordDetail = new Core.Business.VoteRecordDetail();
if (!reader.IsDBNull(0)) voteRecordDetail.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) voteRecordDetail.VoteRecordID = reader.GetInt32(1);
if (!reader.IsDBNull(2)) voteRecordDetail.VoteItemID = reader.GetInt32(2);
if (!reader.IsDBNull(3)) voteRecordDetail.VoteAnswerID = reader.GetInt32(3);
voteRecordDetail.MarkOld();
voteRecordDetaillist.Add(voteRecordDetail);
}
reader.Close();
}
}
return voteRecordDetaillist;
}
public Core.Business.VoteRecordDetail Select(int id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@VoteRecordDetailID", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectVoteRecordDetail);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.VoteRecordDetail voteRecordDetail = new Core.Business.VoteRecordDetail();
if (!reader.IsDBNull(0)) voteRecordDetail.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) voteRecordDetail.VoteRecordID = reader.GetInt32(1);
if (!reader.IsDBNull(2)) voteRecordDetail.VoteItemID = reader.GetInt32(2);
if (!reader.IsDBNull(3)) voteRecordDetail.VoteAnswerID = reader.GetInt32(3);
reader.Close();
return voteRecordDetail;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
