public bool Execute(ref string strSelected) { if (null == fEditService) return false; if (null == fSelectedList) return false; PERemoteName form = new PERemoteName(fSelectedList, strSelected); if (form.ShowDialog() == DialogResult.OK) { strSelected = form.RemoteName; return true; } else { return false; } }
private void btnProviderName_Click(object sender, EventArgs e) { 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) { tbProviderName.Text = form.RemoteName; } }
private void btnRefValNo_D_Click(object sender, EventArgs e) { IGetValues aItem = (IGetValues)FInfoDataSet; FProviderNameList = aItem.GetValues("RemoteName"); PERemoteName form = new PERemoteName(FProviderNameList, tbComboRemoteName.Text); if (form.ShowDialog() == DialogResult.OK) { tbComboRemoteName_D.Text = form.RemoteName; } //fmRefVal aForm = new fmRefVal(InternalConnection, FClientData.DatabaseType, FClientData.DatabaseName); //String RefValNo = aForm.ShowRefValForm(); //cbRefValNo_D.Text = RefValNo; }
private void btnRefValNo_Click(object sender, EventArgs e) { IGetValues aItem = (IGetValues)FInfoDataSet; FProviderNameList = aItem.GetValues("RemoteName"); PERemoteName form = new PERemoteName(FProviderNameList, tbComboRemoteName.Text); if (form.ShowDialog() == DialogResult.OK) { tbComboRemoteName.Text = form.RemoteName; //if (!String.IsNullOrEmpty(tbComboRemoteName.Text)) //{ // if (InternalConnection.State != ConnectionState.Open) // InternalConnection.Open(); // InfoCommand comm = new InfoCommand(FClientData.DatabaseType); // comm.Connection = InternalConnection; // DbCommand comm = InternalConnection.CreateCommand(); // try // { // comm.CommandText = "SELECT * FROM SYS_REFVAL WHERE REFVAL_NO='Auto." + form.RemoteName + "'"; // IDataAdapter ida = WzdUtils.AllocateDataAdapter(FClientData.DatabaseType); // DbDataReader dr = comm.ExecuteReader(); // while (dr.NextResult()) // { // MessageBox.Show(dr["VALUE_MEMBER"].ToString()); // cbDataValueField.Text = dr["VALUE_MEMBER"] == null ? String.Empty : dr["VALUE_MEMBER"].ToString(); // cbDataTextField.Text = dr["DISPLAY_MEMBER"] == null ? String.Empty : dr["DISPLAY_MEMBER"].ToString(); // } // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } //} } //fmRefVal aForm = new fmRefVal(InternalConnection, FClientData.DatabaseType, FClientData.DatabaseName); //String RefValNo = aForm.ShowRefValForm(); //cbRefValNo.Text = RefValNo; }
private void btnSelectProvider_Click(object sender, EventArgs e) { InfoDataSet aDataSet = new InfoDataSet(FContainer); IGetValues aItem = (IGetValues)aDataSet; String[] FProviderNameList = aItem.GetValues("RemoteName"); String strSelected = ""; PERemoteName form = new PERemoteName(FProviderNameList, strSelected); if (form.ShowDialog() == DialogResult.OK) { ListViewItem ViewItem = (ListViewItem)((Button)sender).Tag; ViewItem.SubItems[1].Text = form.RemoteName; InfoDataSet bDataSet = FClientData.FindDataSet(ViewItem.Text); bDataSet.RealDataSet.Tables.Clear(); bDataSet.RemoteName = form.RemoteName; bDataSet.SetWizardDesignMode(true); bDataSet.Active = true; } }
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(); } } } }