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