Text='<%# Eval(\' />
ConnectionString=\<%$ ConnectionStrings:DormConnectionString2 %>\ SelectCommand=\massage from massage where id>=all( select id from massage )\asp:SqlDataSource>
周 次：
16
onclick=\ />
onclick=\ />
Width=\ ReadOnly=\asp:TextBox>
style=\font-size: x-large; color: #FF0000; font-weight: 900;\
校内网站
href=\img alt=\ class=\ src=\ />
17
3.1用户登录
登录功能的实现
protected void Button10_Click(object sender, EventArgs e)//用户登录? {
string Userduti = this.DropDownList1.Text.Trim(); string UserID = this.TextBox1.Text.Trim(); string Password = this.TextBox2.Text.Trim(); SqlConnection conn = new SqlConnection(); conn.ConnectionString = \
Security=True;Database=Dorm;Server=USERSWO-0I96CA3\; conn.Open();
SqlCommand cmd = new SqlCommand(); cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
18
cmd.CommandText = \ + UserID + \Password='\ + Password + \; SqlDataReader dr;
dr = cmd.ExecuteReader();
if (DropDownList1.Text == \请选择登录身份==\) {
Response.Write(\请选择登录类别')\); this.TextBox1.Text = \; this.TextBox2.Text = \; return; }
if (DropDownList1.Text == \学生\) {
if (dr.Read()) {
// string s_url; s_url = \TextBox1.Text.Trim();//QueryString方法¤ // Response.Redirect(s_url);
Session[\] = TextBox1.Text.Trim(); //session方法 Server.Transfer(\); Response.Redirect(\); } else {
Response.Write(\学号和密码不符！')\); this.TextBox1.Text = \; this.TextBox2.Text = \; return; }
}
if (DropDownList1.Text == \管理员\) {
if (dr.Read()) {
//string s_url; s_url = \TextBox1.Text.Trim();//QueryString方法 //Response.Redirect(s_url);
Session[\] = TextBox1.Text.ToString().Trim(); //session方法 Server.Transfer(\); Response.Redirect(\); } else {
19
Response.Write(\学号和密码不符！')\); this.TextBox1.Text = \; this.TextBox2.Text = \; return; } }
}
3.2寝室卫生查询
查询功能的实现
protected void Button8_Click(object sender, EventArgs e)//查询数据 {
if (TextBox5.Text == \) {
Response.Write(\请输入楼栋号')\); return; }
if (TextBox6.Text == \) {
Response.Write(\请输入周次')\); return; }
SqlConnection conn = new SqlConnection(connStr);
string sqlStrSelect = \ + TextBox5.Text.Trim() + \ + TextBox6.Text.Trim() + \;
20