/// <summary> /// 添加菜单 /// </summary> /// <param name="request"></param> /// <param name="loginInfo"></param> /// <returns></returns> public ServiceResult <bool> AddMenu(AddMenuRequest request, TRightsUser loginInfo) { var result = new ServiceResult <bool> { ReturnCode = ReturnCodeType.Error }; var currentTime = DateTime.Now; var menu = new TRightsMenu { Name = request.Name, ParentId = request.ParentId, Code = request.Code, Url = request.Url, Icon = request.Icon, Sort = request.Sort, CreatedBy = loginInfo.Id, CreatedTime = currentTime, LastUpdatedBy = loginInfo.Id, LastUpdatedTime = currentTime }; var rs = _menuDao.Insert(menu); if (rs == true) { result.ReturnCode = ReturnCodeType.Success; result.Content = true; } return(result); }
/// <summary> /// 插入 /// </summary> /// <param name="item">待插入的记录</param> public bool Insert(TRightsMenu item) { using (var conn = DapperHelper.CreateConnection()) { var effectedRows = conn.Execute(@"INSERT INTO dbo.t_rights_menu VALUES ( @Name ,@ParentId ,@Code ,@Url ,@Icon ,@Sort ,@CreatedBy ,@CreatedTime ,@LastUpdatedBy ,@LastUpdatedTime);", item); if (effectedRows > 0) { return(true); } } return(false); }
/// <summary> /// 更新 /// </summary> /// <param name="item">待更新的记录</param> /// <returns></returns> public bool Update(TRightsMenu item) { using (var conn = DapperHelper.CreateConnection()) { var effectedRows = conn.Execute(@"UPDATE dbo.t_rights_menu SET name=@Name, url= @Url, icon= @Icon, sort=@Sort, last_updated_by= @LastUpdatedBy, last_updated_time= @LastUpdatedTime WHERE id= @Id;", item); if (effectedRows > 0) { return(true); } } return(false); }
/// <summary> /// 依id查询 /// </summary> /// <param name="id">id</param> /// <returns></returns> public TRightsMenu GetById(int id) { var result = new TRightsMenu(); using (var conn = DapperHelper.CreateConnection()) { result = conn.Query <TRightsMenu>(@"SELECT menu.parent_id AS ParentId, menu.created_by AS CreatedBy, menu.created_time AS CreatedTime, menu.last_updated_by AS LastUpdatedBy, menu.last_updated_time AS LastUpdatedTime, * FROM dbo.t_rights_menu AS menu WHERE menu.id= @Id;", new { @Id = id }).FirstOrDefault(); } return(result); }