Dao/AnalysisRepository.cs

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

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

using Domain;
using IDao;
using Entity.Common;
using System;
using System.Collections.Generic;
using System.Globalization;
using System.Linq;
using System.Text;
using Common;
using PWMIS.DataMap.Entity;
using PWMIS.DataProvider.Data;
using System.Data;
using System.Collections.Specialized;

namespace Dao
{
    /// <summary>
    /// 经营分析 仓储
    /// </summary>
    public class AnalysisRepository : IAnalysisRepository
    {
        #region 微信-流量转化统计
        /// <summary>
        /// 根据年份获得订单数的统计数组
        /// </summary>
        /// <param name="year"></param>
        /// <returns></returns>
        public int[] WeixinFlow_YearOrder(int year)
        {
            //统计微信支付已完成数据为有效状态的数量
            List<OrdersMdl> lstMol = GetOrders_WeixinFinishedValid();
            if (lstMol.Count > 0)
            {
                int[] monthOrderCount = new int[12];
                var yearData = lstMol.Where(w => ((DateTime)w.CompleteDate).Year == year).OrderBy(w => w.CompleteDate);
                for (int i = 1; i < 13; i++)
                {
                    monthOrderCount[i - 1] = yearData.Where(w => (((DateTime)(w.CompleteDate)).Month == i)).Count();
                }
                return monthOrderCount;
            }
            else
                return null;
        }
        /// <summary>
        /// 获得含有订单的年份
        /// </summary>
        /// <returns></returns>
        public int[] GetOrderYear()
        {
            List<OrdersMdl> lstMol = GetOrders_WeixinFinishedValid();
            return lstMol.OrderBy(w => w.CompleteDate).Select(w => ((DateTime)w.CompleteDate).Year).Distinct().ToArray();
        }
        //获得微信支付已完成数据为有效状态的，完成日期不为空的订单
        private List<OrdersMdl> GetOrders_WeixinFinishedValid()
        {
            OrdersMdl mdl = new OrdersMdl();

            DateTime? checkDate = null;