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 Manager_Vote : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17        if (!Page.IsPostBack) ...{
18
19            BindVote();
20        
21        }
22    }
23    protected void BindVote() ...{
24
25        DataListVote.DataSource = SqlHelper.ExcuteReadApdater("sys_SelectVote", CommandType.StoredProcedure, null);
26        DataListVote.DataKeyField = "Id";
27        DataListVote.DataBind();
28    
29    }
30    protected void DataListVote_CancelCommand(object source, DataListCommandEventArgs e)
31    ...{
32        DataListVote.EditItemIndex = -1;
33        BindVote();
34    }
35    protected void DataListVote_DeleteCommand(object source, DataListCommandEventArgs e)
36    ...{
37        int nId = int.Parse(DataListVote.DataKeys[e.Item.ItemIndex].ToString());
38        string txtName = ((TextBox)DataListVote.FindControl("UpdateName")).Text.ToString();
39        int txtTotal = int.Parse(((TextBox)DataListVote.FindControl("UpdateTotal")).Text.ToString());
40        int txtVis = int.Parse(((DropDownList)DataListVote.FindControl("UpdateVis")).SelectedValue.ToString());
41        SqlParameter[] paras =...{ new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@Name", SqlDbType.NVarChar, 20), new SqlParameter("@Total", SqlDbType.Int, 4), new SqlParameter("@Vis", SqlDbType.Bit) };
42        paras[0].Value = nId;
43        paras[1].Value = txtName;
44        paras[2].Value = txtTotal;
45        paras[3].Value = txtVis;
46        SqlHelper.ExcuteNonQurey("UPDATE [Vote] SET Name=@Name,Total=@Total,Vis=@Vis WHERE Id=@Id", CommandType.Text, paras);
47        DataListVote.EditItemIndex = -1;
48        BindVote();
49    }
50    protected void DataListVote_EditCommand(object source, DataListCommandEventArgs e)
51    ...{
52        DataListVote.EditItemIndex = e.Item.ItemIndex;
53        BindVote();
54    }
55    protected void DataListVote_UpdateCommand(object source, DataListCommandEventArgs e)
56    ...{
57        int nId = int.Parse(DataListVote.DataKeys[e.Item.ItemIndex].ToString());
58        SqlParameter[] paras =...{ new SqlParameter("@Id", SqlDbType.Int, 4) };
59        paras[0].Value = nId;
60        SqlHelper.ExcuteNonQurey("DELETE FROM [Vote] WHERE Id=@Id", CommandType.Text, paras);
61        BindVote();
62    }
63}
64