📄 updateinstorerecordservlet.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: UpdateInStoreRecordServlet.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:
// UpdateInStoreRecordDBBean
public class UpdateInStoreRecordServlet extends ParentServlet
{
public UpdateInStoreRecordServlet()
{
}
public void performTask(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
{
try
{
UpdateInStoreRecordDBBean updateinstorerecorddbbean = new UpdateInStoreRecordDBBean();
DateTimeBean datetimebean = new DateTimeBean();
Vector vector = (Vector)getServletContext().getAttribute("Para");
updateinstorerecorddbbean.setUserID((String)vector.elementAt(0));
updateinstorerecorddbbean.setPassword((String)vector.elementAt(1));
updateinstorerecorddbbean.setURL((String)vector.elementAt(2));
updateinstorerecorddbbean.setDriver((String)vector.elementAt(3));
updateinstorerecorddbbean.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();
updateinstorerecorddbbean.setNumber(vector1.elementAt(6).toString().trim());
updateinstorerecorddbbean.setBuynum((String)vector1.elementAt(7));
updateinstorerecorddbbean.setBuyman((String)vector1.elementAt(8));
updateinstorerecorddbbean.setInstoredate(vector1.elementAt(9).toString().trim() + "-" + vector1.elementAt(10).toString().trim() + "-" + vector1.elementAt(11).toString().trim());
updateinstorerecorddbbean.setStoremanager((String)vector1.elementAt(12));
updateinstorerecorddbbean.setNote1((String)vector1.elementAt(13));
try
{
updateinstorerecorddbbean.initialize();
}
catch(Exception exception)
{
throw exception;
}
try
{
updateinstorerecorddbbean.setDelflag("0");
updateinstorerecorddbbean.setTableName("instorereceipt");
updateinstorerecorddbbean.setUpdateSQL01(" UPDATE " + updateinstorerecorddbbean.getTableName() + " SET BUYNUM = ?, BUYMAN = ?, INSTOREDATE= ?, NOTE = ?, STOREMANAGER = ? WHERE (NUMBER = ? AND DELFLAG = ?)");
try
{
updateinstorerecorddbbean.update01();
}
catch(Exception exception2)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception2.getMessage());
}
for(int i = 14; i < vector1.size(); i += 10)
{
if(vector1.elementAt(i).toString().equals("1") && vector1.elementAt(i + 1).toString().equals("1"))
{
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 exception4)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception4.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 exception5)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception5.getMessage());
}
if(updateinstorerecorddbbean.getStatusCode() != 8357)
{
int j = Integer.parseInt(updateinstorerecorddbbean.vecQB1);
int j1 = Integer.parseInt(updateinstorerecorddbbean.vecQ3);
int j2 = j - j1;
if(j2 > 0)
{
updateinstorerecorddbbean.setName(updateinstorerecorddbbean.vecQ1.toString().trim());
updateinstorerecorddbbean.setStyle(updateinstorerecorddbbean.vecQ2.toString().trim());
updateinstorerecorddbbean.setBanlance(String.valueOf(j2));
updateinstorerecorddbbean.setTableName("store");
updateinstorerecorddbbean.setUpdateSQL05(" UPDATE " + updateinstorerecorddbbean.getTableName() + " SET BALANCE = ? WHERE ( NAME = ? AND STYLE = ? ) ");
try
{
updateinstorerecorddbbean.update05();
}
catch(Exception exception14)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception14.getMessage());
}
} else
if(j2 == 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 exception15)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception15.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.setInstorenum(vector1.elementAt(i + 3).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.setUpdateSQL02(" UPDATE " + updateinstorerecorddbbean.getTableName() + " SET GOODSNAME = ?, GOODSSTYLE = ?, GOODSPRICE = ?, GOODSNUM = ?, GOODSUNIT = ?, NOTE = ? WHERE ( NUMBER = ? AND INSTORENUM = ? AND DELFLAG = ? ) ");
try
{
updateinstorerecorddbbean.update02();
}
catch(Exception exception6)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception6.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 exception7)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception7.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 k = Integer.parseInt(updateinstorerecorddbbean.vecQB2);
int k1 = Integer.parseInt((String)vector1.elementAt(i + 7));
int k2 = k + k1;
updateinstorerecorddbbean.setBanlance(String.valueOf(k2));
try
{
updateinstorerecorddbbean.update07();
}
catch(Exception exception16)
{
throw new Exception("[finance.UpdateInStoreRecordServlet][" + datetimebean.getDate() + " " + datetimebean.getTime() + "]" + exception16.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
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -