public virtual int Fill(DataSet1.DataTable1DataTable dataTable, object m)
        {
            this._commandCollection = new global::Devart.Data.SQLite.SQLiteCommand[1];
            this._commandCollection[0] = new global::Devart.Data.SQLite.SQLiteCommand();
            this._commandCollection[0].Connection = this.Connection;
            this._commandCollection[0].CommandText = string.Format(@"
Create temp table T1 as
    Select Sheta.Id,Profil.artikul_profil, Profil.system, Profil.tip, Profil.opis, Profil.width_kom, Profil.width_street, Profil.length, Profil.height, Izd_karandash.kol, 
        Izd_karandash.sum,Izd_karandash.id_karandash,Izd.id_plenka_street, Izd.kol AS Expr1, Izd.price_s_proc, Izd.prim, Izd.shirina, Izd.date, Izd.squre, Izd.length AS Expr2, Plenka_1.name_plenka AS Expr3, Klient.name_klient, Izd.No_izd, Sheta.N_K_S
    FROM Sheta INNER JOIN Klient ON Sheta.id_K = Klient.Id_klient
               INNER JOIN Izd_Karandash ON Sheta.Id = Izd_karandash.id_schet
               INNER JOIN Izd ON Sheta.id=Izd.id_schet
               INNER JOIN Profil ON Profil.Id_profil = Izd.id_profil
               INNER JOIN Plenka AS Plenka_1 ON Izd.id_plenka_komnata=Plenka_1.Id_plenka
WHERE        (Sheta.id IN ({0}));

Create temp table T2 as
    Select T1.*,Karandash.opisanie_karandash,Karandash.artikul_karandash
        from T1 left join Karandash ON Karandash.Id_karandash =T1.id_karandash
union all
    Select T1.*,Karandash.opisanie_karandash,Karandash.artikul_karandash
        from Karandash left join T1 ON Karandash.Id_karandash = T1.id_karandash
where T1.id_karandash is NULL
order by Id_karandash; 

    Select T2.*,Plenka.* 
        from T2 left join Plenka on Plenka.Id_plenka = T2.id_plenka_street 
union all 
    Select T2.*,Plenka.* 
        from Plenka left join T2 on Plenka.Id_plenka = T2.id_plenka_street 
where T2.id_plenka_street is NULL;


", m);

            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
            this.Adapter.SelectCommand = this.CommandCollection[0];

            if ((this.ClearBeforeFill == true))
            {
                dataTable.Clear();
            }
            int returnValue = this.Adapter.Fill(dataTable);
            return returnValue;
        }