PSI.DAL/GoodsDAL.cs

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

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

using PSI.Common;
using PSI.DbUtility;
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 GoodsDAL:BaseDAL<GoodsInfoModel>
        {
                StoreGoodsStockDAL sgsDAL = new StoreGoodsStockDAL();
                /// <summary>
                /// 分页条件查询商品列表
                /// </summary>
                /// <param name="gTypeId"></param>
                /// <param name="keywords"></param>
                /// <param name="isStopped"></param>
                /// <param name="isDeleted"></param>
                /// <param name="startIndex"></param>
                /// <param name="pageSize"></param>
                /// <returns></returns>
                public PageModel<ViewGoodsInfoModel> LoadGoodsList(int gTypeId, string keywords, int isStopped, int isDeleted, int startIndex, int pageSize)
                {
                        //存储过程  返回两个结果   总记录数    当前页数据列表
                        string cols = "GoodsId,GoodsNo,GoodsName,GoodsPYNo,GoodsTXNo,GUnit,GTypeId,GTypeName,GProperties,IsStopped,RetailPrice,Remark";
                        string strWhere = "1=1";
                        strWhere += $" and IsStopped={isStopped} and IsDeleted={isDeleted}";
                        //总记录数    当前页数据列表
                        DataSet ds =  GetPageDs<ViewGoodsInfoModel>(strWhere, gTypeId, keywords, cols, "proc_GetGoodsPage", startIndex, pageSize);
                        return DsToPageModel<ViewGoodsInfoModel>(ds, cols);
                }

                /// <summary>
                /// 获取指定的商品信息
                /// </summary>
                /// <param name="goodsId"></param>
                /// <returns></returns>
                public GoodsInfoModel GetGoodsInfo(int goodsId)
                {
                        string cols = "GoodsId,GoodsName,GoodsNo,GoodsPYNo,GoodsSName,GoodsTXNo,GUnit,GTypeId,GProperties,IsStopped,RetailPrice,LowPrice,PrePrice,DisCount,BidPrice,Remark,GoodsPic";
                        return GetById(goodsId, cols);
                }

                /// <summary>
                /// 删除商品信息
                /// </summary>
                /// <param name="goodsIds"></param>
                /// <param name="delType">0 LogicDel   1 Delete</param>
                /// <param name="isDeleted"></param>
                /// <returns></returns>
                public bool DeleteGoodsInfos(List<int> goodsIds,int delType, int isDeleted,string uName)
                {
                        List<string> listSql = new List<string>();