PSI.DAL/SheetQueryDAL.cs

（开头部分） 10KB

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

using PSI.Common;
using PSI.DbUtility;
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 SheetQueryDAL:BQuery<SheetInfoModel>
        {
                /// <summary>
                /// 条件查询单据列表
                /// </summary>
                /// <param name="paraModel"></param>
                /// <param name="startIndex"></param>
                /// <param name="pageSize"></param>
                /// <returns></returns>
                public DataSet GetSheetListDs(ShQueryParaModel paraModel,int startIndex,int pageSize)
                {
                        string sql = "select ROW_NUMBER() over (order by SheetId) Id,* from ";
                        string sqlPer = "select distinct PerId SheetId, PerchaseNo SheetNo, 1 as ShType, IsChecked, CreateTime,UnitId, UnitName, YHAmount, DealPerson, Creator, CheckPerson, CheckTime,StoreId,StoreName from ViewPerGoodsQuery ";
                        string sqlSale = " select distinct SaleId SheetId, SaleOutNo SheetNo, 2 as ShType, IsChecked, CreateTime,UnitId, UnitName, YHAmount, DealPerson, Creator, CheckPerson, CheckTime,StoreId,StoreName from ViewSaleGoodsQuery";
                        string sqlStock = "select distinct StockId SheetId, StockNo SheetNo, 3 as ShType, IsChecked, CreateTime,null as UnitId, null as UnitName, null as YHAmount, DealPerson, Creator, CheckPerson, CheckTime,StoreId,StoreName  from ViewStockGoodsQuery";
                        //条件sql的处理
                        string strWhereGoods = "";
                        if (paraModel != null)
                        {
                                switch (paraModel.ShType)
                                {
                                        case 1:
                                                sql += $"({sqlPer}) ";
                                                strWhereGoods = "select PerId from PerchaseGoodsInfos";
                                                break;
                                        case 2:
                                                sql += $"({sqlSale}) ";
                                                strWhereGoods = "select SaleId from SaleGoodsInfos";
                                                break;
                                        case 3:
                                                sql += $"({sqlStock}) ";
                                                strWhereGoods = "select StockId from StStockGoodsInfos";
                                                break;
                                }
                                sql += "as temp where 1=1";
                                if (paraModel.UnitId > 0)
                                        sql += " and UnitId=@unitId";
                                else if(!string.IsNullOrEmpty(paraModel.UnitName))
                                        sql += " and UnitName like @unitName";
                                if (paraModel.StoreId > 0)
                                        sql += " and StoreId=@storeId";
                                else if (!string.IsNullOrEmpty(paraModel.StoreName))
                                        sql += " and StoreName like @storeName";
                                if (!string.IsNullOrEmpty(paraModel.CheckPerson))
                                        sql += " and CheckPerson like @checkPerson";
                                if (!string.IsNullOrEmpty(paraModel.Creator))
后面还有 114 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。