protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CheckAdminPower("ReadVoteRecord", PowerCheckType.Single);
int voteID = RequestHelper.GetQueryString <int>("VoteID");
int voteItemID = RequestHelper.GetQueryString <int>("VoteItemID");
voteItemList = VoteItemBLL.ReadVoteItemAllList();
if (voteID > 0)
{
voteItemList = voteItemList.Where(k => k.VoteID.IndexOf("|" + voteID + "|") >= 0).ToList();
}
VoteRecordSearchInfo searchInfo = new VoteRecordSearchInfo();
if (voteID > 0)
{
searchInfo.VoteID = "|" + voteID + "|";
}
if (voteItemID > 0)
{
searchInfo.ItemID = voteItemID.ToString();
}
List <VoteRecordInfo> recordList = VoteRecordBLL.ReadVoteRecordList(CurrentPage, PageSize, searchInfo, ref Count);
BindControl(recordList, RecordList, MyPager);
}
}
/// <summary>
/// 组合搜索条件
/// </summary>
/// <param name="mssqlCondition"></param>
/// <param name="voteItemSearch"></param>
public void PrepareCondition(MssqlCondition mssqlCondition, VoteRecordSearchInfo searchInfo)
{
mssqlCondition.Add("[VoteID]", searchInfo.VoteID, ConditionType.Like);
mssqlCondition.Add("[ItemID]", searchInfo.ItemID, ConditionType.Equal);
mssqlCondition.Add("[UserIP]", searchInfo.UserIP, ConditionType.Equal);
mssqlCondition.Add("[UserID]", searchInfo.UserID, ConditionType.Equal);
mssqlCondition.Add("[UserName]", searchInfo.UserName, ConditionType.Like);
mssqlCondition.Add("[AddDate]", searchInfo.AddDate, ConditionType.Equal);
}
/// <summary>
/// 按分类ID获得投票记录数据列表
/// </summary>
/// <param name="voteID">分类ID</param>
/// <param name="currentPage">当前的页数</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="count">总数量</param>
/// <returns>投票记录数据列表</returns>
public static List <VoteRecordInfo> ReadVoteRecordList(int currentPage, int pageSize, VoteRecordSearchInfo searchInfo, ref int count)
{
return(dal.ReadVoteRecordList(currentPage, pageSize, searchInfo, ref count));
}
/// <summary>
/// 获得投票记录数据列表
/// </summary>
/// <param name="voteID">分类ID</param>
/// <param name="currentPage">当前的页数</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="count">总数量</param>
/// <returns>投票记录数据列表</returns>
public List <VoteRecordInfo> ReadVoteRecordList(int currentPage, int pageSize, VoteRecordSearchInfo searchInfo, ref int count)
{
List <VoteRecordInfo> voteRecordList = new List <VoteRecordInfo>();
ShopMssqlPagerClass pc = new ShopMssqlPagerClass();
pc.TableName = "VoteRecord";
pc.Fields = "[ID],[VoteID],[ItemID],[UserIP],[AddDate],[UserID],[UserName]";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
pc.OrderField = "[ID]";
pc.OrderType = OrderType.Desc;
PrepareCondition(pc.MssqlCondition, searchInfo);
pc.Count = count;
count = pc.Count;
using (SqlDataReader dr = pc.ExecuteReader())
{
PrepareVoteRecordModel(dr, voteRecordList);
}
return(voteRecordList);
}
