public static string[] GetStatistic(int catalogType, int category, FrmStatistic frm) { string[] results = new string[7] { "", "", "", "", "", "", "" }; if (catalogType == 0 & category == 0) { return(results); } string[] queries = GetQueries(catalogType, category); using (SqlConnection connection = new SqlConnection(DataBase.ConStrDB)) { SqlCommand cmd = connection.CreateCommand(); connection.Open(); for (int i = 0; i < results.Length; i++) { cmd.CommandText = queries[i]; frm.tbTEST.Text = queries[i]; SqlDataReader reader = cmd.ExecuteReader(); if (!reader.HasRows) { results[i] = string.Empty; } else { reader.Read(); double price; if ((i == 2 || i == 3) && double.TryParse(reader[0].ToString(), out price)) { results[i] = price.ToString(); } else { results[i] = reader[0].ToString(); } } reader.Close(); } } return(results); }
private void tsmMenuStatistic_Click(object sender, EventArgs e) { FrmStatistic frmStaristic = new FrmStatistic(); frmStaristic.ShowDialog(); }