
INSERT [IES].[T_EXPORT_XML_DATA] ([ExportXmlDataID], [Entities], [FilterLexem], [ProcedureName], [IsArchive], [Name], [ArchiveExtension]) VALUES (N'F1132428-A362-428B-8171-07C417061D7D', 540, N'<lx:Criteria type="And" xmlns:lx="lexem">
    <lx:Criteria type="Or">
        <lx:Criterion type="=">
            <lx:Path OwnerQueryLevel="0">
                <lx:StepString name="YEAR" />
            </lx:Path>
            <lx:UserQueryOperand type="Const" expectedValueSpecification="Int32" name="Год" />
        </lx:Criterion>
        <lx:Criterion type="=">
            <lx:UserQueryOperand type="Const" expectedValueSpecification="Int32" name="Год" />
            <lx:ConstOperand isNull="1" />
        </lx:Criterion>
    </lx:Criteria>
    <lx:Criteria type="Or">
        <lx:Criterion type="=">
            <lx:UserQueryOperand type="Choice" expectedValueSpecification="IES.SCHET" expectedValueSpecificationAttribute="MONTH" name="Месяц" />
            <lx:ChoiceOperand Entity="IES.SCHET" AttributeName="MONTH" isNull="1" />
        </lx:Criterion>
        <lx:Criterion type="=">
            <lx:Cast type="Int32">
                <lx:Path OwnerQueryLevel="0">
                    <lx:StepString name="MONTH" />
                </lx:Path>
            </lx:Cast>
            <lx:UserQueryOperand type="Const" expectedValueSpecification="Int32" name="Месяц" />
        </lx:Criterion>
    </lx:Criteria>
    <lx:Criterion not="1" type="=">
        <lx:Path OwnerQueryLevel="0">
            <lx:StepString name="SchetFile" />
            <lx:StepString name="Name" />
        </lx:Path>
        <lx:ConstOperand isNull="1" />
    </lx:Criterion>
    <lx:Criterion type="Like">
        <lx:Path OwnerQueryLevel="0">
            <lx:StepString name="SchetFile" />
            <lx:StepString name="Name" />
        </lx:Path>
        <lx:ConstOperand type="String"><![CDATA[HW%]]></lx:ConstOperand>
    </lx:Criterion>
    <lx:Criteria type="Or">
        <lx:Criterion type="=">
            <lx:Path OwnerQueryLevel="0">
                <lx:StepString name="SchetType" />
            </lx:Path>
            <lx:ChoiceOperand Entity="IES.SCHET" AttributeName="SchetType" type="Int32" PrimaryKey="6666" />
        </lx:Criterion>
    </lx:Criteria>
    <lx:Criterion type="&gt;=">
        <lx:Path OwnerQueryLevel="0">
            <lx:StepString name="ReceivedDate" />
        </lx:Path>
        <lx:UserQueryOperand type="Const" expectedValueSpecification="DateTime" name="Дата загрузки от" />
    </lx:Criterion>
    <lx:Criterion type="&lt;">
        <lx:Path OwnerQueryLevel="0">
            <lx:StepString name="ReceivedDate" />
        </lx:Path>
        <lx:DateAdd datepart="Day">
            <lx:ConstOperand type="Int32">1</lx:ConstOperand>
            <lx:UserQueryOperand type="Const" expectedValueSpecification="DateTime" name="Дата загрузки до" />
        </lx:DateAdd>
    </lx:Criterion>
    <lx:Criterion not="1" type="=">
        <lx:Path OwnerQueryLevel="0">
            <lx:StepString name="COMENTS" />
        </lx:Path>
        <lx:ConstOperand isNull="1" />
    </lx:Criterion>
</lx:Criteria>', N'sp_GetSchetFFOMSDispXmlMain', 1, N'Еженедельная выгрузка по COVID-19 тестам реестров', N'zip')
INSERT [IES].[T_EXPORT_XML_DATA_PARAMS] ([ExportXmlDataParamsID], [Name], [ParamDescription], [ParamValue], [ExportXmlData]) VALUES (N'c9e3f1ab-e6ae-480e-9e06-56c7b61a3076', N'@DateFrom', N'@DateFrom', N'<lx:Case xmlns:lx="lexem">
    <When>
        <lx:Criterion type="=">
            <lx:UserQueryOperand type="Const" expectedValueSpecification="DateTime" name="Дата загрузки от" />
            <lx:ConstOperand isNull="1" />
        </lx:Criterion>
    </When>
    <Then>
        <lx:ConstOperand type="DateTime">01/01/1900 00:00:00</lx:ConstOperand>
    </Then>
    <Else>
        <lx:UserQueryOperand type="Const" expectedValueSpecification="DateTime" name="Дата загрузки от" />
    </Else>
</lx:Case>', N'F1132428-A362-428B-8171-07C417061D7D')
INSERT [IES].[T_EXPORT_XML_DATA_PARAMS] ([ExportXmlDataParamsID], [Name], [ParamDescription], [ParamValue], [ExportXmlData]) VALUES (N'88b11f1d-89e4-4b86-8b17-750779f7c09d', N'SchetID', N'SchetID', N'<lx:Path OwnerQueryLevel="0" xmlns:lx="lexem">
	<lx:StepString name="SchetID" />
</lx:Path>', N'F1132428-A362-428B-8171-07C417061D7D')
INSERT [IES].[T_EXPORT_XML_DATA_PARAMS] ([ExportXmlDataParamsID], [Name], [ParamDescription], [ParamValue], [ExportXmlData]) VALUES (N'c5573d1b-cb51-441e-adb2-76ba2414be1a', N'@Month', N'@Month', N'<lx:Case xmlns:lx="lexem">
    <When>
        <lx:Criterion type="=">
            <lx:UserQueryOperand type="Const" expectedValueSpecification="Int32" name="Месяц" />
            <lx:ConstOperand isNull="1" />
        </lx:Criterion>
    </When>
    <Then>
        <lx:ConstOperand type="Int32">0</lx:ConstOperand>
    </Then>
    <Else>
        <lx:UserQueryOperand type="Const" expectedValueSpecification="Int32" name="Месяц" />
    </Else>
</lx:Case>', N'F1132428-A362-428B-8171-07C417061D7D')
INSERT [IES].[T_EXPORT_XML_DATA_PARAMS] ([ExportXmlDataParamsID], [Name], [ParamDescription], [ParamValue], [ExportXmlData]) VALUES (N'8d0bd0d5-f87d-4f2d-a07e-89339f1c23a8', N'@Year', N'@Year', N'<lx:Case xmlns:lx="lexem">
    <When>
        <lx:Criterion type="=">
            <lx:UserQueryOperand type="Const" expectedValueSpecification="Int32" name="Год" />
            <lx:ConstOperand isNull="1" />
        </lx:Criterion>
    </When>
    <Then>
        <lx:ConstOperand type="Int32">0</lx:ConstOperand>
    </Then>
    <Else>
        <lx:UserQueryOperand type="Const" expectedValueSpecification="Int32" name="Год" />
    </Else>
</lx:Case>', N'F1132428-A362-428B-8171-07C417061D7D')
INSERT [IES].[T_EXPORT_XML_DATA_PARAMS] ([ExportXmlDataParamsID], [Name], [ParamDescription], [ParamValue], [ExportXmlData]) VALUES (N'dd0f5ba1-0bac-4a59-98ed-ea3d277e4bde', N'@DateTo', N'@DateTo', N'<lx:Case xmlns:lx="lexem">
    <When>
        <lx:Criterion type="=">
            <lx:UserQueryOperand type="Const" expectedValueSpecification="DateTime" name="Дата загрузки до" />
            <lx:ConstOperand isNull="1" />
        </lx:Criterion>
    </When>
    <Then>
        <lx:ConstOperand type="DateTime">01/01/1900 00:00:00</lx:ConstOperand>
    </Then>
    <Else>
        <lx:UserQueryOperand type="Const" expectedValueSpecification="DateTime" name="Дата загрузки до" />
    </Else>
</lx:Case>', N'F1132428-A362-428B-8171-07C417061D7D')
INSERT [IES].[T_EXPORT_XML_DATA_PARAMS] ([ExportXmlDataParamsID], [Name], [ParamDescription], [ParamValue], [ExportXmlData]) VALUES (N'16b21873-160c-4635-8b71-f942d47810e5', N'@SessionId', N'@SessionId', N'<lx:ParamHolder xmlns:lx="lexem">
    <lx:StepString name="USER_SESSION_ID" />
</lx:ParamHolder>', N'F1132428-A362-428B-8171-07C417061D7D')
INSERT [IES].[T_EXPORT_XML_DATA_PARAMS] ([ExportXmlDataParamsID], [Name], [ParamDescription], [ParamValue], [ExportXmlData]) VALUES (N'6093769e-50cd-4d08-b21a-fca3e44787d2', N'@WeekNumber', N'@WeekNumber', N'<lx:Case xmlns:lx="lexem">
    <When>
        <lx:Criterion type="=">
            <lx:UserQueryOperand type="Const" expectedValueSpecification="Int32" name="Номер недели" />
            <lx:ConstOperand isNull="1" />
        </lx:Criterion>
    </When>
    <Then>
        <lx:ConstOperand type="Int32">0</lx:ConstOperand>
    </Then>
    <Else>
        <lx:UserQueryOperand type="Const" expectedValueSpecification="Int32" name="Номер недели" />
    </Else>
</lx:Case>', N'F1132428-A362-428B-8171-07C417061D7D')
INSERT [IES].[T_EXPORT_XML_DATA_PARAMS] ([ExportXmlDataParamsID], [Name], [ParamDescription], [ParamValue], [ExportXmlData]) VALUES (N'6393769e-50cd-4d08-b21a-fca3e44787d2', N'@TFOMScode', N'@TFOMScode', N'<lx:Case xmlns:lx="lexem">
    <When>
        <lx:Criterion type="=">
            <lx:UserQueryOperand type="Const" expectedValueSpecification="Int32" name="Номер ТФОМС" />
            <lx:ConstOperand isNull="1" />
        </lx:Criterion>
    </When>
    <Then>
        <lx:ConstOperand type="Int32">0</lx:ConstOperand>
    </Then>
    <Else>
        <lx:UserQueryOperand type="Const" expectedValueSpecification="Int32" name="Номер ТФОМС" />
    </Else>
</lx:Case>', N'F1132428-A362-428B-8171-07C417061D7D')
