/// <summary>
/// 列表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonResult List(SearchZJ_RechargeOrderModel model)
{
//SearchAC_OperateLogModel logmodel = new SearchAC_OperateLogModel();
model.PagedIndex = model.PagedIndex == 0 ? 0 : model.PagedIndex;
model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize;
//model.BeginCreateDT = model.BeginCreateDT == null ? DateTime.Now.AddDays(-30) : model.BeginCreateDT;
//model.EedCreateDT = model.EedCreateDT == null ? DateTime.Now.AddDays(1) : model.EedCreateDT.AddDays(1);
//model.EndRechargeDT = model.EndRechargeDT == null ? DateTime.Now.AddDays(1) : model.EndRechargeDT.Value.AddDays(1);
//查询列表
var result = this._zjRechargeOrderService.GetZJ_RechargeOrderList(model);
List <ZJ_RechargeOrderModel> ds = result.Data;
var data = new
{
rows = ds,
total = result.Data.TotalCount,
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取用户充值订单表
/// </summary>
/// <param name="model">model</param>
/// <returns>用户充值订单表</returns>
/// wuyf
public ResultModel GetZJ_RechargeOrderList(SearchZJ_RechargeOrderModel model)
{
var tb = _database.Db.ZJ_RechargeOrder;
var where = new SimpleExpression(1, 1, SimpleExpressionType.Equal); //
if (!string.IsNullOrEmpty(model.Email))
{
//用户Email
where = new SimpleExpression(where, _database.Db.YH_User.Email.Like("%" + model.Email.Trim() + "%"), SimpleExpressionType.And);
}
if (!string.IsNullOrEmpty(model.RealName))
{
//用户真实姓名
where = new SimpleExpression(where, _database.Db.YH_User.RealName.Like("%" + model.RealName.Trim() + "%"), SimpleExpressionType.And);
}
if (!string.IsNullOrEmpty(model.Account))
{
//用户登录账户
where = new SimpleExpression(where, _database.Db.YH_User.Account.Like("%" + model.Account.Trim() + "%"), SimpleExpressionType.And);
}
if (model.UserID > 0)
{
//用户ID
where = new SimpleExpression(where, tb.UserID == model.UserID, SimpleExpressionType.And);
}
if (!string.IsNullOrEmpty(model.OrderNO))
{
//订单编号
where = new SimpleExpression(where, tb.OrderNO.Like("%" + model.OrderNO.Trim() + "%"), SimpleExpressionType.And);
}
if (model.OrderSource != 10)
{
//订单来源
where = new SimpleExpression(where, tb.OrderSource == model.OrderSource, SimpleExpressionType.And);
}
if (model.BeginCreateDT != null && model.BeginCreateDT.Year != 0001)
{
//订单生成 开始时间
where = new SimpleExpression(where, tb.CreateDT >= model.BeginCreateDT, SimpleExpressionType.And);
}
if (model.EedCreateDT != null && model.EedCreateDT.Year != 0001)
{
//订单生成 结束时间
where = new SimpleExpression(where, tb.CreateDT < model.EedCreateDT, SimpleExpressionType.And);
}
if (model.BeginRechargeDT != null && model.BeginRechargeDT.Value.Year != 0001)
{
//充值 开始时间
where = new SimpleExpression(where, tb.RechargeDT >= model.BeginRechargeDT, SimpleExpressionType.And);
}
if (model.EndRechargeDT != null && model.EndRechargeDT.Value.Year != 0001)
{
//充值 结束时间
where = new SimpleExpression(where, tb.RechargeDT < model.EndRechargeDT, SimpleExpressionType.And);
}
if (model.RechargeChannel > 0)
{
//充值 通道
where = new SimpleExpression(where, tb.RechargeChannel == model.RechargeChannel, SimpleExpressionType.And);
}
if (model.RechargeResult != 10)
{
//充值 结果
where = new SimpleExpression(where, tb.RechargeResult == model.RechargeResult, SimpleExpressionType.And);
}
dynamic pc;
var query = tb
.Query()
.LeftJoin(_database.Db.YH_User, out pc)
.On(_database.Db.YH_User.UserID == tb.UserID)
.Select(
tb.UserID,
tb.OrderNO,
tb.RechargeChannel,
tb.RechargeAmount,
tb.RechargeDT,
tb.RechargeResult,
tb.CreateDT,
tb.IsDisplay,
tb.OrderSource,
pc.Phone,
pc.NickName,
pc.RealName,
pc.Email,
pc.Account
)
.Where(where)
.OrderByUserIDDescending();
var result = new ResultModel
{
Data = new SimpleDataPagedList <ZJ_RechargeOrderModel>(query,
model.PagedIndex, model.PagedSize)
};
return(result);
}
