private void Delete(string id) { pnDetail.Visible = false; #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var clsIO = new clsIO(); var strSQL = new StringBuilder(); #endregion #region Procedure #region Delete Photo #region SQL Query strSQL.Append("SELECT "); strSQL.Append("Photo "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id + ";"); #endregion string photoDelete = clsSQL.Return(strSQL.ToString()); if (!string.IsNullOrEmpty(photoDelete)) { clsIO.FileExist(photoDelete, true); } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #region Delete Database #region SQL Query strSQL.Append("DELETE FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id + ";"); #endregion if (clsSQL.Execute(strSQL.ToString())) { ucColorBox1.Redirect(webDefault + clsDefault.QueryStringRemover(new string[] { "id", "command" })); } else { ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล"); return; } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #endregion }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["globalname"] != null && Request.QueryString["globalid"] != null) { BindDefault(); } else { ucColorBox1.Redirect( (Request.QueryString["globalpage"] != null ? Request.QueryString["globalpage"] + clsDefault.QueryStringRemover(new string[] { "globalid", "globalname", "globalpage" }) : "/"), "ไม่พบข้อมูลที่คุณต้องการ"); } } }