package yd.pethospital.diagnose.jdbc;

import java.sql.*;
import java.util.regex.*;
import javax.swing.*;
import yd.pethospital.share.SystemShare;
import yd.pethospital.diagnoseregister.view.*;

public class ChangeDiagnoseGet {
	
	static PreparedStatement pst;                      //聲明PreparedStatement對象 
	boolean check = false;
	public JFrame frame;                               //用于錯誤時返回原窗體
	
	public ChangeDiagnoseGet(JFrame frame){

		this.frame=frame;
		if(setDao(check)){
			
			frame.dispose();
		}
	}
	
	public static void GetText(){                     //調用
		
		ChangeDiagnose.TNum.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 1));
		ChangeDiagnose.TDate.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 2));
		ChangeDiagnose.TProblem.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 3));
		ChangeDiagnose.TResult.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 4));
		ChangeDiagnose.TWays.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 5));
		ChangeDiagnose.TMan.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 6));
		
	}
	
	public boolean setDao(boolean check){
		
		try {
			
			SystemShare.SQL="update DiagnoseInfo set diagnosedate=?,symptom=?,diagnoseresult=?,dealstep=?,diagnoseman=? where petcode="+ChangeDiagnose.TNum.getText();
			SystemShare.getConnection();
			ChangeDiagnoseGet.pst=SystemShare.pst; 
			
			if(ChangeDiagnose.TDate.getText().trim().equals("")){        //就診日期為空處理
				
				JOptionPane.showMessageDialog(null,"就診日期不允許為空！","修改診斷",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TDate.requestFocus();
				return false;
			}
			                                                             //就診日期處理
			Pattern birth=Pattern.compile("(([0-9]{3}[1-9]|[0-9]{2}[1-9][0-9]{1}|[0-9]{1}[1-9][0-9]{2}|[1-9][0-9]{3})-(((0[13578]|1[02])-(0[1-9]|[12][0-9]|3[01]))|((0[469]|11)-(0[1-9]|[12][0-9]|30))|(02-(0[1-9]|[1][0-9]|2[0-8]))))|((([0-9]{2})(0[48]|[2468][048]|[13579][26])|((0[48]|[2468][048]|[3579][26])00))-02-29) "); 
			Matcher mbirth=birth.matcher(ChangeDiagnose.TDate.getText()); 
			
			if (!mbirth.matches()){ 
				
				JOptionPane.showMessageDialog(null,"就診日期格式不符,重新輸入!", "錯誤對話框",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TDate.setText("");
				ChangeDiagnose.TDate.requestFocus();
                return false;
			} 
			
			if(ChangeDiagnose.TProblem.getText().trim().equals("")){    //癥狀為空處理
				
				JOptionPane.showMessageDialog(null,"癥狀不允許為空！","修改診斷",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TProblem.requestFocus();
				return false;
			}
			
			if(ChangeDiagnose.TResult.getText().trim().equals("")){     //診斷結果為空處理
				
				JOptionPane.showMessageDialog(null,"診斷結果不允許為空！","修改診斷",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TResult.requestFocus();
				return false;
			}

			if(ChangeDiagnose.TWays.getText().trim().equals("")){      //處理措施為空處理
				
				JOptionPane.showMessageDialog(null,"處理措施不允許為空！","修改診斷",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TWays.requestFocus();
				return false;
			}
			
			if(ChangeDiagnose.TMan.getText().trim().equals("")){       //診斷人為空處理
				
				JOptionPane.showMessageDialog(null,"診斷人不允許為空！","修改診斷",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TMan.requestFocus();
				return false;
			}
			
			pst.setString(1,ChangeDiagnose.TDate.getText().trim());      //修改就診日期
			pst.setString(2,ChangeDiagnose.TProblem.getText().trim());  //修改癥狀
			pst.setString(3,ChangeDiagnose.TResult.getText().trim());   //修改診斷結果
			pst.setString(4,ChangeDiagnose.TWays.getText().trim());    //修改處理措施
			pst.setString(5,ChangeDiagnose.TMan.getText().trim());     //修改診斷人
			
			pst.executeUpdate();
			                                            //修改診斷成功
			SystemShare.changesuccess();
			frame.dispose();
			new DiagnoseRegister();
			
			this.check=check;
			
		} catch (SQLException e) {                     //處理異常
			SystemShare.changefail();
		} 
		SystemShare.close();
		return false;
	}
}