public static bool Delete(string id, out string msg) { bool state = true; msg = string.Empty; Database db = ValueSetEntity.DefaultDB; db.BeginTransaction(); try { ValueSetEntity entity = ValueSetEntity.GetSingle(id); if (entity.SetId == 0) { string sql = "delete npi_valueSet where SetId=" + entity.Id; db.Execute(sql); } db.Delete(entity); db.CompleteTransaction(); LogService.WriteLog(LogTypeEnum.操作日志, "值集设置", "删除值集:" + entity.Text + "(" + entity.Id + ")"); } catch (Exception e) { state = false; msg = e.Message; db.AbortTransaction(); } return(state); }
public static ValueSetEntity SaveValueSet(string valueSetJson, out bool state, out string msg) { state = false; msg = string.Empty; ValueSetEntity entity = new ValueSetEntity(); try { entity = Serializer.ToObject <ValueSetEntity>(valueSetJson); string log = string.Empty; if (ValueSetEntity.DefaultDB.IsNew(entity)) { state = entity.Save(out msg); log = "设置值集:" + entity.Text + "(" + entity.Id + ")"; } else { ValueSetEntity oldEntity = ValueSetEntity.GetSingle(entity.Id); List <string> changeList = new List <string>(); if (oldEntity.Value != entity.Value) { changeList.Add("值从 " + oldEntity.Value + " 修改为 " + entity.Value); } if (oldEntity.Text != entity.Text) { changeList.Add("文本从 " + oldEntity.Text + " 修改为 " + entity.Text); } if (oldEntity.SortId != entity.SortId) { changeList.Add("排序从 " + oldEntity.SortId + " 修改为 " + entity.SortId); } if (oldEntity.IsEnable != entity.IsEnable) { changeList.Add("启用状态从 " + (oldEntity.IsEnable ? "是" : "否") + " 修改为 " + (entity.IsEnable ? "是" : "否")); } if (oldEntity.IsDefault != entity.IsDefault) { changeList.Add("默认状态从 " + (oldEntity.IsDefault ? "是" : "否") + " 修改为 " + (entity.IsDefault ? "是" : "否")); } if (oldEntity.Extra != entity.Extra) { changeList.Add("扩展信息从 " + oldEntity.Extra + " 修改为 " + entity.Extra); } if (changeList.Count != 0) { log = "设置值集:" + entity.Text + "(" + entity.Id + "):" + string.Join(";", changeList); } state = entity.Save(out msg); } LogService.WriteLog(LogTypeEnum.操作日志, "值集设置", log); } catch (Exception e) { msg = e.Message; } return(entity); }