public static DataTable QueryStockShipType(StockShipTypeQueryFilter filter, out int count)
{
CustomDataCommand command = DataCommandManager.
CreateCustomDataCommandFromConfig("Query_Stock_QueryStockShipType");
using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(
command.CommandText, command, filter, !string.IsNullOrWhiteSpace(filter.SortFields) ? filter.SortFields : "ss.SysNo DESC"))
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"ss.SellerSysNo", DbType.String,
"@SellerSysNo", QueryConditionOperatorType.Equal,
filter.SellerSysNo);
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"ss.StockSysNo", DbType.AnsiStringFixedLength,
"@StockSysNo", QueryConditionOperatorType.Equal,
filter.StockSysNo);
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND,
"ss.ShipTypeSysNo", DbType.AnsiStringFixedLength,
"@ShipTypeSysNo", QueryConditionOperatorType.Equal,
filter.ShipTypeSysNo);
command.CommandText = builder.BuildQuerySql();
count = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
return(command.ExecuteDataTable());
}
}
public static QueryResult QueryStockShipType(StockShipTypeQueryFilter filter)
{
int count = 0;
return(new QueryResult(StockDA.QueryStockShipType(filter, out count), filter, count));
}
