/// <summary>
/// 查询提现订单列表
/// </summary>
/// <param name="model">搜索实体对象</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-7-3</remarks>
public JsonResult List(SearchZJ_WithdrawOrderModel model)
{
model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize;
var list = _zJ_WithdrawOrderService.Select(model);
var data = new { rows = list.Data, total = list.Data.TotalCount };
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 提现订单分布查询
/// </summary>
/// <param name="model">输入查询参数对象</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-7-20</remarks>
public ResultModel Select(SearchZJ_WithdrawOrderModel model)
{
var zJ_WithdrawOrder = _database.Db.ZJ_WithdrawOrder;
var user = _database.Db.YH_User;
dynamic u;
#region 查询参数条件
//查询参数条件
var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal);
//订单号
if (!string.IsNullOrEmpty(model.OrderNO))
{
whereParam = new SimpleExpression(whereParam, zJ_WithdrawOrder.OrderNO.Like("%" + model.OrderNO + "%"), SimpleExpressionType.And);
}
//手机号码
if (!string.IsNullOrEmpty(model.Phone))
{
whereParam = new SimpleExpression(whereParam, user.Phone.Like("%" + model.Phone + "%"), SimpleExpressionType.And);
}
//手机号码
if (!string.IsNullOrEmpty(model.Email))
{
whereParam = new SimpleExpression(whereParam, user.Email.Like("%" + model.Email + "%"), SimpleExpressionType.And);
}
//用户真实姓名
if (!string.IsNullOrEmpty(model.RealName))
{
whereParam = new SimpleExpression(whereParam, user.RealName.Like("%" + model.RealName + "%"), SimpleExpressionType.And);
}
//审核人
if (!string.IsNullOrEmpty(model.Verifier))
{
whereParam = new SimpleExpression(whereParam, zJ_WithdrawOrder.Verifier.Like("%" + model.Verifier + "%"), SimpleExpressionType.And);
}
//打款人
if (!string.IsNullOrEmpty(model.Remitter))
{
whereParam = new SimpleExpression(whereParam, zJ_WithdrawOrder.Remitter.Like("%" + model.Remitter + "%"), SimpleExpressionType.And);
}
//银行账号
if (!string.IsNullOrEmpty(model.BankAccount))
{
whereParam = new SimpleExpression(whereParam, zJ_WithdrawOrder.BankAccount.Like("%" + model.BankAccount + "%"), SimpleExpressionType.And);
}
//开户支行
if (!string.IsNullOrEmpty(model.BankSubbranch))
{
whereParam = new SimpleExpression(whereParam, zJ_WithdrawOrder.BankSubbranch.Like("%" + model.BankSubbranch + "%"), SimpleExpressionType.And);
}
//开户名
if (!string.IsNullOrEmpty(model.BankUserName))
{
whereParam = new SimpleExpression(whereParam, zJ_WithdrawOrder.BankUserName.Like("%" + model.BankUserName + "%"), SimpleExpressionType.And);
}
//来源
if (model.OrderSource != null)
{
whereParam = new SimpleExpression(whereParam, zJ_WithdrawOrder.OrderSource == model.OrderSource.Value, SimpleExpressionType.And);
}
//提现结果
if (model.WithdrawResult != null)
{
whereParam = new SimpleExpression(whereParam, zJ_WithdrawOrder.WithdrawResult == model.WithdrawResult.Value, SimpleExpressionType.And);
}
//申请提现时间
if (model.BeginPaymentDate != null)
{
whereParam = new SimpleExpression(whereParam, zJ_WithdrawOrder.WithdrawDT >= model.BeginPaymentDate, SimpleExpressionType.And);
}
if (model.EndPaymentDate != null)
{
whereParam = new SimpleExpression(whereParam, zJ_WithdrawOrder.WithdrawDT < Convert.ToDateTime(model.EndPaymentDate).AddDays(1), SimpleExpressionType.And);
}
#endregion
var query = zJ_WithdrawOrder.All().
LeftJoin(user, out u).On(u.UserID == zJ_WithdrawOrder.UserID).
Select(
zJ_WithdrawOrder.OrderNO,
zJ_WithdrawOrder.UserID,
zJ_WithdrawOrder.WithdrawAmount,
zJ_WithdrawOrder.WithdrawCommission,
zJ_WithdrawOrder.WithdrawDT,
zJ_WithdrawOrder.Verifier,
zJ_WithdrawOrder.VerifyDT,
zJ_WithdrawOrder.Remitter,
zJ_WithdrawOrder.RemittanceDT,
zJ_WithdrawOrder.Remark,
zJ_WithdrawOrder.WithdrawResult,
zJ_WithdrawOrder.CreateDT,
zJ_WithdrawOrder.BankAccount,
zJ_WithdrawOrder.BankName,
zJ_WithdrawOrder.BankSubbranch,
zJ_WithdrawOrder.BankUserName,
zJ_WithdrawOrder.IsDisplay,
zJ_WithdrawOrder.OrderSource,
u.Account,
u.RealName,
u.Phone,
u.Email,
u.NickName
).Where(whereParam).OrderBy(zJ_WithdrawOrder.WithdrawResult);
var result = new ResultModel()
{
Data = new SimpleDataPagedList <ZJ_WithdrawOrderModel>(query,
model.PagedIndex, model.PagedSize)
};
return(result);
}
