using MySystem.Models.Main; using Library; using MySystem.Service.Main; using System.Collections.Generic; using System; namespace MySystem { /// /// 商户业绩统计工具类 /// public class MerchantAmountSummayUtil { #region 已激活商户-达标信息列表 /// /// 已激活商户-达标信息列表 /// /// 商户Id /// 条数 /// 页数 /// public static List> ListDo(int MerchantId, int PageSize, int PageNum) { List> dataList = new List>(); var query = MerchantDepositOrderService.Query(" and Status=1 and MerchantId=" + MerchantId + ""); var Status = 0;//活动交易状态 var IsJoin = 0;//是否参加活动(0 否 1 是) if (query.Id == 0) IsJoin = 1; var month = DateTime.Parse(query.CreateDate.ToString()); var TradeMonth = ""; decimal TradeAmount = 0.00M; Dictionary dic = new Dictionary(); for (int i = 0; i < 10; i++) { month = month.AddMonths(i + 1); TradeMonth = month.ToString("yyyy-MM"); var check = MerchantAmountSummayService.Query(" and IsAct=1 and TradeMonth='" + TradeMonth + "' and MerchantId=" + MerchantId + ""); if (check.Id > 0) { dic = MerchantAmountSummayService.Sum("TradeAmount", " and IsAct=1 and TradeMonth='" + TradeMonth + "'"); TradeAmount = decimal.Parse(dic["TradeAmount"].ToString()); } if (IsJoin == 0) { //未参与 Status = 3; } else { //考核中 if (DateTime.Now.ToString("yyyy-MM") == TradeMonth) Status = 1; //待考核 if (int.Parse(DateTime.Now.ToString("yyyyMM")) < int.Parse(month.ToString("yyyyMM"))) Status = 0; //已通过 if (TradeAmount >= 10000 && IsJoin != 3 && check.Id > 0) Status = 2; //未通过 if (TradeAmount < 10000 && IsJoin != 3 && check.Id > 0) Status = -1; Dictionary curData = new Dictionary(); curData.Add("TradeMonth", TradeMonth); //月份 curData.Add("TradeAmount", TradeAmount); //订单金额 curData.Add("Status", Status); //状态(-1 未通过 0 待考核 1 考核中 2 已通过 3 未参与) dataList.Add(curData); } } return dataList; } #endregion } }