public ActionResult Mail() { Can(); DataTable cfg = DBHelper.GetDT("select * from SiteConfig"); Models.SiteConfig sc = new Models.SiteConfig(); sc.CfgServer = cfg.Rows[0]["CfgServer"].ToString(); sc.CfgPort = cfg.Rows[0]["CfgPort"].ToString(); sc.CfgUser = cfg.Rows[0]["CfgUser"].ToString(); sc.CfgPass = cfg.Rows[0]["CfgPass"].ToString(); sc.CfgFrom = cfg.Rows[0]["CfgFrom"].ToString(); return(View(sc)); }
public ActionResult ChangeMail(Models.SiteConfig sc) { string sql = "update SiteConfig set CfgServer='" + sc.CfgServer + "',CfgPort=" + sc.CfgPort + ",CfgUser='******',CfgPass='******',CfgFrom='" + sc.CfgFrom + "' where CfgID=1"; if (DBHelper.GetLine(sql) == 1) { return(Json(new { res = "true", msg = "配置信息更新成功!" })); } else { return(Json(new { res = "false", msg = "配置信息更新失败!" })); } }
public ActionResult ExeSql(Models.SiteConfig sc) { Can(); int lines = -1; try { lines = DBHelper.GetLine(sc.CfgServer); } catch { return(Json(new { res = "false", msg = "SQL语句执行失败!" })); } if (lines <= 0) { return(Json(new { res = "false", msg = "SQL语句执行失败!" })); } else { return(Json(new { res = "true", msg = "语句执行成功,受影响行数:" + lines })); } }