/// <summary>
/// 关于我们列表
/// </summary>
/// <returns></returns>
public ActionResult List(int id, int?pageIndex, int pgaesize = 10)
{
// List<V_type_news> list = ef.V_type_news.Where(p => p.web_Type_menu_id == id).OrderByDescending(p => p.newid).ToList();
string title = "关于我们";
hx_td_web_type pr = ef.hx_td_web_type.Where(c => c.menu_id == id).FirstOrDefault();
if (pr != null)
{
title = pr.menu_name;
}
var list = ef.V_type_news.Where(p => p.web_Type_menu_id == id).OrderByDescending(p => p.listcomm).ThenByDescending(p => p.newid).ToPagedList(pageIndex ?? 1, pgaesize);
ViewBag.title1 = title;
ViewBag.MenuId = id;
if (Request.IsAjaxRequest())
{
return(PartialView("_aboutList", list));
}
GetLink(id, "List"); //获取导航
ViewBag.Link = Namelist;
return(View(list));
}
public ActionResult Editpost(hx_td_web_type p, int rootid = 0, int id = 0)
{
ChuanglitouP2P.BLL.B_td_web_type b1 = new BLL.B_td_web_type();
ChuanglitouP2P.Model.M_td_web_type obj = new Model.M_td_web_type();
string ClassName;
string path1;
int orderid = 1;
int ParentID;
ParentID = Convert.ToInt16(Request.Form["parentid"]);
ClassName = DNTRequest.GetString("menu_name");
orderid = DNTRequest.GetInt("orderid", 1);
path1 = DNTRequest.GetString("path1");
DbHelperSQL.RunSql("update hx_td_web_type set menu_name='" + ClassName + "',path1='" + path1 + "',orderid=" + orderid + " where menu_id=" + id.ToString());
string str = "";
str = StringAlert.Alert("网站分类编辑成功!", "/Admin/WebType/index?rootid=" + rootid);
return(Content(str, "text/html"));
}
/// <summary>
/// 面包屑导航
/// </summary>
private void GetLink(int id, string type)
{
if (type == "Detail")
{
V_type_news vpn = ef.V_type_news.Where(p => p.newid == id).FirstOrDefault();
if (vpn != null)
{
if (Namelist == "")
{
id = Convert.ToInt32(vpn.web_Type_menu_id);
Namelist = "<a style=\"cursor: pointer; \"> " + vpn.News_title + " </a>";
}
}
}
hx_td_web_type pr = ef.hx_td_web_type.Where(c => c.menu_id == id).FirstOrDefault();
if (pr != null)
{
if (Namelist != "")
{
if (id == 3) //如果是 关于我们
{
Namelist = "<a style=\"cursor: pointer; \" href=\"/about.html\"> " + pr.menu_name + " </a>>" + "<a style=\"cursor: pointer; \"> " + Namelist + " </a>";
}
else
{
Namelist = "<a style=\"cursor: pointer; \" href=\"/about/List/" + id + "\"> " + pr.menu_name + " </a>>" + "<a style=\"cursor: pointer; \"> " + Namelist + " </a>";
}
}
else
{
Namelist = "<a style=\"cursor: pointer; \"> " + pr.menu_name + " </a>";
}
if (pr.parentid != 0)
{
GetLink(Convert.ToInt32(pr.parentid), type);
}
}
}
public ActionResult DelById(int id, int rootid = 0)
{
string str = "";
hx_td_web_type pDel = new hx_td_web_type()
{
menu_id = id
};
ef.hx_td_web_type.Attach(pDel);
ef.hx_td_web_type.Remove(pDel);
int i = ef.SaveChanges();
if (i > 0)
{
str = StringAlert.Alert("网站分类删除成功!", "/admin/WebType/Index?rootid=" + rootid.ToString());
}
else
{
str = StringAlert.Alert("网站分类删除失败!", "/admin/WebType/Index?rootid=" + rootid.ToString());
}
return(Content(str, "text/html"));
}
public ActionResult Addpost(hx_td_web_type p)
{
ChuanglitouP2P.BLL.B_td_web_type b1 = new BLL.B_td_web_type();
ChuanglitouP2P.Model.M_td_web_type obj = new Model.M_td_web_type();
int rootid = DNTRequest.GetInt("rootid", 0);
int isresult = 0;
int ClassID = 0;
string ClassName;
int PrevOrderID;
int RootID = 0;
int ParentDepth;
string ParentPath;
string ParentName;
int depath;
int PrevID;
int Child;
int ParentID;
PrevOrderID = 0;
ParentPath = "0";
ParentName = "";
ParentDepth = 0;
PrevID = 0;
Child = 0;
ParentPath = "";
ParentID = Convert.ToInt16(Request.Form["parentid"]);
ClassName = DNTRequest.GetString("menu_name");
ClassID = b1.GetMaxId();
if (ParentID > 0)
{
SqlDataReader sdr = DbHelperSQL.Re_dr("select * From hx_td_web_type where menu_id=" + ParentID.ToString() + "");
if (sdr.Read() == false)
{
Response.Write("<script>alert(\"所属栏目已经被删除！\");history.back();</script>");
}
else
{
RootID = Convert.ToInt32(sdr["RootID"]);
ParentName = sdr["menu_name"].ToString();
ParentDepth = Convert.ToInt32(sdr["Depath"]);
ParentPath = sdr["ParentPath"].ToString();
Child = Convert.ToInt32(sdr["Child"]);
// ParentPath = ParentPath + "," + ParentID; //得到此栏目的父级栏目路径
PrevOrderID = Convert.ToInt32(sdr["OrderID"]);
sdr.Close();
sdr.Dispose();
}
sdr.Close();
sdr.Dispose();
}
else
{
RootID = ClassID;
}
// p = (hx_td_web_type)Utils.ValidateModelClass(p);
if (ParentID > 0)
{
depath = ParentDepth + 1;
}
else
{
depath = 0;
}
if (ParentPath == "")
{
ParentPath = "," + ClassID.ToString() + ",";
}
else
{
ParentPath += "," + ClassID.ToString() + ",";
}
try
{
obj.menu_id = ClassID; // +i;
obj.menu_name = ClassName; // +i.ToString();
obj.parentid = ParentID;
obj.parentpath = ParentPath;
obj.depath = depath;
obj.rootid = rootid;
obj.child = 0;
obj.previd = PrevID;
obj.nextid = 0;
obj.createtime = DateTime.Now;
obj.orderid = DNTRequest.GetInt("orderid", 1);
obj.path1 = DNTRequest.GetString("path1");
isresult = b1.Add(obj);
}
catch (Exception ee)
{
Response.Write(ee.Message.ToString());
}
if (ParentID > 0)
{
//更新其父类的子栏目数
DbHelperSQL.RunSql("update hx_td_web_type set child=child+1 where menu_id=" + ParentID.ToString());
}
else if (ParentID == 0)
{
//DbHelperSQL.RunSql("update hx_td_web_type set rootid=" + isresult + ",parentpath='," + isresult + ",' where menu_id=" + isresult.ToString());
DbHelperSQL.RunSql("update hx_td_web_type set parentpath='," + isresult + ",' where menu_id=" + isresult.ToString());
}
//Response.Write("<script>alert(\"添加成功\");location.href='Add_Edit_web_type.aspx?ParentID=" + ParentID.ToString() + "'</script>");
//p.createtime = DateTime.Now;
//p.menu_name = DNTRequest.GetString("menu_name");
//p.path1 = DNTRequest.GetString("path1");
//p.orderid = DNTRequest.GetInt("orderid", 0);
//ef.hx_td_web_type.Add(p);
//ef.SaveChanges();
string str = "";
if (rootid > 0)
{
str = StringAlert.Alert("网站分类添加成功!", "/Admin/WebType/index?rootid=" + rootid);
}
else
{
str = StringAlert.Alert("网站分类添加成功!", "/Admin/WebType/index?rootid=" + isresult);
}
return(Content(str, "text/html"));
}
