protected void btnOk_Click(object sender, EventArgs e)
{
user = new UsrInfo();
user.UsrName = txtUsername.Text;
user.UsrPwd = txtPwd.Text;
user.UsrEmail = txtEmail.Text;
bool result = UsrInfoBLL.login(txtUsername.Text, txtPwd.Text);
if (result)
{
Response.Write("<script type='text/javascript'>alert('错误，已存在同样名称');</script>");
}
else
{
result = UsrInfoBLL.AddUser(user);
if (result)
{
Response.Write("<script type='text/javascript'>alert('注册成功');</script>");
Server.Transfer("Default.aspx");
}
else
{
Response.Write("<script type='text/javascript'>alert('注册失败');</script>");
}
}
}
static void Main(string[] args)
{
UsrInfo usr1 = new UsrInfo();//
#region userInit
usr1.FirstName = ("Andrey");
usr1.LastName = ("Abramov");
usr1.CarSign = ("а456кк777");
/*if (Regex.IsMatch(inputNumber, "^[а-я]\\d{3}[а-я]{3}\\d{3}$"))
* usr1.CarSign = inputNumber;
* else
* Console.WriteLine($"'{inputNumber}' is not a car sign.")*///ввод номера по шаблону
usr1.PhoneNumber = ("+79314567432");
#endregion
List <UsrInfo> UsrBd = new List <UsrInfo>()
{
};
UsrBd.Add(usr1);
string comparison = Console.ReadLine();
Logic.Compare comp1 = new Logic.Compare();
comp1.CompareUsr(comparison, UsrBdы);
Console.ReadLine();
}
public int CompareUsr(string CarSign, UsrInfo UsrBd)
{
string CarSigner = CarSign;
foreach (var CarSigner in UsrBd)
{
}
}
public static bool AddUser(UsrInfo user)
{
int result = UsrInfoDAL.Insert(user);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public static int Insert(UsrInfo user)
{
String cmdText = "insert into UsrInfo(usrName,usrPwd,usrEmail) values(@usrName,@usrPwd,@usrEmail)";
SqlParameter[] values = new SqlParameter[3];
values[0] = new SqlParameter("usrName", user.UsrName);
values[1] = new SqlParameter("usrPwd", user.UsrPwd);
values[2] = new SqlParameter("usrEmail", user.UsrEmail);
int result = DBHelp.ExecuteNonQuery(cmdText, values);
return(result);
}
public static bool login(string usrName, string usrPwd)
{
UsrInfo user = UsrInfoDAL.Select(usrName);
if (user == null)
{
return(false);
}
else
if (user.UsrPwd.Equals(usrPwd))
{
return(true);
}
else
{
return(false);
}
}
public static UsrInfo Select(string usrName)
{
string cmdText = "select * from UsrInfo where usrName='" + usrName + "'";
DataSet ds = DBHelp.GetDataSet(cmdText);
UsrInfo user = null;
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
user = new UsrInfo();
DataRow dr = dt.Rows[0];
user.UsrEmail = dr["usrEmail"].ToString();
user.UsrName = dr["usrName"].ToString();
user.UsrPwd = dr["usrPwd"].ToString();
}
return(user);
}
