void BindData1() { PS_STUDY PStudy = new PS_STUDY(); DataTable dt1 = PStudy.SELECT_PS_STUDY(labelCitizenID.Text, "", "", "", "", "", "", "", "", ""); GridViewStudy.DataSource = dt1; GridViewStudy.DataBind(); SetViewState(dt1); PS_PROFESSIONAL_LICENSE PLicense = new PS_PROFESSIONAL_LICENSE(); DataTable dt2 = PLicense.SELECT_PS_PROFESSIONAL_LICENSE(labelCitizenID.Text, "", "", "", ""); GridViewLicense.DataSource = dt2; GridViewLicense.DataBind(); SetViewState(dt2); PS_TRAINING PTraining = new PS_TRAINING(); DataTable dt3 = PTraining.SELECT_PS_TRAINING(labelCitizenID.Text, "", "", "", "", "", ""); GridViewTraining.DataSource = dt3; GridViewTraining.DataBind(); SetViewState(dt3); PS_DISCIPLINARY_AND_AMNESTY PDAA = new PS_DISCIPLINARY_AND_AMNESTY(); DataTable dt4 = PDAA.SELECT_PS_DISCIPLINARY_AND_AMNESTY(labelCitizenID.Text, "", "", ""); GridViewDAA.DataSource = dt4; GridViewDAA.DataBind(); SetViewState(dt4); PS_POSITION_AND_SALARY PPAS = new PS_POSITION_AND_SALARY(); DataTable dt5 = PPAS.SELECT_PS_POSITION_AND_SALARY(labelCitizenID.Text, "", "", "", "", "", "", "", ""); GridViewPAS.DataSource = dt5; GridViewPAS.DataBind(); SetViewState(dt5); TB_PDH_GOVER PDHgover = new TB_PDH_GOVER(); DataTable dt6 = PDHgover.SELECT_POSI_GOVER_ONLY(labelCitizenID.Text, "", ""); GridviewPDHgover.DataSource = dt6; GridviewPDHgover.DataBind(); SetViewState(dt6); TB_PDH_EMP PDHemp = new TB_PDH_EMP(); DataTable dt7 = PDHemp.SELECT_POSI_EMP_ONLY(labelCitizenID.Text, "", ""); GridviewPDHemp.DataSource = dt7; GridviewPDHemp.DataBind(); SetViewState(dt7); }
void BindData() { //GridViewStudy PS_STUDY PStudy = new PS_STUDY(); DataTable dt1 = PStudy.SELECT_PS_STUDY(p, "", "", "", "", "", "", "", "", ""); GridViewStudy.DataSource = dt1; GridViewStudy.DataBind(); SetViewState(dt1); //GridViewLicense PS_PROFESSIONAL_LICENSE PLicense = new PS_PROFESSIONAL_LICENSE(); DataTable dt2 = PLicense.SELECT_PS_PROFESSIONAL_LICENSE(p, "", "", "", ""); GridViewLicense.DataSource = dt2; GridViewLicense.DataBind(); SetViewState(dt2); //GridViewTraining PS_TRAINING PTraining = new PS_TRAINING(); DataTable dt3 = PTraining.SELECT_PS_TRAINING(p, "", "", "", "", "", ""); GridViewTraining.DataSource = dt3; GridViewTraining.DataBind(); SetViewState(dt3); //GridViewDisciplinary PS_DISCIPLINARY_AND_AMNESTY PDAA = new PS_DISCIPLINARY_AND_AMNESTY(); DataTable dt4 = PDAA.SELECT_PS_DISCIPLINARY_AND_AMNESTY(p, "", "", ""); GridViewDAA.DataSource = dt4; GridViewDAA.DataBind(); SetViewState(dt4); //GridViewPositionAndSalary PS_POSITION_AND_SALARY PPAS = new PS_POSITION_AND_SALARY(); DataTable dt5 = PPAS.SELECT_PS_POSITION_AND_SALARY(p, "", "", "", "", "", "", "", ""); GridViewPAS.DataSource = dt5; GridViewPAS.DataBind(); SetViewState(dt5); //GridViewPositionDegreeHistoryGover TB_PDH_GOVER PDHgover = new TB_PDH_GOVER(); DataTable dt6 = PDHgover.SELECT_POSI_GOVER_ONLY(p, "", ""); GridviewPDHgover.DataSource = dt6; GridviewPDHgover.DataBind(); SetViewState(dt6); //GridViewPositionDegreeHistoryEMP TB_PDH_EMP PDHemp = new TB_PDH_EMP(); DataTable dt7 = PDHemp.SELECT_POSI_EMP_ONLY(p, "", ""); GridviewPDHemp.DataSource = dt7; GridviewPDHemp.DataBind(); SetViewState(dt7); }
protected void modDeleteCommandEmp(Object sender, GridViewDeleteEventArgs e) { int id = Convert.ToInt32(GridviewPDHemp.DataKeys[e.RowIndex].Value); TB_PDH_EMP PDHemp = new TB_PDH_EMP(); PDHemp.PDH_ID = id; PDHemp.DELETE_PS_PROFESSIONAL_LICENSE(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('ลบข้อมูลเรียบร้อย')", true); if (string.IsNullOrEmpty(labelCitizenID.Text)) { GridviewPDHemp.EditIndex = -1; BindData(); } else { GridviewPDHemp.EditIndex = -1; BindData1(); } }
protected void modUpdateCommandEmp(Object sender, GridViewUpdateEventArgs e) { Label lblPDHidEmp = (Label)GridviewPDHemp.Rows[e.RowIndex].FindControl("lblPDHidEmp"); Label lblPDHcitizenIDEmp = (Label)GridviewPDHemp.Rows[e.RowIndex].FindControl("lblPDHcitizenIDEmp"); TextBox txtPDHdateEmp = (TextBox)GridviewPDHemp.Rows[e.RowIndex].FindControl("txtPDHdateEmp"); DropDownList ddlPDHpositionGetEmp = (DropDownList)GridviewPDHemp.Rows[e.RowIndex].FindControl("ddlPDHpositionGetEmp"); TB_PDH_EMP PDHemp = new TB_PDH_EMP(Convert.ToInt32(lblPDHidEmp.Text) , lblPDHcitizenIDEmp.Text , Util.ODT(txtPDHdateEmp.Text) , Convert.ToInt32(ddlPDHpositionGetEmp.SelectedValue)); PDHemp.UPDATE_POSI_EMP_ONLY(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('อัพเดทข้อมูลเรียบร้อย')", true); if (string.IsNullOrEmpty(labelCitizenID.Text)) { GridviewPDHemp.EditIndex = -1; BindData(); } else { GridviewPDHemp.EditIndex = -1; BindData1(); } }
protected void lbuTab4Save_Click(object sender, EventArgs e) { using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); int staffTypeID = -1; using (OracleCommand com = new OracleCommand("SELECT PS_STAFFTYPE_ID FROM PS_PERSON WHERE PS_CITIZEN_ID = '" + p + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { staffTypeID = reader.GetInt32(0); } } } idPositionShowAll.Visible = false; idPositionShowGover.Visible = false; idPositionShowOfficeEmp.Visible = false; GridviewPDHgover.Visible = false; GridviewPDHemp.Visible = false; if (staffTypeID == 1) { idPositionShowAll.Visible = true; idPositionShowGover.Visible = true; GridviewPDHgover.Visible = true; } else if (staffTypeID == 2) { idPositionShowAll.Visible = true; } else if (staffTypeID == 3) { idPositionShowAll.Visible = true; } else if (staffTypeID == 4) { idPositionShowAll.Visible = true; } else if (staffTypeID == 5) { idPositionShowAll.Visible = true; } else if (staffTypeID == 6) { idPositionShowAll.Visible = true; idPositionShowOfficeEmp.Visible = true; GridviewPDHemp.Visible = true; } { if (ddlTab4PositionWorkRow1.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกตำแหน่งในสายงาน</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlTab4AdminPositionRow1.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกตำแหน่งทางบริหาร</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlTab4AcadPositionRow1.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกตำแหน่งทางวิชาการ</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } //บันทึก 3 ตัว PS_PERSON P0 = new PS_PERSON(); P0.PS_WORK_POS_ID = Convert.ToInt32(ddlTab4PositionWorkRow1.SelectedValue); P0.PS_ADMIN_POS_ID = Convert.ToInt32(ddlTab4AdminPositionRow1.SelectedValue); P0.PS_ACAD_POS_ID = Convert.ToInt32(ddlTab4AcadPositionRow1.SelectedValue); P0.PS_CITIZEN_ID = p; P0.UPDATE_PS_PERSON_TAB4_EVERYONE(); if (chkBoxWorkPosition.Checked) { PS_PERSON P2 = new PS_PERSON(); P2.PS_START_POSI_ID = Convert.ToInt32(ddlTab4PositionWorkRow1.SelectedValue); P2.PS_CITIZEN_ID = p; P2.UPDATE_PS_PERSON_START_WORK_POSITION_FIRST_TIME(); } if (chkBoxAdminPosition.Checked) { PS_PERSON P3 = new PS_PERSON(); P3.PS_START_ADMIN_POSI_ID = Convert.ToInt32(ddlTab4AdminPositionRow1.SelectedValue); P3.PS_CITIZEN_ID = p; P3.UPDATE_PS_PERSON_START_ADMIN_POSITION_FIRST_TIME(); } notification.Attributes["class"] = "alert alert_success"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/correct.png' /><strong>บันทึกข้อมูลตำแหน่งสำเร็จ</strong></div>"; } if (staffTypeID == 1) { if (ddlTab4PositionWorkRow1.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกตำแหน่งในสายงาน</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlTab4AdminPositionRow1.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกตำแหน่งทางบริหาร</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlTab4AcadPositionRow1.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกตำแหน่งทางวิชาการ</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } //ถ้าเลือกดรอป ต้องกรอกวันที่ if (ddlShowMenuGoverTab4.SelectedIndex == 1) { if (tbDateGetPositionGoverTab4.Text == "" || ddlTab4AdminPositionDegreeRow2.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณากรอกวันที่ได้รับตำแหน่งและเลือกตำแหน่งประเภทบริหาร</div>"; return; } } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlShowMenuGoverTab4.SelectedIndex == 2) { if (tbDateGetPositionGoverTab4.Text == "" || ddlTab4DirectPositionDegreeRow2.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณากรอกวันที่ได้รับตำแหน่งและเลือกตำแหน่งประเภทอำนวยการ</div>"; return; } } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlShowMenuGoverTab4.SelectedIndex == 3) { if (tbDateGetPositionGoverTab4.Text == "" || ddlTab4AcadPositionDegreeRow2.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณากรอกวันที่ได้รับตำแหน่งและเลือกตำแหน่งประเภทวิชาการ</div>"; return; } } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlShowMenuGoverTab4.SelectedIndex == 4) { if (tbDateGetPositionGoverTab4.Text == "" || ddlTab4GeneralPositionDegreeRow2.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณากรอกวันที่ได้รับตำแหน่งและเลือกตำแหน่งประเภททั่วไป</div>"; return; } } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } //เลือกได้แค่ 1 อัน //*** ddlShowMenuGoverTab4.SelectedIndex = 0; //มีอยู่แล้วในระบบ ห้ามเลือกซ้ำ //DropMiddle1 - ตำแหน่งประเภทบริหาร string result1 = ""; using (OracleCommand com = new OracleCommand("SELECT PDH_POSITION_GET FROM TB_PDH_GOVER WHERE PDH_POSITION_GET = '" + ddlTab4AdminPositionDegreeRow2.SelectedValue + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { result1 = reader.GetInt32(0).ToString(); } } } if (result1 == ddlTab4AdminPositionDegreeRow2.SelectedValue) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>"; notification.InnerHtml += "<div> - มีข้อมูลตำแหน่งข้าราชการที่คุณเลือกนี้อยู่แล้วในระบบ</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } //DropMiddle2 - ตำแหน่งประเภทอำนวยการ string result2 = ""; using (OracleCommand com = new OracleCommand("SELECT PDH_POSITION_GET FROM TB_PDH_GOVER WHERE PDH_POSITION_GET = '" + ddlTab4DirectPositionDegreeRow2.SelectedValue + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { result2 = reader.GetInt32(0).ToString(); } } } if (result2 == ddlTab4DirectPositionDegreeRow2.SelectedValue) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>"; notification.InnerHtml += "<div> - มีข้อมูลตำแหน่งข้าราชการที่คุณเลือกนี้อยู่แล้วในระบบ</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } //DropMiddle3 - ตำแหน่งประเภทวิชาการ string result3 = ""; using (OracleCommand com = new OracleCommand("SELECT PDH_POSITION_GET FROM TB_PDH_GOVER WHERE PDH_POSITION_GET = '" + ddlTab4AcadPositionDegreeRow2.SelectedValue + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { result3 = reader.GetInt32(0).ToString(); } } } if (result3 == ddlTab4AcadPositionDegreeRow2.SelectedValue) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>"; notification.InnerHtml += "<div> - มีข้อมูลตำแหน่งข้าราชการที่คุณเลือกนี้อยู่แล้วในระบบ</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } //DropMiddle4 - ตำแหน่งประเภททั่วไป string result4 = ""; using (OracleCommand com = new OracleCommand("SELECT PDH_POSITION_GET FROM TB_PDH_GOVER WHERE PDH_POSITION_GET = '" + ddlTab4GeneralPositionDegreeRow2.SelectedValue + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { result4 = reader.GetInt32(0).ToString(); } } } if (result4 == ddlTab4GeneralPositionDegreeRow2.SelectedValue) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>"; notification.InnerHtml += "<div> - มีข้อมูลตำแหน่งข้าราชการที่คุณเลือกนี้อยู่แล้วในระบบ</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlTab4AdminPositionDegreeRow2.SelectedIndex == 0 && ddlTab4DirectPositionDegreeRow2.SelectedIndex == 0 && ddlTab4AcadPositionDegreeRow2.SelectedIndex == 0 && ddlTab4GeneralPositionDegreeRow2.SelectedIndex == 0) { //กลาง PS_PERSON P0 = new PS_PERSON(); TB_PDH_GOVER P1 = new TB_PDH_GOVER(); P0.PS_WORK_POS_ID = Convert.ToInt32(ddlTab4PositionWorkRow1.SelectedValue); P0.PS_ADMIN_POS_ID = Convert.ToInt32(ddlTab4AdminPositionRow1.SelectedValue); P0.PS_ACAD_POS_ID = Convert.ToInt32(ddlTab4AcadPositionRow1.SelectedValue); P0.PS_POSI_ADMIN = Convert.ToInt32(ddlTab4AdminPositionDegreeRow2.SelectedValue); P0.PS_POSI_DIRECT = Convert.ToInt32(ddlTab4DirectPositionDegreeRow2.SelectedValue); P0.PS_POSI_ACAD = Convert.ToInt32(ddlTab4AcadPositionDegreeRow2.SelectedValue); P0.PS_POSI_GENERAL = Convert.ToInt32(ddlTab4GeneralPositionDegreeRow2.SelectedValue); P0.PS_CITIZEN_ID = p; P0.UPDATE_PS_PERSON_TAB4_EVERYONE_GOVER(); DataTable dt = P1.SELECT_POSI_GOVER_ONLY(p, "", ""); GridviewPDHgover.DataSource = dt; GridviewPDHgover.DataBind(); SetViewState(dt); notification.Attributes["class"] = "alert alert_success"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/correct.png' /><strong>บันทึกข้อมูลตำแหน่งสำเร็จ</strong></div>"; } else { //กลาง //////////////////////////// PS_PERSON P0 = new PS_PERSON(); P0.PS_WORK_POS_ID = Convert.ToInt32(ddlTab4PositionWorkRow1.SelectedValue); P0.PS_ADMIN_POS_ID = Convert.ToInt32(ddlTab4AdminPositionRow1.SelectedValue); P0.PS_ACAD_POS_ID = Convert.ToInt32(ddlTab4AcadPositionRow1.SelectedValue); P0.PS_POSI_ADMIN = Convert.ToInt32(ddlTab4AdminPositionDegreeRow2.SelectedValue); P0.PS_POSI_DIRECT = Convert.ToInt32(ddlTab4DirectPositionDegreeRow2.SelectedValue); P0.PS_POSI_ACAD = Convert.ToInt32(ddlTab4AcadPositionDegreeRow2.SelectedValue); P0.PS_POSI_GENERAL = Convert.ToInt32(ddlTab4GeneralPositionDegreeRow2.SelectedValue); P0.PS_CITIZEN_ID = p; P0.UPDATE_PS_PERSON_TAB4_EVERYONE_GOVER(); TB_PDH_GOVER P1 = new TB_PDH_GOVER(); P1.PDH_CITIZEN_ID = p; P1.PDH_DATE_START = Util.ODT(tbDateGetPositionGoverTab4.Text); if(ddlTab4AdminPositionDegreeRow2.SelectedIndex != 0) { P1.PDH_POSITION_GET = Convert.ToInt32(ddlTab4AdminPositionDegreeRow2.SelectedValue); } if (ddlTab4DirectPositionDegreeRow2.SelectedIndex != 0) { P1.PDH_POSITION_GET = Convert.ToInt32(ddlTab4DirectPositionDegreeRow2.SelectedValue); } if (ddlTab4AcadPositionDegreeRow2.SelectedIndex != 0) { P1.PDH_POSITION_GET = Convert.ToInt32(ddlTab4AcadPositionDegreeRow2.SelectedValue); } if (ddlTab4GeneralPositionDegreeRow2.SelectedIndex != 0) { P1.PDH_POSITION_GET = Convert.ToInt32(ddlTab4GeneralPositionDegreeRow2.SelectedValue); } P1.INSERT_POSI_GOVER_ONLY(); ClearMiddleTab4(); DataTable dt = P1.SELECT_POSI_GOVER_ONLY(p, "", ""); GridviewPDHgover.DataSource = dt; GridviewPDHgover.DataBind(); SetViewState(dt); notification.Attributes["class"] = "alert alert_success"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/correct.png' /><strong>บันทึกข้อมูลตำแหน่งสำเร็จ</strong></div>"; } } else if (staffTypeID == 6) { if (ddlTab4PositionWorkRow1.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกตำแหน่งในสายงาน</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlTab4AdminPositionRow1.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกตำแหน่งทางบริหาร</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlTab4AcadPositionRow1.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกตำแหน่งทางวิชาการ</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } //ถ้าเลือกดรอป ต้องกรอกวันที่ if (ddlTab4EmpPositionRow3.SelectedIndex != 0) { if (tbDateGetPositionEMPTab4.Text == "") { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณากรอกวันที่ได้รับตำแหน่ง</div>"; return; } } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } //DropRight1 - ตำแหน่งพนักงานราชการ string result5 = ""; using (OracleCommand com = new OracleCommand("SELECT PDH_POSITION_GET FROM TB_PDH_EMP WHERE PDH_POSITION_GET = '" + ddlTab4EmpPositionRow3.SelectedValue + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { result5 = reader.GetInt32(0).ToString(); } } } if (result5 == ddlTab4EmpPositionRow3.SelectedValue) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>"; notification.InnerHtml += "<div> - มีข้อมูลตำแหน่งพนักงานราชการที่คุณเลือกนี้อยู่แล้วในระบบ</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlTab4EmpPositionRow3.SelectedIndex == 0) { //ขวา PS_PERSON P0 = new PS_PERSON(); TB_PDH_EMP P2 = new TB_PDH_EMP(); P0.PS_WORK_POS_ID = Convert.ToInt32(ddlTab4PositionWorkRow1.SelectedValue); P0.PS_ADMIN_POS_ID = Convert.ToInt32(ddlTab4AdminPositionRow1.SelectedValue); P0.PS_ACAD_POS_ID = Convert.ToInt32(ddlTab4AcadPositionRow1.SelectedValue); P0.PS_POSI_EMP_GROUP = Convert.ToInt32(ddlTab4EmpPositionRow3.SelectedValue); P0.PS_CITIZEN_ID = p; P0.UPDATE_PS_PERSON_TAB4_EVERYONE_EMP(); DataTable dt = P2.SELECT_POSI_EMP_ONLY(p, "", ""); GridviewPDHemp.DataSource = dt; GridviewPDHemp.DataBind(); SetViewState(dt); notification.Attributes["class"] = "alert alert_success"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/correct.png' /><strong>บันทึกข้อมูลตำแหน่งสำเร็จ</strong></div>"; } else { //ขวา PS_PERSON P0 = new PS_PERSON(); P0.PS_WORK_POS_ID = Convert.ToInt32(ddlTab4PositionWorkRow1.SelectedValue); P0.PS_ADMIN_POS_ID = Convert.ToInt32(ddlTab4AdminPositionRow1.SelectedValue); P0.PS_ACAD_POS_ID = Convert.ToInt32(ddlTab4AcadPositionRow1.SelectedValue); P0.PS_POSI_EMP_GROUP = Convert.ToInt32(ddlTab4EmpPositionRow3.SelectedValue); P0.PS_CITIZEN_ID = p; P0.UPDATE_PS_PERSON_TAB4_EVERYONE_EMP(); TB_PDH_EMP P2 = new TB_PDH_EMP(); P2.PDH_CITIZEN_ID = p; P2.PDH_DATE_START = Util.ODT(tbDateGetPositionEMPTab4.Text); if (ddlTab4EmpPositionRow3.SelectedIndex != 0) { P2.PDH_POSITION_GET = Convert.ToInt32(ddlTab4EmpPositionRow3.SelectedValue); } P2.INSERT_POSI_EMP_ONLY(); ClearRightTab4(); DataTable dt = P2.SELECT_POSI_EMP_ONLY(p, "", ""); GridviewPDHemp.DataSource = dt; GridviewPDHemp.DataBind(); SetViewState(dt); notification.Attributes["class"] = "alert alert_success"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/correct.png' /><strong>บันทึกข้อมูลตำแหน่งสำเร็จ</strong></div>"; } } } }