BusinessFacade/CommonProxy.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Model;
using NLKIRADBCommon;
using CommonTools;
using System.Collections;
using System.Web;
using BusinessFacade.TransDataRelated;
using System.Configuration;

namespace BLL
{
    public class CommonProxy
    {

        /// <summary>
        /// 获取全部员工信息
        /// </summary>
        /// <param name="truck_id"></param>
        /// <returns></returns>
        public static DataTable GetUserList()
        {
            string sql = @"SELECT UserList.ID, UserList.UserNo, UserList.UserName, UserList.Sex FROM UserList";
            DataBase db = DataBaseProvider.CreateDataBase(dbName.AUTO);
            return db.ExecuteDataSet(sql).Tables[0];
        }

        /// <summary>
        /// 根据员工编号，员工姓名，性别查询员工信息
        /// </summary>
        /// <param name="truck_id"></param>
        /// <returns></returns>
        public static DataTable GetUserListByInfo(string uNo, string uName, string sex)
        {
            string sql = @"SELECT UserList.ID, UserList.UserNo, UserList.UserName, UserList.Sex FROM UserList where UserList.UserNo like '%" + uNo + "%' and UserList.UserName like '%" + uName + "%' and UserList.Sex like '%" + sex + "%'";
            DataBase db = DataBaseProvider.CreateDataBase(dbName.AUTO);
            return db.ExecuteDataSet(sql).Tables[0];
        }

        /// <summary>
        /// 获取全部用户信息
        /// </summary>
        /// <param name="truck_id"></param>
        /// <returns></returns>
        public static DataTable GetPowerList()
        {
            string sql = @"SELECT UserList.ID, UserList.UserNo, UserList.UserName, UserList.Sex, UserList.Power FROM UserList WHERE UserList.UserFlag = '1'";
            DataBase db = DataBaseProvider.CreateDataBase(dbName.AUTO);
            return db.ExecuteDataSet(sql).Tables[0];
        }

        /// <summary>
        /// 获取用户名信息
        /// </summary>
        /// <param name="truck_id"></param>
        /// <returns></returns>
        public static DataTable GetUserNo()
        {