%@ Control Language="C#" AutoEventWireup="true" CodeBehind="mod_gestKIT.ascx.cs" Inherits="MP_ADM.WebUserControls.mod_gestKIT" %>
Ordini selezionati:
Nessun Ordine caricato
Elenco KIT compatibili
Nessun KIT trovato
Prom.ODL
Elenco promesse per KIT (100%)
Nessun Record (P.ODL da eseguire)
Elenco KIT associati ad ordini
Nessun Record (Ordini associati a KIT)
<%--
- esempio KIT: 8060A00
- OPR18-20381
- OPR18-21855
- OPR18-21856
- OPR18-21857
- OPR18-22974 (NON VA BENE A313)
--%>
<%--
- esempio KIT: 8010A00
- OPR18-22022
- OPR18-22032
- esempio KIT: 8665A00
- OPR18-21255
- OPR18-21259
- OPR18-21268
- OPR18-21262
--%>
<%--TESTDB: MoonPro
select * from Config where chiave like 'regexp%'
TESTDB: IS_Colcom
exec stp_IstanzeKit_Search 'K1800000001', '', '', ''
exec stp_IstanzeKit_Search '', 'OPR-123456', '', ''
exec stp_IstanzeKit_Search '', '', 'A101000', ''
exec stp_IstanzeKit_Search '', '', '', 'A101001'
exec stp_TemplateKit_Search '8060A00',''
exec stp_TemplateKit_Search '','8060A313'
select * from TransitoDati
select * from IstanzeKIT
select top 1 * from TransitoDati where ValueOUT LIKE '%8060A0%'
select top 1 * from TransitoDati where ValueOUT LIKE '%8060A1%'
select top 1 * from TransitoDati where ValueOUT LIKE '%8060A2%'
select top 1 * from TransitoDati where ValueOUT LIKE '%8060A313%'
-- esempio KIT: 8060A00
-- OPR18-20381
-- OPR18-21855
-- OPR18-21856
-- OPR18-22974
select * from TemplateKIT order by CodArtChild DESC
exec stp_TKS_Search '1010A1,1010A2,'
exec stp_TKS_Search '8060A0,'
exec stp_TKS_Search '8060A1,'
exec stp_TKS_Search '8060A2,'
exec stp_TKS_Search '8060A313,'
exec stp_TKS_Search '8060A0,8060A1,8060A2,8060A313,'
exec stp_TKS_Search 'V10616D,'
exec stp_TKS_Search 'M06606,'
exec stp_TemplateKit_Search '1050A00',''
exec stp_TemplateKit_Search '1040A00',''
exec stp_TemplateKit_Search '6606A00',''
exec stp_TemplateKit_Search '6610A00',''
--truncate table IstanzeKIT
--truncate table Counters
select * from IstanzeKIT
exec stp_IstKit_byKeyExtOrd 'OPR-123321,OPR-123456,'
exec stp_IstKit_getKey
--%>