MemberManagement/FrmRechargeHistory.cs

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

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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.Common;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace MemberManagement
{
    public partial class FrmRechargeHistory : Form
    {
        public FrmRechargeHistory()
        {
            InitializeComponent();
            //设置窗体的双缓冲
            this.SetStyle(ControlStyles.OptimizedDoubleBuffer | ControlStyles.ResizeRedraw | ControlStyles.AllPaintingInWmPaint, true);
            this.UpdateStyles();
            //利用反射设置DataGridView的双缓冲
            Type dgvType = this.dataGridView1.GetType();
            PropertyInfo pi = dgvType.GetProperty("DoubleBuffered", BindingFlags.Instance | BindingFlags.NonPublic);
            pi.SetValue(this.dataGridView1, true, null);
        }

        private void FrmRecharge_Load(object sender, EventArgs e)
        {
            this.dateTimePicker1.Value = DateTime.Now.AddDays(-7);
            this.dateTimePicker2.Value = DateTime.Now;
            this.txtCard1.Focus();
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            ((Button)sender).Enabled = false;
            this.Search();
            ((Button)sender).Enabled = true;
        }

        private bool Search()
        {
            try
            {
                using (var db = new MemberManagementEntities())
                {
                    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 type = this.radioButton1.Checked ? 0 : 1;
                    //db.Database.log += c => Console.WriteLine(c);
                    var query =
                        from a in db.recharge
                        join b in db.member on a.memberId equals b.id
                        where a.type == type && a.createTime >= startTime && a.createTime <= endTime
                        orderby a.id descending
                        select new