username@email.com
2025-05-15 6fe02a16e55f17e45a3997171e1b2284d45af25b
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.Infrastructure.Query;
using CY.BLL;
using CY.Model;
 
namespace CY.WebForm.Pages.member
{
    public partial class UsedCommissionMoneyListShow : BasePage
    {
        Pay_IncExpRecordBLL bll_Pay_IncExpRecordBLL = new Pay_IncExpRecordBLL();
 
        public string PrintHtml = "";
 
        public string StartDate
        {
            get
            {
                return Request.Params["StartDate"] == null ? string.Empty : Request.Params["StartDate"].ToString();
            }
        }
 
        public string EndDate
        {
            get
            {
                string endDate = Request.Params["EndDate"] == null ? string.Empty : Request.Params["EndDate"].ToString();
                if (!string.IsNullOrEmpty(endDate))
                {
                    endDate = DateTime.Parse(endDate).AddDays(1).ToString();
                }
                return endDate;
            }
        }
 
        public string Province
        {
            get
            {
                return Request.Params["Province"] == null ? string.Empty : Request.Params["Province"].ToString();
            }
        }
 
        public string City
        {
            get
            {
                return Request.Params["City"] == null ? string.Empty : Request.Params["City"].ToString();
            }
        }
 
        public string County
        {
            get
            {
                return Request.Params["County"] == null ? string.Empty : Request.Params["County"].ToString();
            }
        }
 
        protected void Page_Load(object sender, EventArgs e)
        {
            UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
            if (!IsPostBack)
            {
                BindList();
            }
        }
 
        /// <summary>
        /// 绑定数据
        /// </summary>
        private void BindList()
        {
            Pagination pa = new Pagination();
            pa.PageSize = UCPager1.AspNetPager.PageSize;
            pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
            this.RepClientList.DataSource = bll_Pay_IncExpRecordBLL.SelectAllModelByPaging(pa, CurrentPayAccount.Keyid, StartDate, EndDate, Province, City, County);
            this.RepClientList.DataBind();
            UCPager1.AspNetPager.RecordCount = pa.RecordCount;
 
            Pagination pa_All = new Pagination();
            pa_All.PageSize = int.MaxValue;
            pa_All.PageIndex = 1;
            List<Pay_IncExpRecord> m_Pay_PromotionRecord_List = bll_Pay_IncExpRecordBLL.SelectAllModelByPaging(pa_All, CurrentPayAccount.Keyid, StartDate, EndDate, Province, City, County).ToList();
            PrintHtml += "<tr><th>编号</th><th>发生时间</th><th>客户类别</th><th>客户名称</th><th>账户类型</th><th>收支科目</th><th>交易摘要</th><th>交易金额</th><th>剩余金额</th></tr>";
            if (m_Pay_PromotionRecord_List != null && m_Pay_PromotionRecord_List.Count > 0)
            {
                int i = 1;
                foreach (var item in m_Pay_PromotionRecord_List)
                {
                    PrintHtml += "<tr><td>" + i + "</td><td>" + item.CreateTime + "</td><td>" + item.MemberTypeName + "</td><td>" + item.MemberName + "</td><td>" + (item.TradingType == 1 ? "收入" : "支出") + "</td><td>" + item.BalanceAccountName + "</td><td>" + item.TradingName + "</td><td>" + item.TradingMoney.Value.ToString("0.00") + "</td><td>" + item.ResidualMoney.Value.ToString("0.00") + "</td></tr>";
                    i++;
                }
            }
        }
 
        //分页事件
        protected void AspNetPager1_PageChanged(object src, EventArgs e)
        {
            BindList();
        }
    }
}