private void ShowComment()
{
if (_user == "")
{
MessageBox.Show("Please login...");
return;
}
try
{
Excel._Worksheet sheet = (Excel._Worksheet)ExcelApp.ActiveSheet;
_xlsCell = (Excel.Range)ExcelApp.ActiveCell;
string _address = _xlsCell.get_AddressLocal(1, 1, Excel.XlReferenceStyle.xlA1, 0, 0).ToString().Replace("$", "");
if (_xlsCell.Comment != null)
{
string formular = _xlsCell.Comment.Text(Type.Missing, Type.Missing, Type.Missing);
if (frm == null)
{
frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnect, _user);
//frm.User = _user;
frm.Config = _config;
frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed);
//frm.Pos = _address;
//frm.TopMost = true;
frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));
}
//else if (frm.DialogResult == System.Windows.Forms.DialogResult.Yes)
//{
// frm.BringToFront();
// frm.GetQueryBuilderFromFomular(formular);
//}
else
{
frm.Close();
frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user);
frm.User = _user;
frm.Config = _config;
frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed);
//frm.Pos = _address;
//frm.TopMost = true;
frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));//new WindowWrapper((IntPtr)ExcelApp.Hwnd)
}
}
else
{
MessageBox.Show("Cell selected is incorrect!");
}
}
catch (Exception ex)
{
BUS.CommonControl.AddLog("ErroLog", __documentDirectory + "\\Log", "Addin : " + ex.Message + "\n\t" + ex.Source + "\n\t" + ex.StackTrace);
}
}
private void adxExcelEvents_SheetSelectionChange(object sender, object sheet, object range)
{
Excel.Range Target = range as Excel.Range;
if (frm != null && frm.Status == "I")
{
_address = Target.get_AddressLocal(Target.Row, Target.Column, Excel.XlReferenceStyle.xlA1, 0, 0);
string address = _address.Replace("$", "");
string value = "";
try
{
value = Target.Value.ToString();
}//(type)
catch
{
}
frm.SetValueFocus(address, value);
}
}
private void ShowDesign()
{
if (_user == "")
{
MessageBox.Show("Please login...");
return;
}
Excel._Worksheet sheet = (Excel._Worksheet)ExcelApp.ActiveSheet;
_xlsCell = (Excel.Range)ExcelApp.ActiveCell;
string _address = _xlsCell.get_AddressLocal(1, 1, Excel.XlReferenceStyle.xlA1, 0, 0).ToString();
_address = _address.Replace("$", "");
string formular = _xlsCell.Formula.ToString();
if (frm == null)
{
frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user);
frm.User = _user;
frm.Config = _config;
frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed);
//frm.Pos = _address;
//frm.TopMost = true;
//IWin32Window wincurrent = new WindowWrapper((IntPtr)ExcelApp.);
frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));
}
//else if (frm.DialogResult == System.Windows.Forms.DialogResult.Yes)
//{
// frm.BringToFront();
// frm.GetQueryBuilderFromFomular(formular);
//}
else
{
frm.Close();
frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user);
frm.User = _user;
frm.Config = _config;
frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed);
//frm.Pos = _address;
//frm.TopMost = true;
//IWin32Window wincurrent = new WindowWrapper((IntPtr)ExcelApp.Hwnd);
frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));
}
}
private void ShowAnalysis()
{
Excel._Worksheet sheet = ExcelApp.ActiveSheet as Excel.Worksheet;
_xlsCell = (Excel.Range)ExcelApp.ActiveCell;
string _address = _xlsCell.get_AddressLocal(1, 1, Excel.XlReferenceStyle.xlA1, 0, 0).ToString().Replace("$", "");
if (_xlsCell.Comment != null)
{
string formular = _xlsCell.Comment.Text(Type.Missing, Type.Missing, Type.Missing);
if (frmdrill == null)
{
frmdrill = new QDAddinDrillDown(_config, _address, ExcelApp, formular, _strConnectDes, _user);
frmdrill.User = _user;
frmdrill.Config = _config;
frmdrill.FormClosed += new FormClosedEventHandler(frmdrill_FormClosed);
//frm.Pos = _address;
//frm.TopMost = true;
frmdrill.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));
}
//else if (frmdrill.DialogResult == System.Windows.Forms.DialogResult.Yes)
//{
// frmdrill.BringToFront();
// frmdrill.GetQueryBuilderFromFomular(formular);
//}
else
{
frmdrill.Close();
frmdrill = new QDAddinDrillDown(_config, _address, ExcelApp, formular, _strConnectDes, _user);
frmdrill.User = _user;
frmdrill.Config = _config;
frmdrill.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frmdrill_FormClosed);
//frm.Pos = _address;
//frm.TopMost = true;
frmdrill.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));//new WindowWrapper((IntPtr)ExcelApp.Hwnd)
}
}
else
{
MessageBox.Show("Cell selected is incorrect!");
}
}
public string RangeAddress(Excel.Range rng)
{
return(rng.get_AddressLocal(false, false, Excel.XlReferenceStyle.xlA1));
}
private void adxExcelEvents_SheetBeforeDoubleClick(object sender, ADXExcelSheetBeforeEventArgs e)
{
Excel.Range Target = e.Range as Excel.Range;
_address = Target.get_AddressLocal(Target.Row, Target.Column, Excel.XlReferenceStyle.xlA1, 0, 0).Replace("$", "");
if (Target.Formula != null)
{
string formular = Target.Formula.ToString();
if (formular.Contains("TT_XLB_EB") || formular.Contains("USER TABLE"))
{
//Target.set_Value(Type.Missing, formular);
//Application.Undo();
if (frm != null)
{
frm.Close();
frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user);
frm.Config = _config;
frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed);
//frm.Pos = _address;
//if (value.Contains("TT_XLB_ED"))
// frm.GetQueryBuilderFromFomular(value);
//frm.TopMost = true;
frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));//new WindowWrapper((IntPtr)ExcelApp.Hwnd)
}
else
{
frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user);
frm.Config = _config;
frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed);
//frm.Pos = _address;
//if (value.Contains("TT_XLB_ED"))
// frm.GetQueryBuilderFromFomular(value);
//frm.TopMost = true;
//
frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));//new WindowWrapper((IntPtr)ExcelApp.Hwnd)
}
frm.Focus();
e.Cancel = true;
}
}
else
{
if (Target.Text != null)
{
string formular = Target.Text.ToString();
if (formular.Contains("TT_XLB_EB") || formular.Contains("USER TABLE"))
{
//Target.set_Value(Type.Missing, formular);
//Application.Undo();
if (frm != null)
{
frm.Close();
frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user);
frm.Config = _config;
frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed);
//frm.Pos = _address;
//if (value.Contains("TT_XLB_ED"))
// frm.GetQueryBuilderFromFomular(value);
//frm.TopMost = true;
frm.Show();//new WindowWrapper((IntPtr)ExcelApp.Hwnd)
}
else
{
frm = new QDAddIn(_config, _address, ExcelApp, formular, _strConnect, _strConnectDes, _user);
frm.Config = _config;
frm.FormClosed += new System.Windows.Forms.FormClosedEventHandler(frm_FormClosed);
//frm.Pos = _address;
//if (value.Contains("TT_XLB_ED"))
// frm.GetQueryBuilderFromFomular(value);
//frm.TopMost = true;
//
frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));//
}
frm.Focus();
e.Cancel = true;
}
}
}
}
public void ShowFields()
{
Excel._Worksheet sheet = (Excel._Worksheet)ExcelApp.ActiveSheet;
_xlsCell = (Excel.Range)ExcelApp.ActiveCell;
string _address = _xlsCell.get_AddressLocal(1, 1, Excel.XlReferenceStyle.xlA1, 0, 0).ToString();
_address = _address.Replace("$", "");
string formular = _xlsCell.Formula.ToString();
if (formular.Contains("TVC_QUERY") && formular.Contains("USER TABLE"))
{
string tablename = "data";
try
{
Excel.Range rangeTableName = ExcelApp.get_Range("A" + _xlsCell.Row);
tablename = rangeTableName.Value.ToString();
}
catch
{
}
string tmp = formular.Replace("USER TABLE(", "");
formular = tmp.Substring(0, tmp.Length - 1);
SQLBuilder _sqlBuilder = new SQLBuilder(processingMode.Details);
if (!formular.Contains("TVC_QUERY"))
{
Parsing.Formular2SQLBuilder(formular, ref _sqlBuilder);
}
else
{
Parsing.TVCFormular2SQLBuilder(formular, ref _sqlBuilder);
}
DataTable dt_list = new DataTable();
if (_sqlBuilder.SelectedNodes.Count > 0)
{
//CommoControl commo = new CommoControl();
//string connnectString = commo.CreateConnectString(Properties.Settings.Default.Server
// , Properties.Settings.Default.User
// , Properties.Settings.Default.Pass
// , Properties.Settings.Default.DBName);
//a.THEME = this.THEME;
dt_list.TableName = tablename;
dt_list.Columns.Add("Name");
dt_list.Columns.Add("Code");
for (int i = 0; i < _sqlBuilder.SelectedNodes.Count; i++)
{
Node colum = _sqlBuilder.SelectedNodes[i];
string desc = colum.Description;
int dem = 0;
for (int j = i - 1; j >= 0; j--)
{
Node node = _sqlBuilder.SelectedNodes[j];
if (node.Description == colum.Description)
{
dem++;
}
}
if (dem > 0)
{
desc = colum.Description + dem;
}
dt_list.Rows.Add(new string[] { colum.Description, desc });
}
TVCDesigner.MainForm frm = new TVCDesigner.MainForm(dt_list, null, null);
frm.Show(new WindowWrapper((IntPtr)ExcelApp.DDEAppReturnCode));
}
}
}
