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); }