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));
}
public ActionResult Login(ConnInfo connInfo)
{
bool bConn = false;
var ret = new QueryResult();
SqlConnUtil connector = null;
if (connInfo != null)
{
connector = new SqlConnUtil();
connector.SetConnectInfo(connInfo.host, connInfo.user, connInfo.pass);
bConn = connector.TryConnect();
}
if (bConn)
{
Session[KEY_LOGINFO] = connector;
//return RedirectToAction("QueryPage");
ret.retCode = true;
ret.sData = "QueryPage";
return(Json(ret));
}
else
{
ModelState.AddModelError("", "无法登录到目标数据库。");
//return Json(Url.Action("Index"));
ret.retCode = false;
ret.sData = "Index";
return(Json(ret));
}
//return View();
}
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));
}
// GET
public ActionResult QueryPage()
{
SqlConnUtil connInfo = Session[KEY_LOGINFO] as SqlConnUtil;
if (connInfo == null)
{
return(RedirectToAction("Index"));
}
return(View(connInfo));
}
