|
版本: |
|
小版本号: |
|
|
|
数据库: |
|
服务器操作系统: |
|
应用服务器: |
|
客户端操作系统: |
|
浏览器: |
|
|
|
HI,现在经常在保存时出现:
数据被其他用户修改了; 数据被其他用户删除了。
只有一个人用时都是这样,而且,是系统自动带 的保存。
queryWODAction 的源码如下:
select WOD.*,( SQL.ISNULL(WOD.QTY, 0) - SQL.ISNULL(WOD.QTY_F, 0) ) as QTY_BAL,(SQL.dateDiff(SQL.DAY, WOD.TRAN_DATE, :currentDate())) as LATEDATE,JOBBOL.LEAD_TIME1 as LEAD_TIME1,JOBBOL.WK_DESC as WK_DESC,ORDID.ORD_DESCC as ORD_DESCC,SOD.YOURMODEL as YOURMODEL,SOD.YOURCOLOR as YOURCOLOR_SOD,SOD.YOURSIZE as YOURSIZE,ITEMMSTR.SPEC01 as SPEC01,ITEMMSTR.SPEC02 as SPEC02,( SQL.ISNULL(WOD.W, 0) - SQL.ISNULL(WOD.W_F, 0) ) as W_BAL,JOBBOL.NLEAD_TIME1 as NLEAD_TIME1
from WOD WOD
optional join JOBBOL JOBBOL on WOD.JOBFID = JOBBOL
optional join ORDID ORDID on WOD.ORD_ID = ORDID.ORD_ID
optional join SOD SOD on WOD.SOHID = SOD
optional join ITEMMSTR ITEMMSTR on WOD.ITEM_NO = ITEMMSTR.ITEM_NO
多谢
|
|