/// <summary>
/// 分页获取数据信息
/// </summary>
/// <param name="pagIndex"></param>
/// <param name="acount"></param>
/// <param name="name"></param>
/// <returns></returns>
public string GetInfoPagList(int pagIndex, string userName, string buildNum, string amountType)
{
try
{
//// 实现步骤
//// 1、首先获取符号要求的数据总条数
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
//// 3、获取具体的分页数据信息
MPageListResult <MTFCEvidenceInfor> pageListResult = new MPageListResult <MTFCEvidenceInfor>();
//// 每页获取20条数据
int pagSize = 50;
//// 1、首先获取符号要求的数据总条数
TFCEvidenceInforService service = new TFCEvidenceInforService();
pageListResult.totalNum = service.GetInfoPagCount(userName, buildNum, amountType);
if (pageListResult.totalNum > 0)
{
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
pageListResult.totalPage = (int)Math.Ceiling((double)pageListResult.totalNum / pagSize);
pagIndex = pagIndex > pageListResult.totalPage ? pageListResult.totalPage : pagIndex;
//// 3、获取具体的分页数据信息
pageListResult.dataList = service.GetInfoPagList(pagIndex, pagSize, userName, buildNum, amountType);
if (pageListResult.dataList != null && pageListResult.dataList.Count > 0)
{
decimal totalPay = 0M;
//// 对数据做一个加工，验证重复提交的数据
for (int i = 0; i < pageListResult.dataList.Count; i++)
{
pageListResult.dataList[i].samDataNum = pageListResult.dataList.FindAll(P => P.roomNum == pageListResult.dataList[i].roomNum && P.buildNum == pageListResult.dataList[i].buildNum).Count;
totalPay += pageListResult.dataList[i].payAmount;
}
//// 做一个数据汇总
pageListResult.dataList.Add(new MTFCEvidenceInfor()
{
Id = "-1",
payAmount = totalPay,
userName = "******"
});
}
}
pageListResult.pagIndex = pagIndex;
pageListResult.pagSize = pagSize;
return(JsonHelper.GetJson <MPageListResult <MTFCEvidenceInfor> >(pageListResult));
}
catch (Exception)
{
return(string.Empty);
}
}
/// <summary>
/// 分页获取订单数据信息
/// </summary>
/// <param name="pagIndex"></param>
/// <param name="userId"></param>
/// <param name="orderState"></param>
/// <param name="productname"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public string GetOrderInfoPagList(int pagIndex, string userId, string userName,
int orderState, string productname, string startTime, string endTime, string groupOrderId, string orderId)
{
try
{
LogOpert.AddWeiXinMessage("获取订单列表：" + userId);
//// 实现步骤
//// 1、首先获取符号要求的数据总条数
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
//// 3、获取具体的分页数据信息
MPageListResult <Morder> pageListResult = new MPageListResult <Morder>();
//// 每页获取20条数据
int pagSize = 20;
//// 1、首先获取符号要求的数据总条数
OrderService orderService = new OrderService();
if (!string.IsNullOrEmpty(endTime))
{
endTime = Convert.ToDateTime(endTime).AddDays(1).ToString("yyyy-MM-dd");
}
pageListResult.totalNum = orderService.GetOrderInfoPagCount(userId, userName, orderState,
productname, startTime, endTime, groupOrderId, orderId);
if (pageListResult.totalNum > 0)
{
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
pageListResult.totalPage = (int)Math.Ceiling((double)pageListResult.totalNum / pagSize);
pagIndex = pagIndex > pageListResult.totalPage ? pageListResult.totalPage : pagIndex;
//// 3、获取具体的分页数据信息
pageListResult.dataList = orderService.GetOrderInfoPagList(pagIndex, pagSize, userId, userName, orderState,
productname, startTime, endTime, groupOrderId, orderId);
}
pageListResult.pagIndex = pagIndex;
pageListResult.pagSize = pagSize;
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
};
return(JsonConvert.SerializeObject(pageListResult, Formatting.Indented, timeConverter));
}
catch (Exception ex)
{
return(string.Empty);
}
}
/// <summary>
/// 根据用户ID获取所有推荐商品，并根据其购物车组装对应的购买信息
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public string GetRecommentProductListAndCarInfor(string userid)
{
MPageListResult <Mproduct> pageListResult = new MPageListResult <Mproduct>();
// 所有推荐商品
if (CacheData.allRecommendProList != null &&
CacheData.allRecommendProList.Count > 0)
{
pageListResult.dataList =
JsonHelper.ParseFormJson <List <Mproduct> >(
JsonHelper.GetJson <List <Mproduct> >(CacheData.allRecommendProList));
List <MshoppingCart> listShoppingCart = null;
if (!string.IsNullOrEmpty(userid))
{
// 获取用户的所有购物车详情
listShoppingCart = new ShoppingCartBus().GetAllShoppingCartListBySserId(userid);
}
//
MshoppingCart thisMshoppingCart = null;
if (pageListResult.dataList != null && pageListResult.dataList.Count > 0)
{
foreach (var item in pageListResult.dataList)
{
thisMshoppingCart = listShoppingCart == null ? null : listShoppingCart.Find(x => x.productId == item.productid);
if (thisMshoppingCart == null || string.IsNullOrEmpty(thisMshoppingCart.productId))
{
item.hassellnum = 0;
}
else
{
item.hassellnum = thisMshoppingCart.buyNum;
}
}
}
}
return(JsonHelper.GetJson <MPageListResult <Mproduct> >(pageListResult));
}
/// <summary>
/// 分页获取信息
/// </summary>
/// <param name="pagIndex"></param>
/// <param name="pagCount"></param>
/// <returns></returns>
public string GetPagList(string userId, int isUse, int pagIndex, int pagCount)
{
try
{
UserCouponService opert = new UserCouponService();
//// 实现步骤
//// 1、首先获取符号要求的数据总条数
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
//// 3、获取具体的分页数据信息
MPageListResult <Musercoupon> pageListResult = new MPageListResult <Musercoupon>();
//// 每页获取20条数据
int pagSize = 20;
pageListResult.totalNum = opert.GetPagCount(userId, isUse);
if (pageListResult.totalNum > 0)
{
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
pageListResult.totalPage = (int)Math.Ceiling((double)pageListResult.totalNum / pagSize);
pagIndex = pagIndex > pageListResult.totalPage ? pageListResult.totalPage : pagIndex;
//// 3、获取具体的分页数据信息
pageListResult.dataList = opert.GetPagList(userId, isUse, pagIndex, pagSize);
}
pageListResult.pagIndex = pagIndex;
pageListResult.pagSize = pagSize;
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
};
return(JsonConvert.SerializeObject(pageListResult, Formatting.Indented, timeConverter));
}
catch (Exception ex)
{
return(string.Empty);
}
}
/// <summary>
/// 获取产品分页数据
/// </summary>
/// <param name="pagIndex"></param>
/// <param name="productname"></param>
/// <param name="shelfstate"></param>
/// <returns></returns>
public string GetProductcListBySupClassId(int pagIndex, int supClassid,
int shelfstate, int recommend, string keyValues, int classid = -1)
{
try
{
//// 实现步骤
//// 1、首先获取符号要求的数据总条数
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
//// 3、获取具体的分页数据信息
MPageListResult <Mproduct> pageListResult = new MPageListResult <Mproduct>();
//// 每页获取20条数据
int pagSize = 1000;
//// 1、首先获取符号要求的数据总条数
ProductService productService = new ProductService();
pageListResult.totalNum = productService.GetProductPagCount(classid, supClassid, keyValues, shelfstate, recommend);
if (pageListResult.totalNum > 0)
{
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
pageListResult.totalPage = (int)Math.Ceiling((double)pageListResult.totalNum / pagSize);
if (pagIndex <= pageListResult.totalPage)
{
//// 3、获取具体的分页数据信息
pageListResult.dataList = productService.GetProductPagList(pagIndex, pagSize, classid, supClassid, keyValues, shelfstate, recommend);
}
}
pageListResult.pagIndex = pagIndex;
pageListResult.pagSize = pagSize;
return(JsonHelper.GetJson <MPageListResult <Mproduct> >(pageListResult));
}
catch (Exception ex)
{
return(string.Empty);
}
}
/// <summary>
/// 获取产品分页数据
/// </summary>
/// <param name="pagIndex"></param>
/// <param name="productname"></param>
/// <param name="shelfstate"></param>
/// <returns></returns>
public string GetProductcList(int pagIndex, string productname, int shelfstate, int recommend, int type, int superClassid = -1)
{
try
{
//// 实现步骤
//// 1、首先获取符号要求的数据总条数
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
//// 3、获取具体的分页数据信息
MPageListResult <Mproduct> pageListResult = new MPageListResult <Mproduct>();
//// 每页获取20条数据
int pagSize = 20;
//// 1、首先获取符号要求的数据总条数
ProductService productService = new ProductService();
type = type > 0 ? type : -1;
pageListResult.totalNum = productService.GetProductPagCount(type, superClassid, productname, shelfstate, recommend);
if (pageListResult.totalNum > 0)
{
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
pageListResult.totalPage = (int)Math.Ceiling((double)pageListResult.totalNum / pagSize);
pagIndex = pagIndex > pageListResult.totalPage ? pageListResult.totalPage : pagIndex;
//// 3、获取具体的分页数据信息
pageListResult.dataList = productService.GetProductPagList(pagIndex, pagSize, -1, superClassid, productname, shelfstate, recommend);
}
pageListResult.pagIndex = pagIndex;
pageListResult.pagSize = pagSize;
return(JsonHelper.GetJson <MPageListResult <Mproduct> >(pageListResult));
}
catch (Exception ex)
{
return(string.Empty);
}
}
/// <summary>
/// 分页获取微信用户数据信息
/// </summary>
/// <param name="pagIndex"></param>
/// <param name="acount"></param>
/// <param name="name"></param>
/// <returns></returns>
public string GetUserListPage(int pagIndex, string nickname, string subscribe)
{
try
{
//// 实现步骤
//// 1、首先获取符号要求的数据总条数
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
//// 3、获取具体的分页数据信息
MPageListResult <MWXUserInfo> pageListResult = new MPageListResult <MWXUserInfo>();
//// 每页获取20条数据
int pagSize = 20;
//// 1、首先获取符号要求的数据总条数
WXuserService opertService = new WXuserService();
pageListResult.totalNum = opertService.GetWXUserInfoPagCount(nickname, subscribe);
if (pageListResult.totalNum > 0)
{
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
pageListResult.totalPage = (int)Math.Ceiling((double)pageListResult.totalNum / pagSize);
pagIndex = pagIndex > pageListResult.totalPage ? pageListResult.totalPage : pagIndex;
//// 3、获取具体的分页数据信息
pageListResult.dataList = opertService.GetWXUserInfoPagList(pagIndex, pagSize, nickname, subscribe);
}
pageListResult.pagIndex = pagIndex;
pageListResult.pagSize = pagSize;
return(JsonHelper.GetJson <MPageListResult <MWXUserInfo> >(pageListResult));
}
catch (Exception ex)
{
return(string.Empty);
}
}
/// <summary>
/// 分页获取 送货员 数据信息
/// </summary>
/// <param name="pagIndex"></param>
/// <param name="acount"></param>
/// <param name="name"></param>
/// <returns></returns>
public string GetSndGoodsUserListPage(int pagIndex, string phone, string userName)
{
try
{
//// 实现步骤
//// 1、首先获取符号要求的数据总条数
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
//// 3、获取具体的分页数据信息
MPageListResult <MsendGoodsUser> pageListResult = new MPageListResult <MsendGoodsUser>();
//// 每页获取20条数据
int pagSize = 20;
//// 1、首先获取符号要求的数据总条数
SndGoodsUserService sndGoodsUserService = new SndGoodsUserService();
pageListResult.totalNum = sndGoodsUserService.GetSndGoodsUserPagCount(phone, userName);
if (pageListResult.totalNum > 0)
{
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
pageListResult.totalPage = (int)Math.Ceiling((double)pageListResult.totalNum / pagSize);
pagIndex = pagIndex > pageListResult.totalPage ? pageListResult.totalPage : pagIndex;
//// 3、获取具体的分页数据信息
pageListResult.dataList = sndGoodsUserService.GetSendGoodsUserPagList(pagIndex, pagSize, phone, userName);
}
pageListResult.pagIndex = pagIndex;
pageListResult.pagSize = pagSize;
return(JsonHelper.GetJson <MPageListResult <MsendGoodsUser> >(pageListResult));
}
catch (Exception)
{
return(string.Empty);
}
}
/// <summary>
/// 分页获取管理员数据信息
/// </summary>
/// <param name="pagIndex"></param>
/// <param name="acount"></param>
/// <param name="name"></param>
/// <returns></returns>
public string GetAdminUserListPage(int pagIndex, string acount, string name)
{
try
{
//// 实现步骤
//// 1、首先获取符号要求的数据总条数
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
//// 3、获取具体的分页数据信息
MPageListResult <Madminuser> pageListResult = new MPageListResult <Madminuser>();
//// 每页获取20条数据
int pagSize = 20;
//// 1、首先获取符号要求的数据总条数
AdminuserService adminuserService = new AdminuserService();
pageListResult.totalNum = adminuserService.GetAdminUserInfoPagCount(acount, name);
if (pageListResult.totalNum > 0)
{
//// 2、根据获取到数据条数、每页数据量、页码。优化处理页面
pageListResult.totalPage = (int)Math.Ceiling((double)pageListResult.totalNum / pagSize);
pagIndex = pagIndex > pageListResult.totalPage ? pageListResult.totalPage : pagIndex;
//// 3、获取具体的分页数据信息
pageListResult.dataList = adminuserService.GetAdminUserInfoPagList(pagIndex, pagSize, acount, name);
}
pageListResult.pagIndex = pagIndex;
pageListResult.pagSize = pagSize;
return(JsonHelper.GetJson <MPageListResult <Madminuser> >(pageListResult));
}
catch (Exception)
{
return(string.Empty);
}
}
