/// <summary>
/// 获取股权账户分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>股权账户分页列表</returns>
public PagedList <StockAccountExt> GetPagerList(StockAccountRequest request)
{
const string fromStr = "Agent_FnStockAccount a INNER JOIN Agent_CustomerExt c ON a.CustomerSysNo=c.CustomerSysNo";
var dataCount = DBContext.Select <int>("count(0)").From(fromStr);
var dataList = DBContext.Select <StockAccountExt>("a.*,c.RealName as CustomerName,c.SerialNumber").From(fromStr);
Action <string, string, object> setWhere = (@where, name, value) =>
{
dataCount.AndWhere(where).Parameter(name, value);
dataList.AndWhere(where).Parameter(name, value);
};
if (!string.IsNullOrWhiteSpace(request.CustomerName))
{
setWhere("c.RealName LIKE CONCAT('%',@CustomerName,'%')", "CustomerName", request.CustomerName);
}
if (!string.IsNullOrWhiteSpace(request.SerialNumber))
{
setWhere("c.SerialNumber LIKE CONCAT('%',@SerialNumber,'%')", "SerialNumber", request.SerialNumber);
}
return(new PagedList <StockAccountExt>
{
TData = dataList.Paging(request.CurrentPageIndex.GetHashCode(), request.PageSize.GetHashCode()).OrderBy("a.SysNo desc").QueryMany(),
CurrentPageIndex = request.CurrentPageIndex.GetHashCode(),
TotalCount = dataCount.QuerySingle()
});
}
/// <summary>
/// 获取股权账户列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>股权账户列表</returns>
public IList <FnStockAccount> GetList(StockAccountRequest request)
{
var dataList = DBContext.Select <FnStockAccount>("*").From(StrTableName);
Action <string, string, object> setWhere = (@where, name, value) => dataList.AndWhere(@where).Parameter(name, value);
return(dataList.QueryMany());
}
/// <summary>
/// 获取股权账户分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>股权账户分页列表</returns>
public PagedList <StockAccountExt> GetPagerList(StockAccountRequest request)
{
return(Using <IFnStockAccount>().GetPagerList(request));
}
/// <summary>
/// 获取股权账户列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>股权账户列表</returns>
public List <FnStockAccount> GetList(StockAccountRequest request)
{
var list = Using <IFnStockAccount>().GetList(request);
return(list.ToList());
}