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