users.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Data.OleDb;
using Microsoft.Office.Interop.Excel;
using System.Reflection;
using System.IO;

namespace choujiang
{
    public class users
    {
        #region 声明变量
        //
        private static string strSql;
        private string StrExce = null;
        private OleDbConnection objCon = null;
        //全局变量
        DataSet ds = new DataSet();
        //
        #endregion
        #region 构造函数
        public users()
        {
            //连接字符串
            StrExce = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Directory.GetCurrentDirectory() + @"/Data/userinfo.mdb";
        }
        #endregion
        #region 按条件获取人员信息 doImport(string str)   参数str: 全员/未中奖/已中奖
        public DataSet doImport(string str)
        {
            this.objCon = new OleDbConnection(this.StrExce);
            this.objCon.Open();
            if (str == "全员")
            {
                strSql = "SELECT (select count(*) from userinfo where 序号<=a.序号 ) as xu,a.* FROM userinfo as a where  a.工号 is not null ";
                strSql = strSql + " order by a.[序号]";
            }
            else if (str == "未中奖")
            {
                strSql = "SELECT (select count(*) from userinfo where 序号<=a.序号 and 状态= 0 ) as xu,a.* FROM userinfo as a where  a.工号 is not null ";
                strSql = strSql + "  and  a.状态= 0  order by a.[序号] ";
            }
            else if (str == "已中奖")
            {
                strSql = "SELECT (select count(*) from userinfo where 序号<=a.序号 and 状态 <>0) as xu,a.* FROM userinfo as a where  a.工号 is not null ";
                strSql = strSql + "  and  a.状态 <>0  order by a.[序号]";
            }

            // MessageBox.Show(str);
            OleDbDataAdapter ExcelDA = new OleDbDataAdapter(strSql, objCon);
            DataSet ExcelDs = new DataSet();
            try
            {
                ExcelDA.Fill(ExcelDs, "userinfo");
            }
            catch (Exception err)