PSI.DAL/ViewSaleGoodsQueryDAL.cs

（开头部分） 8KB

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

using PSI.Common;
using PSI.DbUtility;
using PSI.Models.UIModels;
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 ViewSaleGoodsQueryDAL
        {
                /// <summary>
                /// 销售统计  分页
                /// </summary>
                /// <param name="typeId"></param>
                /// <param name="paraModel"></param>
                /// <returns></returns>
                public DataSet GetSaleData(int typeId, QueryParaModel paraModel, int startIndex, int pageSize)
                {
                        string sql = " select row_number() over (order by ";
                        string orColName = "";
                        string selCols = "";
                        switch (typeId)
                        {
                                case 1:
                                        orColName = "UnitId";
                                        selCols = "UnitId,UnitName";
                                        break;
                                case 2:
                                        orColName = "StoreId";
                                        selCols = "StoreId,StoreName";
                                        break;
                                case 3:
                                        orColName = "GoodsId";
                                        selCols = "GoodsId,GoodsName,GoodsNo,GUnit";
                                        break;
                                default: break;
                        }
                        sql += orColName + ") as Id," + selCols + " from (select distinct " + selCols + " from ViewSaleGoodsQuery  where 1=1";
                        //条件拼接
                        string strWhere = "";
                        if (paraModel != null)
                        {
                                if (!string.IsNullOrEmpty(paraModel.GoodsName))
                                {
                                        strWhere += " and GoodsName like @goodsName";
                                }
                                if (paraModel.StoreId > 0)
                                        strWhere += " and StoreId=@storeId";
                                else if (!string.IsNullOrEmpty(paraModel.StoreName))
                                {
                                        strWhere += " and StoreName like @storeName";
                                }
                                if (paraModel.GTypeId > 0)
                                        strWhere += " and  (GTypeId in (select GTypeId from GoodsTypeInfos where  GTypeId=@gTypeId  or ParentId in (select GTypeId from GoodsTypeInfos  where ParentId=@gTypeId or GTypeId=@gTypeId)))";
                                if (paraModel.UTypeId > 0)
后面还有 89 行代码，解锁后查看完整代码

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

AI 解读 AI

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

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