/// <summary> /// 获取砍价列表 /// </summary> /// <param name="request"></param> /// <returns></returns> public PartialViewResult ShareBargainList(BargainProductRequest request) { var pager = new Component.Common.Models.PagerModel(request.PageIndex, request.PageSize); ViewBag.request = request; var data = ShareBargainManager.SelectBargainProductList(request, pager); return(PartialView(new ListModel <ShareBargainItemModel>() { Pager = pager, Source = data })); }
public static IEnumerable <ShareBargainItemModel> SelectBargainProductList(BargainProductRequest request, PagerModel pager) { string sql = @"SELECT PKID , PID , productName AS ProductName , CurrentStockCount , FinalPrice , BeginDateTime , EndDateTime , Operator , ShowBeginTime , ProductType FROM Configuration..BargainProduct WITH ( NOLOCK ) WHERE IsDelete=0 AND ( @Operator IS NULL OR Operator = @Operator ) AND ( @PID IS NULL OR PID LIKE '%' + @PID + '%' ) AND ( @ProductName IS NULL OR ProductName LIKE '%' + @ProductName + '%' ) AND ( @OnSale = 0 OR ( @OnSale = 1 AND BeginDateTime < GETDATE() AND EndDateTime > GETDATE() ) OR ( @OnSale = 2 AND EndDateTime < GETDATE() ) OR ( @OnSale = 3 AND BeginDateTime > GETDATE() ) ) ORDER BY CreateDateTime DESC OFFSET @begin ROWS FETCH NEXT @step ROWS ONLY; "; pager.TotalItem = SelectBargainProductCount(request); using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Gungnir"))) { var sqlPrams = new SqlParameter[] { new SqlParameter("@Operator", request.Operator), new SqlParameter("@PID", request.PID), new SqlParameter("@ProductName", request.ProductName), new SqlParameter("@OnSale", request.OnSale), new SqlParameter("@begin", (request.PageIndex - 1) * request.PageSize), new SqlParameter("@step", request.PageSize), }; return(dbHelper.ExecuteDataTable(sql, CommandType.Text, sqlPrams).ConvertTo <ShareBargainItemModel>()); } }
private static int SelectBargainProductCount(BargainProductRequest request) { using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Gungnir"))) { var sqlPrams = new SqlParameter[] { new SqlParameter("@Operator", request.Operator), new SqlParameter("@PID", request.PID), new SqlParameter("@ProductName", request.ProductName), new SqlParameter("@OnSale", request.OnSale), }; return(Convert.ToInt32(dbHelper.ExecuteScalar(ShareBargainSqlText.sql4selectBargainProductCount, CommandType.Text, sqlPrams))); } }
public static IEnumerable <ShareBargainItemModel> SelectBargainProductList(BargainProductRequest request, PagerModel pager) { pager.TotalItem = SelectBargainProductCount(request); using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Gungnir"))) { var sqlPrams = new SqlParameter[] { new SqlParameter("@Operator", request.Operator), new SqlParameter("@PID", request.PID), new SqlParameter("@ProductName", request.ProductName), new SqlParameter("@OnSale", request.OnSale), new SqlParameter("@begin", (request.PageIndex - 1) * request.PageSize), new SqlParameter("@step", request.PageSize), }; return(dbHelper.ExecuteDataTable(ShareBargainSqlText.sql4selectBargainProductList, CommandType.Text, sqlPrams).ConvertTo <ShareBargainItemModel>()); } }
/// <summary> /// 获取活动的操作日志列表 /// </summary> /// <param name="activityId"></param> /// <returns></returns> public ActionResult ShareBargainLogList(BargainProductRequest request) { if (string.IsNullOrEmpty(request.PID)) { request.PID = Request.QueryString["PKID"]; } ViewBag.request = request; var result = new PagedModel <SalePromotionActivityLogModel>(); using (var client = new SalePromotionActivityLogClient()) { var listResult = client.GetOperationLogList(request.PID, request.PageIndex, request.PageSize); if (listResult.Success && listResult.Result != null) { result = listResult.Result; } } ViewBag.pageSize = request.PageSize; ViewBag.pageIndex = request.PageIndex; ViewBag.totalRecords = result.Pager.Total; ViewBag.totalPage = result.Pager.Total % request.PageSize == 0 ? result.Pager.Total / request.PageSize : (result.Pager.Total / request.PageSize) + 1; return(View(result.Source)); }
public static IEnumerable <ShareBargainItemModel> SelectBargainProductList(BargainProductRequest request, PagerModel pager) => DALShareBargain.SelectBargainProductList(request, pager);