We will fill in the table part. How to get the current line of tabular part

note that procedure Initialize, as well as all its parameters, are mandatory for external processing of the filling tabular partIf you do not create it or do not specify all the parameters, your processing simply will not work.

Now let's start writing a program code. First, create a variable for the tabular part of the document. Realization of goods and serviceswhich we will fill out.

Watchboard \u003d object [NameTagged];

When performing the procedure in the parameter An object will contain an object of the document that we fill, and in the parameter NameTablished A string with the name of the tabular part that we fill. Thus, this line of code receives the tabular part of the filled document by its name.

We need to choose the user to select the document Admission of goods and services, Therefore, write the code for opening the form of document selection. To begin with, we get this form into a variable using the external processing method. Optional (<Форма>, <Владелец>, <КлючУникальности>) . We just fill out only the first parameter of this method, passing there a string named our form.

FormAvailability / Access \u003d Options ("Form");

Now open the resulting form using the modal opening (until the form is open all the other 1c windows are not available), because with this method of opening the future our code in the procedure Initialize It will not be executed until the user closes the form.

FormAllustration of complaining. OpenModally ();

After the user closes the form, we need to check whether the requisition is filled Document pay(In case the receipt document was not selected). If after checking Document pay It turns out to be empty, then further processing does not make sense, and it should be interrupted.

To verify the completion of the props, the global context function is used here. Document is filled (<Значение>) , it checks whether the value is transmitted in the default value of the same type. Procedure To report Displays the specified text in the 1C 8 message window. Keyword Return Interrupts the execution of the procedure.

We will start writing a query that will select data tabular Products document Admission of goods and services. Create a new request:

Request \u003d new request;

Request. Installation parameter ( "DocumentAmpsion", DocumentAmpsion);

Write the text of the request, we will do it with Designer query. It is not recommended to write the text of the query text manually, it is not effective and takes a bunch of time. To begin with, write a string:

Request.text \u003d "";

We will deliver the cursor between the characters of the quotes, click the right mouse button and select item Request Designer .... After that, a proposal will appear to create a new request, click the "OK" button. The designer window opens, all available database tables are located in the left part, we need a document Adaitetovarov Supervug. We will find it and reveal using the "+" symbol, select the tabular part Products and pulling it into the second part of the designer screen, which is called Tables(Also, move the desired table using the "\u003e" button).

Now reveal the "+" table we chose ( AdaitovyovarovyovServyvaryovas) and drag the fields necessary for our fill in the third part of the designer screen, which is called - Field. You will not choose all available fields, we will restrict ourselves to such a set: Nomenclature, number, price, amount, StavanS, Summands.

Since we need data for only one admission document (which we chose before filling), then in the "Conditions" tab, we will put the condition for the document link using the parameter transferred by us.

Creating a query text in the designer on this is complete, click the "OK" button. As a result, we turned out the following query text:

Request.text \u003d "Select | From | Where;

The created request remains only to perform and unload to the variable:

Result \u003d query. Fill (). Unload ();

In a variable Result Stored table of values \u200b\u200bwith rows of tabular part Products We have chosen documents Admission of goods and services. Now you can start filling out the tabular part Products Our implementation. But before you fill out the data, it should be cleaned, in the case there are already some lines.

Watchchast.Inter ();

With cycle For each Walk the table of values \u200b\u200bwith the query results.

In this cycle, create and fill in the string of the table part of the document Realization of goods and services. Create a new string We can with a variable Circuit partsThrough which you can make any actions with it.

NEWSTROCATCH \u003d WATCH CHAIN. Add ();

Fill the created tab of the tab. Parts of data from the query result string using the procedure Global Context — Filling out (<Приемник>, <Источник>) .

Filling out (newstock, elementural results);

But the data completed by us is not enough, so that the document would be done, you must fill out more accounting accounts Nomenclature. To do this, we use export

procedure FILLINGSETHETATINGS MANAGEMENTS from the document object module Realization of goods and services. Call it using the parameter An object(It should be noted,

what can we call only export Procedures from the module of the document object).

Object. Requirementsetsetting (newstrokatch, name data, truth);

On this programming of the table part for 1C 8. Completed. Processing can be used. Full text of the procedure Initialize, looks like that: