public void Manger_Load(object sender, EventArgs e)
{
int a = 0;
DataTable dt = new DataTable();
System.DateTime currentTime = new System.DateTime();
currentTime = System.DateTime.Now;
string tody_time = currentTime.ToString("d");
string moth_time = currentTime.ToString("yyyy/M");
string year_time = currentTime.ToString("yy");
moth_time = moth_time + "%";
year_time = "20" + year_time + "/%";
string G_d_sql1 = "select sum(O_food_sale_num*O_price) from food_order where O_food_data='" + tody_time + "'", G_d_sql2 = "select O_food_name from food_order where O_food_sale_num=(SELECT Max(O_food_sale_num) FROM food_order where O_food_data='" + tody_time + "') and O_food_data='" + tody_time + "'";
string G_m_sql1 = "select sum(O_food_sale_num*O_price) from food_order where O_food_data LIKE '" + moth_time + "'", G_m_sql2 = "select O_food_name from food_order where O_food_sale_num=(SELECT Max(O_food_sale_num) FROM food_order where O_food_data LIKE'" + moth_time + "') and O_food_data LIKE '" + moth_time + "'";
string G_y_sql1 = "select sum(O_food_sale_num*O_price) from food_order where O_food_data LIKE '" + year_time + "'", G_y_sql2 = "select O_food_name from food_order where O_food_sale_num=(SELECT Max(O_food_sale_num) FROM food_order where O_food_data LIKE'" + year_time + "') and O_food_data LIKE '" + year_time + "'";
DBOperation.BindDB(dataGridView1, sql, "food_list");
DBOperation.BindDB(dataGridView2, "select * from food_order", "food_order");
M_l_todaysum.Text = print(G_d_sql1);
M_l_todaynum.Text = print(G_d_sql2);
M_l_mouthsum.Text = print(G_m_sql1);
M_l_mouthnum.Text = print(G_m_sql2);
M_l_yearsum.Text = print(G_y_sql1);
M_l_yearnum.Text = print(G_y_sql2);
}
private void FInsert_Click(object sender, EventArgs e)
{
M_insert M_I = new M_insert();
M_I.ShowDialog();
DBOperation.BindDB(dataGridView1, sql, "food_list");
}
