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

C# QueryBuilder.AppendFromTable方法代码示例

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


在下文中一共展示了QueryBuilder.AppendFromTable方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的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(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);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:27，代码来源:TaskDataService.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(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

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

示例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(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);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:32，代码来源:CustomerDataService.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(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);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:33，代码来源:EmployeeDataService.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(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);
            }
        }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:27，代码来源:FuelCorrectionDataService.cs

示例9: 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(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);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:51，代码来源:FuelDataService.cs

示例10: 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

示例11: 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(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);
            }
        }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:44，代码来源:FuelDeliveryDataService.cs

示例12: 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

示例13: 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(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);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:21，代码来源:UnknownDataService.cs

示例14: 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(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);
     }
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:22，代码来源:VehicleTransicsLinkDataService.cs

示例15: GetDescription

 public string GetDescription(Guid id)
 {
     string description = "";
     QueryBuilder builder;
     DataSet ds;
     try
     {
         builder = new QueryBuilder();
         builder.Select();
         builder.AppendColumn(TaskObject.DESCRIPTION);
         builder.AppendFromTable(TaskObject.TABLE);
         builder.AppendWhereString(TaskObject.TASK_ID, id.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST_LAST);
         ds = this.ExecuteDataSet(builder.Query, false);
         if (ds.Tables[0].Rows.Count > 0)
             description = ds.Tables[0].Rows[0][TaskObject.DESCRIPTION].ToString();
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return description;
 }
开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:22，代码来源:TaskDataService.cs


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