public partial class toupiao : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dataBind();
}
}
void dataBind()
{
db mydb = new db();
string strSql = "select * from voteMaster";
DataSet ds = mydb.getDs(strSql);
this.GridView1.AllowPaging = true;
this.GridView1.PageSize = 5;
this.GridView1.DataSource = ds.Tables["admin"].DefaultView;
this.GridView1.DataBind();
if (this.GridView1.PageIndex == 0)
{
this.btnPre.Enabled = false;
this.btnFirst.Enabled = false;
}
else
{
this.btnPre.Enabled = true;
this.btnFirst.Enabled = true;
}
if (this.GridView1.PageIndex == this.GridView1.PageCount - 1)
{
this.btnNext.Enabled = false;
this.btnLast.Enabled = false;
}
else
{
this.btnLast.Enabled = true;
this.btnNext.Enabled = true;
}
}
protected void btnFirst_Click(object sender, EventArgs e)
{
this.GridView1.PageIndex = 0;
dataBind();
}
protected void btnLast_Click(object sender, EventArgs e)
{
this.GridView1.PageIndex = this.GridView1.PageCount - 1;
dataBind();
}
protected void btnPre_Click(object sender, EventArgs e)
{
this.GridView1.PageIndex = Math.Max(this.GridView1.PageIndex - 1, 0);
dataBind();
}
protected void btnNext_Click(object sender, EventArgs e)
{
this.GridView1.PageIndex = Math.Min(this.GridView1.PageIndex + 1, this.GridView1.PageCount - 1);
dataBind();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
this.GridView1.EditIndex = e.NewEditIndex;
dataBind();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
this.GridView1.EditIndex = -1;
dataBind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int id = Convert.ToInt32(this.GridView1.DataKeys[e.RowIndex]["id"].ToString());
string voteTitle = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].FindControl("txtVoteTitle")).Text.ToString();
string strSql = "update voteMaster set voteTitle = '" + voteTitle + "' where id='" + id + "'";
db mydb = new db();
int row = mydb.executeNonquery(strSql);
if (row == 1)
{
Response.Write("<script language='javascript'>alert('数据更新成功！')</script>");
this.GridView1.EditIndex = -1;
dataBind();
}
else
Response.Write("<script language='javascript'>alert('数据更新失败！')</script>");
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(this.GridView1.DataKeys[e.RowIndex]["id"].ToString());
string strSql = "delete from voteMaster where id ='" + id + "'";
db mydb = new db();
mydb.executeNonquery(strSql);
string sql = "delete from voteDetails where id = '" + id + "'";
mydb.executeNonquery(strSql);
dataBind();
}
protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView GridView2 = sender as GridView;
GridView2.EditIndex = e.NewEditIndex;
dataBind();
}
protected void GridView2_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView GridView2 = sender as GridView;
GridView2.EditIndex = -1;
dataBind();
}
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridView GridView2 = sender as GridView;
int id = Convert.ToInt32(GridView2.DataKeys[e.RowIndex]["voteDetailsID"].ToString());
string strSql = "delete from voteDetails where voteDetailsID='" + id + "'";
db mydb = new db();
mydb.executeNonquery(strSql);
dataBind();
}
protected void GridView1_DataBound(object sender, EventArgs e)
{
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
GridView GridView2 = (GridView)e.Row.FindControl("GridView2");
if (GridView2 != null)
{
int id = Convert.ToInt32(this.GridView1.DataKeys[e.Row.RowIndex]["id"].ToString());
string strSql = "select voteDetailsID,voteItem,voteNum from voteDetails where id ='" + id + "'";
db mydb = new db();
DataSet ds = mydb.getDs(strSql);
GridView2.DataSource = ds.Tables[0].DefaultView;
GridView2.DataBind();
}
}
}
protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridView GridView2 = sender as GridView;
int id = Convert.ToInt32(GridView2.DataKeys[e.RowIndex]["voteDetailsID"].ToString());
string voteItem = ((TextBox)GridView2.Rows[e.RowIndex].Cells[3].FindControl ("txtVoteItem")).Text.ToString();
string strSql = "update voteDetails set voteItem='" + voteItem + "' where voteDetailsID ='" + id + "'";
db mydb = new db();
mydb.executeNonquery(strSql);
dataBind();
}
}
