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();
}
