📄 esmainmenu.java~294~
字号:
String sellid = null;
String assetid = null;
String scount = null;
Vector v_sell = new Vector();//对应销售表
Vector v_list = new Vector(); //对应明细表
Vector v_asset = new Vector();//销售小表的库存信息
JPanel jPanel1 = new JPanel();
JPanel jPanel2 = new JPanel();
JPanel jPanel3 = new JPanel();
JSplitPane jSplitPane1 = new JSplitPane();
JSplitPane jSplitPane2 = new JSplitPane();
JScrollPane jScrollPane1 = new JScrollPane();
JTree jTree1 = new JTree(root);
JMenuBar jMenuBar1 = new JMenuBar();
JMenu jMenu1 = new JMenu();
JMenu jMenu2 = new JMenu();
JMenu jMenu3 = new JMenu();
JMenu jMenu4 = new JMenu();
JMenu jMenu5 = new JMenu();
JMenu jMenu6 = new JMenu();
JMenuItem jMenuItem1 = new JMenuItem();
JMenuItem jMenuItem2 = new JMenuItem();
JMenuItem jMenuItem3 = new JMenuItem();
JMenuItem jMenuItem7 = new JMenuItem();
JMenuItem jMenuItem8 = new JMenuItem();
JMenuItem jMenuItem11 = new JMenuItem();
JMenuItem jMenuItem13 = new JMenuItem();
JMenu jMenu7 = new JMenu();
JMenuItem jMenuItem15 = new JMenuItem();
JMenuItem jMenuItem16 = new JMenuItem();
JTextField jTextField1 = new JTextField();
JTextField jTextField2 = new JTextField();
JTextField jTextField3 = new JTextField();
BorderLayout borderLayout3 = new BorderLayout();
int num = (int) Math.round(Math.random() * 9);
JPanel jPanel4 = new JPanel();
BorderLayout borderLayout2 = new BorderLayout();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
JButton jButton3 = new JButton();
JButton jButton4 = new JButton();
JButton jButton5 = new JButton();
JButton jButton6 = new JButton();
JMenuItem jMenuItem17 = new JMenuItem();
JMenuItem jMenuItem6 = new JMenuItem();
JMenu jMenu8 = new JMenu();
JMenuItem jMenuItem4 = new JMenuItem();
JMenuItem jMenuItem9 = new JMenuItem();
JMenuItem jMenuItem10 = new JMenuItem();
JMenuItem jMenuItem12 = new JMenuItem();
JMenuItem jMenuItem18 = new JMenuItem();
JMenuItem jMenuItem19 = new JMenuItem();
JMenu jMenu9 = new JMenu();
JMenuItem jMenuItem5 = new JMenuItem();
JMenuItem jMenuItem20 = new JMenuItem();
GridLayout gridLayout1 = new GridLayout();
JMenuItem jMenuItem14 = new JMenuItem();
JMenuItem jMenuItem21 = new JMenuItem();
JScrollPane jScrollPane2 = new JScrollPane();
JScrollPane jScrollPane3 = new JScrollPane();
JTable jTable1 = new JTable();
JOptionPane jp = new JOptionPane();
JPanel jPanel5 = new JPanel();
ButtonGroup buttonGroup1 = new ButtonGroup();
private String txtname;
private String txtsprice;
private String txtprice;
private String txtrofit;
JButton jButton8 = new JButton();
private Icon image;
JPanel jPanel6 = new JPanel();
JPanel jPanel7 = new JPanel();
GridLayout gridLayout2 = new GridLayout();
JPanel jPanel9 = new JPanel();
JScrollPane jScrollPane5 = new JScrollPane();
JTextField jTextField4 = new JTextField();
JButton jButton11 = new JButton();
JTable jTable3 = new JTable();
JLabel jLabel1 = new JLabel();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JLabel jLabel4 = new JLabel();
JTextField txtsell = new JTextField();
JTextField jTextField6 = new JTextField();
static JTextField txtEclient = new JTextField();
Border border1 = BorderFactory.createMatteBorder(0, 0, 1, 0, Color.yellow);
JButton jButton7 = new JButton();
JLabel jLabel5 = new JLabel();
JTextField txtdate = new JTextField();
static JTextField txtPerson = new JTextField();
JButton jButton9 = new JButton();
JLabel jLabel6 = new JLabel();
JLabel jLabel7 = new JLabel();
JLabel jLabel12 = new JLabel();
JLabel jLabel13 = new JLabel();
JTextField jTextField13 = new JTextField();
JTextField jTextField14 = new JTextField();
JLabel jLabel14 = new JLabel();
JLabel jLabel15 = new JLabel();
JButton jButton10 = new JButton();
JScrollPane jScrollPane4 = new JScrollPane();
JTable jTable2 = new JTable();
int number = -1;
int clickcount = 0;
JLabel jLabel16 = new JLabel();
JComboBox jComboBox1 = new JComboBox();
JSpinner acount = new JSpinner();
JTextField jTextField5 = new JTextField();
JTextField jTextField7 = new JTextField();
JTextField jTextField9 = new JTextField();
JButton jButton12 = new JButton();
JButton jButton13 = new JButton();
JTextField txtshow = new JTextField();
JMenuItem jMenuItem22 = new JMenuItem();
JScrollPane jScrollPane6 = new JScrollPane();
JTree jTree2 = new JTree();
JPanel jPanel8 = new JPanel();
JRadioButton jRadioButton1 = new JRadioButton();
JRadioButton jRadioButton2 = new JRadioButton();
public void run(){ //线程设置
while(true){
SimpleDateFormat sdf = new SimpleDateFormat("hh:mm:ss aaa");
jTextField3.setText(SGetDate.getDate().concat(sdf.format(new Date())));
try {
Thread.sleep(1000);
} catch (InterruptedException ex) {
ex.printStackTrace();
}
}
}
public void getTime() {
Date date = new Date();
DateFormat dft = new SimpleDateFormat("yyyy-MM-dd");
txtdate.setText(dft.format(date));
}
public void jButton6_actionPerformed(ActionEvent e) { //主面版
SMainMenu sm = new SMainMenu();
Thread thr = new Thread(sm);
thr.start();
this.dispose();
}
public void jMenuItem15_actionPerformed(ActionEvent e) { //帮助关于我们
Icon n2 = new ImageIcon("/Jewelry/logo/20.jpg");
JOptionPane.showOptionDialog(null, "程序名称：\n Jewelry\n" +
"程序设计：\n SEX小组所有成员\n" +
"简介:\n 本软件主要针对珠宝店的管理\n" +
" 欢迎大家下载使用，但下载地址不详！\n" +
" htpp:\\www.sex.jewelry\\.....\n"+
"小组成员介绍：\n 赵睿--界面及基础信息模块\n" +
" 杨凯--人员面版及代码实现模块\n" +
" 严靖--客户关系及代码实现模块\n" +
" 杨天伟--采购库存面版及代码实现模块\n" +
" 廖理军--销售面版及代码实现模块\n"+
" 联系我们：faves_007@163.com\n"+
" QQ:12153016 电话：13608090937", "SEX小组简介",
JOptionPane.DEFAULT_OPTION,
JOptionPane.INFORMATION_MESSAGE,
n2, null, null);
}
public void jMenuItem16_actionPerformed(ActionEvent e) { //退出菜单
int option = JOptionPane.showConfirmDialog(this, "真的要退出本系统吗？", "退出",
JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null);
if (option == JOptionPane.NO_OPTION) {
return;
}else{
this.dispose();
}
}
public void jButton1_actionPerformed(ActionEvent e) {//返回
SMainMenu sm = new SMainMenu();
sm.baseButton(e);
Thread thr = new Thread(sm);
thr.start();
this.dispose();
}
public void jButton2_actionPerformed(ActionEvent e) { //入库表
ASMainMenu as = new ASMainMenu();
Thread thr = new Thread(as);
thr.start();
this.dispose();
}
public void jButton4_actionPerformed(ActionEvent e) {//人员表
PMainMenu pm = new PMainMenu();
Thread thr = new Thread(pm);
thr.start();
this.dispose();
}
public void jButton5_actionPerformed(ActionEvent e) {//客户
CSMainMenu cs = new CSMainMenu();
Thread thr = new Thread(cs);
thr.start();
this.dispose();
}
public static void eclick(String ename){
txtEclient.setText(ename);
}
public void jButton7_actionPerformed(ActionEvent e) { //客户查询小键
Aclientstate acs = new Aclientstate();
acs.setSize(260,355);
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = acs.getSize();
if (frameSize.height > screenSize.height) {
frameSize.height = screenSize.height;
}
if (frameSize.width > screenSize.width) {
frameSize.width = screenSize.width;
}
acs.setLocation((screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
acs.setVisible(true);
}
public static void pclick(String ename){
txtPerson.setText(ename);
}
public void jButton9_actionPerformed(ActionEvent e) { //人员查询小键
EPerson eps = new EPerson();
eps.setSize(260,355);
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
Dimension frameSize = eps.getSize();
if (frameSize.height > screenSize.height) {
frameSize.height = screenSize.height;
}
if (frameSize.width > screenSize.width) {
frameSize.width = screenSize.width;
}
eps.setLocation((screenSize.width - frameSize.width) / 2,
(screenSize.height - frameSize.height) / 2);
eps.setVisible(true);
}
public void jTable3_mousePressed(MouseEvent e) { //点JTable3的事件
jTable3.setSelectionBackground(Color.GREEN);
int row = jTable3.getSelectedRow();
if(row >= 0){
if(e.getClickCount() == 2){ //点击填加珠宝编号
String id = jTable3.getValueAt(row,0).toString();
jTextField6.setText(id);
//应收价格
jTextField13.setText(SDBManager.getOne("select aprice from asset where aid = '"+id+"'").elementAt(0).toString());
//库存量
jTextField9.setText(SDBManager.getOne("select acount from asset where aid = '"+id+"'").elementAt(0).toString());
}
}
}
public void jButton11_actionPerformed(ActionEvent e) {//模糊查询
String str = jTextField4.getText();
jTable3.setModel(new DefaultTableModel(SDBManager.getOtherAll(str),v_asset));
}
public void notenumber(){
String rownum = SDBManager.getAll("select count(*) from sell").elementAt(0).toString();
String sumprice = SDBManager.getAll("select sum(convert(float,sprice)) from sell").elementAt(0).toString();
String sumcount = SDBManager.getAll("select sum(convert(int,scount)) from sell").elementAt(0).toString();
txtshow.setText(" 总销售记录 "+rownum+" 条 总销售金额 "+sumprice+" ￥ 总销售珠宝数量 "+sumcount+" 件");
}
public void jButton10_actionPerformed(ActionEvent e) {//增加明细按钮功能，显示明细表,同时增加销售表，并显示
clickcount++;
if(number == 1){
String sid = txtsell.getText(); //销售编号
String aid = jTextField6.getText();//珠宝编号
String snum = acount.getModel().getValue().toString();//数量
//成本价格
String acost = SDBManager.getOne("select acost from asset where aid = '"+aid+"'").elementAt(0).toString();
String cid = txtEclient.getText(); //客户编号
//折扣比列
String discut = SDBManager.getOne("select cdiscut from client where cid = '"+cid+"'").elementAt(0).toString();
//计算折扣价格
double dprice = Math.round((Double.parseDouble(acost) * (1 - Double.parseDouble(discut)))*100)/100.0;
String disprice = String.valueOf(dprice);
String result = jTextField14.getText(); //实售价格
String sql = "insert into selllist values('"+sid+"','"+snum+"','"+acost+"','"+discut+"','"+disprice+"','"+result+"')";
if(SDBManager.dbUpdate(sql)){ //填加明细表
number = -1;
sql = "select * from selllist where sid = '"+sid+"'";
jTable2.setModel(new DefaultTableModel(SDBManager.getAll(sql),v_list));//显示明细表
jTable2.setRowHeight(30);
String sdate = txtdate.getText();//销售日期
String pid = txtPerson.getText();//员工编号
String aprice = jTextField13.getText();//应收价
String smodel = jComboBox1.getSelectedItem().toString();//付款方式
sql = "insert into sell values('"+sid+"','"+aid+"','"+sdate+"','"+cid+"','"+pid+"','"+snum+"','"+smodel+"','"+aprice+"','"+result+"')";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -