ADO.NET物件導向增添程式

標籤：convert   trim   word   else   white   text   ring   ati   錯誤   

Console.BackgroundColor = ConsoleColor.White;
Console.ForegroundColor = ConsoleColor.Black;
while (true)
{
Console.Clear();
new Test1().DataLook();

while (true)
{
Console.WriteLine();
Console.WriteLine();
Console.Write("請輸入你要執行的操作（添加：1，修改：2，刪除：3）：");
string u = Console.ReadLine();

if (u == "1")
{
Users uuu = new Users();
uuu.Ucode = new UsersData().NewUcode();
Console.WriteLine("編號為：" + uuu.Ucode);
while (true)
{
Console.Write("請輸入使用者名稱：");
uuu.UserName = Console.ReadLine();
if (uuu.UserName.Trim().Length > 0) { break; }
else { Console.WriteLine("使用者名稱不符合規定！"); }
}

while (true)
{
Console.Write("請輸入密碼：");
uuu.PassWord = Console.ReadLine();
Console.Write("請再次輸入新的密碼：");
string PassWord2 = Console.ReadLine();

if (uuu.PassWord.Trim().Length > 4 && uuu.PassWord == PassWord2)
{

break;
}
else
{ Console.WriteLine("密碼不符合規定！");
}
}

while (true)
{
Console.Write("請輸入暱稱：");
uuu.NickName = Console.ReadLine();
if (uuu.NickName.Trim().Length > 0) { break; }
else { Console.WriteLine("暱稱不符合規定！"); }
}

while (true)
{
Console.Write("請輸入性別（男/女）：");
string ssex = Console.ReadLine();
if (ssex != "男" && ssex != "女")
{
Console.WriteLine("性別輸入有誤！");
}
else
{
uuu.Sex = ssex == "男" ? true : false;
break;
}
}

while (true)
{
Console.Write("請輸入生日（2000-1-1）：");
string bir = Console.ReadLine();
try
{
uuu.Birthday = Convert.ToDateTime(bir);
break;
}
catch
{
Console.WriteLine("日期輸入錯誤！");
}
}

while (true)
{
Console.Write("請輸入你的民族（如：漢族/藏族）：");
string nat = Console.ReadLine();
string snn = new UserNationData().SelectNationCode(nat);
if (snn == "null")
{
Console.WriteLine("查無此民族！");
}
else
{
uuu.Nation = snn;
break;
}
}

 

UsersData udd = new UsersData();
bool ok = udd.InsertUser(uuu);
if (ok)
{
Console.WriteLine("添加成功！");
}
else
{
Console.WriteLine("添加失敗！");
}

Console.ReadKey();
break;
}

 

//類

public string NewUcode()
{
string s = "產生失敗！";

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物件導向增添程式