自己学习BCDL 1

--在1001 用户下面添加 菜单的SQL
insert into "CMBBCD_AH"."CMCS3_MENU"("MENUID","SUPERIORMENUID","MENULABEL","URL","DESCRIPTION","POSITION","MENUTYPE") values (20219,678,'额度设置','/business/payment/odfRecordAction.shtml?action=loadOdfRecord','',13,3);
insert into "CMBBCD_AH"."CMCS3_MENU"("MENUID","SUPERIORMENUID","MENULABEL","URL","DESCRIPTION","POSITION","MENUTYPE") values (20220,678,'额度发送查询','/business/payment/odfRecordAction.shtml?action=queryOdfSendInfo','',14,3);
commit;

--当前方的企业或者银行账单校验不通过的时候
企业账单校验Action：
AuditCorpBookAction.java 
对应的方法: public ActionForward jihe(
LoadInforAuditCorpBook.jsp 企业账单页面
viewBankBookjihe.jsp 校验是否成功界面

银行账单校验Action：
QueryAuditBankBookAction.java
对应的方法: public ActionForward jihe(
QueryAuditBankBookInfo.jsp
viewBankBookjihe.jsp

--如果期末余额不平，有如下思路：
//计算期初的SQL：
from AuditCorpBalance a where a.bankAccount.accountID = :subjectID order by a.balanceDate desc
//取借贷金额总和：
"select sum(a.debitAmount),sum(a.creditAmount) from AuditCorpBook a " +
" where a.bankAccount.accountID = :subjectId " +
" and a.voucherDate >= :beginDate and a.voucherDate < :endDate";

1. 有可能是期初计算有问题；
2. 有可能是前方的M8传过来的数据有遗漏

--可以根据这个来查找对账初始化的数据
select u.username from CMCS3_USER_ACCOUNT ua ,CMCS3_BANK_ACCOUNT ba ,cmcs3_user u
where ba.accountid = ua.accountid and ua.userid = u.userid
and ua.powertype = 2
and ua.isaudit = 1
  group by u.username

--解决新疆行号要出纳一个一个输入的问题，用到表关联
select * from cmcs3_transfer_bill_list;
update cmcs3_transfer_bill_list l set l.banknum =
(select c.bankcode from cmcs3_bank_code c where c.bankname = l.payeebranch)
where l.transferbillid = 5380;
commit;