//删除 protected void lnkbtnDel_Click(object sender, EventArgs e) { string userid = (sender as LinkButton).CommandArgument; try { //获取被删除用户名 string DelUsername = SQLHelper.GetDataTable("select usr_login from tbl_usr where id = '" + userid + "'").Rows[0][0].ToString(); //删除上传文件表中的数据 SQLHelper.ExecuteNonQuery("delete from UploadFile where username = '******'"); //删除用户表数据 SQLHelper.ExecuteNonQuery("delete from tbl_usr where id = '" + userid + "' "); //记录日志 Log.writeLog(Request.Cookies["user"].Values["id"], Request.Cookies["user"].Values["name"], "Delete user", "Delete user:"******" by " + Request.Cookies["user"].Values["name"]); this.gvData.DataSource = SQLHelper.GetDataTable("select a.id,usr_login,role_na from tbl_usr a left join tbl_role b on a.role_id = b.id where 1=1 "); this.gvData.DataBind(); JScript.ShowMsg(this.PopupWin1, "Delete user successfully!"); } catch (System.Exception ex) { JScript.AjaxAlert(this.Page, "Sorry,there is an error! Reasons:" + ex.Message.ToString()); } }
protected void lnbGo_Click(object sender, EventArgs e) { if (Convert.ToInt32(txtGo.Text) <= 0 || Convert.ToInt32(txtGo.Text) > Convert.ToInt32(lblPages.Text)) { JScript.ShowMsg(PopupWin1, " 页码数非法!"); return; } lblCurpage.Text = txtGo.Text; Bind(GenerateDataTable(lblCurpage.Text)); }
protected void lnkbtnGoto_Click(object sender, EventArgs e) { if (Convert.ToInt32(txtPage.Text) <= 0) { JScript.ShowMsg(PopupWin1, " 页码数非法!"); return; } Pagesize = Convert.ToInt32(txtPage.Text); lblCurpage.Text = ""; }
public static void deleteFromGridView(GridView gv, string tableName, EeekSoft.Web.PopupWin PopupWin1) { int count = 0; if (gv.Rows.Count > 0) { for (int i = 0; i < gv.Rows.Count; i++) { CheckBox ck = gv.Rows[i].Cells[1].FindControl("chkSelect") as CheckBox; Label lb = gv.Rows[i].Cells[2].FindControl("lbID") as Label; if (ck.Checked) { SQLHelper.ExecuteNonQuery("delete from " + tableName + " where id = " + lb.Text); count++; } } } JScript.ShowMsg(PopupWin1, "Delete " + count.ToString() + " Records!"); Log.writeLog(System.Web.HttpContext.Current.Request.Cookies["user"].Values["id"], System.Web.HttpContext.Current.Request.Cookies["user"].Values["name"], "Delete " + tableName, "Count: " + count.ToString()); }