/// <summary>
/// 保存新增的导航菜单
/// </summary>
/// <param name="menuName">导航菜单名称</param>
/// <param name="menuType">菜单类型</param>
/// <param name="menuId">新闻菜单</param>
/// <param name="menuUrl">链接地址</param>
/// <param name="isUse">是否可用</param>
/// <param name="orderBy">排序</param>
/// Author : Napoleon
/// Created : 2015-06-09 15:37:10
public ActionResult SaveAdd(string menuName, string menuType, string menuId, string menuUrl, string isUse, decimal orderBy)
{
string status = "failue", msg = "新增失败!", json;
SystemNavMenu nav = new SystemNavMenu();
nav.Id = CustomId.GetCustomId();
nav.MenuName = menuName;
nav.MenuType = int.Parse(menuType);
nav.MenuId = menuId;
nav.MenuUrl = menuUrl;
nav.IsUse = int.Parse(isUse);
nav.OrderBy = orderBy;
nav.OperationTime = DateTime.Now;
int i = _navMenuService.InsertSystemNavMenu(nav);
switch (i)
{
case 1:
status = "success";
msg = "新增成功!";
break;
}
json = PublicFunc.ModelToJson(status, msg);
return(Content(json));
}
/// <summary>
/// 更新新闻菜单
/// </summary>
/// <param name="hiddenId">ID</param>
/// <param name="menuName">导航菜单名称</param>
/// <param name="menuType">菜单类型</param>
/// <param name="menuId">新闻菜单</param>
/// <param name="menuUrl">链接地址</param>
/// <param name="isUse">是否可用</param>
/// <param name="orderBy">排序</param>
/// Author : Napoleon
/// Created : 2015-06-09 15:37:10
public ActionResult UpdateEdit(string hiddenId, string menuName, string menuType, string menuId, string menuUrl, string isUse, decimal orderBy)
{
string status = "failue", msg = "更新失败!", json;
SystemNavMenu nav = new SystemNavMenu();
nav.Id = hiddenId;
nav.MenuName = menuName;
nav.MenuType = string.IsNullOrWhiteSpace(menuType) ? 0 : int.Parse(menuType);
nav.MenuId = menuId;
nav.MenuUrl = menuUrl;
nav.IsUse = int.Parse(isUse);
nav.OrderBy = orderBy;
nav.OperationTime = DateTime.Now;
int i = _navMenuService.UpdateSystemNavMenu(nav);
switch (i)
{
case 1:
status = "success";
msg = "更新成功!";
break;
}
json = PublicFunc.ModelToJson(status, msg);
return(Content(json));
}
/// <summary>
/// 更新数据
/// </summary>
/// Author :Napoleon
/// Created :2015-06-06 02:02:44
public int UpdateSystemNavMenu(SystemNavMenu model)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("update System_NavMenu set Id=@Id,MenuName=@MenuName,MenuType=@MenuType,MenuId=@MenuId,MenuUrl=@MenuUrl,IsUse=@IsUse,OperationTime=@OperationTime,OrderBy=@OrderBy where Id=@Id");
int i = DbHelper.ExecuteSql(sql.ToString(), model);
return(i);
}
/// <summary>
/// 新增数据
/// </summary>
/// Author :Napoleon
/// Created :2015-06-06 02:02:44
public int InsertSystemNavMenu(SystemNavMenu model)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("insert into System_NavMenu(Id,MenuName,MenuType,MenuId,MenuUrl,IsUse,OperationTime,OrderBy) values(@Id,@MenuName,@MenuType,@MenuId,@MenuUrl,@IsUse,@OperationTime,@OrderBy)");
int i = DbHelper.ExecuteSql(sql.ToString(), model);
return(i);
}
/// <summary>
/// 更新数据
/// </summary>
/// Author :Napoleon
/// Created :2015-06-06 02:02:44
public int UpdateSystemNavMenu(SystemNavMenu model)
{
return(_systemnavmenuDao.UpdateSystemNavMenu(model));
}
/// <summary>
/// 新增数据
/// </summary>
/// Author :Napoleon
/// Created :2015-06-06 02:02:44
public int InsertSystemNavMenu(SystemNavMenu model)
{
return(_systemnavmenuDao.InsertSystemNavMenu(model));
}
