public QueryResult IncomeCostReportExport(IncomeCostReportQueryFilter filter) { int totalCount; var ds = ObjectFactory <IFinancialReportDA> .Instance.IncomeCostReportQuery(filter, out totalCount); var dataTable = ds.Tables[0]; return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
public QueryResultList IncomeCostReportQuery(IncomeCostReportQueryFilter filter) { int totalCount; var ds = ObjectFactory <IFinancialReportDA> .Instance.IncomeCostReportQuery(filter, out totalCount); return(new QueryResultList() { new QueryResult() { Data = ds.Tables[0], TotalCount = totalCount }, new QueryResult() { Data = ds.Tables[1] } }); }
public DataSet IncomeCostReportQuery(IncomeCostReportQueryFilter filter, out int totalCount) { PagingInfoEntity pagingInfo = CreatePagingInfo(filter.PagingInfo); CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("FinancialReport.IncomeCostReportQuery"); DataSet result = null; using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "OrderDate DESC")) { #region Set dynamic codition for where if (filter.SODateFrom.HasValue) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "OrderDate", DbType.DateTime, "@OrderDateFrom_query", QueryConditionOperatorType.MoreThanOrEqual, filter.SODateFrom.Value); } if (filter.SODateTo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "OrderDate", DbType.DateTime, "@SODateTo_query", QueryConditionOperatorType.LessThan, filter.SODateTo.Value); } if (filter.PayTypeSysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "PayTypeSysNo", DbType.Int32, "@PayTypeSysNo_query", QueryConditionOperatorType.Equal, filter.PayTypeSysNo.Value); } if (!string.IsNullOrWhiteSpace(filter.ChannelID)) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "ChannelID", DbType.AnsiStringFixedLength, "@ChannelID_query", QueryConditionOperatorType.Equal, filter.ChannelID); } if (filter.SOSysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "SOSysNo", DbType.Int32, "@SOSysNo_query", QueryConditionOperatorType.Equal, filter.SOSysNo.Value); } if (filter.SOStatusList != null && filter.SOStatusList.Count > 0) { sqlBuilder.ConditionConstructor.AddInCondition <int>( QueryConditionRelationType.AND, "SOStatus", System.Data.DbType.Int32, filter.SOStatusList); } if (filter.VendorSysNoList != null && filter.VendorSysNoList.Count > 0) { sqlBuilder.ConditionConstructor.AddInCondition( QueryConditionRelationType.AND, "VendorSysNo", DbType.Int32, filter.VendorSysNoList); } #endregion dataCommand.CommandText = sqlBuilder.BuildQuerySql(); result = dataCommand.ExecuteDataSet(); dataCommand.ConvertEnumColumn(result.Tables[0], 18, typeof(SOStatus)); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); } return(result); }