/// <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);
}
}
