/// <summary> /// 查询订单支付信息表列表 /// </summary> /// <param name="model">搜索实体对象</param> /// <returns></returns> /// <remarks>added by jimmy,2015-7-16</remarks> public JsonResult List(SearchPaymentOrderModel model) { model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize; var paramList = _paymentOrderService.Select(model); var data = new { rows = paramList.Data, total = paramList.Data.TotalCount }; return(Json(data, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 订单支付信息分布查询 /// </summary> /// <param name="model">输入查询参数对象</param> /// <returns></returns> /// <remarks>added by jimmy,2015-7-16</remarks> public ResultModel Select(SearchPaymentOrderModel model) { var paymentOrder = _database.Db.PaymentOrder; var paymentOrder_Orders = _database.Db.PaymentOrder_Orders; var user = _database.Db.YH_User; dynamic po; dynamic u; //查询参数条件 var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal); //订单号 if (!string.IsNullOrEmpty(model.OrderID)) { whereParam = new SimpleExpression(whereParam, paymentOrder_Orders.OrderID.Like("%" + model.OrderID + "%"), SimpleExpressionType.And); } //手机号码 if (!string.IsNullOrEmpty(model.Phone)) { whereParam = new SimpleExpression(whereParam, user.Phone.Like("%" + model.Phone + "%"), SimpleExpressionType.And); } //Email if (!string.IsNullOrEmpty(model.Email)) { whereParam = new SimpleExpression(whereParam, user.Email.Like("%" + model.Email + "%"), SimpleExpressionType.And); } //支付编号 if (!string.IsNullOrEmpty(model.outOrderId)) { whereParam = new SimpleExpression(whereParam, paymentOrder.PaymentOrderID.Like("%" + model.outOrderId + "%"), SimpleExpressionType.And); } //支付状态 if (model.Flag != null) { whereParam = new SimpleExpression(whereParam, paymentOrder.Flag == model.Flag.Value, SimpleExpressionType.And); } //支付方式 if (model.PayChannel != null) { whereParam = new SimpleExpression(whereParam, paymentOrder.PayChannel == model.PayChannel.Value, SimpleExpressionType.And); } //支付时间 if (model.BeginPaymentDate != null) { whereParam = new SimpleExpression(whereParam, paymentOrder.PaymentDate >= model.BeginPaymentDate, SimpleExpressionType.And); } if (model.EndPaymentDate != null) { whereParam = new SimpleExpression(whereParam, paymentOrder.PaymentDate < Convert.ToDateTime(model.EndPaymentDate).AddDays(1), SimpleExpressionType.And); } var query = paymentOrder.All(). LeftJoin(paymentOrder_Orders, out po).On(po.PaymentOrderID == paymentOrder.PaymentOrderID). LeftJoin(user, out u).On(u.UserID == paymentOrder.UserID). Select( paymentOrder.PaymentOrderID, paymentOrder.UserID, paymentOrder.ProductAmount, paymentOrder.RealAmount, paymentOrder.Flag, paymentOrder.PaymentDate, paymentOrder.PayType, paymentOrder.PayChannel, paymentOrder.outOrderId, paymentOrder.CreateDT, po.OrderID, u.Phone, u.Email, u.NickName ).Where(whereParam).OrderByCreateDTDescending(); var result = new ResultModel() { Data = new SimpleDataPagedList <PaymentOrderModel>(query, model.PagedIndex, model.PagedSize) }; return(result); }