kxs-stat/Controllers/HomeController.cs

using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Data;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using MySystem.PxcModels;
using System.Threading;
using Library;
using LitJson;

namespace MySystem.Controllers
{
    public class HomeController : Controller
    {
        private readonly ILogger<HomeController> _logger;

        public HomeController(ILogger<HomeController> logger)
        {
            _logger = logger;
        }

        public IActionResult Index()
        {
            return View();
        }

        public IActionResult Error()
        {
            string isapi = Request.Headers["Api"].ToString();
            if (isapi != "1")
            {
                if (Response.StatusCode == 500)
                {
                    return Redirect("/public/errpage/pc/500.html");
                }
                else if (Response.StatusCode == 502)
                {
                    return Redirect("/public/errpage/pc/502.html");
                }
                else if (Response.StatusCode == 404)
                {
                    return Redirect("/public/errpage/pc/404.html");
                }
            }
            return View();
        }
        public string tmp()
        {
            string result = "";
            // string conn = Library.ConfigurationManager.AppSettings["SqlConnStr"].ToString();
            // DataTable dt = CustomerSqlConn.dtable("select UserId from HelpProfitAmountSummary where TradeMonth>MaxAmount and TradeMonth='202301'", conn);
            // foreach(DataRow dr in dt.Rows)
            // {
            //     int UserId = int.Parse(dr["UserId"].ToString());
            //     decimal HelpAmount = 0; //当天总交易额
            //     DataTable dtsub = CustomerSqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId=" + UserId + ") AND TradeDate='20230101'", conn);
            //     if(dtsub.Rows.Count > 0)
            //     {
            //         HelpAmount = decimal.Parse(function.CheckNum(dtsub.Rows[0]["TradeAmount"].ToString()));
            //     }
            //     result += test(UserId, HelpAmount);
            //     result += "\n\n";
            // }
            return result;
        }

        public string test(string d)
        {
            string result = "ok";
            // RedisDbconn.Instance.AddList("StatResetUserTradeQueue", "{\"Kind\":\"23\",\"BrandId\":\"1,2,3,4,5,6,7,8,9,10,11,12,13,15\",\"TradeDate\":\"2024-02-01\"}");
            // StatTradeCheckService.Instance.StatTradeAmountCheckDo(d);
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-01");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-02");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-03");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-04");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-05");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-06");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-07");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-08");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-09");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-10");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-11");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-12");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-13");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-14");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-15");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-16");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-17");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-18");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-19");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-20");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-21");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-22");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-23");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-24");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-25");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-26");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-27");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-28");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-29");
            StatTradeCheckService.Instance.StatTradeAmountCheckDo("2024-03-30");
            return result;
        }
    }
}