📄 deleteinstorerecordservlet.java
字号:
// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi
// Source File Name: DeleteInStoreRecordServlet.java
package finance;
import common.*;
import java.io.PrintStream;
import java.util.Vector;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
// Referenced classes of package finance:
// DeleteInStoreRecordDBBean
public class DeleteInStoreRecordServlet extends ParentServlet
{
public DeleteInStoreRecordServlet()
{
}
public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
{
try
{
DeleteInStoreRecordDBBean deleteinstorerecorddbbean = new DeleteInStoreRecordDBBean();
DateTimeBean datetimebean = new DateTimeBean();
Vector vector = (Vector)getServletContext().getAttribute("Para");
deleteinstorerecorddbbean.setUserID((String)vector.elementAt(0));
deleteinstorerecorddbbean.setPassword((String)vector.elementAt(1));
deleteinstorerecorddbbean.setURL((String)vector.elementAt(2));
deleteinstorerecorddbbean.setDriver((String)vector.elementAt(3));
deleteinstorerecorddbbean.setDataSourceName((String)vector.elementAt(4));
ParseInputStringBean parseinputstringbean = new ParseInputStringBean();
String s = httpservletrequest.getParameter("inputString");
Vector vector1 = parseinputstringbean.parseCommonFormatIS(s);
String s1 = vector1.elementAt(0).toString();
String s2 = vector1.elementAt(1).toString();
String s3 = vector1.elementAt(2).toString();
String s4 = vector1.elementAt(3).toString();
String s5 = vector1.elementAt(4).toString();
String s6 = vector1.elementAt(5).toString();
String s7 = vector1.elementAt(6).toString();
String s8 = vector1.elementAt(7).toString();
int i = 0;
try
{
deleteinstorerecorddbbean.initialize();
}
catch(Exception exception)
{
throw exception;
}
try
{
try
{
for(int j = 8; j < vector1.size(); j++)
{
deleteinstorerecorddbbean.setDelflag("1");
deleteinstorerecorddbbean.setTableName("instorereceipt");
deleteinstorerecorddbbean.setUpdateSQL01(" UPDATE " + deleteinstorerecorddbbean.getTableName() + " SET DELFLAG = ? WHERE NUMBER = ? ");
deleteinstorerecorddbbean.setNumber(vector1.elementAt(j).toString().trim());
try
{
deleteinstorerecorddbbean.update01();
i++;
}
catch(Exception exception4)
{
throw new Exception("[finance.DeleteInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception4.getMessage());
}
deleteinstorerecorddbbean.setInstorenum(vector1.elementAt(j).toString().trim());
deleteinstorerecorddbbean.setDelflag("0");
deleteinstorerecorddbbean.setTableName("instorelist");
deleteinstorerecorddbbean.setSelectSQL01(" SELECT GOODSNAME, GOODSSTYLE, GOODSNUM FROM " + deleteinstorerecorddbbean.getTableName() + " WHERE( INSTORENUM = ? AND DELFLAG = ?)");
try
{
deleteinstorerecorddbbean.select01();
deleteinstorerecorddbbean.getDataFromResult01();
}
catch(Exception exception5)
{
throw new Exception("[finance.DeleteInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception5.getMessage());
}
if(deleteinstorerecorddbbean.getStatusCode() != 8386)
{
for(int k = 0; k < deleteinstorerecorddbbean.vecQ1.size(); k++)
{
deleteinstorerecorddbbean.setName(deleteinstorerecorddbbean.vecQ1.elementAt(k).toString().trim());
deleteinstorerecorddbbean.setStyle(deleteinstorerecorddbbean.vecQ2.elementAt(k).toString().trim());
deleteinstorerecorddbbean.setTableName("store");
deleteinstorerecorddbbean.setSelectSQL02(" SELECT BALANCE FROM " + deleteinstorerecorddbbean.getTableName() + " WHERE( NAME = ? AND STYLE = ? AND DELFLAG = '0')");
try
{
deleteinstorerecorddbbean.select02();
deleteinstorerecorddbbean.getDataFromResult02();
}
catch(Exception exception6)
{
throw new Exception("[finance.DeleteInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception6.getMessage());
}
if(deleteinstorerecorddbbean.getStatusCode() != 8391)
{
int l = Integer.parseInt(deleteinstorerecorddbbean.vecQB1);
int i1 = Integer.parseInt(deleteinstorerecorddbbean.vecQ3.elementAt(k).toString());
int j1 = l - i1;
if(j1 > 0)
{
deleteinstorerecorddbbean.setName(deleteinstorerecorddbbean.vecQ1.elementAt(k).toString().trim());
deleteinstorerecorddbbean.setStyle(deleteinstorerecorddbbean.vecQ2.elementAt(k).toString().trim());
deleteinstorerecorddbbean.setBanlance(String.valueOf(j1));
deleteinstorerecorddbbean.setTableName("store");
deleteinstorerecorddbbean.setUpdateSQL02(" UPDATE " + deleteinstorerecorddbbean.getTableName() + " SET BALANCE = ? WHERE ( NAME = ? AND STYLE = ? ) ");
try
{
deleteinstorerecorddbbean.update02();
}
catch(Exception exception8)
{
throw new Exception("[finance.DeleteInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception8.getMessage());
}
continue;
}
if(j1 == 0)
{
deleteinstorerecorddbbean.setName(deleteinstorerecorddbbean.vecQ1.elementAt(k).toString().trim());
deleteinstorerecorddbbean.setStyle(deleteinstorerecorddbbean.vecQ2.elementAt(k).toString().trim());
deleteinstorerecorddbbean.setDelflag("1");
deleteinstorerecorddbbean.setTableName("store");
deleteinstorerecorddbbean.setUpdateSQL04(" UPDATE " + deleteinstorerecorddbbean.getTableName() + " SET DELFLAG = ? WHERE ( NAME = ? AND STYLE = ? ) ");
try
{
deleteinstorerecorddbbean.update04();
}
catch(Exception exception9)
{
throw new Exception("[finance.DeleteInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception9.getMessage());
}
continue;
}
deleteinstorerecorddbbean.setStatusCode(8398);
} else
{
deleteinstorerecorddbbean.setStatusCode(8398);
}
break;
}
if(deleteinstorerecorddbbean.getStatusCode() == 8398)
break;
deleteinstorerecorddbbean.vecQ1.removeAllElements();
deleteinstorerecorddbbean.vecQ2.removeAllElements();
deleteinstorerecorddbbean.vecQ3.removeAllElements();
deleteinstorerecorddbbean.setDelflag("1");
deleteinstorerecorddbbean.setTableName("instorelist");
deleteinstorerecorddbbean.setUpdateSQL03(" UPDATE " + deleteinstorerecorddbbean.getTableName() + " SET DELFLAG = ? WHERE INSTORENUM = ? ");
deleteinstorerecorddbbean.setInstorenum(vector1.elementAt(j).toString().trim());
try
{
deleteinstorerecorddbbean.update03();
}
catch(Exception exception7)
{
throw new Exception("[finance.DeleteInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception7.getMessage());
}
continue;
}
if(deleteinstorerecorddbbean.getStatusCode() != 8386)
continue;
deleteinstorerecorddbbean.setStatusCode(8398);
deleteinstorerecorddbbean.setStatusMessage("对不起，您要删除的入库物品信息有误，请核对后再做删除！");
break;
}
if(deleteinstorerecorddbbean.getStatusCode() == 8398)
{
deleteinstorerecorddbbean.setStatusCode(8399);
deleteinstorerecorddbbean.setStatusMessage("对不起，您要删除的入库物品信息有误，请核对后再做删除！");
} else
{
deleteinstorerecorddbbean.setStatusCode(8390);
deleteinstorerecorddbbean.setStatusMessage("成功删除采购入库信息！");
deleteinstorerecorddbbean.commitToDB();
if(s6.equals(s8) && i == Integer.parseInt(s7))
s6 = String.valueOf(Integer.parseInt(s6) - 1);
}
}
catch(Exception exception2)
{
deleteinstorerecorddbbean.rollbackFromDB();
throw new Exception("[finance.DeleteInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception2.getMessage());
}
}
catch(Exception exception3)
{
throw exception3;
}
finally
{
deleteinstorerecorddbbean.releaseConnection();
}
httpservletrequest.setAttribute("statusMessage", deleteinstorerecorddbbean.getStatusMessage());
httpservletrequest.setAttribute("flag", (new Integer(deleteinstorerecorddbbean.getStatusCode())).toString());
httpservletrequest.setAttribute("currentpage", s6);
httpservletrequest.setAttribute("rbuynum", s1);
httpservletrequest.setAttribute("rbuyman", s2);
httpservletrequest.setAttribute("rinstoredate_year", s3);
httpservletrequest.setAttribute("rinstoredate_month", s4);
httpservletrequest.setAttribute("rinstoredate_day", s5);
RequestDispatcher requestdispatcher1 = getServletContext().getRequestDispatcher("/finance/DeleteInStoreRecordResult.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 + -