本文整理汇总了C#中QueryBuilder.Select方法的典型用法代码示例。如果您正苦于以下问题:C# QueryBuilder.Select方法的具体用法?C# QueryBuilder.Select怎么用?C# QueryBuilder.Select使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类QueryBuilder
的用法示例。
在下文中一共展示了QueryBuilder.Select方法的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);
}
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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);
}
}
示例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;
}