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)); }