//public static Guid BatchId = new Guid();
public ActionResult Detail(string batchId)
{
Session["BatchId"] = batchId;
HttpCookie batcook = new HttpCookie("batcook", batchId);
batcook.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(batcook);
SerchCodeElement detail = new SerchCodeElement()
{
BatchId = new Guid(batchId),
PageSize = 50,
PageNumber = 1
};
var result = ThirdPartyExchangeCodeManage.SelectExchangCode(detail);
return(View(result));
}
public JsonResult SelectExchangCode(int pageSize, int pageNumber, int sort, DateTime?gainDateTime, bool?isEnabled, bool?isGain, int?outTime, int?onTime)
{
string Batch = "";
if (Session["BatchId"] == null)
{
Batch = Request.Cookies.Get("batcook")?.Value;
}
Batch = Session["BatchId"].ToString();
SerchCodeElement detail = new SerchCodeElement();
detail.BatchId = new Guid(Batch);
detail.PageNumber = pageNumber;
detail.PageSize = pageSize;
detail.Sort = sort;
detail.IsEnabled = isEnabled;
detail.IsGain = isGain;
if (outTime == 1)
{
detail.OutTime = DateTime.Now;
}
else
{
detail.OutTime = null;
}
if (outTime == 1)
{
detail.OnTime = DateTime.Now;
}
else
{
detail.OnTime = null;
}
var list = ThirdPartyExchangeCodeManage.SelectExchangCode(detail);
return(Json(list));
}
/// <summary>
/// 搜索兑换码批次信息
/// </summary>
/// <returns></returns>
public static List <Tuhu.Provisioning.DataAccess.Entity.ThirdPartyExchangeCode> SelectExchangCode(SerchCodeElement serchElement)
{
try
{
return(DalThirdPartyExchangeCode.SelectExchangCode(serchElement));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new ThirdPartyExchangerCodeException(1, "SelectExchangCode", ex);
Logger.Log(Level.Error, exception, "SelectExchangCode");
throw ex;
}
}
/// <summary>
/// 搜索兑换码批次信息
/// </summary>
/// <returns></returns>
public static List <ThirdPartyExchangeCode> SelectExchangCode(SerchCodeElement serchElement)
{
string sql1 = @"SELECT IsEnabled ,
IsGain ,
ExchangeCode ,
StartDateTime ,
EndDateTime ,
ImportDateTime ,
UserId ,
GainDateTime
FROM ( SELECT IsEnabled ,
IsGain ,
ExchangeCode ,
StartDateTime ,
EndDateTime ,
ImportDateTime ,
UserId ,
GainDateTime ,
";
string sql2 = @" FROM Configuration.dbo.ThirdPartyExchangeCodeConfig WITH ( NOLOCK )
WHERE ( @IsGain IS NULL--是否领取
OR IsGain = @IsGain
)
AND ( @OutTime IS NULL--已过期
OR EndDateTime < @OutTime
)
AND ( @OnTime IS NULL--未过期
OR EndDateTime > @OnTime
)
AND ( @IsEnabled IS NULL--是否禁用
OR IsEnabled = @IsEnabled
)
AND ( @BatchId IS NULL--批次ID
OR BatchGuid = @BatchId
)
) AS T
WHERE T.RowNumber BETWEEN ( ( @PageNumber - 1 ) * @PageSize + 1 )
AND ( @PageNumber * @PageSize );
";
string sqlSort = @" ROW_NUMBER() OVER ( ORDER BY ImportDateTime DESC ) AS RowNumber ";
#region 排序方式
switch (serchElement.Sort)
{
case 10: //兑换开始日期升序
sqlSort = @"ROW_NUMBER() OVER ( ORDER BY StartDateTime ) AS RowNumber ";
break;
case 11: //兑换开始日期降序
sqlSort = @"ROW_NUMBER() OVER ( ORDER BY StartDateTime DESC ) AS RowNumber ";
break;
case 20: //兑换结束日期升序
sqlSort = @"ROW_NUMBER() OVER ( ORDER BY EndDateTime ) AS RowNumber ";
break;
case 21: //兑换结束日期降序
sqlSort = @"ROW_NUMBER() OVER ( ORDER BY EndDateTime DESC ) AS RowNumber ";
break;
case 30: //创建日期升序
sqlSort = @"ROW_NUMBER() OVER ( ORDER BY ImportDateTime ) AS RowNumber ";
break;
case 31: //创建日期降序
sqlSort = @"ROW_NUMBER() OVER ( ORDER BY ImportDateTime DESC ) AS RowNumber ";
break;
case 40: //领取时间升序
sqlSort = @"ROW_NUMBER() OVER ( ORDER BY GainDateTime ) AS RowNumber ";
break;
case 41: //领取时间降序
sqlSort = @"ROW_NUMBER() OVER ( ORDER BY GainDateTime DESC ) AS RowNumber ";
break;
}
#endregion
var sqlParameters = new[]
{
new SqlParameter("@PageSize", serchElement.PageSize),
new SqlParameter("@PageNumber", serchElement.PageNumber),
new SqlParameter("@IsGain", serchElement.IsGain),
new SqlParameter("@OutTime", serchElement.OutTime),
new SqlParameter("@OnTime", serchElement.OnTime),
new SqlParameter("@IsEnabled", serchElement.IsEnabled),
new SqlParameter("@BatchId", serchElement.BatchId),
};
return
(SqlHelper.ExecuteDataTable(Connfig, CommandType.Text, sql1 + sqlSort + sql2, sqlParameters)
.ConvertTo <ThirdPartyExchangeCode>()
.ToList());
}
