Himall.Service/Job/OrderCommentsJob.cs

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

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

using Himall.Entity;
using Himall.Model;
using Quartz;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Linq.Expressions;
using System.Runtime.CompilerServices;
using System.Transactions;

namespace Himall.Service.Job
{
    public class OrderCommentsJob : IJob
    {
        public OrderCommentsJob()
        {
        }

        public void Execute(IJobExecutionContext context)
        {
            try
            {
                using (TransactionScope transactionScope = new TransactionScope())
                {
                    Entities entity = new Entities();
                    List<OrderCommentsJob.OrderCommentsModel> list = (
                        from p in entity.OrderCommentInfo
                        group p by p.ShopId into g
                        select new OrderCommentsJob.OrderCommentsModel()
                        {
                            ShopId = g.Key,
                            AvgDeliveryMark = g.Average<OrderCommentInfo>((OrderCommentInfo p) => p.DeliveryMark),
                            AvgPackMark = g.Average<OrderCommentInfo>((OrderCommentInfo p) => p.PackMark),
                            AvgServiceMark = g.Average<OrderCommentInfo>((OrderCommentInfo p) => p.ServiceMark),
                            CategoryIds = entity.BusinessCategoryInfo.Where((BusinessCategoryInfo c) => c.ShopId == g.Key).Select<BusinessCategoryInfo, long>((BusinessCategoryInfo c) => c.CategoryId).ToList()
                        }).ToList<OrderCommentsJob.OrderCommentsModel>();
                    foreach (OrderCommentsJob.OrderCommentsModel orderCommentsModel in list)
                    {
                        List<OrderCommentsJob.OrderCommentsModel> orderCommentsModels = new List<OrderCommentsJob.OrderCommentsModel>();
                        foreach (long categoryId in orderCommentsModel.CategoryIds)
                        {
                            IEnumerable<OrderCommentsJob.OrderCommentsModel> orderCommentsModels1 =
                                from c in list
                                where c.CategoryIds.Contains(categoryId)
                                select c;
                            if (orderCommentsModels1 == null || orderCommentsModels1.Count<OrderCommentsJob.OrderCommentsModel>() <= 0)
                            {
                                continue;
                            }
                            orderCommentsModels.AddRange(orderCommentsModels1);
                        }
                        double num = (orderCommentsModels.Count != 0 ? orderCommentsModels.Average<OrderCommentsJob.OrderCommentsModel>((OrderCommentsJob.OrderCommentsModel c) => c.AvgPackMark) : 0);
                        double num1 = (orderCommentsModels.Count != 0 ? orderCommentsModels.Average<OrderCommentsJob.OrderCommentsModel>((OrderCommentsJob.OrderCommentsModel c) => c.AvgDeliveryMark) : 0);
                        double num2 = (orderCommentsModels.Count != 0 ? orderCommentsModels.Average<OrderCommentsJob.OrderCommentsModel>((OrderCommentsJob.OrderCommentsModel c) => c.AvgServiceMark) : 0);
                        double num3 = (orderCommentsModels.Count != 0 ? list.Where<OrderCommentsJob.OrderCommentsModel>((OrderCommentsJob.OrderCommentsModel c) => (
                            from o in orderCommentsModels
                            where o.ShopId == c.ShopId
                            select o).Count<OrderCommentsJob.OrderCommentsModel>() > 0).Max<OrderCommentsJob.OrderCommentsModel>((OrderCommentsJob.OrderCommentsModel c) => c.AvgPackMark) : 0);
                        double num4 = (orderCommentsModels.Count != 0 ? list.Where<OrderCommentsJob.OrderCommentsModel>((OrderCommentsJob.OrderCommentsModel c) => (