private void Init() { ClearValues(); LoadDBString(); FInfoDataSet = new InfoDataSet(); if (((FDTE2 != null) && (FDTE2.Solution.FileName != "")) && File.Exists(FDTE2.Solution.FileName)) { EnabledOutputControls(); } FInfoDataSet.SetWizardDesignMode(true); try { cbEEPAlias.Text = EEPRegistry.WizardConnectionString; cbDatabaseType.Text = EEPRegistry.DataBaseType; } catch { } DisplayPage(tpConnection); }
private void SetFieldNamesByProvider(String TableName, String ProviderName, ListView aListView) { if (ProviderName == null || ProviderName.Trim() == "") return; InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType); aInfoCommand.Connection = InternalConnection; String OWNER = String.Empty, SS = TableName; if (SS.Contains(".")) { OWNER = WzdUtils.GetToken(ref SS, new char[] { '.' }); TableName = SS; } aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME='" + TableName + "' OR TABLE_NAME='" + OWNER + "." + TableName + "'"; IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand); DataSet dsColdef = new DataSet(); WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, dsColdef, TableName); aListView.Items.Clear(); InfoDataSet aDataSet = new InfoDataSet(); try { aDataSet.SetWizardDesignMode(true); aDataSet.RemoteName = ProviderName; aDataSet.AlwaysClose = true; aDataSet.Active = true; DataTable Table = aDataSet.RealDataSet.Tables[0]; foreach (DataColumn Column in Table.Columns) { ListViewItem aItem = new ListViewItem(Column.ColumnName); DataRow[] DRS = dsColdef.Tables[0].Select("FIELD_NAME='" + Column.ColumnName + "'"); TBlockFieldItem aFieldItem = new TBlockFieldItem(); if (DRS.Length > 0) { aItem.SubItems.Add(DRS[0]["CAPTION"].ToString()); aFieldItem.Description = DRS[0]["CAPTION"].ToString(); aFieldItem.QueryMode = DRS[0]["QUERYMODE"].ToString(); if (DRS[0]["IS_KEY"] != null && DRS[0]["IS_KEY"].ToString() == "Y") aFieldItem.IsKey = true; } else { aItem.SubItems.Add(""); aFieldItem.Description = ""; } aListView.Items.Add(aItem); aFieldItem.DataField = Column.ColumnName; aFieldItem.DataType = Column.DataType; if (DRS.Length > 0 && DRS[0]["CAPTION"] != null) aItem.Tag = aFieldItem; } } finally { aDataSet.Dispose(); } }
private void setWizardStep(int step) { if (step > 4 || step < 0) return; currentStep = step; this.tbcContainer.TabPages.Clear(); switch (step) { case 0: this.tbcContainer.TabPages.Add(this.tp1); this.btnPrevious.Enabled = false; this.btnNext.Enabled = true; this.btnDone.Enabled = false; //init string sevPath = ReportCreator.GetServerPath(); XmlDocument doc = new XmlDocument(); doc.Load(SystemFile.DBFile); XmlNode nDataBase = doc.SelectSingleNode("InfolightDB/DataBase"); ArrayList lstDB = new ArrayList(); foreach (XmlNode node in nDataBase.ChildNodes) { lstDB.Add(node.Name); } this.cmbSelectAlias.DataSource = lstDB; this.cmbSelectAlias.SelectedIndex = 0; this.cmbDataBaseType.SelectedIndex = 1; this.txtDetailsRptFileName.Enabled = false; this.cmbMasterReportStyle.SelectedIndex = 0; break; case 1: this.tbcContainer.TabPages.Add(this.tp4); this.btnPrevious.Enabled = false; this.btnNext.Enabled = true; this.btnDone.Enabled = false; if (this._isWebReport) { this.panel4.Visible = false; if (!Previousflag) { cbWebSite.Items.Clear(); foreach (Project P in _dte2.Solution.Projects) { if (string.Compare(P.Kind, "{E24C65DC-7377-472b-9ABA-BC803B73C61A}") == 0) { cbWebSite.Items.Add(P.Name); } } } } else { this.panel4.Visible = true; if (!Previousflag) { string S = _dte2.Solution.FileName; S = System.IO.Path.GetDirectoryName(S); String SolutionName = Path.GetFileNameWithoutExtension(_dte2.Solution.FileName); tbOutputPath.Text = S + @"\" + SolutionName; tbAssemblyOutputPath.Text = String.Format(@"..\..\EEPNetClient\{0}", SolutionName); tbPackageName.Text = "ClientPackage"; } } if (!Previousflag) { tbFormName.Text = "Form1"; tbFormTitle.Text = "Form1"; } break; case 2: if (checkStepCompleted(step - 1)) { this.tbcContainer.TabPages.Add(this.tp5); this.btnPrevious.Enabled = true; this.btnNext.Enabled = false; this.btnDone.Enabled = true; FInfoDataSet = new InfoDataSet(); FInfoDataSet.SetWizardDesignMode(true); break; } else { this.tbcContainer.TabPages.Add(this.tp4); this.btnPrevious.Enabled = false; this.btnNext.Enabled = true; this.btnDone.Enabled = false; currentStep--; step--; return; } case 3: this.tbcContainer.TabPages.Add(this.tp2); if (this._isWebReport) { this.panel3.Visible = false; Project proj = WebClientProject(); foreach (ProjectItem item in proj.ProjectItems) { if (item.Kind == "{6BB5F8EF-4483-11D3-8BCF-00C04F8EC28C}") { this.cmbRootName.Items.Add(item.Name); } } this.cmbRootName.SelectedItem = this.cbAddToExistFolder.SelectedItem; } else { this.panel3.Visible = true; this.cmbProName.Items.AddRange(ReportCreator.FindAllClientProject(_dte2.Solution as Solution2).ToArray()); this.cmbProName.SelectedItem = tbPackageName.Text; } chkIsMasterDetails.Checked = cbIsMasterDetails.Checked; txtRptFileName.Text = this.tbFormName.Text; if (cbIsMasterDetails.Checked) { txtDetailsRptFileName.Text = this.tbFormName.Text + "-dt"; } txtRptCaption.Text = tbFormTitle.Text; tbHorGaps.Text = "2.54"; tbVertGaps.Text = "0.64"; this.btnPrevious.Enabled = false; this.btnNext.Enabled = true; this.btnDone.Enabled = false; break; case 4: this.tbcContainer.TabPages.Add(this.tp3); this.btnPrevious.Enabled = true; this.btnNext.Enabled = false; this.btnDone.Enabled = true; break; } tbcContainer.SelectedIndex = step; }
private void tbProviderName_TextChanged(object sender, EventArgs e) { string ProviderName = tbProviderName.Text; if (ProviderName.Trim() == "") return; if (FInfoDataSet != null && FInfoDataSet.Active) { FInfoDataSet.Active = false; FInfoDataSet.Dispose(); FInfoDataSet = null; FInfoDataSet = new InfoDataSet(); FInfoDataSet.SetWizardDesignMode(true); } FInfoDataSet.RemoteName = ProviderName; FInfoDataSet.ClearWhere(); FInfoDataSet.SetWhere("1=0"); FInfoDataSet.Active = true; tbTableName.Text = FInfoDataSet.RealDataSet.Tables[0].TableName; String DataSetName = FInfoDataSet.RealDataSet.Tables[0].TableName; String ModuleName = FInfoDataSet.RemoteName.Substring(0, FInfoDataSet.RemoteName.IndexOf('.')); String SolutionName = System.IO.Path.GetFileNameWithoutExtension(_dte2.Solution.FullName); tbTableNameF.Text = CliUtils.GetTableName(ModuleName, DataSetName, SolutionName, "", true); string DllName = tbProviderName.Text; int Index = DllName.IndexOf('.'); DllName = DllName.Substring(0, Index + 1); ShowTableRelations(ModuleName, SolutionName); }
private void tbComboRemoteName_TextChanged(object sender, EventArgs e) { string ProviderName = tbComboRemoteName.Text; if (ProviderName.Trim() == "") return; InfoDataSet temp = new InfoDataSet(); temp.SetWizardDesignMode(true); temp.RemoteName = ProviderName; temp.SetWhere("1=0"); temp.Active = true; tbComboTableName.Text = temp.RealDataSet.Tables[0].TableName; String DataSetName = temp.RealDataSet.Tables[0].TableName; String ModuleName = temp.RemoteName.Substring(0, temp.RemoteName.IndexOf('.')); String SolutionName = System.IO.Path.GetFileNameWithoutExtension(FDTE2.Solution.FullName); tbComboTableName_F.Text = CliUtils.GetTableName(ModuleName, DataSetName, SolutionName, "", true); tbComboTableName_F.Text = WzdUtils.RemoveQuote(tbComboTableName_F.Text, FClientData.DatabaseType); cbDataValueField.Items.Clear(); cbDataTextField.Items.Clear(); DataTable dtTableSchema = temp.RealDataSet.Tables[0]; foreach (DataColumn item in dtTableSchema.Columns) { cbDataValueField.Items.Add(item.ColumnName); cbDataTextField.Items.Add(item.ColumnName); } if (InternalConnection.State != ConnectionState.Open) InternalConnection.Open(); DataSet ds = new DataSet(); try { DbCommand comm = InternalConnection.CreateCommand(); comm.CommandText = "SELECT * FROM SYS_REFVAL WHERE REFVAL_NO='Auto." + tbComboTableName_F.Text + "'"; IDbDataAdapter da = WzdUtils.AllocateDataAdapter(FClientData.DatabaseType); da.SelectCommand = comm; da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { cbDataValueField.Text = ds.Tables[0].Rows[0]["VALUE_MEMBER"] == null ? String.Empty : ds.Tables[0].Rows[0]["VALUE_MEMBER"].ToString(); cbDataTextField.Text = ds.Tables[0].Rows[0]["DISPLAY_MEMBER"] == null ? String.Empty : ds.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString(); } } catch (SqlException sex) { if (sex.Number == 208) { string sSysDBAlias = WzdUtils.GetSystemDBName(); ClientType sSysDBType = WzdUtils.GetSystemDBType(); DbConnection sysConn = WzdUtils.AllocateConnection(sSysDBAlias, sSysDBType, false); if (sysConn.State != ConnectionState.Open) sysConn.Open(); DbCommand comm = sysConn.CreateCommand(); comm.CommandText = "SELECT * FROM SYS_REFVAL WHERE REFVAL_NO='Auto." + tbComboTableName_F.Text + "'"; IDbDataAdapter da = WzdUtils.AllocateDataAdapter(sSysDBType); da.SelectCommand = comm; da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { cbDataValueField.Text = ds.Tables[0].Rows[0]["VALUE_MEMBER"] == null ? String.Empty : ds.Tables[0].Rows[0]["VALUE_MEMBER"].ToString(); cbDataTextField.Text = ds.Tables[0].Rows[0]["DISPLAY_MEMBER"] == null ? String.Empty : ds.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void tbProviderName_TextChanged(object sender, EventArgs e) { string ProviderName = tbProviderName.Text; if (ProviderName.Trim() == "") return; ClearAll(); if (FInfoDataSet != null && FInfoDataSet.Active) { FInfoDataSet.Active = false; FInfoDataSet.Dispose(); FInfoDataSet = null; FInfoDataSet = new InfoDataSet(); FInfoDataSet.SetWizardDesignMode(true); } FInfoDataSet.RemoteName = ProviderName; FInfoDataSet.ClearWhere(); FInfoDataSet.SetWhere("1=0"); FInfoDataSet.Active = true; tbTableName.Text = FInfoDataSet.RealDataSet.Tables[0].TableName; String DataSetName = FInfoDataSet.RealDataSet.Tables[0].TableName; String ModuleName = FInfoDataSet.RemoteName.Substring(0, FInfoDataSet.RemoteName.IndexOf('.')); String SolutionName = System.IO.Path.GetFileNameWithoutExtension(FDTE2.Solution.FullName); tbTableNameF.Text = CliUtils.GetTableName(ModuleName, DataSetName, SolutionName, "", true); tbTableNameF.Text = WzdUtils.RemoveQuote(tbTableNameF.Text, FClientData.DatabaseType); cbViewProviderName.Items.Clear(); string DllName = tbProviderName.Text; int Index = DllName.IndexOf('.'); DllName = DllName.Substring(0, Index + 1); for (int I = 0; I < FProviderNameList.Length; I++) { if (FProviderNameList[I].ToString().IndexOf(DllName) > -1) { cbViewProviderName.Items.Add(FProviderNameList[I]); } } cbViewProviderName.SelectedIndex = GetProviderIndex(); FClientData.ViewProviderName = cbViewProviderName.Text; ShowTableRelations(); }
private void SetFieldNamesByProvider(String TableName, String ProviderName, ListView aListView) { if (ProviderName == null || ProviderName.Trim() == "") return; InfoCommand aInfoCommand = new InfoCommand(FClientData.DatabaseType); aInfoCommand.Connection = InternalConnection; TableName = WzdUtils.RemoveQuote(TableName, FClientData.DatabaseType); aInfoCommand.CommandText = "Select * from COLDEF where TABLE_NAME = '" + TableName + "'"; IDbDataAdapter DA = DBUtils.CreateDbDataAdapter(aInfoCommand); DataSet dsColdef = new DataSet(); WzdUtils.FillDataAdapter(FClientData.DatabaseType, DA, dsColdef, TableName); aListView.Items.Clear(); InfoDataSet aDataSet = new InfoDataSet(); try { aDataSet.SetWizardDesignMode(true); aDataSet.RemoteName = ProviderName; aDataSet.AlwaysClose = true; aDataSet.Active = true; DataTable Table = aDataSet.RealDataSet.Tables[0]; foreach (DataColumn Column in Table.Columns) { ListViewItem aItem = new ListViewItem(Column.ColumnName); DataRow[] DRS = dsColdef.Tables[0].Select("FIELD_NAME='" + Column.ColumnName + "'"); if (DRS.Length == 1) aItem.SubItems.Add(DRS[0]["CAPTION"].ToString()); else aItem.SubItems.Add(""); aListView.Items.Add(aItem); TBlockFieldItem aFieldItem = new TBlockFieldItem(); aFieldItem.DataField = Column.ColumnName; aItem.Tag = aFieldItem; } } finally { aDataSet.Dispose(); } }
private void btnComboRemoteName_D_Click(object sender, EventArgs e) { if (radioButtonEntity.Checked) { EFAssembly.EFClientToolsAssemblyAdapt.RemoteNameEditorDialog remoteNameEditorDialog = new EFAssembly.EFClientToolsAssemblyAdapt.RemoteNameEditorDialog(); if (remoteNameEditorDialog.RemoteNameEditorDialogForm.ShowDialog() == System.Windows.Forms.DialogResult.OK) { tbComboRemoteName_D.Text = remoteNameEditorDialog.ReturnValue; tbComboEntityName_D.Text = remoteNameEditorDialog.ReturnClassName; List<object> refvals = WzdUtils.GetAllDataByTableName("SYS_REFVAL"); for (int i = 0; i < refvals.Count; i++) { if ((refvals[i] as SYS_REFVAL).REFVAL_NO == "SL." + tbComboEntityName_D.Text && lvSelectedFields.SelectedItems[0].Text == (refvals[i] as SYS_REFVAL).VALUE_MEMBER) { cbComboDisplayField_D.Text = (refvals[i] as SYS_REFVAL).DISPLAY_MEMBER; cbComboValueField_D.Text = (refvals[i] as SYS_REFVAL).VALUE_MEMBER; tbOtherFields_D.Text = (refvals[i] as SYS_REFVAL).SELECT_COMMAND; break; } } } } else if (radioButtonInfoCommand.Checked) { string[] fSelectedList = new string[10]; string strSelected = ""; IGetValues aItem = (IGetValues)FInfoDataSet; FProviderNameList = aItem.GetValues("RemoteName"); PERemoteName form = new PERemoteName(FProviderNameList, strSelected); if (form.ShowDialog() == DialogResult.OK) { tbComboRemoteName_D.Text = form.RemoteName; InfoDataSet ds = new InfoDataSet(); ds.SetWizardDesignMode(true); ds.RemoteName = tbComboRemoteName_D.Text; ds.ClearWhere(); ds.SetWhere("1=0"); ds.Active = true; String DataSetName = ds.RealDataSet.Tables[0].TableName; String ModuleName = ds.RemoteName.Substring(0, ds.RemoteName.IndexOf('.')); String SolutionName = System.IO.Path.GetFileNameWithoutExtension(FDTE2.Solution.FullName); tbComboEntityName_D.Text = CliUtils.GetTableName(ModuleName, DataSetName, SolutionName, "", true); DataSet dsSYS_REFVAL = GetDataFromSYS_REFVAL(tbComboEntityName_D.Text, lvSelectedFields.SelectedItems[0].Text); if (dsSYS_REFVAL.Tables.Count > 0 && dsSYS_REFVAL.Tables[0].Rows.Count > 0) { cbComboDisplayField_D.Text = dsSYS_REFVAL.Tables[0].Rows[0]["DISPLAY_MEMBER"].ToString(); cbComboValueField_D.Text = dsSYS_REFVAL.Tables[0].Rows[0]["VALUE_MEMBER"].ToString(); tbOtherFields_D.Text = dsSYS_REFVAL.Tables[0].Rows[0]["SELECT_COMMAND"].ToString(); } } } }
private void tbTableName_TextChanged(object sender, EventArgs e) { if (radioButtonEntity.Checked) { if (tbComboEntityName.Text != String.Empty) { Dictionary<string, object> htFields = WzdUtils.GetFieldsByEntityName(FClientData.AssemblyName, FClientData.CommandName, this.tbComboEntityName.Text); cbDataTextField.Items.Clear(); cbDataValueField.Items.Clear(); foreach (var field in htFields) { cbDataTextField.Items.Add(field.Key.ToString()); cbDataValueField.Items.Add(field.Key.ToString()); } } else { cbDataTextField.Items.Clear(); cbDataValueField.Items.Clear(); } } else if (radioButtonInfoCommand.Checked) { if (tbComboEntityName.Text != String.Empty) { InfoDataSet ds = new InfoDataSet(); ds.SetWizardDesignMode(true); ds.RemoteName = tbComboRemoteName.Text; ds.ClearWhere(); ds.SetWhere("1=0"); ds.Active = true; cbDataTextField.Items.Clear(); cbDataValueField.Items.Clear(); foreach (DataColumn field in ds.GetRealDataSet().Tables[0].Columns) { cbDataTextField.Items.Add(field.ColumnName); cbDataValueField.Items.Add(field.ColumnName); } } else { cbDataTextField.Items.Clear(); cbDataValueField.Items.Clear(); } } }
private void Init() { ClearValues(); LoadDBString(); MWizard.WCF.EFAssembly.EFClientToolsAssemblyAdapt.EFClientToolsAssembly = MWizard.WCF.EFAssembly.EFClientToolsAssemblyAdapt.LoadEFClientTools(); FInfoDataSet = new InfoDataSet(); if (((FDTE2 != null) && (FDTE2.Solution.FileName != String.Empty)) && File.Exists(FDTE2.Solution.FileName)) { EnabledOutputControls(); } cbEEPAlias.Text = EEPRegistry.WizardConnectionString; cbDatabaseType.Text = EEPRegistry.DataBaseType; FInfoDataSet.SetWizardDesignMode(true); DisplayPage(tbConnection); }
private void setWizardStep(int step) { if (step > 4 || step < 0) return; currentStep = step; this.tbcContainer.TabPages.Clear(); switch (step) { case 0: this.tbcContainer.TabPages.Add(this.tp1); this.btnPrevious.Enabled = false; this.btnNext.Enabled = true; this.btnDone.Enabled = false; //init string sevPath = ReportCreator.GetServerPath(); XmlDocument doc = new XmlDocument(); doc.Load(SystemFile.DBFile); XmlNode nDataBase = doc.SelectSingleNode("InfolightDB/DataBase"); ArrayList lstDB = new ArrayList(); foreach (XmlNode node in nDataBase.ChildNodes) { lstDB.Add(node.Name); } this.cmbSelectAlias.DataSource = lstDB; this.cmbSelectAlias.SelectedIndex = 0; this.cmbDataBaseType.SelectedIndex = 1; break; case 1: this.tbcContainer.TabPages.Add(this.tp4); this.btnPrevious.Enabled = true; this.btnNext.Enabled = true; this.btnDone.Enabled = false; this.cbTemplate.Items.Clear(); if (this._isWebReport) { this.cbTemplate.Items.Add("WebEasilyReportSingle"); this.cbTemplate.Items.Add("WebEasilyReportMasterDetail1"); this.cbTemplate.SelectedIndex = 0; this.panel4.Visible = false; if (!Previousflag) { cbWebSite.Items.Clear(); foreach (Project P in _dte2.Solution.Projects) { if (string.Compare(P.Kind, "{E24C65DC-7377-472b-9ABA-BC803B73C61A}") == 0) { cbWebSite.Items.Add(P.Name); } } } } else { this.cbTemplate.Items.Add("CEasilyReportSingle1"); this.cbTemplate.Items.Add("CEasilyReportMasterDetail1"); this.cbTemplate.SelectedIndex = 0; this.panel4.Visible = true; if (!Previousflag) { string S = _dte2.Solution.FileName; S = System.IO.Path.GetDirectoryName(S); String SolutionName = Path.GetFileNameWithoutExtension(_dte2.Solution.FileName); tbOutputPath.Text = S + @"\" + SolutionName; tbAssemblyOutputPath.Text = String.Format(@"..\..\EEPNetClient\{0}", SolutionName); tbPackageName.Text = "ClientPackage"; } } if (!Previousflag) { tbFormName.Text = "Form1"; tbFormTitle.Text = "Form1"; } break; case 2: if (checkStepCompleted(step - 1)) { this.tbcContainer.TabPages.Add(this.tp5); this.btnPrevious.Enabled = true; this.btnNext.Enabled = true; this.btnDone.Enabled = false; FInfoDataSet = new InfoDataSet(); FInfoDataSet.SetWizardDesignMode(true); break; } else { this.tbcContainer.TabPages.Add(this.tp4); this.btnPrevious.Enabled = true; this.btnNext.Enabled = true; this.btnDone.Enabled = false; currentStep--; step--; return; } case 3: this.tbcContainer.TabPages.Add(this.tp3); this.btnPrevious.Enabled = true; this.btnNext.Enabled = false; this.btnDone.Enabled = true; break; } tbcContainer.SelectedIndex = step; }