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