private void Window_Loaded(object sender, RoutedEventArgs e) { ex = new SqlExecute(connectionString); AddOrderDate.SelectedDate = DateTime.Now; MySqlDataReader reader = ex.returnResult("select title from details where iddetails =" + missingDetails[0]); if (reader.HasRows) { while (reader.Read()) { AddOrderDetailTitle.Text = reader.GetString(0); } } ex.closeCon(); AddOrderPrice.Text = "0₴"; }
public MainWindow() { InitializeComponent(); StreamReader sReader = new StreamReader(@"settings.txt"); string connString = ""; while (!sReader.EndOfStream) { connString += sReader.ReadLine() + ";"; } sReader.Close(); connectionstring = "server=" + connString.Split(';')[0].Split(':')[1] + ";database=" + connString.Split(';')[1].Split(':')[1] + ";uid=" + connString.Split(';')[2].Split(':')[1] + ";password="******";"; ex = new SqlExecute(connectionstring); hd = new HideAllGrids(this); RepairForecast rp = new RepairForecast(); }
public static string Forecast(string titlemalfunction, string connectionString) { //double d = 0; //получаю месяцы SqlExecute ex = new SqlExecute(connectionString); MySqlDataReader reader = ex.returnResult("SELECT DISTINCT DATE_FORMAT(repairorders.datestart, '%m-%Y') FROM repairorders_malfunctions inner join repairorders using (idrepairorders) "); if (reader == null) { return("DataBaseError-0001_0"); } List <string> MonthLs = new List <string>(); if (reader.HasRows) { while (reader.Read()) { MonthLs.Add(reader.GetString(0)); } } ex.closeCon(); string forecastMonth = MonthLs[MonthLs.Count - 1]; DateTime dt = new DateTime(Convert.ToInt32(forecastMonth.Split('-')[1]), Convert.ToInt32(forecastMonth.Split('-')[0]), 1); dt = dt.AddMonths(1); MonthLs.Add(dt.ToShortDateString().Split('.')[1] + "-" + dt.ToShortDateString().Split('.')[2]); //получаю фактические значения в месяце List <double> valueLs = new List <double>(); for (int i = 0; i < MonthLs.Count - 1; i++) { reader = ex.returnResult("select count(recordid) from repairorders_malfunctions inner join repairorders using (idrepairorders) where idmalfunctions = (select idmalfunctions from malfunctions where title='" + titlemalfunction + "') and Year(repairorders.datestart)=" + MonthLs[i].Split('-')[1] + " and Month(repairorders.datestart) = " + MonthLs[i].Split('-')[0]); if (reader == null) { return("DataBaseError-0001_0"); } if (reader.HasRows) { while (reader.Read()) { valueLs.Add(Convert.ToDouble(reader.GetInt32(0))); } } ex.closeCon(); } ex.closeCon(); //расчёт а и b double a; double b; double SummYfMultX = 0; double SummYfMultSummX; double SummX = 0; double SummYf = 0; double SumSqrX = 0; for (int i = 0; i < valueLs.Count; i++) { SummYfMultX += valueLs[i] * (i + 1); SummX += (i + 1); SummYf += valueLs[i]; SumSqrX += Math.Pow((i + 1), 2); } SummYfMultSummX = SummX * SummYf; a = (SummYfMultX - (SummYfMultSummX / valueLs.Count())) / (SumSqrX - (Math.Pow(SummX, 2) / valueLs.Count())); b = (SummYf / valueLs.Count()) - ((a * SummX) / valueLs.Count()); //вычисление расчётного числа valueLs.Add(a * (valueLs.Count() + 1) + b); //парсинг для передачи string returnString = ""; switch (MonthLs[MonthLs.Count - 1].Split('-')[0]) { case "01": { returnString = "January-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } case "02": { returnString = "February-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } case "03": { returnString = "March-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } case "04": { returnString = "April-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } case "05": { returnString = "May-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } case "06": { returnString = "June-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } case "07": { returnString = "July-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } case "08": { returnString = "August-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } case "09": { returnString = "September-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } case "10": { returnString = "October-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } case "11": { returnString = "November-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } case "12": { returnString = "December-" + MonthLs[MonthLs.Count - 1].Split('-')[1] + "_" + valueLs[valueLs.Count - 1].ToString(); break; } } return(returnString); }