本文整理汇总了C#中SqlField类的典型用法代码示例。如果您正苦于以下问题：C# SqlField类的具体用法？C# SqlField怎么用？C# SqlField使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
SqlField类属于命名空间，在下文中一共展示了SqlField类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetIdentityExpression
public override ISqlExpression GetIdentityExpression(SqlTable table, SqlField identityField, bool forReturning)
{
if (table.SequenceAttributes != null)
return new SqlExpression("GEN_ID(" + table.SequenceAttributes[0].SequenceName + ", 1)", Precedence.Primary);
return base.GetIdentityExpression(table, identityField, forReturning);
}示例2: GetIdentityExpression
public override ISqlExpression GetIdentityExpression(SqlTable table, SqlField identityField, bool forReturning)
{
if (table.SequenceAttributes != null)
{
var attr = GetSequenceNameAttribute(table, false);
if (attr != null)
return new SqlExpression(attr.SequenceName + ".nextval", Precedence.Primary);
}
return base.GetIdentityExpression(table, identityField, forReturning);
}示例3: Address
public Address()
{
party_id = new SqlField("party_id", SqlDbType.BigInt);
address_format_type_cd_id = new SqlField("address_format_type_cd_id", SqlDbType.BigInt, isNullable: true);
address_type_cd_id = new SqlField("address_type_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.ADDRESS_TYPE);
attention = new SqlField("attention", SqlDbType.VarChar, isNullable: true, maxLength: 50);
city = new SqlField("city", SqlDbType.VarChar, isNullable: true, maxLength: 30);
country = new SqlField("country", SqlDbType.VarChar, isNullable: true, maxLength: 30);
county = new SqlField("county", SqlDbType.VarChar, isNullable: true, maxLength: 50);
postal_code = new SqlField("postal_code", SqlDbType.VarChar, isNullable: true, maxLength: 10);
state = new SqlField("state", SqlDbType.VarChar, isNullable: true, maxLength: 50);
street_3 = new SqlField("street_3", SqlDbType.VarChar, isNullable: true, maxLength: 50);
street_aux = new SqlField("street_aux", SqlDbType.VarChar, isNullable: true, maxLength: 50);
street_main = new SqlField("street_main", SqlDbType.VarChar, isNullable: true, maxLength: 50);
usage_cd_id = new SqlField("usage_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.ADDRESS_USAGE);
}示例4: BuildCreateTableFieldType
protected override void BuildCreateTableFieldType(SqlField field)
{
if (field.IsIdentity)
{
if (field.DataType == DataType.Int32)
{
StringBuilder.Append("SERIAL");
return;
}
if (field.DataType == DataType.Int64)
{
StringBuilder.Append("SERIAL8");
return;
}
}
base.BuildCreateTableFieldType(field);
}示例5: Rule_assignment
public Rule_assignment()
{
attached_to_id = new SqlField("attached_to_id", SqlDbType.BigInt);
attached_to_type_cd_id = new SqlField("attached_to_type_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.SYSTEM_OBJECT_TYPE);
start_date = new SqlField("start_date", SqlDbType.DateTime);
end_date = new SqlField("end_date", SqlDbType.DateTime, isNullable: true);
rule_id = new SqlField("rule_id", SqlDbType.BigInt, isNullable: true);
rule_id_old = new SqlField("rule_id_old", SqlDbType.VarChar, isNullable: true, maxLength: 100);
}示例6: FindField
static SelectQuery.TableSource FindField(SqlField field, SelectQuery.TableSource table)
{
if (field.Table == table.Source)
return table;
foreach (var @join in table.Joins)
{
var t = FindField(field, @join.Table);
if (t != null)
return @join.Table;
}
return null;
}示例7: Template
public Template()
{
name = new SqlField("name", SqlDbType.VarChar, maxLength: 250);
start_date = new SqlField("start_date", SqlDbType.DateTime);
template_category_cd_id = new SqlField("template_category_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.TEMPLATE_CATEGORY);
template_text = new SqlField("template_text", SqlDbType.Text);
description = new SqlField("description", SqlDbType.VarChar, isNullable: true, maxLength: 250);
end_date = new SqlField("end_date", SqlDbType.DateTime, isNullable: true);
template_type_cd_id = new SqlField("template_type_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.TEMPLATE_TYPE);
}示例8: Settlement_config
public Settlement_config()
{
business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
check_group_id = new SqlField("check_group_id", SqlDbType.SmallInt);
settlement_method_cd_id = new SqlField("settlement_method_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.SETTLEMENT_METHOD);
attached_to_id = new SqlField("attached_to_id", SqlDbType.BigInt, isNullable: true);
attached_to_type_cd_id = new SqlField("attached_to_type_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.SYSTEM_OBJECT_TYPE);
auto_close_criteria = new SqlField("auto_close_criteria", SqlDbType.VarChar, isNullable: true, maxLength: 500);
auto_closeout_time = new SqlField("auto_closeout_time", SqlDbType.VarChar, isNullable: true, maxLength: 30);
bank_number = new SqlField("bank_number", SqlDbType.VarChar, isNullable: true, maxLength: 44);
check_pay_to_name = new SqlField("check_pay_to_name", SqlDbType.VarChar, isNullable: true, maxLength: 250);
checking_account_number = new SqlField("checking_account_number", SqlDbType.VarChar, isNullable: true, maxLength: 54);
is_auto_closeout = new SqlField("is_auto_closeout", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
is_check_per_order = new SqlField("is_check_per_order", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
is_check_per_order_pos = new SqlField("is_check_per_order_pos", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
is_close_children_on_auto_closeout = new SqlField("is_close_children_on_auto_closeout", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
is_close_prior_business_day = new SqlField("is_close_prior_business_day", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
no_closeout_dates = new SqlField("no_closeout_dates", SqlDbType.VarChar, isNullable: true, maxLength: 100);
prior_day_time_offset_minutes = new SqlField("prior_day_time_offset_minutes", SqlDbType.Int, isNullable: true);
report_group_id = new SqlField("report_group_id", SqlDbType.SmallInt, isNullable: true);
report_template_id = new SqlField("report_template_id", SqlDbType.BigInt, isNullable: true);
settlement_report_cd_id = new SqlField("settlement_report_cd_id", SqlDbType.BigInt, isNullable: true);
}示例9: Rule
public Rule()
{
rule_name = new SqlField("rule_name", SqlDbType.VarChar, maxLength: 100);
rule_type_cd_id = new SqlField("rule_type_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.RULE_TYPE);
run_location_cd_id = new SqlField("run_location_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.RULE_RUN_LOCATION);
is_exclude_from_cache = new SqlField("is_exclude_from_cache", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
rule_class = new SqlField("rule_class", SqlDbType.VarChar, isNullable: true, maxLength: 255);
rule_display_name = new SqlField("rule_display_name", SqlDbType.VarChar, isNullable: true, maxLength: 256);
trigger_cd_id = new SqlField("trigger_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.RULE_TYPE);
}示例10: Business_unit_batch_receipt_config
public Business_unit_batch_receipt_config()
{
name = new SqlField("name", SqlDbType.VarChar, maxLength: 50);
party_id = new SqlField("party_id", SqlDbType.BigInt);
seq_no = new SqlField("seq_no", SqlDbType.SmallInt);
config = new SqlField("config", SqlDbType.Image, isNullable: true);
}示例11: BuildCreateTableIdentityAttribute1
protected override void BuildCreateTableIdentityAttribute1(SqlField field)
{
StringBuilder.Append("GENERATED BY DEFAULT AS IDENTITY");
}示例12: BuildCreateTableIdentityAttribute1
protected override void BuildCreateTableIdentityAttribute1(SqlField field)
{
StringBuilder.Append("AUTO_INCREMENT");
}示例13: Business_unit_merchant_number
public Business_unit_merchant_number()
{
business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
is_card_present = new SqlField("is_card_present", SqlDbType.Char, maxLength: 1, isFlag: true);
start_date = new SqlField("start_date", SqlDbType.DateTime);
visa_mastercard_id = new SqlField("visa_mastercard_id", SqlDbType.VarChar, maxLength: 20);
amex_id = new SqlField("amex_id", SqlDbType.VarChar, isNullable: true, maxLength: 20);
discover_id = new SqlField("discover_id", SqlDbType.VarChar, isNullable: true, maxLength: 20);
end_date = new SqlField("end_date", SqlDbType.DateTime, isNullable: true);
is_tax_number = new SqlField("is_tax_number", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
is_vcfee_tax_number = new SqlField("is_vcfee_tax_number", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
provider_id = new SqlField("provider_id", SqlDbType.VarChar, isNullable: true, maxLength: 5);
}示例14: Business_unit_order_comment
public Business_unit_order_comment()
{
business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
comment_cd_id = new SqlField("comment_cd_id", SqlDbType.BigInt);
end_date = new SqlField("end_date", SqlDbType.DateTime);
start_date = new SqlField("start_date", SqlDbType.DateTime);
display_order = new SqlField("display_order", SqlDbType.SmallInt, isNullable: true);
order_processing_location_cd_id = new SqlField("order_processing_location_cd_id", SqlDbType.BigInt, isNullable: true);
override_template_id = new SqlField("override_template_id", SqlDbType.BigInt, isNullable: true);
}示例15: Business_unit_correspondence_reason
public Business_unit_correspondence_reason()
{
business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
correspondence_reason_cd_id = new SqlField("correspondence_reason_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.CORRESPONDENCE_REASON);
end_date = new SqlField("end_date", SqlDbType.DateTime);
start_date = new SqlField("start_date", SqlDbType.DateTime);
display_order = new SqlField("display_order", SqlDbType.SmallInt, isNullable: true);
order_processing_location_cd_id = new SqlField("order_processing_location_cd_id", SqlDbType.BigInt, isNullable: true, codeType: SystemCodeType.ORDER_PLACEMENT_LOCATION);
override_template_id = new SqlField("override_template_id", SqlDbType.BigInt, isNullable: true);
}