/// <summary>
/// 根据条件获取活动总数
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static async Task <int> TotalActivity(PageLuckyCharmActivityRequest model)
{
string sql = @"select count(1) from Activity.dbo.T_LuckyCharmActivity WITH (NOLOCK) {0}";
var parameters = new Dictionary <string, object>();
if (model.PKID > 0)
{
parameters.Add("PKID", model.PKID);
}
StringBuilder condition = new StringBuilder("where IsDelete=0 ");
foreach (var key in parameters.Keys)
{
condition.AppendFormat("and {0}=@{1} ", key, key);
}
using (var cmd = new SqlCommand(string.Format(sql, condition.ToString())))
{
foreach (var key in parameters.Keys)
{
cmd.AddParameter(string.Format("@{0}", key), parameters[key]);
}
int.TryParse((await DbHelper.ExecuteScalarAsync(true, cmd)).ToString(), out int result);
return(result);
}
}
/// <summary>
/// 根据条件分页获取锦鲤活动的列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static async Task <List <LuckyCharmActivityModel> > PageActivity(PageLuckyCharmActivityRequest model)
{
//string sql = @"select top @pageSize * from (select row_number() over(order by PKID asc) as rownumber,*
//from Activity.dbo.T_LuckyCharmUser WITH (NOLOCK) {0})temp_row where rownumber>10";
string sql = @"select * from Activity.dbo.T_LuckyCharmActivity WITH (NOLOCK) {0} ORDER BY PKID DESC
OFFSET (@PageIndex - 1) * @PageSize ROW
FETCH NEXT @PageSize ROW ONLY" ;
var parameters = new Dictionary <string, object>();
if (model.PKID > 0)
{
parameters.Add("PKID", model.PKID);
}
StringBuilder condition = new StringBuilder("where IsDelete=0 ");
foreach (var key in parameters.Keys)
{
condition.AppendFormat("and {0}=@{1} ", key, key);
}
using (var cmd = new SqlCommand(string.Format(sql, condition.ToString())))
{
foreach (var key in parameters.Keys)
{
cmd.AddParameter(string.Format("@{0}", key), parameters[key]);
}
cmd.AddParameter("@PageSize", model.PageSize);
cmd.AddParameter("@PageIndex", model.PageIndex);
var result = await DbHelper.ExecuteSelectAsync <LuckyCharmActivityModel>(true, cmd);
return(result?.ToList());
}
}
/// <summary>
/// 分页获取活动
/// </summary>
/// <returns></returns>
public PageLuckyCharmActivityModel PageActivtiy(int pageIndex, int pageSize, int pkid)
{
var result = new PageLuckyCharmActivityModel()
{
Activitys = new List <LuckyCharmActivityModel>()
};
try
{
using (var client = new LuckyCharmClient())
{
var request = new PageLuckyCharmActivityRequest()
{
PKID = pkid,
PageIndex = pageIndex,
PageSize = pageSize,
};
var users = client.PageLuckyCharmActivity(request);
if (users.Success)
{
result.Total = users.Result.Total;
foreach (var item in users.Result.Activitys)
{
result.Activitys.Add(new LuckyCharmActivityModel()
{
PKID = item.PKID,
ActivityDes = item.ActivityDes,
ActivityTitle = item.ActivityTitle,
ActivitySlug = item.ActivitySlug,
StarTime = item.StarTime,
EndTime = item.EndTime,
});
}
}
}
}
catch (Exception e)
{
Logger.Error($"PageActivtiy -> {pageIndex}-{pageSize}-{pkid}", e);
throw;
}
return(result);
}
public async Task <OperationResult <PageLuckyCharmActivityResponse> > PageLuckyCharmActivityAsync(PageLuckyCharmActivityRequest request)
{
return(await LuckyCharmManager.PageActivityActivityAsync(request));
}
public static async Task <OperationResult <PageLuckyCharmActivityResponse> > PageActivityActivityAsync(PageLuckyCharmActivityRequest model)
{
if (model.PageIndex < 1)
{
model.PageIndex = 1;
}
if (model.PageSize <= 0)
{
model.PageSize = 10;
}
var act = await DalLuckyCharm.PageActivity(model);
var total = await DalLuckyCharm.TotalActivity(model);
var result = new PageLuckyCharmActivityResponse();
result.Activitys = Mapper.Map <List <LuckyCharmActivityInfoResponse> >(act);
result.Total = total;
return(OperationResult.FromResult(result));
}
