/// <summary>
/// 插入
/// </summary>
/// <param name="item">待插入的记录</param>
public bool Insert(TRightsOrganization item)
{
using (var conn = DapperHelper.CreateConnection())
{
var effectRows = conn.Execute(@"INSERT INTO dbo.t_rights_organization VALUES ( @OrgName ,@ParentId ,@Code ,@OrganizationType ,@Sort ,@EnableFlag ,@CreatedBy ,@CreatedTime ,@LastUpdatedBy ,@LastUpdatedTime);",
new
{
@OrgName = item.Name,
@ParentId = item.ParentId,
@Code = item.Code,
@OrganizationType = item.OrganizationType,
@Sort = item.Sort,
@EnableFlag = item.EnableFlag,
@CreatedBy = item.CreatedBy,
@CreatedTime = item.CreatedTime,
@LastUpdatedBy = item.LastUpdatedBy,
@LastUpdatedTime = item.LastUpdatedTime
});
if (effectRows > 0)
{
return(true);
}
}
return(false);
}
/// <summary>
/// 新增机构
/// </summary>
/// <param name="request">request</param>
/// <returns></returns>
public ServiceResult <bool> AddOrganization(AddOrganizationRequest request, TRightsUser loginInfo)
{
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var currentTime = DateTime.Now;
var item = new TRightsOrganization
{
Name = request.Name,
ParentId = request.ParentId,
Code = request.Code,
Sort = request.Sort,
EnableFlag = true,
CreatedBy = loginInfo.Id,
CreatedTime = currentTime,
LastUpdatedBy = loginInfo.Id,
LastUpdatedTime = currentTime
};
var rs = orgDao.Insert(item);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="item">待更新的记录</param>
/// <returns></returns>
public bool Update(TRightsOrganization item)
{
var result = false;
using (var conn = DapperHelper.CreateConnection())
{
var effectRows = conn.Execute(@"UPDATE dbo.t_rights_organization SET name= @OrgName, parent_id= @ParentId, sort= @Sort, last_updated_by= @LastUpdatedBy, last_updated_time= @LastUpdatedTime WHERE id= @Id;",
new { @Id = item.Id, @OrgName = item.Name, @ParentId = item.ParentId, @Sort = item.Sort, @LastUpdatedBy = item.LastUpdatedBy, @LastUpdatedTime = item.LastUpdatedTime });
if (effectRows > 0)
{
result = true;
}
}
return(result);
}
/// <summary>
/// 依id查询
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
public TRightsOrganization GetById(int id)
{
TRightsOrganization result = null;
using (var conn = DapperHelper.CreateConnection())
{
var query = conn.Query <TRightsOrganization>(@"SELECT org.id AS Id, org.name AS NAME, org.parent_id AS ParentId, org.code AS Code, org.organization_type AS OrganizationType,
org.sort AS Sort, org.enable_flag AS EnableFlag, org.created_by AS CreatedBy, org.created_time AS CreatedTime,
org.last_updated_by AS LastUpdatedBy, org.last_updated_time AS LastUpdatedTime
FROM dbo.t_rights_organization AS org
WHERE org.id= @Id", new { @Id = id });
result = query.FirstOrDefault();
}
return(result);
}
/// <summary>
/// 更新机构
/// </summary>
/// <param name="item">待更新的记录</param>
/// <returns></returns>
public ServiceResult <bool> Update(TRightsOrganization item)
{
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var rs = orgDao.Update(item);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
