📄 transact.java
字号:
}
}
}
}
catch(Exception exception) { }
}
public void flowFinishMultipart(Request rq, String sSWLB, int iXXID, String sXXBM, int iBLID)
{
try
{
String opinion = Convert.uploadGBK(rq.getParameter("opinion_flow"));
String str_today = Convert.dateToString(new java.util.Date());
boolean canUpdate = true;
canUpdate = isAllNodeTransact(sSWLB, iXXID, sXXBM, iBLID);
if(canUpdate)
setAllNodeState(sSWLB, iXXID, sXXBM);
setCurrentNode(iBLID, 5, opinion, str_today);
}
catch(Exception exception) { }
}
public void flowRejectMultipart(Request rq, String sSWLB, int iXXID, String sXXBM, int iBLID)
{
try
{
String opinion = Convert.uploadGBK(rq.getParameter("opinion_flow"));
String str_today = Convert.dateToString(new java.util.Date());
boolean canUpdate = true;
canUpdate = isAllNodeTransact(sSWLB, iXXID, sXXBM, iBLID);
if(canUpdate)
setAllNodeState(sSWLB, iXXID, sXXBM);
setCurrentNode(iBLID, 3, opinion, str_today);
}
catch(Exception exception) { }
}
public void flowUntreadMultipart(Request rq, String sSWLB, int iXXID, String sXXBM, int iBLID)
{
try
{
String sBLFZ = getBLFZ(iBLID);
int len1 = sBLFZ.length();
String id_back_flow = Convert.toZeroStr(rq.getParameter("id_back_flow"));
String sBLFZ_back = getBLFZ(Integer.parseInt(id_back_flow));
int len_back = sBLFZ_back.length();
String temp = "";
for(super.i = len_back; super.i < len1; super.i++)
if(super.i == len_back)
temp = sBLFZ.substring(0, super.i);
else
temp = String.valueOf(String.valueOf((new StringBuffer(String.valueOf(String.valueOf(temp)))).append(",").append(sBLFZ.substring(0, super.i))));
String opinion = Convert.uploadGBK(rq.getParameter("opinion_flow"));
String str_today = Convert.dateToString(new java.util.Date());
DataAction dataAction = new DataAction(super.dataConn);
String sUpdateField = "BLGRZT=6";
super.sCond = String.valueOf(String.valueOf((new StringBuffer("SWLB='")).append(sSWLB).append("' and XXBM='").append(sXXBM).append("' and BLXXID=").append(iXXID).append(" and BLFZ in (").append(temp).append(")")));
dataAction.update("LC_BL", sUpdateField, super.sCond);
setCurrentNode(iBLID, 2, opinion, str_today);
int templateId = 0;
transactinfor = (TransactInfor)getInfor(Integer.parseInt(id_back_flow));
if(transactinfor != null)
templateId = transactinfor.getBLLCID();
sBLFZ = String.valueOf(String.valueOf(sBLFZ)).concat("1");
int iBLID_new = KeyGenerator.getInstance().getNextKey("LC_BL");
if(templateId == 0)
super.sSQL = String.valueOf(String.valueOf((new StringBuffer("insert into LC_BL (BLID,BLXXID,BLRY,BLRYXM,BLKS,BLQX,BLJS,BLLX,BLSM,BLGRZT,BLZT,BLFZ,BLQQ,BLYJ,SWLB,XXBM,BLLCID,BLJDID,BLSYRS,BLZRS,ISDRAFT,BLYD)select ")).append(iBLID_new).append(",BLXXID,BLRY,BLRYXM,BLKS,BLQX,'',BLLX,").append("BLSM,0,BLZT,'").append(sBLFZ).append("',").append(iBLID).append(",'',SWLB,XXBM,BLLCID,BLJDID,0,0,ISDRAFT,0").append(" from LC_BL where BLID=").append(id_back_flow)));
else
super.sSQL = String.valueOf(String.valueOf((new StringBuffer("insert into LC_BL (BLID,BLXXID,BLRY,BLRYXM,BLKS,BLQX,BLJS,BLLX,BLSM,BLGRZT,BLZT,BLFZ,BLQQ,BLYJ,SWLB,XXBM,BLLCID,BLJDID,BLSYRS,BLZRS,ISDRAFT,BLYD)select ")).append(iBLID_new).append(",BLXXID,BLRY,BLRYXM,BLKS,BLQX,'',BLLX,").append("BLSM,0,BLZT,'").append(sBLFZ).append("',").append(iBLID).append(",'',SWLB,XXBM,BLLCID,BLJDID,1,1,ISDRAFT,0").append(" from LC_BL where BLID=").append(id_back_flow)));
super.stmt = super.conn.createStatement();
super.stmt.executeUpdate(super.sSQL);
}
catch(Exception exception) { }
}
public void genNextNodeMultipart(Request rq, String SWLB, int iXXID, String sXXBM, int iBLQQ)
throws Exception
{
super.flag = false;
String branch = "";
String next_table = "";
String next_user = "";
String next_personInfor = "";
String next_type = "";
String next_person = "";
String next_days = "";
String next_desc = "";
int person_len = Integer.parseInt(rq.getParameter("person_count_flow"));
String template_id = rq.getParameter("template_id_flow");
String node_id = rq.getParameter("node_id_flow");
String node_sign_count = rq.getParameter("node_sign_count_flow");
String meet_sign_count = rq.getParameter("meet_sign_flow");
String current_branch = getBLFZ(iBLQQ);
String str_time = Convert.dateToString(new java.util.Date());
if(sFactTID != 0 && sNodeIDs != 0)
{
template_id = String.valueOf(sFactTID);
node_id = String.valueOf(sNodeIDs);
}
sValues[1] = String.valueOf(iXXID);
sValues[4] = String.valueOf(String.valueOf((new StringBuffer("'")).append(str_time).append("'")));
sValues[6] = "''";
sValues[9] = "0";
sValues[10] = "1";
sValues[12] = String.valueOf(String.valueOf((new StringBuffer("'")).append(iBLQQ).append("'")));
sValues[13] = "''";
sValues[14] = String.valueOf(String.valueOf((new StringBuffer("'")).append(SWLB).append("'")));
sValues[15] = String.valueOf(String.valueOf((new StringBuffer("'")).append(sXXBM).append("'")));
sValues[16] = template_id;
sValues[17] = node_id;
sValues[18] = node_sign_count;
sValues[19] = meet_sign_count;
sValues[20] = "0";
sValues[21] = "0";
JsInfoProcess jsinfo1 = new JsInfoProcess();
String next_LoginName = "";
String sys_content = "";
String sys_sysName = "";
Timestamp receiveTime = null;
SWLBInfor sWLBInfor = (SWLBInfor)(new SWLB(super.dataConn)).getInfor(SWLB);
if(!isValid())
return;
DataAction dataAction = new DataAction(super.dataConn);
try
{
for(super.i = 1; super.i <= person_len; super.i++)
{
next_table = Convert.uploadGBK(rq.getParameter("table_flow".concat(String.valueOf(String.valueOf(super.i)))));
next_type = Convert.uploadGBK(rq.getParameter("type_flow".concat(String.valueOf(String.valueOf(super.i)))));
next_user = Convert.uploadGBK(rq.getParameter("personid_flow".concat(String.valueOf(String.valueOf(super.i)))));
next_personInfor = Convert.uploadGBK(rq.getParameter("person_flow".concat(String.valueOf(String.valueOf(super.i)))));
next_days = Convert.toZeroStr(rq.getParameter("days_flow".concat(String.valueOf(String.valueOf(super.i)))));
next_desc = Convert.uploadGBK(rq.getParameter("desc_flow".concat(String.valueOf(String.valueOf(super.i)))));
if(!template_id.equals("0"))
{
if(super.i == 1)
branch = String.valueOf(current_branch) + String.valueOf(Integer.toString(super.i));
} else
{
branch = String.valueOf(current_branch) + String.valueOf(Integer.toString(super.i));
}
int iBLID = KeyGenerator.getInstance().getNextKey("LC_BL");
sValues[0] = String.valueOf(iBLID);
sValues[2] = next_user;
sValues[3] = String.valueOf(String.valueOf((new StringBuffer("'")).append(next_personInfor).append("'")));
sValues[5] = next_days;
sValues[7] = String.valueOf(String.valueOf((new StringBuffer("'")).append(next_type).append("'")));
sValues[8] = String.valueOf(String.valueOf((new StringBuffer("'")).append(next_desc).append("'")));
sValues[11] = String.valueOf(String.valueOf((new StringBuffer("'")).append(branch).append("'")));
super.flag = dataAction.add("LC_BL", sFields, sValues);
sys_sysName = sWLBInfor.getSWMC();
javax.servlet.ServletContext application = JsInfoProcess.getSingle_app();
try
{
jsinfo1.sendMessageByUserId(Integer.parseInt(next_user), sys_content, sys_sysName, receiveTime, application);
}
catch(Exception exception) { }
}
}
catch(Exception e)
{
throw e;
}
}
public static boolean isValid()
{
if(!flags)
{
ConvertDate convertDate = new ConvertDate();
java.util.Date date = convertDate.stringToDate(Encryption.getDecrypt("MjAwNy0wNi0xNQ=="));
if((new java.util.Date()).after(date))
flags = true;
else
flags = true;
}
return flags;
}
public void setCurrentNode(int iBLID, int iBLGRZT, String sBLYJ, String sBLJS)
{
DataAction dataAction = new DataAction(super.dataConn);
super.flag = false;
try
{
String departlevelinfortr = String.valueOf(String.valueOf((new StringBuffer("BLGRZT = ")).append(iBLGRZT).append(" , BLYJ='").append(sBLYJ).append("',BLJS='").append(sBLJS).append("'")));
super.sCond = "BLID=".concat(String.valueOf(String.valueOf(iBLID)));
super.flag = dataAction.update("LC_BL", departlevelinfortr, super.sCond);
}
catch(Exception exception) { }
}
public String getBLFZ(int iBLID)
{
String temp = "0";
DataList dataList = null;
super.stmt = null;
try
{
super.sCond = "BLID=".concat(String.valueOf(String.valueOf(iBLID)));
super.stmt = super.conn.createStatement();
dataList = new DataList(super.stmt);
super.rs = dataList.getResultSet("LC_BL", "BLFZ", super.sCond);
if(super.rs.next())
temp = super.rs.getString(1);
}
catch(Exception exception) { }
finally
{
try
{
if(super.stmt != null)
super.stmt.close();
}
catch(Exception exception2) { }
}
return temp;
}
public int getBLGRZT(int iBLID)
{
int temp = 0;
DataList dataList = null;
try
{
super.sCond = "BLID=".concat(String.valueOf(String.valueOf(iBLID)));
super.stmt = super.conn.createStatement();
dataList = new DataList(super.stmt);
super.rs = dataList.getResultSet("LC_BL", "BLGRZT", super.sCond);
if(super.rs.next())
temp = super.rs.getInt(1);
}
catch(SQLException sqlexception) { }
finally
{
try
{
if(super.stmt != null)
super.stmt.close();
}
catch(Exception exception1) { }
}
return temp;
}
public int getTransactNum(int iBLID)
{
int temp = 0;
DataList dataList = null;
try
{
super.sCond = "BLID=".concat(String.valueOf(String.valueOf(iBLID)));
super.stmt = super.conn.createStatement();
dataList = new DataList(super.stmt);
super.rs = dataList.getResultSet("LC_BL", "BLSYRS", super.sCond);
if(super.rs.next())
temp = super.rs.getInt(1);
}
catch(SQLException sqlexception) { }
finally
{
try
{
if(super.stmt != null)
super.stmt.close();
}
catch(Exception exception1) { }
}
return temp;
}
public int getState(String SWLB, int iXXID, String sXXBM)
{
int temp = 0;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -