App_Code/MicroBIHelper.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Web;
using MicroDBHelper;
//using MicroSysInfoHelper;
using MicroPublicHelper;

/// <summary>
/// DataTable数据表
/// </summary>
namespace MicroBIHelper
{
    public class MicroBI
    {
        /// <summary>
        /// 获取申请量数据（首页2数字用）
        /// </summary>
        /// <param name="QueryType"></param>
        /// <param name="CustomDate"></param>
        /// <returns></returns>
        public static string GetApplyByQty(string QueryType, string CustomDate = "")
        {
            string strTpl = "\"currQty\":\"{0}\", \"preQty\":\"{1}\", \"diffQty\":\"{2}\"";

            string flag = string.Empty,
                StartDate = DateTime.Now.toDateFormat("yyyy-MM-dd") + " 00:00:00.000",
                EndDate = DateTime.Now.toDateFormat("yyyy-MM-dd") + " 23:59:59.998",
                PreStartDate = DateTime.Now.AddDays(-1).toDateFormat("yyyy-MM-dd") + " 00:00:00.000", //上一天
                PreEndDate = DateTime.Now.AddDays(-1).toDateFormat("yyyy-MM-dd") + " 23:59:59.998";

            CustomDate = string.IsNullOrEmpty(CustomDate) ? DateTime.Now.toDateFormat("yyyy-MM-dd") : CustomDate;

            int CurrQty = 0,
                PreQty = 0,
                DiffQty = 0;

            switch (QueryType.ToLower())
            {
                case "day":
                    StartDate = CustomDate.toDateFormat("yyyy-MM-dd") + " 00:00:00.000";
                    EndDate = CustomDate.toDateFormat("yyyy-MM-dd") + " 23:59:59.998";
                    PreStartDate = CustomDate.toDateTime().AddDays(-1).toDateFormat("yyyy-MM-dd") + " 00:00:00.000";
                    PreEndDate = CustomDate.toDateTime().AddDays(-1).toDateFormat("yyyy-MM-dd") + " 23:59:59.998";
                    break;

                case "week":
                    StartDate = CustomDate.toDateWFirstDay() + " 00:00:00.000";
                    EndDate = CustomDate.toDateWLastDay() + " 23:59:59.998";
                    PreStartDate = CustomDate.toDateTime().AddDays(-7).toDateWFirstDay() + " 00:00:00.000";
                    PreEndDate = CustomDate.toDateTime().AddDays(-7).toDateWLastDay() + " 23:59:59.998";
                    break;

                case "month":
                    StartDate = CustomDate.toDateMFirstDay() + " 00:00:00.000";
                    EndDate = CustomDate.toDateMLastDay() + " 23:59:59.998";
                    PreStartDate = CustomDate.toDateTime().AddMonths(-1).toDateMFirstDay() + " 00:00:00.000";