📄 frmbrjz.java
字号:
// colBuild2();
}
public void colBuild1() {
String[] columns={
"发生日期",
"科目",
"金额",
"单价",
"数量",
"所在科室",
"计价单位"};
colBRFY1 = new TableColumn(tblBRFY,SWT.LEFT);
colBRFY1.setText(columns[0]);
colBRFY1.setWidth(70);
colBRFY2 = new TableColumn(tblBRFY,SWT.LEFT);
colBRFY2.setText(columns[1]);
colBRFY2.setWidth(70);
colBRFY3 = new TableColumn(tblBRFY,SWT.LEFT);
colBRFY3.setText(columns[2]);
colBRFY3.setWidth(70);
colBRFY4 = new TableColumn(tblBRFY,SWT.LEFT);
colBRFY4.setText(columns[3]);
colBRFY4.setWidth(70);
colBRFY5 = new TableColumn(tblBRFY,SWT.LEFT);
colBRFY5.setText(columns[4]);
colBRFY5.setWidth(70);
colBRFY6 = new TableColumn(tblBRFY,SWT.LEFT);
colBRFY6.setText(columns[5]);
colBRFY6.setWidth(70);
colBRFY7 = new TableColumn(tblBRFY,SWT.LEFT);
colBRFY7.setText(columns[6]);
colBRFY7.setWidth(70);
}
public void colBuild2() {
String[] columnss={
"缴费日期",
"收费员",
"金额",
"住院号",
"缴费形式"};
colBRJF1 = new TableColumn(tblBRFY,SWT.LEFT);
colBRJF1.setText(columnss[0]);
colBRJF1.setWidth(70);
colBRJF2 = new TableColumn(tblBRFY,SWT.LEFT);
colBRJF2.setText(columnss[1]);
colBRJF2.setWidth(70);
colBRJF3 = new TableColumn(tblBRFY,SWT.LEFT);
colBRJF3.setText(columnss[2]);
colBRJF3.setWidth(70);
colBRJF4 = new TableColumn(tblBRFY,SWT.LEFT);
colBRJF4.setText(columnss[3]);
colBRJF4.setWidth(70);
colBRJF5 = new TableColumn(tblBRFY,SWT.LEFT);
colBRJF5.setText(columnss[4]);
colBRJF5.setWidth(70);
}
public void dispose(){
TableColumn[] column=tblBRFY.getColumns();
for(int i=0;i<column.length;i++){
column[i].dispose();
}
}
//public void dispose1()
// {
// colBRFY1.dispose();
// colBRFY2.dispose();
// colBRFY3.dispose();
// colBRFY4.dispose();
// colBRFY5.dispose();
// colBRFY6.dispose();
// colBRFY7.dispose();
// }
//public void dispose2()
// {
// colBRJF1.dispose();
// colBRJF2.dispose();
// colBRJF3.dispose();
// colBRJF4.dispose();
// colBRJF5.dispose();
//
// }
private void createGroup2(){
Group group1 = new Group(shell,SWT.SHADOW_ETCHED_IN);
//设置group显示格式
GridData gridData0 = new GridData(GridData.HORIZONTAL_ALIGN_BEGINNING);
gridData0.horizontalSpan=2;
gridData0.heightHint = 25;
gridData0.widthHint =150;
group1.setLayoutData(gridData0);
//设置group布局
GridLayout gridLayout0 = new GridLayout();
gridLayout0.numColumns = 2;
group1.setLayout(gridLayout0);
btnBRFY = new Button(group1,SWT.RADIO);
btnBRFY.setText("病人费用");
btnBRFY.setSelection(true);
btnBRFY.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
btnBRJF.setSelection(false);
// dispose1();
// dispose2();
tblBRFY.removeAll();
dispose();
colBuild1();
colBRFY1.setText("发生日期");
colBRFY1.setWidth(70);
colBRFY2.setText("科目");
colBRFY2.setWidth(70);
colBRFY3.setText("金额");
colBRFY3.setWidth(70);
colBRFY4.setText("单价");
colBRFY4.setWidth(70);
colBRFY5.setText("数量");
colBRFY5.setWidth(70);
colBRFY6.setText("所在科室");
colBRFY6.setWidth(70);
colBRFY7.setText("计价单位");
colBRFY7.setWidth(70);
String zyh2 = new String();
zyh2 = txtZYH.getText();
// System.out.println(zyh1);
db.tblBrfy(zyh2);
try{
// colBRJF1.setText(db.rst.getString("JFRQ"));
while(db.st.next()){
// System.out.println(db.rt.getString("JFRQ"));
String[] items2=new String[7];
items2[0]=db.st.getString("CFRQ");
items2[5]=db.st.getString("ZYKS");
items2[1]=db.st.getString("KM");
float lfDJ1=db.st.getFloat("DJ");
int liSL1=db.st.getInt("SL");
float lfJE1=lfDJ1*liSL1;
items2[2]=String.valueOf(lfJE1);
items2[3]=String.valueOf(lfDJ1);
items2[4]=String.valueOf(liSL1);
items2[6]=db.st.getString("JJDW");
TableItem item3 = new TableItem(tblBRFY,SWT.NONE);
item3.setText(items2);
}
}
catch(SQLException eve){
System.out.println(eve.getMessage());
eve.printStackTrace();
}
}
});
btnBRJF = new Button(group1,SWT.RADIO);
btnBRJF.setText("病人交费");
btnBRJF.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent e) {
btnBRJF.setSelection(true);
// dispose1();
// dispose2();
tblBRFY.removeAll();
dispose();
colBuild2();
// colBRFY1.dispose();
// colBRFY2.dispose();
// colBRFY3.dispose();
// colBRFY4.dispose();
// colBRFY5.dispose();
// colBRFY6.dispose();
// colBRFY7.dispose();
//
//
colBRJF1.setText("缴费日期");
colBRJF1.setWidth(70);
colBRJF2.setText("收费员");
colBRJF2.setWidth(70);
colBRJF3.setText("金额");
colBRJF3.setWidth(70);
colBRJF4.setText("住院号");
colBRJF4.setWidth(70);
colBRJF5.setText("缴费形式");
colBRJF5.setWidth(70);
String zyh1 = new String();
zyh1 = txtZYH.getText();
// System.out.println(zyh1);
db.gettblBrjf(zyh1);
try{
// colBRJF1.setText(db.rst.getString("JFRQ"));
while(db.rt.next()){
// System.out.println(db.rt.getString("JFRQ"));
String[] items1=new String[5];
items1[3]=db.rt.getString("ZYH");
items1[0]=db.rt.getString("JFRQ");
items1[4]=db.rt.getString("JFXS");
items1[1]=db.rt.getString("SFY");
items1[2]=db.rt.getString("JE");
TableItem item2 = new TableItem(tblBRFY,SWT.NONE);
item2.setText(items1);
}
}
catch(SQLException ev){
System.out.println(ev.getMessage());
ev.printStackTrace();
}
}
});
}
private void createbutton(){
GridData gridData0 = new GridData(GridData.HORIZONTAL_ALIGN_END);
btnBC = new Button(shell,SWT.None);
btnBC.setLayoutData(gridData0);
btnBC.setText("保存");
btnBC.setEnabled(false);
btnBC.addSelectionListener(new SelectionAdapter()
{
public void widgetSelected(SelectionEvent e)
{
save();
}
});
GridData gridData1 = new GridData(GridData.HORIZONTAL_ALIGN_CENTER);
btnFQ = new Button(shell,SWT.None);
btnFQ.setLayoutData(gridData1);
btnFQ.setText("放弃");
btnFQ.setEnabled(false);
btnFQ.addSelectionListener(new SelectionAdapter()
{
public void widgetSelected(SelectionEvent e)
{
txtZYH.setText("");
txtBRXM.setText("");
txtZYKS.setText("");
txtBCH.setText("");
txtRYRQ.setText("");
txtJFHJ.setText("");
txtFYHJ.setText("");
txtYT.setText("");
txtTXJ.setText("");
txtTZP.setText("");
btnBRFY.setSelection(true);
btnCY.setSelection(true);
// dispose1();
// dispose2();
dispose();
colBuild1();
btnBC.setEnabled(false);
btnFQ.setEnabled(false);
}
});
btnFH = new Button(shell,SWT.None);
btnFH.setText("返回");
btnFH.addSelectionListener(new SelectionAdapter()
{
public void widgetSelected(SelectionEvent e)
{
//返回到主界面
shell.getDisplay().dispose();
shell.dispose();
FrmMenu menu=new FrmMenu();
menu.main();
}
});
}
public void save(){
MessageBox messageBox = new MessageBox(shell, SWT.ICON_QUESTION |SWT.YES |SWT.NO);
messageBox.setMessage("是否保存数据？");
int ms= messageBox.open();
switch (ms)
{
case SWT.YES:
if(txtJFHJ.getText()==txtFYHJ.getText())
{
db.update1(txtZYH.getText(),lblDQSJ.getText());
db.update2(txtZYH.getText(),lblDQSJ.getText());
db.update3(txtZYH.getText(),lblDQSJ.getText());
}
else if(btnCY.getSelection()==true)
{
if(txtTXJ.getText().equals("")==false&&txtTZP.getText().equals("")==true)
{
db.insert(txtZYH.getText(),lblDQSJ.getText(),"现金",txtSFY.getText(),txtYT.getText());
}
else if (txtTZP.getText().equals("")==false&&txtTXJ.getText().equals("")==true)
{
db.insert(txtZYH.getText(),lblDQSJ.getText(),"支票",txtSFY.getText(),txtYT.getText());
}
else if(txtTZP.getText().equals("")==false&&txtTXJ.getText().equals("")==false)
{
db.insert(txtZYH.getText(),lblDQSJ.getText(),"现金",txtSFY.getText(),txtTXJ.getText());
db.insert(txtZYH.getText(),lblDQSJ.getText(),"支票",txtSFY.getText(),txtTZP.getText());
}
else System.out.println("error");
db.update1(txtZYH.getText(),lblDQSJ.getText());
db.update2(txtZYH.getText(),lblDQSJ.getText());
db.update3(txtZYH.getText(),lblDQSJ.getText());
}
else {
db.update1(txtZYH.getText(),lblDQSJ.getText());
db.update2(txtZYH.getText(),lblDQSJ.getText());
db.update3(txtZYH.getText(),lblDQSJ.getText());
if(txtTXJ.getText().equals("")==false&&txtTZP.getText().equals("")==true)
{
db.insert(txtZYH.getText(),lblDQSJ.getText(),"现金",txtSFY.getText(),txtYT.getText());
}
else if (txtTZP.getText().equals("")==false&&txtTXJ.getText().equals("")==true)
{
db.insert(txtZYH.getText(),lblDQSJ.getText(),"支票",txtSFY.getText(),txtYT.getText());
}
else if(txtTZP.getText().equals("")==false&&txtTXJ.getText().equals("")==false)
{
db.insert(txtZYH.getText(),lblDQSJ.getText(),"现金",txtSFY.getText(),txtTXJ.getText());
db.insert(txtZYH.getText(),lblDQSJ.getText(),"支票",txtSFY.getText(),txtTZP.getText());
}
else System.out.println("error");
}
MessageBox messageBox1 = new MessageBox(shell, SWT.YES );
messageBox1.setMessage("保存数据成功");
messageBox1.open();
txtZYH.setText("");
txtBRXM.setText("");
txtZYKS.setText("");
txtBCH.setText("");
txtRYRQ.setText("");
txtJFHJ.setText("");
txtFYHJ.setText("");
txtYT.setText("");
txtTXJ.setText("");
txtTZP.setText("");
btnBRFY.setSelection(true);
btnCY.setSelection(true);
// dispose1();
// dispose2();
dispose();
colBuild1();
btnBC.setEnabled(false);
btnFQ.setEnabled(false);
break;
case SWT.NO:
txtZYH.setText("");
txtBRXM.setText("");
txtZYKS.setText("");
txtBCH.setText("");
txtRYRQ.setText("");
txtJFHJ.setText("");
txtFYHJ.setText("");
txtYT.setText("");
txtTXJ.setText("");
txtTZP.setText("");
btnBRFY.setSelection(true);
btnCY.setSelection(true);
// dispose1();
// dispose2();
dispose();
colBuild1();
btnBC.setEnabled(false);
btnFQ.setEnabled(false);
break;
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -