Пример #1
0
        public void createObjectsTable(ref DataSet myDataSet, ref StructFunctions.objectsStruct myDataTableStruct, ref DataTable myTable)
        {
            //StructFunctions.objectsStruct myDataTableStruct = new StructFunctions.objectsStruct();
            string TableName = myDataTableStruct.tableName;

            //DataTable myTable = myDataSet.Tables.Add(TableName);
            myTable = myDataSet.Tables.Add(TableName);

            DataColumnCollection TableCols;

            TableCols = myTable.Columns;

            //Primary key GUID
            DataColumn colGuid = TableCols.Add(myDataTableStruct.GUID_fieldName, typeof(Guid));

            colGuid.AllowDBNull  = false;
            colGuid.Unique       = true;
            colGuid.DefaultValue = Guid.NewGuid();
            myTable.PrimaryKey   = new DataColumn[] { colGuid };
            //Fields
            DataColumn colType            = TableCols.Add(myDataTableStruct.Type_fieldName, typeof(int));
            DataColumn colTypeDescription = TableCols.Add(myDataTableStruct.Type_Description_fieldName, typeof(string));
            DataColumn colID          = TableCols.Add(myDataTableStruct.ID_fieldName, typeof(int));
            DataColumn colDescription = TableCols.Add(myDataTableStruct.Description_fieldName, typeof(string));

            DataTableCollection myDataTableColl = myDataSet.Tables;
        }
Пример #2
0
        public void createFieldsTable(ref DataSet myDataSet, ref StructFunctions.fieldsStruct myDataTableStruct)
        {
            //StructFunctions.fieldsStruct myDataTableStruct = new StructFunctions.fieldsStruct();
            string    TableName = myDataTableStruct.tableName;
            DataTable myTable   = myDataSet.Tables.Add(TableName);

            DataColumnCollection TableCols;

            TableCols = myTable.Columns;

            //Primary key GUID
            DataColumn colGuid = TableCols.Add(myDataTableStruct.GUID_fieldName, typeof(Guid));

            colGuid.AllowDBNull  = false;
            colGuid.Unique       = true;
            colGuid.DefaultValue = Guid.NewGuid();
            myTable.PrimaryKey   = new DataColumn[] { colGuid };
            //Fields
            DataColumn colTable_No    = TableCols.Add(myDataTableStruct.Table_No_fieldName, typeof(int));
            DataColumn colField_No    = TableCols.Add(myDataTableStruct.Field_No_fieldName, typeof(int));
            DataColumn colField_Name  = TableCols.Add(myDataTableStruct.Field_Name_fieldName, typeof(string));
            DataColumn colData_Type   = TableCols.Add(myDataTableStruct.Data_Type_fieldName, typeof(string));
            DataColumn colLength      = TableCols.Add(myDataTableStruct.Length_fieldName, typeof(int));
            DataColumn colEnabled     = TableCols.Add(myDataTableStruct.Enabled_fieldName, typeof(bool));
            DataColumn colDescription = TableCols.Add(myDataTableStruct.Description_fieldName, typeof(string));

            DataTableCollection myDataTableColl = myDataSet.Tables;
        }
Пример #3
0
        //获取打开表的列名
        public ActionResult GetTableCols(string id)
        {
            dtOpen = DelNullRow(dsRead.Tables[int.Parse(id)]);
            string[] cols = new string[dtOpen.Columns.Count];
            for (int i = 0; i < cols.Length; i++)
            {
                cols[i] = dtOpen.Columns[i].ColumnName;
            }
            TableCols Cs = new TableCols();

            Cs.Cols = cols;
            return(Json(Cs, "text/html;charset=utf-8", JsonRequestBehavior.AllowGet));
        }