/// <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);
}
