MemberManagement/RechargeHistoryForm.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using MemberManagement.Common;
using MemberManagement.Context;
using MemberManagement.Model;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace MemberManagement
{
    public partial class RechargeHistoryForm : Form
    {
        public RechargeHistoryForm()
        {
            InitializeComponent();
            this.dataGridView1.Columns["colCreateTime"].DefaultCellStyle.Format = "yyyy-MM-dd hh:mm:ss";
        }

        private void RechargeHistoryForm_Load(object sender, EventArgs e)
        {
            this.dateTimePicker1.Value = DateTime.Now.AddYears(-1);
            this.dateTimePicker2.Value = DateTime.Now;
            this.RefreshData();
        }

        private List<RechargeQueryModel> LoadData(int currentPage, int pageSize, out int totalCount)
        {
            try
            {
                using (var db = new MyContext())
                {
                    var startTime = DateTime.Parse(this.dateTimePicker1.Value.ToString("yyyy-MM-dd 00:00:00"));
                    var endTime = DateTime.Parse(this.dateTimePicker2.Value.ToString("yyyy-MM-dd 23:59:59"));
                    var query = (from m in db.Member
                                 join r in db.Recharge on m.Id equals r.MemberId
                                 where r.CreateTime >= startTime && r.CreateTime <= endTime
                                 orderby r.CreateTime descending
                                 select new RechargeQueryModel
                                 {
                                     Id = r.Id,
                                     MemberName = m.Name,
                                     Type = r.Type,
                                     Balance = r.Balance,
                                     Amount = r.Amount,
                                     CreateTime = r.CreateTime,
                                     Remark = r.Remark,
                                     CardNumber = m.CardNumber,
                                     Mobile = m.Mobile
                                 }).AsQueryable();

                    if (!string.IsNullOrEmpty(txtName.Text))
                    {
                        query = query.Where(m => m.MemberName.Contains(txtName.Text));
                    }
                    if (!string.IsNullOrEmpty(this.txtCardNumber.Text.Trim()))