ZSJ_BCY_Web_DAL/AdministratorService.cs

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

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

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Runtime.Remoting.Messaging;
using System.Text;
using ZSJ_BCY_Web_Model;

namespace ZSJ_BCY_Web_DAL
{
    public class AdministratorService
    {
        /// <summary>
        /// 管理员 查询
        /// </summary>
        /// <param name="ic"></param>
        /// <returns></returns>
        public static List<Administrator> SelectAdmin(InquireCondition ic)
        {

            StringBuilder sb = new StringBuilder();
            sb.Append(@"select  s.Id,s.StaffName,s.StaffAccount,
            case s.StaffSex when 1 then '男' else '女' end as StaffSex
            ,s.StaffTelePhone,s.StaffEducation,
            s.StaffBirthday,s.StaffSalary,p.PositionName,
            case s.StaffStatus when 1 then '在职' else '离职' end as StaffStatus,p.PositionId

             from Staff as s inner join  Position as p on s.StaffPosition=p.PositionId
             ");

            List<string> listString = new List<string>();
            List<SqlParameter> listpame = new List<SqlParameter>();

            if (!string.IsNullOrWhiteSpace(ic.StaffName))
            {
                listString.Add("s.StaffName like @StaffName ");
                listpame.Add(new SqlParameter("@StaffName", "%" + ic.StaffName + "%"));
            }

            if (!string.IsNullOrWhiteSpace(ic.StaffTelePhone))
            {
                listString.Add("s.StaffTelePhone like @StaffTelePhone ");
                listpame.Add(new SqlParameter("@StaffTelePhone", "%" + ic.StaffTelePhone + "%"));
            }


            if (ic.StaffSex > -1)
            {
                listString.Add("s.StaffSex=@StaffSex ");
                listpame.Add(new SqlParameter("@StaffSex", ic.StaffSex));
            }
            if (ic.StaffPosition > 0)
            {
                listString.Add("s.StaffPosition=@StaffPosition ");
                listpame.Add(new SqlParameter("@StaffPosition", ic.StaffPosition));
            }
            if (listpame.Count > 0)
            {
                sb.Append(" where " + string.Join(" and ", listString.ToArray()));
            }