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