123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412 |
- using System;
- using System.Collections.Generic;
- using System.Diagnostics;
- using System.Linq;
- using System.Threading.Tasks;
- using Microsoft.AspNetCore.Mvc;
- using Microsoft.Extensions.Logging;
- using Library;
- using LitJson;
- using System.Data;
- using MySystem.Models.Main;
- using System.Text.RegularExpressions;
- using Aop.Api.Domain;
- using MySystem.Models;
- 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 string test()
- {
-
-
-
-
-
-
-
-
- WebCMSEntities db = new WebCMSEntities();
- DateTime start = DateTime.Parse("2024-03-10 00:00:00");
- List<ConsumerOrders> orders = db.ConsumerOrders.Where(m => m.Status > 0 && m.IsAct == 1 && m.CreateDate > start && m.CurDivi < m.MaxDivi && m.SettleAmount > 0).OrderBy(m => m.Id).ToList();
- foreach(ConsumerOrders order in orders)
- {
- bool check = RedisDbconn.Instance.GetList<ConsumerOrders>("ConsumerOrdersHd:Divi:" + order.PayMode + ":" + order.MerchantId, 1, 10000).Any(m => m.Id == order.Id);
- bool check1 = db.ConsumerProfit.Any(m => m.OrderId == order.Id);
- if(!check && !check1)
- {
- RedisDbconn.Instance.AddList("ConsumerOrdersHd:Divi:" + order.PayMode + ":List", order.Id.ToString());
- ConsumerOrders edit = db.ConsumerOrders.FirstOrDefault(m => m.Id == order.Id);
- if(edit != null)
- {
- edit.ReturnFlag = 1;
- db.SaveChanges();
- }
- }
- else
- {
- if(!check)
- {
- RedisDbconn.Instance.AddList("ConsumerOrdersHd:Divi:" + order.PayMode + ":" + order.MerchantId, order);
- ConsumerOrders edit = db.ConsumerOrders.FirstOrDefault(m => m.Id == order.Id);
- if(edit != null)
- {
- edit.ReturnFlag = 1;
- db.SaveChanges();
- }
- }
- else if(!check1)
- {
- ConsumerOrders edit = RedisDbconn.Instance.GetList<ConsumerOrders>("ConsumerOrdersHd:Divi:" + order.PayMode + ":" + order.MerchantId, 1, 10000).FirstOrDefault(m => m.Id == order.Id);
- long count = RedisDbconn.Instance.DelFromList("ConsumerOrdersHd:Divi:" + order.PayMode + ":" + order.MerchantId,edit);
- if(count > 0)
- {
- RedisDbconn.Instance.AddList("ConsumerOrdersHd:Divi:" + order.PayMode + ":List", order.Id.ToString());
- }
- }
- }
- if(order.ReturnFlag == 0 && check && check1)
- {
- ConsumerOrders edit = db.ConsumerOrders.FirstOrDefault(m => m.Id == order.Id);
- if(edit != null)
- {
- edit.ReturnFlag = 1;
- db.SaveChanges();
- }
- }
- }
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- string str = "";
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- db.Dispose();
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- return str;
- }
- public string bindapp(int mid)
- {
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- return "ok";
- }
-
-
- public string clearQueue(int OrderId, int MerchantId, int PayMode)
- {
-
-
-
-
-
-
-
-
- return "ok";
- }
-
-
-
- public string back(string no)
- {
- WebCMSEntities db = new WebCMSEntities();
- ConsumerOrders order = db.ConsumerOrders.FirstOrDefault(m => m.OrderNo == no);
- if(order != null)
- {
- List<ConsumerOrders> list = RedisDbconn.Instance.GetList<ConsumerOrders>("ConsumerOrdersHd:Divi:" + order.PayMode + ":" + order.MerchantId + "", 1, 100000);
- ConsumerOrders check = list.FirstOrDefault(m => m.Id == order.Id);
- bool op = db.ConsumerProfit.Any(m => m.OrderId == order.Id);
- if(check == null)
- {
- if(!op)
- {
- RedisDbconn.Instance.AddList("ConsumerOrdersHd:Divi:" + order.PayMode + ":List", order.Id.ToString());
- }
- else
- {
- RedisDbconn.Instance.AddList("ConsumerOrdersHd:Divi:" + order.PayMode + ":" + order.MerchantId, order);
- }
- }
- db.Dispose();
- }
- return "ok";
- }
- public string goonback(int mid, int pm, string date)
- {
- DateTime start = DateTime.Parse(date + " 00:00:00");
- DateTime end = start.AddDays(1);
- WebCMSEntities db = new WebCMSEntities();
- List<ConsumerOrders> queue = RedisDbconn.Instance.GetList<ConsumerOrders>("ConsumerOrdersHd:Divi:" + pm + ":" + mid + "", 1, 100000);
- List<ConsumerOrders> list = db.ConsumerOrders.Where(m => m.MerchantId == mid && m.PayMode == pm && m.Status > 0 && m.IsAct == 1 && m.CreateDate >= start && m.CreateDate < end).ToList();
- foreach(ConsumerOrders sub in list)
- {
- if(!queue.Any(m => m.Id == sub.Id) && sub.CurDivi < sub.MaxDivi)
- {
- RedisDbconn.Instance.AddList("ConsumerOrdersHd:Divi:" + pm + ":" + mid, sub);
- }
- }
- db.Dispose();
- return "ok";
- }
- }
- }
|