Comm.CommandText=

            double VSumVitratDDM = 0;
            SqlConnection conn71 = new SqlConnection(Str);
            if (conn71.State == ConnectionState.Closed) conn71.Open();
            SqlCommand comm71 = new SqlCommand();
            comm71.Connection = conn71;
 
comm71.CommandText = "SELECT SUM(Sum*ExchangeRates.Sum1/ExchangeRates.Sum2) FROM Document,DocumentBody,DocumentSum,ExchangeRates WHERE ((Document.Id=DocumentBody.IdDocument) AND (DocumentBody.Id=DocumentSum.IdDocumentBody) AND (ExchangeRates.IdCurrency2=Document.IdCurrency) AND (ExchangeRates.Date>=Document.Date) AND (Document.TypeDocument=20 OR Document.TypeDocument=21 OR Document.TypeDocument=24 OR Document.TypeDocument=29 OR Document.TypeDocument=30 OR Document.TypeDocument=37 OR Document.TypeDocument=38 OR Document.TypeDocument=39 OR Document.TypeDocument=40) AND (ExchangeRates.IdCurrency1=@VIdCurrencyM2) AND (Document.Date<=@VDateMTime) AND (Document.IdClientOur=@VIdClientOurM))";
 
            comm71.Parameters.AddWithValue("@VIdCurrencyM2", VIdCurrencyM2);
            comm71.Parameters.AddWithValue("@VIdCurrencyM", VIdCurrencyM);
            comm71.Parameters.AddWithValue("@VIdClientOurM", VIdClientOurM);
            comm71.Parameters.AddWithValue("@VDateMTime", VDateMTime);
 
            SqlDataReader DR71 = comm71.ExecuteReader();
            if (DR71.Read())
            {
                string VSumM = DR71.GetValue(0).ToString();
                if (VSumM != "")
                {
                    VSumVitratDDM = Convert.ToDouble(VSumM);
                }
            }
            DR71.Close();
            conn71.Close();