protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { string sql_year = "SELECT * FROM tbl_year"; GetDownList(txtYear, sql_year, "year", "year"); getMampowerData(dBScript.getBudgetYear()); getMampowerFullData(dBScript.getBudgetYear()); GetDatailManpower(dBScript.getBudgetYear()); Title = "อัตรากำลัง ปีงบประมาณ " + dBScript.getBudgetYear(); //rowShow.InnerHtml += "<div class='col-md'>55555</ div > "; } //if (GridViewDetail.InnerHtml.ToString() == "") //{ GetDatailManpower(dBScript.getBudgetYear()); //} }
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; } } }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.Params["empID"])) { if (dBScript.CheckPrivilege(Session["UserPrivilegeId"].ToString(), "Assistant")) { Button1.Visible = true; } else { Button1.Visible = false; } if (dBScript.getEmpIDMD5("type_emp_id", Request.Params["empID"]) == "5") { string sql = "SELECT exp_moterway_start FROM tbl_exp_moterway WHERE exp_moterway_emp_id = '" + dBScript.getEmpIDMD5("emp_id", Request.Params["empID"]) + "' AND exp_moterway_end = '00-00-0000'"; MySqlDataReader rs = dBScript.selectSQL(sql); if (rs.Read()) { leave = new Leave(rs.GetString("exp_moterway_start"), true); } else { leave = new Leave(DateTime.Now.ToString("dd-MM-") + (DateTime.Now.Year + 543), true); } rs.Close(); dBScript.CloseConnection(); } else { leave = new Leave(dBScript.getEmpIDMD5("emp_start_working", Request.Params["empID"]), false); } //empId.Text = Request.Params["empID"].ToString().Trim();pos_name leaveUser = new Leave(dBScript.getEmpIDMD5("emp_id", Request.Params["empID"]), int.Parse(dBScript.getBudgetYear())); lbTypeEmp.Text = dBScript.getEmpIDMD5("type_emp_name", Request.Params["empID"]); lbEmpName.Text = dBScript.getEmpIDMD5("emp_id", Request.Params["empID"]) + " " + dBScript.getEmpIDMD5("profix_name", Request.Params["empID"]) + dBScript.getEmpIDMD5("emp_name", Request.Params["empID"]) + " " + dBScript.getEmpIDMD5("emp_lname", Request.Params["empID"]); lbPos.Text = dBScript.getEmpIDMD5("pos_name", Request.Params["empID"]) + " / ด่านฯ : " + dBScript.getEmpIDMD5("cpoint_name", Request.Params["empID"]); lbExp6Month.Text = leave.Date6Month; lbExp1Year.Text = leave.Date1Year; lbStartDate.Text = leave.Date; lbYear.Text = leave.BudgetYear; lbSick.Text = leaveUser.UserSick + " / " + leave.Sick.ToString("0 วัน"); lbSick.CssClass = leaveUser.UserSick > leave.Sick? "text-danger" : ""; lbRelax.Text = leaveUser.UserRelax + " / " + leave.Relax.ToString("0 วัน"); lbRelax.CssClass = leaveUser.UserRelax > leave.Relax ? "text-danger" : ""; lbOrdain.Text = leave.Ordain > 0 ? "มีสิทธิลา" : "ไม่มีสิทธิลา"; lbMaternity.Text = leaveUser.UserMaternity + " / " + leave.Maternity.ToString("0 วัน"); lbMaternity.CssClass = leaveUser.UserMaternity > leave.Maternity ? "text-danger" : ""; lbMilitary.Text = leaveUser.UserMilitary + " / " + leave.Military.ToString("0 วัน"); lbMilitary.CssClass = leaveUser.UserMilitary > leave.Military ? "text-danger" : ""; dBScript.CloseConnection(); } else { Response.Redirect("/LeaveEmp/empLeaveForm"); } if (!this.IsPostBack) { BindData(); } }
protected void GridViewEmp_RowDataBound(object sender, GridViewRowEventArgs e) { string date_start = (string)DataBinder.Eval(e.Row.DataItem, "emp_start_working"); bool empfun = false; if (dbScript.getEmpData("type_emp_id", (string)DataBinder.Eval(e.Row.DataItem, "emp_id")) == "5") { empfun = true; string sql = "SELECT exp_moterway_start FROM tbl_exp_moterway WHERE exp_moterway_emp_id = '" + (string)DataBinder.Eval(e.Row.DataItem, "emp_id") + "' AND exp_moterway_end = '00-00-0000'"; MySqlDataReader rs = dbScript.selectSQL(sql); if (rs.Read()) { date_start = rs.GetString("exp_moterway_start"); } else { date_start = DateTime.Now.ToString("dd-MM-") + (DateTime.Now.Year + 543); } rs.Close(); dbScript.CloseConnection(); } if (date_start == null) { date_start = DateTime.Now.ToString("dd-MM-") + (DateTime.Now.Year + 543); } Leave leave = new Leave(date_start, empfun); Leave leaveUser = new Leave((string)DataBinder.Eval(e.Row.DataItem, "emp_id"), int.Parse(dbScript.getBudgetYear())); Label lbSick = (Label)(e.Row.FindControl("lbSick")); if (lbSick != null) { if (leaveUser.UserSick <= leave.Sick) { lbSick.Text = leaveUser.UserSick + " / " + leave.Sick; } else { lbSick.CssClass = "text-danger"; lbSick.Text = leaveUser.UserSick + " / " + leave.Sick; } } Label lbRelax = (Label)(e.Row.FindControl("lbRelax")); if (lbRelax != null) { if (leaveUser.UserRelax <= leave.Relax) { lbRelax.Text = leaveUser.UserRelax + " / " + leave.Relax; } else { lbRelax.CssClass = "text-danger"; lbRelax.Text = leaveUser.UserRelax + " / " + leave.Relax; } } Label lbMaternity = (Label)(e.Row.FindControl("lbMaternity")); if (lbMaternity != null) { if (leaveUser.UserMaternity <= leave.Maternity) { lbMaternity.Text = leaveUser.UserMaternity + " / " + leave.Maternity; } else { lbMaternity.CssClass = "text-danger"; lbMaternity.Text = leaveUser.UserMaternity + " / " + leave.Maternity; } } Label lbOrdain = (Label)(e.Row.FindControl("lbOrdain")); if (lbOrdain != null) { if (leave.Ordain > 0) { lbOrdain.CssClass = "text-success"; lbOrdain.Text = leaveUser.UserOrdain + " / มีสิทธิลา"; } else { lbOrdain.CssClass = "text-danger"; lbOrdain.Text = leaveUser.UserOrdain + " / ไม่มีสิทธิลา"; } } Label lbMilitary = (Label)(e.Row.FindControl("lbMilitary")); if (lbMilitary != null) { if (leaveUser.UserMilitary <= leave.Military) { lbMilitary.Text = leaveUser.UserMilitary + " / " + leave.Military; } else { lbMilitary.CssClass = "text-danger"; lbMilitary.Text = leaveUser.UserMilitary + " / " + leave.Military; } } Label lbStartDate = (Label)(e.Row.FindControl("lbStartDate")); if (lbStartDate != null) { string[] data = date_start.Split('-'); DateTime dateStart = DateTime.ParseExact(data[0] + "-" + data[1] + "-" + (int.Parse(data[2]) - 543), "dd-MM-yyyy", CultureInfo.InvariantCulture); if (dateStart.Date <= DateTime.Now.Date) { if (dateStart.Date.ToString("dd-MM-yyyy") == DateTime.Now.Date.ToString("dd-MM-yyyy")) { lbStartDate.CssClass = "text-danger"; lbStartDate.Text = leave.Date.ToString() + " / " + new DateDifference(dateStart).ToString(); } else { lbStartDate.Text = leave.Date.ToString() + " / " + new DateDifference(dateStart).ToString(); } } else { lbStartDate.Text = leave.Date.ToString() + " / <span class='badge badge-pill badge-danger'>ข้อมูลวันเริ่มงานผิดพลาด</span>"; } } Label lbYear = (Label)(e.Row.FindControl("lbYear")); if (lbYear != null) { lbYear.Text = leave.BudgetYear.ToString(); } Label lbEmpType = (Label)(e.Row.FindControl("lbEmpType")); if (lbEmpType != null) { lbEmpType.Text = (string)DataBinder.Eval(e.Row.DataItem, "type_emp_name"); } LinkButton btnView = (LinkButton)(e.Row.FindControl("btnView")); if (btnView != null) { btnView.CommandArgument = (string)DataBinder.Eval(e.Row.DataItem, "emp_id"); } dbScript.CloseConnection(); }