/// <summary>
/// 更新一条网站信息
/// </summary>
/// <param name="wi">网站信息</param>
/// <returns>返回是否更新成功</returns>
public Boolean UpdateWebInfo(sys_onepage wi)
{
try
{
string sql = "update sys_onepage set modelname=@modelname,title=@title,contents=@contents,sort_id=@sort_id,seo_title=@seo_title,"
+ "seo_keyword=@seo_keyword,seo_desc=@seo_desc,img_url=@img_url where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@modelname", wi.modelname),
new SqlParameter("@title", wi.title),
new SqlParameter("@contents", wi.contents),
new SqlParameter("@sort_id", wi.sort_id),
new SqlParameter("@seo_title", wi.seo_title),
new SqlParameter("@seo_keyword", wi.seo_keyword),
new SqlParameter("@seo_desc", wi.seo_desc),
new SqlParameter("@img_url", wi.img_url),
new SqlParameter("@id", wi.id)
};
return(db.ExecuteNonQuery(sql, sp));
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
/// <summary>
/// 添加一条网站信息
/// </summary>
/// <param name="wi">网站信息</param>
/// <returns>返回是否添加成功</returns>
public Boolean AddWebInfo(sys_onepage wi)
{
try
{
string sql = "insert into sys_onepage(modelname,title,contents,sort_id,seo_title,seo_keyword,seo_desc,img_url)"
+ "values (@modelname,@title,@contents,@sort_id,@seo_title,@seo_keyword,@seo_desc,@img_url)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@modelname", wi.modelname),
new SqlParameter("@title", wi.title),
new SqlParameter("@contents", wi.contents),
new SqlParameter("@sort_id", wi.sort_id),
new SqlParameter("@seo_title", wi.seo_title),
new SqlParameter("@seo_keyword", wi.seo_keyword),
new SqlParameter("@seo_desc", wi.seo_desc),
new SqlParameter("@img_url", wi.img_url)
};
return(db.ExecuteNonQuery(sql, sp));
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
public ActionResult DelWebInfo(int CompetenceId, int WebInfoId)
{
if (Session[Keys.SESSION_ADMIN_INFO] == null)
{
return(RedirectToAction("Login", "Admin"));
}
else
{
Master master = Session[Keys.SESSION_ADMIN_INFO] as Master;
if (rcm.GetRoleCompetence(master.RoleId, CompetenceId))
{
sys_onepage wi = wim.GetWebInfo(WebInfoId);
ViewData["modelname"] = wi.modelname;
ViewData["title"] = wi.title;
ViewData["contents"] = wi.contents;
ViewData["sort_id"] = wi.sort_id;
ViewData["seo_title"] = wi.seo_title;
ViewData["seo_keyword"] = wi.seo_keyword;
ViewData["seo_desc"] = wi.seo_desc;
ViewData["img_url"] = wi.img_url;
ViewData["id"] = wi.id;
ViewData["style"] = "display:none";
if (rcm.GetRoleCompetence(master.RoleId, int.Parse(CompetenceId + "1")))
{
ViewData["style"] = "display:block";
}
return(View("WebInfo"));
}
else
{
return(RedirectToAction("Login", "Admin"));
}
}
}
public ActionResult Index()
{
int WebInfoId = string.IsNullOrEmpty(Request["Id"]) ? 1 : int.Parse(Request["Id"]);
sys_onepage wi = wim.GetWebInfo(WebInfoId);
ViewData["AboutTitle"] = wi.title;
ViewData["AboutText"] = wi.contents;
return(View());
}
public bool UpdateWebInfo()
{
sys_onepage wi = new sys_onepage();
wi.modelname = Request["modelname"];
wi.title = Request["title"];
wi.contents = Request["contents"];
wi.sort_id = int.Parse(Request["sort_id"]);
wi.seo_title = Request["seo_title"];
wi.seo_keyword = Request["seo_keyword"];
wi.seo_desc = Request["seo_desc"];
wi.img_url = Request["img_url"];
wi.id = int.Parse(Request["id"]);
return(wim.UpdateWebInfo(wi));
}
/// <summary>
/// 获取网站信息
/// </summary>
/// <param name="WebInfoId">网站信息ID</param>
/// <returns>返回网站信息</returns>
public sys_onepage GetWebInfo(int WebInfoId)
{
sys_onepage wi = new sys_onepage();
try
{
string sql = "select * from sys_onepage where id=@WebInfoId";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@WebInfoId", WebInfoId)
};
using (SqlDataReader reder = db.GetReader(sql, sp))
{
while (reder.Read())
{
wi.id = (int)reder["id"];
wi.modelname = reder["modelname"].ToString();
wi.title = reder["title"].ToString();
wi.contents = reder["contents"].ToString();
wi.sort_id = (int)reder["sort_id"];
wi.img_url = reder["img_url"].ToString();
wi.seo_title = reder["seo_title"].ToString();
wi.seo_keyword = reder["seo_keyword"].ToString();
wi.seo_desc = reder["seo_desc"].ToString();
}
}
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
return(wi);
}
/// <summary>
/// 更新一条网站信息
/// </summary>
/// <param name="wi">网站信息</param>
/// <returns>返回是否更新成功</returns>
public Boolean UpdateWebInfo(sys_onepage wi)
{
return(wis.UpdateWebInfo(wi));
}
