protected void lbuLogin_Click(object sender, EventArgs e)
{
int count = DatabaseManager.ExecuteInt("SELECT count(*) FROM PS_PERSON WHERE PS_CITIZEN_ID = '" + tbUsername.Text + "'");
if(count == 0) {
Label12X.Text = "ไม่พบผู้ใช้งาน!";
} else {
if(DatabaseManager.ValidateUser(tbUsername.Text, tbPassword.Text)) {
PersonnelSystem ps = new PersonnelSystem();
ps.LoginPerson = DatabaseManager.GetPerson(tbUsername.Text);
Session["PersonnelSystem"] = ps;
if (DatabaseManager.ExecuteInt("SELECT COUNT(*) FROM LEV_CLAIM WHERE PS_CITIZEN_ID = '" + ps.LoginPerson.CitizenID + "' AND YEAR = " + Util.BudgetYear()) == 0) {
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("INSERT INTO LEV_CLAIM (LEAVE_CLAIM_ID, PS_CITIZEN_ID, YEAR, SICK_NOW, SICK_REQ, BUSINESS_NOW, BUSINESS_REQ, GB_NOW, GB_REQ, REST_NOW, REST_REQ, REST_SAVE, REST_SAVE_FIX, REST_THIS, REST_THIS_FIX, REST_MAX, HGB_NOW, HGB_REQ, ORDAIN_NOW, ORDAIN_REQ, HUJ_NOW, HUJ_REQ, SICK_MAX, BUSINESS_MAX, HUJ_MAX, ORDAIN_MAX) VALUES (SEQ_LEV_CLAIM_ID.NEXTVAL, :PS_CITIZEN_ID, :YEAR, :SICK_NOW, :SICK_REQ, :BUSINESS_NOW, :BUSINESS_REQ, :GB_NOW, :GB_REQ, :REST_NOW, :REST_REQ, :REST_SAVE, :REST_SAVE_FIX, :REST_THIS, :REST_THIS_FIX, :REST_MAX, :HGB_NOW, :HGB_REQ, :ORDAIN_NOW, :ORDAIN_REQ, :HUJ_NOW, :HUJ_REQ, :SICK_MAX, :BUSINESS_MAX, :HUJ_MAX, :ORDAIN_MAX)", con)) {
com.Parameters.AddWithValue("PS_CITIZEN_ID", ps.LoginPerson.CitizenID);
com.Parameters.AddWithValue("YEAR", Util.BudgetYear());
int v1 = 0;
int v2 = 10;
int v60 = 60;
int v45 = 45;
int v120 = 120;
com.Parameters.AddWithValue("SICK_NOW", v1);
com.Parameters.AddWithValue("SICK_REQ", v1);
com.Parameters.AddWithValue("BUSINESS_NOW", v1);
com.Parameters.AddWithValue("BUSINESS_REQ", v1);
com.Parameters.AddWithValue("GB_NOW", v1);
com.Parameters.AddWithValue("GB_REQ", v1);
com.Parameters.AddWithValue("REST_NOW", v1);
com.Parameters.AddWithValue("REST_REQ", v1);
com.Parameters.AddWithValue("REST_SAVE", v1);
com.Parameters.AddWithValue("REST_SAVE_FIX", v1);
com.Parameters.AddWithValue("REST_THIS", v2);
com.Parameters.AddWithValue("REST_THIS_FIX", v2);
com.Parameters.AddWithValue("REST_MAX", v2);
com.Parameters.AddWithValue("HGB_NOW", v1);
com.Parameters.AddWithValue("HGB_REQ", v1);
com.Parameters.AddWithValue("ORDAIN_NOW", v1);
com.Parameters.AddWithValue("ORDAIN_REQ", v1);
com.Parameters.AddWithValue("HUJ_NOW", v1);
com.Parameters.AddWithValue("HUJ_REQ", v1);
com.Parameters.AddWithValue("SICK_MAX", v60);
com.Parameters.AddWithValue("BUSINESS_MAX", v45);
com.Parameters.AddWithValue("HUJ_MAX", v120);
com.Parameters.AddWithValue("ORDAIN_MAX", v120);
com.ExecuteNonQuery();
}
}
}
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("SELECT LEAVE_ID FROM LEV_DATA WHERE CURRENT_DATE >= FROM_DATE AND LEAVE_TYPE_ID IN(2,4,6,7) AND LEAVE_STATUS_ID = 1", con)) {
using(OracleDataReader reader = com.ExecuteReader()) {
while(reader.Read()) {
int leaveID = reader.GetInt32(0);
LeaveData leaveData = new LeaveData();
leaveData.Load(leaveID);
leaveData.ExecuteCancelBySystem();
}
}
}
using (OracleCommand com = new OracleCommand("SELECT LEAVE_ID FROM LEV_DATA WHERE LEAVE_STATUS_ID = 1 AND TRUNC(CURRENT_DATE - REQ_DATE, 0) >= 3", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
int leaveID = reader.GetInt32(0);
LeaveData leaveData = new LeaveData();
leaveData.Load(leaveID);
leaveData.ExecuteCancelBySystem();
}
}
}
/*using (OracleCommand com = new OracleCommand("SELECT LEAVE_ID FROM LEV_DATA WHERE CURRENT_DATE >= FROM_DATE AND LEAVE_TYPE_ID IN(2,4,6,7) AND LEAVE_STATUS_ID = 4", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
int leaveID = reader.GetInt32(0);
LeaveData leaveData = new LeaveData();
leaveData.Load(leaveID);
leaveData.ExecuteCancelOfCancelBySystem();
}
}
}
using (OracleCommand com = new OracleCommand("SELECT LEAVE_ID FROM LEV_DATA WHERE LEAVE_STATUS_ID = 4 AND TRUNC(CURRENT_DATE - CANCEL_DATE, 0) >= 3", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
int leaveID = reader.GetInt32(0);
LeaveData leaveData = new LeaveData();
leaveData.Load(leaveID);
leaveData.ExecuteCancelOfCancelBySystem();
}
}
}*/
//-------------
/*using (OracleCommand com = new OracleCommand("UPDATE LEV_DATA SET LEAVE_STATUS_ID = 10 WHERE LEAVE_ID = (SELECT LEAVE_ID FROM LEV_DATA WHERE CURRENT_DATE >= FROM_DATE AND LEAVE_TYPE_ID IN(2,4,6,7) AND LEAVE_STATUS_ID IN(1,2))", con)) {
com.ExecuteNonQuery();
}
using (OracleCommand com = new OracleCommand("UPDATE LEV_DATA SET LEAVE_STATUS_ID = 10 WHERE LEAVE_ID = (SELECT LEAVE_ID FROM LEV_DATA WHERE LEAVE_STATUS_ID IN(1,2) AND TRUNC(CURRENT_DATE - REQ_DATE, 0) >= 3)", con)) {
com.ExecuteNonQuery();
}*/
}
Response.Redirect("Default.aspx");
} else {
Label12X.Text = "รหัสผ่านไม่ถูกต้อง!";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
Person loginPerson = ps.LoginPerson;
int count = DatabaseManager.GetLeaveRequiredCountByCommander(loginPerson.CitizenID);
/* using (OleDbConnection con = new OleDbConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OleDbCommand com = new OleDbCommand("SELECT COUNT(LEAVE_ID) FROM LEV_LEAVE WHERE CMD_HIGH_ID = '" + loginPerson.CitizenID + "' AND LEV_LEAVE.STATE_ID = 2", con)) {
using (OleDbDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
count = int.Parse(reader.GetValue(0).ToString());
}
}
}
}*/
if (count == 0) {
error_area.InnerHtml = "ไม่มีรายการที่ท่านต้องอนุมัติ";
} else {
error_area.InnerHtml = "กรุณาเลือกรายการที่ต้องการอนุมัติ";
}
error_area.Attributes["class"] = null;
error_area.InnerHtml = "";
if (count > 0) {
SqlDataSource sds = DatabaseManager.CreateSQLDataSource("SELECT LEV_DATA.LEAVE_ID รหัสการลา, (SELECT PS_FN_TH || ' ' || PS_LN_TH FROM PS_PERSON WHERE PS_CITIZEN_ID = LEV_DATA.PS_ID) ชื่อผู้ลา, (SELECT LEAVE_TYPE_NAME FROM LEV_TYPE WHERE LEV_TYPE.LEAVE_TYPE_ID = LEV_DATA.LEAVE_TYPE_ID) ประเภทการลา, REQ_DATE วันที่ข้อมูล, (SELECT LEAVE_STATUS_NAME FROM LEV_STATUS WHERE LEAVE_STATUS_ID = LEV_DATA.LEAVE_STATUS_ID) สถานะ FROM LEV_DATA, LEV_BOSS_DATA WHERE LEAVE_STATUS_ID IN(1,4) AND LEV_DATA.LEAVE_ID = LEV_BOSS_DATA.LEAVE_ID AND LEV_DATA.BOSS_STATE = LEV_BOSS_DATA.STATE AND LEV_BOSS_DATA.CITIZEN_ID = '" + loginPerson.CitizenID + "'");
GridView1.DataSource = sds;
GridView1.DataBind();
Util.NormalizeGridViewDate(GridView1, 3);
TableHeaderCell newHeader = new TableHeaderCell();
newHeader.Text = "เลือก";
GridView1.HeaderRow.Cells.Add(newHeader);
GridView1.HeaderRow.Cells[0].Text = "<img src='Image/Small/ID.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[0].Text;
GridView1.HeaderRow.Cells[1].Text = "<img src='Image/Small/person2.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[1].Text;
GridView1.HeaderRow.Cells[2].Text = "<img src='Image/Small/list.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[2].Text;
GridView1.HeaderRow.Cells[3].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[3].Text;
GridView1.HeaderRow.Cells[4].Text = "<img src='Image/Small/question.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[4].Text;
GridView1.HeaderRow.Cells[5].Text = "<img src='Image/Small/pointer.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[5].Text;
for (int i = 0; i < GridView1.Rows.Count; ++i) {
string id = GridView1.Rows[i].Cells[0].Text;
LinkButton lbu = new LinkButton();
lbu.Text = "<img src='Image/Small/next.png'></img>";
lbu.CssClass = "ps-button";
lbu.Click += (e2, e3) => {
LeaveData leaveData = new LeaveData();
leaveData.Load(int.Parse(id));
Session["LeaveData"] = leaveData;
trPSBirthDate.Visible = false;
trPSWorkInDate.Visible = false;
trWifeName.Visible = false;
trGBDate.Visible = false;
trOrdained.Visible = false;
trTempleName.Visible = false;
trTempleLocation.Visible = false;
trOrdainDate.Visible = false;
trHujed.Visible = false;
trReason.Visible = false;
trContact.Visible = false;
trPhone.Visible = false;
trRestSave.Visible = false;
trRestLeft.Visible = false;
trRestTotal.Visible = false;
trStatistic.Visible = false;
//trCLOldComment.Visible = false;
//trCLOldDate.Visible = false;
//trCHOldComment.Visible = false;
//trCHOldDate.Visible = false;
trCancelReason.Visible = false;
if (leaveData.LeaveTypeID == 1) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 2) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 3) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 4) {
trRestSave.Visible = true;
trRestLeft.Visible = true;
trRestTotal.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 5) {
trWifeName.Visible = true;
trGBDate.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 6) {
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trOrdained.Visible = true;
trTempleName.Visible = true;
trTempleLocation.Visible = true;
trOrdainDate.Visible = true;
} else if (leaveData.LeaveTypeID == 7) {
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trHujed.Visible = true;
}
if (leaveData.LeaveStatusID == 2) {
} else if (leaveData.LeaveStatusID == 4) {
//trCLOldComment.Visible = true;
//trCLOldDate.Visible = true;
//trCHOldComment.Visible = true;
//trCHOldDate.Visible = true;
trCancelReason.Visible = true;
}
lbLeaveID.Text = leaveData.LeaveID.ToString();
lbLeaveTypeName.Text = leaveData.LeaveTypeName;
lbReqDate.Text = leaveData.RequestDate.Value.ToLongDateString();
lbPSName.Text = leaveData.Person.FirstName + " " + leaveData.Person.LastName;
lbPSPos.Text = leaveData.Person.PositionWorkName;
lbPSAPos.Text = leaveData.Person.AdminPositionName;
if(Util.IsBlank(leaveData.Person.WorkDivisionID)) {
lbPSDept.Text = leaveData.Person.DivisionName;
} else {
lbPSDept.Text = leaveData.Person.WorkDivisionName;
}
//if (leaveData.PS_BirthDate.HasValue) {
lbPSBirthDate.Text = leaveData.Person.BirthDate.Value.ToLongDateString();
//} else {
// lbPSBirthDate.Text = "-";
//}
//if (leaveData.PS_WorkInDate.HasValue) {
lbPSWorkInDate.Text = leaveData.Person.InWorkDate.Value.ToLongDateString();
//} else {
// lbPSWorkInDate.Text = "-";
// }
lbRestSave.Text = leaveData.RestSave + " วัน";
lbRestLeft.Text = leaveData.RestLeft + " วัน";
lbRestTotal.Text = leaveData.RestTotal + " วัน";
lbWifeName.Text = leaveData.WifeFirstName + " " + leaveData.WifeLastName;
if (leaveData.GiveBirthDate.HasValue) {
lbGBDate.Text = leaveData.GiveBirthDate.Value.ToLongDateString();
} else {
lbGBDate.Text = "-";
}
lbOrdained.Text = leaveData.Ordained == 1 ? "เคย" : "ไม่เคย";
lbTempleName.Text = leaveData.TempleName;
lbTempleLocation.Text = leaveData.TempleLocation;
if (leaveData.OrdainDate.HasValue) {
lbOrdainDate.Text = leaveData.OrdainDate.Value.ToLongDateString();
} else {
lbOrdainDate.Text = "-";
}
lbHujed.Text = leaveData.Hujed == 1 ? "เคย" : "ไม่เคย";
if (leaveData.FromDate.HasValue) {
lbFTTDate.Text = leaveData.FromDate.Value.ToLongDateString() + " ถึง " + leaveData.ToDate.Value.ToLongDateString() + " รวม " + leaveData.TotalDay + " วัน";
} else {
lbFTTDate.Text = "ไม่เคยลา";
}
lbStatistic.Text = "ลามาแล้ว " + leaveData.CountPast + " วัน / ลาครั้งนี้ " + leaveData.CountNow + " วัน / รวม " + leaveData.CountTotal + " วัน";
lbReason.Text = leaveData.Reason;
lbContact.Text = leaveData.Contact;
lbPhone.Text = leaveData.Telephone;
if (leaveData.LastFromDate.HasValue) {
lbLastFTTDate.Text = leaveData.LastFromDate.Value.ToLongDateString() + " ถึง " + leaveData.LastToDate.Value.ToLongDateString() + " รวม " + leaveData.LastTotalDay + " วัน";
} else {
lbLastFTTDate.Text = "ไม่เคยลา";
}
if (leaveData.DocterCertificationFileName != "") {
divDrCer.InnerHtml = "<a href='Upload/Drcer/" + leaveData.DocterCertificationFileName + "'><img src='Upload/DrCer/" + leaveData.DocterCertificationFileName + "' style='width: 200px;' /></a>";
}
/*lbCLComment.Text = "";
for (int j = 0; j < leaveData.LeaveBossDataList.Count; j++) {
if(!leaveData.LeaveBossDataList[j].Allow.HasValue) {
continue;
}
LeaveBossData leaveBossData = leaveData.LeaveBossDataList[j];
lbCLComment.Text += "<div style='color: #808080'>" + leaveBossData.Person.FirstNameAndLastName + " / " + leaveBossData.AllowDate.Value.ToLongDateString() + "</div><div style='margin-bottom: 10px;'> - " + leaveBossData.Comment + "</div>";
}*/
{
TableRow row = new TableRow();
TableCell cell2;
Image image;
tbBoss.Rows.Add(row);
for (int j = 0; j < leaveData.BossStateMax; j++) {
LeaveBossData leaveBossData = leaveData.LeaveBossDataList[j];
cell2 = new TableCell();
cell2.Style.Add("vertical-align", "top");
Table tb = new Table();
tb.CssClass = "ps-table-1";
tb.Style.Add("text-align", "left");
{
TableRow tr;
TableCell cell3;
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.ColumnSpan = 2;
cell3.Style.Add("text-align", "center");
image = new Image();
image.CssClass = "ps-ms-main-drop-profile-pic";
string imagePath = DatabaseManager.GetPersonImageFileName(leaveBossData.CitizenID);
if (imagePath != "") {
image.Attributes["src"] = "Upload/PersonImage/" + imagePath;
cell3.Controls.Add(image);
}
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ชื่อ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.FirstNameAndLastName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ตำแหน่ง";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.PositionWorkName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ระดับ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.AdminPositionName;// + "<br />" + leaveBossData.Person.AdminPositionNameExtra();
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "การอนุมัติ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
if (leaveData.LeaveStatusID == 1) {
if (leaveBossData.Allow.HasValue) {
cell3.Text = "<div style='color: #808080;'>" + leaveBossData.AllowDate.Value.ToLongDateString() + "</div>";
if (leaveBossData.Allow.Value == 1) {
cell3.Text += "<div style='color: green'>อนุญาต</div>";
} else {
cell3.Text += "<div style='color: red'>ไม่อนุญาต</div>";
}
cell3.Text += "<div style='color: #000000;'>" + leaveBossData.Comment + "</div>";
}
} else if(leaveData.LeaveStatusID == 4) {
if (leaveBossData.CancelAllow.HasValue) {
cell3.Text = "<div style='color: #808080;'>" + leaveBossData.CancelAllowDate.Value.ToLongDateString() + "</div>";
if (leaveBossData.CancelAllow.Value == 1) {
cell3.Text += "<div style='color: green'>อนุญาต</div>";
} else {
cell3.Text += "<div style='color: red'>ไม่อนุญาต</div>";
}
cell3.Text += "<div style='color: #000000;'>" + leaveBossData.CancelComment + "</div>";
}
}
tr.Cells.Add(cell3);
}
cell2.Controls.Add(tb);
row.Cells.Add(cell2);
}
}
lbCancelReason.Text = leaveData.CancelReason;
/*if (leaveData.LeaveStatusID >= 1 && leaveData.LeaveStatusID <= 4) {
if(leaveData.CL_ID == null) {
lbCLComment.Text = "-";
lbCLDate.Text = "-";
} else {
lbCLComment.Text = leaveData.CL_Comment;
lbCLDate.Text = leaveData.CL_Date.Value.ToLongDateString();
}
} else if (leaveData.LeaveStatusID >= 5 && leaveData.LeaveStatusID <= 8) {
if(leaveData.CL_ID == null) {
lbCLOldComment.Text = "-";
lbCLOldDate.Text = "-";
lbCHOldComment.Text = leaveData.CH_Comment;
lbCHOldDate.Text = leaveData.CH_Date.Value.ToLongDateString();
lbCancelReason.Text = leaveData.CancelReason;
lbCLComment.Text = "-";
lbCLDate.Text = "-";
} else {
lbCLOldComment.Text = leaveData.CL_Comment;
lbCLOldDate.Text = leaveData.CL_Date.Value.ToLongDateString();
lbCHOldComment.Text = leaveData.CH_Comment;
lbCHOldDate.Text = leaveData.CH_Date.Value.ToLongDateString();
lbCancelReason.Text = leaveData.CancelReason;
lbCLComment.Text = leaveData.CL_CancelComment;
lbCLDate.Text = leaveData.CL_CancelDate.Value.ToLongDateString();
}
}*/
MultiView1.ActiveViewIndex = 1;
error_area.Attributes["class"] = null;
error_area.InnerHtml = "";
};
TableCell cell = new TableCell();
cell.Controls.Add(lbu);
GridView1.Rows[i].Cells.Add(cell);
}
lbNoData.Visible = false;
} else {
lbNoData.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
/*if (!IsPostBack) {
ChangeNotification("info", "กรุณากรอกข้อมูล");
}*/
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
Person loginPerson = ps.LoginPerson;
//------
{
SqlDataSource sds = DatabaseManager.CreateSQLDataSource("SELECT LEAVE_ID รหัสการลา, (SELECT LEAVE_TYPE_NAME FROM LEV_TYPE WHERE LEV_TYPE.LEAVE_TYPE_ID = LEV_DATA.LEAVE_TYPE_ID) ประเภทการลา, REQ_DATE วันที่ข้อมูล, FROM_DATE จากวันที่, TO_DATE ถึงวันที่, TOTAL_DAY รวมวัน FROM LEV_DATA WHERE LEAVE_STATUS_ID = 1 AND PS_ID = '" + loginPerson.CitizenID + "' ORDER BY LEAVE_ID DESC");
gvLeaveProgress.DataSource = sds;
gvLeaveProgress.DataBind();
if (gvLeaveProgress.Rows.Count > 0) {
lbLeaveProgress.Visible = false;
TableHeaderCell headerCell = new TableHeaderCell();
headerCell.Text = "เลือก";
gvLeaveProgress.HeaderRow.Cells.Add(headerCell);
gvLeaveProgress.HeaderRow.Cells[0].Text = "<img src='Image/Small/ID.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[0].Text;
gvLeaveProgress.HeaderRow.Cells[1].Text = "<img src='Image/Small/list.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[1].Text;
gvLeaveProgress.HeaderRow.Cells[2].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[2].Text;
gvLeaveProgress.HeaderRow.Cells[3].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[3].Text;
gvLeaveProgress.HeaderRow.Cells[4].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[4].Text;
gvLeaveProgress.HeaderRow.Cells[6].Text = "<img src='Image/Small/pointer.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[6].Text;
for (int i = 0; i < gvLeaveProgress.Rows.Count; ++i) {
string ID = gvLeaveProgress.Rows[i].Cells[0].Text;
TableCell cell = new TableCell();
LinkButton btn = new LinkButton();
btn.CssClass = "ps-button";
btn.Text = "<img src='Image/Small/next.png'></img>";
btn.Click += (e2, e3) => {
lbuCancelFinish.Visible = false;
lbuCancelProgressFinish.Visible = true;
trCancelReason.Visible = false;
LeaveData leaveData = new LeaveData();
leaveData.Load(int.Parse(ID));
trPSBirthDate.Visible = false;
trPSWorkInDate.Visible = false;
trWifeName.Visible = false;
trGBDate.Visible = false;
trOrdained.Visible = false;
trTempleName.Visible = false;
trTempleLocation.Visible = false;
trOrdainDate.Visible = false;
trHujed.Visible = false;
trReason.Visible = false;
trContact.Visible = false;
trPhone.Visible = false;
trRestSave.Visible = false;
trRestLeft.Visible = false;
trRestTotal.Visible = false;
trStatistic.Visible = false;
if (leaveData.LeaveTypeID == 1) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 2) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 3) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 4) {
trRestSave.Visible = true;
trRestLeft.Visible = true;
trRestTotal.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 5) {
trWifeName.Visible = true;
trGBDate.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 6) {
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trOrdained.Visible = true;
trTempleName.Visible = true;
trTempleLocation.Visible = true;
trOrdainDate.Visible = true;
} else if (leaveData.LeaveTypeID == 7) {
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trHujed.Visible = true;
}
lbLeaveID.Text = leaveData.LeaveID.ToString();
lbLeaveTypeName.Text = leaveData.LeaveTypeName;
lbReqDate.Text = leaveData.RequestDate.Value.ToLongDateString();
lbPSName.Text = leaveData.Person.FirstName + " " + leaveData.Person.LastName;
lbPSPos.Text = leaveData.Person.PositionWorkName;
lbPSAPos.Text = leaveData.Person.AdminPositionName;
if (Util.IsBlank(leaveData.Person.WorkDivisionID)) {
lbPSDept.Text = leaveData.Person.DivisionName;
} else {
lbPSDept.Text = leaveData.Person.WorkDivisionName;
}
lbPSBirthDate.Text = leaveData.Person.BirthDate.Value.ToLongDateString();
lbPSWorkInDate.Text = leaveData.Person.InWorkDate.Value.ToLongDateString();
lbRestSave.Text = leaveData.RestSave + " วัน";
lbRestLeft.Text = leaveData.RestLeft + " วัน";
lbRestTotal.Text = leaveData.RestTotal + " วัน";
lbWifeName.Text = leaveData.WifeFirstName + " " + leaveData.WifeLastName;
if (leaveData.GiveBirthDate.HasValue) {
lbGBDate.Text = leaveData.GiveBirthDate.Value.ToLongDateString();
} else {
lbGBDate.Text = "-";
}
lbOrdained.Text = leaveData.Ordained == 1 ? "เคย" : "ไม่เคย";
lbTempleName.Text = leaveData.TempleName;
lbTempleLocation.Text = leaveData.TempleLocation;
if (leaveData.OrdainDate.HasValue) {
lbOrdainDate.Text = leaveData.OrdainDate.Value.ToLongDateString();
} else {
lbOrdainDate.Text = "-";
}
lbHujed.Text = leaveData.Hujed == 1 ? "เคย" : "ไม่เคย";
if (leaveData.FromDate.HasValue) {
lbFTTDate.Text = leaveData.FromDate.Value.ToLongDateString() + " ถึง " + leaveData.ToDate.Value.ToLongDateString() + " รวม " + leaveData.TotalDay + " วัน";
} else {
lbFTTDate.Text = "ไม่เคยลา";
}
lbStatistic.Text = "ลามาแล้ว " + leaveData.CountPast + " วัน / ลาครั้งนี้ " + leaveData.CountNow + " วัน / รวม " + leaveData.CountTotal + " วัน";
lbReason.Text = leaveData.Reason;
lbContact.Text = leaveData.Contact;
lbPhone.Text = leaveData.Telephone;
if (leaveData.LastFromDate.HasValue) {
lbLastFTTDate.Text = leaveData.LastFromDate.Value.ToLongDateString() + " ถึง " + leaveData.LastToDate.Value.ToLongDateString() + " รวม " + leaveData.LastTotalDay + " วัน";
} else {
lbLastFTTDate.Text = "ไม่เคยลา";
}
if (leaveData.DocterCertificationFileName != "") {
divDrCer.InnerHtml = "<a href='Upload/Drcer/" + leaveData.DocterCertificationFileName + "'><img src='Upload/DrCer/" + leaveData.DocterCertificationFileName + "' style='width: 200px;' /></a>";
}
{
TableRow row = new TableRow();
TableCell cell2;
Image image;
tbBoss.Rows.Add(row);
for (int j = 0; j < leaveData.BossStateMax; j++) {
LeaveBossData leaveBossData = leaveData.LeaveBossDataList[j];
cell2 = new TableCell();
cell2.Style.Add("vertical-align", "top");
Table tb = new Table();
tb.CssClass = "ps-table-1";
tb.Style.Add("text-align", "left");
{
TableRow tr;
TableCell cell3;
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.ColumnSpan = 2;
cell3.Style.Add("text-align", "center");
image = new Image();
image.CssClass = "ps-ms-main-drop-profile-pic";
string imagePath = DatabaseManager.GetPersonImageFileName(leaveBossData.CitizenID);
if (imagePath != "") {
image.Attributes["src"] = "Upload/PersonImage/" + imagePath;
cell3.Controls.Add(image);
}
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ชื่อ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.FirstNameAndLastName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ตำแหน่ง";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.PositionWorkName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ระดับ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.AdminPositionName;// + "<br />" + leaveBossData.Person.AdminPositionNameExtra();
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "การอนุมัติ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
if (leaveBossData.Allow.HasValue) {
cell3.Text = "<div style='color: #808080;'>" + leaveBossData.AllowDate.Value.ToLongDateString() + "</div>";
if (leaveBossData.Allow.Value == 1) {
cell3.Text += "<div style='color: green'>อนุญาต</div>";
} else {
cell3.Text += "<div style='color: red'>ไม่อนุญาต</div>";
}
cell3.Text += "<div style='color: #000000;'>" + leaveBossData.Comment + "</div>";
}
tr.Cells.Add(cell3);
}
cell2.Controls.Add(tb);
row.Cells.Add(cell2);
}
}
Session["LeaveData"] = leaveData;
MV1.ActiveViewIndex = 1;
//Response.Redirect("ViewLeaveForm.aspx?Form=1&LeaveID=" + ID);
};
cell.Controls.Add(btn);
gvLeaveProgress.Rows[i].Cells.Add(cell);
}
Util.NormalizeGridViewDate(gvLeaveProgress, 2);
Util.NormalizeGridViewDate(gvLeaveProgress, 3);
Util.NormalizeGridViewDate(gvLeaveProgress, 4);
} else {
lbLeaveProgress.Visible = true;
}
}
//--------
{
SqlDataSource sds = DatabaseManager.CreateSQLDataSource("SELECT LEAVE_ID รหัสการลา, (SELECT LEAVE_TYPE_NAME FROM LEV_TYPE WHERE LEV_TYPE.LEAVE_TYPE_ID = LEV_DATA.LEAVE_TYPE_ID) ประเภทการลา, REQ_DATE วันที่ข้อมูล, FROM_DATE จากวันที่, TO_DATE ถึงวันที่, TOTAL_DAY รวมวัน FROM LEV_DATA WHERE LEAVE_STATUS_ID = 3 AND PS_ID = '" + loginPerson.CitizenID + "' AND V_ALLOW = 1 AND CEIL(FROM_DATE - CURRENT_DATE) >= 3 ORDER BY LEAVE_ID DESC");
gvLeave.DataSource = sds;
gvLeave.DataBind();
if (gvLeave.Rows.Count > 0) {
lbLeave.Visible = false;
TableHeaderCell headerCell = new TableHeaderCell();
headerCell.Text = "เลือก";
gvLeave.HeaderRow.Cells.Add(headerCell);
gvLeave.HeaderRow.Cells[0].Text = "<img src='Image/Small/ID.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[0].Text;
gvLeave.HeaderRow.Cells[1].Text = "<img src='Image/Small/list.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[1].Text;
gvLeave.HeaderRow.Cells[2].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[2].Text;
gvLeave.HeaderRow.Cells[3].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[3].Text;
gvLeave.HeaderRow.Cells[4].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[4].Text;
gvLeave.HeaderRow.Cells[6].Text = "<img src='Image/Small/pointer.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[6].Text;
for (int i = 0; i < gvLeave.Rows.Count; ++i) {
string ID = gvLeave.Rows[i].Cells[0].Text;
TableCell cell = new TableCell();
LinkButton btn = new LinkButton();
btn.CssClass = "ps-button";
btn.Text = "<img src='Image/Small/next.png'></img>";
btn.Click += (e2, e3) => {
lbuCancelFinish.Visible = true;
lbuCancelProgressFinish.Visible = false;
trCancelReason.Visible = true;
LeaveData leaveData = new LeaveData();
leaveData.Load(int.Parse(ID));
trPSBirthDate.Visible = false;
trPSWorkInDate.Visible = false;
trWifeName.Visible = false;
trGBDate.Visible = false;
trOrdained.Visible = false;
trTempleName.Visible = false;
trTempleLocation.Visible = false;
trOrdainDate.Visible = false;
trHujed.Visible = false;
trReason.Visible = false;
trContact.Visible = false;
trPhone.Visible = false;
trRestSave.Visible = false;
trRestLeft.Visible = false;
trRestTotal.Visible = false;
trStatistic.Visible = false;
if (leaveData.LeaveTypeID == 1) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 2) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 3) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 4) {
trRestSave.Visible = true;
trRestLeft.Visible = true;
trRestTotal.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 5) {
trWifeName.Visible = true;
trGBDate.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 6) {
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trOrdained.Visible = true;
trTempleName.Visible = true;
trTempleLocation.Visible = true;
trOrdainDate.Visible = true;
} else if (leaveData.LeaveTypeID == 7) {
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trHujed.Visible = true;
}
lbLeaveID.Text = leaveData.LeaveID.ToString();
lbLeaveTypeName.Text = leaveData.LeaveTypeName;
lbReqDate.Text = leaveData.RequestDate.Value.ToLongDateString();
lbPSName.Text = leaveData.Person.FirstName + " " + leaveData.Person.LastName;
lbPSPos.Text = leaveData.Person.PositionWorkName;
lbPSAPos.Text = leaveData.Person.AdminPositionName;
if (Util.IsBlank(leaveData.Person.WorkDivisionID)) {
lbPSDept.Text = leaveData.Person.DivisionName;
} else {
lbPSDept.Text = leaveData.Person.WorkDivisionName;
}
lbPSBirthDate.Text = leaveData.Person.BirthDate.Value.ToLongDateString();
lbPSWorkInDate.Text = leaveData.Person.InWorkDate.Value.ToLongDateString();
lbRestSave.Text = leaveData.RestSave + " วัน";
lbRestLeft.Text = leaveData.RestLeft + " วัน";
lbRestTotal.Text = leaveData.RestTotal + " วัน";
lbWifeName.Text = leaveData.WifeFirstName + " " + leaveData.WifeLastName;
if (leaveData.GiveBirthDate.HasValue) {
lbGBDate.Text = leaveData.GiveBirthDate.Value.ToLongDateString();
} else {
lbGBDate.Text = "-";
}
lbOrdained.Text = leaveData.Ordained == 1 ? "เคย" : "ไม่เคย";
lbTempleName.Text = leaveData.TempleName;
lbTempleLocation.Text = leaveData.TempleLocation;
if (leaveData.OrdainDate.HasValue) {
lbOrdainDate.Text = leaveData.OrdainDate.Value.ToLongDateString();
} else {
lbOrdainDate.Text = "-";
}
lbHujed.Text = leaveData.Hujed == 1 ? "เคย" : "ไม่เคย";
if (leaveData.FromDate.HasValue) {
lbFTTDate.Text = leaveData.FromDate.Value.ToLongDateString() + " ถึง " + leaveData.ToDate.Value.ToLongDateString() + " รวม " + leaveData.TotalDay + " วัน";
} else {
lbFTTDate.Text = "ไม่เคยลา";
}
lbStatistic.Text = "ลามาแล้ว " + leaveData.CountPast + " วัน / ลาครั้งนี้ " + leaveData.CountNow + " วัน / รวม " + leaveData.CountTotal + " วัน";
lbReason.Text = leaveData.Reason;
lbContact.Text = leaveData.Contact;
lbPhone.Text = leaveData.Telephone;
if (leaveData.LastFromDate.HasValue) {
lbLastFTTDate.Text = leaveData.LastFromDate.Value.ToLongDateString() + " ถึง " + leaveData.LastToDate.Value.ToLongDateString() + " รวม " + leaveData.LastTotalDay + " วัน";
} else {
lbLastFTTDate.Text = "ไม่เคยลา";
}
if (leaveData.DocterCertificationFileName != "") {
divDrCer.InnerHtml = "<a href='Upload/Drcer/" + leaveData.DocterCertificationFileName + "'><img src='Upload/DrCer/" + leaveData.DocterCertificationFileName + "' style='width: 200px;' /></a>";
}
{
TableRow row = new TableRow();
TableCell cell2;
Image image;
tbBoss.Rows.Add(row);
for (int j = 0; j < leaveData.BossStateMax; j++) {
LeaveBossData leaveBossData = leaveData.LeaveBossDataList[j];
cell2 = new TableCell();
cell2.Style.Add("vertical-align", "top");
Table tb = new Table();
tb.CssClass = "ps-table-1";
tb.Style.Add("text-align", "left");
{
TableRow tr;
TableCell cell3;
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.ColumnSpan = 2;
cell3.Style.Add("text-align", "center");
image = new Image();
image.CssClass = "ps-ms-main-drop-profile-pic";
string imagePath = DatabaseManager.GetPersonImageFileName(leaveBossData.CitizenID);
if (imagePath != "") {
image.Attributes["src"] = "Upload/PersonImage/" + imagePath;
cell3.Controls.Add(image);
}
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ชื่อ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.FirstNameAndLastName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ตำแหน่ง";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.PositionWorkName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ระดับ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.AdminPositionName;// + "<br />" + leaveBossData.Person.AdminPositionNameExtra();
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "การอนุมัติ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
if(leaveBossData.Allow.HasValue) {
cell3.Text = "<div style='color: #808080;'>" + leaveBossData.AllowDate.Value.ToLongDateString() + "</div>";
if(leaveBossData.Allow.Value == 1) {
cell3.Text += "<div style='color: green'>อนุญาต</div>";
} else {
cell3.Text += "<div style='color: red'>ไม่อนุญาต</div>";
}
cell3.Text += "<div style='color: #000000;'>" + leaveBossData.Comment + "</div>";
}
tr.Cells.Add(cell3);
}
cell2.Controls.Add(tb);
row.Cells.Add(cell2);
}
}
Session["LeaveData"] = leaveData;
MV1.ActiveViewIndex = 1;
//Response.Redirect("ViewLeaveForm.aspx?Form=1&LeaveID=" + ID);
};
cell.Controls.Add(btn);
gvLeave.Rows[i].Cells.Add(cell);
}
Util.NormalizeGridViewDate(gvLeave, 2);
Util.NormalizeGridViewDate(gvLeave, 3);
Util.NormalizeGridViewDate(gvLeave, 4);
} else {
lbLeave.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack) {
int leaveID = int.Parse(Request.QueryString["LeaveID"]);
LeaveData leaveData = new LeaveData();
leaveData.Load(leaveID);
if (!leaveData.HasData) {
return;
}
trPSBirthDate.Visible = false;
trPSWorkInDate.Visible = false;
trWifeName.Visible = false;
trGBDate.Visible = false;
trOrdained.Visible = false;
trTempleName.Visible = false;
trTempleLocation.Visible = false;
trOrdainDate.Visible = false;
trHujed.Visible = false;
trReason.Visible = false;
trContact.Visible = false;
trPhone.Visible = false;
trRestSave.Visible = false;
trRestLeft.Visible = false;
trRestTotal.Visible = false;
trStatistic.Visible = false;
trCancelReason.Visible = false;
/* trCLCancelComment.Visible = false;
trCLCancelDate.Visible = false;
trCHCancelComment.Visible = false;
trCHCancelDate.Visible = false;
trCHCancelAllow.Visible = false;*/
if (leaveData.LeaveTypeID == 1) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 2) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 3) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 4) {
trRestSave.Visible = true;
trRestLeft.Visible = true;
trRestTotal.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 5) {
trWifeName.Visible = true;
trGBDate.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 6) {
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trOrdained.Visible = true;
trTempleName.Visible = true;
trTempleLocation.Visible = true;
trOrdainDate.Visible = true;
} else if (leaveData.LeaveTypeID == 7) {
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trHujed.Visible = true;
}
if (leaveData.LeaveStatusID >= 1 && leaveData.LeaveStatusID <= 3) {
} else if (leaveData.LeaveStatusID >= 4 && leaveData.LeaveStatusID <= 6) {
trCancelReason.Visible = true;
/* trCLCancelComment.Visible = true;
trCLCancelDate.Visible = true;
trCHCancelComment.Visible = true;
trCHCancelDate.Visible = true;
trCHCancelAllow.Visible = true;*/
}
lbLeaveID.Text = leaveData.LeaveID.ToString();
lbLeaveStatusID.Text = leaveData.LeaveStatusName;
lbLeaveType.Text = leaveData.LeaveTypeName;
lbReqDate.Text = leaveData.RequestDate.Value.ToLongDateString();
lbPSName.Text = leaveData.Person.FirstName + " " + leaveData.Person.LastName;
lbPSPos.Text = leaveData.Person.PositionWorkName;
lbPSAPos.Text = leaveData.Person.AdminPositionName;
if (Util.IsBlank(leaveData.Person.WorkDivisionID)) {
lbPSDept.Text = leaveData.Person.DivisionName;
} else {
lbPSDept.Text = leaveData.Person.WorkDivisionName;
}
//if (leaveData.PS_BirthDate.HasValue) {
lbPSBirthDate.Text = leaveData.Person.BirthDate.Value.ToLongDateString();
//} else {
// lbPSBirthDate.Text = "-";
//}
//if (leaveData.PS_WorkInDate.HasValue) {
lbPSWorkInDate.Text = leaveData.Person.InWorkDate.Value.ToLongDateString();
//} else {
// lbPSWorkInDate.Text = "-";
// }
lbRestSave.Text = leaveData.RestSave + " วัน";
lbRestLeft.Text = leaveData.RestLeft + " วัน";
lbRestTotal.Text = leaveData.RestTotal + " วัน";
lbWifeName.Text = leaveData.WifeFirstName + " " + leaveData.WifeLastName;
if (leaveData.GiveBirthDate.HasValue) {
lbGBDate.Text = leaveData.GiveBirthDate.Value.ToLongDateString();
} else {
lbGBDate.Text = "-";
}
lbOrdained.Text = leaveData.Ordained == 1 ? "เคย" : "ไม่เคย";
lbTempleName.Text = leaveData.TempleName;
lbTempleLocation.Text = leaveData.TempleLocation;
if (leaveData.OrdainDate.HasValue) {
lbOrdainDate.Text = leaveData.OrdainDate.Value.ToLongDateString();
} else {
lbOrdainDate.Text = "-";
}
lbHujed.Text = leaveData.Hujed == 1 ? "เคย" : "ไม่เคย";
if (leaveData.FromDate.HasValue) {
lbFTTDate.Text = leaveData.FromDate.Value.ToLongDateString() + " ถึง " + leaveData.ToDate.Value.ToLongDateString() + " รวม " + leaveData.TotalDay + " วัน";
} else {
lbFTTDate.Text = "ไม่เคยลา";
}
lbStatistic.Text = "ลามาแล้ว " + leaveData.CountPast + " วัน / ลาครั้งนี้ " + leaveData.CountNow + " วัน / รวม " + leaveData.CountTotal + " วัน";
lbReason.Text = leaveData.Reason;
lbContact.Text = leaveData.Contact;
lbPhone.Text = leaveData.Telephone;
if (leaveData.LastFromDate.HasValue) {
lbLastFTTDate.Text = leaveData.LastFromDate.Value.ToLongDateString() + " ถึง " + leaveData.LastToDate.Value.ToLongDateString() + " รวม " + leaveData.LastTotalDay + " วัน";
} else {
lbLastFTTDate.Text = "ไม่เคยลา";
}
{
TableRow row = new TableRow();
TableCell cell2;
Image image;
tbBoss.Rows.Add(row);
for (int j = 0; j < leaveData.BossStateMax; j++) {
LeaveBossData leaveBossData = leaveData.LeaveBossDataList[j];
cell2 = new TableCell();
cell2.Style.Add("vertical-align", "top");
Table tb = new Table();
tb.CssClass = "ps-table-1";
tb.Style.Add("text-align", "left");
{
TableRow tr;
TableCell cell3;
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.ColumnSpan = 2;
cell3.Style.Add("text-align", "center");
image = new Image();
image.CssClass = "ps-ms-main-drop-profile-pic";
string imagePath = DatabaseManager.GetPersonImageFileName(leaveBossData.CitizenID);
if (imagePath != "") {
image.Attributes["src"] = "Upload/PersonImage/" + imagePath;
cell3.Controls.Add(image);
}
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ชื่อ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.FirstNameAndLastName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ตำแหน่ง";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.PositionWorkName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ระดับ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.AdminPositionName;// + "<br />" + leaveBossData.Person.AdminPositionNameExtra();
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "การอนุมัติ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
if (leaveBossData.Allow.HasValue) {
cell3.Text = "<div style='color: #808080;'>" + leaveBossData.AllowDate.Value.ToLongDateString() + "</div>";
if (leaveBossData.Allow.Value == 1) {
cell3.Text += "<div style='color: green'>อนุญาต</div>";
} else {
cell3.Text += "<div style='color: red'>ไม่อนุญาต</div>";
}
cell3.Text += "<div style='color: #000000;'>" + leaveBossData.Comment + "</div>";
}
tr.Cells.Add(cell3);
if(leaveData.CancelAllow.HasValue) {
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "การอนุมัติยกเลิก";
tr.Cells.Add(cell3);
cell3 = new TableCell();
if (leaveBossData.CancelAllow.HasValue) {
cell3.Text = "<div style='color: #808080;'>" + leaveBossData.CancelAllowDate.Value.ToLongDateString() + "</div>";
if (leaveBossData.CancelAllow.Value == 1) {
cell3.Text += "<div style='color: green'>อนุญาต</div>";
} else {
cell3.Text += "<div style='color: red'>ไม่อนุญาต</div>";
}
cell3.Text += "<div style='color: #000000;'>" + leaveBossData.CancelComment + "</div>";
}
tr.Cells.Add(cell3);
}
}
cell2.Controls.Add(tb);
row.Cells.Add(cell2);
}
}
/*if(leaveData.CL_ID == null) {
lbCLName.Text = "-";
lbCLPos.Text = "-";
lbCLCom.Text = "-";
lbCLDate.Text = "-";
} else {
lbCLName.Text = leaveData.CL_Title + leaveData.CL_FirstName + " " + leaveData.CL_LastName;
lbCLPos.Text = leaveData.CL_Position;
if (leaveData.CL_Comment != "") {
lbCLCom.Text = leaveData.CL_Comment;
} else {
lbCLCom.Text = "-";
}
if (leaveData.CL_Date.HasValue) {
lbCLDate.Text = leaveData.CL_Date.Value.ToLongDateString();
} else {
lbCLDate.Text = "-";
}
}
lbCHName.Text = leaveData.CH_Title + leaveData.CH_FirstName + " " + leaveData.CH_LastName;
lbCHPos.Text = leaveData.CH_Position;
if (leaveData.CH_Comment != "") {
lbCHCom.Text = leaveData.CH_Comment;
} else {
lbCHCom.Text = "-";
}
if (leaveData.CH_Date.HasValue) {
lbCHDate.Text = leaveData.CH_Date.Value.ToLongDateString();
lbCHAllow.Text = leaveData.CH_Allow == 1 ? "อนุมัติ" : "ไม่อนุมัติ";
} else {
lbCHDate.Text = "-";
lbCHAllow.Text = "-";
}
if (leaveData.DocterCertificationFileName != "") {
string loc = "Upload/DrCer/" + leaveData.DocterCertificationFileName;
div_dr_cer.InnerHtml += "<a href='" + loc + "'><img src='" + loc + "' /></a>";
}
if (leaveData.LeaveStatusID >= 1 && leaveData.LeaveStatusID <= 4) {
} else if (leaveData.LeaveStatusID >= 5 && leaveData.LeaveStatusID <= 8) {
lbCancelReason.Text = leaveData.CancelReason;
if (leaveData.CL_CancelDate.HasValue) {
lbCL_C_Com.Text = leaveData.CL_CancelComment;
lbCL_C_Date.Text = leaveData.CL_CancelDate.Value.ToLongDateString();
} else {
lbCL_C_Com.Text = "-";
lbCL_C_Date.Text = "-";
}
if (leaveData.CH_CancelDate.HasValue) {
lbCH_C_Com.Text = leaveData.CH_CancelComment;
lbCH_C_Date.Text = leaveData.CH_CancelDate.Value.ToLongDateString();
lbCH_C_Allow.Text = leaveData.CH_CancelAllow == 1 ? "อนุมัติ" : "ไม่อนุมัติ";
} else {
lbCH_C_Com.Text = "-";
lbCH_C_Date.Text = "-";
lbCH_C_Allow.Text = "-";
}
}
string _psCLImage = DatabaseManager.GetPersonImageFileName(leaveData.CL_ID);
string _psCHImage = DatabaseManager.GetPersonImageFileName(leaveData.CH_ID);
if (_psCLImage != "") {
psCLImage.Src = "Upload/PersonImage/" + _psCLImage;
}
if (_psCHImage != "") {
psCHImage.Src = "Upload/PersonImage/" + _psCHImage;
}*/
}
}
private void FuncGVFinish()
{
OracleConnection.ClearAllPools();
SqlDataSource sds = DatabaseManager.CreateSQLDataSource("SELECT LEAVE_ID รหัสการลา, (SELECT LEAVE_TYPE_NAME FROM LEV_TYPE WHERE LEV_TYPE.LEAVE_TYPE_ID = LEV_DATA.LEAVE_TYPE_ID) ประเภทการลา, REQ_DATE วันที่ข้อมูล, FROM_DATE จากวันที่, TO_DATE ถึงวันที่, TOTAL_DAY รวมวัน, (SELECT LEAVE_STATUS_NAME FROM LEV_STATUS WHERE LEV_STATUS.LEAVE_STATUS_ID = LEV_DATA.LEAVE_STATUS_ID) สถานะ, NVL(V_ALLOW,0) ผลการอนุมัติ FROM LEV_DATA WHERE LEAVE_STATUS_ID in(2,5) AND PS_ID = '" + loginPerson.CitizenID + "' ORDER BY LEAVE_ID DESC");
gvFinish.DataSource = sds;
gvFinish.DataBind();
if (gvFinish.Rows.Count > 0) {
lbFinish.Visible = false;
TableHeaderCell headerCell = new TableHeaderCell();
headerCell.Text = "ตกลง";
gvFinish.HeaderRow.Cells.Add(headerCell);
gvFinish.HeaderRow.Cells[0].Text = "<img src='Image/Small/ID.png' class='icon_left'/>" + gvFinish.HeaderRow.Cells[0].Text;
gvFinish.HeaderRow.Cells[1].Text = "<img src='Image/Small/list.png' class='icon_left'/>" + gvFinish.HeaderRow.Cells[1].Text;
gvFinish.HeaderRow.Cells[2].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvFinish.HeaderRow.Cells[2].Text;
gvFinish.HeaderRow.Cells[3].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvFinish.HeaderRow.Cells[3].Text;
gvFinish.HeaderRow.Cells[4].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvFinish.HeaderRow.Cells[4].Text;
gvFinish.HeaderRow.Cells[6].Text = "<img src='Image/Small/question.png' class='icon_left'/>" + gvFinish.HeaderRow.Cells[6].Text;
gvFinish.HeaderRow.Cells[7].Text = "<img src='Image/Small/correct.png' class='icon_left'/>" + gvFinish.HeaderRow.Cells[7].Text;
for (int i = 0; i < gvFinish.Rows.Count; ++i) {
string ID = gvFinish.Rows[i].Cells[0].Text;
TableCell cell = new TableCell();
LinkButton btn = new LinkButton();
btn.CssClass = "ps-button-img";
btn.Text = "ตกลง";
btn.Click += (e2, e3) => {
LeaveData leaveData = new LeaveData();
leaveData.Load(int.Parse(ID));
if (leaveData.LeaveStatusID == 2) {
DatabaseManager.ExecuteNonQuery("UPDATE LEV_DATA SET LEAVE_STATUS_ID = 3 WHERE LEAVE_ID = " + ID);
} else if (leaveData.LeaveStatusID == 5) {
DatabaseManager.ExecuteNonQuery("UPDATE LEV_DATA SET LEAVE_STATUS_ID = 6 WHERE LEAVE_ID = " + ID);
}
Response.Redirect("LeaveHistory.aspx");
};
cell.Controls.Add(btn);
gvFinish.Rows[i].Cells.Add(cell);
if (Util.StringEqual(gvFinish.Rows[i].Cells[7].Text, new string[] { "2" })) {
gvFinish.Rows[i].Cells[7].Text = "ไม่อนุญาต";
gvFinish.Rows[i].Cells[7].ForeColor = System.Drawing.Color.Red;
}
if (Util.StringEqual(gvFinish.Rows[i].Cells[7].Text, new string[] { "1" })) {
gvFinish.Rows[i].Cells[7].Text = "อนุญาต";
gvFinish.Rows[i].Cells[7].ForeColor = System.Drawing.Color.Green;
}
}
Util.NormalizeGridViewDate(gvFinish, 2);
Util.NormalizeGridViewDate(gvFinish, 3);
Util.NormalizeGridViewDate(gvFinish, 4);
} else {
lbFinish.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
Person loginPerson = ps.LoginPerson;
int count = 0;// DatabaseManager.GetLeaveRequiredCountByCommanderLow(loginPerson.CitizenID); ;
/*using (OleDbConnection con = new OleDbConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OleDbCommand com = new OleDbCommand("SELECT COUNT(LEV_MAIN.LEAVE_ID) FROM LEV_MAIN, LEV_FORM1 WHERE LEV_MAIN.LEAVE_ID = LEV_FORM1.LEAVE_ID AND CMD_LOW_ID = '" + loginPerson.CitizenID + "' AND LEAVE_STATE = 1", con)) {
using (OleDbDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
count = int.Parse(reader.GetValue(0).ToString());
}
}
}
}*/
if (count == 0) {
error_area.InnerHtml = "ไม่มีรายการที่ท่านต้องลงความเห็น";
} else {
error_area.InnerHtml = "กรุณาเลือกรายการที่ต้องการลงความเห็น";
}
//error_area.Attributes["class"] = "alert alert_info";
error_area.Attributes["class"] = null;
error_area.InnerHtml = "";
if (count > 0) {
SqlDataSource sds = DatabaseManager.CreateSQLDataSource("SELECT LEAVE_ID รหัสการลา, (SELECT PS_FN_TH || ' ' || PS_LN_TH FROM PS_PERSON WHERE PS_CITIZEN_ID = LEV_DATA.PS_ID) ชื่อผู้ลา, (SELECT LEAVE_TYPE_NAME FROM LEV_TYPE WHERE LEV_TYPE.LEAVE_TYPE_ID = LEV_DATA.LEAVE_TYPE_ID) ประเภทการลา, REQ_DATE วันที่ข้อมูล, (SELECT LEAVE_STATUS_NAME FROM LEV_STATUS WHERE LEAVE_STATUS_ID = LEV_DATA.LEAVE_STATUS_ID) สถานะ FROM LEV_DATA WHERE LEAVE_STATUS_ID in(1,5) AND CL_ID = '" + loginPerson.CitizenID + "'");
GridView1.DataSource = sds;
GridView1.DataBind();
Util.NormalizeGridViewDate(GridView1, 3);
TableHeaderCell newHeader = new TableHeaderCell();
newHeader.Text = "เลือก";
GridView1.HeaderRow.Cells.Add(newHeader);
GridView1.HeaderRow.Cells[0].Text = "<img src='Image/Small/ID.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[0].Text;
GridView1.HeaderRow.Cells[1].Text = "<img src='Image/Small/person2.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[1].Text;
GridView1.HeaderRow.Cells[2].Text = "<img src='Image/Small/list.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[2].Text;
GridView1.HeaderRow.Cells[3].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[3].Text;
GridView1.HeaderRow.Cells[4].Text = "<img src='Image/Small/question.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[4].Text;
GridView1.HeaderRow.Cells[5].Text = "<img src='Image/Small/pointer.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[5].Text;
for (int i=0; i<GridView1.Rows.Count; ++i) {
if(GridView1.Rows[i].Cells[4].Text == "1") {
GridView1.Rows[i].Cells[4].Text = "ขอลา";
}
if (GridView1.Rows[i].Cells[4].Text == "5") {
GridView1.Rows[i].Cells[4].Text = "ยกเลิกลา";
}
string id = GridView1.Rows[i].Cells[0].Text;
LinkButton lbu = new LinkButton();
lbu.Text = "<img src='Image/Small/next.png'></img>";
lbu.CssClass = "ps-button";
lbu.Click += (e2, e3) => {
LeaveData leaveData = new LeaveData();
leaveData.Load(int.Parse(id));
Session["LeaveData"] = leaveData;
trPSBirthDate.Visible = false;
trPSWorkInDate.Visible = false;
trWifeName.Visible = false;
trGBDate.Visible = false;
trOrdained.Visible = false;
trTempleName.Visible = false;
trTempleLocation.Visible = false;
trOrdainDate.Visible = false;
trHujed.Visible = false;
trReason.Visible = false;
trContact.Visible = false;
trPhone.Visible = false;
trRestSave.Visible = false;
trRestLeft.Visible = false;
trRestTotal.Visible = false;
trStatistic.Visible = false;
trOldComment.Visible = false;
trOldDate.Visible = false;
trCancelReason.Visible = false;
if (leaveData.LeaveTypeID == 1) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 2) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 3) {
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 4) {
trRestSave.Visible = true;
trRestLeft.Visible = true;
trRestTotal.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 5) {
trWifeName.Visible = true;
trGBDate.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
} else if (leaveData.LeaveTypeID == 6) {
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trOrdained.Visible = true;
trTempleName.Visible = true;
trTempleLocation.Visible = true;
trOrdainDate.Visible = true;
} else if (leaveData.LeaveTypeID == 7) {
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trHujed.Visible = true;
}
if (leaveData.LeaveStatusID == 1) {
} else if (leaveData.LeaveStatusID == 5) {
trOldComment.Visible = true;
trOldDate.Visible = true;
trCancelReason.Visible = true;
}
lbLeaveID.Text = leaveData.LeaveID.ToString();
lbLeaveTypeName.Text = leaveData.LeaveTypeName;
lbReqDate.Text = leaveData.RequestDate.Value.ToLongDateString();
/* lbPSName.Text = leaveData.PS_Title + leaveData.PS_FirstName + " " + leaveData.PS_LastName;
lbPSPos.Text = leaveData.PS_Position;
lbPSAPos.Text = leaveData.PS_AdminPosition;
lbPSDept.Text = leaveData.PS_Department;
if (leaveData.PS_BirthDate.HasValue) {
lbPSBirthDate.Text = leaveData.PS_BirthDate.Value.ToLongDateString();
} else {
lbPSBirthDate.Text = "-";
}
if (leaveData.PS_WorkInDate.HasValue) {
lbPSWorkInDate.Text = leaveData.PS_WorkInDate.Value.ToLongDateString();
} else {
lbPSWorkInDate.Text = "-";
}*/
lbRestSave.Text = leaveData.RestSave + " วัน";
lbRestLeft.Text = leaveData.RestLeft + " วัน";
lbRestTotal.Text = leaveData.RestTotal + " วัน";
lbWifeName.Text = leaveData.WifeFirstName + " " + leaveData.WifeLastName;
if (leaveData.GiveBirthDate.HasValue) {
lbGBDate.Text = leaveData.GiveBirthDate.Value.ToLongDateString();
} else {
lbGBDate.Text = "-";
}
lbOrdained.Text = leaveData.Ordained == 1 ? "เคย" : "ไม่เคย";
lbTempleName.Text = leaveData.TempleName;
lbTempleLocation.Text = leaveData.TempleLocation;
if (leaveData.OrdainDate.HasValue) {
lbOrdainDate.Text = leaveData.OrdainDate.Value.ToLongDateString();
} else {
lbOrdainDate.Text = "-";
}
lbHujed.Text = leaveData.Hujed == 1 ? "เคย" : "ไม่เคย";
if (leaveData.FromDate.HasValue) {
lbFTTDate.Text = leaveData.FromDate.Value.ToLongDateString() + " ถึง " + leaveData.ToDate.Value.ToLongDateString() + " รวม " + leaveData.TotalDay + " วัน";
} else {
lbFTTDate.Text = "ไม่เคยลา";
}
lbStatistic.Text = "ลามาแล้ว " + leaveData.CountPast + " วัน / ลาครั้งนี้ " + leaveData.CountNow + " วัน / รวม " + leaveData.CountTotal + " วัน";
lbReason.Text = leaveData.Reason;
lbContact.Text = leaveData.Contact;
lbPhone.Text = leaveData.Telephone;
if (leaveData.LastFromDate.HasValue) {
lbLastFTTDate.Text = leaveData.LastFromDate.Value.ToLongDateString() + " ถึง " + leaveData.LastToDate.Value.ToLongDateString() + " รวม " + leaveData.LastTotalDay + " วัน";
} else {
lbLastFTTDate.Text = "ไม่เคยลา";
}
/* if(leaveData.LeaveStatusID >= 5 && leaveData.LeaveStatusID <= 8) {
lbOldComment.Text = leaveData.CL_Comment;
lbOldDate.Text = leaveData.CL_Date.Value.ToLongDateString();
lbCancelReason.Text = leaveData.CancelReason;
}*/
if (leaveData.DocterCertificationFileName != "") {
divDrCer.InnerHtml = "<a href='Upload/Drcer/" + leaveData.DocterCertificationFileName + "'><img src='Upload/DrCer/" + leaveData.DocterCertificationFileName + "' style='width: 200px;' /></a>";
}
MultiView1.ActiveViewIndex = 1;
error_area.Attributes["class"] = null;
error_area.InnerHtml = "";
};
TableCell cell = new TableCell();
cell.Controls.Add(lbu);
GridView1.Rows[i].Cells.Add(cell);
}
}
}
protected void lbuS1Check_Click(object sender, EventArgs e)
{
ClearNotification();
//PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
//Person loginPerson = ps.LoginPerson;
trS2BirthDate.Visible = false;
trS2WorkInDate.Visible = false;
trS2WifeName.Visible = false;
trS2GBDate.Visible = false;
trS2Ordained.Visible = false;
trS2TempleName.Visible = false;
trS2TempleLocation.Visible = false;
trS2OrdainDate.Visible = false;
trS2Hujed.Visible = false;
trS2Reason.Visible = false;
trS2Contact.Visible = false;
trS2Phone.Visible = false;
trS2DrCer.Visible = false;
trS2RestSave.Visible = false;
trS2RestLeft.Visible = false;
trS2RestTotal.Visible = false;
if (hfLeaveTypeID.Value == "1") {
trS2Reason.Visible = true;
trS2Contact.Visible = true;
trS2Phone.Visible = true;
trS2DrCer.Visible = true;
} else if (hfLeaveTypeID.Value == "2") {
trS2Reason.Visible = true;
trS2Contact.Visible = true;
trS2Phone.Visible = true;
} else if (hfLeaveTypeID.Value == "3") {
trS2Reason.Visible = true;
trS2Contact.Visible = true;
trS2Phone.Visible = true;
} else if (hfLeaveTypeID.Value == "4") {
trS2RestSave.Visible = true;
trS2RestLeft.Visible = true;
trS2RestTotal.Visible = true;
trS2Contact.Visible = true;
trS2Phone.Visible = true;
} else if (hfLeaveTypeID.Value == "5") {
trS2WifeName.Visible = true;
trS2GBDate.Visible = true;
trS2Contact.Visible = true;
trS2Phone.Visible = true;
} else if (hfLeaveTypeID.Value == "6") {
trS2BirthDate.Visible = true;
trS2WorkInDate.Visible = true;
trS2Ordained.Visible = true;
trS2TempleName.Visible = true;
trS2TempleLocation.Visible = true;
trS2OrdainDate.Visible = true;
trS2Phone.Visible = true;
} else if (hfLeaveTypeID.Value == "7") {
trS2BirthDate.Visible = true;
trS2WorkInDate.Visible = true;
trS2Hujed.Visible = true;
}
if(tbS1FromDate.Text == "" || tbS1ToDate.Text == "" || !Util.IsDateValid(tbS1FromDate.Text) || !Util.IsDateValid(tbS1ToDate.Text)) {
ChangeNotification("danger", "กรุณากรอกวันที่ให้ถูกต้อง");
return;
} else {
DateTime dtFromDate = Util.ToDateTimeOracle(tbS1FromDate.Text);
DateTime dtToDate = Util.ToDateTimeOracle(tbS1ToDate.Text);
int totalDay = (int)(dtToDate - dtFromDate).TotalDays + 1;
int fromToNowtotalDay = (int)(dtFromDate - DateTime.Today).TotalDays;
if (totalDay <= 0) {
ChangeNotification("danger", "วันที่ไม่ถูกต้อง");
return;
}
if ((DateTime.Today - dtFromDate).TotalDays >= 90) {
ChangeNotification("danger", "ไม่สามารถลาย้อนหลังมากกว่า 3 เดือน");
return;
}
if ((dtFromDate - DateTime.Today).TotalDays >= 90) {
ChangeNotification("danger", "ไม่สามารถลาล่วงหน้ามากกว่า 3 เดือน");
return;
}
if (dtFromDate.DayOfWeek == DayOfWeek.Saturday || dtFromDate.DayOfWeek == DayOfWeek.Sunday || dtToDate.DayOfWeek == DayOfWeek.Saturday || dtToDate.DayOfWeek == DayOfWeek.Sunday) {
ChangeNotification("danger", "ไม่สามารถเรื่มหรือจบการลาในวันเสาร์หรือาทิตย์ได้");
return;
}
int sick_now = -1;
int sick_max = -1;
int business_now = -1;
int business_max = -1;
int huj_now = -1;
int huj_max = -1;
int ordain_now = -1;
int ordain_max = -1;
{
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("SELECT SICK_NOW, SICK_MAX, BUSINESS_NOW, BUSINESS_MAX, HUJ_NOW, HUJ_MAX, ORDAIN_NOW, ORDAIN_MAX FROM LEV_CLAIM WHERE YEAR = " + Util.BudgetYear() + " AND PS_CITIZEN_ID = '" + loginPerson.CitizenID + "'", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
sick_now = reader.GetInt32(0);
sick_max = reader.GetInt32(1);
business_now = reader.GetInt32(2);
business_max = reader.GetInt32(3);
huj_now = reader.GetInt32(4);
huj_max = reader.GetInt32(5);
ordain_now = reader.GetInt32(6);
ordain_max = reader.GetInt32(7);
}
}
}
}
}
if(hfLeaveTypeID.Value == "1") {
if(sick_now + totalDay > sick_max) {
ChangeNotification("danger", "ไม่สามารถลาป่วยได้มากกว่า " + sick_max + " วัน คุณลาไปแล้ว " + sick_now + " วัน ครั้งนี้ " + totalDay + " วัน รวม " + (sick_now + totalDay) + " วัน");
return;
}
}
if (hfLeaveTypeID.Value == "2") {
if (fromToNowtotalDay < businessBeforeDay) {
ChangeNotification("danger", "ต้องลาล่วงหน้ามากกว่า " + businessBeforeDay + " วัน");
return;
} else if (business_now + totalDay > business_max) {
ChangeNotification("danger", "ไม่สามารถลากิจได้มากกว่า " + business_max + " วัน คุณลาไปแล้ว " + business_now + " วัน ครั้งนี้ " + totalDay + " วัน รวม " + (business_now + totalDay) + " วัน");
return;
}
}
if (hfLeaveTypeID.Value == "3") {
DateTime dt1 = DateTime.Today.AddDays(-giveBirthAfterDay);
if ((dtFromDate - dt1).TotalDays < 0) {
ChangeNotification("danger", "ไม่สามารถลาย้อนหลังได้มากกว่า " + giveBirthAfterDay + " วัน");
return;
}
}
if (hfLeaveTypeID.Value == "4") {
if (fromToNowtotalDay < restBeforeDay) {
ChangeNotification("danger", "ต้องลาล่วงหน้ามากกว่า " + restBeforeDay + " วัน");
return;
}
}
if (hfLeaveTypeID.Value == "5") {
DateTime dt1 = DateTime.Today.AddDays(-helpGiveBirthAfterDay);
if ((dtFromDate - dt1).TotalDays < 0) {
ChangeNotification("danger", "ไม่สามารถลาย้อนหลังได้มากกว่า " + helpGiveBirthAfterDay + " วัน");
return;
}
}
if (hfLeaveTypeID.Value == "6") {
if (fromToNowtotalDay < ordainBeforeDay) {
ChangeNotification("danger", "ต้องลาล่วงหน้ามากกว่า " + ordainBeforeDay + " วัน");
return;
} else if (huj_now + totalDay > huj_max) {
ChangeNotification("danger", "ไม่สามารถลาไปอุปสมบทได้มากกว่า " + ordain_max + " วัน คุณลาไปแล้ว " + ordain_now + " วัน ครั้งนี้ " + totalDay + " วัน รวม " + (ordain_now + totalDay) + " วัน");
return;
}
}
if (hfLeaveTypeID.Value == "7") {
if(fromToNowtotalDay < hujBeforeDay) {
ChangeNotification("danger", "ต้องลาล่วงหน้ามากกว่า " + hujBeforeDay + " วัน");
return;
}
else if (huj_now + totalDay > huj_max) {
ChangeNotification("danger", "ไม่สามารถลาไปประกอบพิธีฮัจญ์ได้มากกว่า " + huj_max + " วัน คุณลาไปแล้ว " + huj_now + " วัน ครั้งนี้ " + totalDay + " วัน รวม " + (huj_now + totalDay) + " วัน");
return;
}
}
{
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("SELECT LEAVE_ID FROM LEV_DATA WHERE " + Util.DatabaseToDateSearch(tbS1FromDate.Text) + " <= TO_DATE AND " + Util.DatabaseToDateSearch(tbS1ToDate.Text) + " >= FROM_DATE AND PS_ID = '" + loginPerson.CitizenID + "' AND BUDGET_YEAR = " + Util.BudgetYear() + " AND LEAVE_STATUS_ID IN(3,4) AND V_ALLOW = 1", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
LeaveData leaveData = new LeaveData();
leaveData.Load(reader.GetInt32(0));
ChangeNotification("danger", "ไม่สามารถลาได้ พบวันลาซ้อนทับกัน (รหัสการลา " + leaveData.LeaveID + ", " + leaveData.FromDate.Value.ToLongDateString() + " ถึง " + leaveData.ToDate.Value.ToLongDateString() + ")");
return;
}
}
}
using (OracleCommand com = new OracleCommand("SELECT TO_DATE FROM LEV_DATA WHERE PS_ID = '" + loginPerson.CitizenID + "' AND LEAVE_TYPE_ID = " + hfLeaveTypeID.Value + " AND EXTRACT(YEAR FROM FROM_DATE) = " + Util.BudgetYear() + " AND LEAVE_STATUS_ID IN(3,4) AND V_ALLOW = 1 ORDER BY LEAVE_ID DESC", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
if (reader.Read()) {
DateTime dtLastToDate = reader.GetDateTime(0);
if((dtFromDate - dtLastToDate).TotalDays <= 0) {
ChangeNotification("danger", "ไม่สามารถลาก่อนวันที่ลาล่าสุดได้ (" + dtLastToDate.ToLongDateString() + ")");
return;
}
}
}
}
}
}
}
if(hfLeaveTypeID.Value == "1" || hfLeaveTypeID.Value == "2" || hfLeaveTypeID.Value == "3") {
if(tbS1FromDate.Text == "" || tbS1ToDate.Text == "" || !Util.IsDateValid(tbS1FromDate.Text) || !Util.IsDateValid(tbS1ToDate.Text)) {
ChangeNotification("danger", "วันที่ไม่ถูกต้อง");
return;
}
if(tbS1Reason.Text == "") {
ChangeNotification("danger", "กรุณากรอกเหตุผล");
return;
}
if (tbS1Contact.Text == "") {
ChangeNotification("danger", "กรุณากรอกติดต่อได้ที่");
return;
}
if (tbS1Phone.Text == "") {
ChangeNotification("danger", "กรุณากรอกเบอร์โทรศัพท์");
return;
}
if(hfLeaveTypeID.Value == "1") {
DateTime dtFromDate = Util.ToDateTimeOracle(tbS1FromDate.Text);
DateTime dtToDate = Util.ToDateTimeOracle(tbS1ToDate.Text);
int totalDay = (int)(dtToDate - dtFromDate).TotalDays + 1;
if (totalDay >= 30 && !FileUpload1.HasFile) {
ChangeNotification("danger", "คุณต้องมีใบรับรองแพทย์เมื่อทำการลาเกิน 30 วัน ลาครั้งนี้ " + totalDay + " วัน");
return;
}
}
}
if (hfLeaveTypeID.Value == "4") {
if (tbS1FromDate.Text == "" || tbS1ToDate.Text == "" || !Util.IsDateValid(tbS1FromDate.Text) || !Util.IsDateValid(tbS1ToDate.Text)) {
ChangeNotification("danger", "วันที่ไม่ถูกต้อง");
return;
}
if (tbS1Contact.Text == "") {
ChangeNotification("danger", "กรุณากรอกติดต่อได้ที่");
return;
}
if (tbS1Phone.Text == "") {
ChangeNotification("danger", "กรุณากรอกเบอร์โทรศัพท์");
return;
}
DateTime dtFromDate = Util.ToDateTimeOracle(tbS1FromDate.Text);
DateTime dtToDate = Util.ToDateTimeOracle(tbS1ToDate.Text);
int totalDay = (int)(dtToDate - dtFromDate).TotalDays + 1;
int max = DatabaseManager.ExecuteInt("SELECT REST_MAX FROM LEV_CLAIM WHERE PS_CITIZEN_ID = '" + loginPerson.CitizenID + "' AND YEAR = " + Util.BudgetYear());
int now = DatabaseManager.ExecuteInt("SELECT REST_NOW FROM LEV_CLAIM WHERE PS_CITIZEN_ID = '" + loginPerson.CitizenID + "' AND YEAR = " + Util.BudgetYear());
if (now + totalDay > max) {
ChangeNotification("danger", "ปีนี้คุณไม่สามารถลาพักผ่อนเกิน " + max + " วันได้ ลาไปแล้ว " + now + " วัน ครั้งนี้ " + totalDay + " วัน รวม " + (totalDay + now) + " วัน");
return;
}
}
if (hfLeaveTypeID.Value == "5") {
if (tbS1WifeFirstName.Text == "") {
ChangeNotification("danger", "กรุณากรอกชื่อจริงภริยา");
return;
}
if (tbS1WifeLastName.Text == "") {
ChangeNotification("danger", "กรุณากรอกนามสกุลภริยา");
return;
}
if (tbS1GBDate.Text == "" || !Util.IsDateValid(tbS1GBDate.Text)) {
ChangeNotification("danger", "วันที่คลอดบุตรไม่ถูกต้อง");
return;
}
if (tbS1FromDate.Text == "" || tbS1ToDate.Text == "" || !Util.IsDateValid(tbS1FromDate.Text) || !Util.IsDateValid(tbS1ToDate.Text)) {
ChangeNotification("danger", "วันที่ไม่ถูกต้อง");
return;
}
if (tbS1Contact.Text == "") {
ChangeNotification("danger", "กรุณากรอกติดต่อได้ที่");
return;
}
if (tbS1Phone.Text == "") {
ChangeNotification("danger", "กรุณากรอกเบอร์โทรศัพท์");
return;
}
}
if (hfLeaveTypeID.Value == "6") {
if (!rbS1OrdainedT.Checked && !rbS1OrdainedF.Checked) {
ChangeNotification("danger", "กรุณาเลือกการอุปสมบท");
return;
}
if (tbS1TempleName.Text == "") {
ChangeNotification("danger", "กรุณากรอกชื่อวัด");
return;
}
if (tbS1TempleLocation.Text == "") {
ChangeNotification("danger", "กรุณากรอกสถานที่");
return;
}
if (tbS1OrdainDate.Text == "" || !Util.IsDateValid(tbS1OrdainDate.Text)) {
ChangeNotification("danger", "วันที่อุปสมบทไม่ถูกต้อง");
return;
}
if (tbS1FromDate.Text == "" || tbS1ToDate.Text == "" || !Util.IsDateValid(tbS1FromDate.Text) || !Util.IsDateValid(tbS1ToDate.Text)) {
ChangeNotification("danger", "วันที่ไม่ถูกต้อง");
return;
}
if (tbS1Phone.Text == "") {
ChangeNotification("danger", "กรุณากรอกเบอร์โทรศัพท์");
return;
}
}
if (hfLeaveTypeID.Value == "7") {
if (!rbS1HujedT.Checked && !rbS1HujedF.Checked) {
ChangeNotification("danger", "กรุณาเลือกการไปประกอบพิธีฮัจย์");
return;
}
if (tbS1FromDate.Text == "" || tbS1ToDate.Text == "" || !Util.IsDateValid(tbS1FromDate.Text) || !Util.IsDateValid(tbS1ToDate.Text)) {
ChangeNotification("danger", "วันที่ไม่ถูกต้อง");
return;
}
}
{
MV1.ActiveViewIndex = 2;
Session["LeaveSickFileUpload"] = FileUpload1;
divReq.Visible = false;
//ChangeNotification("info", "กรุณายืนยันข้อมูลอีกครั้ง");
string leavedDate = "ไม่เคยลา";
DateTime? lastFromDate = null;
DateTime? lastToDate = null;
int lastTotalDay = 0;
int pastTotalDay = DatabaseManager.ExecuteInt("SELECT NVL(SUM(TOTAL_DAY),0) FROM LEV_DATA WHERE PS_ID = '" + loginPerson.CitizenID + "' AND LEAVE_TYPE_ID = " + hfLeaveTypeID.Value + " AND EXTRACT(YEAR FROM FROM_DATE) = " + Util.BudgetYear() + " AND V_ALLOW = 1");
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("SELECT FROM_DATE, TO_DATE, TOTAL_DAY FROM LEV_DATA WHERE PS_ID = '" + loginPerson.CitizenID + "' AND LEAVE_TYPE_ID = " + hfLeaveTypeID.Value + " AND EXTRACT(YEAR FROM FROM_DATE) = " + Util.BudgetYear() + " AND V_ALLOW = 1 ORDER BY LEAVE_ID DESC", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
if (reader.Read()) {
lastFromDate = reader.GetDateTime(0);
lastToDate = reader.GetDateTime(1);
lastTotalDay = (int)(lastToDate.Value - lastFromDate.Value).TotalDays + 1;
leavedDate = lastFromDate.Value.ToLongDateString() + " ถึง " + lastToDate.Value.ToLongDateString() + " รวม " + lastTotalDay + " วัน ";
} else {
lastTotalDay = 0;
}
}
}
}
int restSave = -1;
int restLeft = -1;
int restTotal = -1;
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("SELECT REST_SAVE, REST_THIS FROM LEV_CLAIM WHERE PS_CITIZEN_ID = '" + loginPerson.CitizenID + "' AND YEAR = " + Util.BudgetYear(), con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
if (reader.Read()) {
restSave = reader.GetInt32(0);
restLeft = reader.GetInt32(1);
restTotal = restSave + restLeft;
}
}
}
}
lbS2PSName.Text = loginPerson.FullName;
lbS2PSPos.Text = loginPerson.PositionWorkName;
lbS2PSAPos.Text = loginPerson.AdminPositionName;
lbS2PSDept.Text = loginPerson.DivisionName;
lbS2PSBirthDate.Text = loginPerson.BirthDate.Value.ToLongDateString();
lbS2PSWorkInDate.Text = loginPerson.InWorkDate.Value.ToLongDateString();
lbS2RestSave.Text = restSave + " วัน";
lbS2RestLeft.Text = restLeft + " วัน";
lbS2RestTotal.Text = restTotal + " วัน";
lbS2WifeName.Text = tbS1WifeFirstName.Text + " " + tbS1WifeLastName.Text;
lbS2GBDate.Text = tbS1GBDate.Text;
lbS2Ordained.Text = rbS1OrdainedT.Checked ? "เคย" : "ไม่เคย";
lbS2TempleName.Text = tbS1TempleName.Text;
lbS2TempleLocation.Text = tbS1TempleLocation.Text;
lbS2OrdainDate.Text = tbS1OrdainDate.Text;
lbS2Hujed.Text = rbS1HujedT.Checked ? "เคย" : "ไม่เคย";
lbS2LastFTTDate.Text = leavedDate;
lbS2LeaveTypeName.Text = hfLeaveTypeName.Value;
DateTime dtFromDate = Util.ToDateTimeOracle(tbS1FromDate.Text);
DateTime dtToDate = Util.ToDateTimeOracle(tbS1ToDate.Text);
int totalDay = (int)(dtToDate - dtFromDate).TotalDays + 1;
lbS2FTTDate.Text = dtFromDate.ToLongDateString() + " ถึง " + dtToDate.ToLongDateString() + " รวม " + totalDay + " วัน";
lbS2Statistic.Text = "ลามาแล้ว " + pastTotalDay + " วัน / ลาครั้งนี้ " + totalDay + " วัน / รวม " + (pastTotalDay + totalDay) + " วัน";
lbS2Reason.Text = tbS1Reason.Text;
lbS2Contact.Text = tbS1Contact.Text;
lbS2Phone.Text = tbS1Phone.Text;
string drCer;
if (FileUpload1.HasFile) {
lbS2DrCer.Text = "มี";
FileInfo fi = new FileInfo(FileUpload1.FileName);
drCer = Util.RandomFileName() + fi.Extension;
} else {
lbS2DrCer.Text = "ไม่มี";
drCer = "";
}
//----------CL CH--
//string psCLID = "";
//string psCHID = "";
List<Person> psBossID = new List<Person>();
/*int อธิการบดีลาป่วยวัน = -1;
int อธิการบดีลากิจวัน = -1;
bool อธิการบดีลาคลอดบุตร = false;
bool อธิการบดีลาช่วยเหลือภริยาคลอดบุตร = false;
bool อธิการบดีลาพักผ่อน = false;
bool อธิการบดีลาอุปสมบทฮัจญ์ = false;
int คณะบดีลาป่วยวัน = -1;
int คณะบดีลากิจวัน = -1;
bool คณะบดีลาคลอดบุตร = false;
bool คณะบดีลาช่วยเหลือภริยาคลอดบุตร = false;
bool คณะบดีลาพักผ่อน = false;
bool คณะบดีลาอุปสมบทฮัจญ์ = false;
int หัวหน้าภาควิชาลาป่วยวัน = -1;
int หัวหน้าภาควิชาลากิจวัน = -1;
bool หัวหน้าภาควิชาลาคลอดบุตร = false;
bool หัวหน้าภาควิชาลาช่วยเหลือภริยาคลอดบุตร = false;
bool หัวหน้าภาควิชาลาพักผ่อน = false;
bool หัวหน้าภาควิชาลาอุปสมบทฮัจญ์ = false;
int หัวหน้าฝ่ายลาป่วยวัน = -1;
int หัวหน้าฝ่ายลากิจวัน = -1;
bool หัวหน้าฝ่ายลาคลอดบุตร = false;
bool หัวหน้าฝ่ายลาช่วยเหลือภริยาคลอดบุตร = false;
bool หัวหน้าฝ่ายลาพักผ่อน = false;
bool หัวหน้าฝ่ายลาอุปสมบทฮัจญ์ = false;
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("SELECT * FROM LEV_PERMISSION", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
int APOWER = reader.GetInt32(1);
if (APOWER == 1) {
อธิการบดีลาป่วยวัน = reader.GetInt32(2);
อธิการบดีลากิจวัน = reader.GetInt32(3);
อธิการบดีลาคลอดบุตร = Convert.ToBoolean(reader.GetInt32(4));
อธิการบดีลาช่วยเหลือภริยาคลอดบุตร = Convert.ToBoolean(reader.GetInt32(5));
อธิการบดีลาพักผ่อน = Convert.ToBoolean(reader.GetInt32(6));
อธิการบดีลาอุปสมบทฮัจญ์ = Convert.ToBoolean(reader.GetInt32(7));
} else if (APOWER == 2) {
คณะบดีลาป่วยวัน = reader.GetInt32(2);
คณะบดีลากิจวัน = reader.GetInt32(3);
คณะบดีลาคลอดบุตร = Convert.ToBoolean(reader.GetInt32(4));
คณะบดีลาช่วยเหลือภริยาคลอดบุตร = Convert.ToBoolean(reader.GetInt32(5));
คณะบดีลาพักผ่อน = Convert.ToBoolean(reader.GetInt32(6));
คณะบดีลาอุปสมบทฮัจญ์ = Convert.ToBoolean(reader.GetInt32(7));
} else if (APOWER == 3) {
หัวหน้าภาควิชาลาป่วยวัน = reader.GetInt32(2);
หัวหน้าภาควิชาลากิจวัน = reader.GetInt32(3);
หัวหน้าภาควิชาลาคลอดบุตร = Convert.ToBoolean(reader.GetInt32(4));
หัวหน้าภาควิชาลาช่วยเหลือภริยาคลอดบุตร = Convert.ToBoolean(reader.GetInt32(5));
หัวหน้าภาควิชาลาพักผ่อน = Convert.ToBoolean(reader.GetInt32(6));
หัวหน้าภาควิชาลาอุปสมบทฮัจญ์ = Convert.ToBoolean(reader.GetInt32(7));
} else if (APOWER == 4) {
หัวหน้าฝ่ายลาป่วยวัน = reader.GetInt32(2);
หัวหน้าฝ่ายลากิจวัน = reader.GetInt32(3);
หัวหน้าฝ่ายลาคลอดบุตร = Convert.ToBoolean(reader.GetInt32(4));
หัวหน้าฝ่ายลาช่วยเหลือภริยาคลอดบุตร = Convert.ToBoolean(reader.GetInt32(5));
หัวหน้าฝ่ายลาพักผ่อน = Convert.ToBoolean(reader.GetInt32(6));
หัวหน้าฝ่ายลาอุปสมบทฮัจญ์ = Convert.ToBoolean(reader.GetInt32(7));
}
}
}
}
}*/
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
List<Person> tempBossID = DatabaseManager.รหัสหัวหน้า(loginPerson.CitizenID);
for (int i = 0; i < tempBossID.Count; i++) {
int dayReq = 1;
bool ableAllow = false;
using (OracleCommand com = new OracleCommand("SELECT * FROM LEV_PERMISSION WHERE ADMIN_POSITION_POWER = " + tempBossID[i].AdminPositionPower + " ORDER BY LEAVE_PERMISSION_ID DESC", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
if (hfLeaveTypeID.Value == "1") {
dayReq = reader.GetInt32(2);
} else if (hfLeaveTypeID.Value == "2") {
dayReq = reader.GetInt32(3);
} else if (hfLeaveTypeID.Value == "3") {
ableAllow = reader.GetInt32(4) == 1 ? true : false;
} else if (hfLeaveTypeID.Value == "4") {
ableAllow = reader.GetInt32(6) == 1 ? true : false;
} else if (hfLeaveTypeID.Value == "5") {
ableAllow = reader.GetInt32(5) == 1 ? true : false;
} else if (hfLeaveTypeID.Value == "6") {
ableAllow = reader.GetInt32(7) == 1 ? true : false;
} else if (hfLeaveTypeID.Value == "7") {
ableAllow = reader.GetInt32(7) == 1 ? true : false;
}
}
}
}
if(hfLeaveTypeID.Value == "1" || hfLeaveTypeID.Value == "2") {
if (dayReq >= totalDay) {
psBossID.Add(tempBossID[i]);
break;
} else {
psBossID.Add(tempBossID[i]);
}
} else {
if(ableAllow) {
psBossID.Add(tempBossID[i]);
break;
} else {
psBossID.Add(tempBossID[i]);
}
}
}
}
{
TableRow row = new TableRow();
TableCell cell2;
System.Web.UI.WebControls.Image image;
tbBoss.Rows.Add(row);
for (int j = 0; j < psBossID.Count; j++) {
cell2 = new TableCell();
cell2.Style.Add("vertical-align", "top");
Table tb = new Table();
tb.CssClass = "ps-table-1";
tb.Style.Add("text-align", "left");
{
TableRow tr;
TableCell cell3;
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.ColumnSpan = 2;
cell3.Style.Add("text-align", "center");
image = new System.Web.UI.WebControls.Image();
image.CssClass = "ps-ms-main-drop-profile-pic";
string imagePath = DatabaseManager.GetPersonImageFileName(psBossID[j].CitizenID);
if (imagePath != "") {
image.Attributes["src"] = "Upload/PersonImage/" + imagePath;
cell3.Controls.Add(image);
}
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ชื่อ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = psBossID[j].FirstNameAndLastName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ตำแหน่ง";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = psBossID[j].PositionWorkName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ระดับ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = psBossID[j].AdminPositionName + "<br />" + psBossID[j].AdminPositionNameExtra();
tr.Cells.Add(cell3);
}
cell2.Controls.Add(tb);
row.Cells.Add(cell2);
}
}
/*{
TableRow row = new TableRow();
TableCell cell;
System.Web.UI.WebControls.Image image;
tbBoss.Rows.Add(row);
for (int i = 0; i < psBossID.Count; i++) {
cell = new TableCell();
image = new System.Web.UI.WebControls.Image();
image.CssClass = "ps-ms-main-drop-profile-pic";
string imagePath = DatabaseManager.GetPersonImageFileName(psBossID[i].CitizenID);
if (imagePath != "") {
image.Attributes["src"] = "Upload/PersonImage/" + imagePath;
cell.Controls.Add(image);
}
Panel p2 = new Panel();
Label lb = new Label();
lb.Text = "<span class='ps-lb-red-b'>" + psBossID[i].FirstNameAndLastName + "</span><br /><span style='color: #808080;'>" + psBossID[i].CitizenID + "</span><br />" + psBossID[i].PositionWorkName + "<br />" + psBossID[i].AdminPositionName + "<br />" + psBossID[i].AdminPositionNameExtra();
p2.Controls.Add(lb);
cell.Controls.Add(p2);
row.Cells.Add(cell);
}
}*/
/*if(hfLeaveTypeID.Value == "1") {
if(totalDay <= หัวหน้าฝ่ายลาป่วยวัน) {
if(loginPerson.AdminPositionPower == "0") { //ไม่มี
if(loginPerson.IsTeacher()) {
psBossID.Add(DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID));
} else if(loginPerson.WorkDivisionID != null) {
psBossID.Add(DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.DivisionID));
} else {
psBossID.Add(DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID));
}
} else if (loginPerson.AdminPositionPower == "1") { //หัวหน้าฝ่าย
if (loginPerson.IsTeacher()) {
psBossID.Add(DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID));
} else if (loginPerson.WorkDivisionID != null) {
psBossID.Add(DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.DivisionID));
} else {
psBossID.Add(DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID));
}
psCHID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
} else if (totalDay <= หัวหน้าภาควิชาลาป่วยวัน) {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCHID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
} else if (totalDay <= คณะบดีลาป่วยวัน) {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCLID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
} else if (totalDay <= อธิการบดีลาป่วยวัน) {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCLID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCLID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
} else {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCLID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCLID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCLID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
}
} else if (hfLeaveTypeID.Value == "2") {
if (totalDay <= หัวหน้าฝ่ายลากิจวัน) {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCHID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCHID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
} else if (totalDay <= หัวหน้าภาควิชาลากิจวัน) {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCHID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
} else if (totalDay <= คณะบดีลากิจวัน) {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCLID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
} else if (totalDay <= อธิการบดีลากิจวัน) {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCLID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCLID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
} else {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCLID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCLID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCLID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
}
} else if (hfLeaveTypeID.Value == "3") {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCHID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
} else if (hfLeaveTypeID.Value == "4") {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCHID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCHID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
} else if (hfLeaveTypeID.Value == "5") {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCLID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCLID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCHID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
} else if (hfLeaveTypeID.Value == "6" || hfLeaveTypeID.Value == "7") {
if (loginPerson.AdminPositionID == "0" || loginPerson.AdminPositionID == "8" || loginPerson.AdminPositionID == "9") { //ไม่มี
psCLID = DatabaseManager.รหัสหัวหน้าฝ่าย(loginPerson.WorkDivisionID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "4") { //หัวหน้าฝ่าย
psCLID = DatabaseManager.รหัสหัวหน้าภาควิชา(loginPerson.DivisionID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "7") { //หัวหน้าภาควิชา
psCLID = DatabaseManager.รหัสคณบดี(loginPerson.FacultyID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "3" || loginPerson.AdminPositionID == "6") { //คณบดี
psCLID = DatabaseManager.รหัสอธิการบดี(loginPerson.CampusID);
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "1" || loginPerson.AdminPositionID == "2" || loginPerson.AdminPositionID == "5") { //อธิการบดี
psCHID = DatabaseManager.รหัสเลขาธิการคณะกรรมการ();
} else if (loginPerson.AdminPositionID == "10022") { //เลขาธิการคณะกรรมการ
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
} else if (loginPerson.AdminPositionID == "10021") { //รัฐมนตรีเจ้าสังกัด
psCHID = DatabaseManager.รหัสรัฐมนตรีเจ้าสังกัด();
}
}*/
//Person psCL = DatabaseManager.GetPerson("1"/*psCLID*/);
// Person psCH = DatabaseManager.GetPerson("1"/*psCHID*/);
/* if(psCLID == "" && psCL == null) {
lbS2CL.Text = "ไม่มี";
psCLImage.Visible = false;
}
if (psCL != null) {
lbS2CL.Text = "<span class='ps-lb-red-b'>" + psCL.FirstNameAndLastName + "</span><br />" + psCL.CitizenID + "<br />" + psCL.PositionWorkName + "<br />" + psCL.AdminPositionName;
psCLImage.Visible = true;
} else {
lbS2CL.Text = "ไม่มี";
psCLImage.Visible = false;
}
if ( (psCLID != "" && psCL == null) || (psCHID != "" && psCH == null)) {
if (psCLID != "" && psCL == null) {
psCLImage.Visible = false;
lbS2CL.Text = "พบข้อผิดพลาด<br />ไม่พบพนักงาน";
lbS2CL.ForeColor = Color.Red;
}
if (psCHID != "" && psCH == null) {
psCHImage.Visible = false;
lbS2CH.Text = "พบข้อผิดพลาด<br />ไม่พบพนักงาน";
lbS2CH.ForeColor = Color.Red;
}
lbuS2Finish.Visible = false;
return;
}*/
/* psCLImage.Visible = true;
psCHImage.Visible = true;
lbS2CL.ForeColor = Color.Black;
lbS2CH.ForeColor = Color.Black;
lbuS2Finish.Visible = true;*/
//Person psCL = DatabaseManager.GetPerson("1700070000701");
//Person psCH = DatabaseManager.GetPerson("1700070000702");
/* if (psCL == null) {
lbS2CL.Text = "-";
}*/
//----------- END CL CH--
LeaveData leaveData = new LeaveData();
leaveData.LeaveTypeID = int.Parse(hfLeaveTypeID.Value);
leaveData.LeaveStatusID = 1;
leaveData.PS_ID = loginPerson.CitizenID;
leaveData.RequestDate = DateTime.Now;
leaveData.FromDate = dtFromDate;
leaveData.ToDate = dtToDate;
leaveData.TotalDay = totalDay;
leaveData.Reason = tbS1Reason.Text;
leaveData.Contact = tbS1Contact.Text;
leaveData.Telephone = tbS1Phone.Text;
if (lastFromDate.HasValue) {
leaveData.LastFromDate = lastFromDate;
leaveData.LastToDate = lastToDate;
}
leaveData.LastTotalDay = lastTotalDay;
leaveData.DocterCertificationFileName = drCer;
leaveData.CountPast = pastTotalDay;
leaveData.CountNow = totalDay;
leaveData.CountTotal = pastTotalDay + totalDay;
leaveData.RestLeft = restLeft;
leaveData.RestSave = restSave;
leaveData.RestTotal = restTotal;
leaveData.WifeFirstName = tbS1WifeFirstName.Text;
leaveData.WifeLastName = tbS1WifeLastName.Text;
if(hfLeaveTypeID.Value == "5")
leaveData.GiveBirthDate = Util.ToDateTimeOracle(tbS1GBDate.Text);
leaveData.Ordained = rbS1OrdainedT.Checked ? 1 : 0;
leaveData.TempleName = tbS1TempleName.Text;
leaveData.TempleLocation = tbS1TempleLocation.Text;
if (hfLeaveTypeID.Value == "6")
leaveData.OrdainDate = Util.ToDateTimeOracle(tbS1OrdainDate.Text);
leaveData.Hujed = rbS1HujedT.Checked ? 1 : 0;
for (int i = 0; i < psBossID.Count; i++) {
LeaveBossData leaveBossData = new LeaveBossData();
leaveBossData.CitizenID = psBossID[i].CitizenID;
leaveData.AddBoss(leaveBossData);
}
Session["LeaveData"] = leaveData;
hfFileUploadName.Value = drCer;
}
}
private Table BindToTableLeaveID(int leaveID)
{
//Label1.Text = "(1 ตุลาคม " + (int.Parse(DropDownList1.SelectedValue) - 1) + " - 30 กันยายน " + DropDownList1.SelectedValue + ")";
Table table = new Table();
table.CssClass = "ps-table-1";
int budgetYear = int.Parse(DropDownList1.SelectedValue) - 543;
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
const int maxCol = 2;
{
TableHeaderRow row = new TableHeaderRow();
{ TableHeaderCell cell = new TableHeaderCell(); cell.Text = "สรุปข้อมูลการลาหยุดราชการ ขาดราชการ มาสาย ประจำปีงบประมาณ ประจำปีงบประมาณ พ.ศ. " + DropDownList1.SelectedValue; cell.ColumnSpan = maxCol; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableHeaderRow row = new TableHeaderRow();
{ TableHeaderCell cell = new TableHeaderCell(); cell.Text = "มหาวิทยาลัยเทคโนโลยีราชมงคลตะวันออก"; cell.ColumnSpan = maxCol; row.Cells.Add(cell); }
table.Rows.Add(row);
}
TableHeaderRow rowXT = new TableHeaderRow();
TableHeaderCell cellXT = new TableHeaderCell();
{
{ cellXT.Text = loginPerson.FirstNameAndLastName; cellXT.ColumnSpan = maxCol; rowXT.Cells.Add(cellXT); }
table.Rows.Add(rowXT);
}
{
TableHeaderRow row = new TableHeaderRow();
{ TableHeaderCell cell = new TableHeaderCell(); cell.Text = ""; cell.ColumnSpan = maxCol; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableHeaderRow row = new TableHeaderRow();
{ TableHeaderCell cell = new TableHeaderCell(); cell.Text = "ข้อมูลการลา"; cell.ColumnSpan = maxCol; row.Cells.Add(cell); }
table.Rows.Add(row);
}
LeaveData leaveData = new LeaveData();
leaveData.Load(leaveID);
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "รหัสการลา"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = "" + leaveData.LeaveID; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "สถานะการลา"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = "" + leaveData.LeaveStatusName; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "ประเภทการลา"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = "" + leaveData.LeaveTypeName; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "วันที่ข้อมูล"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = "" + leaveData.RequestDate.Value.ToLongDateString(); row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "ชื่อผู้ลา"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = "" + leaveData.Person.FirstNameAndLastName; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "ตำแหน่ง"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = "" + leaveData.Person.PositionWorkName; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "ระดับ"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = "" + leaveData.Person.AdminPositionName + leaveData.Person.AdminPositionNameExtra() == "ไม่มี" ? "" : leaveData.Person.AdminPositionNameExtra(); row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "สังกัด"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = Util.IsBlank(leaveData.Person.WorkDivisionID) ? leaveData.Person.DivisionName : leaveData.Person.WorkDivisionName; row.Cells.Add(cell); }
table.Rows.Add(row);
}
if (leaveData.LeaveTypeID == 4) {
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "วันลาพักผ่อนสะสม"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.RestSave + " วัน"; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "มีสิทธิลาประจำปีนี้อีก"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.RestLeft + " วัน"; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "รวม"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.RestTotal + " วัน"; row.Cells.Add(cell); }
table.Rows.Add(row);
}
}
if (leaveData.LeaveTypeID == 6) {
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "การอุปสมบท"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.Ordained == 1 ? "เคย" : "ไม่เคย"; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "ชื่อวัด"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.TempleName; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "สถานที่"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.TempleLocation; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "อุปสมบทวันที่"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.OrdainDate.Value.ToLongDateString(); row.Cells.Add(cell); }
table.Rows.Add(row);
}
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "วันที่ลาล่าสุด"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.LastFromDate.HasValue ? leaveData.LastFromDate.Value.ToLongDateString() + " ถึง " + leaveData.LastToDate.Value.ToLongDateString() + " รวม " + leaveData.LastTotalDay + " วัน " : "ยังไม่เคยลา"; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "วันที่ลา"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.FromDate.Value.ToLongDateString() + " ถึง " + leaveData.ToDate.Value.ToLongDateString() + " รวม " + leaveData.TotalDay + " วัน "; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "สถิติการลา"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = "ลามาแล้ว " + leaveData.CountPast + " วัน / รวมครั้งนี้ " + leaveData.CountNow + " วัน / รวม " + leaveData.CountTotal + " วัน "; row.Cells.Add(cell); }
table.Rows.Add(row);
}
if(leaveData.LeaveTypeID == 1 || leaveData.LeaveTypeID == 2 || leaveData.LeaveTypeID == 3) {
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "เหตุผล"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.Reason; row.Cells.Add(cell); }
table.Rows.Add(row);
}
if (leaveData.LeaveStatusID >= 4 && leaveData.LeaveStatusID <= 6){
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "เหตุผลที่ยกเลิก"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.CancelReason; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "ติดต่อได้ที่"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveData.Contact; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "เบอร์โทรศัพท์"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = "'" + leaveData.Telephone; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableHeaderRow row = new TableHeaderRow();
{ TableHeaderCell cell = new TableHeaderCell(); cell.Text = ""; cell.ColumnSpan = maxCol; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableHeaderRow row = new TableHeaderRow();
{ TableHeaderCell cell = new TableHeaderCell(); cell.Text = "ผู้อนุมัติการลา"; cell.ColumnSpan = maxCol; row.Cells.Add(cell); }
table.Rows.Add(row);
}
List<LeaveBossData> leaveBossDataList = leaveData.LeaveBossDataList;
for (int i = 0; i < leaveBossDataList.Count; i++) {
LeaveBossData leaveBossData = leaveBossDataList[i];
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "ชื่อ"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveBossData.Person.FirstNameAndLastName; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "ตำแหน่ง"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveBossData.Person.PositionWorkName; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "ระดับ"; row.Cells.Add(cell); }
{ TableCell cell = new TableCell(); cell.Text = leaveBossData.Person.AdminPositionName; row.Cells.Add(cell); }
table.Rows.Add(row);
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "การอนุมัติ"; row.Cells.Add(cell); }
string sss = "";
sss += "<div>" + leaveBossData.AllowDate.Value.ToLongDateString() + "</div>";
if(leaveBossData.Allow == 1) {
sss += "<div style='color:green;'>อนุญาต</div>";
} else {
sss += "<div style='color:red;'>ไม่อนุญาต</div>";
}
sss += "<div>" + leaveBossData.Comment + "</div>";
{ TableCell cell = new TableCell(); cell.Text = sss; row.Cells.Add(cell); }
table.Rows.Add(row);
}
if (leaveData.LeaveStatusID >= 4 && leaveData.LeaveStatusID <= 6) {
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = "การอนุมัติยกเลิก"; row.Cells.Add(cell); }
string sss = "";
sss += "<div>" + leaveBossData.CancelAllowDate.Value.ToLongDateString() + "</div>";
if (leaveBossData.CancelAllow == 1) {
sss += "<div style='color:green;'>อนุญาต</div>";
} else {
sss += "<div style='color:red;'>ไม่อนุญาต</div>";
}
sss += "<div>" + leaveBossData.CancelComment + "</div>";
{ TableCell cell = new TableCell(); cell.Text = sss; row.Cells.Add(cell); }
table.Rows.Add(row);
}
}
{
TableRow row = new TableRow();
{ TableCell cell = new TableCell(); cell.Text = ""; cell.ColumnSpan = 2; row.Cells.Add(cell); }
table.Rows.Add(row);
}
}
}
return table;
}