PSI.DAL/GoodsTypeDAL.cs

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

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

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

namespace PSI.DAL
{
        public class GoodsTypeDAL : BaseDAL<GoodsTypeInfoModel>
        {
                /// <summary>
                /// 加载商品类别信息（模糊查询）
                /// </summary>
                /// <param name="keywords"></param>
                /// <param name="isDeleted"></param>
                /// <returns></returns>
                public List<GoodsTypeInfoModel> LoadAllGoodsTypeList(string keywords, int isDeleted)
                {
                        List<GoodsTypeInfoModel> list = new List<GoodsTypeInfoModel>();
                        string strWhere = "1=1";
                        string cols = "GTypeId,GTypeName,ParentId,ParentName,GTypeNo,GTPYNo,GTOrder";
                        strWhere += $" and IsDeleted={isDeleted}";
                        if (!string.IsNullOrEmpty(keywords))
                        {
                                strWhere += " and (GTypename like @keywords or ParentName like @keywords or GTypeNo like @keywords or GTPYNo like @keywords)";
                                SqlParameter para = new SqlParameter("@keywords", $"%{keywords}%");
                                list = GetModelList(strWhere, cols, para);
                        }
                        else
                                list = GetModelList(strWhere, cols);
                        return list;
                }

                /// <summary>
                /// 加载所有的商品类别（绑定下拉框）
                /// </summary>
                /// <returns></returns>
                public List<GoodsTypeInfoModel> LoadAllGoodsTypes()
                {
                        List<GoodsTypeInfoModel> list = new List<GoodsTypeInfoModel>();
                        string strWhere = "IsDeleted=0 order by ParentId,GTOrder";
                        string cols = "GTypeId,GTypeName,ParentId";
                        list = GetModelList(strWhere, cols);
                        return list;
                }

                /// <summary>
                /// 获取指定商品类别信息
                /// </summary>
                /// <param name="typeId"></param>
                /// <returns></returns>
                public GoodsTypeInfoModel GetGoodsType(int typeId)
                {
                        return GetById(typeId, "GTypeId,GTypeName,ParentId,GTypeNo,GTPYNo,GTOrder");
                }