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