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
}
