PSI.DAL/UnitDAL.cs

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

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

using PSI.Common;
using PSI.Models.DModels;
using PSI.Models.UIModels;
using PSI.Models.VModels;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace PSI.DAL
{
        public  class UnitDAL:BaseDAL<UnitInfoModel>
        {
                /// <summary>
                /// 获取指定类别的单位信息列表
                /// </summary>
                /// <param name="typeId"></param>
                /// <returns></returns>
                public List<UnitInfoModel> GetUnitInfosByTypeId(int typeId)
                {
                        return GetModelList($"IsDeleted=0 and UTypeId={typeId}", "UnitId,UnitName,UnitNo");
                }

                /// <summary>
                /// 条件查询单位信息列表（分页）
                /// </summary>
                /// <param name="uTypeId"></param>
                /// <param name="keywords"></param>
                /// <param name="isDeleted"></param>
                /// <param name="startIndex"></param>
                /// <param name="pageSize"></param>
                /// <returns></returns>
                public  PageModel<ViewUnitInfoModel> GetUnitList(int uTypeId, string keywords, int isDeleted, int startIndex, int pageSize)
                {
                        //存储过程  返回两个结果   总记录数    当前页数据列表
                        string cols = "UnitId,UnitName,UnitPYNo,UTypeId,UTypeName,UnitProperties,RegionId,Address,FullAddress,UnitNo,IsNoVail,ContactPerson";
                        string strWhere = "1=1";
                        strWhere += $" and IsDeleted={isDeleted}";
                        //总记录数    当前页数据列表
                        DataSet ds = GetPageDs<ViewUnitInfoModel>(strWhere, uTypeId, keywords, cols, "proc_GetUnitPage", startIndex, pageSize);
                        return DsToPageModel<ViewUnitInfoModel>(ds, cols);
                }

                /// <summary>
                /// 关键词模糊查询单位列表信息
                /// </summary>
                /// <param name="utypeId"></param>
                /// <param name="keywords"></param>
                /// <param name="cols"></param>
                /// <returns></returns>
                public List<UnitInfoModel> GetUnitList(int utypeId, string utypeName, string keywords)
                {
                        string cols = "UnitId,UnitName,UnitPYNo,ContactPerson,PhoneNumber,Telephone,FullAddress";
                        string strWhere = "1=1";
                        if (utypeId > 0)
                                strWhere += " and (UTypeId in (select UTypeId from UnitTypeInfos where UTypeId=@utypeId  or ParentId in (select UTypeId from UnitTypeInfos  where ParentId=@utypeId or UTypeId=@utypeId)))";
                        else if (!string.IsNullOrEmpty(utypeName))