📄 market.java
字号:
JLabel l = new JLabel("请选择付款方式");
JPanel p1 = new JPanel(); //列选项
p1.setLayout(new GridLayout(12,1));
payByIn.addActionListener(mo);
payByOut.addActionListener(mo);
payBySuplyer.addActionListener(mo);
payPart.addActionListener(mo);
pp2.addActionListener(mo);
payByKind.addActionListener(mo);
p1.add(new JLabel(""));
p1.add(payByIn);p1.add(new JLabel(""));
p1.add(payByOut);p1.add(new JLabel(""));
// p1.add(payBySuplyer);p1.add(new JLabel(""));
p1.add(payPart);p1.add(new JLabel(""));
p1.add(pp2);p1.add(new JLabel(""));
p1.add(payByKind);p1.add(new JLabel(""));
JPanel p2 = new JPanel(); //显示数据
JPanel p3 = new JPanel();
p3.setLayout(new FlowLayout());
// JButton payIT = new JButton("支付");
// payIT.addActionListener(mo);
// p3.add(new JLabel(""));p3.add(payIT);
p3.add(new JLabel(""));p3.add(closePD);
closePD.addActionListener(new Monitor());
JPanel p = new JPanel(); //列选项
p.setLayout(new BorderLayout());
p.add(l,BorderLayout.NORTH);
p.add(p1,BorderLayout.WEST);
p.add(p2,BorderLayout.CENTER);
p.add(p3,BorderLayout.SOUTH);
pDiag.add(p);
pDiag.setSize(600,400);
pDiag.setLocation(300,180);
pDiag.setVisible(true);
}
public void DispPay()
{
}
/////////////////////////////////////////////////////////////////////
JTextField PA_TSNO = new JTextField();
JButton PA_SNOOK = new JButton("确定");
JLabel PA_LSNO = new JLabel("请输入预结账单据号:");
JPanel PA_PSNO = new JPanel();
JPanel PA_PSNO2 = new JPanel();
JLabel PA_LSNO2 = new JLabel("请输入结账金额:");
JTextField PA_TSNO2 = new JTextField();
JButton PA_OK = new JButton("确定");
JLabel PA_Message = new JLabel("请输入:");
boolean PA_getSNO = false;
double A = 0;
public void PA()
{
PA_getSNO = false;
PA_Message.setText("");
PA_TSNO.setText("");
PA_TSNO2.setText("");
PA_SNOOK.setEnabled(true);
pDiag = new JDialog(f,"支付",true);
pDiag.setLocation(200,200);
pDiag.setSize(600,100);
pDiag.setLayout(new GridLayout(3,1));
PA_SNOOK.addActionListener(mo);
PA_OK.addActionListener(mo);
PA_PSNO.setLayout(new GridLayout(1,3));
PA_PSNO.add(PA_LSNO);
PA_PSNO.add(PA_TSNO);
PA_PSNO.add(PA_SNOOK);
PA_PSNO2.setLayout(new GridLayout(1,3));
PA_PSNO2.add(PA_LSNO2);
PA_PSNO2.add(PA_TSNO2);
PA_PSNO2.add(PA_OK);
PA_PSNO2.setVisible(false);
pDiag.add(PA_Message);
PA_Message.setVisible(true);
pDiag.add(PA_PSNO);
pDiag.add(PA_PSNO2);
pDiag.setVisible(true);
}
public void PA1()
{
try
{
String sql = "select * from IntoL where ItemNo = '"+PA_TSNO.getText()+"'";
ResultSet RS = stmt.executeQuery(sql);
if(RS.next())
{
PA_getSNO = true;
A = RS.getDouble(5) *RS.getInt(7) - RS.getDouble(6);
}
RS.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
if(PA_getSNO)
{
PA_PSNO2.setVisible(true);
PA_SNOOK.setEnabled(false);
PA_Message.setText(" 您总共需要付: "+A);
//pDiag.setVisible(true);
}
else
{
PA_Message.setText("您输入的单号不存在!!!!!!!!");
//pDiag.setVisible(true);
}
//PA_getSNO
}
public void PA2()
{
Double pay = 0.0;
Double newLoad = 0.0;
String snoIs = "";
try
{
Double input = Double.parseDouble(PA_TSNO2.getText());
rs = stmt.executeQuery("select * from IntoL where ItemNo = '"+PA_TSNO.getText()+"'");
System.out.println("select * from IntoL where ItemNo = '"+PA_TSNO.getText()+"'");
while(rs.next())
{
pay = input + rs.getDouble("payed");
snoIs = rs.getString("sno");
}
System.out.println("pay + snoIs "+pay +" / "+snoIs );
rs2 = stmt.executeQuery("select sLoad from suplyer where sno = '"+snoIs +"'");
System.out.println("select sLoad from suplyer where sno = '"+snoIs +"'" );
if(rs2.next())
{
newLoad = rs2.getDouble("sLoad")-input;
}
System.out.println("newLoad "+newLoad );
if(input>A)
{
PA_Message.setText("您输入的数字超过最大应交款数量 操作失败!!!");
//pDiag.setVisible(true);
}
else
{
String sql = "update IntoL set payed = "+ pay +" where ItemNo = '"+PA_TSNO.getText()+"'";
System.out.println(sql);
stmt.executeUpdate(sql);
String sql2 = "update suplyer set sLoad = "+ newLoad + " where sno = '"+snoIs+"'";
System.out.println(sql2);
stmt.executeUpdate(sql2);
pDiag.setVisible(false);
outS= new JDialog(f,"",true);
outS.setLayout(new BorderLayout());
outS.add(new JLabel("-----操作成功!-----"),BorderLayout.NORTH);
// outS.add(sure4,BorderLayout.SOUTH);
// sure4.addActionListener(mo);
outS.setSize(300,180);
outS.setLocation(450,180);
outS.setResizable(false);
outS.setVisible(true);//最后写
PA_PSNO2.setEnabled(true);
//pDiag.setVisible(true);
}
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(NumberFormatException e)
{
PA_Message.setText("请输入数字");
//pDiag.setVisible(true);
}
}
JTextField A_TSNO = new JTextField();
JButton A_SNOOK = new JButton("确定");
JLabel A_LSNO = new JLabel("请输入预结账单据号:");
JPanel A_PSNO = new JPanel();
JPanel A_PSNO2 = new JPanel();
JLabel A_LSNO2 = new JLabel("请输入结账金额:");
JTextField A_TSNO2 = new JTextField();
JButton A_OK = new JButton("确定");
JLabel A_Message = new JLabel("请输入:");
boolean A_getSNO = false;
double B = 0;
public void Receive()
{
A_getSNO = false;
A_Message.setText("");
A_TSNO.setText("");
A_TSNO2.setText("");
A_SNOOK.setEnabled(true);
Diag = new JDialog(f,"收款",true);
Diag.setLocation(200,200);
Diag.setSize(600,100);
Diag.setLayout(new GridLayout(3,1));
A_SNOOK.addActionListener(mo);
A_OK.addActionListener(mo);
A_PSNO.setLayout(new GridLayout(1,3));
A_PSNO.add(A_LSNO);
A_PSNO.add(A_TSNO);
A_PSNO.add(A_SNOOK);
A_PSNO2.setLayout(new GridLayout(1,3));
A_PSNO2.add(A_LSNO2);
A_PSNO2.add(A_TSNO2);
A_PSNO2.add(A_OK);
A_PSNO2.setVisible(false);
Diag.add(A_Message);
A_Message.setVisible(true);
Diag.add(A_PSNO);
Diag.add(A_PSNO2);
Diag.setVisible(true);
}
public void Receive1()
{
String Sno = "";
Double Sl = 0.0;
try
{
String sql = "select * from OutL where outNo = '"+A_TSNO.getText()+"'";
ResultSet RS = stmt.executeQuery(sql);
if(RS.next())
{
Sno = RS.getString("gno");
A_getSNO = true;
//System.out.println(RS.getDouble(5)+" "+RS.getInt(7)+" "+RS.getDouble(6));
B = RS.getDouble(5) *RS.getInt(7) - RS.getDouble(6);
System.out.println(B);
}
RS.close();
/*rs = stmt.executeQuery("select sLoad from suplyer where sno = '"+Sno +"'");
if(rs.next())
{
Sl = rs.getDouble("sLoad");
}*/
}
catch(SQLException e)
{
e.printStackTrace();
}
/*if(A_getSNO&&B<0)
{
A_PSNO2.setVisible(true);
A_SNOOK.setEnabled(false);
A_Message.setText(" 您可以接受的总货款: "+ (-B));
}
else*/
if(A_getSNO)
{
A_PSNO2.setVisible(true);
A_SNOOK.setEnabled(false);
A_Message.setText(" 您可以接受的总货款: "+ B);
}
/*else if(A_getSNO&&Sl>0)
{
A_Message.setText(" 您对供应商"+Sno+"有欠款"+ Sl+"未还，请先还款: ");
}*/
else if(!A_getSNO)
{
A_Message.setText("您输入的单号不存在!!!!!!!!");
}
//PA_getSNO
}
public void Receive2()
{
Double pay = 0.0;
String Sno = "";
Double newLoad = 0.0;
try
{
Double input = Double.parseDouble(A_TSNO2.getText());
rs = stmt.executeQuery("select * from OutL where outNo = '"+A_TSNO.getText()+"'");
while(rs.next())
{
pay = input + rs.getDouble("payed");
Sno = rs.getString("sno");
}
rs2 = stmt.executeQuery("select sLoad from suplyer where sno = '"+Sno +"'");
System.out.println("select sLoad from suplyer where sno = '"+Sno +"'" );
if(rs2.next())
{
newLoad = rs2.getDouble("sLoad")+input;
}
Double C = 0.0;
if(B>0)
C=B;
else
C=-B;
if(input>C)
{
A_Message.setText("您输入的数字超过最大应交款数量 操作失败!!!");
//pDiag.setVisible(true);
}
else
{
String sql = "update OutL set payed = "+ pay +" where outNo = '"+A_TSNO.getText()+"'";
System.out.println(sql);
String sql2 = "update suplyer set sLoad = "+ newLoad + " where sno = '"+Sno+"'";
stmt.executeUpdate(sql);
stmt.executeUpdate(sql2);
System.out.println(sql2);
Diag.setVisible(false);
outS= new JDialog(f,"",true);
outS.setLayout(new BorderLayout());
outS.add(new JLabel("-----操作成功!-----"),BorderLayout.NORTH);
outS.setSize(300,180);
outS.setLocation(450,180);
outS.setResizable(false);
outS.setVisible(true);//最后写
A_PSNO2.setEnabled(true);
}
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(NumberFormatException e)
{
A_Message.setText("请输入数字");
//pDiag.setVisible(true);
}
}
ArrayList PP_AL = new ArrayList();
JButton payalllist = new JButton("全部交付");
JPanel cDl = new JPanel();
public void PP()
{
PP_AL.clear();
DL = new JDialog(f,"显示",true);
int num = 0;
String[] name = {"商品号","供货商名称","流水单号","时间日期","欠款数目"};
try
{
String sql = "select * from IntoL";
ResultSet RS = stmt.executeQuery(sql);
while(RS.next())
{
//PA_getSNO = true;
double All = RS.getDouble(5) *RS.getInt(7) - RS.getDouble(6);
if(All > 0)
{
num++;
PP_AL.add(RS.getString(1));
PP_AL.add(RS.getString(2));
PP_AL.add(RS.getString(3));
PP_AL⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -