SourceCode/RFrameGenerate.BLL/Category/CategoryManage.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using RFramework.SQLQuery;
using RFramework.SQLQuery.SQLExpands;
using RFramework.SQLServer.Enums;
using RFrameGenerate.Model;
using System.Linq.Expressions;

namespace RFrameGenerate.BLL.Category
{
    public class CategoryManage
    {
        public static List<T> GetCategories<T>(string categoryCode, Func<Model.T_JD_ProductCategory, T> selectorfield)
        {
            using (var sql = new SqlModel<Model.T_JD_ProductCategory>())
            {
                return sql.SqlSelect(selectorfield)
                          .SqlWhere(m => m.Status == 0 && m.ParentNode == categoryCode)
                          .SqlOrderBy(m => m.Sort)
                          .ToList();
            }
        }

        public static List<T> GetCategories<T>(string[] categoryCodes, Func<Model.T_JD_ProductCategory, T> selectorfield)
        {
            using (var sql = new SqlModel<Model.T_JD_ProductCategory>())
            {
                return sql.SqlSelect(selectorfield)
                          .SqlWhere(m => m.Status == 0 && m.CategoryCode.SqlIn(categoryCodes) && m.ParentNode == "0")
                          .SqlOrderBy(m => m.Sort)
                          .ToList();
            }
        }

        public static T GetCategory<T>(string code, Func<Model.T_JD_ProductCategory, T> selectorfield)
        {
            if (string.IsNullOrEmpty(code)) return default(T);

            using (var sql = new SqlModel<Model.T_JD_ProductCategory>())
            {
                return sql.SqlSelect(selectorfield)
                          .SqlWhere(m => m.CategoryCode == code)
                          .FirstOrDefault();
            }
        }

        public static Result UpdateCategory(T_JD_ProductCategory category)
        {
            var checkState = CheckCategory(category);

            if (!checkState.State) return new Result(false, checkState.Msg);

            using (var sql = new SqlModel<Model.T_JD_ProductCategory>())
            {
                var model = sql.SqlSelect()
                               .SqlWhere(m => m.ProductCategoryGuid == category.ProductCategoryGuid)
                               .FirstOrDefault();