• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

C# DbColumn类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中DbColumn的典型用法代码示例。如果您正苦于以下问题:C# DbColumn类的具体用法?C# DbColumn怎么用?C# DbColumn使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



DbColumn类属于命名空间,在下文中一共展示了DbColumn类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: CsvReader

        public CsvReader(TextReader reader, CsvReaderOptions options)
        {
            _lineReader = new LineReader(options, reader);

            _cursor = _lineReader.GetLines().GetEnumerator();

            // Read the first line, as we expect it to have headers
            _cursor.MoveNext();

            // The file format here is that the first row includes the
            // columnHeaders in the format "<name>:<type>"
            var columnHeaders = _cursor.Current;

            var columns = new DbColumn[columnHeaders.Length];

            for (var i = 0; i < columnHeaders.Length; i++) {
                // Unquote headers
                var header = columnHeaders[i].Replace("\"", "");
                var splitHeader = header.Split(':');

                if (splitHeader.Length == 2) {
                    var columnName = splitHeader[0];
                    var typeHeader = splitHeader[1];

                    var mungType = MungType.Parse(typeHeader);

                    columns[i] = new DbColumn(columnName, mungType);
                } else {
                    columns[i] = new DbColumn(header, MungType.Get(MungTypeCode.String));

                }
            }
            _columns = columns.ToList();
        }
开发者ID:GrowingData,项目名称:Utilities,代码行数:34,代码来源:CsvReader.cs


示例2: CheckTable

        /// <summary>
        /// 
        /// </summary>
        /// <param name="tableName"></param>
        /// <param name="columns"></param>
        /// <returns></returns>
        public override bool CheckTable(string tableName, out DbColumn[] columns)
        {
            columns = null;
            string commandText = string.Format("SELECT count(*) FROM sys.objects WHERE object_id = OBJECT_ID(N'{0}') AND type in (N'U')", tableName);
            if (SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, commandText).ToInt() > 0)
            {
                var list = new List<DbColumn>();
                commandText = string.Format("select c.name as ColumnName, t.name as ColumnType, c.scale, c.length,c.isnullable from syscolumns c join systypes t on c.xtype=t.xtype where t.name <> 'sysname' and c.id=object_id('{0}') order by colorder ASC", tableName);

                using (var dataReader = SqlHelper.ExecuteReader(ConnectionString, CommandType.Text, commandText))
                {
                    while (dataReader.Read())
                    {
                        var column = new DbColumn();
                        column.Name = dataReader[0].ToNotNullString();
                        column.DbType = dataReader[1].ToNotNullString();
                        column.Scale = dataReader[2].ToInt();
                        column.Length = dataReader[3].ToLong();
                        column.Type = ConvertToObjectType(ConvertToDbType(column.DbType));
                        list.Add(column);
                    }
                }
                columns = list.ToArray();
                return true;
            }
            return false;
        }
开发者ID:JerryDeveloper,项目名称:Scut,代码行数:33,代码来源:SqlDataProvider.cs


示例3: LoadDb

        public static DbTable LoadDb(DbDataReader reader)
        {
            if (!reader.Read()) {
                return null;
            }

            var tbl = new DbTable((string)reader["TABLE_NAME"]);

            var firstColumn = new DbColumn(
                (string)reader["COLUMN_NAME"],
                (string)reader["DATA_TYPE"]
            );
            tbl.Columns = new List<DbColumn>() { firstColumn };

            while (reader.Read()) {
                if (tbl.Name != (string)reader["TABLE_NAME"]) {
                    break;
                }
                tbl.Columns.Add(new DbColumn(
                    (string)reader["COLUMN_NAME"],
                    (string)reader["DATA_TYPE"]
                ));

            }
            return tbl;
        }
开发者ID:GrowingData,项目名称:Mung,代码行数:26,代码来源:DbTable.cs


示例4: CheckTable

        /// <summary>
        /// 
        /// </summary>
        /// <param name="tableName"></param>
        /// <param name="columns"></param>
        /// <returns></returns>
        public override bool CheckTable(string tableName, out DbColumn[] columns)
        {
            columns = null;
            string commandText = string.Format("SELECT count(1) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE `TABLE_SCHEMA`='{0}' AND `TABLE_NAME`='{1}'", ConnectionSetting.DatabaseName, tableName);
            if (MySqlHelper.ExecuteScalar(ConnectionString, commandText).ToInt() > 0)
            {
                var list = new List<DbColumn>();
                commandText = string.Format("SELECT Column_Name AS ColumnName,Data_Type AS ColumnType, NUMERIC_SCALE AS scale, CHARACTER_MAXIMUM_LENGTH AS Length FROM information_schema.`columns` WHERE `TABLE_SCHEMA`='{0}' AND `TABLE_NAME`='{1}'", ConnectionSetting.DatabaseName, tableName);

                using (var dataReader = MySqlHelper.ExecuteReader(ConnectionString, commandText))
                {
                    while (dataReader.Read())
                    {
                        var column = new DbColumn();
                        column.Name = dataReader[0].ToNotNullString();
                        column.DbType = dataReader[1].ToNotNullString();
                        column.Scale = dataReader[2].ToInt();
                        column.Length = dataReader[3].ToLong();
                        column.Type = ConvertToObjectType(ConvertToDbType(column.DbType));

                        list.Add(column);
                    }
                }
                columns = list.ToArray();
                return true;
            }
            return false;
        }
开发者ID:haiya,项目名称:Scut,代码行数:34,代码来源:MySqlDataProvider.cs


示例5: GetDatabaseCollection

        /// <summary>
        /// The get database collection.
        /// </summary>
        /// <param name="connectionString">
        /// The connection string.
        /// </param>
        /// <param name="includeTable">
        /// The include table.
        /// </param>
        /// <param name="includeColumn">
        /// The include column.
        /// </param>
        /// <returns>
        /// The <see cref="DatabaseCollection"/>.
        /// </returns>
        public DatabaseCollection GetDatabaseCollection(
            string connectionString,
            bool includeTable = false,
            bool includeColumn = false)
        {
            var databaseCollection = new DatabaseCollection();

            using (var sqlConnection = new SqlConnection(connectionString))
            {
                var serverConnection = new ServerConnection(sqlConnection);
                var server = new Server(serverConnection);

                foreach (
                    var database in
                        server.Databases.Cast<Database>().AsQueryable().Where(d => d.IsSystemObject == false))
                {
                    var dbItem = new EntityTemplate.Database { Name = database.Name };
                    if (includeTable && database.Tables.Count > 0)
                    {
                        foreach (var table in database.Tables.Cast<Table>().AsQueryable().Where(t => t.IsSystemObject == false))
                        {
                            var dbTableItem = new DbTable { Name = table.Name };
                            dbTableItem.Description = table.ExtendedProperties.Count > 0 ? table.ExtendedProperties["MS_Description"].Value.ToString() : string.Empty;

                            if (includeColumn && table.Columns.Count > 0)
                            {
                                foreach (var column in table.Columns.Cast<Column>().AsQueryable())
                                {
                                    var dbColumnItem = new DbColumn();

                                    dbColumnItem.Name = column.Name;
                                    dbColumnItem.Description = column.ExtendedProperties.Count > 0 ? column.ExtendedProperties["MS_Description"].Value.ToString() : string.Empty;

                                    dbColumnItem.IsPrimaryKey = column.InPrimaryKey;
                                    dbColumnItem.IsIdentityColumn = column.Identity;

                                    dbColumnItem.ColumnType = column.DataType.SqlDataType.ToString();
                                    dbColumnItem.AllowEmpty = column.Nullable;
                                    dbColumnItem.DefaultValue = column.Default;

                                    dbTableItem.Columns.Add(dbColumnItem);
                                }
                            }

                            dbItem.Tables.Add(dbTableItem);
                        }
                    }

                    databaseCollection.Add(dbItem);
                }
            }

            return databaseCollection;
        }
开发者ID:lei-zhu,项目名称:EntityTemplate,代码行数:69,代码来源:SqlSchemaProvider.cs


示例6: DbTable

        public DbTable(string tableName, MungedDataReader reader)
        {
            Name = tableName;
            Columns = new List<DbColumn>();

            for (var i = 0; i < reader.ColumnNames.Length; i++) {
                var type = reader.ColumnTypes[i];
                var name = reader.ColumnNames[i];
                var c = new DbColumn(name, type);
                Columns.Add(c);
            }
        }
开发者ID:GrowingData,项目名称:Mung,代码行数:12,代码来源:DbTable.cs


示例7: qCom_Contact

 protected qCom_Contact(DbRow c)
 {
     container = c;
        container.SetContainerName("qCom_Contacts");
        contact_id = container.NewColumn<Int32>("ContactID", true);
        scope_id = container.NewColumn<Int32>("ScopeID");
        available = container.NewColumn<String>("Available");
        created = container.NewColumn<DateTime>("Created");
        created_by = container.NewColumn<Int32>("CreatedBy");
        last_modified = container.NewColumn<DateTime?>("LastModified");
        last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
        mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
        first_name = container.NewColumn<String>("FirstName");
        last_name = container.NewColumn<String>("LastName");
        email = container.NewColumn<String>("Email");
        keywords = container.NewColumn<String>("Keywords");
        source = container.NewColumn<String>("Source");
        user_id = container.NewColumn<Int32>("UserID");
        ok_email = container.NewColumn<String>("OkEmail");
        did = container.NewColumn<String>("DID");
        partner = container.NewColumn<String>("Partner");
        main_group = container.NewColumn<Int32>("MainGroup");
        sub_group = container.NewColumn<Int32>("SubGroup");
        custom_html_element = container.NewColumn<String>("CustomHTMLElement");
        dm_misc = container.NewColumn<String>("DM_Misc");
        unsubscribed = container.NewColumn<DateTime?>("Unsubscribed");
        unsubscribed_campaign_id = container.NewColumn<Int32>("UnsubscribedCampaignID");
        reported_as_spam = container.NewColumn<DateTime?>("ReportedAsSpam");
        reported_as_spam_campaign_id = container.NewColumn<Int32>("ReportedAsSpamCampaignID");
        action_log = container.NewColumn<String>("ActionLog");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:31,代码来源:qCom_Contact.cs


示例8: qPtl_RoleAction

 protected qPtl_RoleAction(DbRow c)
 {
     container = c;
     container.SetContainerName("qPtl_RoleActions");
     role_action_id = container.NewColumn<Int32>("RoleActionID", true);
     scope_id = container.NewColumn<Int32>("ScopeID");
     available = container.NewColumn<String>("Available");
     created = container.NewColumn<DateTime>("Created");
     created_by = container.NewColumn<Int32>("CreatedBy");
     last_modified = container.NewColumn<DateTime?>("LastModified");
     last_modified_by = container.NewColumn<Int32?>("LastModifiedBy");
     mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
     role_id = container.NewColumn<Int32>("RoleID");
     action_id = container.NewColumn<Int32>("ActionID");
     start_days_from_now = container.NewColumn<Int32>("StartDaysFromNow");
     end_days_from_now = container.NewColumn<Int32>("EndDaysFromNow");
     after_num_logins = container.NewColumn<Int32>("AfterNumLogins");
     priority = container.NewColumn<Int32>("Priority");
     skip_allowed = container.NewColumn<String>("SkipAllowed");
     number_skips_allowed = container.NewColumn<Int32>("NumberSkipsAllowed");
     required = container.NewColumn<String>("Required");
     option_opt_out = container.NewColumn<String>("OptionOptOut");
     redirect_url = container.NewColumn<String>("RedirectURL");
     redirect_skip_url = container.NewColumn<String>("RedirectSkipURL");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:25,代码来源:qPtl_RoleAction.cs


示例9: qPtl_Task

 protected qPtl_Task(DbRow c)
 {
     container = c;
     container.SetContainerName("qPtl_Tasks");
     task_id = container.NewColumn<Int32>("TaskID", true);
     scope_id = container.NewColumn<Int32>("ScopeID");
     available = container.NewColumn<String>("Available");
     created = container.NewColumn<DateTime>("Created");
     created_by = container.NewColumn<Int32>("CreatedBy");
     last_modified = container.NewColumn<DateTime?>("LastModified");
     last_modified_by = container.NewColumn<Int32?>("LastModifiedBy");
     mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
     task_type_id = container.NewColumn<Int32>("TaskTypeID");
     assigned_to = container.NewColumn<Int32?>("AssignedTo");
     assigned_text = container.NewColumn<String>("AssignedText");
     start_date = container.NewColumn<DateTime?>("StartDate");
     due_date = container.NewColumn<DateTime?>("DueDate");
     percent_completed = container.NewColumn<Double>("PercentCompleted");
     status = container.NewColumn<String>("Status");
     name = container.NewColumn<String>("Name");
     description = container.NewColumn<String>("Description");
     importance = container.NewColumn<Int32>("Importance");
     content_type_id = container.NewColumn<Int32>("ContentTypeID");
     reference_id = container.NewColumn<Int32>("ReferenceID");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:25,代码来源:qPtl_Tasks.cs


示例10: qOrg_School

 protected qOrg_School(DbRow c)
 {
     container = c;
     container.SetContainerName("qOrg_Schools");
     school_id = container.NewColumn<Int32>("SchoolID", true);
     scope_id = container.NewColumn<Int32>("ScopeID");
     available = container.NewColumn<String>("Available");
     created = container.NewColumn<DateTime>("Created");
     created_by = container.NewColumn<Int32>("CreatedBy");
     last_modified = container.NewColumn<DateTime?>("LastModified");
     last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
     mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
     school_selector = container.NewColumn<String>("SchoolSelector");
     school = container.NewColumn<String>("School");
     address1 = container.NewColumn<String>("Address1");
     address2 = container.NewColumn<String>("Address2");
     city = container.NewColumn<String>("City");
     state_province = container.NewColumn<String>("StateProvince");
     postal_code = container.NewColumn<String>("PostalCode");
     country = container.NewColumn<String>("Country");
     district = container.NewColumn<String>("District");
     school_type = container.NewColumn<String>("SchoolType");
     school_level = container.NewColumn<String>("SchoolLevel");
     school_district_id = container.NewColumn<Int32>("SchoolDistrictID");
     school_phone = container.NewColumn<String>("SchoolPhone");
     school_fax = container.NewColumn<String>("SchoolFax");
     longitude = container.NewColumn<Decimal>("Longitude");
     latitude = container.NewColumn<Decimal>("Latitude");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:29,代码来源:qOrg_School.cs


示例11: qPtl_User

 protected qPtl_User(DbRow c)
 {
     container = c;
     container.SetContainerName("qPtl_Users");
     user_id = container.NewColumn<Int32>("UserID", true);
     org_unit_id = container.NewColumn<Int32>("OrgUnitID");
     scope_id = container.NewColumn<Int32>("ScopeID");
     available = container.NewColumn<String>("Available");
     created = container.NewColumn<DateTime>("Created");
     created_by = container.NewColumn<Int32>("CreatedBy");
     last_modified = container.NewColumn<DateTime?>("LastModified");
     last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
     mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
     username = container.NewColumn<String>("UserName");
     password = container.NewColumn<String>("Password");
     password_reset_code = container.NewColumn<String>("PasswordResetCode");
     first_name = container.NewColumn<String>("FirstName");
     last_name = container.NewColumn<String>("LastName");
     email = container.NewColumn<String>("Email");
     comments = container.NewColumn<String>("Comments");
     dm_user_id = container.NewColumn<Int32>("DM_UserID");
     dm_status_id = container.NewColumn<Int32>("DM_StatusID");
     highest_role = container.NewColumn<String>("HighestRole");
     highest_rank = container.NewColumn<Int32>("HighestRank");
     last_time_seen = container.NewColumn<DateTime?>("LastTimeSeen");
     last_ip_address = container.NewColumn<String>("LastIPAddress");
     profile_pict = container.NewColumn<String>("ProfilePict");
     status = container.NewColumn<String>("Status");
     status_date = container.NewColumn<DateTime?>("StatusDate");
     account_status = container.NewColumn<String>("AccountStatus");
     last_activity = container.NewColumn<Int32>("LastActivity");
     number_logins = container.NewColumn<Int32>("NumberLogins");
     registration_type = container.NewColumn<String>("RegistrationType");
     registration_notes = container.NewColumn<String>("RegistrationNotes");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:35,代码来源:qPtl_User.cs


示例12: qHtl_AbsenteeAnalysisVariable

 protected qHtl_AbsenteeAnalysisVariable(DbRow c)
 {
     container = c;
     container.SetContainerName("qHtl_AbsenteeAnalysisVariables");
     absentee_analysis_variable_id = container.NewColumn<Int32>("AbsenteeAnalysisVariableID", true);
     school_district_id = container.NewColumn<Int32>("SchoolDistrictID");
     solution_start_date = container.NewColumn<DateTime?>("SolutionStartDate");
     green_rate_std_multiplier = container.NewColumn<Decimal>("GreenRateSTDMultiplier");
     yellow_rate_std_multiplier = container.NewColumn<Decimal>("YellowRateSTDMultiplier");
     red_rate_std_multiplier = container.NewColumn<Decimal>("RedRateSTDMultiplier");
     green_illness_boundary = container.NewColumn<Decimal>("GreenIllnessBoundary");
     yellow_illness_boundary = container.NewColumn<Decimal>("YellowIllnessBoundary");
     red_illness_boundary = container.NewColumn<Decimal>("RedIllnessBoundary");
     green_gastrointestinal_boundary = container.NewColumn<Decimal>("GreenGastrointestinalBoundary");
     yellow_gastrointestinal_boundary = container.NewColumn<Decimal>("YellowGastrointestinalBoundary");
     red_gastrointestinal_boundary = container.NewColumn<Decimal>("RedGastrointestinalBoundary");
     green_respiratory_boundary = container.NewColumn<Decimal>("GreenRespiratoryBoundary");
     yellow_respiratory_boundary = container.NewColumn<Decimal>("YellowRespiratoryBoundary");
     red_respiratory_boundary = container.NewColumn<Decimal>("RedRespiratoryBoundary");
     green_rash_boundary = container.NewColumn<Decimal>("GreenRashBoundary");
     yellow_rash_boundary = container.NewColumn<Decimal>("YellowRashBoundary");
     red_rash_boundary = container.NewColumn<Decimal>("RedRashBoundary");
     green_other_illness_boundary = container.NewColumn<Decimal>("GreenOtherIllnessBoundary");
     yellow_other_illness_boundary = container.NewColumn<Decimal>("YellowOtherIllnessBoundary");
     red_other_illness_boundary = container.NewColumn<Decimal>("RedOtherIllnessBoundary");
     green_unknown_illness_boundary = container.NewColumn<Decimal>("GreenUnknownIllnessBoundary");
     yellow_unknown_illness_boundary = container.NewColumn<Decimal>("YellowUnknownIllnessBoundary");
     red_unknown_illness_boundary = container.NewColumn<Decimal>("RedUnknownIllnessBoundary");
     sd_formula_type = container.NewColumn<String>("SDFormulaType");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:30,代码来源:qHtl_AbsenteeAnalysisVariable.cs


示例13: qHtl_HealthProvider

 protected qHtl_HealthProvider(DbRow c)
 {
     container = c;
     container.SetContainerName("qHtl_HealthProviders");
     health_provider_id = container.NewColumn<Int32>("HealthProviderID", true);
     scope_id = container.NewColumn<Int32>("ScopeID");
     available = container.NewColumn<String>("Available");
     created = container.NewColumn<DateTime>("Created");
     created_by = container.NewColumn<Int32>("CreatedBy");
     last_modified = container.NewColumn<DateTime?>("LastModified");
     last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
     mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
     health_provider_type = container.NewColumn<String>("HealthProviderType");
     name = container.NewColumn<String>("name");
     description = container.NewColumn<String>("description");
     address1 = container.NewColumn<String>("Address1");
     address2 = container.NewColumn<String>("Address2");
     city = container.NewColumn<String>("City");
     state_province = container.NewColumn<String>("StateProvince");
     postal_code = container.NewColumn<String>("PostalCode");
     country = container.NewColumn<String>("Country");
     phone = container.NewColumn<String>("Phone");
     website = container.NewColumn<String>("Website");
     service_type = container.NewColumn<String>("ServiceType");
     service_categories = container.NewColumn<String>("ServiceCategories");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:26,代码来源:qHtl_HealthProviders.cs


示例14: qHtl_HealthWarning

 protected qHtl_HealthWarning(DbRow c)
 {
     container = c;
     container.SetContainerName("qHtl_HealthWarnings");
     health_warning_id = container.NewColumn<Int32>("HealthWarningID", true);
     created = container.NewColumn<DateTime>("Created");
     created_by = container.NewColumn<Int32>("CreatedBy");
     mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
     data_date = container.NewColumn<DateTime?>("DataDate");
     type = container.NewColumn<String>("Type");
     title = container.NewColumn<String>("Title");
     text = container.NewColumn<String>("Text");
     notes = container.NewColumn<String>("Notes");
     severity = container.NewColumn<String>("Severity");
     issued_by = container.NewColumn<Int32>("IssuedBy");
     issued_by_name = container.NewColumn<String>("IssuedByName");
     review_status = container.NewColumn<String>("ReviewStatus");
     issued_to = container.NewColumn<String>("IssuedTo");
     valid_from = container.NewColumn<DateTime?>("ValidFrom");
     valid_until = container.NewColumn<DateTime?>("ValidUntil");
     multiple_classrooms = container.NewColumn<String>("MultipleClassrooms");
     multiple_schools = container.NewColumn<String>("MultipleSchools");
     school_levels = container.NewColumn<String>("SchoolLevels");
     content_type_id = container.NewColumn<Int32>("ContentTypeID");
     reference_id = container.NewColumn<Int32>("ReferenceID");
     email_id = container.NewColumn<Int32>("EmailID");
     notification_id = container.NewColumn<Int32>("NotificationID");
     sms_message_id = container.NewColumn<Int32>("SMSMessageID");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:29,代码来源:qHtl_HealthWarnings.cs


示例15: qPtl_UserRole

 protected qPtl_UserRole(DbRow c)
 {
     container = c;
     container.SetContainerName("qPtl_UserRoles");
     user_id = container.NewColumn<Int32>("UserID", true);
     role_id = container.NewColumn<Int32>("RoleID", true);
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:7,代码来源:qPtl_UserRole.cs


示例16: qPtl_UserAction

 protected qPtl_UserAction(DbRow c)
 {
     container = c;
     container.SetContainerName("qPtl_UserActions");
     user_action_id = container.NewColumn<Int32>("UserActionID", true);
     scope_id = container.NewColumn<Int32>("ScopeID");
     available = container.NewColumn<String>("Available");
     created = container.NewColumn<DateTime>("Created");
     created_by = container.NewColumn<Int32>("CreatedBy");
     last_modified = container.NewColumn<DateTime?>("LastModified");
     last_modified_by = container.NewColumn<Int32?>("LastModifiedBy");
     mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
     user_id = container.NewColumn<Int32>("UserID");
     action_id = container.NewColumn<Int32>("ActionID");
     assign_type = container.NewColumn<String>("AssignType");
     available_from = container.NewColumn<DateTime?>("AvailableFrom");
     available_to = container.NewColumn<DateTime?>("AvailableTo");
     after_num_logins = container.NewColumn<Int32>("AfterNumLogins");
     priority = container.NewColumn<Int32>("Priority");
     skip_allowed = container.NewColumn<String>("SkipAllowed");
     number_skips_allowed = container.NewColumn<Int32>("NumberSkipsAllowed");
     required = container.NewColumn<String>("Required");
     optional_opt_out = container.NewColumn<String>("OptionalOptOut");
     user_completed = container.NewColumn<DateTime?>("UserCompleted");
     user_opt_out = container.NewColumn<DateTime?>("UserOptOut");
     user_num_skips = container.NewColumn<Int32>("UserNumSkips");
     user_last_skip = container.NewColumn<DateTime?>("UserLastSkip");
     last_user_action_session_id = container.NewColumn<Int32>("LastUserActionSessionID");
     reference_id = container.NewColumn<Int32>("ReferenceID");
     redirect_url = container.NewColumn<String>("RedirectURL");
     redirect_skip_url = container.NewColumn<String>("RedirectSkipURL");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:32,代码来源:qPtl_UserAction.cs


示例17: qCom_UserPreference

 protected qCom_UserPreference(DbRow c)
 {
     container = c;
     container.SetContainerName("qCom_UserPreferences");
     contact_preference_id = container.NewColumn<Int32>("ContactPreferenceID", true);
     user_id = container.NewColumn<Int32>("UserID");
     available = container.NewColumn<String>("Available");
     scope_id = container.NewColumn<Int32>("ScopeID");
     created = container.NewColumn<DateTime?>("Created");
     created_by = container.NewColumn<Int32>("CreatedBy");
     last_modified = container.NewColumn<DateTime?>("LastModified");
     last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
     mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
     ok_bulk_email = container.NewColumn<String>("OkBulkEmail");
     ok_email = container.NewColumn<String>("OkEmail");
     ok_phone = container.NewColumn<String>("OkPhone");
     ok_fax = container.NewColumn<String>("OkFax");
     ok_solicit = container.NewColumn<String>("OkSolicit");
     ok_mail = container.NewColumn<String>("OkMail");
     ok_partner_contact = container.NewColumn<String>("OkPartnerContact");
     ok_sms = container.NewColumn<String>("OkSms");
     ok_notifications = container.NewColumn<String>("OkNotifications");
     confirm_sms = container.NewColumn<String>("ConfirmSms");
     language_id = container.NewColumn<Int32>("LanguageID");
     mobile_pin = container.NewColumn<String>("MobilePIN");
     mobile_pin_verified = container.NewColumn<DateTime?>("MobilePINVerified");
     default_sms_did = container.NewColumn<String>("DefaultSmsDid");
     sms_active_minutes_window = container.NewColumn<Int32>("SmsActiveMinutesWindow");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:29,代码来源:qCom_UserPreference.cs


示例18: qPtl_Announcement

 protected qPtl_Announcement(DbRow c)
 {
     container = c;
     container.SetContainerName("qPtl_Announcements");
     announcement_id = container.NewColumn<Int32>("AnnouncementID", true);
     scope_id = container.NewColumn<Int32>("ScopeID");
     available = container.NewColumn<String>("Available");
     created = container.NewColumn<DateTime>("Created");
     created_by = container.NewColumn<Int32>("CreatedBy");
     last_modified = container.NewColumn<DateTime?>("LastModified");
     last_modified_by = container.NewColumn<Int32>("LastModifiedBy");
     mark_as_delete = container.NewColumn<Int32>("MarkAsDelete");
     announcement_for_campaign_id = container.NewColumn<Int32>("AnnouncementForCampaignID");
     uri = container.NewColumn<String>("URI");
     title = container.NewColumn<String>("Title");
     text = container.NewColumn<String>("Text");
     generic = container.NewColumn<String>("Generic");
     generic_available_from = container.NewColumn<DateTime?>("GenericAvailableFrom");
     generic_available_to = container.NewColumn<DateTime?>("GenericAvailableTo");
     remind_every_days = container.NewColumn<Int32>("RemindEveryDays");
     content_type_id = container.NewColumn<Int32>("ContentTypeID");
     reference_id = container.NewColumn<Int32>("ReferenceID");
     one_time = container.NewColumn<Boolean>("OneTime");
     associated_announcement_id = container.NewColumn<Int32>("AssociatedAnnouncementID");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:25,代码来源:qPtl_Announcements.cs


示例19: qPtl_Language

 protected qPtl_Language(DbRow c)
 {
     container = c;
     container.SetContainerName("qPtl_Languages");
     language_id = container.NewColumn<Int32>("LanguageID", true);
     display_name = container.NewColumn<String>("DisplayName");
     code = container.NewColumn<String>("Code");
     available = container.NewColumn<Boolean>("Available");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:9,代码来源:qPtl_Language.cs


示例20: qCom_TempBulkEmailLog

 protected qCom_TempBulkEmailLog(DbRow c)
 {
     container = c;
     container.SetContainerName("qCom_TempBulkEmailLogs");
     temp_bulk_email_log_id = container.NewColumn<Int32>("TempBulkEmailLogID", true);
     user_id = container.NewColumn<Int32>("UserID");
     email_item_id = container.NewColumn<Int32>("EmailItemID");
     email_address = container.NewColumn<String>("EmailAddress");
     timestamp = container.NewColumn<DateTime?>("Timestamp");
 }
开发者ID:publichealthcloud,项目名称:absenteesurveillance,代码行数:10,代码来源:qCom_TempBulkEmailLog.cs



注:本文中的DbColumn类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# DbCommand类代码示例发布时间:2022-05-24
下一篇:
C# Db4objects类代码示例发布时间:2022-05-24
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap