µÚÒ»·¶ÎÄÍø - רҵÎÄÕ·¶ÀýÎĵµ×ÊÁÏ·ÖÏíÆ½Ì¨

½ðµû_k3_BOS¿ª·¢°ÙÎʰٴð

À´Ô´£ºÓû§·ÖÏí ʱ¼ä£º2025/6/2 12:19:34 ±¾ÎÄÓÉloading ·ÖÏí ÏÂÔØÕâÆªÎĵµÊÖ»ú°æ
˵Ã÷£ºÎÄÕÂÄÚÈݽö¹©Ô¤ÀÀ£¬²¿·ÖÄÚÈÝ¿ÉÄܲ»È«£¬ÐèÒªÍêÕûÎĵµ»òÕßÐèÒª¸´ÖÆÄÚÈÝ£¬ÇëÏÂÔØwordºóʹÓá£ÏÂÔØwordÓÐÎÊÌâÇëÌí¼Ó΢ÐźÅ:xxxxxxx»òQQ£ºxxxxxx ´¦Àí£¨¾¡¿ÉÄܸøÄúÌṩÍêÕûÎĵµ£©£¬¸ÐлÄúµÄÖ§³ÖÓëÁ½⡣

½â¾ö·½·¨£º ¿ÉÒÔÔÚÊý¾Ý¿âÀïдִÐÐÈçÏ´úÂëʵÏÖ£º£¨ÏÂÃæÀý×ÓÊÇÌí¼ÓÉóºËµÄ¹ýÂËÌõ¼þ£© 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,

ËÑË÷¸ü¶à¹ØÓÚ£º ½ðµû_k3_BOS¿ª·¢°ÙÎʰٴð µÄÎĵµ
½ðµû_k3_BOS¿ª·¢°ÙÎʰٴð.doc ½«±¾ÎĵÄWordÎĵµÏÂÔØµ½µçÄÔ£¬·½±ã¸´ÖÆ¡¢±à¼­¡¢ÊղغʹòÓ¡
±¾ÎÄÁ´½Ó£ºhttps://www.diyifanwen.net/c487zn08qcr6tzp833x78_4.html£¨×ªÔØÇë×¢Ã÷ÎÄÕÂÀ´Ô´£©

Ïà¹ØÍÆ¼ö£º

ÈÈÃÅÍÆ¼ö
Copyright © 2012-2023 µÚÒ»·¶ÎÄÍø °æÈ¨ËùÓÐ ÃâÔðÉùÃ÷ | ÁªÏµÎÒÃÇ
ÉùÃ÷ :±¾ÍøÕ¾×ðÖØ²¢±£»¤ÖªÊ¶²úȨ£¬¸ù¾Ý¡¶ÐÅÏ¢ÍøÂç´«²¥È¨±£»¤ÌõÀý¡·£¬Èç¹ûÎÒÃÇ×ªÔØµÄ×÷Æ·ÇÖ·¸ÁËÄúµÄȨÀû,ÇëÔÚÒ»¸öÔÂÄÚ֪ͨÎÒÃÇ£¬ÎÒÃǻἰʱɾ³ý¡£
¿Í·þQQ£ºxxxxxx ÓÊÏ䣺xxxxxx@qq.com
ÓåICP±¸2023013149ºÅ
Top