实训指导书
(4)完成任务管理系统增加任务功能的设计
public partial class taskAdd : System.Web.UI.Page { string taskName; int userID;
protected void Page_Load(object sender, EventArgs e) { //获得用户名和任务名称 taskName = ""; userID = Convert.ToInt32(Session["userID"].ToString()); if (!Page.IsPostBack) { Label1.Visible = false; Master.lblNavigator.Text = "> 任务管理 > 新建 任务"; Master.lblDiscrption.Text = "输入新任务名称创 建任务"; } } protected void btnCommit_Click(object sender, EventArgs e) { int taskNameLength=txtTaskName.Text.Length; if (taskNameLength > 10) { Label1.Visible = true; return; }
taskName = txtTaskName.Text.ToString(); //向数据库添加新任务 int result = AddTask(userID, taskName); //返回任务列表页 Response.Redirect("taskList.aspx"); } protected void btnReset_Click(object sender, EventArgs e) { txtTaskName.Text = "";
public partial class login : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { }
protected int CheckUser(string value_userName, string value_passWord) { int result; //查询结果
(2)完成任务管理系统主界面的设计 a)模板的设计
<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" Inherits="MasterPage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="/1999/xhtml" > <head id="Head1" runat="server"> <title>无标题页</title> <link href="App_Themes/SkinFile/StyleSheet.css" rel="stylesheet" type="text/css" /> </head> <body> <form id="form1" runat="server"> <table align="center" style="width:550px;border:0"> <tr> <td> <asp:Label ID="navigator" runat="server" Text="导航"></asp:Label></td> </tr> <tr> <td style="border-right: #000000 1px solid; border-top: #000000 1px solid; border-left: #000000 1px solid; border-bottom: #000000 1px solid; background-color: #dcdcdc; height: 24px;"> <asp:Label ID="discription" runat="server" Text="描述"></asp:Label></td> </tr> <tr> <td> <asp:contentplaceholder id="ContentPlaceHolder1" runat="server"> </asp:contentplaceholder> </td> </tr> </table> </form> </body>
</Columns> </asp:GridView>
(3)完成任务管理系统删除功能、更改任务状态功能、编辑 功能的设计(利用SqlDataSource控件)
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TrainningDSN %>" SelectCommand="SELECT * FROM [Task] WHERE ([userID] = @userID) ORDER BY [taskName]" DeleteCommand="DELETE FROM Task WHERE (id = @id)" UpdateCommand="update Task set taskName=@taskName where id=@id"> <SelectParameters> <asp:SessionParameter Name="userID" SessionField="userid" Type="Int32" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="id" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="taskName" /> <asp:Parameter Name="id" /> </UpdateParameters> </asp:SqlDataSource>
using using using using using using using using using using using
System; System.Data; System.Configur.Web; System.Web.Security; System.Web.UI; System.Web.UI.WebControls; System.Web.UI.WebControls.WebParts; System.Web.UI.HtmlControls; System.Data.SqlClient;
</html>
b)GridView控件的设计
<asp:GridView Width="100%" ID="gridViewTask" runat="server" AutoGenerateColumns="False" OnRowDataBound="gridViewTask_RowDataBound" DataKeyNames="id" AllowPaging="True" PageSize="5" DataSourceID="SqlDataSource1" OnSelectedIndexChanged="gridViewTask_SelectedIndexChanged" OnRowEditing="grid_Editing"> <Columns> <asp:BoundField DataField="taskName" HeaderText="任务名称" /> <asp:BoundField DataField="createTime" HeaderText="创建时间" ReadOnly="True" /> <asp:BoundField DataField="taskStatus" HeaderText="任务状态" ReadOnly="True" /> <asp:CommandField HeaderText="编辑" ShowEditButton="True" /> <asp:CommandField HeaderText="选择" ShowSelectButton="True" SelectText="改变状态" /> <asp:TemplateField HeaderText="删除" ShowHeader="False"> <ItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" OnClientClick="return confirm('确认要删除 吗?')" CausesValidation="False" CommandName="Delete" Text="删除"></asp:LinkButton> </ItemTemplate> </asp:TemplateField>