//查看共有多少条数据
private int GetTotalCount()
...{
//try
//{
OracleConnection conn = this.Conn();

conn.Open();
OracleCommand cmd = new OracleCommand( "select count(*) from Supplier ", conn);
int count = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
return count;
//}
//catch
//{
// return 0;
//}
}

//弹出警告窗口
public void Alert(string str_Message, Page page)
...{
page.RegisterStartupScript( " ", " <script >alert( &apos; " + str_Message + " &apos;); </script > ");
}

//弹出确认对话框
public void Confirm(string str_Message, string btn, Page page)
...{
page.RegisterStartupScript( " ", " <script > if (confirm( &apos; " + str_Message + " &apos;)==true){document.forms(0). " + btn + ".click();} </script > ");
}

protected void cbAllSelect_CheckedChanged(object sender, EventArgs e)
...{
for(int i=0;i <this.gvSupplier.Rows.Count;i++)
...{
CheckBox cbSelect=(CheckBox)(gvSupplier.Rows[i].Cells[10].FindControl( "cbSelect "));
cbSelect.Checked=this.cbAllSelect.Checked;
}
}

//当点击删除按钮时删除所有checkbox被选中的数据
protected void btnDel_Click(object sender, EventArgs e)
...{
//如果用户确认将触发btnRealDel的事件
this.Confirm( "你真的要删除你所选的数据么？ ", "btnRealDel ", this.Page);

}

//真实的删除操作
public void btnRealDel_Click(object sender, EventArgs e)
...{
int count = 0;
for (int i = 0; i < this.gvSupplier.Rows.Count; i++)
...{
CheckBox myCb = (CheckBox)(this.gvSupplier.Rows[i].Cells[10].FindControl( "cbSelect "));
if (myCb.Checked)
...{
count++;
HyperLink hl = (HyperLink)(this.gvSupplier.Rows[i].Cells[7].Controls[0]);
int suppId = int.Parse(hl.Text.ToString());
string sqlString = "delete from Supplier where SuppId= " + suppId;
this.ExecuteSql(sqlString);
}
}
if (count > 0)
...{
this.Alert( "你成功删除了 " + count + "条数据 ", this.Page);
this.BindGvSupplier();
}
}