public CRBITBL_HistoryControlResult LoadDataByType(CRBITBL_HistoryControlQuery query) { var pagingInfo = new PagingInfoEntity(); pagingInfo.SortField = query.PageInfo.SortFields; pagingInfo.StartRowIndex = 1 + query.PageInfo.PageIndex * query.PageInfo.PageSize; pagingInfo.MaximumRows = query.PageInfo.PageSize - 1; if (pagingInfo.MaximumRows < 0) { pagingInfo.MaximumRows = 0; } if (pagingInfo.StartRowIndex < 0) { pagingInfo.StartRowIndex = 0; } var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("loadSamplePolitInfoByType"); using (var builder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "n_ID asc")) { builder.ConditionConstructor.AddCustomCondition(QueryConditionRelationType.AND, string.Format("n_Type={0}", query.iType)); dataCommand.CommandText = builder.BuildQuerySql(); } var result = dataCommand.ExecuteEntityList <CRBITBL_HistoryControlTable>(); var totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); CRBITBL_HistoryControlResult response = new CRBITBL_HistoryControlResult(); response.DataList = result; response.TotalCount = totalCount; return(response); }
public CRBITBL_HistoryControlResult LoadEnterpriseDataByType(int iType) { var dataCommand = DataCommandManager.GetDataCommand("loadEnterpriseDataByType"); dataCommand.SetParameterValue("@iType", iType); var result = dataCommand.ExecuteEntityList <CRBITBL_HistoryControlTable>(); CRBITBL_HistoryControlResult response = new CRBITBL_HistoryControlResult(); response.DataList = result; response.TotalCount = result.Count; return(response); }