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);
}
