【問題現(xiàn)象】

銷貨單工作臺查詢條件中客戶字段是通過區(qū)間類型進行查詢的，使用有時會覺得不方方便，需要將客戶字段改成單值查詢

【解決方案】

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

)

--恢復區(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'