/// <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)); }