第一次测试：个人任务管理系统（反思）

 public static int Update(Task task)
        {
            var sql = " update task set taskstate=2,FinishedTime=getdate() where taskid=" + task.TaskID;
            return SqlHelper.NonQuery(sql);
        }

<asp:Button ID="Button1" runat="server" Text="完成任务" CommandName="_update" CommandArgument=‘<%# Eval("TaskID") %>‘
                        Visible=‘<%# Convert.ToInt32(Eval("TaskState"))==1 %>‘ />

var cmd = e.CommandName;
            if (cmd == "_update")
            {
                var id = Convert.ToInt32(e.CommandArgument);
                var num = TaskManager.Update(new Model.Task() { TaskID = id });
                if (num > 0)
                {
                    GridView1.DataSource = TaskManager.Select();
                    GridView1.DataBind();
                    Response.Write("<script>alert(‘任务完成成功‘)</script>");
                }
            }

public static int Insert(Task task)
        {
            var sql = string.Format("insert into Task values({0},‘{1}‘,getdate(),1,null,{2})", task.TaskPriority, task.Content, task.ProjectID);
            return SqlHelper.NonQuery(sql);
        }

<asp:Button ID="Button4" runat="server" Text="添加" PostBackUrl="~/AddTask.aspx" 
            onclick="Button4_Click" />

var task = new Task()
            {
                ProjectID = Convert.ToInt32(DropDownList1.SelectedValue),
                Content = TextBox1.Text,
                TaskPriority = Convert.ToInt32(RadioButtonList1.SelectedValue)
            };

            var num = TaskManager.Insert(task);
            if (num > 0)
            {
                Response.Write("<script>alert(‘任务添加成功‘);location.href=‘TaskList.aspx‘</script>");
            }