【正文】 unction change() {var str。 str = 。 = str。closeDiv()。}div align=center div id=Layer1 table width=400 border=0 cellpadding=0 cellspacing=0 id=table1 %for(int i=0。i()。i=i+5) { try { gb1 = (i)。 % tr %if(gb1 != null){ % tda id=%=() % onclick=change()。%=() %/a/td %}if(gb2 != null){ % tda id=%=() % onclick=change()。%=() %/a/td %}if(gb3 != null){ % tda id=%=() % onclick=change()。%=() %/a/td %}if(gb4 != null){ % tda id=%=() % onclick=change()。%=() %/a/td %}if(gb5 != null){ % tda id=%=() % onclick=change()。%=() %/a/td %} % /tr % } % tr td colspan=5 align=center valign=middle input type=button value=關(guān)閉 onClick=closeDiv()。 //td /tr/table/div出庫時更新貨物庫存業(yè)務邏輯代碼：public boolean putout(GoodsBean gb , WareBean wb , AreaBean ab , SpaceBean sb , int number) {boolean b = false。try {conn = new ConnectionProcess().getConn()。String sql = update stock set number = number + number 39+ where goodsid = + () + and wareid = + ()+ and areaid = + ()+ and spaceid = + ()。pstmt = (sql)。int i = ()。if(i 0) {b = true。}} catch (SQLException e) {()。} finally {()。}return b。}添加移庫記錄業(yè)務邏輯代碼：public boolean addTransfer(TransferBean tb) {boolean b = false。try {conn = new ConnectionProcess().getConn()。SimpleDateFormat sdf = new SimpleDateFormat(yyyyMMdd HH:mm:ss)。String transfertime = (())。String sql = insert into transfer(goodsid,username,number,transtime, + inputware,inputarea,inputspace,outputware,outputarea,outputspace) values( + ().getGoodsid() + ,39。 + ().getUsername() + 39。, + () + ,39。 + transfertime + 39。, + ().getWareid() + , + ().getAreaid() + ,+ ().getSpaceid() + ,+ ().getWareid() + ,+ ().getAreaid() + ,+ ().getSpaceid() + )。pstmt = (sql)。int i = ()。if(i 0) {b = true。}} catch (SQLException e) {()。} finally {()。}return b。}庫存盤點業(yè)務邏輯代碼：public boolean update(int goodsid, int wareid, int areaid, int spaceid, int number) {boolean b = false。try {conn = new ConnectionProcess().getConn()。String sql = update stock set number = + number + where goodsid = + goodsid + and wareid = + wareid 40 + and areaid = + areaid + and spaceid = + spaceid。pstmt = (sql)。int i = ()。if(i 0) {b =true。}} catch (SQLException e) {()。} finally {()。}return b。}庫存統(tǒng)計功能代碼：public int count(GoodsBean gb, WareBean ware, AreaBean area, SpaceBean space) {int count = 0。String str = 。String str1 = 。String str2 = 。String str3 = 。String str4 = 。if(() != 0) {str1 = goodsid = + ()。} else {str1 = 1=1 。}if(() != 0) {str2 = and wareid = + ()。} else {str2 = and 1=1 。}if(() != 0) {str3 = and areaid = + ()。} else {str3 = and 1=1 。}if(() != 0) {str4 = and spaceid = + ()。} else {str4 = and 1=1 。}str = str1 + str2 + str3 + str4。try {conn = new ConnectionProcess().getConn()。String sql = select sum(number) from stock where + str。pstmt = (sql)。rs = ()。if(()) {count = (1)。}} catch (SQLException e) {()。} finally {()。}return count。}出入庫統(tǒng)計功能，按時間統(tǒng)計代碼： 41public ArrayListInventoryBean getInventorys(String type, String starttime , String endtime, int pageNo, int pageSize) {ArrayListInventoryBean al = new ArrayListInventoryBean()。int rowCount = 0。try {conn = new ConnectionProcess().getConn()。String sql = select count(*) from inventory where type=39。 + type + 39。 and modifytime between 39。+ starttime + 39。 and 39。 + endtime + 39。 。pstmt = (sql)。rs = ()。if(()) {rowCount = (1)。}if(rowCount% pageSize == 0) {pageCount = rowCount/pageSize。} else {pageCount = rowCount/pageSize + 1。}String sql1 = select top + pageSize + * from inventory where type=39。 + type + 39。 and modifytime between 39。+ starttime + 39。 and 39。 + endtime + 39。 and inventoryid not in(select top + (pageNo1)*pageSize+ inventoryid from inventory) order by inventoryid desc。pstmt = (sql1)。rs = ()。while(()) {InventoryBean ib = new InventoryBean()。((1))。int goodsid = (2)。GoodsBean good = new GoodsProcess().getGood(goodsid)。(good)。int wareid = (3)。WareBean wb = new WareProcess().getWare(wareid)。(wb)。int areaid = (4)。AreaBean ab = new AreaProcess().getArea(areaid)。(ab)。int spaceid = (5)。SpaceBean sb = new SpaceProcess().getSpace(spaceid)。(sb)。String username = (6)。UserBean ub = new UserProcess().getUser(username)。(ub)。((7))。((8))。((9))。((10))。(ib)。}} catch (SQLException e) {()。} finally {()。}return al。}出入庫統(tǒng)計功能，按操作員統(tǒng)計代碼：public ArrayListInventoryBean getInventorys(String type, String username,int pageNo, int pageSize) { 42ArrayListInventoryBean al = new ArrayListInventoryBean()。int rowCount = 0。try {conn = new ConnectionProcess().getConn()。String sql = select count(*) from inventory where type=39。 + type + 39。 and username like 39。%+ username + %39。 。pstmt = (sql)。rs = ()。if(()) {rowCount = (1)。}if(rowCount% pageSize == 0) {pageCount = rowCount/pageSize。} else {pageCount = rowCount/pageSize + 1。}String sql1 = select top + pageSize + * from inventory where type=39。 + type + 39。 and username like 39。%+ username+ %39。 and inventoryid not in(select top + (pageNo1)*pageSize+ inventoryid from inventory) order by inventoryid desc。pstmt = (sql1)。rs = ()。while(()) {InventoryBean ib = new InventoryBean()。((1))。int goodsid = (2)。GoodsBean good = new GoodsProcess().getGood(goodsid)。(good)。int wareid = (3)。WareBean wb = new WareProcess().getWare(wareid)。(wb)。int areaid = (4)。AreaBean ab = new AreaProcess().getArea(areaid)。(ab)。int spaceid = (5)。SpaceBean sb =)。(sb)。String uname = (6)。Us