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