private void GetUserMenu(string userCode)
{
IList <SysMenuEntity> menulist = ContainerBuilderHelper.Instance.GetUserPartMenu(userCode);
menulist = GetDistinctMenu(menulist);
List <SysMenuModel> lsetm = new List <SysMenuModel>();
if (menulist != null)
{
var onemenulist = menulist.Where(w => w.Menulevel == 0);
foreach (var item in onemenulist)
{
SysMenuModel etm = new SysMenuModel();
etm.id = item.Id.Value;
etm.text = item.Menuname;
etm.attributes = new AttributesModel
{
iframe = "1",
datalink = item.Menuurl
};
etm.iconCls = item.Menuicon;
GetUserChildrenMenu(etm, menulist, item.Menucode);
lsetm.Add(etm);
}
}
CurentMenu = lsetm;
CacheHelper.Insert("CurentMenu_" + UserInfo.UserCode, lsetm);
}
public void DateLoad()
{
SysMenuModel model = new SysMenuModel();
List <SysMenuModel> MenuList = SMBll.GetMenuList(model);
MenuHtml = IListToHtml(MenuList, ParentID);
}
public void DataLoad()
{
List <ListItem> MenuTypeList = EnumHelper.GetEnumList(typeof(SysEnum.MenuType));
MenuTypeList = MenuTypeList.Where(p => Convert.ToInt32(p.Value) > 0).ToList();
MenuType.Items.Add(new ListItem("-请选择-", ""));
MenuType.Items.AddRange(MenuTypeList.ToArray());
MenuType.DataBind();
if (MID != "")
{
if (MID != "00000000-0000-0000-0000-000000000000")
{
SysMenuModel model = new SysMenuModel();
model.MenuID = new Guid(MID);
model.DeleteFlag = Convert.ToInt32(SysEnum.DeleteFlag.NotRemoved);
List <SysMenuModel> MenuList = SMBll.GetMenuList(model);
this.MenuName.Value = MenuList.First().MenuName;
this.ParentID.Value = MenuList.First().ParentID;
this.ParentTree.Value = MenuList.First().ParentID;
this.MenuType.Value = MenuList.First().MenuType.ToString();
this.MenuImg.Value = MenuList.First().MenuImg;
this.Img_Menu_Img.Src = MenuList.First().MenuImg == "" ? "/Theme/Image/illustration.png" : ("/Theme/Image/32/" + MenuList.First().MenuImg);
this.SortCode.Value = MenuList.First().SortCode.ToString();
this.NavigateUrl.Value = MenuList.First().NavigateUrl;
}
else
{
ShowMsgHelper.AlertMsg("请选择菜单！");
}
}
}
/// <summary>
/// 修改系统菜单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(SysMenuModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update sysmenu set ");
strSql.Append(" menuName=@menuName, ");
strSql.Append(" menuIco=@menuIco,");
strSql.Append(" menuUrl=@menuUrl,");
//strSql.Append(" mPID=@mPID,");
strSql.Append(" mSort=@mSort ");
strSql.Append(" where mid=@mid ");
MySqlParameter[] parameters =
{
new MySqlParameter("@menuName", MySqlDbType.VarChar, 30),
new MySqlParameter("@menuIco", MySqlDbType.VarChar, 200),
new MySqlParameter("@menuUrl", MySqlDbType.VarChar, 200),
//new MySqlParameter("@mPID", MySqlDbType.Int32),
new MySqlParameter("@mSort", MySqlDbType.Int32),
new MySqlParameter("@mid", MySqlDbType.Int32)
};
parameters[0].Value = model.menuName;
parameters[1].Value = model.menuIco;
parameters[2].Value = model.menuUrl;
//parameters[3].Value = model.mPID;
parameters[3].Value = model.mSort;
parameters[4].Value = model.mid;
return(MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters));
}
public List <SysMenuModel> GetMenuList(SysMenuModel model)
{
List <SysMenuModel> List = new List <SysMenuModel>();
string[] strPara = new string[] { "@MenuID", "@ParentID", "@MenuName", "@MenuType", "@DeleteFlag", "@OUTTotalCount" };
ParameterMapper mapper = new ParameterMapper(strPara);
var ObjectModel = db.CreateSprocAccessor <SysMenuModel>("PROC_T_SYS_GetMenuList", mapper, MapBuilder <SysMenuModel> .MapNoProperties()
.Map(p => p.MenuID).ToColumn("MenuID")
.Map(p => p.ParentID).ToColumn("ParentID")
.Map(p => p.MenuName).ToColumn("MenuName")
.Map(p => p.MenuImg).ToColumn("MenuImg")
.Map(p => p.MenuType).ToColumn("MenuType")
.Map(p => p.NavigateUrl).ToColumn("NavigateUrl")
.Map(p => p.SortCode).ToColumn("SortCode")
.Map(p => p.DeleteFlag).ToColumn("DeleteFlag")
.Map(p => p.CreateDate).ToColumn("CreateDate")
.Map(p => p.RowNo).ToColumn("RowNo")
.Build()
);
object[] param = { model.MenuID, model.ParentID, model.MenuName, model.MenuType, model.DeleteFlag, model.OUTTotalCount };
List = ObjectModel.Execute(param).ToList <SysMenuModel>();
model.OUTTotalCount = int.Parse(mapper.GetParameterValue("@OUTTotalCount").ToString());
return(List);
}
/// <summary>
/// 增加菜单
/// </summary>
public int Add(SysMenuModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sysmenu(");
strSql.Append("menuName,menuIco,menuUrl,mPID,isDel,mSort)");
strSql.Append(" values (");
strSql.Append("@menuName,@menuIco,@menuUrl,@mPID,@isDel,@mSor)");
strSql.Append(";select @@IDENTITY");
MySqlParameter[] parameters =
{
new MySqlParameter("@menuName", MySqlDbType.VarChar, 30),
new MySqlParameter("@menuIco", MySqlDbType.VarChar, 200),
new MySqlParameter("@menuUrl", MySqlDbType.VarChar, 200),
new MySqlParameter("@mPID", MySqlDbType.Int32, 10),
new MySqlParameter("@isDel", MySqlDbType.Bit),
new MySqlParameter("@mSor", MySqlDbType.Int32, 10)
};
parameters[0].Value = model.menuName;
parameters[1].Value = model.menuIco;
parameters[2].Value = model.menuUrl;
parameters[3].Value = model.mPID;
parameters[4].Value = model.isDel;
parameters[5].Value = model.mSort;
return(MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters));
}
public ActionResult SaveMenuInfo(SysMenuModel model)
{
var resultMode = new ResponseBaseModel <dynamic>
{
ResultCode = ResponceCodeEnum.Success,
Message = "响应成功"
};
var menuServer = new MenuService();
if (model != null && model.Id > 0)
{
var tempModel = menuServer.GetMenuModel(model.Id);
if (tempModel == null)
{
resultMode.Message = "该菜单已经被删除";
resultMode.ResultCode = ResponceCodeEnum.Fail;
return(Json(resultMode, JsonRequestBehavior.AllowGet));
}
}
try
{
menuServer.SaveMenuModel(model);
return(Json(resultMode, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
resultMode.Message = "保存失败";
resultMode.ResultCode = ResponceCodeEnum.Fail;
resultMode.Data = e.Message;
return(Json(resultMode, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 查询菜单列表以及总数
/// </summary>
/// <param name="strcmd">查询条件</param>
/// <param name="rowcount">返回总数</param>
/// <returns></returns>
public List <SysMenuModel> GetMenuList(string strcmd, out int rowcount)
{
List <SysMenuModel> result = new List <SysMenuModel>();
DataTable menus = menu_dal.GetMenu(strcmd);
if (menus.Rows.Count == 0)
{
rowcount = 0;
return(result);
}
rowcount = menus.Rows.Count;
foreach (DataRow item in menus.Rows)
{
SysMenuModel tmp = new SysMenuModel();
tmp.mid = Convert.ToInt32(item["mid"]);
tmp.menuName = item["menuName"].ToString();
tmp.menuIco = item["menuIco"].ToString();
tmp.menuUrl = item["menuUrl"].ToString();
tmp.mPID = Convert.ToInt32(item["mPID"]);
tmp.isDel = Convert.ToBoolean(item["isDel"]);
tmp.mSort = Convert.ToInt32(item["mSort"]);
result.Add(tmp);
}
return(result);
}
/// <summary>
/// 保存菜单信息
/// </summary>
/// <param name="sysMenuModel"></param>
public void SaveMenuModel(SysMenuModel sysMenuModel)
{
if (sysMenuModel == null)
{
return;
}
new MenuData().SaveMenuModel(sysMenuModel);
}
public void Add(SysMenuModel entity)
{
using (var db = new HXContext())
{
db.SysMenu.Add(entity);
db.SaveChanges();
}
}
public void Save(SysMenuModel entity)
{
using (var db = new HXContext())
{
db.Entry <SysMenuModel>(entity).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void DateLoad()
{
SysMenuModel model = new SysMenuModel();
model.ParentID = "0";
List <SysMenuModel> MenuList = SMBll.GetMenuList(model);
TopMenu.DataSource = MenuList;
TopMenu.DataBind();
}
public void DataLoading()
{
SysMenuModel model = new SysMenuModel();
model.DeleteFlag = Convert.ToInt32(SysEnum.DeleteFlag.NotRemoved);
List <SysMenuModel> list = SMBLL.GetMenuList(model);
List <SysMenuModel> MList = list.Where(p => p.MenuType > 0).ToList();
List <SysMenuModel> BList = list.Where(p => p.MenuType == -1).ToList();
GetMenuTreeTable(MList, BList, "0", "node");
}
/// <summary>
/// 根据用户id获取角色菜单
/// </summary>
/// <returns></returns>
public List <SysMenuModel> GetRoleMenuByUserId(string userid)
{
List <SysMenuModel> result = new List <SysMenuModel>();
DataTable menus = menu_dal.GetRoleMenuByUserId(userid);
if (menus.Rows.Count == 0)
{
return(result);
}
foreach (DataRow item in menus.Rows)
{
var tmp = result.Find(m => m.mid == Convert.ToInt32(item["mPID"]));
if (tmp == null)
{
tmp = new SysMenuModel()
{
mid = Convert.ToInt32(item["mPID"]),
menuName = item["menuName_p"].ToString(),
menuIco = item["menuIco_p"].ToString()
};
tmp.cmList.Add(new SysMenuModel()
{
mid = Convert.ToInt32(item["mid"]),
menuName = item["menuName"].ToString(),
menuIco = item["menuIco"].ToString(),
menuUrl = item["menuUrl"].ToString(),
mPID = Convert.ToInt32(item["mPID"]),
isDel = Convert.ToBoolean(item["isDel"]),
mSort = Convert.ToInt32(item["mSort"]),
cmList = new List <SysMenuModel>()
});
result.Add(tmp);
}
else
{
tmp.cmList.Add(new SysMenuModel()
{
mid = Convert.ToInt32(item["mid"]),
menuName = item["menuName"].ToString(),
menuIco = item["menuIco"].ToString(),
menuUrl = item["menuUrl"].ToString(),
mPID = Convert.ToInt32(item["mPID"]),
isDel = Convert.ToBoolean(item["isDel"]),
mSort = Convert.ToInt32(item["mSort"]),
cmList = new List <SysMenuModel>()
});
}
}
return(result);
}
/// <summary>
/// 添加菜单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(SysMenuModel model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("INSERT INTO SYS_MENU");
sql.AppendLine(" (MENU_ID,");
sql.AppendLine(" MENU_CODE,");
sql.AppendLine(" MENU_NAME,");
sql.AppendLine(" MENU_PATH,");
sql.AppendLine(" MENU_ICON,");
sql.AppendLine(" MENU_SORT,");
sql.AppendLine(" MENU_DESC,");
sql.AppendLine(" MENU_TYPE,");
sql.AppendLine(" IS_ABLED,");
sql.AppendLine(" IS_END,");
sql.AppendLine(" PARENT_ID,");
sql.AppendLine(" CREATE_USER,");
sql.AppendLine(" LM_USER)");
sql.AppendLine("VALUES");
sql.AppendLine(" ($MENU_ID,");
sql.AppendLine(" $MENU_CODE,");
sql.AppendLine(" $MENU_NAME,");
sql.AppendLine(" $MENU_PATH,");
sql.AppendLine(" $MENU_ICON,");
sql.AppendLine(" $MENU_SORT,");
sql.AppendLine(" $MENU_DESC,");
sql.AppendLine(" $MENU_TYPE,");
sql.AppendLine(" $IS_ABLED,");
sql.AppendLine(" $IS_END,");
sql.AppendLine(" $PARENT_ID,");
sql.AppendLine(" $CREATE_USER,");
sql.AppendLine(" $LM_USER)");
SQLParameter[] parms =
{
new SQLParameter("MENU_ID", typeof(string), model.MENU_ID),
new SQLParameter("MENU_CODE", typeof(string), model.MENU_CODE),
new SQLParameter("MENU_NAME", typeof(string), model.MENU_NAME),
new SQLParameter("MENU_PATH", typeof(string), model.MENU_PATH),
new SQLParameter("MENU_ICON", typeof(string), model.MENU_ICON),
new SQLParameter("MENU_SORT", typeof(string), model.MENU_SORT),
new SQLParameter("MENU_DESC", typeof(string), model.MENU_DESC),
new SQLParameter("MENU_TYPE", typeof(string), model.MENU_TYPE),
new SQLParameter("IS_ABLED", typeof(int), model.IS_ABLED),
new SQLParameter("IS_END", typeof(int), model.IS_END),
new SQLParameter("PARENT_ID", typeof(string), model.PARENT_ID),
new SQLParameter("CREATE_USER", typeof(string), model.CREATE_USER),
new SQLParameter("LM_USER", typeof(string), model.LM_USER)
};
int result = DB.CustomExecuteWithReturn(new SQLParamCondition(sql.ToString(), parms));
return(result);
}
//添加菜单
public ResponseData AddMenu(SysMenuViewModel smvm)
{
ResponseData rd = new ResponseData();
//验证用户权限（只有管理员才能添加菜单）
bool bRet = new UserService().IsAdmin(smvm.Account, smvm.Token);
if (!bRet)
{
rd.Success = false;
rd.Message = "该用户没有添加菜单的权限";
return(rd);
}
//验证菜单编号和菜单名称是否重合
var mm = _sm.FindByName(smvm.Name, smvm.Token);
if (mm != null)
{
rd.Success = false;
rd.Message = "此菜单已添加";
return(rd);
}
try
{
SysMenuModel smm = new SysMenuModel()
{
Id = Guid.NewGuid().ToString("N"),
Name = smvm.Name,
MenuType = (MenuTypes)smvm.MenuType,
Icon = smvm.Icon,
Url = smvm.Url,
Token = smvm.Token,
Remarks = smvm.Remarks
};
if (smvm.ParentId == "" || null == smvm.ParentId)
{
smm.ParentId = null;
}
else
{
smm.ParentId = smvm.ParentId;
}
_sm.Add(smm);
rd.Success = true;
rd.Message = "添加菜单成功";
}
catch (Exception ex)
{
rd.Success = false;
rd.Message = "添加菜单失败" + ex.Message;
}
return(rd);
}
public int MenuAction(SysMenuModel model, SysEnum.ActionType actionType)
{
DbCommand cmd = db.GetStoredProcCommand("PROC_T_SYS_MenuEdit");
db.AddInParameter(cmd, "@Type", DbType.Int32, Convert.ToInt32(actionType));
db.AddInParameter(cmd, "@MenuID", DbType.Guid, model.MenuID);
db.AddInParameter(cmd, "@ParentID", DbType.String, model.ParentID);
db.AddInParameter(cmd, "@MenuName", DbType.String, model.MenuName);
db.AddInParameter(cmd, "@MenuImg", DbType.String, model.MenuImg);
db.AddInParameter(cmd, "@MenuType", DbType.Int32, model.MenuType);
db.AddInParameter(cmd, "@NavigateUrl", DbType.String, model.NavigateUrl);
db.AddInParameter(cmd, "@DeleteFlag", DbType.Int32, model.DeleteFlag);
db.AddInParameter(cmd, "@SortCode", DbType.Int32, model.SortCode);
int i = db.ExecuteNonQuery(cmd);
return(i);
}
protected void Save_Click(object sender, EventArgs e)
{
SysMenuModel model = new SysMenuModel();
model.ParentID = this.ParentID.Value.Trim();
model.MenuName = this.MenuName.Value.Trim();
model.MenuImg = this.MenuImg.Value.Trim();
model.MenuType = TypeConversion.StringToInt(this.MenuType.Value.Trim());
model.NavigateUrl = this.NavigateUrl.Value.Trim();
model.SortCode = TypeConversion.StringToInt(this.SortCode.Value.Trim());
model.DeleteFlag = 0;
model.CreateDate = new DateTime();
if (model.IsVolid())
{
if (MID == "")
{
model.MenuID = Guid.NewGuid();
int i = SMBll.MenuAction(model, Common.NetEnum.SysEnum.ActionType.ADD);
if (i > 0)
{
ControlAction.CloseWindow(this.Page, "添加成功！", 2500, SysEnum.MsgType.SUCCESS);
}
else
{
ControlAction.CloseWindow(this.Page, "添加失败！", 2500, SysEnum.MsgType.ERROR);
}
}
else
{
model.MenuID = new Guid(MID);
int i = SMBll.MenuAction(model, Common.NetEnum.SysEnum.ActionType.UPDATE);
if (i > 0)
{
ControlAction.CloseWindow(this.Page, "修改成功！", 2500, SysEnum.MsgType.SUCCESS);
}
else
{
ControlAction.CloseWindow(this.Page, "修改失败！", 2500, SysEnum.MsgType.ERROR);
}
}
}
else
{
ShowMsgHelper.ShowScript("showWarningMsg('" + model.ValidateTag.ToString() + "');");
}
}
/// <summary>
/// 修改菜单
/// </summary>
/// <param name="menuId"></param>
/// <param name="menuName"></param>
/// <param name="parentId"></param>
/// <param name="code"></param>
/// <param name="link"></param>
/// <param name="icon"></param>
/// <param name="sort"></param>
/// <param name="type"></param>
/// <param name="desc"></param>
/// <param name="isable"></param>
/// <param name="isend"></param>
/// <returns></returns>
public JsonMessage Edit(string menuId, string menuName, string parentId, string code, string link, string icon, int sort, string type, string desc, bool isable, bool isend)
{
JsonMessage jsonMsg = new JsonMessage(); //返回Json
int result = -1; //类型(成功 、失败)
try
{
DataTable dt = _menuRep.GetById(menuId);
if (ValidateHelper.IsDataTableNotData(dt))
{
throw new CustomException(0, "菜单不存在，刷新后尝试");
}
SysMenuModel model = new SysMenuModel();
model.MENU_ID = menuId;
model.MENU_NAME = menuName;
model.PARENT_ID = parentId;
model.MENU_CODE = code;
model.MENU_PATH = link;
model.MENU_ICON = icon;
model.MENU_SORT = sort;
model.MENU_TYPE = type;
model.MENU_DESC = desc;
model.IS_ABLED = isable ? 1 : 0;
model.IS_END = isend ? 1 : 0;
model.CREATE_USER = UserID;
model.LM_USER = UserID;
result = _menuRep.Edit(model);
jsonMsg = ServiceResult.Message(1, "菜单修改成功");
}
catch (CustomException ex)
{
jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message);
}
catch (Exception ex)
{
jsonMsg = ServiceResult.Message(-1, ex.Message);
WriteSystemException(ex, this.GetType(), OPT_MODEL, menuId + ":修改系统菜单失败");
}
//写入log
WriteSystemLog(jsonMsg, UPDATE, OPT_MODEL, menuId + ":修改系统菜单");
return(jsonMsg);
}
/// <summary>
/// 保存菜单信息
/// </summary>
/// <param name="sysMenuModel"></param>
public void SaveMenuModel(SysMenuModel sysMenuModel)
{
if (sysMenuModel == null)
{
return;
}
using (var conn = SqlConnectionHelper.GetOpenConnection())
{
if (sysMenuModel.Id > 0)
{
conn.Update(sysMenuModel);
}
else
{
conn.Insert(sysMenuModel);
}
}
}
public async Task <ActionResult> Save(SysMenuModel model)
{
var result = new JsonModel();
if (!ModelState.IsValid)
{
result.GetError(ModelState);
return(Json(result));
}
SysMenu menu = null;
var operationType = OperationType.Insert;
if (model.Id > 0)
{
operationType = OperationType.Update;
menu = await SysMenuRepository.GetByIdAsync(model.Id);
if (menu == null)
{
result.statusCode = 300;
result.message = "该条数据不存在，请刷新重试！";
return(Json(result));
}
}
else
{
menu = new SysMenu();
}
menu = Mapper.Map(model, menu);
if (!string.IsNullOrEmpty(menu.Url))
{
menu.Url = menu.Url.Trim().ToLower();
}
menu.CommonStatus = CommonStatus.Enabled;
await SysMenuRepository.SaveAsync(menu);
await LogRepository.Insert(TableSource.SysMenus, operationType, "", menu.Id);
menu.IndexOfParent = await SysMenuRepository.GetIndexOfParent(menu);
result.Data = menu;
result.message = "保存成功！";
return(Json(result));
}
public ReplayBase EditSysMenu(SysMenuModel SysMenu)
{
SysManagerService sms = new SysManagerService();
sms.SysMenu = SysMenu;
ReplayBase result = sms.SaveMenu();
if (result.ReturnCode == EnumErrorCode.Success)
{
SysUserLogModel log = new SysUserLogModel()
{
Describe = "添加/编辑菜单:" + SysMenu.Name,
SysUserId = User.Identity.Name
};
SysManagerService.CreateSysUserLog(log);
}
return(result);
}
public ActionResult Save(SysMenuModel model)
{
try
{
if (model.Id == model.Pid)
{
return(ToJsonErrorResult(1, "父级菜单不能设置成自己"));
}
#region 赋值实体
var entity = new SystemMenuDto
{
Id = model.Id,
Pid = model.Pid,
Name = model.Name,
UrlAddress = model.UrlAddress,
AddressAuth = model.AddressAuth,
NavbarId = model.NavbarId,
MenuType = model.MenuType,
Icon = "fa fa-navicon",//model.Icon,
Sort = model.Sort,
Remark = model.Remark
};
#endregion
var response = _systemMenuService.SaveSystemMenu(new SaveSystemMenuRequest
{
Entity = entity
});
if (!response.IsSuccess)
{
return(ToJsonErrorResult(1, response.MessageText));
}
return(ToJsonResult(new { status = 0 }));
}
catch (Exception ex)
{
LogManager.DefaultLogger.ErrorFormat("保存系统菜单出错：{0}", new { err = ex.ToString() }.ToJson());
return(ToJsonFatalResult("系统出错！"));
}
}
public async Task <IHttpActionResult> Update([FromBody] SysMenuModel menu)
{
return(await ResultFactory.Create(ModelState, async arg =>
{
var result = await sysMenuService.UpdateAsync(new SysMenuDto
{
Description = menu.Description,
Icon = menu.Icon,
Name = menu.Name,
Necessary = menu.Necessary,
ParentSerialnum = menu.ParentSerialnum,
SysFunctionSerialnum = menu.SysFunctionSerialnum,
Visiable = menu.Visiable,
UpdateTime = DateTime.Now
});
return new ApiResult(result ? ExceptionCode.Success : ExceptionCode.InternalError, "",
null);
}, menu, "success", "请检查请求参数"));
}
public ActionResult Save(SysMenuModel model)
{
var result = new JsonModel();
SysMenu menu = null;
var opType = OperationType.Insert;
if (model.Id > 0)
{
opType = OperationType.Update;
menu = SysMenuRepository.Get(model.Id);
if (menu == null)
{
result.msg = "找不到记录！";
return(Json(result));
}
}
else
{
menu = new SysMenu();
}
Mapper.Map(model, menu);
if (model.ButtonArray != null)
{
foreach (var btn in model.ButtonArray)
{
menu.Buttons = menu.Buttons | btn;
}
}
else
{
menu.Buttons = SysButton.None;
}
SysMenuRepository.Save(menu);
LogRepository.Insert(TableSource.SysMenu, opType, menu.Id);
result.data = menu;
result.code = JsonModelCode.Succ;
result.msg = "保存成功！";
return(Json(result));
}
/// <summary>
/// 增加菜单
/// </summary>
private string AddMenu(HttpContext context)
{
//================必填=====================
string mpid = context.Request.Params["mpid"];
string menuname = context.Request.Params["menuname"];
string menuico = context.Request.Params["menuico"];
string menuurl = context.Request.Params["menuurl"];
string msort = context.Request.Params["msort"];
SysMenuModel model = new SysMenuModel();
//model.mid = int.Parse(mid);
model.menuName = menuname;
model.menuIco = menuico;
model.menuUrl = menuurl;
model.mSort = int.Parse(msort);
model.mPID = int.Parse(mpid);
model.isDel = false;
var jr = new JsonResultModel <int>()
{
IsSucceed = false,
Data = 0,
Msg = "增加菜单失败",
RedirectUrl = string.Empty
};
if (!string.IsNullOrEmpty(menuname))
{
SysMenuBLL menu_bll = new SysMenuBLL();
if (menu_bll.Add(model) > 0)
{
jr.IsSucceed = true;
jr.Msg = "增加菜单[" + menuname + "]成功";
//jr.Data = int.Parse(mid);
}
}
return(JsonConvert.SerializeObject(jr));
}
public void DataLoad(string MID)
{
SysMenuModel MModel = new SysMenuModel();
MModel.ParentID = MID;
MModel.DeleteFlag = Convert.ToInt32(SysEnum.DeleteFlag.NotRemoved);
MModel.MenuType = Convert.ToInt32(SysEnum.MenuType.Button);
List <SysMenuModel> MList = SMBll.GetMenuList(MModel);
RpSelectButtonList.DataSource = MList;
RpSelectButtonList.DataBind();
SysButtonModel BModel = new SysButtonModel();
BModel.DeleteFlag = Convert.ToInt32(SysEnum.DeleteFlag.NotRemoved);
BModel.PageIndex = 1;
BModel.PageSize = 10000;
List <SysButtonModel> BList = SBBLL.GetButtonList(BModel);
RpAllButtonList.DataSource = BList;
RpAllButtonList.DataBind();
}
/// <summary>
/// 修改菜单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Edit(SysMenuModel model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE SYS_MENU");
sql.AppendLine(" SET MENU_CODE = $MENU_CODE,");
sql.AppendLine(" MENU_NAME = $MENU_NAME,");
sql.AppendLine(" MENU_PATH = $MENU_PATH,");
sql.AppendLine(" MENU_ICON = $MENU_ICON,");
sql.AppendLine(" MENU_SORT = $MENU_SORT,");
sql.AppendLine(" MENU_DESC = $MENU_DESC,");
sql.AppendLine(" MENU_TYPE = $MENU_TYPE,");
sql.AppendLine(" IS_ABLED = $IS_ABLED,");
sql.AppendLine(" IS_END = $IS_END,");
sql.AppendLine(" PARENT_ID = $PARENT_ID,");
sql.AppendLine(" LM_TIME = GETDATE(),");
sql.AppendLine(" LM_USER = $LM_USER");
sql.AppendLine(" WHERE MENU_ID = $MENU_ID");
SQLParameter[] parms =
{
new SQLParameter("MENU_CODE", typeof(string), model.MENU_CODE),
new SQLParameter("MENU_NAME", typeof(string), model.MENU_NAME),
new SQLParameter("MENU_PATH", typeof(string), model.MENU_PATH),
new SQLParameter("MENU_ICON", typeof(string), model.MENU_ICON),
new SQLParameter("MENU_SORT", typeof(string), model.MENU_SORT),
new SQLParameter("MENU_DESC", typeof(string), model.MENU_DESC),
new SQLParameter("MENU_TYPE", typeof(string), model.MENU_TYPE),
new SQLParameter("IS_ABLED", typeof(int), model.IS_ABLED),
new SQLParameter("IS_END", typeof(int), model.IS_END),
new SQLParameter("PARENT_ID", typeof(string), model.PARENT_ID),
new SQLParameter("LM_USER", typeof(string), model.LM_USER),
new SQLParameter("MENU_ID", typeof(string), model.MENU_ID),
};
int result = DB.CustomExecuteWithReturn(new SQLParamCondition(sql.ToString(), parms));
return(result);
}
private void GetUserChildrenMenu(SysMenuModel etmModel, IList <SysMenuEntity> listpartmenu, string MenuCode)
{
var children = listpartmenu.Where(w => w.Parentcode == MenuCode);
if (children != null && children.Count() > 0)
{
etmModel.children = new List <SysMenuModel>();
foreach (var item in children)
{
SysMenuModel etm = new SysMenuModel();
etm.id = item.Id.Value;
etm.text = item.Menuname;
etm.iconCls = item.Menuicon;
etm.attributes = new AttributesModel
{
iframe = "1",
datalink = item.Menuurl
};
GetUserChildrenMenu(etm, listpartmenu, item.Menucode);
etmModel.children.Add(etm);
}
}
}
/// <summary>
/// 增加菜单
/// </summary>
public int Add(SysMenuModel model)
{
return(menu_dal.Add(model));
}
