private void btnLogin_Click(object sender, EventArgs e)
{
if (txtUserId.Text == "" || txtUserPwd.Text == "")
{
MessageBox.Show("请将信息填写完整!");
return;
}
else
{
string name = txtUserId.Text.Trim(); //移除用户名前部和后部的空格
string pwd = txtUserPwd.Text.Trim(); //移除密码前部和后部的空格
conn = new OracleConnection(ConnectionString);
conn.Open(); //连接到数据库
OracleCommand cmd = new OracleCommand( "select * from T_User where UserName='" +name + "' and UserPwd='" + pwd + "'", conn);
OracleDataReader sdr = cmd.ExecuteReader();//得到数据读取器对象
sdr.Read(); //读取一条记录
if (sdr.HasRows) //判断是否包含数据
{
string time = DateTime.Now.ToString(); //得到系统时间字符串
string strSql = "update T_User set LoginTime='"+ time + "' where UserName='" + name + "'";
OracleCommand command = new OracleCommand();
conn = new OracleConnection(ConnectionString);
command.CommandText = strSql;
this.Hide(); //隐藏窗体
frmMain Main = new frmMain(); //创建主窗体对象
Main.User = name; //为主窗体字段赋值
Main.Logintime = time; //为主窗体字段赋值
Main.Show(); //显示主窗体
}
else
{
txtUserId.Text = ""; //清空用户名
txtUserPwd.Text = ""; //清空密码
MessageBox.Show("用户名或密码错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
{
if (txtUserId.Text == "" || txtUserPwd.Text == "")
{
MessageBox.Show("请将信息填写完整!");
return;
}
else
{
string name = txtUserId.Text.Trim(); //移除用户名前部和后部的空格
string pwd = txtUserPwd.Text.Trim(); //移除密码前部和后部的空格
conn = new OracleConnection(ConnectionString);
conn.Open(); //连接到数据库
OracleCommand cmd = new OracleCommand( "select * from T_User where UserName='" +name + "' and UserPwd='" + pwd + "'", conn);
OracleDataReader sdr = cmd.ExecuteReader();//得到数据读取器对象
sdr.Read(); //读取一条记录
if (sdr.HasRows) //判断是否包含数据
{
string time = DateTime.Now.ToString(); //得到系统时间字符串
string strSql = "update T_User set LoginTime='"+ time + "' where UserName='" + name + "'";
OracleCommand command = new OracleCommand();
conn = new OracleConnection(ConnectionString);
command.CommandText = strSql;
this.Hide(); //隐藏窗体
frmMain Main = new frmMain(); //创建主窗体对象
Main.User = name; //为主窗体字段赋值
Main.Logintime = time; //为主窗体字段赋值
Main.Show(); //显示主窗体
}
else
{
txtUserId.Text = ""; //清空用户名
txtUserPwd.Text = ""; //清空密码
MessageBox.Show("用户名或密码错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}