/// <summary> /// 添加用药情况 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddDrugUse(DrugUse model) { context.CR_DRUGUSE.Add(ModelToEntity(model)); if (model.InterEffect.Any()) { foreach (var drugEffect2 in model.InterEffect) { var item = ModelToEntity(drugEffect2); item.DISEASEID = model.DISEASEID; item.DRUGID = model.DRUGID; context.CR_DRUGEFFECT.Add(item); } } if (model.GeneEffect.Any()) { foreach (var drugGeneInfo in model.GeneEffect) { var item = ModelToEntity(drugGeneInfo); item.DISEASEID = model.DISEASEID; item.DRUGID = model.DRUGID; context.CR_GENEEFFECT.Add(item); } } return(context.SaveChanges() > 0); }
/// <summary> /// 新增账单 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(AccountRecord model) { if (model == null) { return(string.Empty); } if (string.IsNullOrEmpty(model.AccountDescription)) { model.AccountDescription = string.Format("{0}{1}", model.SpendTypeText, model.ProductName); } using (DbContext db = new CRDatabase()) { CTMS_SYS_USERINFO user = db.Set <CTMS_SYS_USERINFO>().Find(model.UserID); if (model.Balance == -1 && model.Account > user.ACCOUNT) { throw new Exception("余额不足!"); } user.ACCOUNT += model.Balance * model.Account; db.Entry(user).State = EntityState.Modified; //Todo 对应服务次数加1 db.Set <CTMS_ACCOUNTRECORD>().Add(ModelToEntity(model)); db.SaveChanges(); return(model.ID); } }
/// <summary> /// 添加值设置 /// </summary> /// <param name="model"></param> /// <returns></returns> public BaseResult AddItemStandVal(ItemStandVal model) { BaseResult br = new BaseResult() { Succeeded = true }; using (CRDatabase _context = new CRDatabase()) { bool flag = !_context.HR_ITEMSTANDVAL.Any(p => p.ITEMNO == model.ITEMNO && p.ISDELETED == "0"); if (flag) { try { _context.HR_ITEMSTANDVAL.Add(ModelToEntity(model)); _context.SaveChanges(); } catch (Exception e) { br.Succeeded = false; br.Error = e.Message.ToString(); throw; } } else { br.Succeeded = false; br.Error = "该项已添加标准值返回,请检查"; } } return(br); }
/// <summary> /// 更新GuideLineFlow /// </summary> /// <param name="model"></param> /// <returns></returns> public bool EditGuideLineFlow(GuideLineFlow model) { using (CRDatabase _context = new CRDatabase()) { var entity = _context.CTMS_GUIDELINEFLOW.FirstOrDefault(p => p.ID == model.ID); if (entity != null) { //1.将原先流程状态设置成删除 entity.ISDELETED = true; GuideLineFlow addModel = new GuideLineFlow(); addModel.ID = Guid.NewGuid().ToString(); addModel.GUIDELINENAME = entity.GUIDELINENAME; addModel.GUIDELINEINFO = model.GUIDELINEINFO; addModel.CreateUserID = model.CreateUserID; addModel.CreateDateTime = model.CreateDateTime; addModel.EditTime = model.EditTime; addModel.EditUserID = model.EditUserID; addModel.IsDeleted = false; addModel.OwnerID = model.OwnerID; _context.CTMS_GUIDELINEFLOW.Add(ModelToEntity(addModel)); return(_context.SaveChanges() > 0); } return(false); } }
/// <summary> /// 新增咨询 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(MyQuestion model) { if (model == null) { return(string.Empty); } using (DbContext db = new CRDatabase()) { db.Set <CTMS_MYQUESTION>().Add(ModelToEntity(model)); //待办 db.Set <CTMS_USEREVENT>().Add(new CTMS_USEREVENT() { EVENTID = Guid.NewGuid().ToString(), USERAPPLYID = "", ACTIONTYPE = "1", ACTIONINFO = string.Format("您收到了{0}的咨询,请回复", model.LoginName), RECEIPTTIME = model.CreateDateTime, ACTIONSTATUS = "1", FROMUSER = model.UserID, TOUSER = model.ObjectUserID, CREATETIME = model.CreateDateTime, MODELID = model.ID, LINKURL = "MyQuestion" }); db.SaveChanges(); return(model.ID); } }
/// <summary> /// 更新会员 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateMemberList(MemberModel model) { using (var context = new CRDatabase()) { var entity = context.CTMS_MEMBER.FirstOrDefault(p => p.MEMBERID == model.MEMBERID); if (entity != null) { //1.更新主表字段 entity.MEMBERNAME = model.MEMBERNAME; entity.MEMBERDESCRIPT = model.MEMBERDESCRIPT; entity.MEMBERLEVEL = model.MEMBERLEVEL; entity.MEMBERPRICE = model.MEMBERPRICE; //2.删除原先服务 context.CTMS_MEMBERPRODUCTS.Where(p => p.MEMBERID == model.MEMBERID).ToList().ForEach(k => context.CTMS_MEMBERPRODUCTS.Remove(k)); //3.新增服务 foreach (var item in model.menberProductList) { item.MEMBERID = model.MEMBERID; context.CTMS_MEMBERPRODUCTS.Add(ModelToEntity(item)); } } return(context.SaveChanges() > 0); } }
public BaseResult DeleteItemStandVal(string id) { BaseResult br = new BaseResult() { Succeeded = true }; using (CRDatabase _context = new CRDatabase()) { var entity = _context.HR_ITEMSTANDVAL.FirstOrDefault(p => p.ID == id); if (entity != null) { entity.ISDELETED = "1"; try { _context.Entry(entity).State = EntityState.Modified; _context.SaveChanges(); } catch (Exception e) { br.Succeeded = false; br.Error = e.Message.ToString(); } } } return(br); }
/// <summary> /// 更新值设置 /// </summary> /// <param name="model"></param> /// <returns></returns> public BaseResult UpdateItemStandVal(ItemStandVal model) { BaseResult br = new BaseResult() { Succeeded = true }; try { using (CRDatabase _context = new CRDatabase()) { var entity = _context.HR_ITEMSTANDVAL.FirstOrDefault(p => p.ID == model.ID); if (entity != null) { entity.NAMEENG = model.NAMEENG; entity.EDITDATETIME = model.EDITDATETIME; entity.EDITUSERID = model.EDITUSERID; entity.MINVALUE = model.MINVALUE; entity.ITEMMAXVALUE = model.MAXVALUE; entity.UNIT = model.UNIT; _context.Entry(entity).State = EntityState.Modified; _context.SaveChanges(); //_context.Entry(ModelToEntity(model)).State = EntityState.Modified; //_context.SaveChanges(); } } } catch (Exception e) { br.Succeeded = false; br.Error = e.Message.ToString(); } return(br); }
/// <summary> /// 修改用户角色 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateUserRole(string userid, List <Role> roleList) { if (string.IsNullOrEmpty(userid) || roleList == null) { LogService.WriteInfoLog(logTitle, "用户ID或实体列表为空!"); return(false); } using (DbContext db = new CRDatabase()) { List <CTMS_SYS_USERROLE> preUserRoleList = db.Set <CTMS_SYS_USERROLE>().Where(o => !o.ISDELETED && o.USERID.Equals(userid)).ToList(); List <string> preRoleIDList = preUserRoleList.Select(p => p.ROLEID).ToList(); List <string> afterRoleIDList = roleList.Select(o => o.RoleID).ToList(); foreach (CTMS_SYS_USERROLE entity in preUserRoleList) { entity.ISDELETED = (preUserRoleList.Find(o => afterRoleIDList.Contains(entity.ROLEID)) == null); db.Entry(entity).State = EntityState.Modified; } foreach (string roleID in afterRoleIDList.Where(o => !preRoleIDList.Contains(o))) { db.Set <CTMS_SYS_USERROLE>().Add(new CTMS_SYS_USERROLE() { USERROLEID = Guid.NewGuid().ToString(), ROLEID = roleID, USERID = userid }); } return(db.SaveChanges() > 0); } }
/// <summary> /// 添加GuideLineFlow /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddGuideLineFlow(GuideLineFlow model) { using (CRDatabase _context = new CRDatabase()) { _context.CTMS_GUIDELINEFLOW.Add(ModelToEntity(model)); return(_context.SaveChanges() > 0); } }
/// <summary> /// 添加用户待办信息 /// </summary> public void AddUserEvent(UserEvent model) { using (var context = new CRDatabase()) { context.CTMS_USEREVENT.Add(ModelToEntity(model)); context.SaveChanges(); } }
/// <summary> /// 删除角色功能权限 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool DeleteById(string id) { using (DbContext db = new CRDatabase()) { var entity = db.Set <CTMS_SYS_ROLEFUNCTION>().Find(id); if (entity != null) { db.Set <CTMS_SYS_ROLEFUNCTION>().Remove(entity); } return(db.SaveChanges() > 0); } }
/// <summary> /// 新增元数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(ConditionItem model) { if (model == null) { return(0); } using (DbContext db = new CRDatabase()) { db.Set <CTMS_CONDITIONITEM>().Add(ModelToEntity(model)); db.SaveChanges(); return(model.ID); } }
/// <summary> /// 修改菜单 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Edit(MenuInfo model) { if (string.IsNullOrEmpty(model.ID)) { LogService.WriteInfoLog("访问MenuInfoBLL类", "试图修改为空的Function实体!"); throw new KeyNotFoundException(); } using (DbContext db = new CRDatabase()) { db.Entry(ModelToEntity(model)).State = EntityState.Modified; return(db.SaveChanges() > 0); } }
/// <summary> /// 新增我的产品 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(MyProduct model) { if (model == null) { return(string.Empty); } using (DbContext db = new CRDatabase()) { db.Set <CTMS_MYPRODUCT>().Add(ModelToEntity(model)); db.SaveChanges(); return(model.ID); } }
/// <summary> /// 编辑用户基因 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Edit(UserGene model) { if (model == null) { LogService.WriteInfoLog(logTitle, "试图修改为空的UserGene实体!"); return(false); } using (DbContext db = new CRDatabase()) { db.Entry(ModelToEntity(model)).State = EntityState.Modified; return(db.SaveChanges() > 0); } }
/// <summary> /// 新增随访方案 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(QATestSolution model) { if (model == null) { return(string.Empty); } using (DbContext db = new CRDatabase()) { db.Set <CTMS_QA_TESTSOLUTION>().Add(ModelToEntity(model)); db.SaveChanges(); return(model.SolutionID); } }
/// <summary> /// 修改随访方案 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Edit(QATestSolution model) { if (string.IsNullOrEmpty(model.SolutionID)) { LogService.WriteInfoLog(logTitle, "试图修改为空的QATestSolution实体!"); throw new KeyNotFoundException(); } using (DbContext db = new CRDatabase()) { db.Entry(ModelToEntity(model)).State = EntityState.Modified; return(db.SaveChanges() > 0); } }
/// <summary> /// 修改元数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Edit(MetaData model) { if (model == null || model.ID <= 0) { LogService.WriteInfoLog(logTitle, "试图修改为空的MetaData实体!"); throw new KeyNotFoundException(); } using (DbContext db = new CRDatabase()) { db.Entry(ModelToEntity(model)).State = EntityState.Modified; return(db.SaveChanges() > 0); } }
/// <summary> /// 新增管家 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(MyHouseKeeper model) { if (model == null) { return(string.Empty); } using (DbContext db = new CRDatabase()) { db.Set <CTMS_MYHOUSEKEEPER>().Add(ModelToEntity(model)); db.SaveChanges(); return(model.ID); } }
/// <summary> /// 新增元数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(MetaData model) { if (model == null) { return(0); } using (DbContext db = new CRDatabase()) { db.Set <CTMS_METADATA>().Add(ModelToEntity(model)); db.SaveChanges(); return(model.ID); } }
/// <summary> /// 新增随访方案 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(QATestPaper model) { if (model == null) { return(string.Empty); } using (DbContext db = new CRDatabase()) { db.Set <CTMS_QA_TESTPAPER>().Add(ModelToEntity(model)); db.SaveChanges(); return(model.TestPaperID); } }
/// <summary> /// 保存父类parentid /// </summary> /// <param name="id"></param> /// <param name="parentList"></param> /// <returns></returns> public bool SaveParentGuideLine(string id, List <ParentGuideLine> parentList) { using (var context = new CRDatabase()) { context.CTMS_PARENTGUIDELINE.Where(p => p.GUIDELINEID == id) .ForEachAsync(k => context.CTMS_PARENTGUIDELINE.Remove(k)); parentList.ForEach(p => p.GuideLineId = id); parentList.ForEach(p => context.CTMS_PARENTGUIDELINE.Add(ModelToEntity(p))); return(context.SaveChanges() > 0); } }
/// <summary> /// 删除会员 /// </summary> /// <param name="memberId"></param> /// <returns></returns> public bool DeleteMember(string memberId) { using (var context = new CRDatabase()) { var entity = context.Set <CTMS_MEMBER>().Find(memberId); if (entity != null) { context.Set <CTMS_MEMBER>().Remove(entity); context.CTMS_MEMBERPRODUCTS.Where(p => p.MEMBERID == memberId).ToList().ForEach(k => context.CTMS_MEMBERPRODUCTS.Remove(k)); } return(context.SaveChanges() > 0); } }
public bool CloseApply(string applyId) { using (var context = new CRDatabase()) { var entity = context.CTMS_USERAPPLY.FirstOrDefault(p => p.ID == applyId); if (entity == null) { return(false); } entity.STATUS = "3"; return(context.SaveChanges() > 0); } }
/// <summary> /// 新增功能权限 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(FunctionPermission model) { if (model == null) { return(string.Empty); } using (DbContext db = new CRDatabase()) { model.FunctionPermissionID = Guid.NewGuid().ToString(); db.Set <CTMS_SYS_FUNCTIONPERMISSION>().Add(ModelToEntity(model)); db.SaveChanges(); return(model.FunctionPermissionID); } }
/// <summary> /// 将上面一条设置成已完成 /// </summary> /// <param name="eventId"></param> /// <returns>更新结果</returns> public bool CloseEvent(string eventId) { using (var context = new CRDatabase()) { var entity = context.CTMS_USEREVENT.FirstOrDefault(p => p.EVENTID == eventId); if (entity == null) { return(false); } entity.ACTIONSTATUS = ((int)ActionStatus.Complete).ToString(); entity.ENDTIME = System.DateTime.Now; return(context.SaveChanges() > 0); } }
/// <summary> /// 添加用户待办信息 /// </summary> public void AddUserEvent(UserEvent model, UserType userType) { using (var context = new CRDatabase()) { //1.根据UserTypetype找到人 var toUserId = context.CTMS_SYS_USERINFO.FirstOrDefault(p => p.USERTYPE == (decimal)userType); //2.将事件类型ActionInfo插入表中 model.ToUser = toUserId.USERID; context.CTMS_USEREVENT.Add(ModelToEntity(model)); context.SaveChanges(); } }
/// <summary> /// 新增角色 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(Role model) { if (model == null) { return(string.Empty); } using (DbContext db = new CRDatabase()) { model.RoleID = Guid.NewGuid().ToString(); db.Set <CTMS_SYS_ROLE>().Add(ModelToEntity(model)); db.SaveChanges(); return(model.RoleID); } }
/// <summary> /// 删除单个GuideLine对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool DeleteGuideLineFlow(string id) { if (string.IsNullOrEmpty(id)) { return(false); } using (CRDatabase _context = new CRDatabase()) { var entity = _context.CTMS_GUIDELINEFLOW.Find(id); if (entity != null) { _context.CTMS_GUIDELINEFLOW.Remove(entity); } return(_context.SaveChanges() > 0); } }