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 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";
}
}
public void Load(int ID)
{
HasData = false;
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using(OracleCommand com = new OracleCommand("SELECT LEV_DATA.*, (SELECT LEAVE_TYPE_NAME FROM LEV_TYPE WHERE LEV_TYPE.LEAVE_TYPE_ID = LEV_DATA.LEAVE_TYPE_ID) LEAVE_TYPE_NAME, (SELECT LEAVE_STATUS_NAME FROM LEV_STATUS WHERE LEV_STATUS.LEAVE_STATUS_ID = LEV_DATA.LEAVE_STATUS_ID) LEAVE_STATUS_NAME FROM LEV_DATA WHERE LEAVE_ID = " + ID, con)) {
using(OracleDataReader reader = com.ExecuteReader()) {
while(reader.Read()) {
HasData = true;
int i = 1;
LeaveID = ID;
LeaveTypeID = reader.GetInt32(i++);
LeaveStatusID = reader.GetInt32(i++);
if(reader.IsDBNull(i)) {
RequestDate = null;
} else {
RequestDate = reader.GetDateTime(i);
}
++i;
if (reader.IsDBNull(i)) {
CancelDate = null;
} else {
CancelDate = reader.GetDateTime(i);
}
++i;
if (reader.IsDBNull(i)) {
FromDate = null;
} else {
FromDate = reader.GetDateTime(i);
}
++i;
if (reader.IsDBNull(i)) {
ToDate = null;
} else {
ToDate = reader.GetDateTime(i);
}
++i;
TotalDay = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
if (reader.IsDBNull(i)) {
LastFromDate = null;
} else {
LastFromDate = reader.GetDateTime(i);
}
++i;
if (reader.IsDBNull(i)) {
LastToDate = null;
} else {
LastToDate = reader.GetDateTime(i);
}
++i;
LastTotalDay = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
Reason = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
Contact = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
Telephone = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
PS_ID = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
DocterCertificationFileName = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
CountPast = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
CountNow = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
CountTotal = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
WifeFirstName = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
WifeLastName = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
if (reader.IsDBNull(i)) {
GiveBirthDate = null;
} else {
GiveBirthDate = reader.GetDateTime(i);
}
++i;
TempleName = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
TempleLocation = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
if (reader.IsDBNull(i)) {
OrdainDate = null;
} else {
OrdainDate = reader.GetDateTime(i);
}
++i;
Ordained = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
Hujed = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
PS_Department = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
RestSave = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
RestLeft = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
RestTotal = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
BudgetYear = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
if (reader.IsDBNull(i)) {
Allow = null;
} else {
Allow = reader.GetInt32(i);
}
++i;
if (reader.IsDBNull(i)) {
AllowDate = null;
} else {
AllowDate = reader.GetDateTime(i);
}
++i;
if (reader.IsDBNull(i)) {
CancelAllow = null;
} else {
CancelAllow = reader.GetInt32(i);
}
++i;
if (reader.IsDBNull(i)) {
CancelAllowDate = null;
} else {
CancelAllowDate = reader.GetDateTime(i);
}
++i;
BossState = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
BossStateMax = reader.IsDBNull(i) ? -1 : reader.GetInt32(i); ++i;
CancelReason = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
LeaveTypeName = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
LeaveStatusName = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
}
}
}
Person = DatabaseManager.GetPerson(PS_ID);
using (OracleCommand com = new OracleCommand("SELECT LEV_BOSS_DATA.* FROM LEV_BOSS_DATA WHERE LEAVE_ID = " + ID, con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
LeaveBossData leaveBossData = new LeaveBossData();
leaveBossData.LeaveBossID = reader.GetInt32(0);
leaveBossData.LeaveID = reader.GetInt32(1);
leaveBossData.CitizenID = reader.GetString(2);
leaveBossData.Comment = reader.IsDBNull(3) ? null : reader.GetString(3);
if(reader.IsDBNull(4)) {
leaveBossData.Allow = null;
} else {
leaveBossData.Allow = reader.GetInt32(4);
}
leaveBossData.State = reader.GetInt32(5);
if(reader.IsDBNull(6)) {
leaveBossData.AllowDate = null;
} else {
leaveBossData.AllowDate = reader.GetDateTime(6);
}
leaveBossData.CancelComment = reader.IsDBNull(7) ? null : reader.GetString(7);
if (reader.IsDBNull(8)) {
leaveBossData.CancelAllow = null;
} else {
leaveBossData.CancelAllow = reader.GetInt32(8);
}
if (reader.IsDBNull(9)) {
leaveBossData.CancelAllowDate = null;
} else {
leaveBossData.CancelAllowDate = reader.GetDateTime(9);
}
leaveBossData.Person = DatabaseManager.GetPerson(leaveBossData.CitizenID);
LeaveBossDataList.Add(leaveBossData);
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
loginPerson = ps.LoginPerson;
lbReqBusinessDay.Text = businessBeforeDay.ToString();
lbReqRestDay.Text = restBeforeDay.ToString();
lbReqGiveBirthDay.Text = giveBirthAfterDay.ToString();
lbReqHelpGiveBirthDay.Text = helpGiveBirthAfterDay.ToString();
lbReqOrdainDay.Text = ordainBeforeDay.ToString();
lbReqHujDay.Text = hujBeforeDay.ToString();
DateTime dt = DateTime.Today;
lbReqBusinessDate.Text = dt.AddDays(businessBeforeDay).ToLongDateString();
lbReqRestDate.Text = dt.AddDays(restBeforeDay).ToLongDateString();
lbReqGiveBirthDate.Text = dt.AddDays(-giveBirthAfterDay).ToLongDateString();
lbReqHelpGiveBirthDate.Text = dt.AddDays(-helpGiveBirthAfterDay).ToLongDateString();
lbReqOrdainDate.Text = dt.AddDays(ordainBeforeDay).ToLongDateString();
lbReqHujDate.Text = dt.AddDays(hujBeforeDay).ToLongDateString();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
OracleConnection.ClearAllPools();
con.Open();
using (OracleCommand com = new OracleCommand("SELECT SICK_MAX - SICK_NOW, BUSINESS_MAX - BUSINESS_NOW, REST_MAX - REST_NOW, ORDAIN_MAX - ORDAIN_NOW, HUJ_MAX - HUJ_NOW FROM LEV_CLAIM WHERE PS_CITIZEN_ID = '" + loginPerson.CitizenID + "' AND YEAR = " + Util.BudgetYear(), con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while(reader.Read()) {
lbSickLeftDay.Text = reader.GetInt32(0).ToString();
lbBusinessLeftDay.Text = reader.GetInt32(1).ToString();
lbRestLeftDay.Text = reader.GetInt32(2).ToString();
lbOrdainLeftDay.Text = reader.GetInt32(3).ToString();
lbHujLeftDay.Text = reader.GetInt32(4).ToString();
}
}
}
using (OracleCommand com = new OracleCommand("SELECT TO_DATE FROM LEV_DATA WHERE PS_ID = '" + loginPerson.CitizenID + "' AND LEAVE_TYPE_ID = 1 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()) {
divSickFrom.Visible = true;
DateTime dtLastToDate = reader.GetDateTime(0);
dtLastToDate = dtLastToDate.AddDays(1);
lbSickFrom.Text = dtLastToDate.ToLongDateString();
} else {
divSickFrom.Visible = false;
}
}
}
}
if(!IsPostBack) {
if (loginPerson.IsMale()) {
trReqGiveBirth.Visible = false;
trReqHelpGiveBirth.Visible = true;
trReqOrdain.Visible = true;
trReqHuj.Visible = true;
lbuSelectGiveBirth.Visible = false;
lbuSelectHelpGiveBirth.Visible = true;
lbuSelectOrdain.Visible = true;
lbuSelectHuj.Visible = true;
} else {
trReqGiveBirth.Visible = true;
trReqHelpGiveBirth.Visible = false;
trReqOrdain.Visible = false;
trReqHuj.Visible = false;
lbuSelectGiveBirth.Visible = true;
lbuSelectHelpGiveBirth.Visible = false;
lbuSelectOrdain.Visible = false;
lbuSelectHuj.Visible = false;
}
}
}
public static Person GetPerson(string citizenID)
{
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand(
"SELECT PS_PERSON.PS_CITIZEN_ID, PS_PERSON.PS_TITLE_ID, (SELECT TITLE_NAME_TH FROM TB_TITLENAME WHERE TB_TITLENAME.TITLE_ID = PS_PERSON.PS_TITLE_ID) TITLE_NAME_TH, PS_PERSON.PS_FN_TH, PS_PERSON.PS_LN_TH, PS_GENDER_ID, (SELECT GENDER_NAME FROM TB_GENDER WHERE TB_GENDER.GENDER_ID = PS_PERSON.PS_GENDER_ID) GENDER_NAME, PS_BIRTHDAY_DATE, PS_BIRTHDAY_LONG, PS_RETIRE_DATE, PS_RETIRE_LONG, PS_INWORK_DATE, PS_PERSON.PS_STAFFTYPE_ID, (SELECT STAFFTYPE_NAME FROM TB_STAFFTYPE WHERE TB_STAFFTYPE.STAFFTYPE_ID = PS_PERSON.PS_STAFFTYPE_ID) STAFFTYPE_NAME, PS_DAD_FN, PS_DAD_LN, PS_MOM_FN, PS_MOM_LN, PS_MOM_LN_OLD, PS_LOV_FN, PS_LOV_LN, PS_LOV_LN_OLD, PS_PERSON.PS_MINISTRY_ID, (SELECT MINISTRY_NAME FROM TB_MINISTRY WHERE TB_MINISTRY.MINISTRY_ID = PS_PERSON.PS_MINISTRY_ID) MINISTRY_NAME, PS_DIVISION_ID, (SELECT DIVISION_NAME FROM TB_DIVISION WHERE TB_DIVISION.DIVISION_ID = PS_PERSON.PS_DIVISION_ID) DIVISION_NAME, PS_PASSWORD, PS_RACE_ID, (SELECT NATION_THA FROM TB_NATIONAL WHERE TB_NATIONAL.NATION_SEQ = PS_PERSON.PS_RACE_ID) RACE_THA, PS_NATION_ID, (SELECT NATION_THA FROM TB_NATIONAL WHERE TB_NATIONAL.NATION_SEQ = PS_PERSON.PS_NATION_ID) NATION_THA, PS_HOMEADD, PS_SOI, PS_MOO, PS_STREET, PS_DISTRICT, (SELECT DISTRICT_TH FROM TB_DISTRICT WHERE TB_DISTRICT.DISTRICT_ID = PS_PERSON.PS_DISTRICT) DISTRICT_TH, PS_AMPHUR_ID, (SELECT AMPHUR_TH FROM TB_AMPHUR WHERE TB_AMPHUR.AMPHUR_ID = PS_PERSON.PS_AMPHUR_ID) AMPHUR_TH, PS_PROVINCE_ID, (SELECT PROVINCE_TH FROM TB_PROVINCE WHERE TB_PROVINCE.PROVINCE_ID = PS_PERSON.PS_PROVINCE_ID) PROVINCE_TH, PS_ZIPCODE, PS_COUNTRY_ID, (SELECT COUNTRY_TH FROM TB_COUNTRY WHERE TB_COUNTRY.COUNTRY_ID = PS_PERSON.PS_COUNTRY_ID) PS_COUNTRY_NAME, PS_STATE, PS_HOMEADD_NOW, PS_SOI_NOW, PS_MOO_NOW, PS_STREET_NOW, PS_DISTRICT_ID_NOW, (SELECT DISTRICT_TH FROM TB_DISTRICT WHERE TB_DISTRICT.DISTRICT_ID = PS_PERSON.PS_DISTRICT_ID_NOW) DISTRICT_TH, PS_AMPHUR_ID_NOW, (SELECT AMPHUR_TH FROM TB_AMPHUR WHERE TB_AMPHUR.AMPHUR_ID = PS_PERSON.PS_AMPHUR_ID_NOW) AMPHUR_TH, PS_PROVINCE_ID_NOW, (SELECT PROVINCE_TH FROM TB_PROVINCE WHERE TB_PROVINCE.PROVINCE_ID = PS_PERSON.PS_PROVINCE_ID_NOW) PROVINCE_TH, PS_ZIPCODE_NOW, PS_COUNTRY_ID_NOW, (SELECT COUNTRY_TH FROM TB_COUNTRY WHERE TB_COUNTRY.COUNTRY_ID = PS_PERSON.PS_COUNTRY_ID_NOW) PS_COUNTRY_NAME_NOW, PS_STATE_NOW, PS_PHONE, PS_BUDGET_ID, (SELECT BUDGET_NAME FROM TB_BUDGET WHERE TB_BUDGET.BUDGET_ID = PS_PERSON.PS_BUDGET_ID) BUDGET_NAME, PS_ADMIN_POS_ID, (SELECT ADMIN_POSITION_NAME FROM TB_ADMIN_POSITION WHERE TB_ADMIN_POSITION.ADMIN_POSITION_ID = PS_PERSON.PS_ADMIN_POS_ID) ADMIN_POSITION_NAME, (SELECT ADMIN_POSITION_POWER FROM TB_ADMIN_POSITION WHERE TB_ADMIN_POSITION.ADMIN_POSITION_ID = PS_PERSON.PS_ADMIN_POS_ID) ADMIN_POSITION_POWER, PS_SPECIAL_WORK, PS_TEACH_ISCED_ID, PS_FACULTY_ID, (SELECT FACULTY_NAME FROM TB_FACULTY WHERE TB_FACULTY.FACULTY_ID = PS_PERSON.PS_FACULTY_ID) FACULTY_NAME, PS_CAMPUS_ID, (SELECT CAMPUS_NAME FROM TB_CAMPUS WHERE TB_CAMPUS.CAMPUS_ID = PS_PERSON.PS_CAMPUS_ID) CAMPUS_NAME, PS_SW_ID, PS_RELIGION_ID, (SELECT RELIGION_NAME FROM TB_RELIGION WHERE TB_RELIGION.RELIGION_ID = PS_PERSON.PS_RELIGION_ID) RELIGION_NAME, (SELECT PS_POSITION_AND_SALARY.PS_POSITION_NO FROM PS_POSITION_AND_SALARY WHERE PS_PERSON.PS_CITIZEN_ID = PS_POSITION_AND_SALARY.PS_CITIZEN_ID AND PRESENT = 1) POSITION_NO, (SELECT TB_POSITION.NAME FROM TB_POSITION WHERE PS_PERSON.PS_POSITION_ID = TB_POSITION.ID) POSITION_NAME, PS_SALARY, PS_STATUS_ID, (SELECT STATUS_NAME FROM TB_STATUS_PERSON WHERE PS_PERSON.PS_STATUS_ID = TB_STATUS_PERSON.STATUS_ID) STATUS_PERSON_NAME, PS_BLOOD_ID, (SELECT BLOOD_NAME FROM TB_BLOOD WHERE PS_PERSON.PS_BLOOD_ID = TB_BLOOD.BLOOD_ID) BLOOD_NAME, PS_TELEPHONE_WORK, PS_EMAIL, PS_GROM, (SELECT SW_NAME FROM TB_STATUS_WORK WHERE PS_PERSON.PS_SW_ID = TB_STATUS_WORK.SW_ID) STATUS_NAME, PS_WORK_DIVISION_ID, (SELECT WORK_NAME FROM TB_WORK_DIVISION WHERE PS_PERSON.PS_WORK_DIVISION_ID = TB_WORK_DIVISION.WORK_ID) WORK_NAME, PS_WORK_POS_ID, (SELECT POSITION_WORK_NAME FROM TB_POSITION_WORK WHERE TB_POSITION_WORK.POSITION_WORK_ID = PS_PERSON.PS_WORK_POS_ID) POSITION_WORK_NAME, PS_RANK_ID, (SELECT RANK_NAME_TH FROM TB_RANK WHERE TB_RANK.RANK_ID = PS_PERSON.PS_RANK_ID) RANK_NAME, PS_START_POSI_ID, (SELECT POSITION_WORK_NAME FROM TB_POSITION_WORK WHERE TB_POSITION_WORK.POSITION_WORK_ID = PS_PERSON.PS_START_POSI_ID) START_POSITION_WORK_NAME, PS_START_ADMIN_POSI_ID, (SELECT ADMIN_POSITION_NAME FROM TB_ADMIN_POSITION WHERE TB_ADMIN_POSITION.ADMIN_POSITION_ID = PS_PERSON.PS_START_ADMIN_POSI_ID) START_ADMIN_POSITION_NAME, PS_POSS_SALARY, PS_DATE_QUIT, PS_PERMISSION FROM PS_PERSON WHERE PS_CITIZEN_ID = '" + citizenID + "'"
, con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
Person person = new Person();
int i = 0;
person.CitizenID = reader.GetValue(i++).ToString();
person.TitleID = reader.GetValue(i++).ToString();
person.TitleName = reader.GetValue(i++).ToString();
person.FirstName = reader.GetValue(i++).ToString();
person.LastName = reader.GetValue(i++).ToString();
person.GenderID = reader.GetValue(i++).ToString();
person.GenderName = reader.GetValue(i++).ToString();
person.BirthDate = reader.GetDateTime(i++);
person.BirthDateLong = reader.GetValue(i++).ToString();
if(reader.IsDBNull(i)) {
person.RetireDate = null;
} else {
person.RetireDate = reader.GetDateTime(i);
}
++i;
person.RetireDateLong = reader.GetValue(i++).ToString();
if (reader.IsDBNull(i))
{
person.InWorkDate = null;
}
else
{
person.InWorkDate = reader.GetDateTime(i);
}
++i;
person.StaffTypeID = reader.GetValue(i++).ToString();
person.StaffTypeName = reader.GetValue(i++).ToString();
person.FatherFirstName = reader.GetValue(i++).ToString();
person.FatherLastName = reader.GetValue(i++).ToString();
person.MotherFirstName = reader.GetValue(i++).ToString();
person.MotherLastName = reader.GetValue(i++).ToString();
person.MotherOldLastName = reader.GetValue(i++).ToString();
person.CoupleFirstName = reader.GetValue(i++).ToString();
person.CoupleLastName = reader.GetValue(i++).ToString();
person.CoupleOldLastName = reader.GetValue(i++).ToString();
person.MinistryID = reader.GetValue(i++).ToString();
person.MinistryName = reader.GetValue(i++).ToString();
if (reader.IsDBNull(i)) {
person.DivisionID = null;
} else {
person.DivisionID = reader.GetValue(i).ToString();
}
++i;
if (reader.IsDBNull(i)) {
person.DivisionName = null;
} else {
person.DivisionName = reader.GetValue(i).ToString();
}
++i;
person.Password = reader.GetValue(i++).ToString();
person.RaceID = reader.GetValue(i++).ToString();
person.RaceName = reader.GetValue(i++).ToString();
person.NationID = reader.GetValue(i++).ToString();
person.NationName = reader.GetValue(i++).ToString();
person.HomeAdd = reader.GetValue(i++).ToString();
person.Soi = reader.GetValue(i++).ToString();
person.Moo = reader.GetValue(i++).ToString();
person.Street = reader.GetValue(i++).ToString();
person.DistrictID = reader.GetValue(i++).ToString();
person.DistrictName = reader.GetValue(i++).ToString();
person.AmphurID = reader.GetValue(i++).ToString();
person.AmphurName = reader.GetValue(i++).ToString();
person.ProvinceID = reader.GetValue(i++).ToString();
person.ProvinceName = reader.GetValue(i++).ToString();
person.ZipCode = reader.GetValue(i++).ToString();
person.PlaceCountryID = reader.GetValue(i++).ToString();
person.PlaceCountryName = reader.GetValue(i++).ToString();
person.PlaceState = reader.GetValue(i++).ToString();
person.HomeAddNow = reader.GetValue(i++).ToString();
person.SoiNow = reader.GetValue(i++).ToString();
person.MooNow = reader.GetValue(i++).ToString();
person.StreetNow = reader.GetValue(i++).ToString();
person.DistrictIDNow = reader.GetValue(i++).ToString();
person.DistrictNameNow = reader.GetValue(i++).ToString();
person.AmphurIDNow = reader.GetValue(i++).ToString();
person.AmphurNameNow = reader.GetValue(i++).ToString();
person.ProvinceIDNow = reader.GetValue(i++).ToString();
person.ProvinceNameNow = reader.GetValue(i++).ToString();
person.ZipCodeNow = reader.GetValue(i++).ToString();
person.PlaceCountryID = reader.GetValue(i++).ToString();
person.PlaceCountryNowName = reader.GetValue(i++).ToString();
person.PlaceStateNow = reader.GetValue(i++).ToString();
person.Telephone = reader.GetValue(i++).ToString();
person.BudgetID = reader.GetValue(i++).ToString();
person.BudgetName = reader.GetValue(i++).ToString();
person.AdminPositionID = reader.GetValue(i++).ToString();
person.AdminPositionName = reader.GetValue(i++).ToString();
person.AdminPositionPower = reader.GetValue(i++).ToString();
person.SpecialName = reader.GetValue(i++).ToString();
person.TeachISCEDID = reader.GetValue(i++).ToString();
person.FacultyID = reader.GetValue(i++).ToString();
person.FacultyName = reader.GetValue(i++).ToString();
person.CampusID = reader.GetValue(i++).ToString();
person.CampusName = reader.GetValue(i++).ToString();
person.StatusID = reader.GetValue(i++).ToString();
person.ReligionID = reader.GetValue(i++).ToString();
person.ReligionName = reader.GetValue(i++).ToString();
person.PositionID = reader.GetValue(i++).ToString();
person.PositionName = reader.GetValue(i++).ToString();
if (reader.IsDBNull(i))
{
person.Salary = 0;
}
else {
person.Salary = reader.GetInt32(i);
}
++i;
//person.Salary = reader.GetInt32(i++);
person.StatusPersonID = reader.GetValue(i++).ToString();
person.StatusPersonName = reader.GetValue(i++).ToString();
person.BloodID = reader.GetValue(i++).ToString();
person.BloodName = reader.GetValue(i++).ToString();
person.WorkTelephone = reader.GetValue(i++).ToString();
person.Email = reader.GetValue(i++).ToString();
person.Grom = reader.GetValue(i++).ToString();
person.StatusName = reader.GetValue(i++).ToString();
if (reader.IsDBNull(i)) {
person.WorkDivisionID = null;
} else {
person.WorkDivisionID = reader.GetValue(i).ToString();
}
++i;
if (reader.IsDBNull(i)) {
person.WorkDivisionName = null;
} else {
person.WorkDivisionName = reader.GetValue(i).ToString();
}
++i;
person.PositionWorkID = reader.GetValue(i++).ToString();
person.PositionWorkName = reader.GetValue(i++).ToString();
person.RankID = reader.GetValue(i++).ToString();
person.RankName = reader.GetValue(i++).ToString();
person.StartPositionWorkID = reader.GetValue(i++).ToString();
person.StartPositionWorkName = reader.GetValue(i++).ToString();
person.StartAdminPositionID = reader.GetValue(i++).ToString();
person.StartAdminPositionName = reader.GetValue(i++).ToString();
person.PositionSalary = reader.GetValue(i++).ToString();
if (reader.IsDBNull(i))
{
person.DateQuit = null;
}
else
{
person.DateQuit = reader.GetDateTime(i);
}
++i;
person.Permission = reader.GetInt32(i++);
return person;
}
}
}
}
return null;
}
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);
}*/
}