WEB数据库实验报告八
- 格式：doc
- 大小：68.00 KB
- 文档页数：6
学号： 姓名 班级：
实验时间：2012-12-28 实验地点：A4059 指导老师:
实验名称 模块开发
实验目的 掌握根据需求来开发模块
一、实验题目
1、设计一个投诉与建议模块，有管理员，教师，学生三种不同的角色。学生和老师都可以投诉，投诉的时候要包括投诉对象，接收人，还可以选择保密不保密，保密就是只有自己能看到，不保密所有的人都能看到。如果管理员和教师接收到信息可以进行回复，管理员可以查看已处理和未处理的投诉信息。还可以删除一些过时的信息。教师可以查询学生给自己的问题并进行回复。老师和学生可以看已回复和未回复的信息
二、实验内容及结果(请将相应题目代码和结果截图写在相应题目下方)
1、登录代码：
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using DataSet1TableAdapters;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{ WEB数据库实验报告 erTableAdapter a = new
userTableAdapter();
erDataTable b = a.GetData(TextBox1.Text);
erDataTable c = a.GetDataBy(TextBox1.Text,
TextBox2.Text);
if (b.Count > 0)
{
if (c.Count > 0)
{
Session["userid"] = TextBox1.Text;
//string x = c[0].role;
if (c[0].Role == "1")
Response.Redirect("Ordinary.aspx");
else if (c[0].Role == "2")
Response.Redirect("teacher.aspx");
else if (c[0].Role == "3")
Response.Redirect("admin.aspx");
else
Label1.Text = "未知用户角色！";
}
else
Label1.Text = "密码错误！";
}
else
Label1.Text = "用户名不存在！";
}
}
2、学生代码：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Ordinary : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
3、教师代码：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class teacher : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
4、管理员代码：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class teacher : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
5、投诉代码：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DataSet1TableAdapters;
public partial class Complaints : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if ((string)(Session["userid"]) == null)
Response.Redirect("Default.aspx");
Label1.Text = (string)(Session["userid"]);
pd_rl2();
}
public void pd_rl2()
{
if (RadioButtonList2.SelectedItem.Value == "2")
{
DataSet1TableAdapters.teacherTableAdapter a=new
teacherTableAdapter();
DataSet1.teacherDataTable b = a.GetData();
DropDownList1.Items.Clear();
for (int i = 0; i < b.Count; i++)
DropDownList1.Items.Add(new ListItem(b[i].name +
"(" + b[i].userid + ")", b[i].userid));
}
else
{
DataSet1TableAdapters.AdminTableAdapter a = new
AdminTableAdapter();
DataSet1.AdminDataTable b= a.GetData();
DropDownList1.Items.Clear();
for (int i = 0; i < b.Count; i++)
DropDownList1.Items.Add(new ListItem(b[i].name +
"(" + b[i].userid + ")", b[i].userid));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
plaintsTableAdapter a = new
ComplaintsTableAdapter();
a.Insert(TextBox1.Text, DropDownList1.SelectedItem.Value,
RadioButtonList1.SelectedItem.Value, DateTime.Now,
Request.Form["S1"], null, DateTime.Now, "0",
(string)(Session["userid"]), TextBox2.Text);
Response.Write("投诉成功");
//Button1.Text = Request.Form["S1"];
} protected void RadioButtonList2_SelectedIndexChanged(object
sender, EventArgs e)
{
pd_rl2();
}
protected void DropDownList2_SelectedIndexChanged(object
sender, EventArgs e)
{
DropDownList3.Visible =false;
DropDownList4.Visible = false;
TextBox1.Visible = false;
string x = DropDownList2.SelectedValue;
if (x == "2") DropDownList3.Visible = true;
else if (x == "3") DropDownList4.Visible = true;
