private void ReadSelectID() { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT CITIZEN_ID,(SELECT UNIV_NAME_TH FROM REF_UNIV WHERE REF_UNIV.UNIV_ID = UOC_STAFF.UNIV_ID) UNIV_NAME,(SELECT FULLNAME FROM REF_PREFIX_NAME WHERE UOC_STAFF.PREFIX_NAME = REF_PREFIX_NAME.PREFIX_NAME_ID) PREFIX_NAME,STF_FNAME,STF_LNAME,(SELECT GENDER_NAME FROM REF_GENDER WHERE REF_GENDER.GENDER_ID = UOC_STAFF.GENDER_ID) GENDER_NAME,BIRTHDAY,HOMEADD,MOO,STREET,(SELECT PROVINCE_NAME_TH FROM REF_PROVINCE WHERE REF_PROVINCE.PROVINCE_ID = UOC_STAFF.PROVINCE_ID) PROVINCE_NAME,(SELECT DISTRICT_NAME_TH FROM REF_DISTRICT WHERE REF_DISTRICT.DISTRICT_ID = UOC_STAFF.DISTRICT_ID) DISTRICT_NAME,(SELECT SUB_DISTRICT_NAME_TH FROM REF_SUB_DISTRICT WHERE REF_SUB_DISTRICT.SUB_DISTRICT_ID = UOC_STAFF.SUB_DISTRICT_ID) SUB_DISTRICT_NAME,TELEPHONE,ZIPCODE,(SELECT NATION_NAME_ENG FROM REF_NATION WHERE REF_NATION.NATION_ID = UOC_STAFF.NATION_ID) NATION_NAME,(SELECT STAFFTYPE_NAME FROM REF_STAFFTYPE WHERE REF_STAFFTYPE.STAFFTYPE_ID = UOC_STAFF.STAFFTYPE_ID) STAFFTYPE_NAME,(SELECT TIME_CONTACT_NAME FROM REF_TIME_CONTACT WHERE REF_TIME_CONTACT.TIME_CONTACT_ID = UOC_STAFF.TIME_CONTACT_ID) TIME_CONTACT_NAME,(SELECT BUDGET_NAME FROM REF_BUDGET WHERE REF_BUDGET.BUDGET_ID = UOC_STAFF.BUDGET_ID) BUDGET_NAME,(SELECT SUBSTAFFTYPE_NAME FROM REF_SUBSTAFFTYPE WHERE REF_SUBSTAFFTYPE.SUBSTAFFTYPE_ID = UOC_STAFF.SUBSTAFFTYPE_ID) SUBSTAFFTYPE_NAME,(SELECT ADMIN_NAME FROM REF_ADMIN WHERE REF_ADMIN.ADMIN_ID = UOC_STAFF.ADMIN_POSITION_ID) ADMIN_POSITION_NAME,(SELECT POSITION_NAME_TH FROM REF_POSITION WHERE REF_POSITION.POSITION_ID = UOC_STAFF.POSITION_ID) POSITION_NAME,POSITION_WORK,(SELECT FAC_NAME FROM REF_FAC WHERE REF_FAC.FAC_ID = UOC_STAFF.DEPARTMENT_ID) DEPARTMENT_NAME,DATE_INWORK,DATE_START_THIS_U,SPECIAL_NAME,(SELECT ISCED_NAME FROM REF_ISCED WHERE REF_ISCED.ISCED_ID = UOC_STAFF.TEACH_ISCED_ID) TEACH_ISCED_NAME,(SELECT LEV_NAME_TH FROM REF_LEV WHERE REF_LEV.LEV_ID = UOC_STAFF.GRAD_LEV_ID) GRAD_LEV_NAME,GRAD_CURR,(SELECT ISCED_NAME FROM REF_ISCED WHERE REF_ISCED.ISCED_ID = UOC_STAFF.GRAD_ISCED_ID) GRAD_ISCED_NAME,(SELECT PROGRAM_NAME FROM REF_PROGRAM WHERE REF_PROGRAM.PROGRAM_ID_NEW = UOC_STAFF.GRAD_PROG) GRAD_PROG,GRAD_UNIV,(SELECT NATION_NAME_ENG FROM REF_NATION WHERE REF_NATION.NATION_ID = UOC_STAFF.GRAD_COUNTRY_ID) GRAD_COUNTRY_NAME,(SELECT DEFORM_NAME FROM REF_DEFORM WHERE REF_DEFORM.DEFORM_ID = UOC_STAFF.DEFORM_ID) DEFORM_NAME,SIT_NO,SALARY,POSITION_SALARY,(SELECT RELIGION_NAME_TH FROM REF_RELIGION WHERE REF_RELIGION.RELIGION_ID = UOC_STAFF.RELIGION_ID) RELIGION_NAME_TH,(SELECT MOVEMENT_TYPE_NAME FROM REF_MOVEMENT_TYPE WHERE REF_MOVEMENT_TYPE.MOVEMENT_TYPE_ID = UOC_STAFF.MOVEMENT_TYPE_ID) MOVEMENT_TYPE_NAME,MOVEMENT_DATE,DECORATION,RESULT1,PERCENT_SALARY1,RESULT2,PERCENT_SALARY2 FROM UOC_STAFF WHERE UOC_ID = '" + loginPerson.UOC_ID + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { int i = 0; lbCitizenID.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbUniv.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbPrefixName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbLastName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbGender.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbBirthday.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd/MM/yyyy"); ++i; lbHomeAdd.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; } } } } }
protected void btn1_Click(object sender, EventArgs e) { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF LoginPerson = ps.LoginPerson; if (FileUpload1.HasFile) { FileInfo fi = new FileInfo(FileUpload1.FileName); string fname = RandomFileName() + fi.Extension; FileUpload1.SaveAs(Server.MapPath("~/Upload/PersonImage/" + fname)); using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("INSERT INTO PS_PERSON_IMAGE (ID, CITIZEN_ID, URL, PRESENT) VALUES (PS_PERSON_IMAGE_SEQ.NEXTVAL, :CITIZEN_ID, :URL, :PRESENT)", con)) { com.Parameters.AddWithValue("CITIZEN_ID", LoginPerson.CITIZEN_ID); com.Parameters.AddWithValue("URL", fname); int v1 = 0; com.Parameters.AddWithValue("PRESENT", v1); com.ExecuteNonQuery(); } } } Page.Response.Redirect(Page.Request.Url.ToString(), true); }
protected void lbuBack_Click(object sender, EventArgs e) { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; int count = 0; using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT COUNT(LEAVE_ID) FROM LEV_LEAVE WHERE CMD_HIGH_ID = '" + loginPerson.CITIZEN_ID + "' AND LEV_LEAVE.STATE_ID = 3", con)) { using (OracleDataReader 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 = ""; MultiView1.ActiveViewIndex = 0; }
private void fBack() { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; int count = 0; OracleConnection.ClearAllPools(); using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT COUNT(LEAVE_ID) FROM LEV_LEAVE WHERE CMD_LOW_ID = '" + loginPerson.CITIZEN_ID + "' AND LEV_LEAVE.STATE_ID = 1", con)) { using (OracleDataReader 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 = ""; MultiView1.ActiveViewIndex = 0; }
protected void lbuUpdatePerson_Click(object sender, EventArgs e) { if (tbZipcode.Text.Length != 5) { MultiView1.ActiveViewIndex = 0; ScriptManager.GetCurrent(this.Page).SetFocus(this.tbZipcode); ChangeNotification("danger", "กรุณากรอกรหัสไปรษณีย์ให้ครบ 5 หลัก"); return; } PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; PS_PERSON person = new PS_PERSON(); person.HOMEADD = tbHomeAdd.Text; person.MOO = tbMoo.Text; person.STREET = tbStreet.Text; person.SUB_DISTRICT_ID = ddlSubDistrict.SelectedValue; person.DISTRICT_ID = ddlDistrict.SelectedValue; person.PROVINCE_ID = ddlProvince.SelectedValue; person.TELEPHONE = tbTelephone.Text; person.ZIPCODE = tbZipcode.Text; person.NATION_ID = ddlNation.SelectedValue; person.UOC_ID = loginPerson.UOC_ID; person.UPDATE_PERSON_USER(); INSERT_REQUEST(); MultiView1.ActiveViewIndex = 3; btnSelectView0.Visible = false; btnSelectView1.Visible = false; btnSelectView2.Visible = false; btnUpdatePerson.Visible = false; }
protected void BindData() { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING); OracleDataAdapter sda = new OracleDataAdapter("SELECT (SELECT STF_FNAME || ' ' || STF_LNAME FROM UOC_STAFF WHERE UOC_STAFF.UOC_ID = TB_PROJECT.UOC_ID) NAME, (SELECT CATEGORY_NAME FROM TB_PROJECT_CATEGORY WHERE TB_PROJECT_CATEGORY.CATEGORY_ID = TB_PROJECT.CATEGORY_ID) CATEGORY_ID, PROJECT_NAME, ADDRESS_PROJECT, PRO_ID FROM TB_PROJECT ORDER BY UOC_ID ASC", con); DataTable dt = new DataTable(); sda.Fill(dt); myRepeater.DataSource = dt; myRepeater.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); loginPerson = ps.LoginPerson; LoadCalendar(Table1, DateTime.Today); LoadCalendar(Table2, DateTime.Today.AddMonths(1)); if (!IsPostBack) { LoadAbsentLate(); } }
private void ReadSelectID() { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT HOMEADD,MOO,STREET,PROVINCE_ID,DISTRICT_ID,SUB_DISTRICT_ID,TELEPHONE,ZIPCODE,NATION_ID,SPECIAL_NAME,TEACH_ISCED_ID,UNIV_ID,PREFIX_NAME,STF_FNAME,STF_LNAME FROM UOC_STAFF WHERE CITIZEN_ID = '" + loginPerson.CITIZEN_ID + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { int i = 0; tbHomeAdd.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbMoo.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbStreet.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; ddlProvince.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; ddlDistrict.Items.Clear(); string s1 = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; DatabaseManager.BindDropDown(ddlDistrict, "SELECT * FROM REF_DISTRICT WHERE PROVINCE_ID = " + ddlProvince.SelectedValue, "DISTRICT_NAME_TH", "DISTRICT_ID", "--กรุณาเลือกอำเภอ--"); ddlDistrict.SelectedValue = s1; ddlSubDistrict.Items.Clear(); string s2 = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; DatabaseManager.BindDropDown(ddlSubDistrict, "SELECT * FROM REF_SUB_DISTRICT WHERE DISTRICT_ID = " + ddlDistrict.SelectedValue, "SUB_DISTRICT_NAME_TH", "SUB_DISTRICT_ID", "--กรุณาเลือกตำบล--"); ddlSubDistrict.SelectedValue = s2; tbTelephone.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbZipcode.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; ddlNation.SelectedValue = reader.IsDBNull(i) ? null : reader.GetString(i); ++i; lbSpecialName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbTeachISCED.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; // ddlUniv.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; ddlPrefixName.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbLastName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; } } } } }
//private List<DateTime> datetimeList; protected void Page_Load(object sender, EventArgs e) { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); pp = ps.LoginPerson; //datetimeList = DatabaseManager.GetLeaveDateTimeFromToDate(pp.CitizenID); LoadCalendar(Panel1, DateTime.Today); if (!IsPostBack) { DateTime dt = DateTime.Today; ddlMonth.SelectedValue = "" + dt.Month; tbYear.Text = "" + (dt.Year + 543); } }
protected void Page_Load(object sender, EventArgs e) { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); loginPerson = ps.LoginPerson; FuncGVFinish(); FuncGVProcessing(); FuncGVHistory(); FuncGVCH(); FuncLeaveClaim(); if (!IsPostBack) { lbuVS1.CssClass = "ps-tab-selected"; } }
protected void Page_Load(object sender, EventArgs e) { loginPerson = PersonnelSystem.GetPersonnelSystem(this).LoginPerson; if (!IsPostBack) { //Session["LeaveReportTable"] = null; for (int i = 2500; i < 2600; ++i) { DropDownList1.Items.Add(new System.Web.UI.WebControls.ListItem("" + i, "" + i)); } //DateTime dt = Util.ODTT(); /*if (dt.Month >= 10) { * DropDownList1.SelectedValue = "" + (dt.Year + 1); * } else { * DropDownList1.SelectedValue = "" + dt.Year; * }*/ DropDownList1.SelectedValue = "" + (Util.BudgetYear() + 543); ddlView.Items.Add(new ListItem("แสดงทั้งหมด", "1")); ddlView.Items.Add(new ListItem("แสดงเฉพาะภายในวิทยาเขต", "2")); ddlView.Items.Add(new ListItem("แสดงเฉพาะภายใน สำนัก / สถาบัน / คณะ", "3")); ddlView.Items.Add(new ListItem("แสดงเฉพาะภายใน กอง / สำนักงานเลขา / ภาควิชา", "4")); ddlView.Items.Add(new ListItem("แสดงเฉพาะภายใน งาน / ฝ่าย", "5")); ddlView.Items.Add(new ListItem("แสดงเฉพาะตนเอง", "6")); ddlSelfView.Items.Add(new ListItem("แสดงการลาทั้งหมด", "1")); ddlSelfView.Items.Add(new ListItem("แสดงตามรหัสการลา", "2")); /* trSelfView.Style.Add("display", "none"); * trSelfViewLeaveID.Style.Add("display", "none");*/ } /*if(Session["LeaveReportTable"] != null) { * Table tb = (Table)Session["LeaveReportTable"]; * Panel1.Controls.Clear(); * Panel1.Controls.Add(tb); * }*/ }
protected void Page_Load(object sender, EventArgs e) { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; if (!IsPostBack) { if (loginPerson.IsLoginFirst()) { TitleDivNamePassOld.Visible = false; divPassOld.Visible = false; tbPasswordOld.Visible = false; } if (loginPerson.IsLoginSecond()) { tbPasswordOld.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); loginPerson = ps.LoginPerson; if (!IsPostBack) { if (MultiView1.ActiveViewIndex == 0) { btnSelectView0.CssClass = "btn btn-info"; btnSelectView1.CssClass = "btn btn-primary"; btnSelectView2.CssClass = "btn btn-primary"; } BindDDL(); ReadSelectID(); BindLabel(); } }
protected void Page_Load(object sender, EventArgs e) { UOC_STAFF ps = PersonnelSystem.GetPersonnelSystem(this).LoginPerson; if (!IsPostBack) { SQLCampus(); using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT BOSS_NODE_ID, BOSS_NODE_NAME FROM TB_BOSS_NODE", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { ddlHighNode.Items.Add(new ListItem(reader.GetInt32(0) + " | " + reader.GetString(1), reader.GetInt32(0) + "")); } } } } } BindTable(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; GridView1.DataSource = DatabaseManager.CreateSQLDataSource("SELECT * FROM LEV_CLAIM WHERE PS_CITIZEN_ID = '" + loginPerson.UOC_ID + "'"); GridView1.DataBind(); /*using(OleDbConnection con = new OleDbConnection(DatabaseManager.CONNECTION_STRING)) { * con.Open(); * using(OleDbCommand com = new OleDbCommand("SELECT * FROM LEV_CLAIM WHERE PS_CITIZEN_ID = '" + loginPerson.CitizenID + "' AND YEAR = EXTRACT(YEAR FROM CURRENT_DATE)", con)) { * using(OleDbDataReader reader = com.ExecuteReader()) { * while(reader.Read()) { * //lbKij.Text = reader.GetValue(9).ToString() + "/" + reader.GetValue(10).ToString(); * lbRest.Text = reader.GetValue(11).ToString() + "/" + reader.GetValue(12).ToString(); * //lbOrdain.Text = reader.GetValue(13).ToString() + "/" + reader.GetValue(14).ToString(); * } * } * } * }*/ } }
private void ReadSelectID() { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT CITIZEN_ID,(SELECT UNIV_NAME_TH FROM REF_UNIV WHERE REF_UNIV.UNIV_ID = UOC_STAFF.UNIV_ID) UNIV_NAME,(SELECT FULLNAME FROM REF_PREFIX_NAME WHERE UOC_STAFF.PREFIX_NAME = REF_PREFIX_NAME.PREFIX_NAME_ID) PREFIX_NAME,STF_FNAME,STF_LNAME,(SELECT GENDER_NAME FROM REF_GENDER WHERE REF_GENDER.GENDER_ID = UOC_STAFF.GENDER_ID) GENDER_NAME,BIRTHDAY,HOMEADD,MOO,STREET,(SELECT PROVINCE_NAME_TH FROM REF_PROVINCE WHERE REF_PROVINCE.PROVINCE_ID = UOC_STAFF.PROVINCE_ID) PROVINCE_NAME,(SELECT DISTRICT_NAME_TH FROM REF_DISTRICT WHERE REF_DISTRICT.DISTRICT_ID = UOC_STAFF.DISTRICT_ID) DISTRICT_NAME,(SELECT SUB_DISTRICT_NAME_TH FROM REF_SUB_DISTRICT WHERE REF_SUB_DISTRICT.SUB_DISTRICT_ID = UOC_STAFF.SUB_DISTRICT_ID) SUB_DISTRICT_NAME,TELEPHONE,ZIPCODE,(SELECT NATION_NAME_ENG FROM REF_NATION WHERE REF_NATION.NATION_ID = UOC_STAFF.NATION_ID) NATION_NAME,(SELECT STAFFTYPE_NAME FROM REF_STAFFTYPE WHERE REF_STAFFTYPE.STAFFTYPE_ID = UOC_STAFF.STAFFTYPE_ID) STAFFTYPE_NAME,(SELECT TIME_CONTACT_NAME FROM REF_TIME_CONTACT WHERE REF_TIME_CONTACT.TIME_CONTACT_ID = UOC_STAFF.TIME_CONTACT_ID) TIME_CONTACT_NAME,(SELECT BUDGET_NAME FROM REF_BUDGET WHERE REF_BUDGET.BUDGET_ID = UOC_STAFF.BUDGET_ID) BUDGET_NAME,(SELECT SUBSTAFFTYPE_NAME FROM REF_SUBSTAFFTYPE WHERE REF_SUBSTAFFTYPE.SUBSTAFFTYPE_ID = UOC_STAFF.SUBSTAFFTYPE_ID) SUBSTAFFTYPE_NAME,(SELECT ADMIN_NAME FROM REF_ADMIN WHERE REF_ADMIN.ADMIN_ID = UOC_STAFF.ADMIN_POSITION_ID) ADMIN_POSITION_NAME,(SELECT POSITION_NAME_TH FROM REF_POSITION WHERE REF_POSITION.POSITION_ID = UOC_STAFF.POSITION_ID) POSITION_NAME,POSITION_WORK,(SELECT FAC_NAME FROM REF_FAC WHERE REF_FAC.FAC_ID = UOC_STAFF.DEPARTMENT_ID) DEPARTMENT_NAME,DATE_INWORK,DATE_START_THIS_U,SPECIAL_NAME,(SELECT ISCED_NAME FROM REF_ISCED WHERE REF_ISCED.ISCED_ID = UOC_STAFF.TEACH_ISCED_ID) TEACH_ISCED_NAME,(SELECT LEV_NAME_TH FROM REF_LEV WHERE REF_LEV.LEV_ID = UOC_STAFF.GRAD_LEV_ID) GRAD_LEV_NAME,GRAD_CURR,(SELECT ISCED_NAME FROM REF_ISCED WHERE REF_ISCED.ISCED_ID = UOC_STAFF.GRAD_ISCED_ID) GRAD_ISCED_NAME,(SELECT PROGRAM_NAME FROM REF_PROGRAM WHERE REF_PROGRAM.PROGRAM_ID_NEW = UOC_STAFF.GRAD_PROG) GRAD_PROG,GRAD_UNIV,(SELECT NATION_NAME_ENG FROM REF_NATION WHERE REF_NATION.NATION_ID = UOC_STAFF.GRAD_COUNTRY_ID) GRAD_COUNTRY_NAME,(SELECT DEFORM_NAME FROM REF_DEFORM WHERE REF_DEFORM.DEFORM_ID = UOC_STAFF.DEFORM_ID) DEFORM_NAME,SIT_NO,SALARY,POSITION_SALARY,(SELECT RELIGION_NAME_TH FROM REF_RELIGION WHERE REF_RELIGION.RELIGION_ID = UOC_STAFF.RELIGION_ID) RELIGION_NAME_TH,(SELECT MOVEMENT_TYPE_NAME FROM REF_MOVEMENT_TYPE WHERE REF_MOVEMENT_TYPE.MOVEMENT_TYPE_ID = UOC_STAFF.MOVEMENT_TYPE_ID) MOVEMENT_TYPE_NAME,MOVEMENT_DATE,DECORATION,RESULT1,PERCENT_SALARY1,RESULT2,PERCENT_SALARY2 FROM UOC_STAFF WHERE UOC_ID = '" + loginPerson.UOC_ID + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { int i = 0; lbCitizenID.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbUniv.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbPrefixName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbLastName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbGender.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbBirthday.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd/MM/yyyy"); ++i; lbHomeAdd.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbMoo.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbStreet.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbProvince.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbDistrict.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbSubDistrict.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbTelephone.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbZipcode.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbNation.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbStaffType.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbTimeContact.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbBudget.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbSubStafftype.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbAdminPosition.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbPosition.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbPositionWork.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbDepartment.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbDateInwork.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd/MM/yyyy"); ++i; lbDateStartThisU.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd/MM/yyyy"); ++i; lbSpecialName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbTeachISCED.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbGradLev.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbGradCURR.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbGradISCED.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbGradProg.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbGradUniv.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbGradCountry.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbDeform.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbSitNo.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbSalary.Text = reader.IsDBNull(i) ? "" : reader.GetInt32(i).ToString(); ++i; lbPositionSalary.Text = reader.IsDBNull(i) ? "" : reader.GetInt32(i).ToString(); ++i; lbReligion.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbMovementType.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbMovementDate.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd/MM/yyyy"); ++i; lbDecoration.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbResult1.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbPercentSalary1.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbResult2.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; lbPercentSalary2.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; } } } } }
protected void btnUpdateProject_Click(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { string[] validFileTypes = { "pdf" }; string ext = System.IO.Path.GetExtension(FUdocument.PostedFile.FileName); bool isValidFile = false; for (int i = 0; i < validFileTypes.Length; i++) { if (ext == "." + validFileTypes[i]) { isValidFile = true; break; } } if (!isValidFile) { ScriptManager.GetCurrent(this.Page).SetFocus(this.FUdocument); ChangeNotification("danger", "กรุณาแนบไฟล์นามสกุล " + string.Join(",", validFileTypes) + " เท่านั้น"); return; } else if (FUdocument.PostedFile.ContentLength > 26214400) { ScriptManager.GetCurrent(this.Page).SetFocus(this.FUdocument); ChangeNotification("danger", "กรุณาแนบไฟล์ไม่เกิน 25 MB"); return; } else { ChangeNotification("", ""); } if (tbStartDate.Text != "" && tbEndDate.Text != "") { DateTime dtEndDate = DateTime.Parse(tbEndDate.Text); DateTime dtStartDate = DateTime.Parse(tbStartDate.Text); int totalDay = (int)(dtEndDate - dtStartDate).TotalDays + 1; if (totalDay <= 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div> <img src='Image/Small/red_alert.png' /> วันที่เริ่มโครงการ - วันที่สิ้นสุดโครงการ : วันที่ไม่ถูกต้อง !</div>"; ScriptManager.GetCurrent(this.Page).SetFocus(this.tbStartDate); return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } } PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; PROJECT p = new PROJECT(); p.Load(int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()))); p.CATEGORY_ID = Convert.ToInt32(ddlCategory.SelectedValue); p.PROJECT_NAME = tbProjectName.Text; p.ADDRESS_PROJECT = tbAddressProject.Text; p.START_DATE = DateTime.Parse(tbStartDate.Text); p.END_DATE = DateTime.Parse(tbEndDate.Text); p.EXPENSES = Convert.ToInt32(tbExpenses.Text); p.FUNDING = tbFunding.Text; p.CERTIFICATE = tbCertificate.Text; p.SUMMARIZE_PROJECT = tbSummarizeProject.Text; p.RESULT_TEACHING = tbResultTeaching.Text; p.RESULT_ACADEMIC = tbResultAcademic.Text; p.DIFFICULTY_PROJECT = tbDifficultyProject.Text; p.RESULT_PROJECT = tbResultProject.Text; p.RESULT_RESEARCHING = tbResultResearching.Text; p.RESULT_OTHER = tbResultOther.Text; p.COUNSEL = tbCounsel.Text; p.COUNTRY_ID = Convert.ToInt32(ddlCountry.SelectedValue); p.SUB_COUNTRY_ID = Convert.ToInt32(ddlSubCountry.SelectedValue); if (FUdocument.HasFile) { string CountBase = DatabaseManager.ExecuteString("select count(*) from tb_project where pro_id = '" + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + "'"); FileInfo fi = new FileInfo(FUdocument.FileName); string imgFile = "UID=" + p.UOC_ID + "&count=" + CountBase + fi.Extension; FUdocument.SaveAs(Server.MapPath("Upload/Project/PDF/" + imgFile)); p.IMG_FILE = imgFile; } p.PRO_ID = int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())); p.UPDATE_PROJECT(); Notsuccess.Visible = false; success.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; int count = DatabaseManager.GetLeaveRequiredCountByCommander(loginPerson.CITIZEN_ID); /* 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.CITIZEN_ID + "'"); 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.BIRTHDAY.Value.ToLongDateString(); //} else { // lbPSBirthDate.Text = "-"; //} //if (leaveData.PS_WorkInDate.HasValue) { lbPSWorkInDate.Text = leaveData.Person.DATE_INWORK.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); UOC_STAFF 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.CITIZEN_ID + "' 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.BIRTHDAY.Value.ToLongDateString(); lbPSWorkInDate.Text = leaveData.Person.DATE_INWORK.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.CITIZEN_ID + "' 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.BIRTHDAY.Value.ToLongDateString(); lbPSWorkInDate.Text = leaveData.Person.DATE_INWORK.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 btnChangePassword_Click(object sender, EventArgs e) { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; if (loginPerson.IsLoginFirst()) { Label12X.Text = ""; if (tbPasswordNew.Text == "") { Label12X.Text = "กรุณากรอกรหัสผ่านใหม่"; Label12X.ForeColor = System.Drawing.Color.Red; return; } if (tbPasswordNewAgain.Text == "") { Label12X.Text = "กรุณากรอกรหัสผ่านใหม่อีกครั้ง"; Label12X.ForeColor = System.Drawing.Color.Red; return; } if (tbPasswordNew.Text == "" || tbPasswordNewAgain.Text == "") { Label12X.Text = "กรุณากรอกรหัสผ่านใหม่ให้ครบถ้วน"; Label12X.ForeColor = System.Drawing.Color.Red; return; } if (tbPasswordNew.Text != tbPasswordNewAgain.Text) { Label12X.Text = "รหัสผ่านไม่ตรงกัน"; Label12X.ForeColor = System.Drawing.Color.Red; return; } string source = tbPasswordNew.Text; using (MD5 md5Hash = MD5.Create()) { string hash = GetMd5Hash(md5Hash, source); DatabaseManager.ExecuteNonQuery("UPDATE UOC_STAFF SET PASSWORD = '******', ST_LOGIN_ID = 1 WHERE CITIZEN_ID = '" + loginPerson.CITIZEN_ID + "'"); Label12X.Text = "ตั้งรหัสผ่านสำเร็จ"; Label12X.ForeColor = System.Drawing.Color.Green; } } if (loginPerson.IsLoginSecond()) { Label12X.Text = ""; if (tbPasswordNew.Text == "") { Label12X.Text = "กรุณากรอกรหัสผ่านใหม่"; Label12X.ForeColor = System.Drawing.Color.Red; return; } if (tbPasswordNewAgain.Text == "") { Label12X.Text = "กรุณากรอกรหัสผ่านใหม่อีกครั้ง"; Label12X.ForeColor = System.Drawing.Color.Red; return; } if (tbPasswordOld.Text == tbPasswordNew.Text) { Label12X.Text = "รหัสผ่านใหม่ไม่สามารถซ้ำรหัสผ่านเก่า"; Label12X.ForeColor = System.Drawing.Color.Red; return; } if (tbPasswordNew.Text != tbPasswordNewAgain.Text) { Label12X.Text = "รหัสผ่านใหม่กับรหัสผ่านใหม่อีกครั้งไม่ตรงกัน"; Label12X.ForeColor = System.Drawing.Color.Red; return; } using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT PASSWORD FROM UOC_STAFF WHERE CITIZEN_ID ='" + loginPerson.CITIZEN_ID + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { string source = tbPasswordNew.Text; string CheckOld = tbPasswordOld.Text; while (reader.Read()) { using (MD5 md5Hash = MD5.Create()) { string hash = GetMd5Hash(md5Hash, source); string hashOld = GetMd5Hash(md5Hash, CheckOld); if (!reader.IsDBNull(0)) { if (hashOld != reader.GetString(0)) { Label12X.Text = "รหัสผ่านเก่าไม่ถูกต้อง"; Label12X.ForeColor = System.Drawing.Color.Red; return; } DatabaseManager.ExecuteNonQuery("UPDATE UOC_STAFF SET PASSWORD = '******' WHERE CITIZEN_ID = '" + loginPerson.CITIZEN_ID + "'"); Label12X.Text = "เปลี่ยนรหัสผ่านสำเร็จ"; Label12X.ForeColor = System.Drawing.Color.Green; } } } } } } } }
protected void Page_Load(object sender, EventArgs e) { PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF 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.CITIZEN_ID + "'"); 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 Page_Load(object sender, EventArgs e) { SessionTimeOut.Text = Session.Timeout.ToString() + " นาที"; PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; if (!IsPostBack) { lbName.Text = loginPerson.FullName; lbStaffType.Text = loginPerson.STAFFTYPE_NAME; lbPosition.Text = loginPerson.POSITION_NAME; lbPositionRank.Text = loginPerson.ADMIN_POSITION_NAME; lbDepartment.Text = loginPerson.DEPARTMENT_NAME; string name = loginPerson.FullName; profile_name.InnerText = name; if (loginPerson.ST_LOGIN_ID == 0) { menu1.Visible = false; } if (loginPerson.PERSON_ROLE_ID == 99) { MenuPublic.Visible = true; MenuPublic2.Visible = true; MenuRolePerson.Visible = false; MenuRoleInsig.Visible = false; MenuRoleSalary.Visible = false; MenuRoleLeave.Visible = false; MenuRoleAdmin.Visible = true; } else if (loginPerson.PERSON_ROLE_ID == 1) { MenuPublic.Visible = true; MenuPublic2.Visible = true; MenuRolePerson.Visible = false; MenuRoleInsig.Visible = false; MenuRoleSalary.Visible = false; MenuRoleLeave.Visible = false; MenuRoleAdmin.Visible = false; } else if (loginPerson.PERSON_ROLE_ID == 2) { MenuPublic.Visible = true; MenuPublic2.Visible = true; MenuRolePerson.Visible = true; MenuRoleInsig.Visible = false; MenuRoleSalary.Visible = false; MenuRoleLeave.Visible = false; MenuRoleAdmin.Visible = false; } else if (loginPerson.PERSON_ROLE_ID == 3) { MenuPublic.Visible = true; MenuPublic2.Visible = true; MenuRolePerson.Visible = false; MenuRoleInsig.Visible = true; MenuRoleSalary.Visible = false; MenuRoleLeave.Visible = false; MenuRoleAdmin.Visible = false; } else if (loginPerson.PERSON_ROLE_ID == 4) { MenuPublic.Visible = true; MenuPublic2.Visible = true; MenuRolePerson.Visible = false; MenuRoleInsig.Visible = false; MenuRoleSalary.Visible = true; MenuRoleLeave.Visible = false; MenuRoleAdmin.Visible = false; } else if (loginPerson.PERSON_ROLE_ID == 5) { MenuPublic.Visible = true; MenuPublic2.Visible = true; MenuRolePerson.Visible = false; MenuRoleInsig.Visible = false; MenuRoleSalary.Visible = false; MenuRoleLeave.Visible = true; MenuRoleAdmin.Visible = false; } } //Declare int countRequestID = 0; OracleConnection.ClearAllPools(); using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT URL FROM PS_PERSON_IMAGE WHERE CITIZEN_ID = '" + loginPerson.CITIZEN_ID + "' AND PRESENT = 1", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { string fileName; fileName = reader.GetValue(0).ToString(); string personImageFileName = DatabaseManager.GetPersonImageFileName(loginPerson.CITIZEN_ID); if (personImageFileName != "") { profile_pic.Src = "Upload/PersonImage/" + personImageFileName; profile_pic2.Src = "Upload/PersonImage/" + personImageFileName; } else { profile_pic.Src = "Image/Small/person2.png"; } } } } if (loginPerson.PERSON_ROLE_ID == 2) { //Count using (OracleCommand com = new OracleCommand("SELECT COUNT(STATUS_ID) FROM TB_REQUEST WHERE STATUS_ID = 0", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { countRequestID = reader.GetInt32(0); IntCountRequest.Text = "คุณมีรายการที่ต้องอนุมัติ" + reader.GetInt32(0).ToString() + "รายการ"; } } } noti_request_none.Visible = false; noti_request_approve.Visible = false; int count = countRequestID; if (countRequestID == 0) { noti_request_none.Visible = true; } else { noti_request_approve.Visible = true; } if (count > 0) { noti_alert.InnerText = "" + count; noti_alert.Attributes["class"] = "ps-ms-main-hd-noti-alert"; } } else { NotiAllsee.Visible = true; NotiManageRequest.Visible = false; } } }