public int AddTreeNode(int id) { //api/Syspart/AddTreeNode/0 TbSysPart tmpNode = new TbSysPart(); tmpNode.IParentId = id;//此处的id为parentid tmpNode.SPartName = "新增结点"; if (id != 0) { //非一级节点,先读取父结点 TbSysPart parentNode = SyspartDAO.GetByID(id); if (parentNode != null) { tmpNode.ILevel = parentNode.ILevel + 1; } else { return -1; //Request.CreateResponse(HttpStatusCode.BadRequest, "出错了,找不到新建 Syspart 的 父结点:"+id+"!!"); } } else { //一级节点 tmpNode.ILevel = 1; } SyspartDAO.Insert(tmpNode); int tempId = tmpNode.Id;//新增节点的ID return tempId; }
/// <summary> /// 通过对象删除记录 /// </summary> /// <param name="item"></param> /// <returns></returns> public bool Del( TbSysPart item) { bool res = false; using (var connection = DataBase.GetOpenConnection()) { res = connection.Delete< TbSysPart>(item); } return res; }
/// <summary> /// 通过ID删除记录 /// </summary> /// <param name="id">需要删除的对象的ID</param> /// <returns></returns> public bool Del(int id) { bool res = false; TbSysPart item = new TbSysPart(); using (var connection = DataBase.GetOpenConnection()) { item = GetByID(id); res = connection.Delete<TbSysPart>(item); } return res; }
/// <summary> /// 插入一个对象 /// </summary> /// <param name="item">需要插入的对象</param> /// <returns></returns> public int Insert(TbSysPart item) { int id = 0; using (var connection = DataBase.GetOpenConnection()) { id = (int)connection.Insert<TbSysPart>(item); } return id; }
/// <summary> /// PUT api/Syspart/Put/5,更新数据 /// </summary> public int Put(int id, TbSysPart item) { if (id != item.Id) { //数据无效 return -1; } try { SyspartDAO.Update(item); // MyCache.ClearBranchStore(); } catch (Exception ex) { //更新数据失败 return -2; } //更新成功 return 1; }
/// <summary> /// POST api/Syspart/Post ///新增item数据, /// </summary> /// <param name="item">item,新增数据</param> public int Post(TbSysPart item) { if (ModelState.IsValid) { SyspartDAO.Insert(item); // MyCache.ClearBranchStore(); return 1;//新增数据成功 } else { //数据验证失败 return 0; } }