当前位置: 首页>>代码示例>>C#>>正文

C# QueryBuilder.AppendLeftJoin方法代码示例

本文整理汇总了C#中QueryBuilder.AppendLeftJoin方法的典型用法代码示例。如果您正苦于以下问题：C# QueryBuilder.AppendLeftJoin方法的具体用法？C# QueryBuilder.AppendLeftJoin怎么用？C# QueryBuilder.AppendLeftJoin使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类QueryBuilder的用法示例。


在下文中一共展示了QueryBuilder.AppendLeftJoin方法的8个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: BaseQuery

 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);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:35，代码来源:RevisionDataService.cs

示例2: BaseQuery

 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);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:32，代码来源:PopupUserDataService.cs

示例3: BaseQuery

 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);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:26，代码来源:MaintenanceVehicleDataService.cs

示例4: BaseQuery

 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);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:45，代码来源:TaskScheduleDataService.cs

示例5: BaseQuery

 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);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:43，代码来源:MaterialRevisionDataService.cs

示例6: BaseQuery

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(UserObject.USR_ID);
         builder.AppendColumn(UserObject.EMP_ID);
         builder.AppendColumn(UserObject.SURNAME);
         builder.AppendColumn(UserObject.NAME);
         builder.AppendColumn(UserObject.LOGIN);
         builder.AppendColumn(UserObject.PASSWORD);
         builder.AppendColumn(UserObject.ACTIVE);
         builder.AppendColumn(UserObject.HASPOPUPS);
         builder.AppendColumn(UserObject.SECURITY);
         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.AppendColumn(LanguageObject.LAN_ID);
         builder.AppendColumn(LanguageObject.LANGUAGE);
         builder.AppendColumn(LanguageObject.LANGUAGE_DUTCH);
         builder.AppendFromTable(UserObject.TABLE);
         builder.AppendLeftJoin(EmployeeObject.TABLE, EmployeeObject.EMP_ID, UserObject.EMP_ID);
         builder.AppendLeftJoin(LanguageObject.TABLE, EmployeeObject.LAN_ID, LanguageObject.LAN_ID);
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:43，代码来源:UserDataService.cs

示例7: BaseQuery

 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"));
//.........这里部分代码省略.........
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:101，代码来源:MaterialDataService.cs

示例8: BaseQuery

 public string BaseQuery(bool selectTop, int top)
 {
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         if (selectTop == true)
             builder.SelectTop(top);
         else
             builder.Select();
         builder.AppendColumn(TaskPeopleObject.TPEOP_ID);
         builder.AppendColumn(TaskPeopleObject.TASK_ID);
         builder.AppendColumn(TaskPeopleObject.EMP_ID);
         builder.AppendColumn(TaskPeopleObject.SUP_ID);
         builder.AppendColumn(TaskPeopleObject.CUS_ID);
         builder.AppendColumn(TaskPeopleObject.ASSIGNEE);
         builder.AppendColumn(TaskPeopleObject.REPORTER);
         builder.AppendColumn(EmployeeObject.EMP_ID);
         builder.AppendColumn(EmployeeObject.EMAIL);
         builder.AppendColumn(EmployeeObject.TRANSC_ID);
         builder.AppendColumn(EmployeeObject.TRANSI_ID);
         builder.AppendColumn(EmployeeObject.NAME);
         builder.AppendColumn(EmployeeObject.SURNAME);
         builder.AppendColumn(EmployeeObject.ARCHIVE);
         builder.AppendColumn(EmployeeObject.LAN_ID);
         builder.AppendColumn(EmployeeObject.TRANSC_LANGUAGE);
         builder.AppendColumn(EmployeeObject.REPEAT_MAIL);
         builder.AppendColumn(LanguageObject.LAN_ID, "EmployeeLanguage");
         builder.AppendColumn(LanguageObject.LANGUAGE, "EmployeeLanguage");
         builder.AppendColumn(LanguageObject.LANGUAGE_DUTCH, "EmployeeLanguage");
         builder.AppendColumn(SupplierObject.SUP_ID);
         builder.AppendColumn(SupplierObject.EMAIL);
         builder.AppendColumn(SupplierObject.TRANSC_ID);
         builder.AppendColumn(UnknownObject.UNK_ID);
         builder.AppendColumn(UnknownObject.EMAIL);
         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.AppendColumn(TaskObject.CREATION_DATE);
         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(TaskPeopleObject.TABLE);
         builder.AppendLeftJoin(EmployeeObject.TABLE, TaskPeopleObject.EMP_ID, EmployeeObject.EMP_ID);
         builder.AppendLeftJoin(SupplierObject.TABLE, TaskPeopleObject.SUP_ID, SupplierObject.SUP_ID);
         builder.AppendLeftJoin(CustomerObject.TABLE, TaskPeopleObject.CUS_ID, CustomerObject.CUS_ID);
         builder.AppendLeftJoin(UnknownObject.TABLE, TaskPeopleObject.UNK_ID, UnknownObject.UNK_ID);
         builder.AppendLeftJoin(TaskObject.TABLE, TaskPeopleObject.TASK_ID, TaskObject.TASK_ID);
         builder.AppendLeftJoin(LanguageObject.TABLE, "EmployeeLanguage",LanguageObject.ConvertColumnToAlias(LanguageObject.LAN_ID, "EmployeeLanguage"),EmployeeObject.LAN_ID );
         return builder.Query;
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:71，代码来源:TaskPeopleDataService.cs


注：本文中的QueryBuilder.AppendLeftJoin方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。