private void btnNewField_Click(object sender, EventArgs e) { System.Windows.Forms.TreeNode Node = tvRelation.SelectedNode; if (Node != null) { TDetailItem DetailItem = (TDetailItem)Node.Tag; MWizard.fmSelTableField F = new fmSelTableField(); if (F.ShowSelTableFieldForm(DetailItem, GetFieldNames, lvSelectedFields, InternalConnection, RearrangeRefValButton, btnRefVal_Click, FClientData.DatabaseType)) { btnDeleteField.Enabled = lvSelectedFields.Items.Count > 0; } } }
private void btnAddField_Click(object sender, EventArgs e) { TreeNode Node = tvContainer.SelectedNode; if (Node != null) { TNodeObject NodeObject = (TNodeObject)Node.Tag; fmSelTableField F = new fmSelTableField(); if (F.ShowSelTableFieldForm(NodeObject.BlockItem, GetFieldNames, lvSelectedFields, InternalConnection, RearrangeRefValButton, btnRefVal_Click, FClientData.DatabaseType)) { btnDeleteField.Enabled = lvSelectedFields.Items.Count > 0; } } }
private void btnAdd_Click(object sender, EventArgs e) { TreeNode Node = tvTables.SelectedNode; string TableName = ""; MWizard.fmSelTableField F; if (Node != null) TableName = Node.Text; F = new fmSelTableField(); if (F.ShowSelTableFieldForm(FServerData, FServerData.DatabaseName, ref TableName, InternalConnection)) { Node = tvTables.Nodes.Add(TableName); Node.Name = TableName; AddDatasetNode(Node); tvTables.SelectedNode = Node; String sQL = "select * from " + WzdUtils.Quote(TableName, GlobalConnection) + " where 1=0"; IDbCommand cmd = GlobalConnection.CreateCommand(); cmd.CommandText = sQL; if (GlobalConnection.State == ConnectionState.Closed) { GlobalConnection.Open(); } DataSet schemaTable = new DataSet(); IDbDataAdapter ida = WzdUtils.AllocateDataAdapter(FServerData.DatabaseType); ida.SelectCommand = cmd; ida.MissingSchemaAction = MissingSchemaAction.AddWithKey; ida.Fill(schemaTable); lvSelectedFields.Items.Clear(); TDatasetItem tdsItem = null; foreach (TDatasetItem item in FServerData.Datasets) { if (item.TableName == Node.Text) { tdsItem = item; break; } } foreach (DataColumn DR in schemaTable.Tables[0].Columns) { lvSelectedFields.Items.Add(DR.ColumnName); TFieldAttrItem Item = new TFieldAttrItem(); tdsItem.FieldAttrItems.Add(Item); Item.DataField = lvSelectedFields.Items[lvSelectedFields.Items.Count - 1].Text; if (lvSelectedFields.Items[lvSelectedFields.Items.Count - 1].SubItems.Count > 1) { if (tdsItem.FieldCaptionList.Count > 0) { Item.Description = tdsItem.FieldCaptionList.Values(Item.DataField); } else { Item.Description = lvSelectedFields.Items[lvSelectedFields.Items.Count - 1].SubItems[1].Text; } } else { if (tdsItem.FieldCaptionList.Count > 0) { Item.Description = tdsItem.FieldCaptionList.Values(Item.DataField); //lvSelectedFields.Items[lvSelectedFields.Items.Count - 1].SubItems.Add(tdsItem.FieldCaptionList.Values(Item.DataField)); } } if (!String.IsNullOrEmpty(Item.Description)) lvSelectedFields.Items[lvSelectedFields.Items.Count - 1].SubItems.Add(Item.Description); lvSelectedFields.Items[lvSelectedFields.Items.Count - 1].Tag = Item; } foreach (DataColumn DR in schemaTable.Tables[0].PrimaryKey) { for (int I = 0; I < lvSelectedFields.Items.Count; I++) { if (lvSelectedFields.Items[I].Text == DR.ColumnName) { TFieldAttrItem fi = (TFieldAttrItem)lvSelectedFields.Items[I].Tag; fi.IsKey = true; } } } Node.Tag = tdsItem; if (lvSelectedFields.Items.Count > 0) { lvSelectedFields.Items[0].Selected = true; } btnDeleteField.Enabled = lvSelectedFields.Items.Count > 0; } }
private void btnNewField_Click(object sender, EventArgs e) { if (radioButtonEntity.Checked) { System.Windows.Forms.TreeNode Node = tvRelation.SelectedNode; if (Node != null) { TWCFDetailItem DetailItem = (TWCFDetailItem)Node.Tag; MWizard.fmSelWCFTableField F = new fmSelWCFTableField(); //COLDEF List<COLDEFInfo> colDefObjects = null; colDefObjects = WzdUtils.GetColumnDefination(FClientData.AssemblyName, FClientData.CommandName, DetailItem.EntityName, cbEEPAlias.Text); if (F.ShowSelTableFieldForm(DetailItem, lvSelectedFields, RearrangeRefValButton, btnRefVal_Click, colDefObjects, FClientData.AssemblyName, FClientData.CommandName)) { btnDeleteField.Enabled = lvSelectedFields.Items.Count > 0; } } } else if (radioButtonInfoCommand.Checked) { System.Windows.Forms.TreeNode Node = tvRelation.SelectedNode; if (Node != null) { TDetailItem DetailItem = (TDetailItem)Node.Tag; MWizard.fmSelTableField F = new fmSelTableField(); if (F.ShowSelTableFieldForm(DetailItem, GetFieldNames, lvSelectedFields, InternalConnection, RearrangeRefValButton, btnRefVal_Click, FClientData.DatabaseType)) { btnDeleteField.Enabled = lvSelectedFields.Items.Count > 0; } } } }
private void btnAddField_Click(object sender, EventArgs e) { TreeNode Node = tvTables.SelectedNode; if (Node != null) { TDatasetItem DatasetItem = (TDatasetItem)Node.Tag; MWizard.fmSelTableField F = new fmSelTableField(); if (F.ShowSelTableFieldForm(DatasetItem, GetFieldNamesEx, lvSelectedFields, InternalConnection, FServerData.DatabaseType)) { btnDeleteField.Enabled = lvSelectedFields.Items.Count > 0; String sQL = "select * from " + WzdUtils.Quote(DatasetItem.TableName, GlobalConnection) + " where 1=0"; IDbCommand cmd = GlobalConnection.CreateCommand(); cmd.CommandText = sQL; if (GlobalConnection.State == ConnectionState.Closed) { GlobalConnection.Open(); } DataSet schemaTable = new DataSet(); IDbDataAdapter ida = WzdUtils.AllocateDataAdapter(DatasetItem.DatabaseType); ida.SelectCommand = cmd; ida.MissingSchemaAction = MissingSchemaAction.AddWithKey; ida.Fill(schemaTable); foreach (DataColumn DR in schemaTable.Tables[0].PrimaryKey) { for (int I = 0; I < lvSelectedFields.Items.Count; I++) { if (lvSelectedFields.Items[I].Text == DR.ColumnName) { TFieldAttrItem fi = (TFieldAttrItem)lvSelectedFields.Items[I].Tag; fi.IsKey = true; break; } } } } } }