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