public List <Vendor_ExInfo> QueryByStockShippingeInvoic(Vendor_ExInfo query)
{
var resultList = new List <Vendor_ExInfo>();
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("External_Query_ByStockShippingeInvoic");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, new PagingInfoEntity(), "SysNo DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"VendorSysNo",
DbType.Int32,
"@VendorSysNo",
QueryConditionOperatorType.Equal,
query.VendorSysNo);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"StockType",
DbType.AnsiStringFixedLength,
"@StockType",
QueryConditionOperatorType.Equal,
query.StockType);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"ShippingType",
DbType.AnsiStringFixedLength,
"@ShippingType",
QueryConditionOperatorType.Equal,
query.ShippingType);
sqlBuilder.ConditionConstructor.AddCondition(
QueryConditionRelationType.AND,
"InvoiceType",
DbType.AnsiStringFixedLength,
"@InvoiceType",
QueryConditionOperatorType.Equal,
query.InvoiceType);
cmd.CommandText = sqlBuilder.BuildQuerySql();
resultList = cmd.ExecuteEntityList <Vendor_ExInfo>();
return(resultList);
}
}
public List <Vendor_ExInfo> QueryByStockShippingeInvoic(Vendor_ExInfo query)
{
return(ObjectFactory <IVendorUserDA> .Instance.QueryByStockShippingeInvoic(query));
}
