private void FrmSystem_Load(object sender, EventArgs e) { dgvList.AutoGenerateColumns = false; //string startupPath = Application.StartupPath; //DataTable dt = new DataTable("ITEM"); //DataColumn[] col = new DataColumn[]{new DataColumn("KEY"), // new DataColumn("DEFAULT"), // new DataColumn("CONTENT"), // new DataColumn("CONTENTEX"), // new DataColumn("TEST"), // new DataColumn("BUTTON"), // new DataColumn("TYPE")}; //DataTable dtQD = new DataTable("DTB"); //DataColumn[] colQD = new DataColumn[]{new DataColumn("QD"), // new DataColumn("AP")}; //DataTable dtDIR = new DataTable("DIR"); //DataColumn[] colDIR = new DataColumn[]{new DataColumn("TMP"), // new DataColumn("RPT")}; //DataTable dtSYS = new DataTable("SYS"); //DataColumn[] colSYS = new DataColumn[]{new DataColumn("FONT"), // new DataColumn("FORCECOLOR"), // new DataColumn("BACKCOLOR")}; //dt.Columns.AddRange(col); //dtQD.Columns.AddRange(colQD); //dtDIR.Columns.AddRange(colDIR); //dtSYS.Columns.AddRange(colSYS); //dset.Tables.Add(dt); //dset.Tables.Add(dtQD); //dset.Tables.Add(dtDIR); //dset.Tables.Add(dtSYS); //string filename = GetDocumentDirec() + "\\Configuration\\xmlConnect.xml"; _config.LoadConfig(GetDocumentDirec() + "\\Configuration\\QDConfig.tvc"); bindingConfig.DataSource = _config; //iTEMBindingSource.DataSource = _config.ITEM; //if (File.Exists(filename)) //{ // StreamReader sr = new StreamReader(filename); // string result = sr.ReadToEnd(); // sr.Close(); // string kq = RC2.DecryptString(result, Form_QD._key, Form_QD._iv, Form_QD._padMode, Form_QD._opMode); // StringReader stringReader = new StringReader(kq); // dset.ReadXml(stringReader); // stringReader.Close(); // //dset.ReadXml(filename); //} //dgvList.AutoGenerateColumns = false; //dgvList.DataSource = dt; }
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) { } }