家電維修配件倉庫管理系統畢業論文-資料下載頁

　　

【正文】 size)。(pn, currentpage)。(url, method!chuhuolist)。(chuhuo/)。return SUCCESS。}河北經貿大學畢業論文45// 出貨查詢public String chuhuolist10() {HttpServletRequest request = ()。String name = (name)。String leixing = (leixing)。String bianhao = (bianhao)。StringBuffer sb = new StringBuffer()。( where )。StringBuffer sb2 = new StringBuffer()。( where )。if (bianhao != null amp。amp。 !.equals(bianhao)) {( like 39。% + bianhao + %39。)。( and )。( like 39。% + bianhao + %39。)。( and )。(bianhao, bianhao)。}if (name != null amp。amp。 !.equals(name)) {( like 39。% + name + %39。)。( and )。( like 39。% + name + %39。)。( and )。河北經貿大學畢業論文46(name, name)。}if (leixing != null amp。amp。 !.equals(leixing)) {( like 39。% + leixing + %39。)。( and )。( like 39。% + leixing + %39。)。( and )。(leixing, leixing)。}HttpSession session = ()。User user = (User)(manage)。( =+()+ order by id desc )。String where = ()。( =+())。String where2 = ()。int currentpage = 1。int pagesize = 20。if ((pageNum) != null) {currentpage = ((pageNum))。pagesize = ((numPerPage))。}河北經貿大學畢業論文47int total = (where2)。(list, ((currentpage 1) * pagesize, pagesize, where))。(totalCount, total)。(ps, pagesize)。(pn, currentpage)。(url, method!chuhuolist10)。(chuhuo/)。return SUCCESS。}// 添加出貨操作public void chuhuoadd2() throws IOException {HttpServletRequest request = ()。String product = (product)。String user2 = (user2)。HttpSession session = ()。User user = (User)(manage)。Chuhuo bean = new Chuhuo()。(未確認 )。(( where id= +product))。(user)。(( where id= +user2))。(bean)。HttpServletResponse response = ()。河北經貿大學畢業論文48(utf8)。PrintWriter out = ()。((操作成功 , method!chuhuolist, chuhuolist))。()。()。}// 刪除出貨操作public void chuhuodelete() throws IOException {HttpServletRequest request = ()。HttpServletResponse response = ()。(utf8)。PrintWriter out = ()。Chuhuo bean = ( where id= + (id))。if(().equals(未確認 )){(bean)。((操作成功 , method!chuhuolist, chuhuolist))。}else{((操作失敗，該商品已經確認出貨 , method!chuhuolist, chuhuolist))。}()。()。}河北經貿大學畢業論文49，如圖所示：代碼如下：// 商品庫存列表public String kucunlist() {HttpServletRequest request = ()。String name = (name)。String leixing = (leixing)。String bianhao = (bianhao)。StringBuffer sb = new StringBuffer()。( where )。StringBuffer sb2 = new StringBuffer()。( where )。if (bianhao != null amp。amp。 !.equals(bianhao)) {( like 39。% + bianhao + %39。)。( and )。( like 39。% + bianhao + %39。)。( and )。(bianhao, bianhao)。河北經貿大學畢業論文50}if (name != null amp。amp。 !.equals(name)) {( like 39。% + name + %39。)。( and )。( like 39。% + name + %39。)。( and )。(name, name)。}if (leixing != null amp。amp。 !.equals(leixing)) {( like 39。% + leixing + %39。)。( and )。( like 39。% + leixing + %39。)。( and )。(leixing, leixing)。}( 1=1 order by id desc )。String where = ()。( 1=1 )。String where2 = ()。int currentpage = 1。河北經貿大學畢業論文51int pagesize = 20。if ((pageNum) != null) {currentpage = ((pageNum))。pagesize = ((numPerPage))。}ListKucun list = ((currentpage 1) * pagesize, pagesize, where)。StringBuffer sbsb = new StringBuffer()。int flag = 0。for(Kucun k:list){if(()20){(().getName()+數量為+()+,不足 20！，報警！ )。flag = 1。}}(sbsb, ())。(flag, flag)。int total = (where2)。(list, list)。(totalCount, total)。(ps, pagesize)。(pn, currentpage)。(url, method!kucunlist)。(kucun/)。return SUCCESS。河北經貿大學畢業論文52}，并通知倉庫保管員發放貨物，如圖所示：代碼如下：// 申請列表public String shenqinglist() {HttpServletRequest request = ()。StringBuffer sb = new StringBuffer()。( where )。StringBuffer sb2 = new StringBuffer()。( where )。HttpSession session = ()。User user = (User)(manage)。( =+()+ order by id desc )。String where = ()。( =+())。String where2 = ()。河北經貿大學畢業論文53int currentpage = 1。int pagesize = 20。if ((pageNum) != null) {currentpage = ((pageNum))。pagesize = ((numPerPage))。}int total = (where2)。(list, ((currentpage 1) * pagesize, pagesize, where))。(totalCount, total)。(ps, pagesize)。(pn, currentpage)。(url, method!shenqinglist)。(shenqing/)。return SUCCESS。}// 申請查詢public String shenqinglist10() {HttpServletRequest request = ()。String bianhao = (bianhao)。String name = (name)。String leixing = (leixing)。StringBuffer sb = new StringBuffer()。( where )。河北經貿大學畢業論文54StringBuffer sb2 = new StringBuffer()。( where )。if (bianhao != null amp。amp。 !.equals(bianhao)) {( like 39。% + bianhao + %39。)。( and )。( like 39。% + bianhao + %39。)。( and )。(bianhao, bianhao)。}if (name != null amp。amp。 !.equals(name)) {( like 39。% + name + %39。)。( and )。( like 39。% + name + %39。)。( and )。(name, name)。}if (leixing != null amp。amp。 !.equals(leixing)) {( like 39。% + leixing + %39。)。( and )。( like 39。% + leixing + %39。)。( and )。(leixing, leixing)。}HttpSession session = ()。User user = (User)(manage)。河北經貿大學畢業論文55( =+()+ order by id desc )。String where = ()。( =+())。String where2 = ()。int currentpage = 1。int pagesize = 20。if ((pageNum) != null) {currentpage = ((pageNum))。pagesize = ((numPerPage))。}int total = (where2)。(list, ((currentpage 1) * pagesize, pagesize, where))。(totalCount, total)。(ps, pagesize)。(pn, currentpage)。(url, method!shenqinglist10)。(shenqing/)。return SUCCESS。}// 確認申請public String shenqinglist3() {HttpServletRequest request = ()。StringBuffer sb = new StringBuffer()。河北經貿大學畢業論文56( where )。StringBuffer sb2 = new StringBuffer()。( where )。HttpSession session = ()。User user = (User)(manage)。( =+()+ order by j