C# QueryBuilder.SelectTop方法代码示例

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(RevisionObject.REV_ID);
         builder.AppendColumn(RevisionObject.MATCAT_ID);
         builder.AppendColumn(RevisionObject.MATTYP_ID);
         builder.AppendColumn(RevisionObject.MATSTYP_ID);
         builder.AppendColumn(RevisionObject.REVISION);
         builder.AppendColumn(MaterialCategoryObject.CATEGORY);
         builder.AppendColumn(MaterialCategoryObject.MATCAT_ID);
         builder.AppendColumn(MaterialSubTypeObject.MATSTYP_ID);
         builder.AppendColumn(MaterialSubTypeObject.MATTYP_ID);
         builder.AppendColumn(MaterialSubTypeObject.SUBTYPE);
         builder.AppendColumn(MaterialTypeObject.MATCAT_ID);
         builder.AppendColumn(MaterialTypeObject.MATTYP_ID);
         builder.AppendColumn(MaterialTypeObject.TYPE);
         builder.AppendFromTable(RevisionObject.TABLE);
         builder.AppendLeftJoin(MaterialCategoryObject.TABLE, MaterialCategoryObject.MATCAT_ID, RevisionObject.MATCAT_ID);
         builder.AppendLeftJoin(MaterialTypeObject.TABLE, MaterialTypeObject.MATTYP_ID, RevisionObject.MATTYP_ID);
         builder.AppendLeftJoin(MaterialSubTypeObject.TABLE, MaterialSubTypeObject.MATSTYP_ID, RevisionObject.MATSTYP_ID);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(ScheduleObject.SCHED_ID);
         builder.AppendColumn(ScheduleObject.FREQUENCY);
         builder.AppendColumn(ScheduleObject.MONDAY);
         builder.AppendColumn(ScheduleObject.TUESDAY);
         builder.AppendColumn(ScheduleObject.WEDNESDAY);
         builder.AppendColumn(ScheduleObject.THURSDAY);
         builder.AppendColumn(ScheduleObject.FRIDAY);
         builder.AppendColumn(ScheduleObject.WEDNESDAY);
         builder.AppendColumn(ScheduleObject.SATERDAY);
         builder.AppendColumn(ScheduleObject.SUNDAY);
         builder.AppendColumn(ScheduleObject.STARTDATE);
         builder.AppendColumn(ScheduleObject.TIME);
         builder.AppendColumn(ScheduleObject.LAST_SEND);
         builder.AppendFromTable(ScheduleObject.TABLE);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(PopupUserObject.POPUPUSER_ID);
         builder.AppendColumn(PopupUserObject.POPUP_ID);
         builder.AppendColumn(PopupUserObject.USER_ID);
         builder.AppendColumn(PopupObject.POPUP_ID);
         builder.AppendColumn(PopupObject.DESCRIPTION);
         builder.AppendColumn(PopupObject.REPEAT);
         builder.AppendColumn(PopupObject.ACTIVE);
         builder.AppendColumn(PopupObject.CREATIONDATE);
         builder.AppendColumn(PopupObject.TIME);
         builder.AppendColumn(PopupObject.SHOW_DIRECT);
         builder.AppendColumn(UserObject.USR_ID);
         builder.AppendFromTable(PopupUserObject.TABLE);
         builder.AppendLeftJoin(PopupObject.TABLE, PopupUserObject.POPUP_ID, PopupObject.POPUP_ID);
         builder.AppendLeftJoin(UserObject.TABLE, PopupUserObject.USER_ID, UserObject.USR_ID);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(TaskObject.TASK_ID);
         builder.AppendColumn(TaskObject.TAG);
         builder.AppendColumn(TaskObject.CREATION_DATE);
         builder.AppendColumn(TaskObject.UPDATE_DATE);
         builder.AppendColumn(TaskObject.DUE_DATE);
         builder.AppendColumn(TaskObject.STATUS);
         builder.AppendColumn(TaskObject.PRIORITY);
         builder.AppendColumn(TaskObject.EFFORT);
         builder.AppendFromTable(TaskObject.TABLE);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(MaintenanceVehicleObject.MAINTVEH_ID);
         builder.AppendColumn(MaintenanceVehicleObject.EMPID_EXECUTOR);
         builder.AppendColumn(MaintenanceVehicleObject.REMARK);
         builder.AppendColumn(MaintenanceVehicleObject.VEH_ID);
         builder.AppendColumn(MaintenanceVehicleObject.START_MAINTENANCE);
         builder.AppendFromTable(MaintenanceVehicleObject.TABLE);
         builder.AppendInnerJoin(VehicleObject.TABLE, VehicleObject.VEHID, MaintenanceVehicleObject.VEH_ID);
         builder.AppendLeftJoin(EmployeeObject.TABLE, EmployeeObject.EMP_ID, MaintenanceVehicleObject.EMPID_EXECUTOR);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(CustomerObject.CUS_ID);
         builder.AppendColumn(CustomerObject.TAS_ID);
         builder.AppendColumn(CustomerObject.NAME);
         builder.AppendColumn(CustomerObject.NAME2);
         builder.AppendColumn(CustomerObject.STREET);
         builder.AppendColumn(CustomerObject.HOUSE_NUMBER);
         builder.AppendColumn(CustomerObject.ZIPCODE);
         builder.AppendColumn(CustomerObject.TOWN);
         builder.AppendColumn(CustomerObject.COUNTRY);
         builder.AppendColumn(CustomerObject.VAT);
         builder.AppendColumn(CustomerObject.PHONE);
         builder.AppendColumn(CustomerObject.LANGUAGE);
         builder.AppendColumn(CustomerObject.CURRENCY);
         builder.AppendFromTable(CustomerObject.TABLE);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

        public string BaseQuery(bool selectTop, int top)
        {
            QueryBuilder builder;
            try
            {
                builder = new QueryBuilder();
                if (selectTop == true)
                    builder.SelectTop(top);
                else
                    builder.Select();
                builder.AppendColumn(FuelCorrectionObject.FUELCOR_ID);
                builder.AppendColumn(FuelCorrectionObject.DATE_FROM);
                builder.AppendColumn(FuelCorrectionObject.DATE_TO);
                builder.AppendColumn(FuelCorrectionObject.QUANTITY);
                builder.AppendColumn(FuelCorrectionObject.MAXQUANTITY);
                builder.AppendColumn(FuelCorrectionObject.SUPPLIERS_INCLUDED);
                builder.AppendColumn(FuelCorrectionObject.VEHICLES_NOT_INCLUDED);

                builder.AppendFromTable(FuelCorrectionObject.TABLE);
                return builder.Query;
            }
            catch (System.Exception exception1)
            {
                Exception innerException = exception1;
                throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
            }
        }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(EmployeeObject.EMP_ID);
         builder.AppendColumn(EmployeeObject.TRANSC_ID);
         builder.AppendColumn(EmployeeObject.TRANSI_ID);
         builder.AppendColumn(EmployeeObject.NAME);
         builder.AppendColumn(EmployeeObject.SURNAME);
         builder.AppendColumn(EmployeeObject.EMAIL);
         builder.AppendColumn(EmployeeObject.ARCHIVE);
         builder.AppendColumn(EmployeeObject.TRANSC_LANGUAGE);
         builder.AppendColumn(EmployeeObject.LAN_ID);
         builder.AppendColumn(EmployeeObject.REPEAT_MAIL);
         builder.AppendColumn(LanguageObject.LAN_ID);
         builder.AppendColumn(LanguageObject.LANGUAGE);
         builder.AppendColumn(LanguageObject.LANGUAGE_DUTCH);
         builder.AppendFromTable(EmployeeObject.TABLE);
         builder.AppendInnerJoin(LanguageObject.TABLE, LanguageObject.LAN_ID, EmployeeObject.LAN_ID);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(FuelObject.FUEL_ID);
         builder.AppendColumn(FuelObject.TRANSI_TNR_REG);
         builder.AppendColumn(FuelObject.TRANSI_TNR_PERSON);
         builder.AppendColumn(FuelObject.TRANSI_TNR_MAT);
         builder.AppendColumn(FuelObject.TRANSI_TNR_PUMP);
         builder.AppendColumn(FuelObject.TRANSI_TNR_TANK);
         builder.AppendColumn(FuelObject.TRANSI_FUELTYPE);
         builder.AppendColumn(FuelObject.TRANSC_FUELID);
         builder.AppendColumn(FuelObject.TRANSC_NAWID);
         builder.AppendColumn(FuelObject.TRANSC_DATE);
         builder.AppendColumn(FuelObject.TRANSC_PRIVEBEDRIJF);
         builder.AppendColumn(FuelObject.TRANSC_PRODUCT);
         builder.AppendColumn(FuelObject.DATE);
         builder.AppendColumn(FuelObject.EMPLOYEE_NAME);
         builder.AppendColumn(FuelObject.EMPLOYEE);
         builder.AppendColumn(FuelObject.VEHICLE_LICENSEPLATE);
         builder.AppendColumn(FuelObject.VEHICLE_KILOMETRECOUNTER);
         builder.AppendColumn(FuelObject.QUANTITY);
         builder.AppendColumn(FuelObject.QUANTITY_CORRECTION);
         builder.AppendColumn(FuelObject.FULLTANK);
         builder.AppendColumn(FuelObject.UNITYPRICE);
         builder.AppendColumn(FuelObject.TOTALPRICE);
         builder.AppendColumn(FuelObject.UNIT);
         builder.AppendColumn(FuelObject.SUPPLIER);
         builder.AppendColumn(FuelObject.LOCATION);
         builder.AppendColumn(FuelObject.FUELTYPE);
         builder.AppendColumn(FuelObject.BTW);
         builder.AppendColumn(FuelObject.PRIVATE_TANKING);
         builder.AppendColumn(FuelObject.COMPANY_TANKING);
         builder.AppendColumn(FuelObject.INVOICE_RECEIVED);
         builder.AppendColumn(FuelObject.INVOICE_OK);
         builder.AppendColumn(FuelObject.DATEMAIL_FORBIDDENFUELING);
         builder.AppendFromTable(FuelObject.TABLE);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(TaskScheduleObject.TSCHED_ID);
         builder.AppendColumn(TaskScheduleObject.TASK_ID);
         builder.AppendColumn(TaskScheduleObject.SCHED_ID);
         builder.AppendColumn(ScheduleObject.FREQUENCY);
         builder.AppendColumn(ScheduleObject.FRIDAY);
         builder.AppendColumn(ScheduleObject.MONDAY);
         builder.AppendColumn(ScheduleObject.SATERDAY);
         builder.AppendColumn(ScheduleObject.SCHED_ID);
         builder.AppendColumn(ScheduleObject.SUNDAY);
         builder.AppendColumn(ScheduleObject.THURSDAY);
         builder.AppendColumn(ScheduleObject.TIME);
         builder.AppendColumn(ScheduleObject.TUESDAY);
         builder.AppendColumn(ScheduleObject.WEDNESDAY);
         builder.AppendColumn(ScheduleObject.LAST_SEND);
         builder.AppendColumn(ScheduleObject.STARTDATE);
         builder.AppendColumn(TaskObject.CREATION_DATE);
         builder.AppendColumn(TaskObject.DESCRIPTION);
         builder.AppendColumn(TaskObject.DUE_DATE);
         builder.AppendColumn(TaskObject.EFFORT);
         builder.AppendColumn(TaskObject.PRIORITY);
         builder.AppendColumn(TaskObject.STATUS);
         builder.AppendColumn(TaskObject.TAG);
         builder.AppendColumn(TaskObject.TASK_ID);
         builder.AppendColumn(TaskObject.UPDATE_DATE);
         builder.AppendFromTable(TaskScheduleObject.TABLE);
         builder.AppendLeftJoin(ScheduleObject.TABLE, TaskScheduleObject.SCHED_ID, ScheduleObject.SCHED_ID);
         builder.AppendLeftJoin(TaskObject.TABLE, TaskScheduleObject.TASK_ID, TaskObject.TASK_ID);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

        public string BaseQuery(bool selectTop, int top)
        {
            QueryBuilder builder;
            try
            {
                builder = new QueryBuilder();
                if (selectTop == true)
                    builder.SelectTop(top);
                else
                    builder.Select();
                builder.AppendColumn(FuelDeliveryObject.FUELDEL_ID);
                builder.AppendColumn(FuelDeliveryObject.SUP_ID);
                builder.AppendColumn(FuelDeliveryObject.DATE_DELIVERY);
                builder.AppendColumn(FuelDeliveryObject.DATE_INVOICE);
                builder.AppendColumn(FuelDeliveryObject.QUANTITY);
                builder.AppendColumn(FuelDeliveryObject.UNITY_PRICE);
                builder.AppendColumn(FuelDeliveryObject.LOCATION);
                builder.AppendColumn(FuelDeliveryObject.REMARK);

                builder.AppendColumn(SupplierObject.SUP_ID);
                builder.AppendColumn(SupplierObject.TRANSC_ID);
                builder.AppendColumn(SupplierObject.TAS_ID);
                builder.AppendColumn(SupplierObject.NAME);
                builder.AppendColumn(SupplierObject.NAME2);
                builder.AppendColumn(SupplierObject.STREET);
                builder.AppendColumn(SupplierObject.HOUSE_NUMBER);
                builder.AppendColumn(SupplierObject.ZIPCODE);
                builder.AppendColumn(SupplierObject.TOWN);
                builder.AppendColumn(SupplierObject.COUNTRY);
                builder.AppendColumn(SupplierObject.VAT);
                builder.AppendColumn(SupplierObject.PHONE);
                builder.AppendColumn(SupplierObject.LANGUAGE);
                builder.AppendColumn(SupplierObject.CURRENCY);
                builder.AppendColumn(SupplierObject.EMAIL);
                builder.AppendFromTable(FuelDeliveryObject.TABLE);
                builder.AppendInnerJoin(SupplierObject.TABLE, SupplierObject.SUP_ID, FuelDeliveryObject.SUP_ID);
                return builder.Query;
            }
            catch (System.Exception exception1)
            {
                Exception innerException = exception1;
                throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
            }
        }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(MaterialRevisionObject.MATREV_ID);
         builder.AppendColumn(MaterialRevisionObject.MAINT_ID);
         builder.AppendColumn(MaterialRevisionObject.REVISION);
         builder.AppendColumn(MaterialRevisionObject.ANSWER);
         builder.AppendColumn(MaterialRevisionObject.CATEGORY);
         builder.AppendColumn(MaintenanceObject.EMP_ID_EXECUTOR);
         builder.AppendColumn(MaintenanceObject.MAINT_ID);
         builder.AppendColumn(MaintenanceObject.MAINTVEH_ID);
         builder.AppendColumn(MaintenanceObject.MAT_ID);
         builder.AppendColumn(MaintenanceObject.REMARK);
         builder.AppendColumn(MaintenanceObject.START_MAINTENANCE);
         builder.AppendColumn(EmployeeObject.ARCHIVE);
         builder.AppendColumn(EmployeeObject.EMAIL);
         builder.AppendColumn(EmployeeObject.EMP_ID);
         builder.AppendColumn(EmployeeObject.LAN_ID);
         builder.AppendColumn(EmployeeObject.NAME);
         builder.AppendColumn(EmployeeObject.SURNAME);
         builder.AppendColumn(EmployeeObject.TRANSC_ID);
         builder.AppendColumn(EmployeeObject.TRANSC_LANGUAGE);
         builder.AppendColumn(EmployeeObject.TRANSI_ID);
         builder.AppendColumn(EmployeeObject.REPEAT_MAIL);
         builder.AppendFromTable(MaterialRevisionObject.TABLE);
         builder.AppendLeftJoin(MaintenanceObject.TABLE, MaintenanceObject.MAINT_ID, MaterialRevisionObject.MAINT_ID);
         builder.AppendLeftJoin(EmployeeObject.TABLE, EmployeeObject.EMP_ID, MaintenanceObject.EMP_ID_EXECUTOR);
         builder.AppendLeftJoin(MaintenanceVehicleObject.TABLE, MaintenanceVehicleObject.MAINTVEH_ID, MaintenanceObject.MAINTVEH_ID);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(UnknownObject.UNK_ID);
         builder.AppendColumn(UnknownObject.EMAIL);
         builder.AppendFromTable(UnknownObject.TABLE);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(VehicleTransicsLinkObject.VEHTI_ID);
         builder.AppendColumn(VehicleTransicsLinkObject.TRANSC_VEHICLEID);
         builder.AppendColumn(VehicleTransicsLinkObject.TRANSI_TNR_MAT);
         builder.AppendFromTable(VehicleTransicsLinkObject.TABLE);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(MaterialObject.MATCAT_ID);
         builder.AppendColumn(MaterialObject.MATTYP_ID);
         builder.AppendColumn(MaterialObject.MATSTYP_ID);
         builder.AppendColumn(MaterialObject.EMP_ID_CREATOR);
         builder.AppendColumn(MaterialObject.EMP_ID_RESPONSABLE);
         builder.AppendColumn(MaterialObject.INTERNAL_NUMBER);
         builder.AppendColumn(MaterialObject.MAT_ID);
         builder.AppendColumn(MaterialObject.NAME);
         builder.AppendColumn(MaterialObject.NEXT_MAINTENANCE);
         builder.AppendColumn(MaterialObject.PRICE);
         builder.AppendColumn(MaterialObject.SERIE_NUMBER);
         builder.AppendColumn(MaterialObject.TYPE);
         builder.AppendColumn(MaterialObject.VEH_ID);
         builder.AppendColumn(MaterialObject.SUP_ID);
         builder.AppendColumn(MaterialObject.DESCRIPTION);
         builder.AppendColumn(MaterialObject.PURCHASEDON);
         builder.AppendColumn(MaterialObject.MAINTENANCE_FREQUENCY);
         builder.AppendColumn(MaterialObject.BROKEN);
         builder.AppendColumn(MaterialObject.ACTIVE);
         builder.AppendColumn(MaterialCategoryObject.MATCAT_ID);
         builder.AppendColumn(MaterialCategoryObject.CATEGORY);
         builder.AppendColumn(MaterialTypeObject.MATTYP_ID);
         builder.AppendColumn(MaterialTypeObject.MATCAT_ID);
         builder.AppendColumn(MaterialTypeObject.TYPE);
         builder.AppendColumn(MaterialSubTypeObject.MATSTYP_ID);
         builder.AppendColumn(MaterialSubTypeObject.MATTYP_ID);
         builder.AppendColumn(MaterialSubTypeObject.SUBTYPE);
         builder.AppendColumn(VehicleObject.BRAND);
         builder.AppendColumn(VehicleObject.CHASSIS);
         builder.AppendColumn(VehicleObject.EURONORM);
         builder.AppendColumn(VehicleObject.ICON);
         builder.AppendColumn(VehicleObject.LICENSE_NUMBER);
         builder.AppendColumn(VehicleObject.NAME);
         builder.AppendColumn(VehicleObject.TRANSC_VEHICLE_ID);
         builder.AppendColumn(VehicleObject.TRANSC_VEHICLE_TYPE);
         builder.AppendColumn(VehicleObject.VEHICLETYPE);
         builder.AppendColumn(VehicleObject.VEHID);
         builder.AppendColumn(VehicleObject.CONTACT_TRANSICS);
         builder.AppendColumn(SupplierObject.COUNTRY);
         builder.AppendColumn(SupplierObject.CURRENCY);
         builder.AppendColumn(SupplierObject.EMAIL);
         builder.AppendColumn(SupplierObject.HOUSE_NUMBER);
         builder.AppendColumn(SupplierObject.LANGUAGE);
         builder.AppendColumn(SupplierObject.NAME);
         builder.AppendColumn(SupplierObject.NAME2);
         builder.AppendColumn(SupplierObject.PHONE);
         builder.AppendColumn(SupplierObject.STREET);
         builder.AppendColumn(SupplierObject.SUP_ID);
         builder.AppendColumn(SupplierObject.TAS_ID);
         builder.AppendColumn(SupplierObject.TOWN);
         builder.AppendColumn(SupplierObject.TRANSC_ID);
         builder.AppendColumn(SupplierObject.VAT);
         builder.AppendColumn(SupplierObject.ZIPCODE);
         builder.AppendColumn(VehicleTransicsLinkObject.TRANSC_VEHICLEID);
         builder.AppendColumn(VehicleTransicsLinkObject.TRANSI_TNR_MAT);
         builder.AppendColumn(VehicleTransicsLinkObject.VEHTI_ID);
         builder.AppendColumn(EmployeeObject.ARCHIVE, "Creator");
         builder.AppendColumn(EmployeeObject.EMAIL, "Creator");
         builder.AppendColumn(EmployeeObject.EMP_ID, "Creator");
         builder.AppendColumn(EmployeeObject.LAN_ID, "Creator");
         builder.AppendColumn(EmployeeObject.NAME, "Creator");
         builder.AppendColumn(EmployeeObject.SURNAME, "Creator");
         builder.AppendColumn(EmployeeObject.TRANSC_ID, "Creator");
         builder.AppendColumn(EmployeeObject.TRANSC_LANGUAGE, "Creator");
         builder.AppendColumn(EmployeeObject.TRANSI_ID, "Creator");
         builder.AppendColumn(EmployeeObject.REPEAT_MAIL, "Creator");
         builder.AppendColumn(LanguageObject.LAN_ID, "CreatorLanguage");
         builder.AppendColumn(LanguageObject.LANGUAGE, "CreatorLanguage");
         builder.AppendColumn(LanguageObject.LANGUAGE_DUTCH, "CreatorLanguage");
         builder.AppendColumn(EmployeeObject.ARCHIVE, "Responsable");
         builder.AppendColumn(EmployeeObject.EMAIL, "Responsable");
         builder.AppendColumn(EmployeeObject.EMP_ID, "Responsable");
         builder.AppendColumn(EmployeeObject.LAN_ID, "Responsable");
         builder.AppendColumn(EmployeeObject.NAME, "Responsable");
         builder.AppendColumn(EmployeeObject.SURNAME, "Responsable");
         builder.AppendColumn(EmployeeObject.TRANSC_ID, "Responsable");
         builder.AppendColumn(EmployeeObject.TRANSC_LANGUAGE, "Responsable");
         builder.AppendColumn(EmployeeObject.TRANSI_ID, "Responsable");
         builder.AppendColumn(EmployeeObject.REPEAT_MAIL, "Responsable");
         builder.AppendColumn(LanguageObject.LAN_ID, "ResponsableLanguage");
         builder.AppendColumn(LanguageObject.LANGUAGE, "ResponsableLanguage");
         builder.AppendColumn(LanguageObject.LANGUAGE_DUTCH, "ResponsableLanguage");
         builder.AppendFromTable(MaterialObject.TABLE);
         builder.AppendLeftJoin(VehicleObject.TABLE, VehicleObject.VEHID, MaterialObject.VEH_ID);
         builder.AppendLeftJoin(VehicleTransicsLinkObject.TABLE, VehicleTransicsLinkObject.TRANSC_VEHICLEID, VehicleObject.TRANSC_VEHICLE_ID);
         builder.AppendLeftJoin(SupplierObject.TABLE, SupplierObject.SUP_ID, MaterialObject.SUP_ID);
         builder.AppendLeftJoin(EmployeeObject.TABLE, "Creator", EmployeeObject.EMP_ID, MaterialObject.EMP_ID_CREATOR);
         builder.AppendLeftJoin(LanguageObject.TABLE, "CreatorLanguage", LanguageObject.LAN_ID, EmployeeObject.ConvertColumnToAlias(EmployeeObject.LAN_ID,"Creator"));
         builder.AppendLeftJoin(EmployeeObject.TABLE, "Responsable", EmployeeObject.EMP_ID, MaterialObject.EMP_ID_RESPONSABLE);
         builder.AppendLeftJoin(LanguageObject.TABLE, "ResponsableLanguage", LanguageObject.LAN_ID, EmployeeObject.ConvertColumnToAlias(EmployeeObject.LAN_ID, "Responsable"));
//.........这里部分代码省略.........