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