/// <summary>
/// 获取股权记录分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>股权记录分页列表</returns>
public PagedList <FnStockRecord> GetPagerList(StockRecordRequest request)
{
var dataCount = DBContext.Select <int>("count(0)").From(StrTableName);
var dataList = DBContext.Select <FnStockRecord>("*").From(StrTableName);
Action <string, string, object> setWhere = (@where, name, value) =>
{
dataCount.AndWhere(where).Parameter(name, value);
dataList.AndWhere(where).Parameter(name, value);
};
if (request.Type.HasValue)
{
setWhere("Type = @Type", "Type", request.Type.Value);
}
if (request.OperatorType.HasValue)
{
setWhere("OperatorType = @OperatorType", "OperatorType", request.OperatorType.Value);
}
if (request.OperatorSysNo.HasValue)
{
setWhere("OperatorSysNo = @OperatorSysNo", "OperatorSysNo", request.OperatorSysNo.Value);
}
if (request.StatusList != null && request.StatusList.Any())
{
setWhere(string.Format("Status in({0})", string.Join(",", request.StatusList)), "", "");
}
return(new PagedList <FnStockRecord>
{
TData = dataList.Paging(request.CurrentPageIndex.GetHashCode(), request.PageSize.GetHashCode()).OrderBy("SysNo desc").QueryMany(),
CurrentPageIndex = request.CurrentPageIndex.GetHashCode(),
TotalCount = dataCount.QuerySingle()
});
}
/// <summary>
/// 获取股权记录列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>股权记录列表</returns>
public IList <FnStockRecord> GetList(StockRecordRequest request)
{
var dataList = DBContext.Select <FnStockRecord>("*").From(StrTableName);
Action <string, string, object> setWhere = (@where, name, value) => dataList.AndWhere(@where).Parameter(name, value);
if (request.Type.HasValue)
{
setWhere("Type = @Type", "Type", request.Type.Value);
}
if (request.OperatorType.HasValue)
{
setWhere("OperatorType = @OperatorType", "OperatorType", request.OperatorType.Value);
}
if (request.OperatorSysNo.HasValue)
{
setWhere("OperatorSysNo = @OperatorSysNo", "OperatorSysNo", request.OperatorSysNo.Value);
}
if (request.StatusList != null && request.StatusList.Any())
{
setWhere(string.Format("Status in({0})", string.Join(",", request.StatusList)), "", "");
}
if (request.StartDate.HasValue)
{
setWhere("CreatedDate >= @StartDate", "StartDate", request.StartDate.ToString());
}
if (request.EndDate.HasValue)
{
setWhere("CreatedDate <= @EndDate", "EndDate", request.EndDate.ToString());
}
if (request.TopNum.HasValue)
{
dataList.OrderBy("CreatedDate desc").Paging(1, request.TopNum.Value);
}
return(dataList.QueryMany());
}
/// <summary>
/// 获取股权记录列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>股权记录列表</returns>
public List <FnStockRecord> GetList(StockRecordRequest request)
{
var list = Using <IFnStockRecord>().GetList(request);
return(list.ToList());
}
/// <summary>
/// 获取股权记录分页列表
/// </summary>
/// <param name="request">查询参数</param>
/// <returns>股权记录分页列表</returns>
public PagedList <FnStockRecord> GetPagerList(StockRecordRequest request)
{
return(Using <IFnStockRecord>().GetPagerList(request));
}
