SourceCode/RFrameGenerate.BLL/DALExtensions/CommonDAL.cs

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

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

using RFrameGenerate.Common;
using RFramework.SQLQuery;
using RFramework.SQLServer;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Linq.Expressions;
using System.Text;

namespace RFrameGenerate.BLL.DALExtensions
{
    /// <summary>
    /// 扩展现有不支持的方法
    /// </summary>
    public class CommonDAL<T>
    {
        #region Sum 

        public static decimal? Sum(Expression<Func<T, decimal?>> selector, Expression<Func<T, bool>> conditionExpression, bool isFilterNull = false, bool isFilterMerchant = true)
        {
            QueryTranslator where = new QueryTranslator();
            string conditionString = where.Translate(conditionExpression);

            if (isFilterNull == true)
                conditionString = conditionString.SqlFilterNull();

            var field = ((MemberExpression)selector.Body).Member.Name;

            if (string.IsNullOrEmpty(field)) return null;

            return Sum(conditionString, field, isFilterMerchant);
        }

        public static decimal? Sum(Expression<Func<T, int?>> selector, Expression<Func<T, bool>> conditionExpression, bool isFilterNull = false, bool isFilterMerchant = true)
        {
            QueryTranslator where = new QueryTranslator();
            string conditionString = where.Translate(conditionExpression);

            if (isFilterNull == true)
                conditionString = conditionString.SqlFilterNull();

            var field = ((MemberExpression)selector.Body).Member.Name;

            if (string.IsNullOrEmpty(field)) return null;

            return Sum(conditionString, field, isFilterMerchant);
        }

        public static decimal? Sum(Expression<Func<RFrameGenerate.Model.T_BAS_Orders, decimal?>> selector, Expression<Func<RFrameGenerate.Model.T_BAS_Orders, bool>> conditionExpression, bool isFilterNull = false, bool isFilterMerchant = true)
        {
            QueryTranslator where = new QueryTranslator();
            string conditionString = where.Translate(conditionExpression);

            if (isFilterNull == true)
                conditionString = conditionString.SqlFilterNull();

            var field = ((MemberExpression)selector.Body).Member.Name;