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