?? mainfrm.java~668~
字號:
btnguanyu.setEnabled(true);
btncancel.setEnabled(false);
btntianjia.setEnabled(false);
btnsell.setEnabled(false);
txtid.setEnabled(false);
btncan.setEnabled(false);
txtnumber.setEnabled(false);
chbvip.setEnabled(false);
btnyingye.setEnabled(false);
lblpv.setText("當前登陸用戶：倉庫管理員");
jMenuItem1.setEnabled(false);
jMenuItem2.setEnabled(true);
cmbname.setEnabled(false);
txtspname.setEnabled(false);
btntong.setEnabled(false);
btndate.setEnabled(false);
btnkong.setEnabled(false);
treeIn.setEnabled(true);
btnjinhuo.setEnabled(true);
btnquan.setEnabled(true);
btncls.setEnabled(true);
btninto.setEnabled(true);
btncl.setEnabled(true);
btnall.setEnabled(true);
cmbyear.setEnabled(true);
cmbmonth.setEnabled(true);
break;
case 3: //系統管理員權限
btnshangpin.setEnabled(true);
btnhuiyuan.setEnabled(true);
btnguanyu.setEnabled(true);
tpnjieguo.setEnabled(true);
btncancel.setEnabled(true);
btntianjia.setEnabled(true);
btnsell.setEnabled(true);
txtid.setEnabled(true);
lblpv.setText("當前登陸用戶：系統管理員");
txtnumber.setEnabled(true);
btncan.setEnabled(true);
chbvip.setEnabled(true);
btnyingye.setEnabled(true);
jMenuItem1.setEnabled(true);
jMenuItem2.setEnabled(true);
cmbname.setEnabled(true);
txtspname.setEnabled(true);
btntong.setEnabled(true);
btndate.setEnabled(true);
btnkong.setEnabled(true);
treeIn.setEnabled(true);
btnjinhuo.setEnabled(true);
btnquan.setEnabled(true);
btncls.setEnabled(true);
btninto.setEnabled(true);
btncl.setEnabled(true);
btnall.setEnabled(true);
cmbyear.setEnabled(true);
cmbmonth.setEnabled(true);
break;
}
}
public void zhuxiao() { //注銷
btnhuiyuan.setEnabled(false);
btnshangpin.setEnabled(false);
tpnjieguo.setEnabled(false);
btncancel.setEnabled(false);
btntianjia.setEnabled(false);
btnsell.setEnabled(false);
txtid.setEnabled(false);
btnyingye.setEnabled(false);
txtnumber.setEnabled(false);
btncan.setEnabled(false);
chbvip.setEnabled(false);
jMenuItem1.setEnabled(false);
jMenuItem2.setEnabled(false);
pnejinhuo.setEnabled(false);
pnetotal.setEnabled(false);
pnesell.setEnabled(false);
cmbname.setEnabled(false);
txtspname.setEnabled(false);
btntong.setEnabled(false);
btndate.setEnabled(false);
btnkong.setEnabled(false);
treeIn.setEnabled(false);
btnjinhuo.setEnabled(false);
btnquan.setEnabled(false);
btncls.setEnabled(false);
btninto.setEnabled(false);
btncl.setEnabled(false);
btnall.setEnabled(false);
cmbyear.setEnabled(false);
cmbmonth.setEnabled(false);
}
public void year() {
cmbyear.addItem("2008");
cmbyear.addItem("2009");
cmbyear.addItem("2010");
cmbyear.addItem("2011");
cmbyear.addItem("2012");
cmbyear.addItem("2013");
cmbyear.addItem("2014");
cmbyear.addItem("2015");
cmbyear.addItem("2016");
cmbmonth.addItem("1");
cmbmonth.addItem("2");
cmbmonth.addItem("3");
cmbmonth.addItem("4");
cmbmonth.addItem("5");
cmbmonth.addItem("6");
cmbmonth.addItem("7");
cmbmonth.addItem("8");
cmbmonth.addItem("9");
cmbmonth.addItem("10");
cmbmonth.addItem("11");
cmbmonth.addItem("12");
}
public void btnexit_actionPerformed(ActionEvent e) { //退出
if ( (JOptionPane.showConfirmDialog(null, "確認退出?", "確認",
JOptionPane.YES_NO_OPTION)) == 0) {
System.exit(0); //確認退出
}
}
public void updateTree(Object kind, String name, int pvi) { //對樹進行更新
switch (pvi) {
case 1: //增加
DefaultMutableTreeNode root1 = (DefaultMutableTreeNode) treeIn.getModel().
getRoot();
for (int i = 0; i < root1.getChildCount(); i++) {
DefaultMutableTreeNode node = (DefaultMutableTreeNode) root1.
getChildAt(i);
if (node.getUserObject().equals(kind)) {
node.add(new DefaultMutableTreeNode(name));
treeIn.updateUI();
break;
}
}
break;
case 2: //刪除
DefaultMutableTreeNode root2 = (DefaultMutableTreeNode) treeIn.getModel().
getRoot();
for (int i = 0; i < root2.getChildCount(); i++) {
DefaultMutableTreeNode node = (DefaultMutableTreeNode) root2.
getChildAt(i);
if (node.getUserObject().equals(kind)) {
for (int j = 0; j < node.getChildCount(); j++) {
DefaultMutableTreeNode child = (DefaultMutableTreeNode) node.
getChildAt(i);
if (child.getUserObject().equals(name)) {
child.removeFromParent();
treeIn.updateUI(); //更新樹
tbljinhuo.updateUI();
break;
}
}
break;
}
}
break;
case 3: //更改
DefaultMutableTreeNode root3 = (DefaultMutableTreeNode) treeIn.getModel().
getRoot();
for (int i = 0; i < root3.getChildCount(); i++) {
DefaultMutableTreeNode node = (DefaultMutableTreeNode) root3.
getChildAt(i);
if (node.getUserObject().equals(kind)) {
for (int j = 0; j < node.getChildCount(); j++) {
DefaultMutableTreeNode child = (DefaultMutableTreeNode) node.
getChildAt(i);
if (!child.getUserObject().equals(name)) {
node.insert(child, j);
treeIn.updateUI(); //更新樹
tbljinhuo.updateUI();
break;
}
}
break;
}
}
}
}
public void treeupdate() {
}
public void btnshangpin_actionPerformed(ActionEvent e) { //商品查詢
Select obj = new Select(this);
// Select obj = new Select();
obj.setLocation(200, 150);
obj.show();
//treeIn.remove(root);
// treeIn = new JTree(tree());//對樹進行更新,重新加載樹
//treeIn.updateUI();
}
public DefaultMutableTreeNode tree() { //從庫中把商品 類別及商品加到樹上
String sql = "";
Link lk = new Link();
lk.connection();
sql = "select kindsname from kinds"; //取出所有類別名
ResultSet rs = lk.Select(sql);
DefaultMutableTreeNode root = new DefaultMutableTreeNode("進貨管理"); //樹根節點
try {
while (rs.next()) {
String str = rs.getString(1).trim();
DefaultMutableTreeNode node1 = new DefaultMutableTreeNode(str);
String sql1 = "select name from shopping where kindname='" +
str + "'";
//System.out.println(sql1);
Link ln = new Link();
ln.connection();
ResultSet rt = ln.Select(sql1);
while (rt.next()) {
DefaultMutableTreeNode node2 = new DefaultMutableTreeNode(rt.
getString(1));
node1.add(node2);
}
rt.close();
ln.close();
root.add(node1); //將類別名添加到樹中
}
}
catch (SQLException ex) {
}
try {
rs.close();
}
catch (SQLException ex1) {
}
lk.close();
return root;
}
public void btnguanyu_actionPerformed(ActionEvent e) { //關于我們
Dialog1 dl = new Dialog1();
dl.setLocation(300, 150);
dl.setSize(400, 330);
dl.show();
dl.setModal(true);
}
public void btnhuiyuan_actionPerformed(ActionEvent e) { //會員管理
VipFrm vf = new VipFrm();
vf.setLocation(200, 150);
vf.show();
}
public void jButton2_actionPerformed(ActionEvent e) {
//清空表中數據
if (vt.size() == 0) {
return;
}
if (JOptionPane.showConfirmDialog(null, "是否清空表中數據", "提示",
JOptionPane.YES_NO_OPTION) == 0) {
// shopping = "";
vt.removeAllElements(); //清空所存商品數據
tblsp.updateUI();
}
}
public void clear() {
//清空表中數據
vt.removeAllElements();
tblsp.updateUI();
}
public void btntianjia_actionPerformed(ActionEvent e) { //將要出售的商品添加到表中
String id = txtid.getText().trim(); //獲取商品名
int num = 0; //存商品個數
String tatol = txtnumber.getText(); //將商品個數放如表中
if (id.equals("")) {
JOptionPane.showMessageDialog(null, "請輸入商品編號", "錯誤",
JOptionPane.ERROR_MESSAGE);
return;
}
try {
num = Integer.parseInt(txtnumber.getText()); //獲取商品個數
}
catch (Exception ex) {
JOptionPane.showMessageDialog(null, "請正確填寫商品個數", "錯誤",
JOptionPane.ERROR_MESSAGE);
return;
}
String sql = "select * from shopping where id='" + id + "'";
Link lk = new Link();
lk.connection();
ResultSet rs = lk.Select(sql);
try {
if (rs.next()) {
int geshu = Integer.parseInt(rs.getString(5));
if (geshu < num) { //判斷庫存是否小于商品個數
JOptionPane.showMessageDialog(null, "庫存量不足,請聯系倉庫管理員", "警告",
JOptionPane.INFORMATION_MESSAGE);
}
else {
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(tatol); //商品個數
v.add(rs.getString(6).trim()); //單位
v.add(rs.getString(7).trim()); //折扣率
v.add(rs.getString(8).trim()); //備注
vt.add(v); //添加數據
}
while (rs.next());
shopping += id + "\n";
tblsp.updateUI();
txtid.setText("");
txtnumber.setText("");
}
}
else {
JOptionPane.showMessageDialog(null, "沒有該商品,請確認商品名是否正確", "錯誤",
JOptionPane.ERROR_MESSAGE);
}
}
catch (SQLException ex1) {
}
lk.close();
txtnumber.setText("1");
}
public void disleibei() { //顯示
Link obj = new Link();
obj.connection();
String sql = "select kindsname from kinds";
ResultSet rs = obj.Select(sql);
cmbname.removeAllItems(); //清除下拉框中所有的項
cmbname.addItem("商品類別");
try {
while (rs.next()) {
cmbname.addItem(rs.getString(1));
}
rs.close();
obj.close();
}
catch (SQLException ex) {
}
}
public void jButton1_actionPerformed(ActionEvent e) {
vr.removeAllElements(); //刪除表中原有數據
String name = txtspname.getText().trim();
String sql = ""; //
if (name.equals("") && cmbname.getSelectedItem().equals("商品類別")) {
sql = "select * from sellnote";
}
else if (!name.equals("") &&
cmbname.getSelectedItem().equals("商品類別")) {
sql = "select * from sellnote where name like'%" + name + "%'";
}
else if (name.equals("") &&
!cmbname.getSelectedItem().equals("商品類別")) {
sql = "select * from sellnote where kindsname='" +
cmbname.getSelectedItem() + "'";
}
else {
sql = "select * from sellnote where kindsname='" +
cmbname.getSelectedItem() + "' and name like'%" + name + "%'";
}
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());
tbltotal.updateUI();
}
else {
JOptionPane.showMessageDialog(null, "不存在該商品記錄", "",
JOptionPane.INFORMATION_MESSAGE);
}
}
catch (SQLException ex1) {
}
try {
rs.close();
}
catch (SQLException ex) {
}
lk.close();
}
public void btnsell_actionPerformed(ActionEvent e) { //銷售表中商品
if (vt.size() == 0) {
JOptionPane.showMessageDialog(null, "表中無任何數據!", "提示",
JOptionPane.INFORMATION_MESSAGE);
return;
}
String shopping = ""; //用于存所售出的商品名
String sql = ""; //用于存SQL語句
float vipzhek = 10; //用于存會員折扣率
float price = 0; //用于存總額
boolean fl = false; //判斷是否是會員
float mo = 0; //用于存單件商品的總額
Link lk = new Link();
lk.connection();
ResultSet rs = null;
if (chbvip.isSelected()) { //如果是會員,判斷會員等級
rs = lk.Select("select grade from vip where cardid='" +
txtvipid.getText().trim() + "'");
try {
if (rs.next()) {
fl = true;
if (rs.getInt(1) == 1) {
vipzhek = 9.5f;
}
else {
vipzhek = 9.0f;
}
}
else {
JOptionPane.showMessageDialog(null, "該會員號不存在，請核實再查詢！", "錯誤",
JOptionPane.ERROR_MESSAGE);
rs.close();
lk.close();
return;
}
}
catch (SQLException ex1) {
}
}
for (int i = 0; i < vt.size(); i++) {
int sum = 0; //用于剩余庫存量
float danjia = 0; //用于存單價
float zhek = 10; //用于存折扣率
int su = 0; //售出數量
Vector tmep = (Vector) vt.get(i); //把表中的每一行都存在一個數組中
//查詢原有庫存
sql = "select price,total,abate from shopping where id='" +
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -