?? mainfrm.java~673~
字號(hào):
btnhuiyuan.setEnabled(false);
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("當(dāng)前登陸用戶：倉(cāng)庫(kù)管理員");
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);
jMenuItem6.setEnabled(false);
break;
case 3: //系統(tǒng)管理員權(quán)限
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("當(dāng)前登陸用戶：系統(tǒng)管理員");
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);
jMenuItem6.setEnabled(true);
break;
}
}
public void zhuxiao() { //注銷(xiāo)
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);
jMenuItem6.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, "確認(rèn)退出?", "確認(rèn)",
JOptionPane.YES_NO_OPTION)) == 0) {
System.exit(0); //確認(rèn)退出
}
}
public void updateTree(Object kind, String name, int pvi) { //對(duì)樹(shù)進(jìn)行更新
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(j);
if (child.getUserObject().equals(name)) {
child.removeFromParent();
treeIn.updateUI(); //更新樹(shù)
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(); //更新樹(shù)
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());//對(duì)樹(shù)進(jìn)行更新,重新加載樹(shù)
//treeIn.updateUI();
}
public DefaultMutableTreeNode tree() { //從庫(kù)中把商品 類別及商品加到樹(shù)上
String sql = "";
Link lk = new Link();
lk.connection();
sql = "select kindsname from kinds"; //取出所有類別名
ResultSet rs = lk.Select(sql);
DefaultMutableTreeNode root = new DefaultMutableTreeNode("進(jìn)貨管理"); //樹(shù)根節(jié)點(diǎn)
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); //將類別名添加到樹(shù)中
}
}
catch (SQLException ex) {
}
try {
rs.close();
}
catch (SQLException ex1) {
}
lk.close();
return root;
}
public void btnguanyu_actionPerformed(ActionEvent e) { //關(guān)于我們
Dialog1 dl = new Dialog1();
dl.setLocation(300, 150);
dl.setSize(400, 330);
dl.show();
dl.setModal(true);
}
public void btnhuiyuan_actionPerformed(ActionEvent e) { //會(huì)員管理
VipFrm vf = new VipFrm();
vf.setLocation(200, 150);
vf.show();
}
public void jButton2_actionPerformed(ActionEvent e) {
//清空表中數(shù)據(jù)
if (vt.size() == 0) {
return;
}
if (JOptionPane.showConfirmDialog(null, "是否清空表中數(shù)據(jù)", "提示",
JOptionPane.YES_NO_OPTION) == 0) {
// shopping = "";
vt.removeAllElements(); //清空所存商品數(shù)據(jù)
tblsp.updateUI();
}
}
public void clear() {
//清空表中數(shù)據(jù)
vt.removeAllElements();
tblsp.updateUI();
}
public void btntianjia_actionPerformed(ActionEvent e) { //將要出售的商品添加到表中
String id = txtid.getText().trim(); //獲取商品名
int num = 0; //存商品個(gè)數(shù)
String tatol = txtnumber.getText(); //將商品個(gè)數(shù)放如表中
if (id.equals("")) {
JOptionPane.showMessageDialog(null, "請(qǐng)輸入商品編號(hào)", "錯(cuò)誤",
JOptionPane.ERROR_MESSAGE);
return;
}
try {
num = Integer.parseInt(txtnumber.getText()); //獲取商品個(gè)數(shù)
}
catch (Exception ex) {
JOptionPane.showMessageDialog(null, "請(qǐng)正確填寫(xiě)商品個(gè)數(shù)", "錯(cuò)誤",
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) { //判斷庫(kù)存是否小于商品個(gè)數(shù)
JOptionPane.showMessageDialog(null, "庫(kù)存量不足,請(qǐng)聯(lián)系倉(cāng)庫(kù)管理員", "警告",
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()); //單價(jià)
v.add(tatol); //商品個(gè)數(shù)
v.add(rs.getString(6).trim()); //單位
v.add(rs.getString(7).trim()); //折扣率
v.add(rs.getString(8).trim()); //備注
vt.add(v); //添加數(shù)據(jù)
}
while (rs.next());
shopping += id + "\n";
tblsp.updateUI();
txtid.setText("");
txtnumber.setText("");
}
}
else {
JOptionPane.showMessageDialog(null, "沒(méi)有該商品,請(qǐng)確認(rèn)商品名是否正確", "錯(cuò)誤",
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(); //清除下拉框中所有的項(xiàng)
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(); //刪除表中原有數(shù)據(jù)
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()); //商品編號(hào)
v.add(rs.getString(2).trim()); //類別
v.add(rs.getString(3).trim()); //商品名
v.add(rs.getString(4).trim()); //總數(shù)
v.add(rs.getString(5).trim()); //總額
v.add(rs.getString(6).trim()); //售出時(shí)間
vr.add(v); //添加數(shù)據(jù)
}
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) { //銷(xiāo)售表中商品
if (vt.size() == 0) {
JOptionPane.showMessageDialog(null, "表中無(wú)任何數(shù)據(jù)!", "提示",
JOptionPane.INFORMATION_MESSAGE);
return;
}
String shopping = ""; //用于存所售出的商品名
String sql = ""; //用于存SQL語(yǔ)句
float vipzhek = 10; //用于存會(huì)員折扣率
float price = 0; //用于存總額
boolean fl = false; //判斷是否是會(huì)員
float mo = 0; //用于存單件商品的總額
Link lk = new Link();
lk.connection();
ResultSet rs = null;
if (chbvip.isSelected()) { //如果是會(huì)員,判斷會(huì)員等級(jí)
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, "該會(huì)員號(hào)不存在，請(qǐng)核實(shí)再查詢！", "錯(cuò)誤",
JOptionPane.ERROR_MESSAGE);
rs.close();
lk.close();
return;
}
}
catch (SQLException ex1) {
}
}
for (int i = 0; i < vt.size(); i++) {
int sum = 0; //用于剩余庫(kù)存量
float danjia = 0; //用于存單價(jià)
float zhek = 10; //用于存折扣率
int su = 0; //售出數(shù)量
Vector tmep = (Vector) vt.get(i); //把表中的每一行都存在一個(gè)數(shù)組中
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -