📄 changebusinessdaoimpl.java
字号:
// conn.setAutoCommit(false);
stmt = conn.createStatement();
sql = " update " + TableNameUtil.GSGSJOUT_BASIS01 + " set " + fieldName + " ='" + fieldValue + "' where field001='" + SN + "'";
stmt.executeUpdate(sql);
// conn.commit();
} catch(Exception e){
throw new AppException("[ChangeBusinessDAOImpl-->>updateSubChangeInfo]: Exception " +
e.getMessage());
}
finally{
try{
this.closeStatement(stmt);
} catch(Exception e){
}
try{
this.closeConnection(conn);
} catch(Exception e){
}
}
}
/**
*方法名称：getChangeItem
*功能描述：得到变化字段项。
*参数BID：业务号
*参数PAGE：页面编码
*返回值:HashMap
*创建人：冯瑞龙
*创建时间：2003-11-3
*/
public HashMap getChangeItem(String BID,String PAGE) throws Exception{
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sql = "";
//存放变化字段名
ArrayList changeFieldList = new ArrayList();
//存放变化字段中文名
ArrayList nameList = new ArrayList();
//add (hgw 2004-03-10 17:21)
//变更项所在的页面
ArrayList pageNumber = new ArrayList();
//变更事项的不同方面修改标识
ArrayList changeItemSub = new ArrayList();
HashMap changeItem = new HashMap();
try{
//得到Connection对象
conn = Common.getConnection();
stmt = conn.createStatement();
//sql = " select field003,field004 from " + TableNameUtil.CHANGE_ITEM + " where field001='" + BID + "' and field002='" + PAGE + "'";
sql = " select SHOWPAGE,field003,field004,CHANGEITEM_SUB from " + TableNameUtil.CHANGE_ITEM + " where field001='" + BID + "' order by field003";
if(PAGE != null && !PAGE.equals("")){
sql += " and field002 = '" + PAGE + "'";
}
Debug.println("[ChangeBusinessDAOImpl-->>getChangeItem:sql]" + sql);
rs = stmt.executeQuery(sql);
while(rs.next()){
changeFieldList.add(rs.getString("field003"));
nameList.add(rs.getString("field004"));
pageNumber.add(rs.getString("SHOWPAGE"));
changeItemSub.add(rs.getString("CHANGEITEM_SUB"));
}
changeItem.put("changeFieldList",changeFieldList);
changeItem.put("nameList",nameList);
changeItem.put("pageNumber",pageNumber);
changeItem.put("changeItemSub",changeItemSub);
} catch(Exception e){
throw new AppException("[ChangeBusinessDAOImpl-->>getChangeItem]: Exception " +
e.getMessage());
} finally{
try{
this.closeResultSet(rs);
} catch(Exception e){
}
try{
this.closeStatement(stmt);
} catch(Exception e){
}
try{
this.closeConnection(conn);
} catch(Exception e){
}
return changeItem;
}
}
/**
*方法名称：getChangeItem
*功能描述：得到某业务（BID）的变化字段项。
*参数BID：业务号
*参数PAGE：页面编码
*返回值:HashMap
*创建人：
*创建时间：2003-11-3
*/
public HashMap getChangeItem(String BID) throws Exception{
return getChangeItem(BID,null);
}
/**
* <p>得到变化字段项等相关信息</p>
* @param BID
* @param PAGE
* @return HashMap ArrayList 0--changeFieldList;1--nameList;2--pageNumber;3--fieldSelect
* @throws java.lang.Exception
*/
public HashMap getChangeItemDetail(String SN,String BID,String INNERID,String PAGE) throws Exception{
HashMap changeItem = new HashMap();
//判断页面号是否为空并确定是查询但个页面的变更项还是某业务的所有变更事项
if(PAGE != null && !PAGE.equals("")){
changeItem = getChangeItem(BID,PAGE);
} else{
changeItem = getChangeItem(BID);
}
//变更项选中情况0--未选中，1--选中
ArrayList fieldSelect = new ArrayList();
ArrayList changeFieldList = (ArrayList) changeItem.get("changeFieldList");
ArrayList changeItemSub = (ArrayList) changeItem.get("changeItemSub");
try{
//需要页面控制的（外资）
//根据实际选中的变更项（gsgsjout_coding_page_using）
sqlExecProxy.openProxy();
//if(BID.startsWith("0302")){
for(int i = 0;i < changeFieldList.size();i++){
//查询变更事项选择记录表
String sql = null;
String changeItemSubStr = (String) changeItemSub.get(i);
sql = " select BID from " + TableNameUtil.GSGSJOUT_CODING_PAGE_USING;
sql += " where SN='" + SN + "'";
sql += " and BID='" + BID + "'";
sql += " and CHANGEITEM='" + (String) changeFieldList.get(i) + "'";
if(changeItemSubStr != null && !changeItemSubStr.trim().equals("")){
sql += " and CHANGEITEM_SUB = '" + (String) changeItemSub.get(i) + "'";
}
Debug.println("[ChangeBusinessDAOImpl-->>getChangeItemDetail]sql:" + sql);
sqlExecProxy.executeQuery(sql);
//判断是否选中，并为fieldSelect赋值
if(sqlExecProxy.nextRow()){
fieldSelect.add(new String("1"));
} else{
fieldSelect.add(new String("0"));
}
}
/*
} else{
//不需要页面控制的（非外资）
//根据实际变更的值确定是否选中
HashMap hmNewValue = new HashMap();
Change change = new Change();
change.setSN(SN);
change.setBID(BID);
change.setINNERID(INNERID);
hmNewValue = change.getChangeRecord_newValue();
//判断是否有变更，并为fieldSelect赋值
String fieldValue = null;
String fieldName = null;
for(int i = 0;i < changeFieldList.size();i++){
fieldName = (String) changeFieldList.get(i);
fieldValue = (String) hmNewValue.get(fieldName.substring(fieldName.indexOf("$$") + 2));
//判断是有变化值，并为fieldSelect赋值
//if(fieldValue != null && !fieldValue.equals("")){//...2004-03-23 comment
if(hmNewValue.containsKey(fieldName.substring(fieldName.indexOf("$$") + 2))){//...2004-03-23 add
fieldSelect.add(new String("1"));
} else{
fieldSelect.add(new String("0"));
}
}
}
*/
} catch(Exception e){
e.printStackTrace();
throw new Exception("[ChangeBusinessDAOImpl-->getChangeItemDetail]exception:" + e.toString());
} finally{
try{
sqlExecProxy.closeProxy();
} catch(Exception e){
Debug.println("[ChangeBusinessDAOImpl-->>getChangeItemDetail]exception:" + e.toString());
}
}
changeItem.put("fieldSelect",fieldSelect);
return changeItem;
}
/**
*方法名称：isChangePage
*功能描述：判断是否是变更页面。
*参数BID：业务号
*参数PAGE：页面编码
*返回值:无
*创建人：冯瑞龙
*创建时间：2003-11-3
*/
public boolean isChangePage(String BID,String PAGE) throws Exception{
boolean bl = false;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String sql = "";
try{
//得到Connection对象
conn = Common.getConnection();
stmt = conn.createStatement();
String sNoSelect = null;
//modify (hgw 2004-03-14 11:43)
//控制有的变更页面不需要显示变更项选择页面(ChangeItem.jsp),(当change_item.NOSELECT = "1")
//sql = "select field001 from " + TableNameUtil.CHANGE_ITEM + " where field001='" + BID + "' and field002='" + PAGE + "'";
sql = "select field001,NOSELECT from " + TableNameUtil.CHANGE_ITEM + " where field001='" + BID + "' and field002='" + PAGE + "'";
sql += " order by NOSELECT desc";
Debug.println("[ChangeBusinessDAOImpl-->>isChangePage]sql:" + sql);
rs = stmt.executeQuery(sql);
if(rs.next()){
sNoSelect = rs.getString("NOSELECT");
//判断是否不需要显示选择页面(暂用于外资)
//modify (hgw 2003-03-30 10:13)
//修改为用于所有业务
//if(BID.startsWith("0302") && sNoSelect != null && (sNoSelect.trim()).equals("1")){
if(sNoSelect != null && (sNoSelect.trim()).equals("1")){
bl = false;
} else{
bl = true;
}
}
//End modify (hgw 2004-03-14 11:43)
} catch(Exception e){
throw new Exception("[ChangeBusinessDAOImpl-->>isChangePage]exception" + e.toString());
} finally{
try{
this.closeResultSet(rs);
} catch(Exception e){
}
try{
this.closeStatement(stmt);
} catch(Exception e){
}
try{
this.closeConnection(conn);
} catch(Exception e){
}
return bl;
}
}
//判断是否开业股东成员中有存在的信息
public boolean isExistChairman(String SN,String personInfo,String tableName) throws Exception{
boolean bl = false;
String sql = "";
personInfo = ""; //2004-02-20 因错误增加词语句
StringBuffer sb = new StringBuffer();
try{
sqlExecProxy.openProxy();
sb.append("select field001 from " + tableName + " where field001='" + SN + "'");
if(personInfo != null){
//2004-02-20 更新为下面的新程序sb.append("and (field026 like '%" + personInfo + "%' or field012 like '%" + personInfo + "%')");
//sb.append("and (field026 like '%" + personInfo + "%' or field012 like '%" + personInfo + "%')");
sb.append("and (field026 like '%%' or field012 like '%%')");
}
sql = sb.toString();
Debug.println("[**********************ChangeBusinessDAOImpl-->isExistChairman]sql=" + sql);
sqlExecProxy.executeQuery(sql);
bl = sqlExecProxy.nextRow();
} catch(Exception e){
throw new Exception("[ChangeBusinessDAOImpl-->isExistChairman]Exception:" + e.toString());
} finally{
try{
sqlExecProxy.closeProxy();
} catch(Exception e){
Debug.println("[ChangeBusinessDAOImpl-->>moveChairmanToIn]exception:" + e.toString());
}
return bl;
}
}
//得到开业的法代表、负责人
public ArrayList getOldChairman(String OLDSN,String personInfo,String SUB) throws Exception{
String sql = "";
ArrayList al = new ArrayList();
personInfo = ""; //2004-02-20 因错误增加词语句
try{
sqlExecProxy.openProxy();
StringBuffer sb = new StringBuffer();
sb.append("SELECT gsgsjin_sub02.field012 ,gsgsjin_basis02.field009 from " + TableNameUtil.GSGSJIN_BASIS02 + "," +
TableNameUtil.GSGSJIN_SUB02 + " WHERE gsgsjin_basis02.field001 = gsgsjin_sub02.field001 and gsgsjin_sub02.field001='" + OLDSN +
"' and gsgsjin_sub02.field002='" + SUB + "'");
if(personInfo != null){
sb.append(" and (gsgsjin_sub02.field026 like '%" + personInfo + "%' or gsgsjin_sub02.field012 like '%" + personInfo + "%')");
}
sql = sb.toString();
Debug.println("[ChangeBusinessDAOImpl-->getOldChairman]sql=" + sql);
sqlExecProxy.executeQuery(sql);
while(sqlExecProxy.nextRow()){
HashMap hm = new HashMap();
Debug.println("[ChangeBusinessDAOImpl-->getOldChairman]field009" + PubFunc.toShow(sqlExecProxy.getFieldString("basis.field009")));
if(sqlExecProxy.getFieldString("field012") != null && !sqlExecProxy.getFieldString("field012").trim().equals("")){
hm.put("field009",sqlExecProxy.getFieldString("FIELD009"));
hm.put("field012",sqlExecProxy.getFieldString("FIELD012"));
al.add(hm);
}
}
} catch(Exception e){
throw new Exception("[ChangeBusinessDAOImpl-->getOldChairman]Exception:" + e.toString());
}
finally{
try{
sqlExecProxy.closeProxy();
} catch(Exception e){
Debug.println("[ChangeBusinessDAOImpl-->>moveChairmanToIn]exception:" + e.toString());
}
return al;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -