C#编写WEB程序设计课程设计报告.doc

WEB程序设计课程设计报告一、程序总体功能描述首页登陆注册密码修改任务统计设备分类管理我的维护任务我们通过设计首页来让员工注册自己的个人信息才能登陆进我们的管理系统。登陆系统后，就可以方便维修人员对自己的工作的安排，首先是自己的工作任务，还可以在设备分类里面添加我们的设备，对用户送来修理的设备进行录入，最后每天都可以查看自己的工作的统计。我们进行了一个详细的分类总结。二、添加分类需求程序详细设计（一）设备分类管理功能详细设计（梅浩）1、功能描述2、实现描述在sort_add代码中添加分类需求这个字段，然后在后台代码中添加能够判断数据库读写的字段，在SortDataAccess.cs代码中添加写入数据的代码，并且在添加、修改、删除的数据段中都必须添加此字段，否则会运行报错3、主要功能函数解析sort_add.aspx代码 添加新的维修设备 设备分类名称 分类简介 用户需求   这个是sort_add.aspx界面，在界面上添加文字。使用后台的aspx.cs后台代码来实现他的有关功能sort_add.aspx.cs界面using System;using System.Collections;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;public partial class sort_sort_add : System.Web.UI.Page private CommDataAccess cda = new CommDataAccess(); private SortDataAccess sda = new SortDataAccess(); private TaskDataAccess tda = new TaskDataAccess(); protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) cda.changeHeadBg(h2, Master); protected void Button1_Click(object sender, EventArgs e) int res = 0; try res = sda.addSort(TextBoxSortName.Text, TextBoxIntro.Text,TextBoxSortRemark.Text);/这个是最主要的字段，将TextBox中的SortRemark文本框中的字段添加到数据库中 if (res 0) resLabel.Text = 操作成功; else resLabel.Text = 操作失败; /使用判断语句判断是否操作成功，但是我们还要在数据库中添加备注这个字段，所以就要修改数据库的代码。 catch (Exception ex) resLabel.Text = 操作失败！原因是： + ex.ToString(); SortDataAccess.cs代码分析我们是在sort_add代码中添加的模块所以在数据库中我们就要在sortdataaccess.cs中添加我们所需要的数据信息，下面我们着重介绍添加的数据流程我们在获取任务分类，删除任务分类，修改任务分类，增加任务分类中都用到了sort_remark这个字段，所以在数据库添加的文件中也必须要修改这几个字段，在这几个代码中添加这个字段的名称即可using System;using System.Data;using System.Configuration;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 System.Data.SqlClient;using System.Collections.Generic;/ / Summary description for SortDataAccess/ public class SortDataAccess public SortDataAccess() /获取Web.Config中设置的连接字符串 connectionString = server=.;database=task;uid=sa;pwd=307; /connectionString = Data Source=.SQLEXPRESS;Initial Catalog=task;Integrated Security=True; private string connectionString; / / 获取任务分类信息 / / public DataSet SortList() using (SqlConnection conn = new SqlConnection(connectionString) string sqlstr = SELECT sortid,sortname,intro,sortremark FROM task.dbo.sort ORDER BY sortid DESC; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sqlstr; DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter(cmd); /将数据填充到DataSet中 sda.Fill(ds); return ds; / / 删除任务分类 / / public int delSort(string sortid) using (SqlConnection conn = new SqlConnection(connectionString) string sqlstr = delete from task.dbo.sort where sortid = sortid; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sqlstr; cmd.Parameters.Add(sortid, SqlDbType.VarChar); cmd.Parameterssortid.Value = sortid; conn.Open(); int res = cmd.ExecuteNonQuery(); return res; / / 修改任务分类 / / public int updateSort(string sortid, string sortname, string intro, string sortremark) using (SqlConnection conn = new SqlConnection(connectionString) string sqlstr = update task.dbo.sort set sortname=sortname,intro=intro ,sortremark=sortremark where sortid = sortid; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sqlstr; cmd.Parameters.Add(sortid, SqlDbType.VarChar); cmd.Parameterssortid.Value = sortid; cmd.Parameters.Add(sortname, SqlDbType.VarChar); cmd.Parameterssortname.Value = sortname; cmd.Parameters.Add(intro, SqlDbType.VarChar); cmd.Parametersintro.Value = intro; cmd.Parameters.Add(sortremark, SqlDbType.VarChar); cmd.Parameterssortremark.Value = sortremark; conn.Open(); int res = cmd.ExecuteNonQuery(); return res; / / 增加任务分类 / / public int addSort(string sortname, string intro,string sortremark) using (SqlConnection conn = new SqlConnection(connectionString) string sqlstr = insert into task.dbo.sort(sortname,intro,sortremark) values (sortname,intro,sortremark); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sqlstr; cmd.Parameters.Add(sortname, SqlDbType.VarChar); cmd.Parameterssortname.Value = sortname; cmd.Parameters.Add(intro, SqlDbType.VarChar); cmd.Parametersintro.Value = intro; cmd.Parameters.Add(sortremark, SqlDbType.VarChar); cmd.Parameterssortremark.Value = sortremark; conn.Open(); int res = cmd.ExecuteNonQuery(); return res; / / 获取分类中任务的数量 / / public int getSortNum(string sortid) using (SqlConnection conn = new SqlConnection(connectionString) string sqlstr = select count(*) from task.dbo.task where sortid = sortid; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sqlstr; cmd.Parameters.Add(sortid, SqlDbType.VarChar); cmd.Parameterssortid.Value = sortid; conn.Open(); int res = Convert.ToInt32(cmd.ExecuteScalar(); return res; / / 根据任务sortid获取任务信息 / / public Dictionary selectInfoBySortid(string sortid) using (SqlConnection conn = new SqlConnection(connectionString) conn.Open(); string sqlstr = select * from task.dbo.sort where sortid= + sortid; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sqlstr; SqlDataReader reader = cmd.ExecuteReader(); Dictionary sortInfo = new Dictionary(); while (reader.Read() sortInfo.Add(sortid, reader0.ToString(); sortInfo.Add(sortname, reader1.ToString(); sortInfo.Add(intro, reader2.ToString(); sortInfo.Add(sortremark, reader3.ToString(); return sortInfo; / / 统计任务分类 / / public DataSet getStatistic() using (SqlConnection conn = new SqlConnection(connectionString) string sqlstr = SELECT sortid, sortname, (SELECT count(*) FROM task WHERE sortid = S.sortid) as Total, (SELECT count(*) FROM task WHERE sortid = S.sortid and taskstatus=未完成) as TotalIncomplete, (SELECT count(*) FROM task WHERE sortid = S.sortid and taskstatus=完成) as TotalComplete FROM sort S; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sqlstr; conn.Open(); DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter(cmd); /将数据填充到DataSet中 sda.Fill(ds); return ds; public int addSort(string p, string p_2, TextBox TextBoxSortRemark) throw new Exception(The method or operation is not implemented.); （二）注册功能详细设计（朱佳宇、马海涛、孙轩凯）1、功能描述添加工作人员注册模块，为我们的上班人员注册自己的账户2、实现描述在以前现有的模版上添加了注册的模块，我们只需要截取userid以及username加入数据库中user的表中就可以添加一行数据项，但是还要在数据库的表中添加userdataaccess.cs文件3、主要功能函数解析register.aspx代码 用户注册 用户注册             register.aspx.cs代码主要涉及到的代码：将文件中的txtUserName.Text, txtPassword.Text字段添加到数据库中using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class register : System.Web.UI.Page private CommDataAccess cda = new CommDataAccess(); private SortDataAccess sda = new SortDataAccess(); private UsersDataAccess uda = new UsersDataAccess(); protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) int res = 0; try res = uda.addUsers(txtUserName.Text, txtPassword.Text); if (res 0) resLabel.Text = 操作成功; Response.Redirect(login.aspx); else resLabel.Text = 操作失败; catch (Exception ex) resLabel.Text = 操作失败！原因是： + ex.ToString() + username= + txtUserName.Text + password= + txtPassword.Text; protected void Button2_Click(object sender, EventArgs e) Response.Redirect(login.aspx); UserDataAccess.cs代码分析代码中取userid、username、password等字段添加进user数据库中，我们可以在user的表中进行查看表中的属性using System;using System.Data;using System.Configuration;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 System.Data.SqlClient;using System.Collections.Generic;/ / Summary description for TaskDataAccess/ public class UsersDataAccesspublic UsersDataAccess(