public QueryResult QueryStockShiftConfig(StockShiftConfigFilter filter) { DataTable dt = null; int totalCount; dt = ObjectFactory <IShiftRequestQueryDA> .Instance.QueryStockShiftConfig(filter, out totalCount); return(new QueryResult { Data = dt, TotalCount = totalCount }); }
public DataTable QueryStockShiftConfig(StockShiftConfigFilter filter, out int totalCount) { totalCount = 0; if (filter == null) { return(null); } PagingInfoEntity pagingEntity = PageInfoToEntity(filter.PagingInfo); pagingEntity.SortField = ShiftConfigSortFieldMapping(pagingEntity.SortField); CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("Inventory_Query_StockShiftConfig"); using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingEntity, "a.SysNo DESC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CompanyCode", DbType.Int32, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.StockASysno", DbType.Int32, "@WarehouseASysNumber", QueryConditionOperatorType.Equal, filter.OutStockSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.StockBSysno", DbType.Int32, "@WarehouseBSysNumber", QueryConditionOperatorType.Equal, filter.InStockSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.ShiftType", DbType.Int32, "@TransferType", QueryConditionOperatorType.Equal, filter.ShiftType); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.SPLTimeInterval", DbType.Int32, "@SPLInterval", QueryConditionOperatorType.Equal, filter.SPLInterval); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.ShipTimeInterval", DbType.Int32, "@ShipInterval", QueryConditionOperatorType.Equal, filter.ShipInterval); dataCommand.CommandText = sqlBuilder.BuildQuerySql(); DataTable dt = dataCommand.ExecuteDataTable(); if (null != dt && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { dr["ShiftTypeString"] = CodeNamePairManager.GetName("Inventory", "StockShiftConfigShippingType", dr["ShiftType"].ToString()); } } totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); return(dt); } }