private void BindData()
    {
        pager.PageSize = PagingSize;

        DepartmentDal departmentDal = new DepartmentDal();
        string filter = null;
        if (ViewState["Filter"] != null)
            filter = ViewState["Filter"].ToString();
        pager.RecordCount = departmentDal.GetCount(filter);
        DataTable table = departmentDal.GetAll(pageIndex, PagingSize, filter);
        BindTable2GridView(gvMain, table);
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        //保存修改到数据库
        try
        {
            DepartmentDal departmentDal = new DepartmentDal();
            if (ViewState["OP"].ToString() == "ADD")
            {
                departmentDal.Insert(txtDepartmentName.Text, txtRemark.Text);
            }
            else
            {
                departmentDal.Save(txtDepartmentID.Text, txtDepartmentName.Text, txtRemark.Text);

            }
            JScript.Instance.ShowMessage(UpdatePanel1, "保存数据成功。");
        }
        catch (Exception ex)
        {
            JScript.Instance.ShowMessage(UpdatePanel1, string.Format("保存数据失败,原因:'{0}'", ex.Message));
        }
    }
 protected void btnDelete_Click(object sender, EventArgs e)
 {
     DepartmentDal departmentDal = new DepartmentDal();
     int deleteCount = 0;
     foreach (GridViewRow row in gvMain.Rows)
     {
         if (row.Cells[0].Controls.Count != 0 && ((CheckBox)row.Cells[0].Controls[0]).Checked)
         {
             departmentDal.Delete(row.Cells[2].Text);
             deleteCount++;
         }
     }
     if (deleteCount == 0)
         JScript.Instance.ShowMessage(UpdatePanel1, "请选择要删除的记录。");
     else
         JScript.Instance.ShowMessage(UpdatePanel1, "删除数据成功。");
     BindData();
 }