protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { // 只有首次執行才會執行的程式 // AUO Login in ClsLogin.auth(); CatchSystemTime(); Label9.Text = "歡迎您的登入!今天日期為 " + currentDate + ",祝您有個愉快的一天!"; // 測試用日期 //currentDate = "2019-07-12"; // SELECT data from MySQL database SQL = "SELECT h.MFGday, h.OVERTIME, h.DN, p.WNUM ,h.NAME FROM h_hr_manpower_daily_actual_name h LEFT OUTER JOIN personal_data p ON(h.NAME = p.NAME) WHERE h.MFGday = \"" + currentDate + "\" AND ( h.OVERTIME = \"當班\" OR h.OVERTIME = \"加班\" ) AND (h.DN = \"" + currentShift + "\")"; InquiryMySQLData(); GridView1.DataSource = dataTable; //告訴GridView資料來源為誰 GridView1.DataBind(); //綁定 DisconnectMySQL(); //ClsLogin.Right("PC|領班|大領班", "抱歉您沒有權限!", "'0230221'"); } if (Session["W_ID"] == null) { ClsLogin.auth(); } }