/// <summary> /// 通过案例ID获取案例信息 /// </summary> /// <param name="Id"></param> /// <returns></returns> public RegisterInfo GetRegisterInfoById(string Id) { using (var db = new SRISContext()) { return(db.RegisterInfos.Find(Id)); } }
/// <summary> /// 通过案例类型ID获取案例类型 /// </summary> /// <param name="id">例类型ID</param> /// <returns></returns> public SRType GetSRTypeById(int id) { using (var db = new SRISContext()) { return(db.SRTypes.Where(n => n.SRTypeID == id).FirstOrDefault()); } }
/// <summary> /// 获取所有的案例类型 /// </summary> /// <returns></returns> public List <SRType> GetSRType() { using (var db = new SRISContext()) { List <SRType> SRTypeList = db.SRTypes.ToList(); return(SRTypeList); } }
/// <summary> /// 通过案例ID获取联系人信息 /// </summary> /// <param name="CaseId">案例ID</param> /// <returns></returns> public LinkMan GetLinManModelById(string CaseId) { using (var db = new SRISContext()) { LinkMan model = db.LinkMans.Where(n => n.RegisterInfoId == CaseId).FirstOrDefault(); return(model); } }
/// <summary> /// 通过用户名查询用户信息 /// </summary> /// <param name="userName">用户名</param> /// <returns></returns> public UserInfo GetUserInfoByUserName(string userName) { using (var db = new SRISContext()) { var userInfo = db.UserInfos.Where(n => n.UserName == userName).SingleOrDefault(); return(userInfo); } }
/// <summary> /// 注册 /// </summary> /// <param name="userInfo">用户信息实体类</param> /// <returns></returns> public int Register(UserInfo userInfo) { using (var db = new SRISContext()) { db.UserInfos.Add(userInfo); return(db.SaveChanges()); } }
/// <summary> /// 获取所有的登记案例的信息 /// </summary> /// <returns></returns> public List <RegisterInfo> GetAllCaseInfo(string userId) { using (var db = new SRISContext()) { var list = db.RegisterInfos .Where(n => n.UserInfo.UserInfoID == userId) .Include(t => t.SRType) .OrderByDescending(s => s.CreateDateTime) .ToList(); return(list); } }
/// <summary> /// 创建联系人信息 /// </summary> /// <param name="model">联系人信息实体类</param> /// <returns></returns> public bool CreateLinkMan(LinkMan model) { using (var db = new SRISContext()) { db.LinkMans.Add(model); if (db.SaveChanges() > 0) { return(true); } else { return(false); } } }
/// <summary> /// 修改案例信息 /// </summary> /// <param name="model">案例信息实体类</param> /// <returns></returns> public bool UpdateRegisterInfo(RegisterInfo model) { using (var db = new SRISContext()) { RegisterInfo md = db.RegisterInfos.Find(model.RegisterInfoID); md.BeSeekerName = model.BeSeekerName; md.CaseCode = model.CaseCode; md.GetTaskDateTime = model.GetTaskDateTime; md.PostLink = model.PostLink; md.RegisterLink = model.RegisterLink; md.Remarks = model.Remarks; md.SRTypeID = model.SRTypeID; md.Title = model.Title; db.SaveChanges(); return(true); } }
/// <summary> /// 创建一条案例信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool CreateRegister(RegisterInfo model) { try { using (var db = new SRISContext()) { db.RegisterInfos.Add(model); if (db.SaveChanges() > 0) { return(true); } else { return(false); } } } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { return(false); } }
/// <summary> /// 修改联系人信息 /// </summary> /// <param name="model">联系人信息实体类</param> /// <returns></returns> public bool UpdateLinkMan(LinkMan model) { using (var db = new SRISContext()) { LinkMan linkManModel = db.LinkMans.Find(model.LinkManID); linkManModel.Address = model.Address; linkManModel.Birthday = model.Birthday; linkManModel.Career = model.Career; linkManModel.CreateDateTime = model.CreateDateTime; linkManModel.Email = model.Email; linkManModel.IdCardNo = model.IdCardNo; linkManModel.LinkManName = model.LinkManName; linkManModel.OtherLink = model.OtherLink; linkManModel.Phone = model.Phone; linkManModel.QQ = model.QQ; linkManModel.Relationship = model.Relationship; linkManModel.Remark = model.Remark; linkManModel.Sex = model.Sex; linkManModel.TelPhone = model.TelPhone; linkManModel.WeiXin = model.WeiXin; db.SaveChanges(); return(true); } }