kxs-main/AppStart/Helper/DepositReturnStatService.cs

using System;
using System.Collections.Generic;
using Library;
using LitJson;
using System.Linq;
using System.Data;
using System.Threading;
using MySystem.PxcModels;

namespace MySystem
{
    public class DepositReturnStatService
    {
        public readonly static DepositReturnStatService Instance = new DepositReturnStatService();
        private DepositReturnStatService()
        { }


        public void Start()
        {
            Thread th = new Thread(StartEverDay);
            th.IsBackground = true;
            th.Start();
        }

        public void StartEverDay()
        {
            while(true)
            {
                if(DateTime.Now.Day == 1 && DateTime.Now.Hour == 1)
                {
                    StartEverDayDo();
                }
                Thread.Sleep(60000);
            }
        }

        public void StartEverDayDo()
        {
            string Month = DateTime.Now.ToString("yyyyMM");
            string chk = function.ReadInstance("/DepositReturn/" + Month + ".txt");
            if(!string.IsNullOrEmpty(chk))
            {
                return;
            }
            function.WritePage("/DepositReturn/", Month + ".txt", DateTime.Now.ToString());
            WebCMSEntities db = new WebCMSEntities();
            int startid = int.Parse(function.CheckInt(function.ReadInstance("/DepositReturn/MerchantId.txt")));
            List<PosMerchantInfo> merchants = db.PosMerchantInfo.Where(m => m.Id > startid && m.StandardStatus == 0).OrderBy(m => m.Id).Take(50).ToList();
            foreach(PosMerchantInfo merchant in merchants)
            {
                if(merchant.ActiveStatus == 1)
                {
                    int StandardMonths = merchant.StandardMonths;
                    int StandardStatus = merchant.StandardStatus;
                    DateTime ActDate = merchant.MerStandardDate.Value;
                    int MonthNum = StandardMonths;
                    for (int i = StandardMonths + 1; i <= 10; i++)
                    {
                        string TradeMonth = ActDate.AddMonths(i).ToString("yyyyMM");
                        if(int.Parse(TradeMonth) < int.Parse(DateTime.Now.ToString("yyyyMM")))
                        {
                            decimal TradeAmount = 0;
                            bool CheckAmount = db.PosMerchantTradeSummay.Any(m => m.MerchantId == merchant.Id && m.TradeMonth == TradeMonth);
                            if(CheckAmount)
                            {
                                TradeAmount = db.PosMerchantTradeSummay.Where(m => m.MerchantId == merchant.Id && m.TradeMonth == TradeMonth).Sum(m => m.TradeAmount);
                            }
                            if(TradeAmount >= 10000)
                            {
                                MonthNum = i;
                            }
                            else
                            {
                                StandardStatus = -1;
                                break;
                            }
                        }
                    }
                    PosMerchantInfo edit = db.PosMerchantInfo.FirstOrDefault(m => m.Id == merchant.Id);
                    if(edit != null)
                    {
                        edit.StandardMonths = MonthNum;
                        edit.StandardStatus = StandardStatus;
                        db.Dispose();
                    }
                }
                startid = merchant.Id;
            }
            function.WritePage("/DepositReturn/", "MerchantId.txt", startid.ToString());
            db.Dispose();
        }
    }
}