|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
5.3.4版本,主从表要删除明细数据(从表设置directDelte为false),从表保存前动作执行以下语句,结果执行时第一个被删除的数据总是不能清空销售订单明细表,一定要从第二条才开始清空,请问如何处理:
//删除时清空销售订单明细表fPlanSign , fSeOrderPlanID
Iterator <Row> rows = table.iterator(com.justep.system.data.ModifyState.DELETE);
String sql = null ;
Integer FInterID = 0 , FEntryID = 0;
String fMainID = null;
while (rows.hasNext()){
Row row = rows.next();
FInterID = (Integer)row.getValue("fOrderInterID");
FEntryID = (Integer)row.getValue("fOrderEntryID");
System.out.println(FInterID + " " + FEntryID + (String)row.getValue("fMaterialNumber"));
sql = "update SEOrderEntry set fPlanSign = '' , fSeOrderPlanID = '' where FInterID = " + FInterID;
sql = sql + " and FEntryID = " + FEntryID;
SQL.executeUpdate(sql, null, "/aaERP/produce/data");
}
|
|