WindowsFormsApp1/Form1.cs

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

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

using Dapper;
using DapperEx;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.Common;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        public string connectionName = "strSql";
        public DbBase CreateDbBase()
        {
            return new DbBase(connectionName);
        }
     
        public void Connection()
        {
            var providerName = "System.Data.SqlClient";
            var connStr = ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;
            if (!string.IsNullOrEmpty(ConfigurationManager.ConnectionStrings[connectionName].ProviderName))
                providerName = ConfigurationManager.ConnectionStrings[connectionName].ProviderName;

            var dbProvider = DbProviderFactories.GetFactory(providerName);
            var conn = dbProvider.CreateConnection();
            conn.ConnectionString = connStr;
            conn.Open();
            Console.WriteLine("状态：" + conn.State.ToString());
        }
       
        int pageIndex = 1;
        int pageSize = 10;
        private void pagerToolsControl1_PagerIndexChanged(object sender, PagerToolsLibrary.C_EventArgsClass e)
        {
           /* MessageBox.Show("改变了当前页。" + Environment.NewLine
               + "当前页为：" + e.CurrentPagerIndex.ToString(), "提示"
               , MessageBoxButtons.OK, MessageBoxIcon.Asterisk);*/

            int pageIndex = e.CurrentPagerIndex;
            int pageSize = 10;
            //int pageSize = e.PagerNum;

            int dc1 = 0;
            var result = Page(pageIndex, pageSize, out dc1);
            pagerToolsControl1.IsTrigger = false;
            pagerToolsControl1.DataCount = dc1; //result.Count; 当前查到数量
            pagerToolsControl1.Current = e.CurrentPagerIndex;
            pagerToolsControl1.IsTrigger = true;