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