public QDAddinDrillDown(QDConfig config, string Pos, Excel._Application xls, QueryBuilder.SQLBuilder sqBuilder, string connectDesc)
{
InitializeComponent();
_config = config;
Init(Pos, xls, sqBuilder);
//_strConnectDes = sqBuilder.StrConnectDes;
//ThemeResolutionService.ApplyThemeToControlTree(this, THEME);
}
public QDAddinDrillDown(QDConfig config, string Pos, Excel._Application xls, string formular, string connectDesc, string user)
{
InitializeComponent();
_config = config;
_user = user;
//_strConnectDes = connectDesc;
Init(Pos, xls, formular);
_sqlBuilder.StrConnectDes = connectDesc;
//ThemeResolutionService.ApplyThemeToControlTree(this, THEME);
}
public QDAddinDrillDown(QDConfig config, string connectDesc)
{
InitializeComponent();
//_strConnectDes = connectDesc;
_config = config;
_sqlBuilder = new QueryBuilder.SQLBuilder(processingMode.Balance);
_sqlBuilder.StrConnectDes = connectDesc;
//TopMost = true;
//ThemeResolutionService.ApplyThemeToControlTree(this, THEME);
}
public QDAddIn(QDConfig confi, string Pos, Excel._Application xls, string formular, string connect, string connectDes, string user)
{
InitializeComponent();
////ThemeResolutionService.ApplyThemeToControlTree(this, THEME);
_user = user;
_strConnect = connect;
_strConnectDes = connectDes;
_config = confi;
Init(Pos, xls, formular);
}
public QDAddIn(QDConfig config, string connect, string connectDes)
{
InitializeComponent();
////ThemeResolutionService.ApplyThemeToControlTree(this, THEME);
_sqlBuilder = new QueryBuilder.SQLBuilder(processingMode.Balance);
DataTable dtcom = QueryBuilder.Parsing.GetListNumberAgregate();
DataRow newrow = dtcom.NewRow();
newrow["Code"] = newrow["Description"] = "";
dtcom.Rows.Add(newrow);
((DataGridViewComboBoxColumn)dgvSelectNodes.Columns["colAgregate"]).DataSource = dtcom;
((DataGridViewComboBoxColumn)dgvSelectNodes.Columns["colAgregate"]).DisplayMember = "Code";
((DataGridViewComboBoxColumn)dgvSelectNodes.Columns["colAgregate"]).ValueMember = "Code";
//TopMost = true;
_config = config;
_strConnect = connect;
_strConnectDes = connectDes;
}
private static void LoadConfig(string db)
{
string __documentDirectory = System.Environment.GetFolderPath(System.Environment.SpecialFolder.MyDocuments) + "\\" + Form_QD.DocumentFolder;
string _strConnect = "";
string _strConnectDes = "";
string __templatePath = "";
string __reportPath = "";
string _appPath = Application.StartupPath;
try
{
QDConfig _config = new QDConfig();
if (File.Exists(__documentDirectory + "\\Configuration\\QDConfig.tvc"))
{
_config.LoadConfig(__documentDirectory + "\\Configuration\\QDConfig.tvc");
string key = "";
_strConnect = _config.GetConnection(ref key, "QD");
key = "";
_strConnectDes = _config.GetConnection(ref key, "AP");
if (_config.DIR.Rows.Count > 0)
{
__templatePath = _config.DIR.Rows[0]["TMP"].ToString();
__reportPath = _config.DIR.Rows[0]["RPT"].ToString();
}
if (_config.SYS.Rows.Count > 0)
{
ReportGenerator.User2007 = (bool)_config.SYS.Rows[0][_config.SYS.USE2007Column];
}
}
QueryBuilder.SQLBuilder.SetConnection(_strConnect);
ReportGenerator.Config = _config;
CmdManager.Db = db;
CmdManager.AppConnect = _strConnect;
CmdManager.RepConnect = _strConnectDes;
CmdManager.ReptPath = __reportPath;
CmdManager.TempPath = __templatePath;
}
catch (Exception ex)
{
}
}
private QDConfig GetDataSetConfig(QDConfig dset)
{
if (dset.Tables["DTB"].Rows.Count > 0)
{
dset.Tables["DTB"].Rows[0]["QD"] = ddlQD.Text;
dset.Tables["DTB"].Rows[0]["AP"] = ddlAP.Text;
}
else
{
DataRow row = dset.Tables["DTB"].NewRow();
row["QD"] = ddlQD.Text;
row["AP"] = ddlAP.Text;
dset.Tables["DTB"].Rows.Add(row);
}
if (dset.Tables["DIR"].Rows.Count > 0)
{
dset.Tables["DIR"].Rows[0]["TMP"] = txtTMP.Text;
dset.Tables["DIR"].Rows[0]["RPT"] = txtRPT.Text;
}
else
{
DataRow row = dset.Tables["DIR"].NewRow();
row["TMP"] = txtTMP.Text;
row["RPT"] = txtRPT.Text;
dset.Tables["DIR"].Rows.Add(row);
}
if (dset.Tables["SYS"].Rows.Count > 0)
{
dset.Tables["SYS"].Rows[0]["FONT"] = txtFont.Text;
if (panelForce.BackColor != SystemColors.Control)
{
TypeConverter tc = TypeDescriptor.GetConverter(typeof(Color));
string color = tc.ConvertToString(panelForce.BackColor);
dset.Tables["SYS"].Rows[0]["FORCECOLOR"] = color;
}
else
{
dset.Tables["SYS"].Rows[0]["FORCECOLOR"] = "";
}
if (panelBack.BackColor != SystemColors.Control)
{
TypeConverter tc = TypeDescriptor.GetConverter(typeof(Color));
string color = tc.ConvertToString(panelBack.BackColor);
dset.Tables["SYS"].Rows[0]["BACKCOLOR"] = color;
}
else
{
dset.Tables["SYS"].Rows[0]["BACKCOLOR"] = "";
}
}
else
{
DataRow row = dset.Tables["SYS"].NewRow();
row["FONT"] = txtFont.Text;
if (panelForce.BackColor != SystemColors.Control)
{
TypeConverter tc = TypeDescriptor.GetConverter(typeof(Color));
string color = tc.ConvertToString(panelForce.BackColor);
row["FORCECOLOR"] = color;
}
else
{
row["FORCECOLOR"] = "";
}
if (panelBack.BackColor != SystemColors.Control)
{
TypeConverter tc = TypeDescriptor.GetConverter(typeof(Color));
string color = tc.ConvertToString(panelBack.BackColor);
row["BACKCOLOR"] = color;
}
else
{
row["BACKCOLOR"] = "";
}
dset.Tables["SYS"].Rows.Add(row);
}
return(dset);
}
public frmDBDef(QDConfig config)
{
InitializeComponent();
_config = config;
}