📄 updateinstorerecordservlet.java
字号:
updateinstorerecorddbbean.selectMaxnum();
updateinstorerecorddbbean.insert08();
}
catch(Exception exception8)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception8.getMessage());
}
}
continue;
}
if(vector1.elementAt(i).toString().equals("1") && vector1.elementAt(i + 1).toString().equals("0"))
{
updateinstorerecorddbbean.setInstorenum(vector1.elementAt(6).toString().trim());
updateinstorerecorddbbean.setGoodsname((String)vector1.elementAt(i + 4));
updateinstorerecorddbbean.setGoodsstyle((String)vector1.elementAt(i + 5));
updateinstorerecorddbbean.setGoodsprice((String)vector1.elementAt(i + 6));
updateinstorerecorddbbean.setGoodsnum((String)vector1.elementAt(i + 7));
updateinstorerecorddbbean.setGoodsunit((String)vector1.elementAt(i + 8));
updateinstorerecorddbbean.setNote2((String)vector1.elementAt(i + 9));
updateinstorerecorddbbean.setDelflag("0");
updateinstorerecorddbbean.setTableName("instorelist");
updateinstorerecorddbbean.setInsertSQL03("INSERT INTO " + updateinstorerecorddbbean.getTableName() + " (NUMBER, INSTORENUM, GOODSNAME, GOODSSTYLE, GOODSPRICE, GOODSNUM, GOODSUNIT, NOTE, DELFLAG ) VALUES (?, ?, ?, ?, ?, ?, ?, ? ,?)");
try
{
updateinstorerecorddbbean.selectMaxnum();
updateinstorerecorddbbean.insert03();
}
catch(Exception exception9)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception9.getMessage());
}
updateinstorerecorddbbean.setTableName("store");
updateinstorerecorddbbean.setSelectSQL03(" SELECT NUMBER , BALANCE FROM " + updateinstorerecorddbbean.getTableName() + " WHERE (NAME = ? AND STYLE = ? AND DELFLAG = '0')");
updateinstorerecorddbbean.setName((String)vector1.elementAt(i + 4));
updateinstorerecorddbbean.setStyle((String)vector1.elementAt(i + 5));
try
{
updateinstorerecorddbbean.select03();
updateinstorerecorddbbean.getDataFromResult03();
}
catch(Exception exception10)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception10.getMessage());
}
if(updateinstorerecorddbbean.getStatusCode() != 8367)
{
updateinstorerecorddbbean.setTableName("store");
updateinstorerecorddbbean.setUpdateSQL07(" UPDATE " + updateinstorerecorddbbean.getTableName() + " SET BALANCE = ? WHERE (NUMBER = ? AND NAME = ? AND STYLE = ?)");
updateinstorerecorddbbean.setNumber(updateinstorerecorddbbean.vecQN2);
updateinstorerecorddbbean.setName((String)vector1.elementAt(i + 4));
updateinstorerecorddbbean.setStyle((String)vector1.elementAt(i + 5));
int l = Integer.parseInt(updateinstorerecorddbbean.vecQB2);
int l1 = Integer.parseInt((String)vector1.elementAt(i + 7));
int l2 = l + l1;
updateinstorerecorddbbean.setBanlance(String.valueOf(l2));
try
{
updateinstorerecorddbbean.update07();
}
catch(Exception exception17)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception17.getMessage());
}
} else
if(updateinstorerecorddbbean.getStatusCode() == 8367)
{
updateinstorerecorddbbean.setTableName("store");
updateinstorerecorddbbean.setInsertSQL08("INSERT INTO " + updateinstorerecorddbbean.getTableName() + " (NUMBER, NAME, STYLE, BALANCE, UNIT, FLAG ,DELFLAG ) VALUES (?, ?, ?, ?, ?, ?,?)");
updateinstorerecorddbbean.setName((String)vector1.elementAt(i + 4));
updateinstorerecorddbbean.setStyle((String)vector1.elementAt(i + 5));
updateinstorerecorddbbean.setBanlance((String)vector1.elementAt(i + 7));
updateinstorerecorddbbean.setUnit((String)vector1.elementAt(i + 8));
updateinstorerecorddbbean.setFlag("0");
updateinstorerecorddbbean.setDelflag("0");
try
{
updateinstorerecorddbbean.selectMaxnum();
updateinstorerecorddbbean.insert08();
}
catch(Exception exception11)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception11.getMessage());
}
}
continue;
}
if(!vector1.elementAt(i).toString().equals("0") || !vector1.elementAt(i + 1).toString().equals("1"))
continue;
updateinstorerecorddbbean.setNumber(vector1.elementAt(i + 2).toString().trim());
updateinstorerecorddbbean.setDelflag("0");
updateinstorerecorddbbean.setTableName("instorelist");
updateinstorerecorddbbean.setSelectSQL01(" SELECT GOODSNAME, GOODSSTYLE, GOODSNUM FROM " + updateinstorerecorddbbean.getTableName() + " WHERE( NUMBER = ? AND DELFLAG = ?)");
try
{
updateinstorerecorddbbean.select01();
updateinstorerecorddbbean.getDataFromResult01();
}
catch(Exception exception12)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception12.getMessage());
}
if(updateinstorerecorddbbean.getStatusCode() != 8353)
{
updateinstorerecorddbbean.setName(updateinstorerecorddbbean.vecQ1.toString().trim());
updateinstorerecorddbbean.setStyle(updateinstorerecorddbbean.vecQ2.toString().trim());
updateinstorerecorddbbean.setTableName("store");
updateinstorerecorddbbean.setSelectSQL02(" SELECT BALANCE FROM " + updateinstorerecorddbbean.getTableName() + " WHERE( NAME = ? AND STYLE = ? AND DELFLAG = '0')");
try
{
updateinstorerecorddbbean.select02();
updateinstorerecorddbbean.getDataFromResult02();
}
catch(Exception exception13)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception13.getMessage());
}
if(updateinstorerecorddbbean.getStatusCode() != 8357)
{
int i1 = Integer.parseInt(updateinstorerecorddbbean.vecQB1);
int i2 = Integer.parseInt(updateinstorerecorddbbean.vecQ3);
int i3 = i1 - i2;
if(i3 > 0)
{
updateinstorerecorddbbean.setName(updateinstorerecorddbbean.vecQ1.toString().trim());
updateinstorerecorddbbean.setStyle(updateinstorerecorddbbean.vecQ2.toString().trim());
updateinstorerecorddbbean.setBanlance(String.valueOf(i3));
updateinstorerecorddbbean.setTableName("store");
updateinstorerecorddbbean.setUpdateSQL05(" UPDATE " + updateinstorerecorddbbean.getTableName() + " SET BALANCE = ? WHERE ( NAME = ? AND STYLE = ? ) ");
try
{
updateinstorerecorddbbean.update05();
}
catch(Exception exception18)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception18.getMessage());
}
} else
if(i3 == 0)
{
updateinstorerecorddbbean.setName(updateinstorerecorddbbean.vecQ1.toString().trim());
updateinstorerecorddbbean.setStyle(updateinstorerecorddbbean.vecQ2.toString().trim());
updateinstorerecorddbbean.setDelflag("1");
updateinstorerecorddbbean.setTableName("store");
updateinstorerecorddbbean.setUpdateSQL06(" UPDATE " + updateinstorerecorddbbean.getTableName() + " SET DELFLAG = ? WHERE ( NAME = ? AND STYLE = ? ) ");
try
{
updateinstorerecorddbbean.update06();
}
catch(Exception exception19)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception19.getMessage());
}
} else
{
updateinstorerecorddbbean.setStatusCode(8370);
updateinstorerecorddbbean.setStatusMessage("对不起，您要修改的入库物品信息有误，请核对后再做修改！");
break;
}
} else
{
updateinstorerecorddbbean.setStatusCode(8370);
updateinstorerecorddbbean.setStatusMessage("对不起，您要修改的入库物品信息有误，请核对后再做修改！");
break;
}
} else
{
updateinstorerecorddbbean.setStatusCode(8370);
updateinstorerecorddbbean.setStatusMessage("对不起，您要修改的入库物品信息有误，请核对后再做修改！");
break;
}
updateinstorerecorddbbean.setNumber(vector1.elementAt(i + 2).toString().trim());
updateinstorerecorddbbean.setDelflag("1");
updateinstorerecorddbbean.setTableName("instorelist");
updateinstorerecorddbbean.setUpdateSQL04("UPDATE " + updateinstorerecorddbbean.getTableName() + " SET DELFLAG = ? WHERE NUMBER = ?");
updateinstorerecorddbbean.update04();
}
if(updateinstorerecorddbbean.getStatusCode() == 8370)
{
updateinstorerecorddbbean.setStatusCode(8378);
updateinstorerecorddbbean.setStatusMessage("对不起，您要修改的入库物品信息有误，请核对后再做修改！");
} else
{
updateinstorerecorddbbean.commitToDB();
updateinstorerecorddbbean.setStatusCode(8379);
updateinstorerecorddbbean.setStatusMessage("成功修改采购入库信息！");
}
}
catch(Exception exception3)
{
updateinstorerecorddbbean.rollbackFromDB();
throw exception3;
}
finally
{
updateinstorerecorddbbean.releaseConnection();
}
httpservletrequest.setAttribute("statusMessage", updateinstorerecorddbbean.getStatusMessage());
httpservletrequest.setAttribute("flag", (new Integer(updateinstorerecorddbbean.getStatusCode())).toString());
httpservletrequest.setAttribute("rbuynum", s1);
httpservletrequest.setAttribute("rbuyman", s2);
httpservletrequest.setAttribute("rinstoredate_year", s3);
httpservletrequest.setAttribute("rinstoredate_month", s4);
httpservletrequest.setAttribute("rinstoredate_day", s5);
httpservletrequest.setAttribute("currentpage", s6);
RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/finance/UpdateInStoreRecordResult.jsp");
requestdispatcher1.forward(httpservletrequest, httpservletresponse);
}
catch(Throwable throwable)
{
System.out.println(throwable.getMessage());
try
{
RequestDispatcher requestdispatcher = getServletContext().getRequestDispatcher("/common/Error.jsp");
requestdispatcher.forward(httpservletrequest, httpservletresponse);
}
catch(Exception _ex) { }
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -