recontrol.java

固定資産

/*
 * 创建日期 2006-7-3
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package contorl;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;

import javax.swing.JOptionPane;
import model.DBManager;

import view.ReturnEquipmentPane;

/**
 * @author 21660313010
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class REControl implements ActionListener
{
	

	private ReturnEquipmentPane pane;
	private DBManager db=new DBManager();
	private ResultSet rs;
	private int eid;
	private String mid;
	private String uid;
	private String note;
	private Timestamp timestamp;
	private String sql;
	private int stute;
	private String seid;

	/**
	 * @param pane
	 */
	public REControl(ReturnEquipmentPane pane) {
		this.pane=pane;
		
		// TODO 自动生成构造函数存根
	}

	/* （非 Javadoc）
	 * @see java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent)
	 */
	public void actionPerformed(ActionEvent e)
	{
		// TODO 自动生成方法存根
		Object button=e.getSource();	
		boolean success=false;
		
			if(button==pane.confirmbtn)
			{
				pane.surebtn.setEnabled(true);
				pane.cancelbtn.setEnabled(true);
				seid=pane.numbertex.getText().trim();
				mid=pane.manageridtex.getText().trim();
				uid=pane.idtex.getText().trim();
				note=pane.notetex.getText().trim();
				stute=pane.stutecbx.getSelectedIndex();
				try{
					timestamp=Timestamp.valueOf(pane.datetex.getText().trim()+" 00:00:00.000");
				}
				catch(IllegalArgumentException ie)
				{
					JOptionPane.showMessageDialog(null,"输入的时间格式有误,请参考:yyyy-mm-dd");
					pane.datetex.setText("");
					pane.surebtn.setEnabled(false);
					pane.cancelbtn.setEnabled(false);
					return;
				}
				eid=Integer.parseInt(seid);
				if(eid==-1||mid.equals("")||uid.equals(""))
				{
					JOptionPane.showMessageDialog(null,"请输入完整");
					pane.surebtn.setEnabled(false);
					pane.cancelbtn.setEnabled(false);
					return;
				}
				
				dofine();
				
			}
			if(button==pane.surebtn)
			{
				dofine();
				int confirm=JOptionPane.showConfirmDialog(null,"以上信息是否正确?","确认",JOptionPane.YES_NO_OPTION);
				if(confirm==JOptionPane.YES_OPTION)
				{
					
					sql="insert into returnin(ieid,iuid,idate,iiremark,imid) values( "+eid+","+uid+",'"+timestamp+"','"+note+"',"+mid+")";					
					System.out.println(sql);
					success=db.executeSql(sql);
					if(!success)
					{
						JOptionPane.showMessageDialog(null,"不成功，请重试");
						pane.numberlbl.setText("资产编号");
						pane.idlbl.setText("用户编号");
						pane.mangeridlbl.setText("管理员编号");
						pane.idtex.setText("");
						pane.numbertex.setText("");
						pane.notetex.setText("");
						pane.datetex.setText("");
						pane.manageridtex.setText("");
						pane.surebtn.setEnabled(false);
						pane.cancelbtn.setEnabled(false);
						return;
					}
					sql="update equipment set estute="+stute+" ,euid=0 where eid="+eid;
					System.out.println(sql);
					success=db.executeSql(sql);
					if(!success)
					{
						JOptionPane.showMessageDialog(null,"不成功，请重试");
						pane.numberlbl.setText("资产编号");
						pane.idlbl.setText("用户编号");
						pane.mangeridlbl.setText("管理员编号");
						pane.idtex.setText("");
						pane.numbertex.setText("");
						pane.notetex.setText("");
						pane.datetex.setText("");
						pane.manageridtex.setText("");
						pane.surebtn.setEnabled(false);
						pane.cancelbtn.setEnabled(false);
						return;
						
					}
					else
					{
						JOptionPane.showMessageDialog(null,"成功");
						pane.numberlbl.setText("资产编号");
						pane.idlbl.setText("用户编号");
						pane.mangeridlbl.setText("管理员编号");
						pane.idtex.setText("");
						pane.numbertex.setText("");
						pane.notetex.setText("");
						pane.datetex.setText("");
						pane.manageridtex.setText("");
						pane.surebtn.setEnabled(false);
						pane.cancelbtn.setEnabled(false);
						return;
					}
				}
			}
		
			if(button==pane.cancelbtn)
			{
				
				pane.numberlbl.setText("资产编号");
				pane.idlbl.setText("用户编号");
				pane.mangeridlbl.setText("管理员编号");
				pane.idtex.setText("");
				pane.numbertex.setText("");
				pane.notetex.setText("");
				pane.datetex.setText("");
				pane.manageridtex.setText("");
				pane.surebtn.setEnabled(false);
				pane.cancelbtn.setEnabled(false);
				return;
				
			}
		}
			private void dofine()
			{
				sql="select ename,estute from equipment where eid="+eid;
				rs=db.getResult(sql);
				
					try
					{
					if(!rs.first()|rs.getInt(2)!=4)
					{
						JOptionPane.showMessageDialog(null,"找不到资产的相关信息");
						pane.numberlbl.setText("资产编号");
						pane.idlbl.setText("用户编号");
						pane.mangeridlbl.setText("管理员编号");
						pane.idtex.setText("");
						pane.numbertex.setText("");
						pane.notetex.setText("");
						pane.datetex.setText("");
						pane.manageridtex.setText("");
						pane.surebtn.setEnabled(false);
						pane.cancelbtn.setEnabled(false);
						return;
						
					}
					else{
						pane.numberlbl.setText("资产名称");
						pane.numbertex.setText(rs.getString(1));
					
					}
					}
					catch(SQLException e)
					{

						JOptionPane.showMessageDialog(null,"找不到资产的相关信息");
						pane.numberlbl.setText("资产编号");
						pane.idlbl.setText("用户编号");
						pane.mangeridlbl.setText("管理员编号");
						pane.idtex.setText("");
						pane.numbertex.setText("");
						pane.notetex.setText("");
						pane.datetex.setText("");
						pane.manageridtex.setText("");
						pane.surebtn.setEnabled(false);
						pane.cancelbtn.setEnabled(false);
								return;
					}
					sql="select uname,udel from users where uid="+uid;
					rs=db.getResult(sql);
					try
					{
					if(!rs.first()|rs.getInt(2)==1)
					{
						JOptionPane.showMessageDialog(null,"找不到用户的相关信息");
						pane.numberlbl.setText("资产编号");
						pane.idlbl.setText("用户编号");
						pane.mangeridlbl.setText("管理员编号");
						pane.idtex.setText("");
						pane.numbertex.setText("");
						pane.notetex.setText("");
						pane.datetex.setText("");
						pane.manageridtex.setText("");
						pane.surebtn.setEnabled(false);
						pane.cancelbtn.setEnabled(false);
						return;
					}
					else{
						pane.idlbl.setText("用户名");
						pane.idtex.setText(rs.getString(1));
					
					}
					}
					catch(SQLException e)
					{

						JOptionPane.showMessageDialog(null,"找不到用户的相关信息");
						pane.numberlbl.setText("资产编号");
						pane.idlbl.setText("用户编号");
						pane.mangeridlbl.setText("管理员编号");
						pane.idtex.setText("");
						pane.numbertex.setText("");
						pane.notetex.setText("");
						pane.datetex.setText("");
						pane.manageridtex.setText("");
						pane.surebtn.setEnabled(false);
						pane.cancelbtn.setEnabled(false);
								return;
					}
					sql="select mname,mdel from manager where mid="+mid;
					rs=db.getResult(sql);
					try
					{
						if(!rs.first()|rs.getInt(2)==1)
						{
							JOptionPane.showMessageDialog(null,"找不到管理员的相关信息");
							pane.numberlbl.setText("资产编号");
							pane.idlbl.setText("用户编号");
							pane.mangeridlbl.setText("管理员编号");
							pane.idtex.setText("");
							pane.numbertex.setText("");
							pane.notetex.setText("");
							pane.datetex.setText("");
							pane.manageridtex.setText("");
							pane.surebtn.setEnabled(false);
							pane.cancelbtn.setEnabled(false);
							return;
						}
						else{
							pane.mangeridlbl.setText("管理员");
							pane.manageridtex.setText(rs.getString(1));
						
					}
				}catch(SQLException e)
				{

					JOptionPane.showMessageDialog(null,"找不到管理员的相关信息");
					pane.numberlbl.setText("资产编号");
					pane.idlbl.setText("用户编号");
					pane.mangeridlbl.setText("管理员编号");
					pane.idtex.setText("");
					pane.numbertex.setText("");
					pane.notetex.setText("");
					pane.datetex.setText("");
					pane.manageridtex.setText("");
					pane.surebtn.setEnabled(false);
					pane.cancelbtn.setEnabled(false);
							return;
				}
				
	}
}