protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { if (clsDefault.QueryStringChecker("command") == "edit") { vdPhoto.Enabled = false; BindControl(); BindDetail(Request.QueryString["id"].ToString()); } else if (clsDefault.QueryStringChecker("command") == "delete") { Delete(Request.QueryString["id"].ToString()); } else { ucColorBox1.Redirect("/" + webDefault, "ไม่พบหน้าเว็บที่คุณต้องการ"); } } else { BindControl(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { #region Procedure if (Request.QueryString["id"] != null) { if (clsDefault.QueryStringChecker("command") == "edit") { ucColorBox1.SizeChange(); vdPhoto.Enabled = false; BindDetail(Request.QueryString["id"].ToString()); } else if (clsDefault.QueryStringChecker("command") == "delete") { Delete(Request.QueryString["id"].ToString()); } else { ucColorBox1.Redirect("/Management/" + webDefault, "ไม่พบหน้าเว็บที่คุณต้องการ"); } } else { ucColorBox1.SizeChange(); } #endregion } }
protected void BindDefault() { gvDefault.Visible = true; pnDGHeader.Visible = true; #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); #endregion #region Header Builder lblHeader.Text = clsSQL.Return("SELECT Name FROM MedicalCenterGroup WHERE UID=" + clsDefault.QueryStringChecker("group"), dbType, cs); #endregion #region SQL Query strSQL.Append("SELECT "); strSQL.Append(tableDefault + ".UID,"); strSQL.Append(tableDefault + ".Name,"); strSQL.Append(tableDefault + ".Detail,"); strSQL.Append(tableDefault + ".MWhen,"); strSQL.Append(tableDefault + ".Sort,"); strSQL.Append(tableDefault + ".Active,"); strSQL.Append("Language.Name LanguageName,"); strSQL.Append("Language.Icon LanguageIcon "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("INNER JOIN Language ON " + tableDefault + ".LanguageUID=Language.UID "); #region Where strSQL.Append("WHERE "); strSQL.Append("MedicalCenterGroupUID=" + clsDefault.QueryStringChecker("group") + " "); #endregion strSQL.Append("ORDER BY "); strSQL.Append(tableDefault + ".Sort,"); strSQL.Append("Language.Sort"); #endregion #region Data Builder dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); strSQL.Length = 0; strSQL.Capacity = 0; if (dt != null && dt.Rows.Count > 0) { lblDG.Text = ""; gvDefault.DataSource = dt; if (Request.QueryString["page"] != null) { try { gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()); } catch (Exception ex) { gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1; } } gvDefault.DataBind(); dt = null; } else { pnDGHeader.Visible = false; lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info); } #endregion }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { if (clsDefault.QueryStringChecker("command") == "edit") { ucColorBox1.SizeChange(); vdPhoto.Enabled = false; UserGroupBuilder(); BindDetail(Request.QueryString["id"].ToString()); } else if (clsDefault.QueryStringChecker("command") == "delete") { Delete(Request.QueryString["id"].ToString()); } else { ucColorBox1.Redirect("/", "ไม่พบหน้าเว็บที่คุณต้องการ"); } } else { txtPassword.Enabled = true; vdPassword.Enabled = true; UserGroupBuilder(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { if (clsDefault.QueryStringChecker("command") == "edit") { BindDetail(Request.QueryString["id"].ToString()); } else if (clsDefault.QueryStringChecker("command") == "delete") { Delete(Request.QueryString["id"].ToString()); } else { ucColorBox1.Redirect("/Management/" + webDefault, "ไม่พบหน้าเว็บที่คุณต้องการ"); } } else { //ucColorBox1.Redirect("/Management/Content.aspx", "ไม่พบหน้าเว็บที่คุณต้องการ"); } } }
protected void BindDefault() { dlDefault.Visible = true; pnDGHeader.Visible = true; #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); #endregion #region Header Builder lblHeader.Text = clsSQL.Return("SELECT Name FROM " + clsDefault.QueryStringChecker("globalname") + " WHERE UID=" + clsDefault.QueryStringChecker("globalid"), dbType, cs); #endregion #region SQL Query strSQL.Append("SELECT "); strSQL.Append(tableDefault + ".UID,"); strSQL.Append(tableDefault + ".PhotoPreview,"); strSQL.Append(tableDefault + ".Photo,"); strSQL.Append(tableDefault + ".Name,"); strSQL.Append(tableDefault + ".Detail,"); strSQL.Append(tableDefault + ".[View],"); strSQL.Append(tableDefault + ".MWhen,"); strSQL.Append(tableDefault + ".Sort,"); strSQL.Append(tableDefault + ".Active "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " "); #region Where strSQL.Append("WHERE "); strSQL.Append("GlobalName='" + clsDefault.QueryStringChecker("globalname") + "' "); strSQL.Append("AND GlobalUID=" + clsDefault.QueryStringChecker("globalid") + " "); #endregion strSQL.Append("ORDER BY "); strSQL.Append(tableDefault + ".Sort"); #endregion #region Data Builder dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); strSQL.Length = 0; strSQL.Capacity = 0; if (dt != null && dt.Rows.Count > 0) { lblDG.Text = ""; dlDefault.DataSource = dt; dlDefault.DataBind(); dt = null; } else { pnDGHeader.Visible = false; lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info); } #endregion }
protected void BindDefault() { dlDefault.Visible = true; pnDGHeader.Visible = true; #region Variable var strSQL = new StringBuilder(); var dt = new DataTable(); var clsSQL = new clsSQL(clsGlobal.dbType, clsGlobal.cs); #endregion #region Procedure #region Header Builder lblHeader.Text = clsSQL.Return("SELECT Name FROM " + tableParrent + " WHERE UID=" + clsDefault.QueryStringChecker("group")); #endregion #region SQL Query strSQL.Append("SELECT "); strSQL.Append("A.UID,"); strSQL.Append("A.PhotoPreview,"); strSQL.Append("A.Photo,"); strSQL.Append("A.Name,"); strSQL.Append("A.Detail,"); strSQL.Append("A.[View],"); strSQL.Append("A.MWhen,"); strSQL.Append("A.Sort,"); strSQL.Append("A.StatusFlag "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " A "); #region Where strSQL.Append("WHERE "); strSQL.Append("PhotoGalleryGroupUID=" + clsDefault.QueryStringChecker("group") + " "); #endregion strSQL.Append("ORDER BY "); strSQL.Append("A.Sort"); #endregion #region Data Builder dt = clsSQL.Bind(strSQL.ToString()); strSQL.Length = 0; strSQL.Capacity = 0; if (dt != null && dt.Rows.Count > 0) { lblDG.Text = ""; dlDefault.DataSource = dt; dlDefault.DataBind(); dt = null; } else { pnDGHeader.Visible = false; lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info); } #endregion #endregion }