/// <summary> /// 兑换的生意专家和实物商品的比例 /// </summary> /// <param name="stDate"></param> /// <param name="edDate"></param> /// <returns></returns> public List <IntPie> GetGoodsType(DateTime stDate, DateTime edDate) { List <IntPie> dic = new List <IntPie>(); IntPie entity = new IntPie("实物产品", 0); IntPie notEntity = new IntPie("生意专家产品", 0); IntegralStore.StoreProject storeModel = new IntegralStore.StoreProject(); List <string> entityProduct = new List <string>(); for (int i = 1; i < 36; i++) { if (storeModel.GetModel(i) != null) { if (storeModel.GetModel(i).isEntity == 1) { entityProduct.Add(storeModel.GetModel(i).ProjectName); } } } List <IntPie> rawData = GetExRatio(stDate, edDate); if (rawData != null) { foreach (IntPie item in rawData) { if (entityProduct.Contains(item.Name)) { entity.Value += item.Value; } else { notEntity.Value += item.Value; } } dic.Add(entity); dic.Add(notEntity); return(dic); } return(null); }
/// <summary> /// 生成新的积分商城统计信息 /// </summary> /// <param name="dayDate"></param> /// <returns></returns> public IntegralExchangeModel GenerateNewDailyModel(DateTime dayDate) { StringBuilder strSql = new StringBuilder(); IntegralExchangeModel exchangeModel = new IntegralExchangeModel(); exchangeModel.DayTime = dayDate; IntegralStore.StoreProject storeModel = new IntegralStore.StoreProject(); //Sys_DailyIntegralExchange updateModel = new Sys_DailyIntegralExchange(); int productCount = 0; for (int i = 1; i < 36; i++) { strSql.Clear(); Sys_DailyIntegralExchange updateModel = new Sys_DailyIntegralExchange(); if (storeModel.GetModel(i) != null) { updateModel.DayDate = dayDate; updateModel.ProductName = storeModel.GetModel(i).ProjectName; strSql.Append( "select count(*) from i200.dbo.T_ExchangeLog where DateDiff(day,eInsertTime,@dayDate)=0 and eProjectName=@productName;"); productCount = DapperHelper.ExecuteScalar <int>(strSql.ToString(), new { dayDate = dayDate, productName = updateModel.ProductName }); updateModel.ExchangeNum = productCount; updateModel.VisitNum = 0; updateModel.Ratio = 0; updateModel.ProductId = i; exchangeModel.DataList.Add(updateModel); } } return(exchangeModel); }