本文整理汇总了C#中QueryBuilder.AppendInnerJoin方法的典型用法代码示例。如果您正苦于以下问题：C# QueryBuilder.AppendInnerJoin方法的具体用法？C# QueryBuilder.AppendInnerJoin怎么用？C# QueryBuilder.AppendInnerJoin使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类QueryBuilder的用法示例。
在下文中一共展示了QueryBuilder.AppendInnerJoin方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的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(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.AppendColumn(MaterialCategoryObject.CATEGORY);
builder.AppendColumn(MaterialCategoryObject.MATCAT_ID);
builder.AppendFromTable(MaterialSubTypeObject.TABLE);
builder.AppendInnerJoin(MaterialTypeObject.TABLE, MaterialSubTypeObject.MATTYP_ID, MaterialTypeObject.MATTYP_ID);
builder.AppendInnerJoin(MaterialCategoryObject.TABLE, MaterialTypeObject.MATCAT_ID, MaterialCategoryObject.MATCAT_ID);
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(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);
}
}示例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(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);
}
}示例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(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);
}
}