T+销货单工作台查询条件中将客户字段改成单值查询

【问题现象】

销货单工作台查询条件中客户字段是通过区间类型进行查询的，使用有时会觉得不方方便，需要将客户字段改成单值查询

【解决方案】

修改了销货单工作台的话，那么销货单列表的查询也会随着变成单值，以下脚本为处理销货单列表查询的客户和结算客户，如果结算客户不需要修改则不用执行；同时下面还有恢复到区间的脚本，执行完成以后，重启T+服务；（请注意备份账套再执行）

--处理客户

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')

)

--处理结算客户

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')

)

--恢复区间的脚本

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'