📄 transact.java
字号:
DataList dataList = null;
try
{
super.sCond = String.valueOf(String.valueOf((new StringBuffer("SWLB='")).append(SWLB).append("' AND BLXXID=").append(iXXID).append(" AND XXBM='").append(sXXBM).append("'")));
super.stmt = super.conn.createStatement();
dataList = new DataList(super.stmt);
super.rs = dataList.getResultSet("LC_BL", "BLZT", 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 String getStateName(int iState)
{
String temp = "";
switch(iState)
{
case 0: // '\0'
temp = "\u8349\u7A3F";
break;
case 1: // '\001'
temp = "\u529E\u7406\u4E2D";
break;
case 2: // '\002'
temp = "\u529E\u7ED3";
break;
case 3: // '\003'
temp = "\u5426\u51B3";
break;
}
return temp;
}
public String getPersonStateName(int iState)
{
String temp = "";
switch(iState)
{
case 0: // '\0'
temp = "\u672A\u529E";
break;
case 1: // '\001'
temp = "\u5DF2\u529E";
break;
case 2: // '\002'
temp = "\u9000\u56DE";
break;
case 3: // '\003'
temp = "\u5426\u51B3";
break;
case 4: // '\004'
temp = "\u4ED6\u529E";
break;
case 5: // '\005'
temp = "\u529E\u7ED3";
break;
}
return temp;
}
public Object getInfor(int iBLID)
{
try
{
super.sSQL = String.valueOf(String.valueOf((new StringBuffer("select BLID,BLXXID,BLRY,BLRYXM,BLKS,BLQX,BLJS,BLLX,BLSM,BLGRZT,BLZT,BLFZ,BLQQ,BLYJ,SWLB,XXBM,BLLCID,BLJDID,BLSYRS,BLZRS,ISDRAFT,BLYD from LC_BL where BLID=")).append(iBLID)));
super.stmt = super.conn.createStatement();
super.rs = super.stmt.executeQuery(super.sSQL);
if(super.rs.next())
{
transactinfor = new TransactInfor();
super.intKey = super.rs.getInt(1);
transactinfor.setBLID(super.intKey);
transactinfor.setBLXXID(super.rs.getInt(2));
transactinfor.setBLRY(super.rs.getInt(3));
transactinfor.setBLRYXM(Convert.toUnicode(super.rs.getString(4)));
transactinfor.setBLKS(Convert.toUnicode(super.rs.getString(5)));
transactinfor.setBLQX(super.rs.getInt(6));
transactinfor.setBLJS(Convert.toUnicode(super.rs.getString(7)));
transactinfor.setBLLX(Convert.toUnicode(super.rs.getString(8)));
transactinfor.setBLSM(Convert.toUnicode(super.rs.getString(9)));
transactinfor.setBLGRZT(super.rs.getInt(10));
transactinfor.setBLZT(super.rs.getInt(11));
transactinfor.setBLFZ(Convert.toUnicode(super.rs.getString(12)));
transactinfor.setBLQQ(super.rs.getInt(13));
transactinfor.setBLYJ(Convert.toUnicode(super.rs.getString(14)));
transactinfor.setSWLB(Convert.toUnicode(super.rs.getString(15)));
transactinfor.setXXBM(Convert.toUnicode(super.rs.getString(16)));
transactinfor.setBLLCID(super.rs.getInt(17));
transactinfor.setBLJDID(super.rs.getInt(18));
transactinfor.setBLSYRS(super.rs.getInt(19));
transactinfor.setBLZRS(super.rs.getInt(20));
transactinfor.setISDRAFT(super.rs.getInt(21));
transactinfor.setBLYD(super.rs.getInt(22));
}
super.rs.close();
super.stmt.close();
}
catch(Exception e)
{
System.out.println("\u9519\u8BEF\u539F\u56E0:".concat(String.valueOf(String.valueOf(e.getMessage()))));
}
return transactinfor;
}
public Collection getList(String sCondition)
{
try
{
super.sSQL = String.valueOf(String.valueOf((new StringBuffer("select BLID,BLXXID,BLRY,BLRYXM,BLKS,BLQX,BLJS,BLLX,BLSM,BLGRZT,BLZT,BLFZ,BLQQ,BLYJ,SWLB,XXBM,BLLCID,BLJDID,BLSYRS,BLZRS,ISDRAFT,BLYD from LC_BL where ")).append(sCondition)));
super.stmt = super.conn.createStatement();
super.rs = super.stmt.executeQuery(super.sSQL);
super.arrayList = new ArrayList();
for(; super.rs.next(); super.arrayList.add(transactinfor))
{
transactinfor = new TransactInfor();
super.intKey = super.rs.getInt(1);
transactinfor.setBLID(super.intKey);
transactinfor.setBLXXID(super.rs.getInt(2));
transactinfor.setBLRY(super.rs.getInt(3));
transactinfor.setBLRYXM(Convert.toUnicode(super.rs.getString(4)));
transactinfor.setBLKS(Convert.toUnicode(super.rs.getString(5)));
transactinfor.setBLQX(super.rs.getInt(6));
transactinfor.setBLJS(Convert.toUnicode(super.rs.getString(7)));
transactinfor.setBLLX(Convert.toUnicode(super.rs.getString(8)));
transactinfor.setBLSM(Convert.toUnicode(super.rs.getString(9)));
transactinfor.setBLGRZT(super.rs.getInt(10));
transactinfor.setBLZT(super.rs.getInt(11));
transactinfor.setBLFZ(Convert.toUnicode(super.rs.getString(12)));
transactinfor.setBLQQ(super.rs.getInt(13));
transactinfor.setBLYJ(Convert.toUnicode(super.rs.getString(14)));
transactinfor.setSWLB(Convert.toUnicode(super.rs.getString(15)));
transactinfor.setXXBM(Convert.toUnicode(super.rs.getString(16)));
transactinfor.setBLLCID(super.rs.getInt(17));
transactinfor.setBLJDID(super.rs.getInt(18));
transactinfor.setBLSYRS(super.rs.getInt(19));
transactinfor.setBLZRS(super.rs.getInt(20));
transactinfor.setISDRAFT(super.rs.getInt(21));
transactinfor.setBLYD(super.rs.getInt(22));
}
super.rs.close();
super.stmt.close();
}
catch(Exception e)
{
System.out.println("\u9519\u8BEF\u539F\u56E0:".concat(String.valueOf(String.valueOf(e.getMessage()))));
}
return super.arrayList;
}
public boolean isAllNodeTransact(String sSWLB, int iXXID, String sXXBM, int iBLID)
{
super.flag = false;
DataAction dataAction = null;
try
{
super.sCond = String.valueOf(String.valueOf((new StringBuffer(" BLXXID= ")).append(iXXID).append(" and SWLB='").append(sSWLB).append("' and XXBM='").append(sXXBM).append("' and BLGRZT=0 and BLID<>").append(iBLID)));
dataAction = new DataAction(super.dataConn);
super.flag = !dataAction.isExist("LC_BL", super.sCond);
}
catch(Exception exception) { }
return super.flag;
}
public void setAllNodeState(String sSWLB, int iXXID, String sXXBM)
{
DataAction dataAction = new DataAction(super.dataConn);
super.flag = false;
try
{
String departlevelinfortr = "BLZT= 2";
super.sCond = String.valueOf(String.valueOf((new StringBuffer(" BLXXID= ")).append(iXXID).append(" and SWLB='").append(sSWLB).append("' and XXBM='").append(sXXBM).append("'")));
super.flag = dataAction.update("LC_BL", departlevelinfortr, super.sCond);
}
catch(Exception exception) { }
}
public String getTransactUserID(String sSWLB, int iXXID, String sXXBM)
{
super.flag = false;
String str_YGID = "0";
try
{
super.sCond = String.valueOf(String.valueOf((new StringBuffer("BLZT=1 AND BLGRZT=0 AND BLXXID= ")).append(iXXID).append(" and SWLB='").append(sSWLB).append("' and XXBM='").append(sXXBM).append("'")));
super.sSQL = String.valueOf(String.valueOf((new StringBuffer("select BLRY from LC_BL where ")).append(super.sCond)));
super.stmt = super.conn.createStatement();
for(super.rs = super.stmt.executeQuery(super.sSQL); super.rs.next();)
str_YGID = String.valueOf(str_YGID) + String.valueOf(",".concat(String.valueOf(String.valueOf(super.rs.getInt(1)))));
}
catch(Exception exception) { }
return str_YGID;
}
public String sendPress(String sSWLB, int iXXID, String sXXBM, String sXXID_field, String sXXBT_field, String sFWLJ, UserInfor userInfor)
{
super.flag = false;
String str_YGID = "0";
try
{
super.sCond = String.valueOf(String.valueOf((new StringBuffer("BLZT=1 AND BLGRZT=0 AND BLXXID= ")).append(iXXID).append(" and SWLB='").append(sSWLB).append("' and XXBM='").append(sXXBM).append("'").append(" AND BLXXID=").append(sXXID_field)));
super.sSQL = String.valueOf(String.valueOf((new StringBuffer("select BLRY,BLRYXM,")).append(sXXBT_field).append(" from ").append("LC_BL").append(",").append(sXXBM).append(" where ").append(super.sCond)));
super.stmt = super.conn.createStatement();
super.rs = super.stmt.executeQuery(super.sSQL);
String sBLRY = "0";
String sBLRYXM = "";
String sXXBT = "";
String sContent = "";
while(super.rs.next())
{
sBLRY = String.valueOf(sBLRY) + String.valueOf(",".concat(String.valueOf(String.valueOf(super.rs.getInt(1)))));
sBLRYXM = String.valueOf(sBLRYXM) + String.valueOf(",".concat(String.valueOf(String.valueOf(Convert.uploadUnicode(super.rs.getString(2))))));
sXXBT = "[\u50AC\u529E]\u8BF7\u5C3D\u5FEB\u529E\u7406\u6807\u9898\u4E3A\uFF1A".concat(String.valueOf(String.valueOf(Convert.uploadUnicode(super.rs.getString(3)))));
}
super.rs.close();
super.stmt.close();
sContent = String.valueOf(String.valueOf((new StringBuffer("<a href=\"")).append(sFWLJ).append("\">").append("\u8FDB\u5165\u529E\u7406").append("</a>")));
SendMail sendMail = new SendMail(super.dataConn);
sendMail.simpleMail(userInfor.getYGXM(), String.valueOf(userInfor.getYGID()), sBLRYXM, sBLRY, sXXBT, sContent);
}
catch(Exception exception) { }
return str_YGID;
}
public static void main(String args[])
{
Transact transact = new Transact();
System.out.println(transact.getStateName(2));
}
public static final String strLevel = "";
public static final String strLink_list = "transact_list.jsp";
public static final String strLink_update = "transact_update.jsp";
public static final String strLink_action = "transact_control.jsp";
public static final int iModuleID = 12;
private final String sTable = "LC_BL";
private final String Field = "BLID,BLXXID,BLRY,BLRYXM,BLKS,BLQX,BLJS,BLLX,BLSM,BLGRZT,BLZT,BLFZ,BLQQ,BLYJ,SWLB,XXBM,BLLCID,BLJDID,BLSYRS,BLZRS,ISDRAFT,BLYD";
private final String sFields[] = {
"BLID", "BLXXID", "BLRY", "BLRYXM", "BLKS", "BLQX", "BLJS", "BLLX", "BLSM", "BLGRZT",
"BLZT", "BLFZ", "BLQQ", "BLYJ", "SWLB", "XXBM", "BLLCID", "BLJDID", "BLSYRS", "BLZRS",
"ISDRAFT", "BLYD"
};
private String sValues[] = {
"", "", "", "", "", "", "", "", "", "",
"", "", "", "", "", "", "", "", "", "",
"", ""
};
private TransactInfor transactinfor;
private int sFactTID;
private int sNodeID;
private int sNodeIDs;
public static final String VERSION = "Vk9B";
private static boolean flags = false;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -