/// <summary>
/// 添加节点，知道父节点的名称
/// </summary>
/// <param name="model">节点实体</param>
/// <param name="name">父节点名称</param>
/// <returns>添加结果</returns>
public CustomResult Add(DAL.OT_Dic model, string name)
{
model.Name = model.Name.Trim();//去除空格
using (TransactionScope transaction = new TransactionScope())
{
List <DictionaryViewModel> info = GetList(name);//获取根节点信息
CustomResult pReturnValue = new CustomResult();
if (info != null && info.Count > 0)
{
//检查同一级别的节点中是否已经存在了该节点的名称
var id = db.OT_Dic.Where(a => a.Belong == info[0].DictId & a.Name == model.Name).ToList().Select(a => new
{
a.Id
}).ToList();
if (id != null && id.Count > 0)
{
pReturnValue.ResultKey = (byte)ENodeAddResult.Exist;
pReturnValue.ResultValue = Wttech.DataSubmitted.Common.Resources.TipInfo.Exist;
}
else
{
//添加节点
db.OT_Dic.Add(model);
if (db.SaveChanges() > 0)
{
transaction.Complete();
pReturnValue.ResultKey = (byte)ENodeAddResult.Succeed;
pReturnValue.ResultValue = Wttech.DataSubmitted.Common.Resources.TipInfo.Success;
}
else
{
pReturnValue.ResultKey = (byte)ENodeAddResult.Fail;
pReturnValue.ResultValue = Wttech.DataSubmitted.Common.Resources.TipInfo.Failed;
}
}
}
else
{
pReturnValue.ResultKey = (byte)ENodeAddResult.Inexist;
pReturnValue.ResultValue = Wttech.DataSubmitted.Common.Resources.TipInfo.Inexist;
}
return(pReturnValue);
}
}
/// <summary>
/// 修改节点
/// </summary>
/// <param name="model">数据字典实体</param>
/// <returns>影响行数</returns>
public CustomResult Update(DAL.OT_Dic model)
{
model.Name = model.Name.Trim();//去除空格
using (TransactionScope transaction = new TransactionScope())
{
CustomResult pReturnValue = new CustomResult();
//检查同一级别的节点中是否已经存在了该节点的名称
var id = db.OT_Dic.Where(a => a.Belong == model.Belong & a.Name == model.Name & a.Id != model.Id).ToList();
if (id != null && id.Count > 0)
{
pReturnValue.ResultKey = (byte)ENodeAddResult.Exist;
pReturnValue.ResultValue = Wttech.DataSubmitted.Common.Resources.TipInfo.Exist;
return(pReturnValue);
}
else
{
var list = db.OT_Dic.Where(a => a.Id == model.Id).ToList();
foreach (OT_Dic info in list)
{
if (!string.IsNullOrEmpty(model.Name))
{
info.Name = model.Name;
}
if (model.Rank != null)
{
info.Rank = model.Rank;
}
if (!string.IsNullOrEmpty(model.Rek))
{
info.Rek = model.Rek;
}
if (model.IsDelete != null)
{
info.IsDelete = model.IsDelete;
}
}
return(Result.SaveUpdateResult(db, transaction));
}
}
}
/// <summary>
/// 添加节点，知道节点的父标识，根节点的父标识是0
/// </summary>
/// <param name="model">数据字典实体</param>
/// <returns>是否添加成功</returns>
public byte Create(DAL.OT_Dic model)
{
model.Name = model.Name.Trim();
using (TransactionScope transaction = new TransactionScope())
{
//检查同一级别的节点中是否已经存在了该节点的名称
var id = db.OT_Dic.Where(a => a.Belong == model.Belong & a.Name == model.Name).ToList().Select(a => new
{
a.Id
}).ToList();
if (id != null && id.Count > 0)
{
return((byte)ENodeAddResult.Exist);
}
else
{
//添加节点
db.OT_Dic.Add(model);
return(Result.SaveChangesResult(db, transaction).ResultKey);
}
}
}
