public ByDays()
{
InitializeComponent();
for (int i = 0; i < 7; i++)
{
Day_Info di = new Day_Info();
di.order_idx = new List <int>();
DayData.Add(di);
}
GetValue();
SetChart();
}
private void GetValue()
{
string connStr = "Server=10.80.162.193;Database=mcdonald_kiosk;Uid=root;Pwd=kmk5632980;";
using (MySqlConnection conn = new MySqlConnection(connStr))
{
conn.Open();
string sql = "SELECT * FROM ordering ORDER BY order_idx DESC";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
string tempDate = "temp";
int dayCnt = -1;
while (rdr.Read())
{
if (dayCnt >= 6)
{
break;
}
Day_Info tempDay = new Day_Info();
tempDay.order_idx = new List <int>();
if (((DateTime)rdr["order_time"]).Day.ToString().Equals(tempDate))
{
DayData[dayCnt].order_idx.Add(int.Parse(rdr["order_idx"].ToString()));
}
else
{
tempDate = ((DateTime)rdr["order_time"]).Day.ToString();
tempDay.date = (DateTime)rdr["order_time"];
tempDay.order_idx.Add(int.Parse(rdr["order_idx"].ToString()));
DayData[dayCnt + 1] = tempDay;
dayCnt++;
}
Hour_Info hourInfo = new Hour_Info();
hourInfo.hour = ((DateTime)rdr["order_time"]).Hour.ToString();
hourInfo.orderNum = int.Parse(rdr["order_idx"].ToString());
HourData.Add(hourInfo);
}
rdr.Close();
}
using (MySqlConnection conn = new MySqlConnection(connStr))
{
conn.Open();
string sql = "SELECT * FROM ordered_menu ORDER BY ordered_idx DESC";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
int cnt = 0;
int payCnt = 0;
string pastIdx = "temp";
while (rdr.Read())
{
Day_Info tempDI = new Day_Info();
if (rdr["order_idx"].ToString().Equals(pastIdx))
{
payCnt++;
}
else
{
Console.WriteLine("!");
payCnt = 0;
pastIdx = rdr["order_idx"].ToString();
}
for (int i = 0; i < DayData.Count; i++)
{
foreach (int idx in DayData[i].order_idx)
{
if (rdr["order_idx"].ToString().Equals(idx.ToString()))
{
tempDI = DayData[i];
tempDI.Selling += int.Parse(rdr["total"].ToString());
DayData[i] = tempDI;
cnt++;
}
}
}
for (int i = 0; i < HourData.Count; i++)
{
if (HourData[i].orderNum.ToString().Equals(rdr["order_idx"].ToString()))
{
int hour = int.Parse(HourData[i].hour);
Console.WriteLine(hour);
if (hour >= 6 && hour <= 12)
{
PricePerTime[0] += int.Parse(rdr["total"].ToString());
break;
}
else if (hour > 12 && hour <= 24)
{
PricePerTime[1] += int.Parse(rdr["total"].ToString());
break;
}
else
{
PricePerTime[2] += int.Parse(rdr["total"].ToString());
break;
}
}
}
}
rdr.Close();
}
}
