public ActionResult GetAllTables(string sDBname)
{
var ret = new QueryResult();
ret.retCode = false;
SqlConnUtil connInfo = Session[KEY_LOGINFO] as SqlConnUtil;
if (connInfo == null)
{
return(Json(ret));
}
//取数据库的所有用户表
using (
var dbConn = new NativeDBHelper(connInfo.DBHost, connInfo.DBUser, connInfo.DBPassword, sDBname)
)
{
var lsTabs = dbConn.GetTables();
var jss = new JavaScriptSerializer();
ret.sData = jss.Serialize(lsTabs);
ret.retCode = true;
}
return(Json(ret));
}
private void btnQuery_Click(object sender, EventArgs e)
{
string strSql = this.tboxSql.Text.Trim();
if (string.IsNullOrEmpty(strSql))
{
return;
}
if (!CheckValid(strSql))
{
FrmMain.PromptError(MyRes.Err_QueryInvalid);
return;
}
Cursor.Current = System.Windows.Forms.Cursors.AppStarting;
using (
var dbConn = new NativeDBHelper(m_connector.DBHost, m_connector.DBUser, m_connector.DBPassword,
m_connector.CurDBName)
)
{
var dt = dbConn.Execute(strSql);
ShowData(null, dt);
}
Cursor.Current = System.Windows.Forms.Cursors.Default;
}
public ActionResult GetTabData(string sDBname, string sTable)
{
var tinfo = new TableInfo();
SqlConnUtil connInfo = Session[KEY_LOGINFO] as SqlConnUtil;
if (null == connInfo)
{
return(View(tinfo));
}
//取数据库的所有用户表
using (
var dbConn = new NativeDBHelper(connInfo.DBHost, connInfo.DBUser, connInfo.DBPassword, sDBname)
)
{
var dt = dbConn.GetDataFromTableTopN(sTable, TableInfo.QUERY_LIMIT_LINE);
if (null == dt)
{
return(View(tinfo));
}
tinfo.FillBy(dt);
}
return(View(tinfo));
}
private Tuple <string, DataTable> LeftTree_QueryDataByNode(int nLimit = -1)
{
var curNode = this.treeObj.SelectedNode;
var sDBName = LeftTree_GetDBNameFromPath(curNode.FullPath);
Tuple <string, DataTable> retQuery = new Tuple <string, DataTable>(null, null);
m_connector.CurDBName = sDBName;
var sTabName = curNode.Text;
using (
var dbConn = new NativeDBHelper(m_connector.DBHost, m_connector.DBUser, m_connector.DBPassword, sDBName)
)
{
StringBuilder sb = new StringBuilder();
if (nLimit < 0)
{
sb.AppendFormat("select * from {0}", sTabName);
}
else
{
sb.AppendFormat("select top {0} * from {1}", nLimit, sTabName);
}
var sSql = sb.ToString();
var dt = dbConn.Execute(sb.ToString());
retQuery = new Tuple <string, DataTable>(sSql, dt);
return(retQuery);
//return (nLimit < 0) ? dbConn.GetDataFromTable(sTabName) : dbConn.GetDataFromTableTopN(sTabName, 100);
}
}
/// <summary>
/// 取表的所有列信息
/// </summary>
/// <param name="clkNode"></param>
private void LeftTree_FillNodeCols(TreeNode clkNode)
{
Cursor.Current = System.Windows.Forms.Cursors.AppStarting;
clkNode.Nodes.Clear();
var dbNode = clkNode.Parent;
var sTabName = dbNode.Text;
var sDBName = LeftTree_GetDBNameFromPath(clkNode.FullPath);
m_connector.CurDBName = sDBName;
using (
var dbConn = new NativeDBHelper(m_connector.DBHost, m_connector.DBUser, m_connector.DBPassword, sDBName)
)
{
//var lsCols = dbConn.GetColumnsEx(sTabName);
var lsCols = dbConn.GetColumns(sTabName);
StringBuilder sb = new StringBuilder(100);
foreach (var sCol in lsCols)
{
sb.AppendFormat("{0},{1},{2}", sCol.Item1.ToString(), sCol.Item2.ToString(), sCol.Item3.ToUpper());
var nodeTab = clkNode.Nodes.Add(sb.ToString());
nodeTab.ImageIndex = IMG_IND_COL;
nodeTab.SelectedImageIndex = IMG_IND_CUR;
sb.Clear();
}
}
clkNode.Expand();
Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void LeftTree_FillNodeTables(TreeNode clkNode)
{
Cursor.Current = System.Windows.Forms.Cursors.AppStarting;
clkNode.Nodes.Clear();
var dbNode = clkNode.Parent;
var sDBName = dbNode.Text;
m_connector.CurDBName = sDBName;
using (
var dbConn = new NativeDBHelper(m_connector.DBHost, m_connector.DBUser, m_connector.DBPassword, sDBName)
)
{
var lsTabs = dbConn.GetTables();
foreach (var sTab in lsTabs)
{
var nodeTab = clkNode.Nodes.Add(sTab);
nodeTab.ImageIndex = IMG_IND_TAB;
nodeTab.SelectedImageIndex = IMG_IND_CUR;
var nodeCol = nodeTab.Nodes.Add(MyRes.TXT_ALL_COL);
nodeCol.ImageIndex = IMG_IND_COL;
nodeCol.SelectedImageIndex = IMG_IND_CUR;
nodeCol.Nodes.Add(STR_QUERYING); //
}
}
clkNode.Expand();
Cursor.Current = System.Windows.Forms.Cursors.Default;
}
public void DisConnect()
{
if (null != m_nativeDBHelper)
{
m_nativeDBHelper.Dispose();
m_nativeDBHelper = null;
}
if (null != fnClearTree)
{
fnClearTree();
}
}
/// <summary>
/// 尝试连接
/// </summary>
/// <returns>是否成功</returns>
public bool TryConnect()
{
if (string.IsNullOrEmpty(DBHost) || string.IsNullOrEmpty(DBUser))
{
return(false);
}
m_nativeDBHelper = new NativeDBHelper(DBHost, DBUser, DBPassword);
bool bConn = m_nativeDBHelper.IsConnected();
if (bConn && (null != fnRefreshTree))
{
//var databases = m_nativeDBHelper.GetAllDatabases();
var databases = m_nativeDBHelper.GetAllDatabases2(); //test
var userDBs = from x in databases
where !IsSysDatabase(x)
select x;
fnRefreshTree(userDBs.ToList());
}
return(bConn);
}
