protected void Page_Load(object sender, EventArgs e) { lbUserOnline.Text = int.Parse(Application["TotalOnlineUsers"].ToString()).ToString(" 0 คน"); if (!this.IsPostBack) { string sql = "SELECT COUNT('id') AS EmpSum FROM tbl_emp_profile WHERE emp_staus_working = '1'"; MySqlDataReader rs = dBScript.selectSQL(sql); if (rs.Read()) { lbCountEmp.Text = "ทั้งหมด " + rs.GetString("EmpSum") + " คน"; } rs.Close(); BindDataLeave(); BindRetire(); dBScript.CloseConnection(); string sql_guest = "SELECT guest_offer_date FROM tbl_guest ORDER BY STR_TO_DATE(guest_offer_date, '%d-%m-%Y') DESC "; LabelGuest.Text = "รายการล่าสุด " + dBScript.convertDateShortThai(dBScript.GetSelectData(sql_guest)); lbYear.Text = dBScript.getBudgetYear(); txtYear.Text = dBScript.getBudgetYear(); } if (Session["User"] != null) { if (dBScript.Notallow(new string[] { "5" }, Session["UserPrivilegeId"].ToString())) { Response.Redirect("/Profile/empViwe"); } if (dBScript.Notallow(new string[] { "5", "4", "3" }, Session["UserPrivilegeId"].ToString())) { boxChangPos.Visible = false; boxMigrateEmp.Visible = false; boxResignEmp.Visible = false; } } }