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

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

【解決方案】

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

--處理客戶

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é)算客戶

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'