C# QueryBuilder.Append方法代码示例

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

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

示例1: GetMemosByMaintenanceID

 public MemoObjectCollection GetMemosByMaintenanceID(MaterialObject material)
 {
     MemoObjectCollection memos = new MemoObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendWhereString(MemoObject.MAT_ID, material.MatID.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST);
         builder.Append("AND " + MemoObject.MAT_ID + " is not null ");
         memos = MemoConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return memos;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:18，代码来源:MemoDataService.cs

示例2: GetByMaterialCateogry

 public RevisionObjectCollection GetByMaterialCateogry(MaterialCategoryObject materialCategory)
 {
     RevisionObjectCollection revisions = new RevisionObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendWhereString(RevisionObject.MATCAT_ID, materialCategory.MatcatID.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST);
         builder.Append("AND " + RevisionObject.MATCAT_ID + " is not null ");
         revisions = RevisionConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return revisions;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:18，代码来源:RevisionDataService.cs

示例3: GetAll

 public ScheduleObjectCollection GetAll()
 {
     ScheduleObjectCollection parameters = new ScheduleObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false,0));
         parameters = ScheduleConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return parameters;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:16，代码来源:ScheduleDataService.cs

示例4: GetAll

 public VehicleTransicsLinkObjectCollection GetAll()
 {
     VehicleTransicsLinkObjectCollection vehicleTransicsLinks = new VehicleTransicsLinkObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         vehicleTransicsLinks = VehicleTransicsLinkConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return vehicleTransicsLinks;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:16，代码来源:VehicleTransicsLinkDataService.cs

示例5: GetAll

 public SupplierObjectCollection GetAll()
 {
     SupplierObjectCollection suppliers = new SupplierObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false,0));
         builder.AppendOrderBy(SupplierObject.TRANSC_ID, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
         suppliers = SupplierConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return suppliers;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:17，代码来源:SupplierDataService.cs

示例6: GetAll

 public LanguageObjectCollection GetAll()
 {
     LanguageObjectCollection languages = new LanguageObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendOrderBy(LanguageObject.LANGUAGE, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
         languages = LanguageConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return languages;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:17，代码来源:LanguageDataService.cs

示例7: GetAll

 public ParameterSystemObjectCollection GetAll()
 {
     ParameterSystemObjectCollection parameters = new ParameterSystemObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendOrderBy(ParameterSystemObject.KEYNAME, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
         parameters = ParameterSystemConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return parameters;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:17，代码来源:ParameterSystemDataService.cs

示例8: GetAll

 public UnknownObjectCollection GetAll()
 {
     UnknownObjectCollection unknowns = new UnknownObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendOrderBy(UnknownObject.EMAIL, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
         unknowns = UnknownConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return unknowns;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:17，代码来源:UnknownDataService.cs

示例9: GetAll

 public FuelCorrectionObjectCollection GetAll()
 {
     FuelCorrectionObjectCollection fuelCorrections = new FuelCorrectionObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendOrderBy(FuelCorrectionObject.DATE_FROM, QueryBuilder.OrderByType.DESC, QueryBuilder.ParameterLocation.FIRST_LAST);
         fuelCorrections = FuelCorrectionConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return fuelCorrections;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:17，代码来源:FuelCorrectionDataService.cs

示例10: GetAll

 public MaterialSubTypeObjectCollection GetAll()
 {
     MaterialSubTypeObjectCollection materialSubTypes = new MaterialSubTypeObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendOrderBy(MaterialSubTypeObject.SUBTYPE, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
         materialSubTypes = MaterialSubTypeConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return materialSubTypes;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:17，代码来源:MaterialSubTypeDataService.cs

示例11: GetAll

 public VehicleMileageObjectCollection GetAll()
 {
     VehicleMileageObjectCollection vehicleMileages = new VehicleMileageObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendOrderBy(VehicleMileageObject.TRANSI_NM_MAT, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST);
         builder.AppendOrderBy(VehicleMileageObject.DATE, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.LAST);
         vehicleMileages = VehicleMileageConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return vehicleMileages;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:18，代码来源:VehicleMileageDataService.cs

示例12: GetAll

 public EmployeeObjectCollection GetAll()
 {
     EmployeeObjectCollection employees = new EmployeeObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false,0));
         builder.AppendWhereBoolean(EmployeeObject.ARCHIVE, false, QueryBuilder.ParameterLocation.FIRST_LAST);
         builder.AppendOrderBy(EmployeeObject.NAME, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
         employees = EmployeeConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0], "");
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return employees;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:18，代码来源:EmployeeDataService.cs

示例13: GetTypesByCategorie

 public MaterialTypeObjectCollection GetTypesByCategorie(MaterialCategoryObject category)
 {
     MaterialTypeObjectCollection materialTypes = new MaterialTypeObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendWhereString(MaterialTypeObject.MATCAT_ID, category.MatcatID.ToString(), QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST);
         builder.Append("AND " + MaterialTypeObject.MATCAT_ID + " is not null ");
         builder.AppendOrderBy(MaterialTypeObject.TYPE, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
         materialTypes = MaterialTypeConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
     }
     return materialTypes;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:19，代码来源:MaterialTypeDataService.cs

示例14: GetActive

 public TaskObjectCollection GetActive()
 {
     TaskObjectCollection tasks = new TaskObjectCollection();
     QueryBuilder builder;
     try
     {
         builder = new QueryBuilder();
         builder.Append(this.BaseQuery(false, 0));
         builder.AppendWhereInteger(TaskObject.STATUS, (int)TIS.Framework.Common.Enumeration.Task.Status.Open, QueryBuilder.ParameterLocation.FIRST_LAST);
         builder.AppendOrderBy(TaskObject.CREATION_DATE, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
         tasks = TaskConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);
     }
     catch (System.Exception exception1)
     {
         Exception innerException = exception1;
         throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
     }
     return tasks;
 }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:19，代码来源:TaskDataService.cs

示例15: GetByKeyName

        public ParameterSystemObject GetByKeyName(string keyName)
        {
            ParameterSystemObjectCollection parameters = new ParameterSystemObjectCollection();
            QueryBuilder builder;
            try
            {
                builder = new QueryBuilder();
                builder.Append(this.BaseQuery(false, 0));
                builder.AppendWhereString(ParameterSystemObject.KEYNAME, keyName, QueryBuilder.ComparisonOperators.Equal, QueryBuilder.ParameterLocation.FIRST_LAST);
                builder.AppendOrderBy(ParameterSystemObject.KEYNAME, QueryBuilder.OrderByType.ASC, QueryBuilder.ParameterLocation.FIRST_LAST);
                parameters = ParameterSystemConvertor.DataTableToCollection(this.ExecuteDataSet(builder.Query, false).Tables[0]);

                if (parameters.Count > 0)
                    return parameters[0];
            }
            catch (System.Exception exception1)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name, exception1);
            }
            return null;
        }

开发者ID:GianiWVL，项目名称:VUYLSTEKE，代码行数:21，代码来源:ParameterSystemDataService.cs

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