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