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();
}
}
}
}
