⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 setup.java

📁 主要功能包括散客开单、团体开单、宾客结帐、客房预订、营业查询、客户管理、网络设置、系统设置等等。 详细说明见阳光酒店管理系统需求规格说明书。
💻 JAVA
📖 第 1 页 / 共 4 页
字号:
		ResultSet rs = null;
		String aState = "";
		try {
			for (int i = 0; i < ar; i++) {
				rs = sunsql.executeQuery("select state from roominfo where " +
				"delmark=0 and pk='" + dtm12.getValueAt(aRow[i], 0) + "'");
				rs.next();
				aState = rs.getString(1);
				if(aState.equals("占用")) {
					JOptionPane.showMessageDialog(null, "[ " + dtm12.getValueAt(aRow[i], 2) + 
					" ] 房间正处于占用状态,无法执行删除操作,系统取消了所有删除操作", "提示", JOptionPane.INFORMATION_MESSAGE);
					return false;
				}else if(aState.equals("钟点")) {
					JOptionPane.showMessageDialog(null, "[ " + dtm12.getValueAt(aRow[i], 2) + 
					" ] 房间正处于钟点房状态,无法执行删除操作,系统取消了所有删除操作", "提示", JOptionPane.INFORMATION_MESSAGE);
					return false;
				}else if(aState.equals("预订")) {
					JOptionPane.showMessageDialog(null, "[ " + dtm12.getValueAt(aRow[i], 2) + 
					" ] 房间正处于预订状态,无法执行删除操作,系统取消了所有删除操作", "提示", JOptionPane.INFORMATION_MESSAGE);
					return false;
				}//Endif
	    	}//Endif
	    }
	    catch (Exception ex) {
	    	ex.printStackTrace();
	    	System.out.println ("Setup.isState(): false");
	    }//End try
	    return true;
	}
	
	
	
	
	/**=======================================================================**
	 *			ActionListener 监听
	 **=======================================================================**
	 */
	public void actionPerformed(ActionEvent ae) {
		Object o = ae.getSource();
		if(o == bt11) {//=======================================================
			art.show(true);					//添加房间类型
			buildDTM11();					//刷新表数据
			buildDTM12("");					//刷新表数据
			buildDTM22();					//刷新表数据
			
		}else if(o == bt12) {//=================================================
			if(initMrt()) {					//传数据给窗口
				mrt.show(true);				//修改房间类型
				buildDTM11();				//刷新表数据
				buildDTM12("");				//刷新表数据
				buildDTM22();				//刷新表数据
			}//Endif
			
		}else if(o == bt13) {//=================================================
				int rRow[] = tb11.getSelectedRows();			//删除房间类型
				int sysmark;
				for (int i = 0; i < rRow.length; i++) {
					//获得得记录的属性标志,并转成整型
					sysmark = Integer.parseInt(dtm11.getValueAt(rRow[i], 1) + "");
					if(sysmark == 1) {
						JOptionPane.showMessageDialog(null, "[ " + dtm11.getValueAt(rRow[i], 4) + 
						" ] 类型为系统级设置,不允许被删除,系统终止了删除操作 ...", "提示",
						JOptionPane.INFORMATION_MESSAGE);
						return;				//不执行删除返回窗口
					}//Endif
			    }//Endfor
				String msg = "注意,删除 [ 房间类型 ] 操作会将与 [ 房间类型 ] 相关" +
				"的所有 [ 房间信息 ] 一并删除。\n您确定要删除在表格中选中的类型条目吗?";
				
				if(delInfo ("roomtype", dtm11, rRow, msg)) {	//执行删除操作
					buildDTM11();			//刷新类型表数据
					buildDTM12("");			//刷新房间表数据
					buildDTM22();			//刷新类型表数据
					journal = "执行了删除房间类型的操作--删除数量:" + rRow.length;
					Journal.writeJournalInfo(HotelFrame.userid, journal, Journal.TYPE_RT);//记录操作日志
				}//Endif
				
		}else if(o == bt14) {//=================================================
			if(initDis(tb11, dtm11)) {				//房间费打折
				dis.show(true);
			}//Endif
		}else if(o == bt15) {//=================================================
			sunsql.initJComboBox(AddRoomInfo.cb1, "select r_type from roomtype where delmark = 0");
			ari.show(true);					//单个添加房间信息
			buildDTM12("");					//刷新表数据
			
		}else if(o == bt16) {//=================================================
			sunsql.initJComboBox(AddRoomInfos.cb, "select r_type from roomtype where delmark = 0");
			aris.show(true);				//批量添加房间信息
			buildDTM12("");					//刷新表数据
			
		}else if(o == bt18) {//=================================================
			sunsql.initJComboBox(ModiRoomInfo.cb1, "select r_type from roomtype where delmark = 0");
			if(initMri()) {					//传数据给窗口
				mri.show(true);				//修改房间信息
				buildDTM12("");				//刷新表数据
			}//Endif
			
		}else if(o == bt17) {//=================================================
			int rRow[] = tb12.getSelectedRows();			//删除房间信息
			if(isState(rRow)) {				//判断房间的状态是否可以删除
				if(delInfo ("roominfo", dtm12, rRow, msg0)) {	//执行删除操作
					buildDTM12("");			//刷新房间表数据
					journal = "执行了删除房间信息的操作--删除数量:" + rRow.length;
					Journal.writeJournalInfo(HotelFrame.userid, journal, Journal.TYPE_RI);//记录操作日志
				}//Endif
			}
		}else if(o == bt19) {//=================================================
			if(!suntools.isNum(tf11.getText(),2 ,5 ,30))	{	//保存退房后房间状态
				JOptionPane.showMessageDialog(null, "结算后更改房间状态的时间框只能为数字,且范围在 5 - 30 之间",
				"提示", JOptionPane.INFORMATION_MESSAGE);
				tf11.requestFocus(true);
				return;
			}
			sunini.setIniKey(ini[16], cb12.getSelectedIndex() + "");	//将设置保存至缓冲区
			sunini.setIniKey(ini[17], tf11.getText());			
			sunini.saveIni(ini);								//将缓冲区的设置保存至INI文件
			
		}else if(o == bt20) {//=================================================
				int cbIndex = cb11.getSelectedIndex();		//筛选信息
				if(cbIndex == cb11.getItemCount() - 1) {	//显示全部房间
					buildDTM12("");							//刷新房间表数据
				}else {
					String rt = "and a.r_type_id = '" + dtm11.getValueAt(cbIndex, 2) + "'";
					buildDTM12(rt);							//根据指定房间类型刷新表数据
				}//Endif
				
		}else if(o == bt21) {//=================================================
			act.show(true);					//添加客户类型
			buildDTM21();
			
		}else if(o == bt22) {//=================================================
			if(initMct()) {					//传数据给窗口
				mct.show(true);				//修改客户类型
				buildDTM21();				//刷新表数据
			}//Endif
			
		}else if(o == bt23) {//=================================================
			int rRow[] = tb21.getSelectedRows();				//删除客户类型
			if(delInfo ("customertype", dtm21, rRow, msg0)) {	//执行删除操作
				buildDTM21();			//刷新房间表数据
				journal = "执行了删除客户类型的操作--删除数量:" + rRow.length;
				Journal.writeJournalInfo(HotelFrame.userid, journal, Journal.TYPE_US);//记录操作日志
			}//Endif
			
		}else if(o == bt24) {//=================================================
			if(initDis(tb22, dtm22)) {		//房间费打折
				dis.show(true);
			}//Endif
		}else if(o == bt31) {//===================================//登记操作员信息
			if(String.valueOf(tf32.getPassword()).length() == 0) {
			 	JOptionPane.showMessageDialog(null, " [ 新密码 ] 不能为空", "提示", 
			 	JOptionPane.INFORMATION_MESSAGE);
			 	return;
			}else if(String.valueOf(tf33.getPassword()).length() == 0) {
				JOptionPane.showMessageDialog(null, " [ 确认密码 ] 不能为空", "提示", 
				JOptionPane.INFORMATION_MESSAGE);
				return;
			}//Endif
			umAdd ();					//执行添加操作
			buildDTM31();				//刷新表数据
			journal = "添加了新的操作员信息-- [ " + cb31.getEditor ().getItem () + " ]";
			Journal.writeJournalInfo(HotelFrame.userid, journal, Journal.TYPE_CZ);//记录操作日志
			
		}else if(o == bt32) {//==================================//修改操作员信息
			if(String.valueOf(tf31.getPassword()).length() == 0) {
				JOptionPane.showMessageDialog(null, " [ 新密码 ] 不能为空", "提示", 
				JOptionPane.INFORMATION_MESSAGE);
				return;
			}else if(String.valueOf(tf32.getPassword()).length() == 0) {
				JOptionPane.showMessageDialog(null, " [ 新密码 ] 不能为空", "提示", 
				JOptionPane.INFORMATION_MESSAGE);
				return;
			}else if(String.valueOf(tf33.getPassword()).length() == 0) {
				JOptionPane.showMessageDialog(null, " [ 确认密码 ] 不能为空", "提示", 
				JOptionPane.INFORMATION_MESSAGE);
				return;
			}//Endif
			umUpdate (0);				//执行修改密码操作
			journal = "修改了操作员 [ " + cb31.getEditor ().getItem () + " ] 的设置";
			Journal.writeJournalInfo(HotelFrame.userid, journal, Journal.TYPE_CZ);//记录操作日志
			
		}else if(o == bt33) {//=================================================//删除操作员信息
			if(String.valueOf(tf32.getPassword()).length() == 0) {
				JOptionPane.showMessageDialog(null, " [ 新密码 ] 不能为空", "提示", 
				JOptionPane.INFORMATION_MESSAGE);
				return;
			}else if(String.valueOf(tf33.getPassword()).length() == 0) {
				JOptionPane.showMessageDialog(null, " [ 确认密码 ] 不能为空", "提示", 
				JOptionPane.INFORMATION_MESSAGE);
				return;
			}//Endif
			int wi = JOptionPane.showConfirmDialog(null,"您确认要删除当前的用户ID吗?", 
			"提示", JOptionPane.YES_NO_OPTION);
			
			if(wi == JOptionPane.YES_OPTION) {
				umUpdate (1);			//执行删除用户ID操作
				buildDTM31();			//刷新表数据
				journal = "删除了操作员 [ " + cb31.getEditor ().getItem () + " ] 的设置";
				Journal.writeJournalInfo(HotelFrame.userid, journal, Journal.TYPE_CZ);//记录操作日志
			}//Endif
			
		}else if(o == bt41) {//=================================================
			if(isValidity()) {
				int saveJf = JOptionPane.showConfirmDialog(null, "您 确 实 要 保 存 " +
				"当 前 的 计 费 设 置 吗 ?","保存设置",JOptionPane.YES_NO_OPTION);
				if(saveJf == JOptionPane.YES_OPTION) {		//保存计费设置
					sunini.setIniKey("In_Room", tf41.getText());	//将设置保存至缓冲区
					sunini.setIniKey("Out_Room1", tf42.getText());
					sunini.setIniKey("Out_Room2", tf43.getText());
					sunini.setIniKey("ClockRoom1", tf44.getText());
					sunini.setIniKey("ClockRoom2", tf45.getText());
					sunini.setIniKey("InsuHour1", tf46.getText());
					sunini.setIniKey("InsuHour2", tf47.getText());
					if(ck.isSelected()) {					//不足一天按一天收费
						sunini.setIniKey("InsuDay","1");
					}else {
						sunini.setIniKey("InsuDay","0");
					}//Endif
					sunini.saveIni(ini);					//将缓冲区的设置保存至INI文件
					journal = "修改了系统的计费设置";
					Journal.writeJournalInfo(HotelFrame.userid, journal, Journal.TYPE_JF);//记录操作日志
				}//Endif
			}//Endif
		}else if(o == bt42) {//=================================================
			this.setVisible(false);			//返回主窗口
		}else if(o == tf41) {
			tf42.requestFocus(true);
		}else if(o == tf42) {
			tf43.requestFocus(true);
		}else if(o == tf43) {
			tf44.requestFocus(true);
		}else if(o == tf44) {
			tf45.requestFocus(true);
		}else if(o == tf45) {
			tf46.requestFocus(true);
		}else if(o == tf46) {
			tf47.requestFocus(true);
			
		}else if(o == rb31) {//=================================================
			bt31.setEnabled (true);			//操作范围--添加新操作员
			bt32.setEnabled (false);
			bt33.setEnabled (false);
			rb34.setEnabled (true);
			rb35.setEnabled (true);
			tf31.setEditable(false);
			tf32.setEditable(true);
			tf33.setEditable(true);
			cb31.setEditable (true);
			
		}else if(o == rb32) {				//操作范围--操作员修改密码
			bt31.setEnabled (false);
			bt32.setEnabled (true);
			bt33.setEnabled (false);
			rb34.setEnabled (false);
			rb35.setEnabled (false);
			tf31.setEditable(true);
			tf32.setEditable(true);
			tf33.setEditable(true);
			cb31.setEditable (false);
			
		}else if(o == rb33) {				//操作范围--删除操作员
			bt31.setEnabled (false);
			bt32.setEnabled (false);
			bt33.setEnabled (true);
			rb34.setEnabled (false);
			rb35.setEnabled (false);
			tf31.setEditable(false);
			tf32.setEditable(true);
			tf33.setEditable(true);
			cb31.setEditable (false);
		}//Endif
	}//End actionPerformed
	
	
	/**=======================================================================**
	 *			MouseListener 监听
	 **=======================================================================**
	 */
	public void mouseClicked (MouseEvent me) {
	}

	public void mousePressed (MouseEvent me) {
	}

	public void mouseReleased(MouseEvent me) {
	}

	public void mouseEntered (MouseEvent me) {		//鼠标移进提示
		Object o = me.getSource ();
		if(o == bt11) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"添加新的房间类型                      ");
		}else if(o == bt12) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"修改指定的房间类型                     ");
		}else if(o == bt13) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"删除指定的房间类型                     ");
		}else if(o == bt14) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"设置指定房间类型的消费折扣                 ");
		}else if(o == bt15) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"为指定的房间类型添加新的客房                ");
		}else if(o == bt16) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"为指定的房间类型一次添加多个新客房             ");
		}else if(o == bt17) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"修改指定客房信息设置                    ");
		}else if(o == bt18) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"删除指定的客房                       ");
		}else if(o == bt19) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"保存房间退房后的状态                    ");
		}else if(o == bt20) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"以左边指定的类型显示房间信息                ");
		} if(o == bt21) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"添加新的客户类型                      ");
		}else if(o == bt22) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"修改指定的客户资料                     ");
		}else if(o == bt23) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"删除指定的客户资料                     ");
		}else if(o == bt24) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"设置指定房间类型的消费折扣                 ");
		}else if(o == bt31) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"添加新的操作员                       ");
		}else if(o == bt32) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"修改指定的操作员密码                    ");
		}else if(o == bt33) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"删除指定的操作员                      ");
		}else if(o == bt41) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"保存当前的计费设置至INI配置文件              ");
		}else if(o == bt42) {
			HotelFrame.lbA.setText (HotelFrame.clue + 
			"返回主窗口                         ");
		}
	}

	public void mouseExited (MouseEvent me) {
		HotelFrame.lbA.setText (HotelFrame.clue + 
		"请选择功能项 ...                       ");
	}
	
}

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -