Console.backgroundcolor = Consolecolor.white;
Console.foregroundcolor = Consolecolor.black;
while (true)
{
Console.clear ();
New Test1 (). Datalook ();
while (true)
{
Console.WriteLine ();
Console.WriteLine ();
Console.Write ("Please enter the action you want to perform (add: 1, modify: 2, Delete: 3):");
string u = Console.ReadLine ();
if (U = = "1")
{
Users UUU = new users ();
UuU. Ucode = new Usersdata (). Newucode ();
Console.WriteLine ("Numbered:" + UUU. Ucode);
while (true)
{
Console.Write ("Please enter user name:");
UuU. UserName = Console.ReadLine ();
if (UUU. Username.trim (). Length > 0) {break;}
else {Console.WriteLine ("User name does not meet the rules!") "); }
}
while (true)
{
Console.Write ("Please enter password:");
UuU. PassWord = Console.ReadLine ();
Console.Write ("Please enter the new password again:");
String PassWord2 = Console.ReadLine ();
if (UUU. Password.trim (). Length > 4 && UUU. PassWord = = PassWord2)
{
Break
}
Else
{Console.WriteLine ("Password does not meet the rules!") ");
}
}
while (true)
{
Console.Write ("Please enter a nickname:");
UuU. Nickname = Console.ReadLine ();
if (UUU. Nickname.trim (). Length > 0) {break;}
else {Console.WriteLine ("Nickname does not meet the rules!") "); }
}
while (true)
{
Console.Write ("Please enter gender (male/female):");
String ssex = Console.ReadLine ();
if (ssex! = "Male" && ssex! = "female")
{
Console.WriteLine ("Gender input is wrong!") ");
}
Else
{
UuU. Sex = Ssex = = "Male"? True:false;
Break
}
}
while (true)
{
Console.Write ("Please enter your Birthday (2000-1-1):");
string bir = Console.ReadLine ();
Try
{
UuU. Birthday = Convert.todatetime (BIR);
Break
}
Catch
{
Console.WriteLine ("Date input Error! ");
}
}
while (true)
{
Console.Write ("Please enter your nationality (e.g. Han/Tibetan):");
string nat = Console.ReadLine ();
String snn = new Usernationdata (). Selectnationcode (NAT);
if (SNN = = "NULL")
{
Console.WriteLine ("Look no this nation!") ");
}
Else
{
UuU. Nation = SNN;
Break
}
}
Usersdata Udd = new Usersdata ();
bool OK = Udd. Insertuser (UUU);
if (OK)
{
Console.WriteLine ("added successfully! ");
}
Else
{
Console.WriteLine ("Add failed! ");
}
Console.readkey ();
Break
}
Class
public string Newucode ()
{
string s = "Build failed!" ";
Cmd.commandtext = "Select *from Users Order by Ucode Desc";
Conn. Open ();
SqlDataReader dr = cmd. ExecuteReader ();
if (Dr. HasRows)
{
Dr. Read ();
String code = dr["Ucode"]. ToString ();
int a = Convert.ToInt32 (code. Substring (1));
a++;
s = "U" + a.tostring ("000");
}
Conn. Close ();
return s;
}
public bool Insertuser (Users u)
{
bool OK = false;
Cmd.commandtext = "INSERT into Users values (@a,@b,@c,@d,@e,@f,@g)";
Cmd. Parameters.clear ();
Cmd. Parameters.Add ("@a", U.ucode);
Cmd. Parameters.Add ("@b", u.username);
Cmd. Parameters.Add ("@c", U.password);
Cmd. Parameters.Add ("@d", u.nickname);
Cmd. Parameters.Add ("@e", u.sex);
Cmd. Parameters.Add ("@f", u.birthday);
Cmd. Parameters.Add ("@g", u.nation);
Conn. Open ();
int count = cmd. ExecuteNonQuery ();
if (Count > 0)
{
OK = true;
}
Conn. Close ();
return OK;
}
ADO. NET object-oriented add program