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