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