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(); }