DAL/Employee.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
    public class Employee
    {
        /// <summary>
        /// 精准查询
        /// </summary>
        /// <param name="id"></param>
        /// <param name="strsql"></param>
        /// <returns></returns>
        public DataTable ExactSelectEmployee(string id, string strsql)
        {
            string sql = " SELECT Rowid,Idno,name,Sex,Uid,Mobile,GraduationDate,HAddress FROM y_Employee";
            if (id == "1")
            {
                sql += " where Idno='" + strsql + "'";
            }
            if (id == "2")
            {
                sql += " where name='" + strsql + "'";
            }
            if (id == "3")
            {
                sql += " where  uid='" + strsql + "'";
            }
            if (id == "4")
            {
                sql += " where Mobile='" + strsql + "'";
            }
            return DBhelp.Gettable(sql, null);
        }
        /// <summary>
        /// 模糊查询
        /// </summary>
        /// <param name="sex"></param>
        /// <param name="source"></param>
        /// <param name="edu"></param>
        /// <returns></returns>
        public DataTable VagueSelectEmployee(string sex, string source, string edu)
        {
            string sql = @"SELECT e.Rowid,Idno,name,Sex,Uid,Mobile,GraduationDate,HAddress FROM y_Employee e INNER JOIN y_parameterSrc p ON e.source=p.Parametercode AND p.Parametertype='HSource'INNER JOIN y_parameterSrc p2 on e.EducationBG=p2.Parametercode AND p2.Parametertype='HEducationBG'  ";
            if (sex != "请选择")
            {
                sql += "and e.sex='" + sex + "'";
            }
            if (source != "请选择")
            {
                sql += "and p.Parametercontent='" + source + "'";
            }
            if (edu != "请选择")
            {
                sql += "and p2.Parametercontent='" + edu + "'";
            }
            return DBhelp.Gettable(sql, null);