package frame;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.GridLayout;
import java.awt.Toolkit;
import java.awt.event.WindowAdapter;
import java.awt.event.*;
import java.sql.ResultSet;

import model.FrameInit;
import javax.swing.*;
import model.TbEmployeeInfo;
import com.DAO;
public class UpdateEmpInfo extends JFrame{
	JFrame uei = new JFrame("修改員工數(shù)據(jù)");
	JPanel p = new JPanel();
	JTextField ename;
	JTextField eyname = new JTextField(10);
	JComboBox sex = new JComboBox();
	JTextField birthday = new JTextField(10);
	JComboBox nativeplace = new JComboBox();
	JComboBox nation = new JComboBox();
	JTextField hkszd = new JTextField(10);
	JLabel lhkszd = new JLabel("戶口所在地:");
	JTextField bornaddress = new JTextField(10);
	JLabel lba = new JLabel("出生地:");
	JTextField commnityname = new JTextField(10);
	JLabel lcn = new JLabel("社區(qū)名稱:");
	JTextField firstedu = new JTextField(10);
	JLabel lfedu = new JLabel("最初學(xué)歷:");
	JTextField education = new JTextField(10);
	JLabel ledu = new JLabel("學(xué)歷");
	JTextField school = new JTextField(10);
	JLabel lschool = new JLabel("畢業(yè)院校:");
	JTextField specialname = new JTextField(10);
	JLabel lsn = new JLabel("專業(yè)名稱:");
	JTextField intoschooldate = new JTextField(10);
	JLabel lisd = new JLabel("入學(xué)日期:");
	JTextField graduatedate = new JTextField(10);
	JLabel lgd = new JLabel("畢業(yè)日期:");
	JLabel life = new JLabel("是否第一學(xué)歷:");
	JComboBox isfirstedu = new JComboBox();
	JLabel ldg = new JLabel("學(xué)位:");
	JComboBox degree = new JComboBox();
	JLabel ley = new JLabel("受教育年限:");
	JTextField eduyears = new JTextField(10);
	JLabel lsw = new JLabel("學(xué)習(xí)形式");
	JTextField studyway = new JTextField(10);
	JLabel lpf = new JLabel("政治面貌:");
	JComboBox ploityface = new JComboBox();
	JLabel lipd = new JLabel("入黨時間:");
	JTextField intoparydate = new JTextField(10);
	JLabel lww = new JLabel("用工形式:");
	JTextField workway = new JTextField(10);
	JLabel ldn = new JLabel("職務(wù):");
	JComboBox dutyname =new JComboBox();
	JLabel lsdn = new JLabel("專業(yè)技術(shù)職務(wù):");
	JComboBox spedutyname = new JComboBox();
	JLabel lbwd = new JLabel("開始工作時間:");
	JTextField beginworkdate = new JTextField(10);
	JLabel lidd = new JLabel("入本單位時間:");
	JTextField intodeptdate = new JTextField(10);
	JLabel lws = new JLabel("工作狀態(tài):");
	JTextField workstate = new JTextField(10);
	JLabel lrdd = new JLabel("退休時間:");
	JTextField retireddate = new JTextField(10);
	JLabel lgrsf = new JLabel("個人身份:");
	JTextField grsf = new JTextField(10);
	JLabel lbgphone = new JLabel("辦公電話:");
	JTextField bgphone = new JTextField(10);
	JLabel lsjphone = new JLabel("手機:");
	JTextField sjphone = new JTextField(10);
	JLabel lhp = new JLabel("家庭電話:");
	JTextField homephone = new JTextField(10);
	JLabel lfyzym = new JLabel("復(fù)原轉(zhuǎn)業(yè)標識:");
	JTextField fyzymark = new JTextField(10);
	JLabel lidcard = new JLabel("身份證號:");
	JTextField idcard = new JTextField(10);
	JLabel lxxdate = new JLabel("下鄉(xiāng)日期:");
	JTextField xxdate = new JTextField(10);
	JLabel lldhtid = new JLabel("勞動合同編號:");
	JTextField ldhtid = new JTextField(10);
	JLabel lden = new JLabel("部門編號:");
	JComboBox deptno = new JComboBox();
	JLabel lcln = new JLabel("班組名稱:");
	JTextField classname = new JTextField(10);
	JLabel lmenu = new JLabel("備注:");
	JTextArea menu = new JTextArea();
	JButton btnupdate = new JButton("修改");
	JComboBox empid = new JComboBox();
	public UpdateEmpInfo(){
		init();
	}
	public void init(){
		FrameInit.InitFrame(uei, p);
        //添加打開窗口時的事件監(jiān)聽器，初始化下拉列表
		uei.addWindowListener(new WindowAdapter(){
			public void windowOpened(WindowEvent e){
				ResultSet rs1 = DAO.getNativePlace();
				ResultSet rs2 = DAO.getDegree();
				ResultSet rs3 = DAO.getNation();
				ResultSet rs4 = DAO.getDutyName();
				ResultSet rs5 = DAO.getSpecialDuty();
				ResultSet rs6 = DAO.getDeptID();
				ResultSet rs7 = DAO.getEmployeeId();
				try{
					while(rs1.next()){
						nativeplace.addItem(rs1.getString("npname"));
					}
					while(rs2.next()){
						degree.addItem(rs2.getString("degree"));
					}
					while(rs3.next()){
						nation.addItem(rs3.getString("nation"));
					}
					while(rs4.next()){
						dutyname.addItem(rs4.getString("dutyname"));
					}
					while(rs5.next()){
						spedutyname.addItem(rs5.getString("sdname"));
					}
					while(rs6.next()){
						deptno.addItem(new Integer(rs6.getInt("dkid")));
					}
					while(rs7.next()){
						empid.addItem(rs7.getString("empid"));
					}
				}catch(Exception ex){
					System.out.println(ex.getMessage());
				}
			}
		});
		uei.setSize(new Dimension(800,400));
		p.setLayout(new GridLayout(13,6));
		JLabel lblename = new JLabel("員工姓名:");
		p.add(lblename);
		ename = new JTextField(10);
		p.add(ename);
		JLabel lblyename = new JLabel("曾用名:");
		p.add(lblyename);
		p.add(eyname);
		JLabel lsex = new JLabel("性別:");
		p.add(lsex);
		sex.addItem("男");
		sex.addItem("女");
		p.add(sex);
		JLabel lsr = new JLabel("出生日期:");
		p.add(lsr);
		p.add(birthday);
		JLabel ljg = new JLabel("籍貫");
		p.add(ljg);
		p.add(nativeplace);
		JLabel lmz = new JLabel("民族");
		p.add(lmz);
		p.add(nation);
		p.add(lhkszd);
		p.add(hkszd);
		p.add(lba);
		p.add(bornaddress);
		p.add(lcn);
		p.add(commnityname);
		p.add(lfedu);
		p.add(firstedu);
		p.add(ledu);
		p.add(education);
		p.add(lschool);
		p.add(school);
		p.add(lsn);
		p.add(specialname);
		p.add(lisd);
		p.add(intoschooldate);
		p.add(lgd);
		p.add(graduatedate);
		isfirstedu.addItem("是");
		isfirstedu.addItem("否");
		p.add(life);
		p.add(isfirstedu);
		p.add(ldg);
		p.add(degree);
		p.add(ley);
		p.add(eduyears);
		p.add(lsw);
		p.add(studyway);
		p.add(lpf);
		ploityface.addItem("群眾");
		ploityface.addItem("團員");
		ploityface.addItem("中共黨員");
		ploityface.addItem("其他黨派人士");
		p.add(ploityface);
		p.add(lipd);
		p.add(intoparydate);
		p.add(lww);
		p.add(workway);
		p.add(ldn);
		p.add(dutyname);
		p.add(lbwd);
		p.add(beginworkdate);
		p.add(lidd);
		p.add(intodeptdate);
		p.add(lws);
		p.add(workstate);
		p.add(lrdd);
		p.add(retireddate);
		p.add(lgrsf);
		p.add(grsf);
		p.add(lbgphone);
		p.add(bgphone);
		p.add(lsjphone);
		p.add(sjphone);
		p.add(lhp);
		p.add(homephone);
		p.add(lfyzym);
		p.add(fyzymark);
		p.add(lidcard);
		p.add(idcard);
		p.add(lxxdate);
		p.add(xxdate);
		p.add(lldhtid);
		p.add(ldhtid);
		p.add(lden);
		p.add(deptno);
		p.add(lcln);
		p.add(classname);
		p.add(lmenu);
		p.add(menu);
		p.add(empid);
		//人員編碼的下拉列表選擇時的事件監(jiān)聽程序
		empid.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				String id = empid.getSelectedItem().toString().trim();
				int empno = Integer.parseInt(id);
				TbEmployeeInfo info = DAO.getSpeEmployee(empno);
				if(info!=null){
					ename.setText(info.getEname());
					eyname.setText(info.getEyname());
					sex.setSelectedItem(info.getSex());
					birthday.setText(info.getBirthday());
					nativeplace.setSelectedItem(info.getNativeplace());
					nation.setSelectedItem(info.getNation());
					hkszd.setText(info.getHkszd());
					bornaddress.setText(info.getBornaddress());
					commnityname.setText(info.getCommnityname());
					firstedu.setText(info.getFirstedu());
					education.setText(info.getEducation());
					school.setText(info.getSchool());
					specialname.setText(info.getSpecialname());
					intoschooldate.setText(info.getIntoschooldate());
					graduatedate.setText(info.getGraduatedate());
					isfirstedu.setSelectedItem(info.getIsfirstedu());
					degree.setSelectedItem(info.getDegree());
					eduyears.setText(""+info.getEduyears());
					studyway.setText(info.getStudyway());
					ploityface.setSelectedItem(info.getPolityface());
					intoparydate.setText(info.getIntopartydate());
					workway.setText(info.getWorkway());
					dutyname.setSelectedItem(info.getDutyname());
					spedutyname.setSelectedItem(info.getSpedutyname());
					beginworkdate.setText(info.getBeginworkdate());
					intodeptdate.setText(info.getIntodeptdate());
					workstate.setText(info.getWorkstate());
					retireddate.setText(info.getRetireddate());
					grsf.setText(info.getGrsf());
					bgphone.setText(info.getBgphone());
					sjphone.setText(info.getSjphone());
					homephone.setText(info.getHomephone());
					fyzymark.setText(info.getFyzymark());
					idcard.setText(info.getIdcard());
					deptno.setSelectedItem(""+info.getDeptno());
					classname.setText(info.getClassname());
					menu.setText(info.getMenu());
				}
			}
		});
		p.add(btnupdate);
		uei.setVisible(true);
	}

}