½â¾ö·½·¨£º ¿ÉÒÔÔÚÊý¾Ý¿âÀïдִÐÐÈçÏ´úÂëʵÏÖ£º£¨ÏÂÃæÀý×ÓÊÇÌí¼ÓÉóºËµÄ¹ýÂËÌõ¼þ£© Update icclasstableinfo set flock=-1,fconditionext=1000000 where fclasstypeid=300000000 and fkey='Fchecker'
˵Ã÷£ºfconditionext=1000000 ¶ÔÓ¦µÄÄÚÈÝΪ ICClassCondition ±íÖÐ FID=1000000 ÄÚ ÈÝ£¬²ì¿´¸ÃÌõ¼Ç¼µÄ FDataSource_CHS ¼òÌåÖÐÎÄÐÅϢΪ£º¡±È«²¿;None~ÒÑÉó ºË;isnull(@Field,0)>0~δÉóºË;isnull(@Field,0)<=0¡±¡£
È«²¿£º¶ÔÓ¦µÃ½âÎöÌõ¼þΪNone,˵Ã÷¸Ã¹ýÂËÌõ¼þ²»Æð×÷ÓÃ
ÒÑÉóºË£º¶ÔÓ¦µÃisnull(@Field,0)>0£¬Í¨¹ýÅжÏFchecker ×ֶεÄÖµÊÇ·ñ´óÓÚ0£¬À´ÅÐ ¶ÏÆäÊÇ·ñÉóºË£»
δÉóºË£º¶ÔÓ¦µÃisnull(@Field,0)<=0£¬Í¨¹ýÅжÏFchecker×ֶεÄÖµÊÇ·ñСÓÚµÈÓÚ0£¬ À´ÅÐ¶ÏÆäδÉóºË¡£
P.S:Èç¹ûÏÖÓеÄÀ©Õ¹¹ýÂËÌõ¼þ²»Âú×ãÌõ¼þÐèÒªÔö¼Ó£¬Çë²»Òª½ô½Ó×Åϵͳ¶¨ÒåµÄ Fid ¿ª ʼÀ©Õ¹£¬ÒÔÃⱻϵͳÉý¼¶Ê±Çå³ý£¬¿ÉÏñµ¥¾ÝÀàÐÍÒ»Ñù´Ó200000000¿ªÊ¼¡£
¡¾ÕªÒª¡¿£ºÈçºÎÔÙ´ÎÌí¼Óвå¼þ ¡¾°æ±¾¡¿£ºK3v10.2 ¼°ÒÔºó°æ±¾
ÎÊÌâÃèÊö£º ÔÚͶÁϱä¸üµ¥µÄ²Ëµ¥ÉϼÓÈëÒ»¸ö²Ëµ¥ÏÐèÒª²åÈëÒ»¸ö²å¼þ£¬µ«Í¶Áϱä¸ü µ¥ÉÏÒѾÓÐÒ»¸ö²å¼þÁË£¬ÈçºÎ²Å¿ÉÒÔÔÙ²åÈëÒ»¸ö²å¼þ ¿Í»§»¯¿ª·¢¼¼Êõ×ÊÁÏ¡ª¡ªK/3BOS¿ª·¢°ÙÎʰٴð
½â¾ö·½·¨£º µã²å¼þ¹ÜÀíÖеİ´Å¥£¬¿ÉÒÔͨ¹ýä¯ÀÀÀ´Ñ¡Ôñ×Ô¶¨Òå²å¼þ£¬²¢Ñ¡Ôñ¶à¸ö²å¼þ¶ÔÏó£¬BOSÔÊ
Ðí¶à¸ö²å¼þͬʱ´æÔÚ¡£
¡¾ÕªÒª¡¿£ºµ¥¾Ý·Ö¼Êý´ïµ½ 3000 Ìõ£¬µ¥¾Ý±£´æ»á²»»á³ö´í ¡¾°æ±¾¡¿£ºK3v10.2SP2
ÎÊÌâÃèÊö£º ÒòΪҵÎñÐèÒª£¬¿ÉÄÜÒ»Õŵ¥¾ÝµÄ·Ö¼Êý´ïµ½ 2000-3000 Ìõ£¬ÕâÑùµÄ BOS¿ª ·¢µÄµ¥¾Ý£¬±£´æÊ±ÊÇ·ñÓÐÎÊÌ⣿²Î¿¼:10.0 µÄÉ豸¹ÜÀíÖУ¬Â¼Èë 50-60 Ìõ·Ö ¼£¬±£´æÊ±¾Í»áÓÐÎÊÌâ³öÏÖ¡£
½â¾ö·½·¨£º Õâ¸öÎÊÌâÊÇ 10.0 µÄ bug,Ŀǰ K3BOS µ¥¾Ý×î´óÐÐÊýÉ趨ÊÇ 2000 ÐС£ÈçȷʵÓÐÐèÇó¿É·Å
¿ªÏàÓ¦ÏÞÖÆ¡£µ«µ¥¾ÝÌå×ֶιý¶à£¬ÐÔÄÜ»áÊܵ½Ò»Ð©Ó°Ï죬½¨Òé×îºÃ²»Òª³¬¹ýÕâ¸öÏÞÖÆ¡£
¡¾ÕªÒª¡¿£ºÅú´Î¹ýÂË ¡¾°æ±¾¡¿£ºK3v10.2SP1&K3v10.2SP2&K3v10.3
ÎÊÌâÃèÊö£º ¹ØÓÚÅú´ÎºÅ·Ö±ð°´ÊäÈëµÄÎïÁÏ¡¢²Ö¿â¡¢²ÖλµÄ¹ýÂËÅú´ÎµÄ·¶Àý´úÂë¡£ ½â¾ö·½·¨£º »·¾³ËµÃ÷£º ÎïÁÏ£º×Ö¶ÎÃû³ÆFItemID ²Ö¿â£º×Ö¶ÎÃû³ÆFDCStockID ²Öλ£º×Ö¶ÎÃû³ÆFDCSPID Åú´ÎºÅ£º×Ö¶ÎÃû³ÆFBatchNo
1¡¢ ¼Èë²Ö¿âºó£¬ÒÀ¾Ý²Ö¿âµÄ²Ö¿â×é¹ýÂ˲Öλ¡£
update ICClasstableinfo set FFilter='FSPGroupID = (SELECT FSPGroupID FROM t_Stock WHERE FItemID = GetFldValue(FDCStockID,1))'
where FKey='FDCSPID' and FClassTypeID=300000000 2¡¢ ¸ù¾ÝÊäÈëµÄÎïÁÏ¡¢²Ö¿â¡¢²Öλ¹ýÂ˹ýÂÊÅú´ÎºÅʱ¡£
update ICClassTableinfo set FFilter='(FItemID=GetFldValue(FItemID,1)
and FStockID=GetFldValue(FDCStockID,1) and ¿Í»§»¯¿ª·¢¼¼Êõ×ÊÁÏ¡ª¡ªK/3 BOS¿ª·¢°ÙÎʰٴð
FStockplaceID=GetFldValue(FDCSPID,1))' where FKey='FBatchNo' and FClassTypeID=300000000 3¡¢ ¸üÐÂBOS µ¥¾Ý»º´æ UPdate ICClasstype set fid=fid
¡¾ÕªÒª¡¿£ºÓ¦ÊÕÓ¦¸¶ÏµÍ³ºÏͬÊÇ·ñÄܳ¬¶îÖ´ÐÐ ¡¾°æ±¾¡¿£ºK3v10.1
ÎÊÌâÃèÊö£º Ó¦ÊÕÓ¦¸¶ÏµÍ³ºÏͬÊÇ·ñÄܳ¬¶îÖ´ÐС£
½â¾ö·½·¨£º 10.1Ó¦ÊÕÓ¦¸¶µÄºÏͬµÄ·´Ð´ÓÉÓ¦ÊÕÓ¦¸¶×ÔÐпØÖÆ£¬ÇÒ²¢ÎªÌṩÏàÓ¦²ÎÊý¿ØÖÆ¡£10.2Ó¦
ÊÕÓ¦¸¶ºÏͬ¸ÃÓÉBOSʵÏÖ£¬ÇÒÌṩÁË[ºÏͬÊÇ·ñÔÊÐí³¬¶îÖ´ÐÐ]µÄϵͳ²ÎÊýÑ¡Ïî¡£
¡¾ÕªÒª¡¿£º»ù´¡×ÊÁϼÈë´úÂëʱ²»ÂíÉÏÏÔʾÏà¹ØµÄÁÐ±í ¡¾°æ±¾¡¿£ºK3v10.2SP2+K3v10.3
ÎÊÌâÃèÊö£º BOS µ¥¾ÝÒýÓûù´¡×ÊÁÏʱ£¬ÄÜ·ñÓÐÉèÖã¬Ê¹ÔÚ¼Èë´úÂëʱ²»ÂíÉÏÏÔʾÏà¹ØµÄ ÁÐ±í£¬¶øÊÇÔڻسµÖ®ºó²ÅÅжÏÊÇ·ñ´æÔÚ´úÂ룬ÒòΪij¸ö»ù´¡×ÊÁÏÌ«´óÁË£¬ ÊäÈëÒ»¸ö×ÖĸҪ³¤Ê±¼ä²ÅÄܹ»·´Ó³¡£
½â¾ö·½·¨£º ¿ÉÒÔÔÚµ¥¾Ý¼Èë½çÃæÑ¡ÏîÖÐÑ¡Ôñ½ûÖ¹ÏÂÀÁбí×Ô¶¯ÏÔʾ¡£ ¿Í»§»¯¿ª·¢¼¼Êõ×ÊÁÏ¡ª¡ªK/3 BOS¿ª·¢°ÙÎʰٴð
¡¾ÕªÒª¡¿£ºÔÚ²å¼þÖÐÒÔÐÂÔö¡¢Ð޸ĺͲ鿴·½Ê½´ò¿ªÁíÒ»µ¥¾Ý ¡¾°æ±¾¡¿£ºK/3BOS ËùÓа汾
ÎÊÌâÃèÊö£º ÔÚ²å¼þÖÐÒÔÐÂÔö¡¢Ð޸ĺͲ鿴·½Ê½´ò¿ªÁíÒ»µ¥¾Ý ½â¾ö·½·¨£º ******************************************** '¹¦ÄÜ£ºÏÔʾBOSµ¥¾Ý£¬ÏÔʾµÄ·½Ê½ÎªÐÂÔö¡¢Ð޸ĺÍä¯ÀÀ '²ÎÊý£ºlClassTypeID¡ªÏÔʾBOSµ¥¾ÝµÄID
'******************************************** Private Sub ShowBill(ByVal lClassTypeID As Long) Dim oDataSrv As Object Dim oBill As Object On Error GoTo err_ctr Set oDataSrv =
m_BillInterface.K3Lib.CreateK/3Object(\ oDataSrv.ClassTypeID = lClassTypeID
Set oBill = CreateObject(\ With oBill
.DataSrv = oDataSrv .ISNetControl = True
.ISCheckRight = True .Show
'********************** 'Show ²ÎÊýÀàÐÍ
'µÚÒ»¸ö²ÎÊý Optional ByVal lID As Long = 0 £»ÃèÊöÐ޸Ļò²é¿´µÄµ¥¾ÝID 'µÚ¶þ¸ö²ÎÊý Optional ByVal bShowGroup As Boolean = False £»ÈçÊÇ»ù´¡ ×ÊÁÏʱ£¬ÊÇ·ñÏÔʾ·Ö×é
'µÚÈý¸ö²ÎÊý Optional ByVal BillStatus As Long = Enu_BillStatus_New £» ÏÔʾ·½Ê½ 0¡ª²é¿´£»1¡ªÐÂÔö£»2¡ªÐÞ¸Ä
'µÚËĸö²ÎÊý Optional ByVal dctData As KFO.Dictionary 'µ¥¾Ý³õʼֵ '********************** End With
Set oDataSrv = Nothing Set oBill = Nothing Exit Sub err_ctr:
Set oDataSrv = Nothing Set oBill = Nothing End Sub
¡¾ÕªÒª¡¿£ºÏÔʾBOSÐòʱ²¾²¢·µ»ØÑ¡ÖеÄÖµ ¡¾°æ±¾¡¿£ºK/3BOS ËùÓа汾 ¿Í»§»¯¿ª·¢¼¼Êõ×ÊÁÏ¡ª¡ªK/3 BOS¿ª·¢°ÙÎʰٴð
ÎÊÌâÃèÊö£º ÇëÎÊÔÚ²å¼þÖÐÔõÑùÏÔʾBOS Ðòʱ²¾²¢·µ»ØÑ¡ÖеÄÖµ¡£ ½â¾ö·½·¨£º '******************************************** '¹¦ÄÜ£ºÏÔʾBOSÐòʱ²¾²¢·µ»ØÑ¡ÖеÄÖµ '²ÎÊý£ºlClassTypeID¡ªÏÔʾBOSµ¥¾ÝµÄID
'********************************************
Private Function ShowListByReturn(ByVal lClassTypeID As Long) As Object Dim oDataSrv As Object Dim objLookup As Object On Error GoTo err_ctr Set oDataSrv =
m_BillInterface.K3Lib.CreateK3Object(\ oDataSrv.ClassTypeID = lClassTypeID If oDataSrv.showfilter Then
Set objLookup = CreateObject(\ objLookup.ClassTypeID = lClassTypeID Set objLookup.DataSrv = oDataSrv objLookup.Lookup
Set ShowListByReturn = objLookup.VectReturn End If
Set oDataSrv = Nothing Set objLookup = Nothing
Exit Function err_ctr:
Set oDataSrv = Nothing Set objLookup = Nothing End Function
¡¾ÕªÒª¡¿£º½«µ±Ç°µ¥¾Ýת»¯ÎªÁíÒ»µ¥¾Ý£¬²¢ÎÞ½çÃæ±£´æÊý¾Ý ¡¾°æ±¾¡¿£ºK/3BOS ËùÓа汾
ÎÊÌâÃèÊö£º ½«µ±Ç°µ¥¾Ýת»¯ÎªÁíÒ»µ¥¾Ý£¬²¢ÎÞ½çÃæ±£´æÊý¾Ý¡£ ½â¾ö·½·¨£º '******************************************** '¹¦ÄÜ£º½«µ±Ç°µ¥¾Ýת»¯ÎªÁíÒ»µ¥¾Ý£¬²¢ÎÞ½çÃæ±£´æÊý¾Ý '²ÎÊý£ºlClassTypeID¡ªÏÔʾBOSµ¥¾ÝµÄID
'******************************************** Private Sub NoUISaveBill(ByVal lClassTypeID As Long) Dim oDataSrv As Object Dim oTableInfo As Object Dim oBill As Object Dim oData As Object
Dim oSrv As Object ¿Í»§»¯¿ª·¢¼¼Êõ×ÊÁÏ¡ª¡ªK/3 BOS¿ª·¢°ÙÎʰٴð
Dim oPage2 As Object Dim i As Long
On Error GoTo err_ctr Set oDataSrv =
m_BillInterface.K3Lib.CreateK3Object(\ oDataSrv.ClassTypeID = lClassTypeID Set oTableInfo = oDataSrv.TableInfo Set oData = oDataSrv.GetEmptyBill
For i = 1 To m_BillInterface.Data(\ Set oPage2 = oData(\
oData(\ 'Ìí¼Óµ½ dcData
oData(\¸ü¸Ä·Ö¼ºÅ Next
For i = 1 To m_BillInterface.Data(\
oData(\ m_BillInterface.GetFieldValue(\ oData(\ m_BillInterface.GetFieldValue(\ oData(\ m_BillInterface.GetFieldValue(\ Next
Set oSrv = CreateObject(\ i = oSrv.Save(MMTS.PropsString, oDataSrv.ClassType,
Ïà¹ØÍÆ¼ö£º