/// <summary> /// /// </summary> /// <param name="UserName"></param> /// <param name="PassWord"></param> /// <returns></returns> public static User Valid(string UserName, string PassWord) { User User = null; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { ///该写法有sql注入风险 //User = dbContext.Users.Where<User>(user => (user.UserName == UserName && user.Password == PassWord)).First() as User; dbContext.Configuration.LazyLoadingEnabled = false; string sql = "select * from [User] where UserName=@UserName and Password=@Password"; var args = new DbParameter[] { new SqlParameter("UserName", UserName), // 写法1 new SqlParameter { ParameterName = "Password", Value = PassWord }, // 写法2 }; User = dbContext.Database.SqlQuery <User>(sql, args).FirstOrDefault(); if (User != null) { User.Role = dbContext.Role.Where <Role>(c => c.RoleId == User.RoleId).FirstOrDefault(); if (User.FamilyId != null) { User.Family = dbContext.Family.Where <Family>(c => c.FamilyId == User.FamilyId).FirstOrDefault(); } } } return(User); }
private void btInit_Click(object sender, EventArgs e) { FRSDbContext = new FamilyRelationshipContext(); bool flag = FRSDbContext.Database.CreateIfNotExists(); if (flag == true) { CertificateType type = new CertificateType(); type.CertificateTypeName = "二代身份证"; type.Description = "二代身份证"; FRSDbContext.CertificateType.Add(type); Role role = new Role(); role.RoleName = "System admin"; role.Description = "System admin"; FRSDbContext.Role.Add(role); User user = new User(); user.UserName = "******"; user.Password = "******"; user.UserTrueName = "admin"; user.RoleId = 1; FRSDbContext.User.Add(user); FRSDbContext.SaveChanges(); MessageBox.Show("数据库创建成功!"); } else { //MessageBox.Show("数据库创建失败!"); } }
/// <summary> /// /// </summary> /// <param name="Member"></param> /// <returns></returns> public static ErrorCode Add(Family Member) { ErrorCode code = ErrorCode.Unknown_Error; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { if (dbContext.Family.Find(Member.FamilyName) != null) { code = ErrorCode.DataAlreadyExist; } else { dbContext.Family.Add(Member); int rows = dbContext.SaveChanges(); if (rows <= 0) { code = ErrorCode.DataAddError; } else { code = ErrorCode.Success; } } } return(code); }
public static Role Get(int RoleId) { Role Role = null; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { Role = dbContext.Role.Where <Role>(c => c.RoleId == RoleId).FirstOrDefault(); } return(Role); }
/// <summary> /// /// </summary> /// <returns></returns> public static List <Role> GetAll() { List <Role> list = null; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { list = dbContext.Role.ToList(); } return(list); }
public static CertificateType Get(int CertificateTypeId) { CertificateType CertificateType = null; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { CertificateType = dbContext.CertificateType.Where <CertificateType>(c => c.CertificateTypeId == CertificateTypeId).FirstOrDefault(); } return(CertificateType); }
/// <summary> /// /// </summary> /// <returns></returns> public static List <CertificateType> GetAll() { List <CertificateType> list = null; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { list = dbContext.CertificateType.ToList(); } return(list); }
/// <summary> /// /// </summary> /// <param name="Member"></param> /// <returns></returns> public static int Remove(Family Member) { int rows = 0; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { Family rem = dbContext.Family.Where <Family>(c => c.FamilyId == Member.FamilyId).FirstOrDefault(); dbContext.Family.Remove(rem); rows = dbContext.SaveChanges(); } return(rows); }
/// <summary> /// /// </summary> /// <param name="CertificateTypeId"></param> /// <returns></returns> public static int Remove(int CertificateTypeId) { int rows = 0; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { CertificateType rem = dbContext.CertificateType.Where <CertificateType>(c => c.CertificateTypeId == CertificateTypeId).FirstOrDefault(); dbContext.CertificateType.Remove(rem); rows = dbContext.SaveChanges(); } return(rows); }
/// <summary> /// /// </summary> /// <param name="Member"></param> /// <returns></returns> public static int Update(CertificateType Member) { int rows = 0; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { CertificateType up = dbContext.CertificateType.Where <CertificateType>(c => c.CertificateTypeId == Member.CertificateTypeId).FirstOrDefault(); up.CertificateTypeName = Member.CertificateTypeName; up.Description = Member.Description; rows = dbContext.SaveChanges(); } return(rows); }
/// <summary> /// /// </summary> /// <param name="Member"></param> /// <returns></returns> public static int Update(Family Member) { int rows = 0; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { Family up = dbContext.Family.Where <Family>(c => c.FamilyId == Member.FamilyId).FirstOrDefault(); up.FamilyName = Member.FamilyName; up.FamilyOrigin = Member.FamilyOrigin; up.FamilyHistory = Member.FamilyHistory; up.GenerationInfo = Member.GenerationInfo; up.Other1 = Member.Other1; up.Other2 = Member.Other2; rows = dbContext.SaveChanges(); } return(rows); }
/// <summary> /// 获取单一家庭成员 /// </summary> /// <param name="FamilyMemberId"></param> /// <returns></returns> public static FamilyMember Get(int FamilyMemberId) { FamilyMember PersonInfo = null; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { PersonInfo = dbContext.FamilyMember.Where <FamilyMember>(c => c.FamilyMemberId == FamilyMemberId).FirstOrDefault(); if (PersonInfo != null) { PersonInfo.CertificateType = dbContext.CertificateType.Where <CertificateType>(c => c.CertificateTypeId == PersonInfo.CertificateTypeId).FirstOrDefault(); PersonInfo.Family = dbContext.Family.Where <Family>(c => c.FamilyId == PersonInfo.FamilyId).FirstOrDefault(); PersonInfo.Father = dbContext.FamilyMember.Where <FamilyMember>(c => c.FamilyMemberId == PersonInfo.Father_FamilyMemberId).FirstOrDefault(); PersonInfo.Mother = dbContext.FamilyMember.Where <FamilyMember>(c => c.FamilyMemberId == PersonInfo.Mother_FamilyMemberId).FirstOrDefault(); PersonInfo.Spouse = dbContext.FamilyMember.Where <FamilyMember>(c => c.FamilyMemberId == PersonInfo.Spouse_FamilyMemberId).FirstOrDefault(); } } return(PersonInfo); }
/// <summary> /// /// </summary> /// <param name="Member"></param> /// <returns></returns> public static int Update(FamilyMember Member) { int rows = 0; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { FamilyMember up = dbContext.FamilyMember.Where <FamilyMember>(c => c.FamilyId == Member.FamilyId).FirstOrDefault(); up.GenerationIndex = Member.GenerationIndex; up.Address = Member.Address; up.Age = Member.Age; up.Birthday = Member.Birthday; up.CertificateNumber = Member.CertificateNumber; up.CertificateTypeId = Member.CertificateTypeId; up.Country = Member.Country; up.Deathday = Member.Deathday; up.Description = Member.Description; up.Education = Member.Education; up.LastName = Member.LastName; up.Father_FamilyMemberId = Member.Father_FamilyMemberId; up.Father = Member.Father; up.File = Member.File; up.GivenName = Member.GivenName; up.Hometown = Member.Hometown; up.Job = Member.Job; up.MiddleName = Member.MiddleName; up.Mother_FamilyMemberId = Member.Mother_FamilyMemberId; up.Mother = Member.Mother; up.Nationality = Member.Nationality; up.OtherName1 = Member.OtherName1; up.OtherName2 = Member.OtherName2; up.PhotoImage = Member.PhotoImage; up.Ranking = Member.Ranking; up.CertificateType = Member.CertificateType; up.Sex = Member.Sex; up.Spouse_FamilyMemberId = Member.Spouse_FamilyMemberId; up.Spouse = Member.Spouse; up.FamilyId = Member.FamilyId; up.Family = Member.Family; rows = dbContext.SaveChanges(); } return(rows); }
/// <summary> /// 根据家族编号,获取所有成员 /// </summary> /// <param name="FamilyId"></param> /// <returns></returns> public static List <FamilyMember> GetMembers(int FamilyId) { List <FamilyMember> list = null; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { list = dbContext.FamilyMember.Where <FamilyMember>(c => c.FamilyId == FamilyId).ToList(); if (list != null && list.Count > 0) { foreach (FamilyMember e in list) { e.CertificateType = dbContext.CertificateType.Where <CertificateType>(c => c.CertificateTypeId == e.CertificateTypeId).FirstOrDefault(); e.Family = dbContext.Family.Where <Family>(c => c.FamilyId == e.FamilyId).FirstOrDefault(); e.Father = dbContext.FamilyMember.Where <FamilyMember>(c => c.FamilyMemberId == e.Father_FamilyMemberId).FirstOrDefault(); e.Mother = dbContext.FamilyMember.Where <FamilyMember>(c => c.FamilyMemberId == e.Mother_FamilyMemberId).FirstOrDefault(); e.Spouse = dbContext.FamilyMember.Where <FamilyMember>(c => c.FamilyMemberId == e.Spouse_FamilyMemberId).FirstOrDefault(); } } } return(list); }
/// <summary> /// /// </summary> /// <param name="FamilyId"></param> /// <returns></returns> public static Family Get(int FamilyId) { Family Family = null; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { Family = dbContext.Family.Where <Family>(c => c.FamilyId == FamilyId).FirstOrDefault(); //if (Family != null) //{ // Family.FamilyMembers = dbContext.FamilyMember.Where<FamilyMember>(c => c.FamilyId == Family.FamilyId).ToList(); // foreach (FamilyMember e in Family.FamilyMembers) // { // e.CertificateType = dbContext.CertificateType.Where<CertificateType>(c => c.CertificateTypeId == e.CertificateTypeId).FirstOrDefault(); // e.Family = dbContext.Family.Where<Family>(c => c.FamilyId == e.FamilyId).FirstOrDefault(); // e.Father = dbContext.FamilyMember.Where<FamilyMember>(c => c.FamilyMemberId == e.Father_FamilyMemberId).FirstOrDefault(); // e.Mother = dbContext.FamilyMember.Where<FamilyMember>(c => c.FamilyMemberId == e.Mother_FamilyMemberId).FirstOrDefault(); // e.Spouse = dbContext.FamilyMember.Where<FamilyMember>(c => c.FamilyMemberId == e.Spouse_FamilyMemberId).FirstOrDefault(); // } //} } return(Family); }