?? mainfrm.java~673~
字號:
//查詢原有庫存
sql = "select price,total,abate from shopping where id='" +
tmep.get(0) + "'";
rs = lk.Select(sql);
//更新庫存
try {
if (rs.next()) { //減去售出的數量
danjia = rs.getFloat(1);
su = Integer.parseInt(tmep.get(4).toString());
sum = rs.getInt(2) - su; //剩余庫存量
zhek = rs.getFloat(3); //取出折扣
// System.out.println("su=" + su + " sum=" + sum + " zhek=" + zhek);
if (fl) {
mo = vipzhek * su * danjia * zhek * 0.01f;
}
else {
mo = danjia * zhek * 0.1f * su;
}
price += mo; //累計總額
}
}
catch (NumberFormatException ex) {
System.out.println("整形數據轉換出錯！");
}
catch (SQLException ex) {
} //取得當前時間
Calendar date = Calendar.getInstance(); //獲取一個日歷
t = new Date();
String temp = t.toString().substring(11,
(t.toString().length() - 4));
temp = temp.substring(0, 8);
date.get(Calendar.MINUTE);
date.get(Calendar.SECOND);
String time = date.get(Calendar.YEAR) + "-" +
(date.get(Calendar.MONTH) + 1)
+ "-" + date.get(Calendar.DATE) + " " + temp;
sql = "update shopping set total=" + sum + " where id='" +
tmep.get(0).toString() + "'";
int count = 0;
count = lk.Update(sql); //更新庫存
if (count <= 0) {
JOptionPane.showMessageDialog(null, "更新庫存出錯了!", "錯誤",
JOptionPane.ERROR_MESSAGE);
lk.close();
return;
}
sql = "insert into sellnote values('" + tmep.get(0) + "','" +
tmep.get(1) + "','" + tmep.get(2) + "'," + tmep.get(4) +
"," + mo + ",'" + time + "')";
count = 0;
count = lk.Update(sql); //插入銷售記錄
if (count <= 0) {
JOptionPane.showMessageDialog(null, "無法更新銷售記錄!", "錯誤",
JOptionPane.ERROR_MESSAGE);
lk.close();
return;
}
shopping += "商品名：" + tmep.get(2) + "\n商品數量：" + su + "\n商品折扣率：" +
zhek +
"折\n"; //將出售信息存在一個字符串中，便于打印清單
}
System.out.println(price);
if (fl) {
sql = "update vip set integral=integral+" + (int) price +
" where cardid='" + //更新會員積分
txtvipid.getText().trim() + "'"; //每次消費增加積分
int count = 0;
count = lk.Update(sql);
if (count <= 0) {
JOptionPane.showMessageDialog(null, "會員積分出錯了!", "錯誤",
JOptionPane.ERROR_MESSAGE);
lk.close();
return;
}
lk.Update("update vip set grade=2 where integral>=1000"); //當會員積分大于等于1000分時自動提升等級
try {
if (rs.next()) {
}
}
catch (SQLException ex3) {
}
}
try {
rs.close();
}
catch (SQLException ex2) {
}
lk.close();
System.out.println(price + " " + mo);
Checkout ct = new Checkout(shopping, fl, vipzhek, price, this);
ct.setSize(450, 420);
ct.setLocation(300, 200);
ct.show();
txtvipid.setText("");
// this.clear();//清空表中的數據
}
public void txtnumber_keyPressed(KeyEvent e) { //單擊回車觸發添加
if ( (int) e.getKeyChar() == 10) {
btntianjia_actionPerformed(null);
}
}
public void txtname_keyPressed(KeyEvent e) {
if ( (int) e.getKeyChar() == 10) {
btntianjia_actionPerformed(null);
}
}
public void txtspname_keyPressed(KeyEvent e) {
if ( (int) e.getKeyChar() == 10) {
jButton1_actionPerformed(null);
}
}
public void btncan_actionPerformed(ActionEvent e) { //刪除表中的要銷售商品的記錄
int count = tblsp.getSelectedRow();
if (vt.size() == 0) {
JOptionPane.showMessageDialog(null, "表中無任何數據!", "提示",
JOptionPane.INFORMATION_MESSAGE);
return;
}
if (count < 0) {
JOptionPane.showMessageDialog(null, "請選擇要刪除的商品", "提示",
JOptionPane.INFORMATION_MESSAGE);
return;
}
String str = (String) tblsp.getValueAt(count, 1);
if (JOptionPane.showConfirmDialog(null, "確認刪除?", "確認",
JOptionPane.YES_NO_OPTION) == 0) {
vt.remove(count); //刪除表中的數據
tblsp.updateUI(); //更新表
}
}
public void jMenuItem3_actionPerformed(ActionEvent e) {
if ( (JOptionPane.showConfirmDialog(null, "確認退出?", "確認",
JOptionPane.YES_NO_OPTION)) ==
0) {
System.exit(0); //退出系統
}
}
public void jMenuItem1_actionPerformed(ActionEvent e) { //添加用戶
UserAdd ua = new UserAdd();
ua.setSize(400, 330);
ua.setLocation(300, 250);
ua.show();
}
public void jMenuItem2_actionPerformed(ActionEvent e) { //登陸窗口
LandFrm lf = new LandFrm(this);
lf.setLocation(300, 250);
lf.show();
}
public void chbvip_mouseClicked(MouseEvent e) {
if (chbvip.isSelected()) {
txtvipid.setEnabled(true);
}
else {
txtvipid.setEnabled(false);
}
}
public void jMenuItem4_actionPerformed(ActionEvent e) { //計算器
try {
Runtime.getRuntime().exec("calc"); //調用計算器
}
catch (IOException ex) {
}
}
public void jMenuItem9_actionPerformed(ActionEvent e) { //計算器
try {
Runtime.getRuntime().exec("notepad"); //調用記事本
}
catch (IOException ex) {
}
}
public void jMenuItem11_actionPerformed(ActionEvent e) { //幫助提示
Help help = new Help();
help.setSize(500, 450);
help.setLocation(300, 250);
help.show();
}
public void btnkong_actionPerformed(ActionEvent e) { //清空表中的數據
if (vr.size() == 0) {
return;
}
if (JOptionPane.showConfirmDialog(null, "是否清空表中數據", "提示",
JOptionPane.YES_NO_OPTION) == 0) {
// shopping = ""; //清空所存商品數據
vr.removeAllElements();
tbltotal.updateUI();
}
}
public void btndate_actionPerformed(ActionEvent e) { //每日統計
vr.removeAllElements();
tbltotal.updateUI(); //清空表
String name = txtspname.getText().trim();
String sql;
String day = "";
Calendar cr;
cr = Calendar.getInstance();
int year = cr.get(Calendar.YEAR);
int month = cr.get(Calendar.MONTH) + 1;
int date = cr.get(Calendar.DATE);
day = year + "-" + month + "-" + date + ""; //獲取當前日期
if (name.equals("") && cmbname.getSelectedItem().equals("商品類別")) {
sql = "select * from sellnote where times like '%" + day + "%'";
}
else if (!name.equals("") &&
cmbname.getSelectedItem().equals("商品類別")) {
sql = "select * from sellnote where times like '%" + day +
"%' and name like'%" + name + "%'";
}
else if (name.equals("") &&
!cmbname.getSelectedItem().equals("商品類別")) {
sql = "select * from sellnote where times like '%" + day +
"%' and kindsname='" +
cmbname.getSelectedItem() + "'";
}
else {
sql = "select * from sellnote where times like '%" + day +
"%' and kindsname='" +
cmbname.getSelectedItem() + "' and name like'%" + name + "%'";
}
// sql = "select * from sellnote where times like '%" + day +"%'";
// System.out.print(sql);
Link lk = new Link();
lk.connection();
ResultSet rs = lk.Select(sql);
try {
if (rs.next()) {
do {
Vector v = new Vector();
v.removeAllElements();
v.add(rs.getString(1).trim()); //商品編號
v.add(rs.getString(2).trim()); //類別
v.add(rs.getString(3).trim()); //商品名
v.add(rs.getString(4).trim()); //總數
v.add(rs.getString(5).trim()); //總額
v.add(rs.getString(6).trim()); //售出時間
vr.add(v); //添加數據
}
while (rs.next());
tbljinhuo.updateUI(); //更新表
}
else {
JOptionPane.showMessageDialog(null, "不存在紀錄", "提示",
JOptionPane.INFORMATION_MESSAGE);
}
rs.close();
lk.close();
}
catch (SQLException ex) {
}
//lk.close();
}
public void treeChanged() {
ve.removeAllElements();
//System.out.println("夠了");
tbljinhuo.updateUI();
String sql = ""; //存SQL語句
try {
DefaultMutableTreeNode node = (DefaultMutableTreeNode) treeIn.
getLastSelectedPathComponent(); //用于確定當前選定節點
String nodeInfo = node.getUserObject().toString().trim(); //用于存選定的接點名稱
if (node.isLeaf()) { //判斷是否選中商品
sql = "select * from shopping where name='" + nodeInfo + "'";
}
else { //判斷選定的類
sql = "select * from shopping where kindname='" + nodeInfo +
"'";
}
if (nodeInfo.equals("進貨管理")) { //未選中商品則進行模糊查詢
sql = "select * from shopping order by kindname";
}
}
catch (Exception ex) {
}
Link lk = new Link();
lk.connection();
//System.out.print(sql);
ResultSet rs = lk.Select(sql);
try {
if (rs.next()) {
do {
Vector v = new Vector();
v.removeAllElements();
v.add(rs.getString(1).trim()); //商品編號
v.add(rs.getString(2).trim()); //類別
v.add(rs.getString(3).trim()); //商品名
// v.add(rs.getString(4).trim()); //總數
v.add(rs.getString(5).trim()); //庫存量
v.add(rs.getString(6).trim()); //單位
v.add(rs.getString(8).trim()); //備注
ve.add(v); //添加數據
}
while (rs.next());
tbljinhuo.updateUI();
}
}
catch (SQLException ex1) {
}
lk.close();
}
public void treeIn_valueChanged(TreeSelectionEvent e) {
DefaultMutableTreeNode node = (DefaultMutableTreeNode) treeIn.
getLastSelectedPathComponent();
if (node == null) { //判斷是否選種節點
return;
}
else {
treeChanged(); //調用樹方法
}
}
public void btnquan_actionPerformed(ActionEvent e) { //進貨顯示所有
ve.removeAllElements(); //清空數組原有數據
tbljinhuo.updateUI(); //更新表
String sql = "select * from shopping order by kindname"; //存SQL語句
Link lk = new Link();
lk.connection();
System.out.print(sql);
ResultSet rs = lk.Select(sql);
try {
if (rs.next()) {
do {
Vector v = new Vector();
v.removeAllElements();
v.add(rs.getString(1).trim()); //商品編號
v.add(rs.getString(2).trim()); //類別
v.add(rs.getString(3).trim()); //商品名
// v.add(rs.getString(4).trim()); //總數
v.add(rs.getString(5).trim()); //庫存量
v.add(rs.getString(6).trim()); //單位
v.add(rs.getString(8).trim()); //備注
ve.add(v); //添加數據
}
while (rs.next());
tbljinhuo.updateUI();
}
}
catch (SQLException ex1) {
}
lk.close();
}
public void btnjinhuo_actionPerformed(ActionEvent e) { //未完成
int count = tbljinhuo.getSelectedRow();
String id = "";
String num = "";
int sum; //存輸入的庫存
if (count >= 0) { //判斷是否被選中
Calendar date = Calendar.getInstance(); //獲取一個日歷
t = new Date();
String te = t.toString().substring(11, (t.toString().length() - 4));
te = te.substring(0, 8);
date.get(Calendar.MINUTE);
date.get(Calendar.SECOND);
String time = date.get(Calendar.YEAR) + "-" +
(date.get(Calendar.MONTH) + 1)
+ "-" + date.get(Calendar.DATE) + " " + te;
Vector temp = (Vector) ve.get(count);
id = temp.get(0).toString().trim();
String sql = "select total from shopping where id='" + id + "'";
num = JOptionPane.showInputDialog(null, "請輸入需要進貨的數量");
if (num.toString().equals("")) { //判斷輸入是否為空
return;
}
try {
sum = Integer.parseInt(num);
}
catch (Exception ex) {
JOptionPane.showMessageDialog(null, "請輸入整數");
return;
}
Link lk = new Link();
lk.connection();
ResultSet rs = lk.Select(sql); //用于將現有的庫存量查詢出來
try {
if (rs.next()) {
int to = Integer.parseInt(rs.getString(1).trim());
sum += to;
sql = "update shopping set total=" + sum + " where id='" + id +
"'";
int ao = lk.Update(sql);
if (ao > 0) {
sql = "insert into jinhuo values('" + temp.get(1) + "','" +
temp.get(2) + "','" + num + "','" + time + "')";
lk.Update(sql);
JOptionPane.showMessageDialog(null, "庫存添加完成！", "成功",
JOptionPane.
INFORMATION_MESSAGE);
tbljinhuo.updateUI(); //更新表
}
else {
JOptionPane.showMessageDialog(null, "添加庫存失敗！", "錯誤",
JOptionPane.ERROR_MESSAGE);
rs.close();
lk.close();
return;
}
}
}
catch (SQLException ex1) {
}
catch (NumberFormatException ex1) {
}
try {
rs.close();
}
catch (SQLException ex2) {
}
lk.close();
}
else {
JOptionPane.showMessageDialog(null, "請在表中選擇需要進貨的商品", "提示",
JOptionPane.INFORMATION_MESSAGE);
return;
}
}
public void btncl_actionPerformed(ActionEvent e) { //清空進貨管理表中的數據
if (ve.size() == 0) {
return;
}
if (JOptionPane.showConfirmDialog(null, "確認清空？", "提示",
JOptionPane.YES_NO_OPTION) == 0) {
ve.removeAllElements(); //清空表中數據
tbljinhuo.updateUI();
}
}
public void btninto_actionPerformed(ActionEvent e) { //根據條件進貨明細表
vc.removeAllElements();
String yr = null;
String mn = null;
yr = cmbyear.getSelectedItem().toString();
mn = cmbmonth.getSelectedItem().toString();
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -