public UAccaount SignIn(int Login, string Password)
{
cn.Open();
string cm = $"select * from U_Accaunt a join U_Roles p on a.RoleId = p.id where Login = {Login} and Password='******'";
SqlCommand cd = new SqlCommand(cm, cn);
SqlDataReader r = cd.ExecuteReader();
UAccaount uas = new UAccaount();
while (r.Read())
{
uas = new UAccaount()
{
id = int.Parse(r.GetValue("id").ToString()),
RoleId = int.Parse(r.GetValue("RoleId").ToString()),
Gender = r.GetValue("Gender").ToString(),
Age = int.Parse(r.GetValue("Age").ToString()),
CityZone = r.GetValue("CityZone").ToString(),
FStatus = r.GetValue("FStatus").ToString(),
FullName = r.GetValue("FullName").ToString(),
Login = int.Parse(r.GetValue("Login").ToString()),
Password = r.GetValue("Password").ToString(),
Role = r.GetValue("Role").ToString()
};
}
cn.Close();
return(uas);
}
public void Update(UAccaount ua, int?id)
{
cn.Open();
string cm = $"update U_Accaunt set RoleId = {ua.RoleId},FullName='{ua.FullName}',Gender='{ua.Gender}',FStatus'{ua.FStatus}',Age={ua.Age},CityZone='{ua.CityZone}',Login={ua.Login},Password='******' where id =";
SqlCommand cd = new SqlCommand(cm, cn);
cd.ExecuteNonQuery();
cn.Close();
}
public void Add(UAccaount ua)
{
Random ran = new Random();
cn.Open();
ua.id = ran.Next(0, 1000000);
string cm = $"insert into U_Accaunt(id,RoleId,Fullname,Gender,FStatus,Age,CityZone,Login,Password,ICard) Values({ua.id},{ua.RoleId},'{ua.FullName}','{ua.Gender}','{ua.FStatus}',{ua.Age},'{ua.CityZone}',{ua.Login},'{ua.Password}','{ua.ICNum}');";
SqlCommand cd = new SqlCommand(cm, cn);
cd.ExecuteNonQuery();
cn.Close();
}
