/// <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 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); } }
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 Edit(GuideLine model) { if (string.IsNullOrEmpty(model.ID)) { LogService.WriteInfoLog(logTitle, "试图修改为空的GuideLine实体!"); throw new KeyNotFoundException(); } using (DbContext db = new CRDatabase()) { db.Entry(ModelToEntity(model)).State = EntityState.Modified; foreach (GuideLineData data in model.MetaDataList) { db.Entry(new GuideLineDataBLL().ModelToEntity(data)).State = EntityState.Modified; } return(db.SaveChanges() > 0); } }
/// <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 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 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 bool Edit(MyQuestion model, string eventID = "") { if (string.IsNullOrEmpty(model.ID)) { LogService.WriteInfoLog(logTitle, "试图修改为空的MyQuestion实体!"); throw new KeyNotFoundException(); } using (DbContext db = new CRDatabase()) { db.Entry(ModelToEntity(model)).State = EntityState.Modified; if (!string.IsNullOrEmpty(eventID)) { CTMS_USEREVENT userEvent = db.Set <CTMS_USEREVENT>().Find(eventID); if (userEvent != null) { userEvent.ACTIONSTATUS = "3"; userEvent.ENDTIME = model.EditTime; db.Entry(userEvent).State = EntityState.Modified; } } return(db.SaveChanges() > 0); } }
/// <summary> /// 保存就诊史录入 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool SaveSeeDoctoryHis(SeeDoctorHistory model) { if (model == null) { LogService.WriteInfoLog(logTitle, "试图查找为空的SeeDoctorHistory实体!"); return(false); } using (DbContext db = new CRDatabase()) { db.Entry(ModelToEntity(model)).State = EntityState.Modified; db.Set <HR_SEEDOCHISICD>() .Where(p => p.HISTORYID == model.HISTORYID) .ForEachAsync(k => db.Set <HR_SEEDOCHISICD>().Remove((k))); model.ICDList.ForEach(p => db.Set <HR_SEEDOCHISICD>().Add(EntityToModel(p))); return(db.SaveChanges() > 0); } }
/// <summary> /// 更新模板配置 /// </summary> /// <param name="etModel"></param> /// <returns></returns> public bool UpdateTemplate(ExamineTemplate etModel) { using (CRDatabase _context = new CRDatabase()) { if (etModel != null) { _context.Entry(ModelToEntity(etModel)).State = EntityState.Modified; //_context.HR_TEMPLATEITEM.Where(p => p.TEMPLATEID == etModel.TEMPLATEID) // .ToList() // .ForEach(k => _context.HR_TEMPLATEITEM.Remove(k)); //删除掉关联的项以及项的单位 foreach (var item in _context.HR_TEMPLATEITEM.Where(p => p.TEMPLATEID == etModel.TEMPLATEID).ToList()) { _context.HR_TEMPLATEITEMUNIT.Where(p => p.ITEMID == item.ITEMID) .ForEachAsync(k => _context.HR_TEMPLATEITEMUNIT.Remove(k)); _context.HR_TEMPLATEITEM.Remove(item); } //_context.Database.ExecuteSqlCommand("delete from Students where StudentId = @studentId", new SqlParameter("@studentId", 5)); //foreach (var templateItem in etModel.TemplateItems) //{ // templateItem.TEMPLATEID = etModel.TEMPLATEID; // templateItem.ITEMID = Guid.NewGuid().ToString(); // //_context.HR_TEMPLATEITEM.Add(ModelToEntity(templateItem)); //} foreach (var item in etModel.TemplateItems ?? new List <HR_TemplateItemDTO>()) { item.TEMPLATEID = etModel.TEMPLATEID; _context.Set <HR_TEMPLATEITEM>().Add(ModelToEntity(item)); //3.添加项单位 foreach (var unitDto in item.ItemUnit ?? new List <HR_TemplateItemUnitDTO>()) { unitDto.ITEMID = item.ITEMID; _context.Set <HR_TEMPLATEITEMUNIT>().Add(ModelToEntity(unitDto)); } } } return(_context.SaveChanges() > 0); } }
/// <summary> /// 购买会员 /// </summary> /// <param name="userID"></param> /// <param name="MemberID"></param> /// <returns></returns> public bool BuyMember(string userID, string memberID) { using (DbContext db = new CRDatabase()) { DateTime now = DateTime.Now; DateTime startDate = now.Date; DateTime endDate = now.Date.AddYears(1).AddDays(-1); UserInfo userInfo = new UserInfoService().GetUserInfoByID(userID); MemberModel buyMember = new MemberBLL().GetMember(memberID); if (userInfo == null || buyMember == null) { throw new Exception("错误的用户ID或会员ID"); } //判断余额 if (userInfo.Account < buyMember.MEMBERPRICE.Value) { throw new Exception("余额不足,购买失败!"); } //判断会员等级 if (userInfo.Member.MEMBERLEVEL.Value >= buyMember.MEMBERLEVEL) { throw new Exception("不能购买相同或更低级别的会员!"); } //1.扣钱+升级会员 CTMS_SYS_USERINFO user = db.Set <CTMS_SYS_USERINFO>().Find(userID); user.ACCOUNT -= buyMember.MEMBERPRICE.Value; user.MEMBERID = buyMember.MEMBERID; user.MEMBERSTARTDATE = startDate; user.MEMBERENDDATE = endDate; db.Entry(user).State = EntityState.Modified; //2.添加商品 List <string> productDescList = new List <string>(); foreach (MemberProducts memberProduct in buyMember.menberProductList) { if (!memberProduct.PRODUCTNUMBER.HasValue || Convert.ToInt32(memberProduct.PRODUCTNUMBER.Value) <= 0) { continue; } for (int i = 0; i < Convert.ToInt32(memberProduct.PRODUCTNUMBER.Value); i++) { db.Set <CTMS_MYPRODUCT>().Add(new CTMS_MYPRODUCT() { CREATEDATETIME = now, CREATEUSERID = userInfo.UserId, CREATEUSERNAME = userInfo.LoginName, ENDDATE = endDate, ID = Guid.NewGuid().ToString(), LOGINNAME = userInfo.LoginName, PRODUCTID = memberProduct.PRODUCTID, PRODUCTNUM = 1, STARTDATE = startDate, USERID = userInfo.UserId }); } var product = db.Set <CTMS_PRODUCTS>().Find(memberProduct.PRODUCTID); if (product != null) { productDescList.Add(string.Format("{0}*{1}", product.PRODUCTNAME, Convert.ToInt32(memberProduct.PRODUCTNUMBER.Value))); } } //3.提示记录 db.Set <CTMS_ACCOUNTRECORD>().Add(new CTMS_ACCOUNTRECORD() { ACCOUNT = buyMember.MEMBERPRICE.Value, ACCOUNTDESCRIPTION = string.Format("购买{0}", buyMember.MEMBERNAME), BALANCE = -1, CREATEDATETIME = now, CREATEUSERID = userInfo.UserId, CREATEUSERNAME = userInfo.LoginName, ID = Guid.NewGuid().ToString(), LOGINNAME = userInfo.LoginName, PRODUCTID = "", PRODUCTNAME = string.Format("{0}(包含商品/服务:{1})", buyMember.MEMBERNAME, string.Join(",", productDescList)), //PRODUCTNAME = string.Format("{0}", buyMember.MEMBERNAME), SPENDTYPE = (int)SpendType.Buy, USERID = userInfo.UserId, }); return(db.SaveChanges() > 0); } }
/// <summary> /// 根据ID获取我的产品 /// </summary> /// <param name="keyWord"></param> /// <returns></returns> public bool BuyProduct(string userID, string ProductID) { using (DbContext db = new CRDatabase()) { DateTime now = DateTime.Now; if (string.IsNullOrEmpty(userID) || string.IsNullOrEmpty(ProductID)) { throw new Exception("用户ID或产品ID为空,购买失败!"); } CTMS_SYS_USERINFO user = db.Set <CTMS_SYS_USERINFO>().Find(userID); CTMS_PRODUCTS product = db.Set <CTMS_PRODUCTS>().Find(ProductID); if (user == null || product == null) { throw new Exception("错误的用户ID或产品ID"); } if (product.SALEPRICE > user.ACCOUNT) { throw new Exception("余额不足!"); } //用户表 decimal salePrice = product.SALEPRICE.HasValue ? product.SALEPRICE.Value : 0; user.ACCOUNT -= salePrice; db.Entry(user).State = EntityState.Modified; //记录表 CTMS_ACCOUNTRECORD accountRecord = new CTMS_ACCOUNTRECORD() { ID = Guid.NewGuid().ToString(), USERID = user.USERID, ACCOUNT = salePrice, ACCOUNTDESCRIPTION = string.Format("购买{0}", product.PRODUCTNAME), BALANCE = -1, LOGINNAME = user.LOGINNAME, ORDERID = "", PRODUCTID = product.PRODUCTID, PRODUCTNAME = product.PRODUCTNAME, SPENDTYPE = (int)SpendType.Buy, CREATEDATETIME = now, CREATEUSERID = user.USERID, CREATEUSERNAME = user.LOGINNAME }; db.Set <CTMS_ACCOUNTRECORD>().Add(accountRecord); //我的产品表 CTMS_MYPRODUCT myProduct = new CTMS_MYPRODUCT() { ID = Guid.NewGuid().ToString(), USERID = user.USERID, LOGINNAME = user.LOGINNAME, PRODUCTID = product.PRODUCTID, PRODUCTNUM = 1, STARTDATE = DateTime.Now.Date, ENDDATE = DateTime.Now.Date.AddYears(1).AddDays(-1), CREATEUSERID = user.USERID, CREATEUSERNAME = user.LOGINNAME, CREATEDATETIME = now, }; db.Set <CTMS_MYPRODUCT>().Add(myProduct); return(db.SaveChanges() > 0); } }