/// <summary> /// 根据query获取兑现申请信息 /// </summary> /// <returns></returns> public DataTable GetCommissionToCashByQuery(CommissionToCashQueryFilter query, out int TotalCount) { var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetCommissionToCashByQuery"); var pagingInfo = new PagingInfoEntity { SortField = query.PageInfo.SortBy, StartRowIndex = query.PageInfo.PageIndex * query.PageInfo.PageSize, MaximumRows = query.PageInfo.PageSize }; using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingInfo, "cashRecord.SysNo desc")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "userInfo.CustomerID", DbType.String, "@CustomerID", QueryConditionOperatorType.LeftLike, query.CustomerID); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cashRecord.InDate", DbType.DateTime, "@RequestDateFrom", QueryConditionOperatorType.MoreThanOrEqual, query.ApplicationDateFrom); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cashRecord.InDate", DbType.DateTime, "@RequestDateTo", QueryConditionOperatorType.LessThanOrEqual, query.ApplicationDateTo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cashRecord.Status", DbType.AnsiStringFixedLength, "@Status", QueryConditionOperatorType.Equal, query.Status); cmd.CommandText = sqlBuilder.BuildQuerySql(); } DataTable dt = new DataTable(); dt = cmd.ExecuteDataTable(8, typeof(ToCashStatus)); TotalCount = (int)cmd.GetParameterValue("@TotalCount"); return(dt); }
public QueryResult GetCommissionToCashByQuery(CommissionToCashQueryFilter query) { int totalCount; var dataTable = ObjectFactory <ICommissionToCashDA> .Instance.GetCommissionToCashByQuery(query, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
/// <summary> /// 获取申请信息 /// </summary> /// <param name="model"></param> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="SortField"></param> /// <param name="callback"></param> public void GetCommissionToCashByQuery(CommissionToCashQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { string GetCommissionToCashByQueryUrl = "ExternalSYSService/CommissionToCash/GetCommissionToCashByQuery"; CommissionToCashQueryFilter query = ConvertQuery(model); query.PageInfo = new QueryFilter.Common.PagingInfo() { PageIndex = PageIndex, PageSize = PageSize, SortBy = SortField }; restClient.QueryDynamicData(GetCommissionToCashByQueryUrl, query, callback); }