当前文件路径：Votes/SubjectManage.aspx.cs

		            
  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11using System.Data.SqlClient;
 12
 13public partial class SubjectManage : System.Web.UI.Page
 14...{
 15    private int sid;
 16    protected void Page_Load(object sender, EventArgs e)
 17    ...{
 18        if (!Page.IsPostBack)
 19        ...{
 20            BindTopicData();
 21            if (TopicList.Items.Count > 0)
 22            ...{                                   /**////使SubjectLIst绑定TopicList的第一项
 23                TopicList.SelectedIndex = 0;
 24                BindSubjectData(Int32.Parse(TopicList.SelectedValue));
 25            }
 26        }
 27    }
 28
 29    private void BindTopicData()
 30    ...{
 31        ITopics topic = new Topics();
 32        SqlDataReader dr = topic.GetAllTopic();
 33        TopicList.DataSource = dr;
 34        TopicList.DataTextField = "t_name";
 35        TopicList.DataValueField = "t_id";
 36        TopicList.DataBind();
 37        dr.Close();
 38    }
 39
 40    private void BindSubjectData(int tid)
 41    ...{
 42        ISubjects subject = new Subjects();
 43        SqlDataReader dr = subject.GetSubjectByTopic(tid);
 44        SubjectView.DataSource = dr;
 45        SubjectView.DataBind();
 46        dr.Close();
 47    }
 48
 49    protected void TopicList_SelectedIndexChanged(object sender, EventArgs e)
 50    ...{
 51        BindSubjectData(Int32.Parse(TopicList.SelectedValue));
 52    }
 53    protected void SubjectView_RowCommand(object sender, GridViewCommandEventArgs e)
 54    ...{
 55        if (Int32.TryParse(e.CommandArgument.ToString(), out sid) == false || e.CommandName == "")
 56        ...{
 57            Response.Write("<script>alert('没有接受到参数！');</script>");
 58            return;
 59        }
 60        ISubjects subject = new Subjects();
 61        switch (e.CommandName)
 62        ...{
 63            case "delete":
 64                subject.DeleteSubject(sid);
 65                Response.Write("<script>alert('删除投票项目成功！');</script>");
 66                BindSubjectData(Int32.Parse(TopicList.SelectedValue));
 67                break;
 68
 69            case "update":
 70                SqlDataReader dr = subject.GetSingleSubject(sid);
 71                if (dr.Read())
 72                ...{
 73                    lbl.Text = "修改投票项目";
 74                    name.Text = dr["s_name"].ToString();
 75                    AddUpdateBtn.Text = "修改投票";
 76                    AddUpdateBtn.CommandName = "update";
 77                    AddUpdateBtn.CommandArgument = dr["s_id"].ToString();
 78                }
 79                dr.Close();
 80                break;
 81        }
 82
 83    }
 84
 85    protected void SubjectView_RowDataBound(object sender, GridViewRowEventArgs e)
 86    ...{
 87        ImageButton imagebutton = (ImageButton)e.Row.FindControl("imagebtn");
 88        if (imagebutton != null)
 89            imagebutton.Attributes.Add("onclick", "return confirm('确定删除么？');");
 90    }
 91
 92    protected void AddUpdateBtn_Click(object sender, EventArgs e)
 93    ...{
 94        ISubjects subject = new Subjects();
 95        if (AddUpdateBtn.CommandName != "")
 96        ...{
 97            switch (AddUpdateBtn.CommandName)
 98            ...{
 99                case "add":
100                    subject.AddSubject(name.Text.Trim().ToString(), Int32.Parse(TopicList.SelectedValue));
101                    Response.Write("<script>alert('添加投票项目成功！');</script>");
102                    BindSubjectData(Int32.Parse(TopicList.SelectedValue));
103                    break;
104
105                case "update":
106                    subject.UpdateSubject(name.Text.Trim().ToString(), Int32.Parse(AddUpdateBtn.CommandArgument));
107                    Response.Write("<script>alert('更新投票项目成功！');</script>");
108                    BindSubjectData(Int32.Parse(TopicList.SelectedValue));
109                    break;
110            }
111        }
112    }
113   
114    protected void ChangeMode_Click(object sender, EventArgs e)
115    ...{
116        ISubjects subject = new Subjects();
117        subject.UpdateSubjectMode(Int32.Parse(SubjectView.DataKeys[SubjectView.SelectedRow.RowIndex].Value.ToString()));
118        Response.Write("<script>alert('更新模式成功！');</script>");
119        BindSubjectData(Int32.Parse(TopicList.SelectedValue));
120    }
121
122    protected void SubjectView_RowDeleting(object sender, GridViewDeleteEventArgs e)
123    ...{
124
125    }
126    protected void SubjectView_RowUpdating(object sender, GridViewUpdateEventArgs e)
127    ...{
128
129    }
130}
131