Пример #1
0
        protected void btnEtAddSelectedColumnsToMetaFields_onClick(object sender, EventArgs e)
        {
            //set create table view
            viewMode = "editTable";
            setViewMode();
            int    tableId   = int.Parse(ddlTableDefs.SelectedValue);
            string tableName = lblEtTableName.Text;


            string fieldName;
            string fieldDataType;
            int    maxLength = -1;
            int    order;

            MetadataNewDa MNDa = new MetadataNewDa();

            if (MNDa.MetaFieldOrderTableHasOrderedFields(tableId))
            {
                order = -1;
            }
            else
            {
                order = 1;
            }
            foreach (DataGridItem i in dgEtFieldsNotUsed.Items)
            {
                CheckBox deleteChkBxItem = (CheckBox)i.FindControl("chkSelection");

                if (deleteChkBxItem.Checked)
                {
                    string strMaxLength;
                    fieldName     = i.Cells[1].Text;
                    fieldDataType = ParseSQLDatatypeToCsharp(i.Cells[2].Text);
                    strMaxLength  = i.Cells[3].Text;
                    if (PageUtil.IsInteger(strMaxLength))
                    {
                        maxLength = int.Parse(strMaxLength);
                    }
                    else
                    {
                        maxLength = -1;
                    }
                    if (order > 0)
                    {
                        MNDa.AddMetaField(tableId, fieldName, fieldDataType, maxLength, false, false, order);
                        order++;
                    }
                    else
                    {
                        MNDa.AddMetaField(tableId, fieldName, fieldDataType, maxLength, false, false);
                    }
                }
            }
            updateEditTableView(tableId, tableName);
        }