【問(wèn)題現(xiàn)象】

銷(xiāo)貨單工作臺(tái)查詢(xún)條件中客戶(hù)字段是通過(guò)區(qū)間類(lèi)型進(jìn)行查詢(xún)的，使用有時(shí)會(huì)覺(jué)得不方方便，需要將客戶(hù)字段改成單值查詢(xún)

【解決方案】

修改了銷(xiāo)貨單工作臺(tái)的話(huà)，那么銷(xiāo)貨單列表的查詢(xún)也會(huì)隨著變成單值，以下腳本為處理銷(xiāo)貨單列表查詢(xún)的客戶(hù)和結(jié)算客戶(hù)，如果結(jié)算客戶(hù)不需要修改則不用執(zhí)行；同時(shí)下面還有恢復(fù)到區(qū)間的腳本，執(zhí)行完成以后，重啟T+服務(wù)；（請(qǐng)注意備份賬套再執(zhí)行）

--處理客戶(hù)

update EAP_SearchItem_Ext set IsBetween = 0,CompareSign = '=' where SearchId in (select id from EAP_SearchInfo_Ext where Name = 'SA_SaleDeliveryList') and FieldName = 'SaleDelivery.Customer.Code'

update EAP_SearchPlanItem_Ext set ItemType = NULL where SearchItemId in (

select id from EAP_SearchItem_Ext where SearchId in (select id from EAP_SearchInfo_Ext where Name = 'SA_SaleDeliveryList') and (FieldName = 'SaleDelivery.Customer.Code')

)

--處理結(jié)算客戶(hù)

update EAP_SearchItem_Ext set IsBetween = 0,CompareSign = '=' where SearchId in (select id from EAP_SearchInfo_Ext where Name = 'SA_SaleDeliveryList') and FieldName = 'SaleDelivery.SettleCustomer.Code'

update EAP_SearchPlanItem_Ext set ItemType = NULL where SearchItemId in (

select id from EAP_SearchItem_Ext where SearchId in (select id from EAP_SearchInfo_Ext where Name = 'SA_SaleDeliveryList') and (FieldName = 'SaleDelivery.Customer.Code')

)

--恢復(fù)區(qū)間的腳本

update EAP_SearchItem_Ext set IsBetween = 1,CompareSign = '=' where SearchId in (select id from EAP_SearchInfo_Ext where Name = 'SA_SaleDeliveryList') and FieldName = 'SaleDelivery.Customer.Code'

update EAP_SearchItem_Ext set IsBetween = 1,CompareSign = '=' where SearchId in (select id from EAP_SearchInfo_Ext where Name = 'SA_SaleDeliveryList') and FieldName = 'SaleDelivery.SettleCustomer.Code'