SourceCode/RFrameGenerate.BLL/OrderManage.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using OfficeOpenXml.ConditionalFormatting;
using RFrameGenerate.DAL.SQLServer;
using RFrameGenerate.Model;
using RFramework.SQLServer;
using System.Linq.Expressions;
using RFrameGenerate.BLL.Products;
using RFrameGenerate.Common;
using System.Data;
using System.Net;
using RFrameGenerate.DAL.Enums;
using RFramework.SQLQuery;
using RFrameGenerate.BLL.Logistics;
using RFrameGenerate.BLL.Marketing;
using RFrameGenerate.Model.PageModel;
using System.Data.SqlClient;
using RFrameGenerate.Common.Tools;
using RFrameGenerate.BLL.Recharge;
namespace RFrameGenerate.BLL
{
    public class OrderManage
    {
        /// <summary>
        /// 获取订单列表（分页）
        /// </summary>
        /// <param name="gridModel"></param>
        /// <returns></returns>
        public List<T_ST_OrderList> GetPageList(GridModel gridModel, Guid? merchantguid, string orderState, string memberName, string orderNo, string payNo, string reciever)
        {
            using (var query = Factory.CreateT_ST_OrderList())
            {
                Expression<Func<T_ST_OrderList, bool>> condition = m => m.MemberName.SqlLike(memberName) && m.OrderNo.SqlLike(orderNo) && m.TransactionID.SqlLike(payNo) && m.Reciever.SqlLike(reciever);
                if (merchantguid != null && merchantguid != Guid.Empty)
                {
                    condition = condition.AndAlso(m => m.MerchantGuid == merchantguid);
                }
                if (!string.IsNullOrEmpty(orderState) && orderState != "0")
                {
                    condition = condition.AndAlso(m => m.OrderState == int.Parse(orderState));
                }
                var istop = MerchantManage.IsTop();
                if (!istop)
                {
                    condition = condition.AndAlso(m => m.MerchantGuid == Common.CurrentManage.MerchantGuid);
                }
                else
                {
                    var guids = AgentAuditManage.GetAllSubordinateAgentByMerGuid(CurrentManage.MerchantGuid);
                    guids.Add(Common.CurrentManage.MerchantGuid);
                    condition = condition.AndAlso(m => m.MerchantGuid.SqlIn(guids.Select(c => c.ToString()).ToArray()));
                }

                return query.GetPageList(gridModel, condition, true, a => a.OrderTime, DAL.Enums.OrderMethods.DESC, RFramework.SQLServer.Enums.LockType.Default, false);
            }
        }
        /// <summary>
        /// 根据GUID获取订单