http://96.0.45.49:9082/
sitdev/sitdev
数据库
96.0.40.136
lcsdb
ecapdev
123456
重空批量调拨打印
T_Ibd_TellerStoring
describe table T_Ibd_TellerStoring
select * from T_Ibd_TellerStoring
select SourceBranch,ReceiveTeller1,DestinationBranch,ReceiveTeller2 from T_Ibd_TellerStoring where SourceBranch = '06050'
int page_num = 10;
String[] elementNames = {"HB_SourceBranch","HB_DefaultString10","HB_DestinationBranch","HB_ReceiveTeller"};
String[] elementNames_num = {"HB_Transaction_Detail_LEN"};
String sql = "select SourceBranch,ReceiveTeller1,DestinationBranch,ReceiveTeller2 from T_Ibd_TellerStoring where SourceBranch = '06050'";
String sql_num = "select count(*) from T_Ibd_TellerStoring where SourceBranch = '06050'";
if($ECAP_NOWPAGENUM == null || "".equals($ECAP_NOWPAGENUM) || $ECAP_NOWPAGENUM == 0)
{
$ECAP_NOWPAGENUM = 1;
}
int st_no = (($ECAP_NOWPAGENUM - 1) * page_num) + 1;
com.adtec.client.util.DataPoolTool.deleteElementValues(com.adtec.struct.ECAPTxRunInfo.getInstance().getIpID(), elementNames);
com.adtec.client.DBServiceTool.selectIntoDataPool(sql,st_no,page_num,elementNames);
com.adtec.client.util.DataPoolTool.deleteElementValues(com.adtec.struct.ECAPTxRunInfo.getInstance().getIpID(), elementNames_num);
com.adtec.client.DBServiceTool.selectIntoDataPool(sql_num,1,1,elementNames_num);
$ECAP_ALLPAGENUM = (($HB_Transaction_Detail_LEN)/page_num) + 1;