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 _logger; public HomeController(ILogger 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; } } }