public JsonResult menuSave(menuTreeGridRow model) { //检测菜单名称是否合法 //Dictionary<string, string> dic = new Dictionary<string, string>(); //dic.Add("name", model.name); //var list = new Dal.Basedata.t_ordertypeDal(dic, "name").ToList(); //if (list.Count == 0) //{ // return Json(new { success = "error", message = "请先在[订单类型档案]添加上该订单类型" }); //} //var src = "/Order/index?type=" + list[0].code; //Dal.DataHelper.ExcuteNonQuery("insert into s_menu(code,name,topcode,src,icon) values ('" + model.code + "','" + model.name + "','" + model.topcode + "','" + src + "','" + model.icon + "')"); return(Json(new { success = "ok", message = "保存成功" })); }
public JsonResult appMenuTree() { List <menuTreeGridRow> list = new List <menuTreeGridRow>(); DataTable dt = Dal.DataHelper.GetDataTable(@"select code,name,topcode,icon,src, flag from s_menu_m order by code "); DataRow[] dr = dt.Select(" topcode = '~' "); foreach (var i in dr) { menuTreeGridRow model = new menuTreeGridRow() { code = i["code"].ToString(), name = i["name"].ToString(), icon = i["icon"].ToString(), src = i["src"].ToString(), flag = i["flag"].ToString() == "0" ? "正常" : "禁用" }; DataRow[] drs = dt.Select(" topcode like '" + i["code"].ToString() + "%'", "code asc"); List <menuTreeGridRow> lists = new List <menuTreeGridRow>(); foreach (var s in drs) { lists.Add(new menuTreeGridRow() { code = s["code"].ToString(), name = s["name"].ToString(), icon = s["icon"].ToString(), src = s["src"].ToString(), flag = s["flag"].ToString() == "0" ? "正常" : "禁用" }); } model.children = lists.ToArray(); list.Add(model); } return(Json(list)); }