protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { string user_ip = Request.UserHostAddress;//获取用户IP地址信息 sqltext = "select * from users where username='******'"; table = con.RunSqlReturnTable(sqltext); if (TextBox3.Text.Trim().ToUpper() != Button1.Text.Trim().ToUpper()) { WebMessage.Show("验证码错误!"); } else if (table.Rows.Count <= 0) { WebMessage.Show("用户名错误!"); } else if (table.Rows[0][1].ToString() != TextBox2.Text.Trim()) { WebMessage.Show("密码错误!"); } else if (Session["username"] == null || Session["username"].ToString().Trim() == "") { UserLogin(TextBox1.Text.Trim(), user_ip); table = con.RunSqlReturnTable(sqltext); Session["username"] = TextBox1.Text.Trim(); Session["password"] = TextBox2.Text.Trim(); Session["nc"] = table.Rows[0]["nc"].ToString().Trim(); Session["jf"] = table.Rows[0]["jf"].ToString().Trim().ToString(); Session["realname"] = table.Rows[0]["realname"].ToString().Trim(); Session["lb"] = table.Rows[0]["lb"].ToString().Trim(); Session["pic"] = table.Rows[0]["pic"].ToString().Trim(); Session["sex"] = table.Rows[0]["sex"].ToString().Trim(); if (table.Rows[0]["last_time"].ToString().Length > 5) { Session["last_time"] = table.Rows[0]["last_time"].ToString().Trim().Substring(0, 10); } if (Session["url"] == null || Session["url"].ToString().Trim() == "") { Response.Redirect("Default.aspx"); } else { Response.Redirect(Session["url"].ToString()); } } else { WebMessage.Shows("请退出当前登录的用户!"); } }
protected void b_send_Click(object sender, EventArgs e) { if (tb_cno.Text.Length == 0) { WebMessage.Show("请输入课程号!"); } else { ConnSql con = new ConnSql(); System.Data.DataTable table = new System.Data.DataTable(); string tno = con.RunSqlReturnTable("select tno from teacher where tname='" + ddl_lt.Text.Trim() + "'").Rows[0][0].ToString(); int result = con.RunSql("insert into course(cno,cname,tno,xs,skdd) values ('" + tb_cno.Text.Trim() + "','" + tb_cname.Text.Trim() + "','" + tno + "','" + tb_cth.Text.Trim() + "','" + tb_classAdd.Text.Trim() + "')"); if (result == 1) { WebMessage.Show("添加成功"); } else { WebMessage.Show("添加失败"); } } }
protected void Page_Load(object sender, EventArgs e) {//IsPostBack == false && if (Request.QueryString["kch"] != null) { string kch = Request.QueryString["kch"].ToString(); ConnSql con = new ConnSql(); System.Data.DataTable table = new System.Data.DataTable(); table = con.RunSqlReturnTable("SELECT * from course where cno = '" + kch + "'"); if (!IsPostBack && table.Rows.Count != 0) { //ddl_tch.SelectedIndex = 0; tb_cno.Text = table.Rows[0]["cno"].ToString(); tb_cname.Text = table.Rows[0]["cname"].ToString(); tb_lt.Text = table.Rows[0]["xs"].ToString(); tb_addr.Text = table.Rows[0]["skdd"].ToString(); ddl_tch.DataBind(); ddl_tch.SelectedValue = table.Rows[0]["tno"].ToString(); var list = ddl_tch.Items.FindByValue(table.Rows[0]["tno"].ToString()); //ddl_tch.SelectedItem;// = table.Rows. } } else { Response.Redirect("./CourseManage.aspx"); } }
protected void btn_login_Click(object sender, EventArgs e) { if (btn_showCheck.Text == tb_checkcode.Text.Trim()) { ConnSql conn = new ConnSql(); string sql = "select * from student where sno = '" + tb_sno.Text + "' AND pwd='" + tb_pwd.Text + "'"; var table = conn.RunSqlReturnTable(sql); if (table.Rows.Count != 0) { Session["sno"] = tb_sno.Text.Trim(); Session["sname"] = table.Rows[0]["sname"].ToString().Trim(); Response.Redirect("Stu/UpdateStu.aspx"); } else { Response.Redirect("./Default.aspx"); } } }
protected void Button2_Click(object sender, EventArgs e) { if (TextBox1.Text.Trim() == "") { WebMessage.Show("请输入用户名"); } else if (TextBox2.Text.Trim() == "") { WebMessage.Show("请输入密码"); } else if (TextBox3.Text.Trim() == "") { WebMessage.Show("请输入验证码"); } else { string sqltext = "select * from student where sno='" + TextBox1.Text.Trim() + "'"; DataTable table = new DataTable(); ConnSql cn = new ConnSql(); table = cn.RunSqlReturnTable(sqltext); if (table.Rows.Count <= 0) { WebMessage.Show("用户名错误!"); } else if (table.Rows[0]["pwd"].ToString().Trim() != TextBox2.Text) { WebMessage.Show("密码错误!"); } else if (TextBox3.Text.Trim().ToUpper() != Button1.Text.Trim().ToUpper()) { WebMessage.Show("验证码错误!"); } else { Session["username"] = TextBox1.Text.Trim(); Session["password"] = TextBox2.Text.Trim(); Session["sname"] = table.Rows[0]["sname"].ToString().Trim(); WebMessage.Show("全部正确", "StudentMain.aspx"); } } }
protected void bCheck_Click(object sender, EventArgs e) { if (tb_sno.Text.Length == 0) { WebMessage.Show("请输入学号!"); } else { ConnSql con = new ConnSql(); DataTable table = new DataTable(); table = con.RunSqlReturnTable("select * from student where sno = " + "'" + tb_sno.Text.Trim() + "'"); if (table.Rows.Count.Equals(0)) { WebMessage.Show("学号不存在"); return; } else { tb_sname.Text = table.Rows[0][1].ToString(); //获取出生年月日 string s = table.Rows[0]["birthday"].ToString(); tb_birth.Text = s.Substring(0, s.LastIndexOf(' ')); //获取性别 if (table.Rows[0]["sex"].Equals(true)) { rb_girl.Checked = true; } else { rb_man.Checked = true; } tb_sno.BackColor = System.Drawing.Color.DarkGray; tb_sno.ReadOnly = true; } } }
protected void btn_login_Click(object sender, EventArgs e) { string sqltext = "select * from admini where username = '******' and pwd = '" + tb_password.Text + "'"; ConnSql conn = new ConnSql(); System.Data.DataTable table = conn.RunSqlReturnTable(sqltext); if (tb_checkcode.Text == btn_img.Text) { if (table.Rows.Count != 1) { WebMessage.Show("用户名或密码错误。"); } else { Session["username"] = table.Rows[0]["username"]; Response.Redirect("Index_Admin.aspx"); } //return; } else { WebMessage.Show("验证码错误。"); } }
protected void Button_Login(object sender, EventArgs e) { if (Username.Text == "") { WebMessage.Show("请输入用户名"); } else if (Password.Text == "") { WebMessage.Show("请输入密码"); } else if (yzm.Text == "") { WebMessage.Show("请输入验证码"); } else { string sqltext = "select * from bookuser where id='" + Username.Text + "'"; DataTable table = new DataTable(); ConnSql cn = new ConnSql(); table = cn.RunSqlReturnTable(sqltext); if (table.Rows.Count <= 0) { WebMessage.Show("用户名错误!"); } else if (table.Rows[0][1].ToString().Trim() != Password.Text) { WebMessage.Show("密码错误!"); } else if (table.Rows[0][4].ToString().Trim() == "0") { WebMessage.Show("账户处于挂失状态,无法登陆!"); } else if (yzm.Text != btn_yzm.Text) { WebMessage.Show("验证码输入错误"); } else { ConnSql con = new ConnSql(); string sql = "update bookuser SET last_login_time='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.ffff") + "' WHERE id='" + table.Rows[0][0].ToString() + "'"; con.RunSql(sql); //保存登录的用户的用户名和密码到Session对象 Session["Admin"] = table.Rows[0][5].ToString(); if (Session["Admin"].ToString() == "1") { Session["Username"] = table.Rows[0][0].ToString(); Session["Password"] = table.Rows[0][1].ToString(); Session["Name"] = table.Rows[0][2].ToString(); Session["Time"] = table.Rows[0][6].ToString(); Session["id"] = Username.Text; WebMessage.Show("登录成功,管理员:" + Session["Name"].ToString().Trim() + "欢迎您!", "/Admin/Index/Index.aspx"); } else if (Session["Admin"].ToString() == "0") { Session["Username"] = table.Rows[0][0].ToString(); Session["Password"] = table.Rows[0][1].ToString(); Session["Name"] = table.Rows[0][2].ToString(); Session["Time"] = table.Rows[0][6].ToString(); Session["id"] = Username.Text; WebMessage.Show("登录成功," + Session["Name"].ToString().Trim() + "同学,欢迎您!", "/Home/Index/Index.aspx"); } } } }