/// <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> /// 根据userID获取有权限的功能点 /// </summary> /// <param name="userID">用户ID</param> /// <param name="isMenu">是否为菜单</param> /// <returns></returns> public List <RoleFunction> GetAuthorizedList(string userID) { using (DbContext db = new CRDatabase()) { if (string.IsNullOrEmpty(userID)) { return(new List <RoleFunction>()); } var roleIDList = db.Set <CTMS_SYS_USERROLE>() .AsNoTracking() .Where(o => !o.ISDELETED && o.USERID.Equals(userID)) .Select(o => o.ROLEID) .ToList(); return(db.Set <CTMS_SYS_ROLEFUNCTION>() .AsNoTracking() .Where(o => !o.ISDELETED && roleIDList.Contains(o.ROLEID)) .Select(EntityToModel) .ToList()); } }
/// <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 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 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> /// 新增我的产品 /// </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 string Add(GuideLine model) { if (model == null) { return(string.Empty); } using (DbContext db = new CRDatabase()) { model.ID = Guid.NewGuid().ToString(); db.Set <CTMS_GUIDELINE>().Add(ModelToEntity(model)); if (model.MetaDataList != null && model.MetaDataList.Count > 0) { foreach (GuideLineData data in model.MetaDataList) { data.GuideLineID = model.ID; db.Set <CTMS_GUIDELINEDATA>().Add(new GuideLineDataBLL().ModelToEntity(data)); } } db.SaveChanges(); return(model.ID); } }
/// <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> /// 根据用户ID,功能编码和权限类型 获取角色功能权限实体 /// </summary> /// <param name="userID">用户ID</param> /// <param name="authCode">权限编码</param> /// <param name="permission">权限类型</param> /// <returns></returns> public List <RoleFunction> GetAuthorizedList(string userID, string authCode, PermissionType permission) { List <RoleFunction> roleFunctionList = new List <RoleFunction>(); if (string.IsNullOrEmpty(authCode) || string.IsNullOrEmpty(authCode)) { return(roleFunctionList); } using (DbContext db = new CRDatabase()) { var function = db.Set <CTMS_SYS_FUNCTION>().AsNoTracking().Where(o => o.FUNCTIONCODE.Equals(authCode)).ToList(); if (function == null || function.Count() == 0) { return(roleFunctionList); } string functionid = function[0].FUNCTIONID; var roleIDList = db.Set <CTMS_SYS_USERROLE>() .AsNoTracking() .Where(o => !o.ISDELETED && o.USERID.Equals(userID)) .Select(o => o.ROLEID) .ToList(); roleFunctionList = db.Set <CTMS_SYS_ROLEFUNCTION>() .AsNoTracking() .Where ( o => !o.ISDELETED && roleIDList.Contains(o.ROLEID) && o.FUNCTIONID.Equals(functionid) && o.PERMISSIONVALUE == (int)permission ) .Select(EntityToModel) .ToList(); return(roleFunctionList); } }
/// <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> /// 根据ID获取咨询 /// </summary> /// <param name="keyWord"></param> /// <returns></returns> public MyQuestion Get(string id) { using (DbContext db = new CRDatabase()) { if (string.IsNullOrEmpty(id)) { return(null); } CTMS_MYQUESTION entity = db.Set <CTMS_MYQUESTION>().Find(id); if (entity == null) { return(null); } return(EntityToModel(entity)); } }
/// <summary> /// 根据ID获取我的产品 /// </summary> /// <param name="keyWord"></param> /// <returns></returns> public MyProduct Get(string id) { using (DbContext db = new CRDatabase()) { if (string.IsNullOrEmpty(id)) { return(null); } CTMS_MYPRODUCT entity = db.Set <CTMS_MYPRODUCT>().Find(id); if (entity == null) { return(null); } return(EntityToModel(entity)); } }
/// <summary> /// 根据ID获取管家 /// </summary> /// <param name="keyWord"></param> /// <returns></returns> public MyHouseKeeper Get(string id) { using (DbContext db = new CRDatabase()) { if (string.IsNullOrEmpty(id)) { return(null); } CTMS_MYHOUSEKEEPER entity = db.Set <CTMS_MYHOUSEKEEPER>().Find(id); if (entity == null) { return(null); } return(EntityToModel(entity)); } }
/// <summary> /// 根据ID获取账单 /// </summary> /// <param name="keyWord"></param> /// <returns></returns> public AccountRecord Get(string id) { using (DbContext db = new CRDatabase()) { if (string.IsNullOrEmpty(id)) { return(null); } CTMS_ACCOUNTRECORD entity = db.Set <CTMS_ACCOUNTRECORD>().Find(id); if (entity == null) { return(null); } return(EntityToModel(entity)); } }
/// <summary> /// 根据ID获取用户基因信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public UserGene Get(string id) { if (string.IsNullOrEmpty(id)) { LogService.WriteInfoLog(logTitle, "试图查找ID为空的UserGene实体!"); return(null); } using (DbContext db = new CRDatabase()) { HR_USERGENE entity = db.Set <HR_USERGENE>().Find(id); if (entity == null) { return(null); } return(EntityToModel(entity)); } }
/// <summary> /// 添加用户基因 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(UserGene model) { if (model == null) { return(string.Empty); } if (string.IsNullOrEmpty(model.ID)) { model.ID = Guid.NewGuid().ToString(); } using (DbContext db = new CRDatabase()) { db.Set <HR_USERGENE>().Add(ModelToEntity(model)); db.SaveChanges(); return(model.ID); } }
/// <summary> /// 获取查询列表 /// </summary> /// <param name="keyWord"></param> /// <returns></returns> public List <MyQuestion> GetList(string keyWord, string userID = "") { using (DbContext db = new CRDatabase()) { var query = db.Set <CTMS_MYQUESTION>().AsNoTracking().Where(o => !o.ISDELETED); if (!string.IsNullOrEmpty(userID)) { query = query.Where(o => o.USERID.Equals(userID)); } if (!string.IsNullOrEmpty(keyWord)) { query = query.Where(o => o.QUESTION.Contains(keyWord)); } List <MyQuestion> list = query.ToList().Select(EntityToModel).ToList(); return(list); } }
/// <summary> /// 添加用户基因 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(DrugAllele model) { if (model == null) { return(string.Empty); } if (string.IsNullOrEmpty(model.ID)) { model.ID = Guid.NewGuid().ToString(); } using (DbContext db = new CRDatabase()) { db.Set <GN_DRUGALLELE>().Add(ModelToEntity(model)); db.SaveChanges(); return(model.ID); } }
/// <summary> /// 根据ID获取用户基因信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public DrugAllele Get(string id) { if (string.IsNullOrEmpty(id)) { LogService.WriteInfoLog(logTitle, "试图查找ID为空的DrugAllele实体!"); return(null); } using (DbContext db = new CRDatabase()) { GN_DRUGALLELE entity = db.Set <GN_DRUGALLELE>().Find(id); if (entity == null) { return(null); } return(EntityToModel(entity)); } }
public string Add(UserApply model) { if (model == null) { return(string.Empty); } if (string.IsNullOrEmpty(model.ID)) { model.ID = Guid.NewGuid().ToString(); } using (var context = new CRDatabase()) { context.Set <CTMS_USERAPPLY>().Add(ModelToEntity(model)); context.SaveChanges(); return(model.ID); } }
/// <summary> /// 检查该手机是否已经被使用 /// </summary> /// <param name="phone"></param> /// <returns></returns> public BaseResult CheckUserPhoneExists(string phone) { using (var context = new CRDatabase()) { BaseResult br = new BaseResult() { Succeeded = true, Error = "" }; var list = context.Set <CTMS_SYS_USERINFO>().Where(p => p.MOBILEPHONE == phone).ToList(); if (list.Any()) { br.Succeeded = false; br.Error = "该手机已被注册"; } return(br); } }
/// <summary> /// 获取查询列表 /// </summary> /// <param name="keyWord"></param> /// <returns></returns> public List <MenuInfo> GetList() { using (DbContext db = new CRDatabase()) { var query = db.Set <CTMS_SYS_FUNCTION>().AsNoTracking() .Where(o => o.ISMENU && !o.ISDELETED && string.IsNullOrEmpty(o.PARENTID)) .OrderBy(m => m.SORT).ToList(); List <MenuInfo> list = new List <MenuInfo>(); foreach (CTMS_SYS_FUNCTION entity in query) { MenuInfo model = EntityToModel(entity); model.ChildrenList = GetChildrenList(model.ID); list.Add(model); } return(list); } }
/// <summary> /// 根据用户ID获取基因 /// </summary> /// <param name="userID"></param> /// <returns></returns> public List <DrugAllele> GetList(string drugBankID) { List <DrugAllele> list = new List <DrugAllele>(); if (string.IsNullOrEmpty(drugBankID)) { return(list); } using (DbContext db = new CRDatabase()) { var entityList = db.Set <GN_DRUGALLELE>().AsNoTracking().Where(o => o.DRUGBANKID.Equals(drugBankID)); foreach (GN_DRUGALLELE entity in entityList) { DrugAllele DrugAllele = EntityToModel(entity); list.Add(DrugAllele); } } return(list); }
/// <summary> /// 获取查询列表 /// </summary> /// <param name="keyWord"></param> /// <returns></returns> public List <AccountRecord> GetList(string userID, DateTime startDate, DateTime endDate) { using (DbContext db = new CRDatabase()) { DateTime date = endDate.Date.AddDays(1); return(db.Set <CTMS_ACCOUNTRECORD>() .AsNoTracking() .Where ( o => !o.ISDELETED && o.USERID.Equals(userID) && o.CREATEDATETIME >= startDate.Date && o.CREATEDATETIME < date ) .OrderByDescending(o => o.CREATEDATETIME) .Select(EntityToModel) .ToList()); } }
public List <MemberModel> GetMemberList() { using (var context = new CRDatabase()) { return (context.Set <CTMS_MEMBER>() .AsNoTracking() .OrderBy(o => o.MEMBERLEVEL) .ToList() .Select((p) => new MemberModel() { MEMBERID = p.MEMBERID, MEMBERNAME = p.MEMBERNAME, MEMBERLEVEL = p.MEMBERLEVEL, MEMBERPRICE = p.MEMBERPRICE, MEMBERUNIT = p.MEMBERUNIT, MEMBERDESCRIPT = p.MEMBERDESCRIPT, }).ToList()); } }
public bool DeleteTemplate(string id) { if (string.IsNullOrEmpty(id)) { return(false); } using (CRDatabase _context = new CRDatabase()) { var entity = _context.Set <HR_EXAMINETEMPLATE>().Find(id); if (entity != null) { entity.ISDELETED = "1"; //_context.Set<HR_EXAMINETEMPLATE>().Remove(entity); //_context.HR_TEMPLATEITEM.Where(p => p.TEMPLATEID == id) // .ToList() // .ForEach(k => _context.HR_TEMPLATEITEM.Remove(k)); } return(_context.SaveChanges() > 0); } }
/// <summary> /// 根据用户ID获取基因 /// </summary> /// <param name="userID"></param> /// <returns></returns> public List <UserGene> GetList(string userID) { List <UserGene> list = new List <UserGene>(); if (string.IsNullOrEmpty(userID)) { return(list); } using (DbContext db = new CRDatabase()) { var entityList = db.Set <HR_USERGENE>().AsNoTracking().Where(o => o.USERID.Equals(userID)); foreach (HR_USERGENE entity in entityList) { UserGene userGene = EntityToModel(entity); userGene.GeneModel = string.IsNullOrEmpty(entity.GENEID) ? null : new GeneService().Get(entity.GENEID); userGene.Allele1Model = string.IsNullOrEmpty(entity.ALLELE1ID) ? null : new GeneAlleleService().Get(entity.ALLELE1ID); userGene.Allele2Model = string.IsNullOrEmpty(entity.ALLELE2ID) ? null : new GeneAlleleService().Get(entity.ALLELE2ID); list.Add(userGene); } } return(list); }
/// <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="permissionValue">加总后的权限值</param> /// <returns></returns> public List <Permission> GetListByValue(int permissionValue) { if (permissionValue <= 0) { return(new List <Permission>()); } using (DbContext db = new CRDatabase()) { Char[] permissionArray = Convert.ToString(permissionValue, 2).ToCharArray(); Array.Reverse(permissionArray); List <int> permissionValueList = new List <int>(); for (int i = 0; i < permissionArray.Length; i++) { if (permissionArray[i] == '0') { continue; } permissionValueList.Add((int)Math.Pow(2, i)); } IEnumerable <CTMS_SYS_PERMISSION> query = db.Set <CTMS_SYS_PERMISSION>().AsNoTracking().Where(o => !o.ISDELETED && permissionValueList.Contains(o.PERMISSIONVALUE)).ToList(); List <Permission> list = (from m in query select EntityToModel(m)).ToList(); return(list); } }
/// <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); } }