using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; namespace WebUI { public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) BindGrid(); } protected void BindGrid() { BLL.EmployeeBLL empBLL = new BLL.EmployeeBLL(); dgdShowData.DataSource = empBLL.GetEmployee(); dgdShowData.DataBind(); } protected void btnSearch_Click(object sender, EventArgs e) { BLL.EmployeeBLL empBLL = new BLL.EmployeeBLL(); dgdShowData.DataSource = empBLL.GetEmployee(txtName.Text); dgdShowData.DataBind(); } protected void btnAdd_Click(object sender, EventArgs e) { Response.Redirect("EmployeeDetails.aspx?id=-1"); } protected void dgdShowData_RowDeleting(object sender, GridViewDeleteEventArgs e) { //删除一条数据 int id = (int)dgdShowData.DataKeys[e.RowIndex].Value; BLL.EmployeeBLL empBLL = new BLL.EmployeeBLL(); lblMsg.Text = empBLL.DeleteEmployee(id); BindGrid(); } protected void chkSelectAll_CheckedChanged(object sender, EventArgs e) { //全选操作 for (int i = 0; i < dgdShowData.Rows.Count; i++) { //CheckBox ch = (CheckBox)dgdShowData.Rows[i].FindControl("CheckBox1"); //ch.Checked=true; ((CheckBox)dgdShowData.Rows[i].FindControl("CheckBox1")).Checked = ((CheckBox)sender).Checked; } } protected void btnDeleteAll_Click(object sender, EventArgs e) { //批量删除 string ids = ""; for (int i = 0; i < dgdShowData.Rows.Count; i++) { if (((CheckBox)dgdShowData.Rows[i].FindControl("CheckBox1")).Checked) ids += dgdShowData.DataKeys[i].Value + ",";//把想要添加的键值添加到数组中 } BLL.EmployeeBLL empBLL = new BLL.EmployeeBLL(); ids = ids.Substring(0, ids.Length - 1); lblMsg.Text = empBLL.DeleteEmployee(ids); BindGrid(); } protected void btnDelete_Click(object sender, EventArgs e) { //乱添加的 } } } 把存在数组中的id的数据删除 using System; using System.Data; namespace DAL { public class EmployeeDAL { public DataTable GetEmployee() { SQLHelp db = new SQLHelp(); return db.FillTable("select * from vw_Employee"); } public DataTable GetEmployee(int id) { SQLHelp db = new SQLHelp(); return db.FillTable("select * from vw_Employee where [id]=" + id); } public DataTable GetEmployee(string name) { SQLHelp db = new SQLHelp(); return db.FillTable("select * from vw_Employee where [name] like '%" + name + "%'"); } public string InsertEmployee(Model.Employee emp) { string sql = "insert into employee values('" + emp.Name + "','" + emp.Gender + "','" + emp.Birthday + "','" + emp.Phone + "','" + emp.Email + "'," + emp.DepID + ",'" + emp.Remark + "')"; SQLHelp db = new SQLHelp(); int i = db.ExecQuery(sql); switch (i) { case -2: sql = "数据库连接异常!请检查您的数据库或联系管理员!"; break; case -1: sql = "数据库操作异常!请检查您的数据或联系管理员!"; break; case 0: sql = "没有影响到任何数据!"; break; default: sql = "成功添加" + i + "条数据!"; break; } return sql; } public string UpdateEmployee(Model.Employee emp) { string sql = "update employee set [Name]='" + emp.Name + "' where [ID]=" + emp.ID; SQLHelp db = new SQLHelp(); int i = db.ExecQuery(sql); switch (i) { case -2: sql = "数据库连接异常!请检查您的数据库或联系管理员!"; break; case -1: sql = "数据库操作异常!请检查您的数据或联系管理员!"; break; case 0: sql = "没有影响到任何数据!"; break; default: sql = "成功修改" + i + "条数据!"; break; } return sql; } public string DeleteEmployee(int id) { string sql = "delete employee where [ID]=" + id; SQLHelp db = new SQLHelp(); int i = db.ExecQuery(sql); switch (i) { case -2: sql = "数据库连接异常!请检查您的数据库或联系管理员!"; break; case -1: sql = "数据库操作异常!请检查您的数据或联系管理员!"; break; case 0: sql = "没有影响到任何数据!"; break; default: sql = "成功删除" + i + "条数据!"; break; } return sql; } public string DeleteEmployee(string ids)//删除多参数的键值······· { string sql = "delete employee where [ID] in (" + ids + ")"; SQLHelp db = new SQLHelp(); int i = db.ExecQuery(sql); switch (i) { case -2: sql = "数据库连接异常!请检查您的数据库或联系管理员!"; break; case -1: sql = "数据库操作异常!请检查您的数据或联系管理员!"; break; case 0: sql = "没有影响到任何数据!"; break; default: sql = "成功删除" + i + "条数据!"; break; } return sql; } } }