package edu.sccp.chat.frame;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.BorderFactory;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;

import com.swtdesigner.SwingResourceManager;

import edu.sccp.chat.bo.DepartmentBO;
import edu.sccp.chat.dao.ConnData;
import edu.sccp.chat.jarClass.JarAllege;
import edu.sccp.chat.tools.Tools;

public class UpdateDeptMessage {

	private JTextArea depttextArea;
	private JComboBox deptcomboBox;
	/**
	 * @param args
	 */ 
	JFrame frame;
	public UpdateDeptMessage()
	{
		JarAllege.bai();
		initGUI();
	}
	private void initGUI()
	{
		frame=new JFrame("修改部門公告");
		frame.setIconImage(SwingResourceManager.getImage(UpdateDeptMessage.class, "/edu/sccp/chat/image/zhuxiao.png"));
		frame.getContentPane().setLayout(null);
		frame.addWindowListener(new WindowAdapter() {
			public void windowClosing(final WindowEvent e) {
				frame.dispose();
			}
		});

		final JLabel label = new JLabel();
		label.setText("選擇部門：");
		label.setBounds(23, 22, 63, 16);
		frame.getContentPane().add(label);
		depttextArea = new JTextArea();
		depttextArea.setEditable(false);
		
		deptcomboBox = new JComboBox();
		deptcomboBox.addItemListener(new ItemListener() {
			public void itemStateChanged(final ItemEvent e) {
				ResultSet rs;
				String name=(String)deptcomboBox.getSelectedItem();
				String sql="select * from t_dept where f_name='"+name+"'";
				try {
					rs=ConnData.conn().createStatement().executeQuery(sql);
					while(rs.next()){
						String text=rs.getString(6).trim();
						depttextArea.setText(text);	
					}
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
					
			}
		});
		Vector vector=DepartmentBO.selectdept();
		for(int i=0;i<vector.size();i++)
		{
			deptcomboBox.addItem(vector.get(i));
		};
	

		
		deptcomboBox.setBounds(95, 20, 140, 20);
		frame.getContentPane().add(deptcomboBox);

		final JScrollPane scrollPane = new JScrollPane();
		scrollPane.setBorder(BorderFactory.createTitledBorder("部門公告(30字內)"));
		scrollPane.setBounds(10, 44, 303, 152);
		frame.getContentPane().add(scrollPane);

		
		
		scrollPane.setViewportView(depttextArea);

		final JButton update = new JButton();
		update.setSelected(true);
		update.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				if(update.isSelected())
				{
					update.setText("提交");
					update.setSelected(false);
					depttextArea.setEditable(true);
				}
				else
				{
					if(!Tools.checkLength(depttextArea.getText(), 0, 30))
					{
						JOptionPane.showMessageDialog(frame, "字符過長(限30字內)", "Warning", JOptionPane.WARNING_MESSAGE);
						return;
					}
						
					String name=(String)deptcomboBox.getSelectedItem();
					boolean f=DepartmentBO.alterMessageData("t_dept",depttextArea.getText(), name);
					if(f)
						JOptionPane.showMessageDialog(frame, "修改成功","提示",JOptionPane.INFORMATION_MESSAGE);
					else
						JOptionPane.showMessageDialog(frame, "修改失敗","提示",JOptionPane.INFORMATION_MESSAGE);
				}
			}
		});
		update.setText("修改");
		update.setBounds(95, 202, 81, 25);
		frame.getContentPane().add(update);

		final JButton close = new JButton();
		close.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				frame.dispose();
			}
		});
		close.setText("關閉");
		close.setBounds(206, 202, 87, 25);
		frame.getContentPane().add(close);
	}
	public void showGUI()
	{
		frame.setResizable(false);
		frame.setSize(329,263);
		frame.setLocationRelativeTo(null);
		frame.setVisible(true);
	}
	public static void main(String[] args) {
		// TODO Auto-generated method stub

		//new UpdateDeptMessage().showGUI();
	}

}