/// <summary>
/// 根据对象实体数据新增一条组织机构节点合并记录
/// </summary>
/// <param name="org">组织节点合并对象</param>
/// <returns>JsonResult</returns>
public JsonResult AddOrgMerger(SYS_OrgMerger org)
{
const string action = "DAE7F2C5-E379-4F74-8043-EB616D4A5F8B";
var verify = new SessionVerify();
if (!verify.Compare(action))
{
return(verify.Result);
}
return(InsertData(verify.Basis.UserId, org) ? verify.Result : verify.Result.DataBaseError());
}
/// <summary>
/// 根据对象实体数据新增一条组织机构节点合并记录
/// </summary>
/// <param name="uid"></param>
/// <param name="obj">组织节点合并对象</param>
/// <returns>bool 是否成功</returns>
private bool InsertData(Guid uid, SYS_OrgMerger obj)
{
var sql = "insert into SYS_OrgMerger ([OrgId], [MergerOrgId], [CreatorUserId]) ";
sql += "select @OrgId, @MergerOrgId, @CreatorUserId ";
sql += "select ID From SYS_OrgMerger where SN = SCOPE_IDENTITY()";
var parm = new[]
{
new SqlParameter("@OrgId", SqlDbType.UniqueIdentifier)
{
Value = obj.OrgId
},
new SqlParameter("@MergerOrgId", SqlDbType.UniqueIdentifier)
{
Value = obj.MergerOrgId
},
new SqlParameter("@CreatorUserId", SqlDbType.UniqueIdentifier)
{
Value = uid
}
};
return(SqlNonQuery(MakeCommand(sql, parm)) > 0);
}
