/// <summary>
/// 用户银行帐户信息表对象分布查询
/// </summary>
/// <param name="model">输入查询参数对象</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-7-16</remarks>
public ResultModel Select(SearchYH_UserBankAccountModel model)
{
var userBrank = _database.Db.YH_UserBankAccount;
var user = _database.Db.YH_User;
var brank = _database.Db.BD_Bank;
dynamic u;
dynamic bk;
var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal);
if (!string.IsNullOrEmpty(model.Account))
{
whereParam = new SimpleExpression(whereParam, user.Account.Like("%" + model.Account + "%"), 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);
}
var query = userBrank.All().
LeftJoin(user, out u).On(userBrank.UserID == u.UserID).
LeftJoin(brank, out bk).On(brank.BankID == userBrank.BankID).
Select(
userBrank.ID,
userBrank.IsDefault,
userBrank.BankAccount,
userBrank.BankSubbranch,
userBrank.BankUserName,
userBrank.IsUse,
userBrank.CreateBy,
userBrank.CreateDT,
u.Account,
u.RealName,
u.Phone,
u.Email,
bk.BankName
).Where(whereParam).
OrderBy(userBrank.IsUse);
var result = new ResultModel()
{
Data = new SimpleDataPagedList <YH_UserBankAccountModel>(query,
model.PagedIndex, model.PagedSize)
};
return(result);
}
/// <summary>
/// 查询用户银行帐户信息表列表
/// </summary>
/// <param name="model">搜索实体对象</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-7-16</remarks>
public JsonResult List(SearchYH_UserBankAccountModel model)
{
model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize;
var paramList =
_yH_UserBankAccountService.Select(new SearchYH_UserBankAccountModel
{
PagedIndex = model.PagedIndex,
PagedSize = model.PagedSize,
Account = model.Account,
Phone = model.Phone,
IsUse = model.IsUse
});
var data = new { rows = paramList.Data, total = paramList.Data.TotalCount };
return(Json(data, JsonRequestBehavior.AllowGet));
}
