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