public static void getCsvFilesList(TreeNodeMouseClickEventArgs e)
{
e.Node.Nodes.Clear();
string vCurrFolderName = e.Node.Text;
FolderProperties vCurrFolder = In2SqlSvcCsv.vFolderList.Find(item => item.FolderName == vCurrFolderName);
try
{
/* e.Node.SelectedImageIndex = 22;
* e.Node.Tag = "CSV#";
* TreeNode vNodeTableFolder = new TreeNode("Tables".ToString(), 3, 3);
* vNodeTableFolder.Tag = vCurrFolder.FolderName + "_csv";
* e.Node.Nodes.Add(vNodeTableFolder);
*/
initCsvObjects(ref vCurrFolder);
foreach (var vCurrFile in vCurrFolder.Files)
{
TreeNode vNodeTable = new TreeNode(vCurrFile.Name, 22, 22);
vNodeTable.Tag = vCurrFolder.FolderName + "|" + vCurrFile.Name + "|$FILE_CSV$";
e.Node.Nodes.Add(vNodeTable);
TreeNode vNodeColumnTbl = new TreeNode(" ".ToString(), 99, 99);
vNodeColumnTbl.Tag = vCurrFolder.FolderName + "." + vCurrFile.Name;
vNodeTable.Nodes.Add(vNodeColumnTbl);
}
return;
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "getCsvFilesList 1 ");
}
}
public static void getCsvHeaders(TreeNodeMouseClickEventArgs e)
{
try
{
String vNodeTag = e.Node.Parent.Text + '.' + e.Node.Text;
FilesAndProperties vCurrObjProp = In2SqlSvcCsv.vFileObjProp.Find(item => item.ObjName == vNodeTag);
if (vCurrObjProp.objColumns == null)
{
In2SqlSvcCsv.vFileObjProp.AddRange(In2SqlSvcCsv.getCsvFileColumn(e.Node.Parent.Text, e.Node.Text));
vCurrObjProp = In2SqlSvcCsv.vFileObjProp.Find(item => item.ObjName == vNodeTag);
}
if (vCurrObjProp.objColumns != null)
{
if (vCurrObjProp.objColumns.Count > 0)
{
e.Node.Nodes.Clear();
foreach (var vCurrColumn in vCurrObjProp.objColumns)
{
TreeNode vNodeColumn = new TreeNode(vCurrColumn.ToString(), 14, 14);
vNodeColumn.Tag = vNodeTag + '.' + vCurrColumn + "_clm";
e.Node.Nodes.Add(vNodeColumn);
}
}
}
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "getColumnsandIndexes ");
}
}
public void PopulateOdbcTreeView(int vIsUI = 0)
{
try
{
TreeNode rootNode = new TreeNode("ODBC");
rootNode.Tag = "root";
GetODbcRecords(rootNode, vIsUI);
treeODBC.Nodes.Add(rootNode);
TreeNode rootCloud = new TreeNode("Сloud", 18, 18);
rootCloud.Tag = "cloud";
TreeNode tnClickHouse = new TreeNode("ClickHouse", 19, 19);
tnClickHouse.Tag = "ClickHouse";
GetCloudRecords(tnClickHouse, "CloudCH");
rootCloud.Nodes.Add(tnClickHouse);
treeODBC.Nodes.Add(rootCloud);
TreeNode rootCSV = new TreeNode("csv", 20, 20);
rootCSV.Tag = "CSV";
GetCSVRecords(rootCSV);
treeODBC.Nodes.Add(rootCSV);
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "PopulateOdbcTreeView");
}
}
public static IEnumerable <OdbcProperties> getODBCList(RegistryKey rootKey)
{
RegistryKey regKey = rootKey.OpenSubKey(@"Software\ODBC\ODBC.INI\ODBC Data Sources");
if (regKey != null)
{
foreach (string name in regKey.GetValueNames())
{
OdbcProperties vOdbcProperties = new OdbcProperties();
vOdbcProperties.OdbcName = regKey.GetValue(name, "").ToString();
if (vOdbcProperties.OdbcName.Contains("Microsoft ") == false)
{
try
{
vOdbcProperties.OdbcName = name;
RegistryKey vCurrRegKey = rootKey.OpenSubKey(@"Software\ODBC\ODBC.INI\" + name);
vOdbcProperties.Database = in2SqlRegistry.getLocalRegValue(vCurrRegKey, "Database");
vOdbcProperties.Description = in2SqlRegistry.getLocalRegValue(vCurrRegKey, "Description");
vOdbcProperties.Driver = in2SqlRegistry.getLocalRegValue(vCurrRegKey, "Driver");
vOdbcProperties.LastUser = in2SqlRegistry.getLocalRegValue(vCurrRegKey, "LastUser");
vOdbcProperties.Server = in2SqlRegistry.getLocalRegValue(vCurrRegKey, "Server");
vOdbcProperties.ConnStatus = 0;
vCurrRegKey = Registry.CurrentUser.OpenSubKey(@"Software\in2sql");
vOdbcProperties.Login = in2SqlRegistry.getLocalRegValue(vCurrRegKey, name + '.' + "Login");
vOdbcProperties.Password = in2SqlRegistry.getLocalRegValue(vCurrRegKey, name + '.' + "Password");
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "ODBCList");
}
yield return(vOdbcProperties);
}
}
}
}
private void GetODbcRecords(TreeNode nodeToAddTo, int vIsUI = 0)
{
try
{
foreach (var vCurrCloudList in in2sqlSvcCloud.vCloudList)
{
string vv = vCurrCloudList.CloudName;
}
if (vIsUI == 0)
{
foreach (var vCurrvODBCList in In2SqlSvcODBC.vODBCList)
{
in2SqlRightPaneTreeTables.setODBCTreeLineSimple(nodeToAddTo, vCurrvODBCList.OdbcName);
}
return;
}
if (vIsUI == 1)
{
foreach (var vCurrvODBCList in In2SqlSvcODBC.vODBCList)
{
In2SqlSvcODBC.checkOdbcStatus(vCurrvODBCList.OdbcName);
in2SqlRightPaneTreeTables.setODBCTreeLineComplex(nodeToAddTo, vCurrvODBCList.OdbcName, vCurrvODBCList.OdbcName);
}
return;
}
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "GetODbcRecords");
}
}
public static void setLocalValue(string vOdbcName, string vParameter, string vValue)
{
RegistryKey vCurrRegKey = Registry.CurrentUser.OpenSubKey(@"Software\in2sql", true);
try
{
if (vCurrRegKey == null)
{
vCurrRegKey = Registry.CurrentUser.CreateSubKey(@"SOFTWARE\in2sql");
}
if (vParameter.Contains("Password"))
{
vValue = Encrypt(vValue);
}
vCurrRegKey.SetValue(vOdbcName + '.' + vParameter, vValue);
vCurrRegKey.Close();
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "in2SQLRegistry.etLocalValue");
}
}
public static string getLocalRegValue(RegistryKey vCurrRegKey, string vValue)
{
try
{
string vGetLocalRegValue = null;
if (vCurrRegKey == null)
{
return(null);
}
if ((vCurrRegKey.GetValue(vValue, null) == null) == false)
{
vGetLocalRegValue = vCurrRegKey.GetValue(vValue).ToString();;
}
if (vValue.Contains("Password"))
{
vGetLocalRegValue = Decrypt(vGetLocalRegValue);
}
return(vGetLocalRegValue);
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "in2SQLRegistry.getLocalRegValue");
return(null);
}
}
/* public static void schedulueDeleteFile(string vFileName )
* {
* RegistryKey vCurrRegKey = Registry.LocalMachine.OpenSubKey(@"CurrentControlSet\Control\Session Manager", true);
* try
* {
* if (vCurrRegKey == null)
* vCurrRegKey = Registry.CurrentUser.CreateSubKey(@"SOFTWARE\in2sql");
*
* if (vParameter.Contains("Password"))
* vValue = Encrypt(vValue);
*
* vCurrRegKey.SetValue(vOdbcName + '.' + vParameter, vValue);
*
* vCurrRegKey.Close();
* }
* catch (Exception e)
* {
* In2SqlSvcTool.ExpHandler(e, "in2SQLRegistry.etLocalValue");
* }
* }
*/
public static void delLocalValue(string vOdbcName)
{
RegistryKey vCurrRegKey = Registry.CurrentUser.OpenSubKey(@"Software\in2sql\", true);
try
{
if (vCurrRegKey == null)
{
return;
}
vOdbcName = vOdbcName.Replace("#", "");
vOdbcName = vOdbcName.Replace("$", "");
if (vOdbcName.Contains("CloudCH"))
{
vCurrRegKey.DeleteValue(vOdbcName + ".Login");
vCurrRegKey.DeleteValue(vOdbcName + ".Password");
vCurrRegKey.DeleteValue(vOdbcName + ".Url");
}
if (vOdbcName.Contains("Csv"))
{
vCurrRegKey.DeleteValue(vOdbcName + ".Path");
}
vCurrRegKey.Close();
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "in2SQLRegistry.etLocalValue");
}
}
private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
{
try
{
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "treeODBC_AfterSelect");
}
}
public static void getCloudTablesAndViews(TreeNodeMouseClickEventArgs e)
{
e.Node.Nodes.Clear();
string vCurrCloudName = e.Node.Text;
CloudProperties vCurrCloud = in2sqlSvcCloud.vCloudList.Find(item => item.CloudName == vCurrCloudName);
try
{
if ((in2sqlSvcCloud.checkCloudState(vCurrCloudName) < 0))
{
return;
}
e.Node.ImageIndex = 2;
e.Node.SelectedImageIndex = 2;
e.Node.Tag = vCurrCloud.CloudType + '#';
TreeNode vNodeTableFolder = new TreeNode("Tables".ToString(), 3, 3);
vNodeTableFolder.Tag = vCurrCloud.CloudName + "_tf";
e.Node.Nodes.Add(vNodeTableFolder);
initCloudObjects(ref vCurrCloud);
foreach (var vCurrTable in vCurrCloud.Tables)
{
TreeNode vNodeTable = new TreeNode(vCurrTable.Name, 4, 4);
vNodeTable.Tag = vCurrCloud.CloudName + "|" + vCurrTable.Name + "|$TABLE_CLD$";
vNodeTableFolder.Nodes.Add(vNodeTable);
TreeNode vNodeColumnTbl = new TreeNode(" ".ToString(), 99, 99);
vNodeColumnTbl.Tag = vCurrCloud.CloudName + "." + vCurrTable.Name;
vNodeTable.Nodes.Add(vNodeColumnTbl);
}
TreeNode vNodeViewFolder = new TreeNode("Views".ToString(), 5, 5);
vNodeViewFolder.Tag = vCurrCloud.CloudName + "_vf";
e.Node.Nodes.Add(vNodeViewFolder);
foreach (var vCurrView in vCurrCloud.Views)
{
TreeNode vNodeView = new TreeNode(vCurrView.Name, 6, 6);
vNodeView.Tag = vCurrCloud.CloudName + "." + vNodeView.Name + "|$VIEW_CLD$";
vNodeViewFolder.Nodes.Add(vNodeView);
TreeNode vNodeColumnVw = new TreeNode(" ".ToString(), 99, 99);
vNodeColumnVw.Tag = vCurrCloud.CloudName + "." + vNodeView.Name;
vNodeView.Nodes.Add(vNodeColumnVw);
}
return;
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "treeODBC_NodeMouseClick 1 ");
}
}
public static void ChangeOdbcValue(String vOdbcName, OdbcProperties vNewOdbcValue)
{
try
{
int vOdbcIndex = In2SqlSvcODBC.vODBCList.FindIndex(item => item.OdbcName == vOdbcName);
vODBCList[vOdbcIndex] = vNewOdbcValue;
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "ChangeOdbcValue");
}
}
private void treeODBC_AfterSelect(object sender, TreeViewEventArgs e)
{
try
{
/* string selectedNodeText = e.Node.Text;
* DialogResult result = MessageBox.Show(selectedNodeText + " 1");
*/
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "treeODBC_AfterSelect");
}
}
public static List <FolderProperties> FolderList()
{
try
{
List <FolderProperties> listClooudProperties = new List <FolderProperties>();
listClooudProperties.AddRange(getCsvList());
return(listClooudProperties);
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "CloudList");
return(null);
}
}
// var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vCurrvODBCList.OdbcName);
public static string getODBCProperties(string vODBCName, string vProperties)
{
try
{
var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vODBCName);
string vCurrProp = "";
if (vProperties.Contains("Database"))
{
vCurrProp = vCurrODBC.Database;
}
else if (vProperties.Contains("Description"))
{
vCurrProp = vCurrODBC.Description;
}
else if (vProperties.Contains("Driver"))
{
vCurrProp = vCurrODBC.Driver;
}
else if (vProperties.Contains("LastUser"))
{
vCurrProp = vCurrODBC.LastUser;
}
else if (vProperties.Contains("ConnErrMsg"))
{
vCurrProp = vCurrODBC.ConnErrMsg;
}
else if (vProperties.Contains("DBType"))
{
vCurrProp = vCurrODBC.DBType;
}
else if (vProperties.Contains("Login"))
{
vCurrProp = vCurrODBC.Login;
}
else if (vProperties.Contains("Password"))
{
vCurrProp = vCurrODBC.Password;
}
else if (vProperties.Contains("DSNStr"))
{
vCurrProp = vCurrODBC.DSNStr;
}
return(vCurrProp);
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "getODBCProperties");
return(null);
}
}
public static IEnumerable <String> sqlReadQuery(string vOdbcName, string queryString = "")
{
var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vOdbcName);
using
(OdbcConnection conn = new System.Data.Odbc.OdbcConnection())
{
using (OdbcCommand cmnd = new OdbcCommand(queryString, conn))
{
try
{
vCurrODBC.DSNStr = "DSN=" + vOdbcName;
if (vCurrODBC.Login != null)
{
vCurrODBC.DSNStr = vCurrODBC.DSNStr + ";Uid=" + vCurrODBC.Login + ";Pwd=" + vCurrODBC.Password + ";";
}
conn.ConnectionString = vCurrODBC.DSNStr;
conn.ConnectionTimeout = 5;
conn.Open();
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "In2SqlSvcODBC.ReadData", queryString);
conn.Close();
conn.Dispose();
yield break;
}
OdbcDataReader rd = cmnd.ExecuteReader();
string strRow = "";
while (rd.Read())
{
strRow = "";
for (int i = 0; i < rd.FieldCount; i++)
{
strRow = strRow + '"' + rd.GetString(i) + '"';
if (i < rd.FieldCount - 1)
{
strRow += ",";
}
}
yield return(strRow);
conn.Close();
conn.Dispose();
}
}
}
}
public static void getColumnsandIndexes(TreeNodeMouseClickEventArgs e)
{
try
{
String vNodeTag = e.Node.Parent.Parent.Text + '.' + e.Node.Text;
var vCurrObjProp = In2SqlSvcODBC.vObjProp.Find(item => item.ObjName == vNodeTag);
if (vCurrObjProp.objColumns == null)
{
In2SqlSvcODBC.vObjProp.AddRange(In2SqlSvcODBC.getObjectProperties(e.Node.Parent.Parent.Text, e.Node.Text));
vCurrObjProp = In2SqlSvcODBC.vObjProp.Find(item => item.ObjName == vNodeTag);
}
if (vCurrObjProp.objColumns != null)
{
if (vCurrObjProp.objColumns.Count > 0)
{
e.Node.Nodes.Clear();
foreach (var vCurrColumn in vCurrObjProp.objColumns)
{
TreeNode vNodeColumn = new TreeNode(vCurrColumn.ToString(), 14, 14);
vNodeColumn.Tag = vNodeTag + '.' + vCurrColumn + "_clm";
e.Node.Nodes.Add(vNodeColumn);
}
if (e.Node.Tag.ToString().Contains("$TABLE$"))
{
e.Node.Tag = vNodeTag + ".TABLE";
TreeNode vNodeIndexFolder = new TreeNode("Indexes".ToString(), 12, 12);
vNodeIndexFolder.Tag = vNodeTag + "_idx";
e.Node.Nodes.Add(vNodeIndexFolder);
foreach (var vCurrIndx in vCurrObjProp.objIndexes)
{
TreeNode vNodeIndx = new TreeNode(vCurrIndx.ToString(), 13, 13);
vNodeIndx.Tag = vNodeTag + '.' + vCurrIndx + "_idx";
vNodeIndexFolder.Nodes.Add(vNodeIndx);
}
}
else
{
e.Node.Tag = vNodeTag + ".VIEW";
}
}
}
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "getColumnsandIndexes ");
}
}
private static void initSQlObjects(ref In2SqlSvcODBC.OdbcProperties vCurrOdbc)
{
try
{
if (vCurrOdbc.Tables == null)
{
vCurrOdbc.Tables = new List <In2SqlSvcODBC.SqlObjects>();
}
if (vCurrOdbc.Views == null)
{
vCurrOdbc.Views = new List <In2SqlSvcODBC.SqlObjects>();
}
if (vCurrOdbc.SQLProgramms == null)
{
vCurrOdbc.SQLProgramms = new List <In2SqlSvcODBC.SqlObjects>();
}
if (vCurrOdbc.SQLFunctions == null)
{
vCurrOdbc.SQLFunctions = new List <In2SqlSvcODBC.SqlObjects>();
}
if (vCurrOdbc.Tables.Count == 0)
{
vCurrOdbc.Tables.AddRange(In2SqlSvcODBC.getTableList(vCurrOdbc.OdbcName));
}
if (vCurrOdbc.Views.Count == 0)
{
vCurrOdbc.Views.AddRange(In2SqlSvcODBC.getViewList(vCurrOdbc.OdbcName));
}
if (vCurrOdbc.SQLProgramms.Count == 0)
{
vCurrOdbc.SQLProgramms.AddRange(In2SqlSvcODBC.getSQLProgrammsList(vCurrOdbc.OdbcName));
}
if (vCurrOdbc.SQLFunctions.Count == 0)
{
vCurrOdbc.SQLFunctions.AddRange(In2SqlSvcODBC.getSQLFunctionsList(vCurrOdbc.OdbcName));
}
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "initSQlObjects");
}
}
public void ExecDropDown(Office.IRibbonControl vControl)
{
try
{
/* string caption = "Information message";
* MessageBoxButtons buttons = MessageBoxButtons.YesNo;
* DialogResult result;
*
* result = MessageBox.Show(vControl.Id, caption, buttons);*/
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "ExecDropDown");
}
}
public static List <OdbcProperties> ODBCList()
{
try
{
vIdtbl = 0;
List <OdbcProperties> listOdbcProperties = new List <OdbcProperties>();
listOdbcProperties.AddRange(getODBCList(Registry.CurrentUser));
listOdbcProperties.AddRange(getODBCList(Registry.LocalMachine));
return(listOdbcProperties);
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "ODBCList");
return(null);
}
}
private void GetCSVRecords(TreeNode nodeToAddTo)
{
try
{
In2SqlSvcCsv.vFolderList = In2SqlSvcCsv.FolderList();
foreach (var vCurrFolder in In2SqlSvcCsv.vFolderList)
{
in2SqlRightPaneTreeTables.setCSVTreeLineSimple(nodeToAddTo, vCurrFolder.FolderName, "CSV$");
}
return;
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "GetCloudRecords");
}
}
public in2SqlWF03PanelRigtSqlM()
{
try
{
InitializeComponent();
PopulateOdbcTreeView();
initParam();
newToolStripButton_Click(null, null);
SqlBuild();
// OdbcEditPanel();
CurrSqlPanel = this;
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "in2SqlRightPane");
}
}
private static void initCsvObjects(ref In2SqlSvcCsv.FolderProperties vCurrCloudObj)
{
try
{
if (vCurrCloudObj.Files == null)
{
vCurrCloudObj.Files = new List <In2SqlSvcCsv.CloudObjects>();
}
if (vCurrCloudObj.Files.Count == 0)
{
vCurrCloudObj.Files.AddRange(In2SqlSvcCsv.getFileList(vCurrCloudObj.FolderName));
}
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "initCloudObjects");
}
}
private void GetCloudRecords(TreeNode nodeToAddTo, string vCloudType)
{
try
{
in2sqlSvcCloud.vCloudList = in2sqlSvcCloud.CloudList();
foreach (var vCurrCloudList in in2sqlSvcCloud.vCloudList)
{
if (vCurrCloudList.CloudType.Contains(vCloudType))
{
in2SqlRightPaneTreeTables.setODBCTreeLineSimple(nodeToAddTo, vCurrCloudList.CloudName, vCloudType + '$');
}
}
return;
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "GetCloudRecords");
}
}
public void PopulateExcelTreeView( )
{
try
{
TreeNode rootTable = new TreeNode("Excel".ToString(), 4, 4);
rootTable.Tag = "excel";
TreeNode vNodeExcelSheet = new TreeNode(" ".ToString(), 99, 99);
rootTable.Nodes.Add(vNodeExcelSheet);
treeExcelOtl.Nodes.Add(rootTable);
TreeNode rootTask = new TreeNode("Tasks".ToString(), 3, 3);
rootTask.Tag = "task";
TreeNode vNodeExcelTask = new TreeNode(" ".ToString(), 99, 99);
rootTask.Nodes.Add(vNodeExcelTask);
treeExcelOtl.Nodes.Add(rootTask);
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "PopulateOdbcTreeView");
}
}
public static string writeSqlToFile(string vOdbcName, string queryString = "")
{
try
{
string vFileName = getTmpFileName();
using (StreamWriter vCurrFile = new StreamWriter(vFileName))
{
foreach (var str in sqlReadQuery(vOdbcName, queryString))
{
vCurrFile.WriteLine(str);
}
}
return(vFileName);
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "In2SqlSvcTool.writeSqlToFile", vOdbcName + " # " + queryString);
return(null);
}
}
public static string writeHttpToFile(string vHttpUrl)
{
try
{
string vFileName = getTmpFileName();
using (StreamWriter vCurrFile = new StreamWriter(vFileName))
{
foreach (var str in HttpGetArray(vHttpUrl))
{
vCurrFile.WriteLine(str);
}
}
return(vFileName);
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "In2SqlSvcTool.writeHttpToFile", vHttpUrl);
return(null);
}
}
private static void initCloudObjects(ref in2sqlSvcCloud.CloudProperties vCurrCloudObj)
{
try
{
if (vCurrCloudObj.Tables == null)
{
vCurrCloudObj.Tables = new List <in2sqlSvcCloud.CloudObjects>();
}
if (vCurrCloudObj.Views == null)
{
vCurrCloudObj.Views = new List <in2sqlSvcCloud.CloudObjects>();
}
if (vCurrCloudObj.SQLProgramms == null)
{
vCurrCloudObj.SQLProgramms = new List <in2sqlSvcCloud.CloudObjects>();
}
if (vCurrCloudObj.SQLFunctions == null)
{
vCurrCloudObj.SQLFunctions = new List <in2sqlSvcCloud.CloudObjects>();
}
if (vCurrCloudObj.Tables.Count == 0)
{
vCurrCloudObj.Tables.AddRange(in2sqlSvcCloud.getCloudTableList(vCurrCloudObj.CloudName));
}
if (vCurrCloudObj.Views.Count == 0)
{
vCurrCloudObj.Views.AddRange(in2sqlSvcCloud.getCloudViewList(vCurrCloudObj.CloudName));
}
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "initCloudObjects");
}
}
public static IEnumerable <String> SqlReadDataValue(string vOdbcName, string queryString = "")
{
var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vOdbcName);
using
(OdbcConnection conn = new System.Data.Odbc.OdbcConnection())
{
using (OdbcCommand cmnd = new OdbcCommand(queryString, conn))
{
try
{
vCurrODBC.DSNStr = "DSN=" + vOdbcName;
if (vCurrODBC.Login != null)
{
vCurrODBC.DSNStr = vCurrODBC.DSNStr + ";Uid=" + vCurrODBC.Login + ";Pwd=" + vCurrODBC.Password + ";";
}
conn.ConnectionString = vCurrODBC.DSNStr;
conn.ConnectionTimeout = 5;
conn.Open();
}
catch (Exception e)
{
In2SqlSvcTool.ExpHandler(e, "In2SqlSvcODBC.ReadData", queryString);
conn.Close();
conn.Dispose();
yield break;
}
OdbcDataReader rd = cmnd.ExecuteReader();
while (rd.Read())
{
yield return(rd["value"].ToString());//.Split(',').ToList(); ;
}
conn.Close();
conn.Dispose();
}
}
}
private void treeODBC_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
try
{
miSelectNode = treeODBC.GetNodeAt(e.X, e.Y);
if (e.Node.Tag != null)
{
if (e.Button == MouseButtons.Left)
{
expand_action(e);
}
else
{
contextMenu(e);
}
}
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "treeODBC_NodeMouseClick ");
}
}
public static void setODBCTreeLineComplex(TreeNode nodeToAddTo, string vCurrvListOdbcName, string VCurrOdbcName)
{
try
{
var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vCurrvListOdbcName);
if ((vCurrODBC.ConnStatus == 0))
{
setODBCTreeLineSimple(nodeToAddTo, vCurrvListOdbcName);
return;
}
if (vCurrODBC.ConnStatus < 0)
{
TreeNode vNodeDatabase = new TreeNode(vCurrODBC.OdbcName, 7, 7);
nodeToAddTo.Nodes.Add(vNodeDatabase);
vNodeDatabase.Tag = "ODBC%";
TreeNode vNodeTable = new TreeNode(vCurrODBC.ConnErrMsg, 99, 99);
vNodeDatabase.Nodes.Add(vNodeTable);
return;
}
if ((vCurrODBC.ConnStatus == 1) & vCurrvListOdbcName.Contains(VCurrOdbcName) & vCurrvListOdbcName.Length == VCurrOdbcName.Length)
{
initSQlObjects(ref vCurrODBC);
}
if (vCurrODBC.ConnStatus == 1 & (vCurrODBC.Tables.Count == 0 & vCurrODBC.Views.Count == 0))
{
TreeNode vNodeDatabase = new TreeNode(vCurrODBC.OdbcName, 2, 2);
nodeToAddTo.Nodes.Add(vNodeDatabase);
vNodeDatabase.Tag = "ODBC#";
return;
}
if (vCurrODBC.ConnStatus == 1 & (vCurrODBC.Tables.Count > 0 | vCurrODBC.Views.Count > 0))
{
TreeNode vNodeDatabase = new TreeNode(vCurrODBC.OdbcName, 2, 2);
nodeToAddTo.Nodes.Add(vNodeDatabase);
vNodeDatabase.Tag = "ODBC#";
if (vCurrODBC.Tables.Count > 0)
{
TreeNode vNodeTableFolder = new TreeNode("Tables".ToString(), 3, 3);
vNodeTableFolder.Tag = vCurrODBC.OdbcName + "tf";
vNodeDatabase.Nodes.Add(vNodeTableFolder);
foreach (var vCurrTable in vCurrODBC.Tables)
{
TreeNode vNodeTable = new TreeNode(vCurrTable.Name, 4, 4); // vNodeTable.Tag = vCurrTable.Name;
vNodeTableFolder.Nodes.Add(vNodeTable);
}
}
if (vCurrODBC.Views.Count > 0)
{
TreeNode vNodeViewFolder = new TreeNode("Views".ToString(), 5, 5);
vNodeViewFolder.Tag = vCurrODBC.OdbcName + "vf";
vNodeDatabase.Nodes.Add(vNodeViewFolder);
foreach (var vCurrView in vCurrODBC.Views)
{
TreeNode vNodeView = new TreeNode(vCurrView.Name, 6, 6); // vNodeTable.Tag = vCurrTable.Name;
vNodeViewFolder.Nodes.Add(vNodeView);
}
}
}
}
catch (Exception er)
{
In2SqlSvcTool.ExpHandler(er, "setODBCTreeLineComplex");
}
}
