Verdana 小四

Verdana

角度决定深度，细节决定成败，态度决定一切。

object brower:
komatsuzaki@sd-net.co.jp
OOB7-697368-7C0C7f-7D3010

SI Object Browser 10
NO: 1q2w3
Key: OB-626421-357640-0C5D2b
试试看吧。
SI Object Browser 10.0.0.0
p.no 12345678
p.key OB-293D7e-333532-213451


Object Browser
usename:tomdog@dog
password:OOB7-223436-4F4116-632DE4

WinCvs
http://www.wincvs.org/download.html
http://blog.youkuaiyun.com/sipsir/archive/2007/07/06/1681071.aspx


resin
http://www.blogjava.net/vesung/archive/2008/03/05/184028.html


update VmiReportFormat

// 清空表尾统计数据
sqlString.append(" update VmiReportFormat t ");
sqlString.append(" set t.defaultValue='0' ");
sqlString.append(" where 1=1 ");
sqlString.append(" and t.submitSupplierCode = :submitSupplierCode ");
sqlString.append(" and t.reportMode = :reportMode ");
sqlString.append(" and t.reportType = :reportType ");
sqlString.append(" and t.dataType = :dataType ");
sqlString.append(" and t.informationSource = :informationSource ");

daovo.setSubmitSupplierCode(masterVO.getSubmitSupplierCode());
daovo.setReportMode("E");
daovo.setReportType(masterVO.getReportType());
daovo.setDataType("FE");
daovo.setInformationSource("2");

findEachPhaseList（）

updateVmiReportFormatCount()
if("FE".equals(vo.getDataType())){

daovo.setReportMode("E");
daovo.setReportType(masterReportType);
daovo.setDataType("FE");
daovo.setInformationSource("2");
daovo.setMappingTable("SUM");
findModelByPK4VMSL(daovo);
检索得出不同column的数据

如果检索出的值存在，则更新VmiReportFormat，如下：
model.setDefaultValue(checkSum+"");
model.setUpdateCompanyCode(vo.getEmpCompanyCode());
model.setUpdateEmpNo(vo.getEmpNo());
model.setUpdateDate(new Date());

getEachPhaseSQLVO（）回傳FH, BD, FE的sql
字方法findVmiReportFormat（） findVmiTableRelation（）
sb.append("select r from VmiTableRelation r");
sb.append(" where 1=1");
//sb.append(" and secondaryTable not in ('TA','SL','PT','PR') ");
sb.append(" and secondaryTable not in ('SL','PT', 'BG') ");