/// <summary> /// 获取协议操作历史记录 /// </summary> /// <param name="searchParas"></param> /// <param name="para"></param> /// <returns></returns> public JsonResult GetRedPacketHistoryList(Search_RedPacketHistory searchParas, GridParams para) { para.pagenum = para.pagenum + 1;//页0,+1 var list = _redPacketLogic.GetRedPacketHistoryList(searchParas, para); return(Json(list, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 根据搜索条件获取企业付款历史 /// </summary> /// <param name="searchParas">搜索条件</param> /// <param name="para">页码信息</param> /// <returns></returns> public JsonResultModel <v_Business_Redpacket_Push_Information> GetPaymentInfos(Search_RedPacketHistory searchParas, GridParams para) { var jsonResult = new JsonResultModel <v_Business_Redpacket_Push_Information>(); using (var db = SugarDao_MsSql.GetInstance()) { var query = db.Queryable <Business_Enterprisepayment_Information>().JoinTable <Business_Personnel_Information>((s1, s2) => s1.UserID == s2.UserID); if (!string.IsNullOrEmpty(searchParas.Name)) { query.Where <Business_Personnel_Information>((s1, s2) => s2.Name.Contains(searchParas.Name)); } if (!string.IsNullOrEmpty(searchParas.UserID)) { query.Where(s1 => s1.UserID.Contains(searchParas.UserID)); } if (searchParas.RedpacketStatus != null) { query.Where(s1 => s1.RedpacketStatus == searchParas.RedpacketStatus); } if (searchParas.ReceiveDateFrom != null && searchParas.ReceiveDateTo == null) { query.Where(s1 => s1.CreatedDate >= searchParas.ReceiveDateFrom); } if (searchParas.ReceiveDateFrom == null && searchParas.ReceiveDateTo != null) { query.Where(s1 => s1.CreatedDate <= searchParas.ReceiveDateTo); } if (searchParas.ReceiveDateFrom != null && searchParas.ReceiveDateTo != null) { query.Where(s1 => s1.CreatedDate >= searchParas.ReceiveDateFrom && s1.CreatedDate <= searchParas.ReceiveDateTo); } query.OrderBy(s1 => s1.CreatedDate, OrderByType.Desc); jsonResult.TotalRows = query.Count(); jsonResult.Rows = query.Select <Business_Enterprisepayment_Information, Business_Personnel_Information, v_Business_Redpacket_Push_Information> ((s1, s3, s2) => new v_Business_Redpacket_Push_Information { UserID = s1.UserID, Name = s2.Name, RedpacketMoney = s1.RedpacketMoney, RedpacketStatus = s1.RedpacketStatus, CreatedDate = s1.CreatedDate, Reson = s1.Reson, VGUID = s1.VGUID }).ToPageList(para.pagenum, para.pagesize); } return(jsonResult); }
/// <summary> /// 根据搜索条件获取红包领取记录历史 /// </summary> /// <param name="searchParas"></param> /// <param name="para"></param> /// <returns></returns> public JsonResultModel <v_Business_Redpacket_Push_Information> GetRedPacketHistoryList(Search_RedPacketHistory searchParas, GridParams para) { GetRedPacketInfo(); var jsonResult = new JsonResultModel <v_Business_Redpacket_Push_Information>(); using (var db = SugarDao_MsSql.GetInstance()) { var query = db.Queryable <v_Business_Redpacket_Push_Information>(); if (!string.IsNullOrEmpty(searchParas.Name)) { query.Where(i => i.Name.Contains(searchParas.Name)); } if (!string.IsNullOrEmpty(searchParas.UserID)) { query.Where(i => i.UserID.Contains(searchParas.UserID)); } if (searchParas.RedpacketStatus != null) { query.Where(i => i.RedpacketStatus == searchParas.RedpacketStatus); } if (searchParas.ReceiveDateFrom != null && searchParas.ReceiveDateTo == null) { query.Where(i => i.ReceiveDate >= searchParas.ReceiveDateFrom); } if (searchParas.ReceiveDateFrom == null && searchParas.ReceiveDateTo != null) { query.Where(i => i.ReceiveDate <= searchParas.ReceiveDateTo); } if (searchParas.ReceiveDateFrom != null && searchParas.ReceiveDateTo != null) { query.Where(i => i.ReceiveDate >= searchParas.ReceiveDateFrom && i.ReceiveDate <= searchParas.ReceiveDateTo); } query.OrderBy(i => i.CreatedDate, OrderByType.Desc); int totalCount = 0; jsonResult.Rows = query.ToPageList(para.pagenum, para.pagesize, ref totalCount); jsonResult.TotalRows = totalCount; var logData = JsonConverter.Serialize(jsonResult); _ll.SaveLog(3, 51, CurrentUser.GetCurrentUser().LoginName, "红包领取历史", logData); } return(jsonResult); }
/// <summary> /// 根据搜索条件获取企业付款历史 /// </summary> /// <param name="searchParas">搜索条件</param> /// <param name="para">页码信息</param> /// <returns></returns> public JsonResultModel <v_Business_Redpacket_Push_Information> GetPaymentInfos(Search_RedPacketHistory searchParas, GridParams para) { return(_redPacketServer.GetPaymentInfos(searchParas, para)); }