kxs-main/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;
using System.Security.Cryptography;

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 leaderflag()
        {
            WebCMSEntities db = new WebCMSEntities();
            List<int> ids = new List<int>();
            // List<PosCouponRecord> records = db.PosCouponRecord.Where(m => m.FromUserId == 597).ToList();
            // foreach(PosCouponRecord record in records)
            // {
            //     ids.Add(record.PosCouponId);
            // }
            ids.Add(6843);
            List<PosCoupons> coupons = db.PosCoupons.Where(m => ids.Contains(m.Id) && m.IsUse == 1).ToList();
            foreach (PosCoupons coupon in coupons)
            {
                PosSns.Add(coupon.ExchangeCode);
            }
            foreach (PosCoupons coupon in coupons)
            {
                ChildNo(db, coupon.ExchangeCode, coupon.ExchangeCode, coupon.LeaderUserId);
            }
            // db.SaveChanges();
            db.Dispose();
            return "ok";
        }
        List<string> nos = new List<string>();
        private void ChildNo(WebCMSEntities db, string RootCheckNo, string CheckNo, int LeaderUserId)
        {
            MachineApply apply = db.MachineApply.FirstOrDefault(m => m.SwapSnExpand.Contains(CheckNo));
            if(apply != null)
            {
                int len = 0;
                string[] SnList = apply.SwapSnExpand.TrimEnd('\n').Split('\n');
                foreach(string sn in SnList)
                {
                    if(PosSns.Contains(sn.Split(':')[0]) || nos.Contains(sn.Split(':')[0]))
                    {
                        len += 1;
                    }
                }
                Orders order = db.Orders.FirstOrDefault(m => m.Id == apply.QueryCount);
                if(order != null)
                {
                    if(!string.IsNullOrEmpty(order.SnNos))
                    {
                        if(order.SnNos.Contains(","))
                        {
                            string[] SwapSnExpands = order.SnNos.TrimEnd(',').Split(',');
                            int index = 0;
                            foreach(string no in SwapSnExpands)
                            {
                                if(!nos.Contains(no) && index < len)
                                {
                                    index += 1;
                                    nos.Add(no);
                                    ChildNo(db, RootCheckNo, no, LeaderUserId);
                                }
                            }
                        }
                        else
                        {
                            string[] SwapSnExpands = order.SnNos.TrimEnd('\n').Split('\n');
                            int index = 0;
                            foreach(string no in SwapSnExpands)
                            {
                                if(!nos.Contains(no) && index < len)
                                {
                                    index += 1;
                                    nos.Add(no);
                                    ChildNo(db, RootCheckNo, no, LeaderUserId);
                                }
                            }
                        }
                    }
                    else
                    {
                        MachineForSnNo forSnNo = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == CheckNo) ?? new MachineForSnNo();
                        PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forSnNo.SnId);
                        if(pos != null)
                        {
                            // pos.LeaderUserId = LeaderUserId;
                            // Library.function.WriteLog(LeaderUserId + ":" + pos.PosSn + ":" + apply.SwapSnExpand.TrimEnd('\n').Split('\n').Length, "大盟主奖励标记机具");
                            Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
                            Library.function.WriteLog(pos.PosSn + ":" + RootCheckNo + ":" + user.MakerCode + ":" + user.RealName, "大盟主奖励标记机具");
                        }
                    }
                }
            }
            else
            {
                MachineForSnNo forSnNo = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == CheckNo) ?? new MachineForSnNo();
                PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m=>m.Id == forSnNo.SnId);
                if(pos != null)
                {
                    // pos.LeaderUserId = LeaderUserId;
                    // Library.function.WriteLog(LeaderUserId + ":" + pos.PosSn, "大盟主奖励标记机具");
                    Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new Users();
                    Library.function.WriteLog(pos.PosSn + ":" + RootCheckNo + ":" + user.MakerCode + ":" + user.RealName, "大盟主奖励标记机具");
                }
            }
        }
        List<string> PosSns = new List<string>();
        public string ScanNos()
        {
            PosSns = new List<string>();
            PosSns.Add("00005002681889125851");
            WebCMSEntities db = new WebCMSEntities();
            foreach(string PosSn in PosSns)
            {
                ChildNo(db, PosSn, PosSn, 0);
            }
            db.Dispose();
            return "ok";
        }
        



        public string test()
        {
            WebCMSEntities db = new WebCMSEntities();
            List<string> list = new List<string>();
            foreach(string sub in list)
            {
                string[] subData = sub.Split(';');
                string OrderNo = subData[0].Split(':')[1];
                int ToUserId = int.Parse(subData[1].Split(':')[1]);
                int UserId = int.Parse(subData[2].Split(':')[1]);
                decimal Amt = decimal.Parse(subData[3].Split(':')[1]);
                UserAccount account = db.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new UserAccount();
                if(account.BalanceAmount - account.FreezeAmount >= Amt)
                {
                    account.BalanceAmount -= Amt;
                    account.TotalAmount -= Amt;
                    Orders order = db.Orders.FirstOrDefault(m => m.OrderNo == OrderNo) ?? new Orders();
                    UserAccountRecord record = db.UserAccountRecord.FirstOrDefault(m => m.QueryCount == order.Id && m.ChangeType == 112 && m.ChangeAmount == Amt && m.UserId == UserId);
                    if(record != null)
                    {
                        record.UserId = ToUserId;
                        UserAccount toAccount = db.UserAccount.FirstOrDefault(m => m.Id == ToUserId);
                        if(toAccount != null)
                        {
                            toAccount.BalanceAmount += Amt;
                            toAccount.TotalAmount += Amt;
                            db.SaveChanges();

                            // //重置实发对象收支明细数据
                            // var oldrecord = db.UserAccountRecord.Where(m => m.Id < record.Id && m.UserId == UserId).OrderByDescending(m => m.Id).FirstOrDefault();
                            // if(oldrecord != null)
                            // {
                            //     decimal AfterBalanceAmount = oldrecord.AfterBalanceAmount;
                            //     decimal AfterTotalAmount = oldrecord.AfterTotalAmount;
                            //     decimal AfterFreezeAmount = oldrecord.AfterFreezeAmount;
                            //     var records = db.UserAccountRecord.Where(m => m.Id > oldrecord.Id && m.UserId == UserId).OrderBy(m => m.Id).ToList();
                            //     foreach(var subrecord in records)
                            //     {
                            //         UserAccountRecord edit = db.UserAccountRecord.FirstOrDefault(m => m.Id == subrecord.Id);
                            //         if(edit != null)
                            //         {
                            //             if(edit.BeforeBalanceAmount < edit.AfterBalanceAmount)
                            //             {
                            //                 edit.AfterBalanceAmount = AfterBalanceAmount + edit.ChangeAmount;
                            //             }
                            //             else
                            //             {
                            //                 edit.AfterBalanceAmount = AfterBalanceAmount - edit.ChangeAmount;
                            //             }

                            //             if(edit.BeforeTotalAmount < edit.AfterTotalAmount)
                            //             {
                            //                 edit.AfterTotalAmount = AfterTotalAmount + edit.ChangeAmount;
                            //             }
                            //             else
                            //             {
                            //                 edit.AfterTotalAmount = AfterTotalAmount - edit.ChangeAmount;
                            //             }

                            //             if(edit.BeforeFreezeAmount < edit.AfterFreezeAmount)
                            //             {
                            //                 edit.AfterFreezeAmount = AfterFreezeAmount + edit.ChangeAmount;
                            //             }
                            //             else
                            //             {
                            //                 edit.AfterFreezeAmount = AfterFreezeAmount - edit.ChangeAmount;
                            //             }
                            //             edit.BeforeBalanceAmount = AfterBalanceAmount;
                            //             edit.BeforeTotalAmount = AfterTotalAmount;
                            //             edit.BeforeFreezeAmount = AfterFreezeAmount;
                            //             db.SaveChanges();

                            //             AfterBalanceAmount = edit.AfterBalanceAmount;
                            //             AfterTotalAmount = edit.AfterTotalAmount;
                            //             AfterFreezeAmount = edit.AfterFreezeAmount;
                            //         }
                            //     }
                            // }

                            // //重置实发对象收支明细数据
                            // var torecord = db.UserAccountRecord.Where(m => m.Id < record.Id && m.UserId == ToUserId).OrderByDescending(m => m.Id).FirstOrDefault();
                            // if(torecord != null)
                            // {
                            //     record.BeforeBalanceAmount = torecord.AfterBalanceAmount;
                            //     record.BeforeTotalAmount = torecord.AfterTotalAmount;
                            //     record.BeforeFreezeAmount = torecord.AfterFreezeAmount;
                            //     record.AfterBalanceAmount = record.BeforeBalanceAmount + record.ChangeAmount;
                            //     record.AfterTotalAmount = record.BeforeTotalAmount + record.ChangeAmount;
                            //     record.AfterFreezeAmount = record.BeforeFreezeAmount + record.ChangeAmount;

                            //     decimal AfterBalanceAmount = record.AfterBalanceAmount;
                            //     decimal AfterTotalAmount = record.AfterTotalAmount;
                            //     decimal AfterFreezeAmount = record.AfterFreezeAmount;
                            //     var records = db.UserAccountRecord.Where(m => m.Id > torecord.Id && m.UserId == ToUserId).OrderBy(m => m.Id).ToList();
                            //     foreach(var subrecord in records)
                            //     {
                            //         UserAccountRecord edit = db.UserAccountRecord.FirstOrDefault(m => m.Id == subrecord.Id);
                            //         if(edit != null)
                            //         {
                            //             if(edit.BeforeBalanceAmount < edit.AfterBalanceAmount)
                            //             {
                            //                 edit.AfterBalanceAmount = AfterBalanceAmount + edit.ChangeAmount;
                            //             }
                            //             else
                            //             {
                            //                 edit.AfterBalanceAmount = AfterBalanceAmount - edit.ChangeAmount;
                            //             }

                            //             if(edit.BeforeTotalAmount < edit.AfterTotalAmount)
                            //             {
                            //                 edit.AfterTotalAmount = AfterTotalAmount + edit.ChangeAmount;
                            //             }
                            //             else
                            //             {
                            //                 edit.AfterTotalAmount = AfterTotalAmount - edit.ChangeAmount;
                            //             }

                            //             if(edit.BeforeFreezeAmount < edit.AfterFreezeAmount)
                            //             {
                            //                 edit.AfterFreezeAmount = AfterFreezeAmount + edit.ChangeAmount;
                            //             }
                            //             else
                            //             {
                            //                 edit.AfterFreezeAmount = AfterFreezeAmount - edit.ChangeAmount;
                            //             }
                            //             edit.BeforeBalanceAmount = AfterBalanceAmount;
                            //             edit.BeforeTotalAmount = AfterTotalAmount;
                            //             edit.BeforeFreezeAmount = AfterFreezeAmount;
                            //             db.SaveChanges();

                            //             AfterBalanceAmount = edit.AfterBalanceAmount;
                            //             AfterTotalAmount = edit.AfterTotalAmount;
                            //             AfterFreezeAmount = edit.AfterFreezeAmount;
                            //         }
                            //     }
                            // }

                            function.WriteLog(sub, "已执行日志");
                        }
                    }
                }
            }
            db.Dispose();
            return "ok";
        }

        public string setlee()
        {
            WebCMSEntities db = new WebCMSEntities();
            List<string> poslist = new List<string>();
            poslist.Add("00003102722201179816714");
            foreach(string PosSn in poslist)
            {
                PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == PosSn);
                if(pos != null)
                {
                    string info = "{\"RecordId\":\"\",\"PosId\":\"" + pos.Id + "\",\"Fee\": \"0.6\",\"Kind\": \"2\",\"OpMan\": \"系统\"}";
                    RedisDbconn.Instance.AddList("SetDepositPostQueue", info);
                }
            }
            db.Dispose();
            return "ok";
        }

        public string add()
        {
            DateTime now = DateTime.Now;
            WebCMSEntities db = new WebCMSEntities();
            List<string> poslist = new List<string>();
            foreach(string PosSn in poslist)
            {
                PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.PosSn == PosSn);
                if(pos != null)
                {
                    PxcModels.PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId);
                    if (merchant != null)
                    {
                        DateTime TransferTime = pos.TransferTime == null ? DateTime.Now : pos.TransferTime.Value;

                        //广电卡批量补盟主奖励和运营中心奖励
                        if (pos.BrandId == 14 && pos.BuyUserId > 0 && pos.ActivationState == 1 && TransferTime < pos.BindingTime && pos.BindingTime > now.AddDays(-30) && pos.CardType > 0 && pos.CardType < 100)
                        {
                            if(pos.LeaderUserId > 0 && db.Leaders.Any(m => m.Id == pos.LeaderUserId && m.ExpiredDate > now))
                            {
                                RedisDbconn.Instance.AddList("LeaderPrizeQueue", pos.Id);
                            }
                            RedisDbconn.Instance.AddList("OperatePrizeQueue", pos.Id);
                        }

                        //0押金返30的奖励批量补录
                        // if(pos.ActivationState == 1 && (string.IsNullOrEmpty(pos.SeoKeyword) || pos.SeoKeyword == "0") && pos.CreditTrade >= 5000 && pos.CardType < 100)
                        // {
                        //     Users user = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId);
                        //     if (user != null)
                        //     {
                        //         int GetUserId = user.Id;
                        //         string ParentNav = user.ParentNav;
                        //         int TopUserId = 0;
                        //         if (!string.IsNullOrEmpty(ParentNav))
                        //         {
                        //             TopUserId = int.Parse(ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
                        //         }
                        //         if(pos.BindingTime.Value.AddDays(30) >= pos.ActivationTime)
                        //         {
                        //             StatService.Instance.doActiveReward(db, merchant, pos, GetUserId, ParentNav, TopUserId, 30);
                        //             if(pos.LeaderUserId > 0 && db.Leaders.Any(m => m.Id == pos.LeaderUserId && m.ExpiredDate > now))
                        //             {
                        //                 RedisDbconn.Instance.AddList("LeaderPrizeQueue", pos.Id);
                        //             }
                        //             RedisDbconn.Instance.AddList("OperatePrizeQueue", pos.Id);
                        //         }
                        //     }
                        // }
                    }

                    //批量补服务费奖励
                    // if(decimal.Parse(function.CheckNum(pos.SeoKeyword)) > 0 && pos.CardType < 100)
                    // {
                    //     StatService.Instance.PreActPrize(db, pos, merchant, pos.SeoKeyword);
                    // }
                }
            }
            db.Dispose();
            return "ok";
        }

    
    
    
    
        //金控自备机，补商户信息
        public string jkmerinfo(string sn)
        {
            SpModels.WebCMSEntities spdb = new SpModels.WebCMSEntities();
            PxcModels.WebCMSEntities db = new PxcModels.WebCMSEntities();
            var Bind = spdb.BindRecord.FirstOrDefault(m => m.MerSnNo == sn && m.Field1 == "解绑");
            if (Bind != null)
            {
                PxcModels.MachineForSnNo posFor = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == Bind.MerSnNo) ?? new PxcModels.MachineForSnNo();
                PxcModels.PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == posFor.SnId);
                if (pos != null)
                {
                    pos.BindingState = 1;
                    pos.BindingTime = Bind.CreateTime;
                    pos.Status = 0;

                    PxcModels.MachineForMerNo merFor = db.MachineForMerNo.FirstOrDefault(m => m.MerNo == Bind.MerNo);
                    if (merFor == null)
                    {
                        merFor = db.MachineForMerNo.Add(new PxcModels.MachineForMerNo()
                        {
                            MerNo = Bind.MerNo,
                            SnId = pos.Id,
                        }).Entity;
                    }
                    else
                    {
                        merFor.SnId = pos.Id;
                    }
                    db.SaveChanges();

                    PxcModels.Users user = db.Users.FirstOrDefault(m => m.Id == pos.UserId) ?? new PxcModels.Users();
                    int TopUserId = 0;
                    if (!string.IsNullOrEmpty(user.ParentNav))
                    {
                        TopUserId = int.Parse(user.ParentNav.Trim(',').Replace(",,", ",").Split(',')[0]);
                    }
                    int BrandId = pos.BrandId;
                    
                    PxcModels.TradeRecord trade = db.TradeRecord.FirstOrDefault(m => m.SnNo == sn) ?? new PxcModels.TradeRecord();
                    PxcModels.PosMerchantInfo add = db.PosMerchantInfo.FirstOrDefault(m => m.KqMerNo == Bind.MerNo);
                    if (add == null)
                    {
                        if(trade.MerchantId > 0)
                        {
                            add = db.PosMerchantInfo.Add(new PxcModels.PosMerchantInfo()
                            {
                                CreateDate = Bind.CreateTime,
                                KqMerNo = Bind.MerNo,
                                MerchantNo = Bind.MerNo.Length > 16 ? Bind.MerNo.Substring(0, 16) : Bind.MerNo,
                                Id = trade.MerchantId,
                            }).Entity;
                            db.SaveChanges();
                        }
                        else
                        {
                            add = db.PosMerchantInfo.Add(new PxcModels.PosMerchantInfo()
                            {
                                CreateDate = Bind.CreateTime,
                                KqMerNo = Bind.MerNo,
                                MerchantNo = Bind.MerNo.Length > 16 ? Bind.MerNo.Substring(0, 16) : Bind.MerNo,
                            }).Entity;
                            db.SaveChanges();
                        }
                    }
                    add.UpdateDate = Bind.UpdateTime;
                    add.TopUserId = TopUserId;
                    add.BrandId = BrandId;
                    add.SnStoreId = pos.StoreId;
                    add.SnType = pos.PosSnType;
                    add.UserId = pos.UserId;
                    add.MerStatus = 1;
                    add.KqSnNo = Bind.MerSnNo;
                    add.MerIdcardNo = function.CheckNull(Bind.SeoKeyword).ToUpper();
                    add.MerRealName = Bind.MerName;
                    add.MerchantMobile = Bind.MerNewSnNo;
                    add.MerchantName = Bind.MerName;
                    pos.BindMerchantId = add.Id;
                    pos.LastMerchantId = add.Id;
                    db.SaveChanges();
                    RedisDbconn.Instance.AddList("DepositReturnStatQueue", add.Id.ToString());
                    PxcModels.Users buser = db.Users.FirstOrDefault(m => m.Id == pos.BuyUserId) ?? new PxcModels.Users();
                    if(buser.BusinessFlag == 1)
                    {
                        bool checkMer = db.BusinessPartnerMerchant.Any(m => m.MerchantId == add.Id);
                        if(!checkMer)
                        {
                            PxcModels.BusinessPartnerPos bpos = db.BusinessPartnerPos.FirstOrDefault(m => m.PosId == pos.Id) ?? new PxcModels.BusinessPartnerPos();
                            db.BusinessPartnerMerchant.Add(new PxcModels.BusinessPartnerMerchant()
                            {
                                CreateDate = DateTime.Now,
                                MerNo = Bind.MerNo,
                                MerchantId = add.Id,
                                PartnerId = bpos.PartnerId,
                                UserId = pos.BuyUserId,
                            });
                            db.SaveChanges();
                        }
                    }
                }
            }
            spdb.Dispose();
            db.Dispose();
            return "ok";
        }

        public string sycnTrade(int Id)
        {
            PxcModels.WebCMSEntities db = new PxcModels.WebCMSEntities();
            PosMerchantInfo merchant = db.PosMerchantInfo.FirstOrDefault(m => m.Id == Id);
            if(merchant != null)
            {
                DepositReturnStatService.Instance.DoSomething(db, merchant);
            }
            return "ok";
        }
    


        public string addprize()
        {
            List<int> ids = new List<int>();
            foreach(int id in ids)
            {
                RedisDbconn.Instance.AddList("LeaderPrizeQueue", id);
            }
            return "ok";
        }

        public string addprize2()
        {
            List<int> ids = new List<int>();
            foreach(int id in ids)
            {
                RedisDbconn.Instance.AddList("OperatePrizeQueue", id);
            }
            return "ok";
        }
    
    
        public string addprize3()
        {
            List<int> ids = new List<int>();
            foreach(int id in ids)
            {
                LeaderApplyCouponsHelper.Instance.addprize(id);
            }
            return "ok";
        }
    
    
    }
}