public ResponseNodeDelete NodeDelete(RequestNodeDelete request) { ResponseNodeDelete response = new ResponseNodeDelete(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = UserInfoGetButAccount(request.Token, ts); var users = cnn.Query("select 1 from tks_fas_user2Node where nodeId=@NodeId", new { NodeId = request.Data.Id }, ts); if (users.Count() > 0) { throw new NormalException("机构下存在用户,禁止删除"); } cnn.Execute("delete from tks_fas_Node where id=@Id", request.Data, ts); //cnn.Execute("delete from tks_fas_user2Node where Nodeid=@NodeId", // new { NodeId = request.Data.Id }, ts); ts.Commit(); response.IsSuccess = true; response.Message = "删除成功"; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseNodeDelete); } } }
public ResponseNodeDelete NodeDelete([FromBody] RequestNodeDelete request) { try { NodeBLL bll = new NodeBLL(); return(bll.NodeDelete(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }