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