protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(_validateGroup)) { vldCaptcha.ValidationGroup = _validateGroup; vldRequire.ValidationGroup = _validateGroup; } vldCaptcha.ErrorMessage = clsDefault.AlertMessageColor(_errorMessage, clsDefault.AlertType.Fail); vldRequire.ErrorMessage = clsDefault.AlertMessageColor(_errorMessage, clsDefault.AlertType.Fail); GetCaptcha(); }
private void DefaultBuilder() { gvDefault.Visible = true; pnDetail.Visible = false; #region Variable var strSQL = new StringBuilder(); var dt = new DataTable(); #endregion #region Procedure #region SQLQuery strSQL.Append("SELECT "); strSQL.Append("B.Name LanguageName,"); strSQL.Append("A.UID,"); strSQL.Append("A.PackageName Subject,"); strSQL.Append("A.DetailSub,"); strSQL.Append("A.PicThumbnail,"); strSQL.Append("A.UnitPrice,"); strSQL.Append("A.ActiveDateFrom,"); strSQL.Append("A.ActiveDateTo,"); strSQL.Append("A.DepartmentUID,"); strSQL.Append("A.StatusFlag "); strSQL.Append("FROM "); strSQL.Append("Package A INNER JOIN Language B ON A.LanguageUID=B.UID AND B.Active='1' "); if (clsSecurity.LoginChecker("admin")) { strSQL.Append("ORDER BY "); strSQL.Append("A.MWhen DESC;"); } else { strSQL.Append("WHERE "); strSQL.Append("StatusFlag='A' "); strSQL.Append("AND B.Name='" + clsLanguage.LanguageCurrent + "' "); strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= GETDATE()) "); strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= GETDATE()) "); strSQL.Append("ORDER BY "); strSQL.Append("A.MWhen DESC;"); } #endregion dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); if (dt != null && dt.Rows.Count > 0) { gvDefault.DataSource = dt; gvDefault.DataBind(); } else { lblDefault.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูล"); } #endregion }
protected void BindDefault() { gvDefault.Visible = true; pnDGHeader.Visible = true; #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); #endregion #region SQL Query strSQL.Append("SELECT "); strSQL.Append(tableDefault + ".UID,"); strSQL.Append(tableDefault + ".HN,"); strSQL.Append(tableDefault + ".PName,"); strSQL.Append(tableDefault + ".FName,"); strSQL.Append(tableDefault + ".LName,"); strSQL.Append(tableDefault + ".Email,"); strSQL.Append(tableDefault + ".Phone,"); strSQL.Append(tableDefault + ".DoctorName,"); strSQL.Append(tableDefault + ".DepartmentName,"); strSQL.Append(tableDefault + ".Comment,"); strSQL.Append(tableDefault + ".BirthDate,"); strSQL.Append(tableDefault + ".NID,"); strSQL.Append(tableDefault + ".AppointmentDate,"); strSQL.Append(tableDefault + ".MWhen,"); strSQL.Append(tableDefault + ".Sort,"); strSQL.Append(tableDefault + ".Active "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("ORDER BY "); strSQL.Append(tableDefault + ".Sort"); strSQL.Append("," + tableDefault + ".MWhen DESC"); #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 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 btLogin_Click(object sender, EventArgs e) { #region Variable var clsSQL = new clsSQL(); var clsDefault = new clsDefault(); var clsColorBox = new clsColorBox(); #endregion #region Procedure if (clsSecurity.LoginChecker( clsSQL.CodeFilter(txtUsername.Text), clsSQL.CodeFilter(txtPassword.Text), cbEnableCookie.Checked)) { //ucColorBox.Redirect(Request.RawUrl, "เข้าสู่ระบบแล้ว"); Response.Redirect(Request.RawUrl); } else { var script = "document.getElementById('dvUCLogon').scrollIntoView(true);"; Page.ClientScript.RegisterStartupScript(Page.GetType(), "ucColorBoxScroller", script, true); ucColorBox.Alert("Login Alert", "ไม่พบข้อมูลที่คุณกรอก", AlertImage: global::ucColorBox.Alerts.Fail); lblLogin.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่คุณกรอก", clsDefault.AlertType.Warn); } #endregion }
protected void DefaultBuilder() { gvDefault.Visible = true; pnDGHeader.Visible = true; #region Variable var strSQL = new StringBuilder(); var dt = new DataTable(); #endregion #region Procedure #region SQL Query strSQL.Append("SELECT "); strSQL.Append("A.UID,"); strSQL.Append("A.Photo,"); strSQL.Append("A.Name,"); strSQL.Append("A.Detail,"); strSQL.Append("A.Type,"); 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("Type='Progress' "); strSQL.Append("Type=Type "); #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 = ""; gvDefault.DataSource = dt; #region PageBuilder if (Request.QueryString["page"] != null) { try { gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()); } catch (Exception) { gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1; } } #endregion gvDefault.DataBind(); dt = null; } else { pnDGHeader.Visible = false; lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info); } #endregion #endregion }
protected void btSubmit_Click(object sender, EventArgs e) { #region Variable string outMail = ""; #endregion if (txtFromName.Text.Trim().Length > 0 && txtFromPhone.Text.Trim().Length > 0 && txtFromEmail.Text.Trim().Length > 0 && txtMessage.Text.Trim().Length > 0) { if (clsMail.SendTemplate( "Feedback", clsMail.GetEmailList("AutoSystemFrom"), clsMail.GetEmailList("FeedbackTo"), new string[, ] { { "[FromName]", txtFromName.Text }, { "[FromPhone]", txtFromPhone.Text }, { "[FromEmail]", txtFromEmail.Text }, { "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") }, { "[Message]", txtMessage.Text } }, out outMail)) { txtFromName.Text = ""; txtFromEmail.Text = ""; txtFromPhone.Text = ""; txtMessage.Text = ""; //lblAlert.Text = clsDefault.AlertMessageColor("ระบบได้รับข้อความของคุณแล้ว"); //lblAlert.Focus(); ucColorBox1.Redirect("/Feedback/", "ได้รับข้อความของคุณแล้ว"); } else { lblAlert.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะพยายามส่งอีเมล์<br/>" + outMail, clsDefault.AlertType.Fail); lblAlert.Focus(); } } else { lblAlert.Text = clsDefault.AlertMessageColor("กรุณากรอกข้อมูลให้ครบก่อนค่ะ", clsDefault.AlertType.Warn); } }
protected void BindDefault() { gvDefault.Visible = true; pnDGHeader.Visible = true; StringBuilder strSQL = new StringBuilder(); #region SQL Query strSQL.Append("SELECT "); strSQL.Append("Content.UID,"); strSQL.Append("Content.Name,"); strSQL.Append("Content.Detail,"); strSQL.Append("Content.MWhen,"); strSQL.Append("Content.Active,"); strSQL.Append("Language.Name LanguageName,"); strSQL.Append("Language.Icon LanguageIcon "); strSQL.Append("FROM "); strSQL.Append("Content "); strSQL.Append("INNER JOIN Language ON Content.LanguageUID=Language.UID "); strSQL.Append("ORDER BY "); strSQL.Append("Content.Name,"); strSQL.Append("Language.Sort"); #endregion DataTable dt = new DataTable(); 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); } strSQL.Length = 0; strSQL.Capacity = 0; }
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 }
private void GalleryBuilder() { #region Variable bool errorCheck = false; #endregion #region Data Builder if (_source != null && _source.Rows.Count > 0) { lblGallery.Text = ""; #region Error Check if (!_source.Columns.Contains(_sourceFieldName) && _visible) { lblGallery.Text += "<div>ไม่พบคอลัม " + _sourceFieldName + " ใน Source ที่ส่งมา</div>"; errorCheck = true; } if (!_source.Columns.Contains(_sourceFieldDetail) && _visible) { lblGallery.Text += "<div>ไม่พบคอลัม " + _sourceFieldDetail + " ใน Source ที่ส่งมา</div>"; errorCheck = true; } if (!_source.Columns.Contains(_sourceFieldPhoto) && _visible) { lblGallery.Text += "<div>ไม่พบคอลัม " + _sourceFieldPhoto + " ใน Source ที่ส่งมา</div>"; errorCheck = true; } if (!_source.Columns.Contains(_sourceFieldPhotoPreview) && _visible) { lblGallery.Text += "<div>ไม่พบคอลัม " + _sourceFieldPhotoPreview + " ใน Source ที่ส่งมา</div>"; errorCheck = true; } if (errorCheck) { return; } #endregion dlGallery.RepeatColumns = _repeatColumns; dlGallery.DataSource = _source; dlGallery.DataBind(); dlGallery.Visible = _visible; } else { if (_visible) { lblGallery.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลใน Source", clsDefault.AlertType.Warn); } } #endregion }
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 btLogin_Click(object sender, EventArgs e) { clsSQL clsSQL = new clsSQL(); clsDefault clsDefault = new clsDefault(); if (clsSecurity.LoginChecker( clsSQL.CodeFilter(txtUsername.Text), clsSQL.CodeFilter(txtPassword.Text), cbEnableCookie.Checked)) { //LoginChecker(); Response.Redirect(Request.RawUrl); } else { lblLogin.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่คุณกรอก", clsDefault.AlertType.Warn); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (_dataSource != null && _dataSource.Rows.Count > 0) { lblTitle.Text = _title; gvDefault.PageSize = _pageSize; gvDefault.DataSource = _dataSource; gvDefault.DataBind(); gvDefault.BottomPagerRow.Visible = true; } else { clsDefault clsDefault = new clsDefault(); lblMessage.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูล", clsDefault.AlertType.Warn); pnGVHeader.Visible = false; } } }
private void WebboardTypeBuilder() { #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); #endregion #region Data Builder #region SQL Query strSQL.Append("SELECT "); strSQL.Append("UID,"); strSQL.Append("Name,"); strSQL.Append("Detail,"); strSQL.Append("Active "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " "); if (clsSecurity.LoginGroup != "Admin") { strSQL.Append("WHERE "); strSQL.Append("Active='1' "); } strSQL.Append("ORDER BY "); strSQL.Append("Sort,Name"); #endregion dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); if (dt != null && dt.Rows.Count > 0) { gvDefault.Visible = true; gvDefault.DataSource = dt; gvDefault.DataBind(); lblDefault.Text = ""; } else { gvDefault.Visible = false; lblDefault.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(); #endregion #region SQL Query #region HealthPackage strSQL.Append("SELECT "); strSQL.Append("UID,Name,PicThumbnail Photo,'HealthPackage' GlobalName "); strSQL.Append("FROM "); strSQL.Append("HealthPackage "); strSQL.Append("WHERE "); strSQL.Append("StatusFlag='A' "); strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= CONVERT(DATE,GETDATE())) "); strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= CONVERT(DATE,GETDATE())) "); #endregion strSQL.Append("UNION ALL "); #region Package strSQL.Append("SELECT "); strSQL.Append("UID,PackageName Name,PicThumbnail Photo,'Package' GlobalName "); strSQL.Append("FROM "); strSQL.Append("Package "); strSQL.Append("WHERE "); strSQL.Append("StatusFlag='A' "); strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= CONVERT(DATE,GETDATE())) "); strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= CONVERT(DATE,GETDATE())) "); #endregion strSQL.Append("UNION ALL "); #region Event strSQL.Append("SELECT "); strSQL.Append("UID,Subject Name,PicThumbnail Photo,'Event' GlobalName "); strSQL.Append("FROM "); strSQL.Append("Event "); strSQL.Append("WHERE "); strSQL.Append("StatusFlag='A' "); strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= CONVERT(DATE,GETDATE())) "); strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= CONVERT(DATE,GETDATE())) "); #endregion strSQL.Append("UNION ALL "); #region Promotion strSQL.Append("SELECT "); strSQL.Append("UID,PromotionName Name,PicThumbnail Photo,'Promotion' GlobalName "); strSQL.Append("FROM "); strSQL.Append("Promotion "); strSQL.Append("WHERE "); strSQL.Append("StatusFlag='A' "); strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= CONVERT(DATE,GETDATE())) "); strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= CONVERT(DATE,GETDATE())) "); #endregion strSQL.Append("UNION ALL "); #region News strSQL.Append("SELECT "); strSQL.Append("UID,Subject Name,PicThumbnail Photo,'News' GlobalName "); strSQL.Append("FROM "); strSQL.Append("News "); strSQL.Append("WHERE "); strSQL.Append("StatusFlag='A' "); strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= CONVERT(DATE,GETDATE())) "); strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= CONVERT(DATE,GETDATE())) "); #endregion #endregion #region Data Builder dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); strSQL.Length = 0; strSQL.Capacity = 0; if (dt != null && dt.Rows.Count > 0) { DataColumn dc = dt.Columns.Add("Choose", typeof(string)); #region HighlightBuilder for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["Choose"] = HighlightFinder( dt.Rows[i]["UID"].ToString(), dt.Rows[i]["GlobalName"].ToString()); } dt.AcceptChanges(); #endregion DataView dv = new DataView(dt); dv.Sort = "Choose DESC"; dt = dv.ToTable(); lblDG.Text = ""; dlDefault.DataSource = dt; dlDefault.DataBind(); dt = null; } else { pnDGHeader.Visible = false; lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info); } #endregion }
protected void BindDefault() { gvDefault.Visible = true; pnDGHeader.Visible = true; #region Variable var strSQL = new StringBuilder(); var dt = new DataTable(); #endregion #region Procedure #region SQL Query strSQL.Append("SELECT "); strSQL.Append("A.UserGroupUID,"); strSQL.Append("B.Name AS UserGroupName,"); strSQL.Append("A.UID,"); strSQL.Append("A.Photo,"); strSQL.Append("A.Username,"); strSQL.Append("A.PName,"); strSQL.Append("A.FName,"); strSQL.Append("A.LName,"); strSQL.Append("A.Phone,"); strSQL.Append("A.Mobile,"); strSQL.Append("A.Email,"); strSQL.Append("A.Sort,"); strSQL.Append("A.StatusFlag "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " A "); strSQL.Append("INNER JOIN P5_UserGroup B "); strSQL.Append("ON A.UserGroupUID=B.UID "); strSQL.Append("ORDER BY B.Sort,A.Sort;"); #endregion dt = clsSQL.Bind(strSQL.ToString()); strSQL.Length = 0; strSQL.Capacity = 0; if (dt != null && dt.Rows.Count > 0) { lblDG.Text = ""; gvDefault.DataSource = dt; #region PageBuilder if (Request.QueryString["page"] != null) { try { gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()); } catch (Exception) { gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1; } } #endregion gvDefault.DataBind(); dt = null; #region Bind UserGroup #region SQL Query strSQL.Append("SELECT "); strSQL.Append("UID,"); strSQL.Append("Name "); strSQL.Append("FROM "); strSQL.Append("UserGroup "); strSQL.Append("WHERE "); strSQL.Append("StatusFlag='A' "); strSQL.Append("ORDER BY "); strSQL.Append("Sort;"); #endregion dt = clsSQL.Bind(strSQL.ToString(), new string[, ] { { } }); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < gvDefault.Rows.Count; i++) { Label lblDGUserGroupUID = (Label)gvDefault.Rows[i].FindControl("lblDGUserGroupUID"); DropDownList ddlDGUserGroup = (DropDownList)gvDefault.Rows[i].FindControl("ddlDGUserGroup"); if (lblDGUserGroupUID != null && ddlDGUserGroup != null) { ddlDGUserGroup.DataSource = dt; ddlDGUserGroup.DataTextField = "Name"; ddlDGUserGroup.DataValueField = "UID"; ddlDGUserGroup.DataBind(); ddlDGUserGroup.SelectedValue = lblDGUserGroupUID.Text; } } } #endregion } else { pnDGHeader.Visible = false; lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info); } strSQL.Length = 0; strSQL.Capacity = 0; #endregion }
protected void BindDefault() { gvDefault.Visible = true; pnDGHeader.Visible = true; StringBuilder strSQL = new StringBuilder(); #region SQL Query strSQL.Append("SELECT "); strSQL.Append("[User].UserGroupUID,"); strSQL.Append("UserGroup.Name AS UserGroupName,"); strSQL.Append("[User].UID,"); strSQL.Append("[User].Photo,"); strSQL.Append("[User].Username,"); strSQL.Append("[User].PName,"); strSQL.Append("[User].FName,"); strSQL.Append("[User].LName,"); strSQL.Append("[User].Phone,"); strSQL.Append("[User].Mobile,"); strSQL.Append("[User].Email,"); strSQL.Append("[User].Sort,"); strSQL.Append("[User].Active "); strSQL.Append("FROM "); strSQL.Append("[User] "); strSQL.Append("INNER JOIN UserGroup "); strSQL.Append("ON [User].UserGroupUID=UserGroup.UID "); strSQL.Append("WHERE [User].Active<>'D' "); strSQL.Append("ORDER BY UserGroup.Sort,[User].Sort"); #endregion DataTable dt = new DataTable(); 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; #region Bind UserGroup #region SQL Query strSQL.Append("SELECT "); strSQL.Append("UID,"); strSQL.Append("Name "); strSQL.Append("FROM "); strSQL.Append("UserGroup "); strSQL.Append("WHERE "); strSQL.Append("Active='1' "); strSQL.Append("ORDER BY "); strSQL.Append("Sort"); #endregion dt = clsSQL.Bind(strSQL.ToString(), new string[, ] { { } }, dbType, cs); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < gvDefault.Rows.Count; i++) { Label lblDGUserGroupUID = (Label)gvDefault.Rows[i].FindControl("lblDGUserGroupUID"); DropDownList ddlDGUserGroup = (DropDownList)gvDefault.Rows[i].FindControl("ddlDGUserGroup"); if (lblDGUserGroupUID != null && ddlDGUserGroup != null) { ddlDGUserGroup.DataSource = dt; ddlDGUserGroup.DataTextField = "Name"; ddlDGUserGroup.DataValueField = "UID"; ddlDGUserGroup.DataBind(); ddlDGUserGroup.SelectedValue = lblDGUserGroupUID.Text; } } } #endregion } else { pnDGHeader.Visible = false; lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info); } strSQL.Length = 0; strSQL.Capacity = 0; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { #region WebboardConfig approveEnable = WebboardConfig("AnonymousEnable"); if (approveEnable != "1") { if (!clsSecurity.LoginChecker()) { pnDetail.Visible = false; lblDefault.Text = clsDefault.AlertMessageColor("กรุณาสมัครสมาชิก หรือ ล็อคอิน ก่อนตั้งคำถาม | <a href='/Register/' target='_Blank'>คลิกที่นี่เพื่อสมัครสมาชิก</a>", clsDefault.AlertType.Info); ucColorBox1.SizeChange(); return; } } #endregion if (clsDefault.URLRouting("group") != "") { webDefault = "/Webboard/" + clsDefault.URLRouting("group") + "/"; #region Authorize if (clsSecurity.LoginChecker()) { dvAnonymous.Visible = false; vadCName.Enabled = false; vadCEmail.Enabled = false; } if (clsSecurity.LoginGroup == "Admin") { dvAdmin.Visible = true; } #endregion if (clsDefault.URLRouting("id") != "") { if (clsDefault.URLRouting("command") == "Edit") { vdPhoto.Enabled = false; BindControl(clsDefault.URLRouting("group")); BindDetail(clsDefault.URLRouting("id")); } else if (clsDefault.URLRouting("command") == "Delete") { pnDetail.Visible = false; Delete(clsDefault.URLRouting("id")); } else if (clsDefault.URLRouting("command") == "Approve") { pnDetail.Visible = false; Approve(clsDefault.URLRouting("id")); } else { ucColorBox1.Redirect(webDefault, "ไม่พบหน้าเว็บที่คุณต้องการ"); } } else { BindControl(clsDefault.URLRouting("group")); } } else { ucColorBox1.Close(); } } }
protected void btLogin_Click(object sender, EventArgs e) { clsSQL clsSQL = new clsSQL(); clsDefault clsDefault = new clsDefault(); if(clsSecurity.LoginChecker( clsSQL.CodeFilter(txtUsername.Text), clsSQL.CodeFilter(txtPassword.Text), cbEnableCookie.Checked)) { //LoginChecker(); Response.Redirect(Request.RawUrl); } else { lblLogin.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่คุณกรอก", clsDefault.AlertType.Warn); } }
private void DoctorBuilder(string DoctorUID, string DepartmentUID, string MedicalCenterUID) { #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); #endregion #region SQL Query strSQL.Append("SELECT "); strSQL.Append("ISNULL(MC.Name,'') Department,"); strSQL.Append("DD.DepartmentUID,"); strSQL.Append("D.UID,"); strSQL.Append("D.Photo,"); #region Language Select if (clsLanguage.LanguageCurrent == "th-TH") { strSQL.Append("D.PNameTH+' '+D.FNameTH+' '+D.LNameTH Name1,"); strSQL.Append("D.FNameEN+' '+D.LNameEN+', '+D.PNameEN Name2,"); strSQL.Append("D.SpecialtyTH Specialty,"); strSQL.Append("D.EducationTH Education,"); strSQL.Append("D.ExperianceTH Experiance,"); strSQL.Append("D.TypeTH Type,"); } else { strSQL.Append("D.PNameTH+' '+D.FNameTH+' '+D.LNameTH Name2,"); strSQL.Append("D.FNameEN+' '+D.LNameEN+', '+D.PNameEN Name1,"); strSQL.Append("D.SpecialtyEN Specialty,"); strSQL.Append("D.EducationEN Education,"); strSQL.Append("D.ExperianceEN Experiance,"); strSQL.Append("D.TypeEN Type,"); } #endregion strSQL.Append("D.MedID,"); strSQL.Append("D.Phone,"); strSQL.Append("D.EMail "); strSQL.Append("FROM "); strSQL.Append("Doctor D "); strSQL.Append("INNER JOIN DoctorDepartment DD ON D.UID=DD.DoctorUID "); if (DepartmentUID != "0") { strSQL.Append("AND DD.DepartmentUID='" + DepartmentUID + "' "); } strSQL.Append("INNER JOIN MedicalCenter MC ON DD.DepartmentUID=MC.DepartmentUID "); if (MedicalCenterUID != "0") { strSQL.Append("AND MC.UID=" + MedicalCenterUID + " "); } strSQL.Append("WHERE "); strSQL.Append("D.Active='1' "); strSQL.Append("AND D.UID=" + DoctorUID + " "); strSQL.Append("ORDER BY "); strSQL.Append("D.FNameTH"); #endregion #region Data Builder dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); if (dt != null && dt.Rows.Count > 0) { DoctorDetail.Visible = true; lblDoctorPhoto.Text = "<img src='" + DoctorPhotoPath + (dt.Rows[0]["Photo"].ToString() != "" ? dt.Rows[0]["Photo"].ToString() : "default.jpg") + "' alt='" + dt.Rows[0]["Name1"].ToString() + "' title='" + dt.Rows[0]["Name1"].ToString() + "'/>"; lblName1.Text = dt.Rows[0]["Name1"].ToString(); lblName2.Text = dt.Rows[0]["Name2"].ToString(); lblSpecialty.Text = dt.Rows[0]["Specialty"].ToString(); lblDepartment.Text = dt.Rows[0]["Department"].ToString(); lblEducation.Text = dt.Rows[0]["Education"].ToString(); } else { DoctorDetail.Visible = false; lblDefault.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูล", clsDefault.AlertType.Warn); } #endregion }
protected void BindDefault() { gvDefault.Visible = true; pnDGHeader.Visible = true; #region Variable var strSQL = new StringBuilder(); var dt = new DataTable(); #endregion #region Procedure #region SQL Query strSQL.Append("SELECT "); strSQL.Append("A.UID,"); strSQL.Append("A.FileName,"); strSQL.Append("A.Name,"); strSQL.Append("A.Detail,"); strSQL.Append("A.ContactName,"); strSQL.Append("A.ContactPhone,"); strSQL.Append("A.DateApprove,"); strSQL.Append("A.DateSubmit,"); strSQL.Append("A.DateInstall,"); strSQL.Append("A.DateUninstall,"); strSQL.Append("A.Location,"); strSQL.Append("A.ProducerName,"); strSQL.Append("A.VerifyName,"); strSQL.Append("A.InstallName,"); strSQL.Append("A.CWhen "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " A "); strSQL.Append("ORDER BY A.UID DESC;"); #endregion dt = clsSQL.Bind(strSQL.ToString()); strSQL.Length = 0; strSQL.Capacity = 0; if (dt != null && dt.Rows.Count > 0) { lblDG.Text = ""; for (int i = 0; i < dt.Rows.Count; i++) { try { FileInfo fi = new FileInfo(Server.MapPath(dt.Rows[i]["FileName"].ToString())); if (!fi.Exists) { dt.Rows[i]["FileName"] = ""; } } catch (Exception) { dt.Rows[i]["FileName"] = ""; } } dt.AcceptChanges(); gvDefault.DataSource = dt; #region PageBuilder if (Request.QueryString["page"] != null) { try { gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()); } catch (Exception) { gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1; } } #endregion gvDefault.DataBind(); } else { pnDGHeader.Visible = false; lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info); } strSQL.Length = 0; strSQL.Capacity = 0; #endregion }
protected void btSubmit_Click(object sender, EventArgs e) { #region Variable var outSQL = ""; var clsIO = new clsIO(); var outError = ""; var outPhoto = ""; var outMail = ""; #endregion #region Procedure if (fuPhoto.HasFile) { if (!clsIO.UploadPhoto( fuPhoto, "/Upload/Jobs/", clsSQL.GetNewID("UID", "JobsHistory", "", dbType, cs).ToString(), out outError, out outPhoto, 512, 200, 200)) { ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดภาพ : " + outError); return; } } #region InsertData if (!clsSQL.Insert( "JobsHistory", new string[, ] { { "JobsUID", ddlJobs.SelectedItem.Value }, { "JobsName", "'" + txtJobsName.Text.SQLQueryFilter() + "'" }, { "Salary", "'" + txtSalary.Text.SQLQueryFilter() + "'" }, { "Start", "'" + txtStart.Text.SQLQueryFilter() + "'" }, { "ProvinceChange", "'" + rbProvinceChange.SelectedItem.Value + "'" }, { "PrenameTH", "'" + ddlPrenameTH.SelectedItem.Value + "'" }, { "ForenameTH", "'" + txtForenameTH.Text.SQLQueryFilter() + "'" }, { "SurnameTH", "'" + txtSurnameTH.Text.SQLQueryFilter() + "'" }, { "PrenameEN", "'" + ddlPrenameEN.SelectedItem.Value + "'" }, { "ForenameEN", "'" + txtForenameEN.Text.SQLQueryFilter() + "'" }, { "SurnameEN", "'" + txtSurnameEN.Text.SQLQueryFilter() + "'" }, { "MarriageStatus", "'" + rbMarriageStatus.SelectedItem.Value + "'" }, { "Gender", "'" + rbGender.SelectedItem.Value + "'" }, { "Birthdate", "'" + (ucBirthdate.Text.Trim() != ""?ucBirthdate.DateTime.ToString("yyyy-MM-dd"):"1900-01-01 00:00") + "'" }, { "Birthplace", "'" + txtBirthplace.Text.SQLQueryFilter() + "'" }, { "Nationality", "'" + txtNationality.Text.SQLQueryFilter() + "'" }, { "Race", "'" + txtRace.Text.SQLQueryFilter() + "'" }, { "Religion", "'" + txtReligion.Text.SQLQueryFilter() + "'" }, { "Weight", "'" + txtWeight.Text.SQLQueryFilter() + "'" }, { "Height", "'" + txtHeight.Text.SQLQueryFilter() + "'" }, { "NID", "'" + txtNID.Text.SQLQueryFilter() + "'" }, { "NIDCreateBy", "'" + txtNIDCreateBy.Text.SQLQueryFilter() + "'" }, { "NIDExpire", "'" + (ucNIDExpire.Text != ""?ucNIDExpire.DateTime.ToString("yyyy-MM-dd"):"") + "'" }, { "Phone", "'" + txtPhone.Text.SQLQueryFilter() + "'" }, { "Email", "'" + txtEmail.Text.SQLQueryFilter() + "'" }, { "Address", "'" + txtAddress.Text.SQLQueryFilter() + "'" }, { "EmergencyName", "'" + txtEmergencyName.Text.SQLQueryFilter() + "'" }, { "EmergencyPhone", "'" + txtEmergencyPhone.Text.SQLQueryFilter() + "'" }, { "EmergencyEmail", "'" + txtEmergencyEmail.Text.SQLQueryFilter() + "'" }, { "EmergencyAddress", "'" + txtEmergencyAddress.Text.SQLQueryFilter() + "'" }, { "EmergencyRelationship", "'" + txtEmergencyRelationship.Text.SQLQueryFilter() + "'" }, { "Photo", (outPhoto != ""?"'" + outPhoto + "'":"null") }, { "Education", "'" + ucEducation.Text.SQLQueryFilter() + "'" }, { "Experience", "'" + ucExperience.Text.SQLQueryFilter() + "'" }, { "Resume", "null" }, { "CWhen", "GETDATE()" }, { "CUser", "0" }, { "MWhen", "GETDATE()" }, { "MUser", "0" }, { "Sort", "0" }, { "StatusFlag", "'A'" } }, new string[, ] { { } }, dbType, cs, out outSQL)) { ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะรันคำสั่ง : " + Server.HtmlEncode(outSQL)); return; } else { #region MailSender string JobsUID = clsSQL.Return("SELECT MAX(UID) FROM JobsHistory", dbType, cs); if (!clsMail.SendTemplate( "JobsApply", clsMail.GetEmailList("AutoSystemFrom"), clsMail.GetEmailList("JobsTo"), new string[, ] { { "[Photo]", "<img src='" + System.Configuration.ConfigurationManager.AppSettings["website"] + "/Upload/Jobs/" + outPhoto + "'/>" }, { "[UID]", JobsUID }, { "[JobsName]", ddlJobs.SelectedItem.Text + (txtJobsName.Text.Trim() != ""?" (" + txtJobsName.Text.SQLQueryFilter() + ")":"") }, { "[PrenameTH]", ddlPrenameTH.SelectedItem.Text }, { "[ForenameTH]", txtForenameTH.Text }, { "[SurnameTH]", txtSurnameTH.Text }, { "[Birthdate]", ucBirthdate.DateTime.ToString("dd/MM/yyyy") }, { "[Birthplace]", txtBirthplace.Text }, { "[Gender]", rbGender.SelectedItem.Text }, { "[Phone]", txtPhone.Text }, { "[Email]", txtEmail.Text }, { "[Start]", txtStart.Text.SQLQueryFilter() }, { "[Education]", ucEducation.Text.SQLQueryFilter() }, { "[Experience]", ucExperience.Text.SQLQueryFilter() }, { "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm") } }, out outMail)) { lblMessage.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะพยายามส่งอีเมล์<br/>" + outMail, clsDefault.AlertType.Fail); lblMessage.Focus(); return; } #endregion ucColorBox1.Redirect("/Jobs/"); } #endregion #endregion }
private void DoctorBuilderDeptOneLine() { #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); #endregion #region SQL Query strSQL.Append("SELECT "); strSQL.Append("("); strSQL.Append("SELECT TOP 1 MedicalCenter.UID "); strSQL.Append("FROM DoctorDepartment "); strSQL.Append("INNER JOIN MedicalCenter ON DoctorDepartment.DepartmentUID = MedicalCenter.DepartmentUID AND MedicalCenter.LanguageUID = " + (clsLanguage.LanguageCurrent == "th-TH" ? "1" : "2") + " "); strSQL.Append("WHERE DoctorDepartment.DoctorUID = D.UID "); strSQL.Append(")MedicalCenterUID,"); strSQL.Append("("); strSQL.Append("SELECT MC.Name + ' , ' "); strSQL.Append("FROM DoctorDepartment DD "); strSQL.Append("INNER JOIN MedicalCenter MC ON DD.DepartmentUID = MC.DepartmentUID "); if (clsLanguage.LanguageCurrent == "th-TH") { strSQL.Append("AND MC.LanguageUID=1 "); } else { strSQL.Append("AND MC.LanguageUID=2 "); } strSQL.Append("WHERE DD.DoctorUID = D.UID FOR XML PATH('')"); strSQL.Append(")Department,"); strSQL.Append("("); strSQL.Append("SELECT TOP 1 DoctorDepartment.DepartmentUID "); strSQL.Append("FROM DoctorDepartment "); strSQL.Append("INNER JOIN MedicalCenter ON DoctorDepartment.DepartmentUID = MedicalCenter.DepartmentUID AND MedicalCenter.LanguageUID = " + (clsLanguage.LanguageCurrent == "th-TH" ? "1" : "2") + " "); strSQL.Append("WHERE DoctorDepartment.DoctorUID = D.UID "); strSQL.Append(")DepartmentUID,"); strSQL.Append("D.UID,D.Photo,"); #region Language Select if (clsLanguage.LanguageCurrent == "th-TH") { strSQL.Append("D.PNameTH+' '+D.FNameTH+' '+D.LNameTH Name1,"); strSQL.Append("D.FNameEN+' '+D.LNameEN+', '+D.PNameEN Name2,"); strSQL.Append("D.SpecialtyTH Specialty,"); strSQL.Append("D.EducationTH Education,"); strSQL.Append("D.ExperianceTH Experiance,"); strSQL.Append("D.TypeTH Type,"); } else { strSQL.Append("D.PNameTH+' '+D.FNameTH+' '+D.LNameTH Name2,"); strSQL.Append("D.FNameEN+' '+D.LNameEN+', '+D.PNameEN Name1,"); strSQL.Append("D.SpecialtyEN Specialty,"); strSQL.Append("D.EducationEN Education,"); strSQL.Append("D.ExperianceEN Experiance,"); strSQL.Append("D.TypeEN Type,"); } #endregion strSQL.Append("D.MedID,D.Phone,D.EMail "); strSQL.Append("FROM Doctor D "); strSQL.Append("WHERE D.Active = '1' "); #region SearchBuilder #region Name if (txtSearchName.Text.Trim() != "") { if (clsLanguage.LanguageCurrent == "th-TH") { strSQL.Append("AND ("); strSQL.Append("D.FNameTH LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%' "); strSQL.Append("OR D.LNameTH LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%'"); strSQL.Append(") "); } else { strSQL.Append("AND ("); strSQL.Append("D.FNameEN LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%' "); strSQL.Append("OR D.LNameEN LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%'"); strSQL.Append(") "); } } #endregion #region Specialty if (ddlSearchSpecialty.SelectedItem.Value != "null") { strSQL.Append("AND ("); strSQL.Append("SpecialtyTH LIKE '%" + ddlSearchSpecialty.SelectedItem.Text + "%' "); strSQL.Append("OR SpecialtyEN LIKE '%" + ddlSearchSpecialty.SelectedItem.Text + "%' "); strSQL.Append(") "); } #endregion #region MedicalCenter if (ddlSearchMedicalCenter.SelectedItem.Value != "null") { strSQL.Append("AND ("); strSQL.Append("SELECT COUNT(MedicalCenter.UID) "); strSQL.Append("FROM DoctorDepartment "); strSQL.Append("INNER JOIN MedicalCenter ON DoctorDepartment.DepartmentUID = MedicalCenter.DepartmentUID AND MedicalCenter.LanguageUID = " + (clsLanguage.LanguageCurrent == "th-TH" ? "1" : "2") + " "); strSQL.Append("WHERE DoctorDepartment.DoctorUID = D.UID "); strSQL.Append("AND MC.Name LIKE '%" + ddlSearchMedicalCenter.SelectedItem.Text + "%'"); strSQL.Append(")>0,"); } #endregion #region Schedule #region Checked bool cbChecked = false; for (int c = 0; c < cbSearchSchedule.Items.Count; c++) { if (cbSearchSchedule.Items[c].Selected) { cbChecked = true; break; } } #endregion if (cbChecked) { strSQL.Append("AND ("); strSQL.Append("SELECT "); strSQL.Append("COUNT(UID) "); strSQL.Append("FROM "); strSQL.Append("DoctorSchedule "); strSQL.Append("WHERE "); strSQL.Append("DoctorUID=D.UID "); //strSQL.Append("AND DATEPART(DW,DoctorSchedule.DateActive)=1"); strSQL.Append("AND " + clsSQL.QueryBuilderWhere(cbSearchSchedule, "DATEPART(DW,DoctorSchedule.DateActive)", "OR", false, true)); strSQL.Append(")>0 "); } #endregion #endregion strSQL.Append("ORDER BY "); strSQL.Append("D.FNameTH;"); #endregion #region Data Builder dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); if (dt != null && dt.Rows.Count > 0) { gvDoctor.Visible = true; gvDoctor.DataSource = dt; gvDoctor.DataBind(); DoctorScheduleBuilder(); } else { gvDoctor.Visible = false; lblDoctor.Text = (clsLanguage.LanguageCurrent == "th-TH"?clsDefault.AlertMessageColor("ไม่พบข้อมูลแพทย์ที่ต้องการ.", clsDefault.AlertType.Info):clsDefault.AlertMessageColor("Not found data.", clsDefault.AlertType.Info)); } #endregion }
protected void btSubmit_Click(object sender, EventArgs e) { #region Variable string outMail = ""; string outSQL = ""; string UID = ""; #endregion if (txtFromName.Text.Trim().Length > 0 && txtFromPhone.Text.Trim().Length > 0 && txtFromEmail.Text.Trim().Length > 0 && txtMessage.Text.Trim().Length > 0) { UID = clsSQL.GetNewID("UID", "Inquiry", "", dbType, cs).ToString(); if (!clsSQL.Insert( "Inquiry", new string[, ] { { "UID", UID }, { "MedicalCenterUID", (ddlMedicalCenter.SelectedItem.Value == "null"?"null":ddlMedicalCenter.SelectedItem.Value) }, { "Name", "'" + clsSQL.CodeFilter(txtFromName.Text) + "'" }, { "Email", "'" + clsSQL.CodeFilter(txtFromEmail.Text) + "'" }, { "Phone", "'" + clsSQL.CodeFilter(txtFromPhone.Text) + "'" }, { "Message", "'" + clsSQL.CodeFilter(txtMessage.Text) + "'" }, { "Status", "'RECEIVED'" }, { "CWhen", "GETDATE()" }, { "CUser", /*clsSecurity.LoginUID*/ "0" }, { "MWhen", "GETDATE()" }, { "MUser", /*clsSecurity.LoginUID*/ "0" }, { "Sort", "0" }, { "Active", "'1'" } }, new string[, ] { {} }, dbType, cs, out outSQL)) { ucColorBox1.Alert(Message: "เกิดข้อผิดพลาดขณะบันทึกข้อมูล", AlertImage: ucColorBox.Alerts.Fail); return; } #region MailToUser try { //string outMailMessage=""; //clsMail.Send( // "*****@*****.**", // txtFromEmail.Text.Trim(), // "โรงพยาบาลกรุงเทพจันทบุรี ได้รับข้อมูลของคุณแล้ว", // "คุณได้ส่งคำถาม '" + txtMessage.Text.Trim() + "' มายังโรงพยาบาล", // out outMailMessage); if (clsMail.SendTemplate( "InquiryConfirm", clsMail.GetEmailList("GlobalFrom"), txtFromEmail.Text, new string[, ] { { "[UID]", UID }, { "[MedicalCenter]", ddlMedicalCenter.SelectedItem.Text }, { "[FromName]", txtFromName.Text }, { "[FromPhone]", txtFromPhone.Text }, { "[FromEmail]", txtFromEmail.Text }, { "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") }, { "[Message]", txtMessage.Text } }, out outMail)) { ucColorBox1.Redirect("/Inquiry/", "ได้รับข้อความของคุณแล้ว"); } else { lblAlert.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะพยายามส่งอีเมล์<br/>" + outMail, clsDefault.AlertType.Fail); lblAlert.Focus(); } } catch (Exception) { } #endregion #region MailToAdmin if (clsMail.SendTemplate( "Inquiry", clsMail.GetEmailList("AutoSystemFrom"), clsMail.GetEmailList("InquiryTo"), new string[, ] { { "[UID]", UID }, { "[MedicalCenter]", ddlMedicalCenter.SelectedItem.Text }, { "[FromName]", txtFromName.Text }, { "[FromPhone]", txtFromPhone.Text }, { "[FromEmail]", txtFromEmail.Text }, { "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") }, { "[Message]", txtMessage.Text } }, out outMail)) { ucColorBox1.Redirect("/Inquiry/", "ได้รับข้อความของคุณแล้ว"); } else { lblAlert.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะพยายามส่งอีเมล์<br/>" + outMail, clsDefault.AlertType.Fail); lblAlert.Focus(); } #endregion } else { lblAlert.Text = clsDefault.AlertMessageColor("กรุณากรอกข้อมูลให้ครบก่อนค่ะ", clsDefault.AlertType.Warn); } }
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 = "ประวัติการส่งใบสมัครงาน"; #endregion #region SQL Query strSQL.Append("SELECT "); strSQL.Append("Jobs.Name JobsName,"); strSQL.Append("ISNULL(" + tableDefault + ".JobsName,'')" + " JobsNameManual,"); strSQL.Append(tableDefault + ".Photo,"); strSQL.Append(tableDefault + ".UID,"); strSQL.Append(tableDefault + ".PrenameTH,"); strSQL.Append(tableDefault + ".ForenameTH,"); strSQL.Append(tableDefault + ".SurnameTH,"); strSQL.Append(tableDefault + ".MWhen,"); strSQL.Append(tableDefault + ".Sort,"); strSQL.Append(tableDefault + ".StatusFlag "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("INNER JOIN Jobs ON " + tableDefault + ".JobsUID=Jobs.UID "); #region Where strSQL.Append("WHERE "); strSQL.Append("JobsHistory.StatusFlag<>'D' "); //strSQL.Append("MedicalCenterGroupUID=" + clsDefault.QueryStringChecker("group") + " "); #endregion strSQL.Append("ORDER BY "); strSQL.Append(tableDefault + ".CWhen DESC;"); #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) { 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 }