本文整理汇总了C#中SqlField类的典型用法代码示例。如果您正苦于以下问题:C# SqlField类的具体用法?C# SqlField怎么用?C# SqlField使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
SqlField类属于命名空间,在下文中一共展示了SqlField类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的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);
}
开发者ID:MajidSafari,项目名称:bltoolkit,代码行数:7,代码来源:FirebirdSqlProvider.cs
示例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);
}
开发者ID:ivanoffalex,项目名称:bltoolkit,代码行数:12,代码来源:OracleSqlProvider.cs
示例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);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:16,代码来源:SqlEntities.cs
示例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);
}
开发者ID:jack128,项目名称:linq2db,代码行数:19,代码来源:InformixSqlBuilder.cs
示例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);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:9,代码来源:SqlEntities.cs
示例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;
}
开发者ID:petedv,项目名称:linq2db,代码行数:15,代码来源:SelectQueryOptimizer.cs
示例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);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:10,代码来源:SqlEntities.cs
示例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);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:23,代码来源:SqlEntities.cs
示例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);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:10,代码来源:SqlEntities.cs
示例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);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:7,代码来源:SqlEntities.cs
示例11: BuildCreateTableIdentityAttribute1
protected override void BuildCreateTableIdentityAttribute1(SqlField field)
{
StringBuilder.Append("GENERATED BY DEFAULT AS IDENTITY");
}
开发者ID:Convey-Compliance,项目名称:linq2db,代码行数:4,代码来源:SapHanaSqlBuilder.cs
示例12: BuildCreateTableIdentityAttribute1
protected override void BuildCreateTableIdentityAttribute1(SqlField field)
{
StringBuilder.Append("AUTO_INCREMENT");
}
开发者ID:Convey-Compliance,项目名称:linq2db,代码行数:4,代码来源:MySqlSqlBuilder.cs
示例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);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:13,代码来源:SqlEntities.cs
示例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);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:10,代码来源:SqlEntities.cs
示例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);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:10,代码来源:SqlEntities.cs
示例16: Business_unit_connect_info
public Business_unit_connect_info()
{
business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
ftp_folder = new SqlField("ftp_folder", SqlDbType.VarChar, isNullable: true, maxLength: 100);
ftp_password = new SqlField("ftp_password", SqlDbType.VarChar, isNullable: true, maxLength: 128);
ftp_user = new SqlField("ftp_user", SqlDbType.VarChar, isNullable: true, maxLength: 50);
gpg_options = new SqlField("gpg_options", SqlDbType.VarChar, isNullable: true, maxLength: 50);
gpgp_key_name = new SqlField("gpgp_key_name", SqlDbType.VarChar, isNullable: true, maxLength: 50);
is_ftp_s = new SqlField("is_ftp_s", SqlDbType.Char, isNullable: true, maxLength: 1, isFlag: true);
postback_password = new SqlField("postback_password", SqlDbType.VarChar, isNullable: true, maxLength: 128);
postback_url = new SqlField("postback_url", SqlDbType.VarChar, isNullable: true, maxLength: 1000);
postback_user = new SqlField("postback_user", SqlDbType.VarChar, isNullable: true, maxLength: 50);
server_name = new SqlField("server_name", SqlDbType.VarChar, isNullable: true, maxLength: 50);
share_name = new SqlField("share_name", SqlDbType.VarChar, isNullable: true, maxLength: 100);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:15,代码来源:SqlEntities.cs
示例17: Business_unit_close_method
public Business_unit_close_method()
{
business_unit_party_id = new SqlField("business_unit_party_id", SqlDbType.BigInt);
close_method_cd_id = new SqlField("close_method_cd_id", SqlDbType.BigInt, codeType: SystemCodeType.EOD_CLOSE_METHOD);
display_index = new SqlField("display_index", SqlDbType.SmallInt, isNullable: true);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:6,代码来源:SqlEntities.cs
示例18: GetColumn
static ISqlExpression GetColumn(QueryData data, SqlField field)
{
foreach (var query in data.Queries)
{
var q = query.Query;
foreach (var table in q.From.Tables)
{
var t = FindField(field, table);
if (t != null)
{
var n = q.Select.Columns.Count;
var idx = q.Select.Add(field);
if (n != q.Select.Columns.Count)
if (!q.GroupBy.IsEmpty || q.Select.Columns.Any(c => IsAggregationFunction(c.Expression)))
q.GroupBy.Items.Add(field);
return q.Select.Columns[idx];
}
}
}
return null;
}
开发者ID:petedv,项目名称:linq2db,代码行数:26,代码来源:SelectQueryOptimizer.cs
示例19: Terminal_id
public Terminal_id()
{
business_unit_merchant_number_id = new SqlField("business_unit_merchant_number_id", SqlDbType.BigInt);
start_date = new SqlField("start_date", SqlDbType.DateTime);
terminal_id = new SqlField("terminal_id", SqlDbType.VarChar, maxLength: 20);
business_unit_pos_terminal_id = new SqlField("business_unit_pos_terminal_id", SqlDbType.BigInt, isNullable: true);
end_date = new SqlField("end_date", SqlDbType.DateTime, isNullable: true);
}
开发者ID:amyhickman,项目名称:RapidAgencyDevelopment,代码行数:8,代码来源:SqlEntities.cs
示例20: VisitField
protected override SqlExpression VisitField(SqlField expr)
{
// нужно вытащить имя источника поля
string sourceName = null;
if (!_nameMap.TryGetValue(expr.Source, out sourceName))
{
sourceName = "T" + _nameMap.Count;
_nameMap[expr.Source] = sourceName;
}
if (!String.IsNullOrEmpty(sourceName))
{
WriteName(sourceName);
_builder.Append('.');
}
WriteName(expr.Name);
return expr;
}
开发者ID:radischevo,项目名称:Radischevo.Wahha,代码行数:18,代码来源:SqlDbFormatter.cs
注:本文中的SqlField类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论