/// <summary> /// 依标识码查询按钮,不存在返回NULL /// </summary> /// <param name="buttonCode"></param> /// <returns></returns> public TRightsButton GetButtonByCode(string buttonCode) { TRightsButton result = null; using (var conn = DapperHelper.CreateConnection()) { result = conn.Query <TRightsButton>(@"SELECT * FROM dbo.t_rights_button WHERE code= @Code;", new { @Code = buttonCode }).FirstOrDefault(); } return(result); }
/// <summary> /// 更新 /// </summary> /// <param name="item">待更新的记录</param> /// <returns></returns> public bool Update(TRightsButton item) { using (var conn = DapperHelper.CreateConnection()) { var effectedRows = conn.Execute(@"UPDATE dbo.t_rights_button SET name=@Name, icon= @Icon, sort=@Sort, last_updated_by= @LastUpdatedBy, last_updated_time= @LastUpdatedTime WHERE id= @Id;", item); if (effectedRows > 0) { return(true); } } return(false); }
/// <summary> /// 插入 /// </summary> /// <param name="item">待插入的记录</param> public bool Insert(TRightsButton item) { using (var conn = DapperHelper.CreateConnection()) { var effectedRows = conn.Execute(@"INSERT INTO dbo.t_rights_button VALUES (@Name ,@Code ,@Icon ,@Sort ,@CreatedBy ,@CreatedTime ,@LastUpdatedBy ,@LastUpdatedTime);", item); if (effectedRows > 0) { return(true); } } return(false); }
/// <summary> /// 新增按钮 /// </summary> /// <param name="request"></param> /// <returns></returns> public ServiceResult <bool> AddButton(AddButtonRequest request, TRightsUser loginInfo) { //校验按钮名称和标识码 var result = new ServiceResult <bool> { ReturnCode = ReturnCodeType.Error }; var buttonByName = _btnDao.GetButtonByName(request.Name); if (buttonByName != null) { result.Message = "已存在相同名称的按钮!"; return(result); } var buttonByCode = _btnDao.GetButtonByCode(request.Code); if (buttonByCode != null) { result.Message = "已存在相同标识码的按钮!"; return(result); } var currentTime = DateTime.Now; var btn = new TRightsButton { Name = request.Name, Code = request.Code, Icon = request.Icon, Sort = request.Sort, CreatedBy = loginInfo.Id, CreatedTime = currentTime, LastUpdatedBy = loginInfo.Id, LastUpdatedTime = currentTime }; var rs = _btnDao.Insert(btn); if (rs == true) { result.ReturnCode = ReturnCodeType.Success; result.Content = true; } return(result); }
/// <summary> /// 依id查询 /// </summary> /// <param name="id">id</param> /// <returns></returns> public TRightsButton GetById(int id) { var result = new TRightsButton(); using (var conn = DapperHelper.CreateConnection()) { result = conn.Query <TRightsButton>(@"SELECT btn.created_by AS CreatedBy , btn.created_time AS CreatedTime , btn.last_updated_by AS LastUpdatedBy , btn.last_updated_time AS LastUpdatedTime , * FROM dbo.t_rights_button AS btn WHERE btn.id = @Id;", new { @Id = id }).FirstOrDefault(); } return(result); }