public ActionResult GetCouponActivityConfigs(CouponActivityConfigPageRequestModel request) { var result = new BaoYangResultEntity <Tuple <int, List <CouponActivityConfigV2Model> > >() { Status = false }; if (request == null) { result.Msg = "参数验证失败"; return(Json(result)); } if (request.PageIndex <= 0) { request.PageIndex = 1; } if (request.PageSize <= 0) { request.PageSize = 10; } var manager = new CouponActivityConfigManagerV2(); result = manager.GetCouponActivityConfigs(request); return(Json(result)); }
/// <summary> /// 获取蓄电池/加油卡浮动配置分页列表 /// </summary> /// <param name="conn"></param> /// <param name="model"></param> /// <returns></returns> public static Tuple <int, List <CouponActivityConfigV2Model> > GetCouponActivityConfigs(SqlConnection conn, CouponActivityConfigPageRequestModel model) { int totalCount = 0; var sql = @"SELECT @totalCount = COUNT(1) FROM [Configuration].[dbo].[SE_CouponActivityConfig] AS a WHERE a.Type = @Type or @Type =0; SELECT A.[Id], [ActivityNum], [ActivityName], [ActivityStatus], [CheckStatus], [LayerImage], [CouponId], [ButtonChar], ActivityImage, A.GetRuleGUID, [CreateTime], A.Type, A.Channel, [UpdateTime] FROM [Configuration].[dbo].[SE_CouponActivityConfig] AS A WITH (NOLOCK) WHERE A.Type = @Type or @Type =0 ORDER BY A.[UpdateTime] DESC OFFSET (@PageIndex - 1) * @PageSize ROWS FETCH NEXT @PageSize ROWS ONLY;"; var parameters = new SqlParameter[] { new SqlParameter("@PageIndex", model.PageIndex), new SqlParameter("@PageSize", model.PageSize), new SqlParameter("@Type", model.Type), new SqlParameter("@totalCount", System.Data.SqlDbType.Int) { Direction = System.Data.ParameterDirection.Output } }; var configs = SqlHelper.ExecuteDataTable2(conn, CommandType.Text, sql, parameters).ConvertTo <CouponActivityConfigV2Model>().ToList(); int.TryParse(parameters.Last().Value.ToString(), out totalCount); return(Tuple.Create(totalCount, configs)); }
/// <summary> /// 获取蓄电池/加油卡浮动配置分页列表 /// </summary> /// <param name="request"></param> /// <returns></returns> public BaoYangResultEntity <Tuple <int, List <CouponActivityConfigV2Model> > > GetCouponActivityConfigs(CouponActivityConfigPageRequestModel request) { var result = new BaoYangResultEntity <Tuple <int, List <CouponActivityConfigV2Model> > >() { Status = false }; try { dbScopeManagerConfigurationRead.Execute(conn => { var tupleConfigs = DalCouponActivityConfigV2.GetCouponActivityConfigs(conn, request); if (tupleConfigs == null || !tupleConfigs.Item2.Any() || tupleConfigs.Item1 <= 0) { result.Status = true; result.Msg = "未查找到数据"; } else { var ChannelConfigs = DalCouponActivityConfigV2.GetChannelConfigs(conn, tupleConfigs.Item2.Select(x => x.Id).ToList()); var ChannelConfigDic = ChannelConfigs.GroupBy(x => x.ConfigId).Select(x => new { x.Key, x }).ToDictionary(k => k.Key, v => v.x); foreach (var item in tupleConfigs.Item2) { item.Channels = item.Channel == null ? new List <string>() : item.Channel.Split(',').ToList(); if (ChannelConfigDic.ContainsKey(item.Id)) { item.ChannelConfigs = ChannelConfigDic[item.Id].ToList(); } } result.Status = true; result.Data = tupleConfigs; } }); } catch (Exception ex) { result.Status = false; result.Msg = "程序遇见错误,请联系管理员"; Logger.Error("GetCouponActivityConfigs", ex); } return(result); }