当前文件路径：Votes/ItemManage.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 ItemManage : System.Web.UI.Page
 14...{
 15    private int iid;
 16    protected void Page_Load(object sender, EventArgs e)
 17    ...{
 18        if (!Page.IsPostBack)                       
 19        ...{
 20            BindTopicData();
 21            if (TopicList.Items.Count > 0)
 22            ...{
 23                TopicList.SelectedIndex = 0;          /**////使SubjectLIst绑定TopicList的第一项
 24                BindSubjectData(Int32.Parse(TopicList.SelectedValue));
 25                if (SubjectList.Items.Count > 0)
 26                ...{
 27                    SubjectList.SelectedIndex = 0;
 28                    BindItemData(Int32.Parse(SubjectList.SelectedValue));
 29                }
 30            }
 31        }
 32    }
 33
 34    private void BindTopicData()
 35    ...{
 36        ITopics topic = new Topics();
 37        SqlDataReader dr = topic.GetAllTopic();
 38        TopicList.DataSource = dr;
 39        TopicList.DataTextField = "t_name";
 40        TopicList.DataValueField = "t_id";
 41        TopicList.DataBind();
 42        dr.Close();
 43    }
 44
 45    private void BindSubjectData(int tid)
 46    ...{
 47        ISubjects subject = new Subjects();
 48        SqlDataReader dr=subject.GetSubjectByTopic(tid);
 49        SubjectList.DataSource=dr;
 50        SubjectList.DataTextField = "s_name";
 51        SubjectList.DataValueField = "s_id";
 52        SubjectList.DataBind();
 53        dr.Close();
 54    }
 55
 56    private void BindItemData(int sid)
 57    ...{
 58        IItems item = new Items();
 59        SqlDataReader dr = item.GetItemBySubject(sid);
 60        ItemView.DataSource = dr;
 61        ItemView.DataBind();
 62        dr.Close();
 63    }
 64    protected void TopicList_SelectedIndexChanged(object sender, EventArgs e)
 65    ...{
 66        BindSubjectData(Int32.Parse(TopicList.SelectedValue));
 67        if (SubjectList.Items.Count > 0)
 68        ...{
 69            SubjectList.Visible = true;                     /**////当SubjectList.Items,Count>0时,SubjectList可见
 70            SubjectList.SelectedIndex = 0;                 /**////当TopicList改变时，SubjectList选中第一项
 71            BindItemData(Int32.Parse(SubjectList.SelectedValue));
 72        }
 73        else
 74        ...{
 75            SubjectList.Visible = false;                   /**////当SubjectList.Items,Count==0时,SubjectList不可见
 76            ItemView.DataSource = null;                    /**////当SubjectList.Items,Count==0时，去掉ItemView留下的纪录
 77            ItemView.DataBind();
 78        }
 79    }
 80    protected void SubjectList_SelectedIndexChanged(object sender, EventArgs e)
 81    ...{
 82        BindItemData(Int32.Parse(SubjectList.SelectedValue));
 83    }
 84
 85    protected void ItemView_RowDataBound(object sender, GridViewRowEventArgs e)
 86    ...{
 87        ImageButton imagebutton = (ImageButton)e.Row.FindControl("imageButton");
 88        if (imagebutton != null)
 89            imagebutton.Attributes.Add("onclick","return confirm('确定删除么？');");
 90    }
 91
 92    protected void ItemView_RowCommand(object sender, GridViewCommandEventArgs e)
 93    ...{
 94        if (Int32.TryParse(e.CommandArgument.ToString(), out iid) == false || e.CommandName == "")
 95        ...{
 96            Response.Write("<script>alert('没有接收到参数！');</script>");
 97            return;
 98        }
 99
100        IItems item=new Items();
101        switch (e.CommandName)
102        ...{
103            case "delete":
104                item.DeleteItem(iid);
105                Response.Write("<script>alert('删除成功！');</script>");
106                BindItemData(Int32.Parse(SubjectList.SelectedValue));
107                break;
108
109            case "update":
110                SqlDataReader dr = item.GetSingleItem(iid);
111                if (dr.Read())
112                ...{
113                    title.Text = "修改投票内容";
114                    name.Text=dr["i_name"].ToString();
115                    AddUpdatebtn.Text = "修改投票";
116                    AddUpdatebtn.CommandName = "update";
117                    AddUpdatebtn.CommandArgument = dr["i_id"].ToString();
118                }
119                break;
120        }
121    }
122    
123    protected void AddUpdatebtn_Click(object sender, EventArgs e)
124    ...{
125        if (AddUpdatebtn.CommandName != "")
126        ...{
127            IItems item = new Items();
128            switch (AddUpdatebtn.CommandName)
129            ...{
130                case "add" :
131                    try
132                    ...{
133                        item.AddItem(name.Text.Trim().ToString(),Int32.Parse(SubjectList.SelectedValue));
134                        Response.Write("<script>alert('新增成功！');</script>");
135                        BindItemData(Int32.Parse(SubjectList.SelectedValue));
136                    }
137                    catch (Exception ex)
138                    ...{
139                        Response.Redirect("ErrorPage.aspx?ErrorUrl=" + Request.Url.ToString().Replace("<br>", "").Replace("\n", "") + "&ErrorMsg=" + ex.Message.Replace("<br>", "").Replace("\n", ""));
140                    }
141                    break;
142
143                case "update":
144                    try
145                    ...{   
146                        item.UpdateItem(name.Text.Trim().ToString(),Int32.Parse(AddUpdatebtn.CommandArgument.ToString()));
147                        Response.Write("<script>alert('更新成功！');</script>");
148                        BindItemData(Int32.Parse(SubjectList.SelectedValue));
149                    }
150                    catch (Exception ex)
151                    ...{
152                        Response.Redirect("ErrorPage.aspx?ErrorUrl=" + Request.Url.ToString().Replace("<br>", "").Replace("\n", "") + "&ErrorMsg=" + ex.Message.Replace("<br>", "").Replace("\n", ""));
153                    }
154                break;
155            }
156        }
157    }
158    protected void ItemView_RowDeleting(object sender, GridViewDeleteEventArgs e)
159    ...{
160        /**////
161    }
162    protected void ItemView_RowUpdating(object sender, GridViewUpdateEventArgs e)
163    ...{
164        /**////
165    }
166}
167