用友T+销售出库单列表查询条件中将客户字段改成单值查询

【问题现象】

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

【解决方案】

执行以下脚本，完成以后，需要重启T+服务；（请注意备份账套再执行）

--处理客户

update EAP_SearchItem_Ext set IsBetween='0' where SearchId in (select id from EAP_SearchInfo_Ext where name='Stock_SaleDispatchVoucherList') and FieldTitle='客户'

--处理结算客户

update EAP_SearchItem_Ext set IsBetween='0' where SearchId in (select id from EAP_SearchInfo_Ext where name='Stock_SaleDispatchVoucherList') and FieldTitle='结算客户'

--恢复区间

update EAP_SearchItem_Ext set IsBetween='1' where SearchId in (select id from EAP_SearchInfo_Ext where name='Stock_SaleDispatchVoucherList') and FieldTitle='客户'

update EAP_SearchItem_Ext set IsBetween='1' where SearchId in (select id from EAP_SearchInfo_Ext where name='Stock_SaleDispatchVoucherList') and FieldTitle='结算客户'