private void Main_Load(object sender, EventArgs e) { Checkit(); VisibleFalseLabel(); LblCart.Visible = true; LblCartInfo.Visible = true; LblLiveInfo.Visible = true; LblUsingUser.Visible = true; picBoxCheck1.Visible = true; //picBoxCheck2.Visible = true; dataGridView1.Visible = true; btnCart.BackgroundImage = Image.FromFile("menuCart2.jpg"); pictureBox2.BackColor = Color.FromArgb(234, 234, 234); dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.AliceBlue; dataGridView2.AlternatingRowsDefaultCellStyle.BackColor = Color.AliceBlue; dataGridView3.AlternatingRowsDefaultCellStyle.BackColor = Color.AliceBlue; dataGridView1.RowHeadersVisible = false; dataGridView2.RowHeadersVisible = false; dataGridView3.RowHeadersVisible = false; //this.FormBorderStyle = FormBorderStyle.FixedSingle; //쓰레드 시작 fThreadStart(); //오늘 날짜 int nowYear = DateTime.Now.Year; //오늘 년 int nowMonth = DateTime.Now.Month; //오늘 월 string nowWeek = DTPlast1.Value.ToString("dddd"); //오늘 요일 int nowHour = DateTime.Now.Hour; //오늘 시 int nowMinute = DateTime.Now.Minute; //오늘 분 int firstDay = DateTime.Now.Day - 7; //일주일 전 날짜 int lastDay = DateTime.Now.Day; //오늘 날짜 //총매출액 그래프 날짜 DTPfirst1.Value = new DateTime(nowYear, nowMonth, firstDay); DTPlast1.Value = new DateTime(nowYear, nowMonth, lastDay); //상품별 매출액 그래프 날짜 DTPfirst2.Value = new DateTime(nowYear, nowMonth, firstDay); DTPlast2.Value = new DateTime(nowYear, nowMonth, lastDay); int firstyear1 = DTPfirst1.Value.Year; int firstmonth1 = DTPfirst1.Value.Month; int firstday1 = DTPfirst1.Value.Day; int lastyear1 = DTPlast1.Value.Year; int lastmonth1 = DTPlast1.Value.Month; int lastday1 = DTPlast1.Value.Day; int firstyear2 = DTPfirst2.Value.Year; int firstmonth2 = DTPfirst2.Value.Month; int firstday2 = DTPfirst2.Value.Day; int lastyear2 = DTPlast2.Value.Year; int lastmonth2 = DTPlast2.Value.Month; int lastday2 = DTPlast2.Value.Day; //총매출액 그래프 string Querysale = "SELECT date_format(buydate, '%m-%d') AS date, sum(price) FROM `order` WHERE buydate BETWEEN date('" + firstyear1 + "-" + firstmonth1 + "-" + firstday1 + "') AND date('" + lastyear1 + "-" + lastmonth1 + "-" + lastday1 + "') GROUP BY buydate"; string constring = "datasource=localhost; database=smartcart; username=root; password=apmsetup;"; MySqlConnection consaleDB = new MySqlConnection(constring); MySqlCommand cmdsaleDB = new MySqlCommand(Querysale, consaleDB); MySqlDataReader myreadersale; consaleDB.Open(); myreadersale = cmdsaleDB.ExecuteReader(); chartSum.Series.Clear(); chartSum.Series.Add("price"); try { while (myreadersale.Read()) { string date = myreadersale.GetString("date"); chartSum.Series["price"].Points.AddXY(date, myreadersale.GetString("sum(price)")); } } catch (Exception ex) { MessageBox.Show(ex.Message); } consaleDB.Close(); //상품별 매출액 그래프 ArrayList ProdList = new ArrayList(); chartProd.Series.Clear(); string QueryPdMenu1 = "SELECT name FROM `product`"; MySqlConnection conPdmenuDB1 = new MySqlConnection(constring); MySqlCommand cmdPdmenuDB1 = new MySqlCommand(QueryPdMenu1, conPdmenuDB1); MySqlDataReader myreaderPdmenu1; try { conPdmenuDB1.Open(); myreaderPdmenu1 = cmdPdmenuDB1.ExecuteReader(); while (myreaderPdmenu1.Read()) { string sName = myreaderPdmenu1.GetString("name"); Series series1 = chartProd.Series.Add(sName); ProdList.Add(sName); } conPdmenuDB1.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } //string QueryPdMenu2 = "SELECT product FROM `order`"; //MySqlConnection conPdMenuDB2 = new MySqlConnection(constring); //MySqlCommand cmdPdmenuDB2 = new MySqlCommand(QueryPdMenu2, conPdMenuDB2); //MySqlDataReader myreaderPdmenu2; //try //{ // conPdMenuDB2.Open(); // myreaderPdmenu2 = cmdPdmenuDB2.ExecuteReader(); // while (myreaderPdmenu2.Read()) // { // string sName = myreaderPdmenu2.GetString("product"); // for (int i = 0; i < ProdList.Count; i++) // { // if (!sName.Equals((string)ProdList[i])) // { // ProdList.Add(sName); // } // } // } // conPdMenuDB2.Close(); //} //catch (Exception ex) //{ // MessageBox.Show(ex.Message + "오오"); //} ArrayList QueryPdCnt = new ArrayList(); for (int i = 0; i < ProdList.Count; i++) { QueryPdCnt.Add($"SELECT date_format(buydate, '%m-%d') AS date, count(product) FROM `order` WHERE product = '{ProdList[i]}' AND buydate BETWEEN date('{firstyear2}-{firstmonth2}-{firstday2}') AND date('{lastyear2}-{lastmonth2}-{lastday2}') GROUP BY buydate"); MySqlConnection conPdCntDB = new MySqlConnection(constring); MySqlCommand cmdPdCntDB = new MySqlCommand((string)QueryPdCnt[i], conPdCntDB); MySqlDataReader myreader; try { conPdCntDB.Open(); myreader = cmdPdCntDB.ExecuteReader(); while (myreader.Read()) { string sCount = myreader.GetString("count(product)"); string sDay = myreader.GetString("date"); chartProd.Series[(string)ProdList[i]].Points.AddXY(sDay, sCount); } conPdCntDB.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message + ProdList.Count + "라라"); } } //실시간 시간 LblNowDate.Text = "" + nowYear + "년 " + nowMonth + "월 " + lastDay + "일 " + nowWeek + " " + nowHour + "시 " + nowMinute + "분"; //로그인 창 띄우기 loginForm = new Login(); loginForm.loginEventHandler += new EventHandler(LoginSuccess); switch (loginForm.ShowDialog()) { case DialogResult.OK: loginForm.Close(); break; case DialogResult.Cancel: Dispose(); break; } //DataGridView1에 Cart 실시간 현황 테이블 생성 string sql = "SELECT * FROM `cart`"; DataTable dt = db.GetDBTable(sql); dataGridView1.DataSource = dt; dataGridView1.Columns["cartNumber"].HeaderText = "카트 번호"; dataGridView1.Columns["cartName"].HeaderText = "카트 이름"; dataGridView1.Columns["usingName"].HeaderText = "사용자 정보"; dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView2.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView3.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //db 행 색깔,폰트 색깔 dataGridView1.EnableHeadersVisualStyles = false; dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.CornflowerBlue; dataGridView1.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dataGridView2.EnableHeadersVisualStyles = false; dataGridView2.ColumnHeadersDefaultCellStyle.BackColor = Color.CornflowerBlue; dataGridView2.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dataGridView3.EnableHeadersVisualStyles = false; dataGridView3.ColumnHeadersDefaultCellStyle.BackColor = Color.CornflowerBlue; dataGridView3.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dataGridView1.ClearSelection(); dataGridView2.ClearSelection(); dataGridView3.ClearSelection(); }
private void Main_Load(object sender, EventArgs e) { Checkit(); VisibleFalseLabel(); LblCart.Visible = true; LblCartInfo.Visible = true; LblLiveInfo.Visible = true; LblUsingUser.Visible = true; picBoxCheck1.Visible = true; //picBoxCheck2.Visible = true; dataGridView1.Visible = true; btnCart.BackgroundImage = Image.FromFile("menuCart2.jpg"); pictureBox2.BackColor = Color.FromArgb(234, 234, 234); dataGridView1.RowHeadersVisible = false; dataGridView2.RowHeadersVisible = false; dataGridView3.RowHeadersVisible = false; // this.FormBorderStyle = FormBorderStyle.FixedSingle; fThreadStart(); //오늘 날짜 int nowYear = DateTime.Now.Year; //오늘 년 int nowMonth = DateTime.Now.Month; //오늘 월 string nowWeek = DTPlast1.Value.ToString("dddd"); //오늘 요일 int nowHour = DateTime.Now.Hour; //오늘 시 int nowMinute = DateTime.Now.Minute; //오늘 분 int firstDay = DateTime.Now.Day - 7; //일주일 전 날짜 int lastDay = DateTime.Now.Day; //오늘 날짜 //총매출액 그래프 날짜 DTPfirst1.Value = new DateTime(nowYear, nowMonth, firstDay); DTPlast1.Value = new DateTime(nowYear, nowMonth, lastDay); //상품별 매출액 그래프 날짜 DTPfirst2.Value = new DateTime(nowYear, nowMonth, firstDay); DTPlast2.Value = new DateTime(nowYear, nowMonth, lastDay); int firstyear = DTPfirst1.Value.Year; int firstmonth = DTPfirst1.Value.Month; int firstday = DTPfirst1.Value.Day; int lastyear = DTPlast1.Value.Year; int lastmonth = DTPlast1.Value.Month; int lastday = DTPlast1.Value.Day; //총매출액 그래프 string Querysale = " select date_format(buydate, '%m-%d') as date, sum(price) from `order` where buydate between date('" + firstyear + "-" + firstmonth + "-" + firstday + "') AND date('" + lastyear + "-" + lastmonth + "-" + lastday + "') group by buydate"; string constring = "server=localhost; database=smartcart; uid=root; password=apmsetup;"; MySqlConnection consaleDB = new MySqlConnection(constring); MySqlCommand cmdsaleDB = new MySqlCommand(Querysale, consaleDB); MySqlDataReader myreadersale; consaleDB.Open(); myreadersale = cmdsaleDB.ExecuteReader(); chartSum.Series.Clear(); Series series = chartSum.Series.Add("price"); try { while (myreadersale.Read()) { string date = myreadersale.GetString("date"); chartSum.Series["price"].Points.AddXY(date, myreadersale.GetString("sum(price)")); } } catch (Exception ex) { MessageBox.Show(ex.Message); } consaleDB.Close(); //실시간 시간 LblNowDate.Text = "" + nowYear + "년 " + nowMonth + "월 " + lastDay + "일 " + nowWeek + " " + nowHour + "시 " + nowMinute + "분"; //로그인 창 띄우기 loginForm = new Login(); loginForm.loginEventHandler += new EventHandler(LoginSuccess); switch (loginForm.ShowDialog()) { case DialogResult.OK: loginForm.Close(); break; case DialogResult.Cancel: Dispose(); break; } //DataGridView1에 Cart 실시간 현황 테이블 생성 string sql = "SELECT * FROM `cart`"; DataTable dt = db.GetDBTable(sql); dataGridView1.DataSource = dt; dataGridView1.Columns["cartNumber"].HeaderText = "카트 번호"; dataGridView1.Columns["cartName"].HeaderText = "카트 이름"; dataGridView1.Columns["usingName"].HeaderText = "사용자 정보"; dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView2.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView3.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //db 행 색깔,폰트 색깔 dataGridView1.EnableHeadersVisualStyles = false; dataGridView1.ColumnHeadersDefaultCellStyle.BackColor = Color.CornflowerBlue; dataGridView1.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dataGridView2.EnableHeadersVisualStyles = false; dataGridView2.ColumnHeadersDefaultCellStyle.BackColor = Color.CornflowerBlue; dataGridView2.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dataGridView3.EnableHeadersVisualStyles = false; dataGridView3.ColumnHeadersDefaultCellStyle.BackColor = Color.CornflowerBlue; dataGridView3.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dataGridView1.ClearSelection(); dataGridView2.ClearSelection(); dataGridView3.ClearSelection(); dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.AliceBlue; dataGridView2.AlternatingRowsDefaultCellStyle.BackColor = Color.AliceBlue; dataGridView3.AlternatingRowsDefaultCellStyle.BackColor = Color.AliceBlue; //선택했을때 흰색배경 dataGridView1.DefaultCellStyle.SelectionBackColor = Color.White; dataGridView2.DefaultCellStyle.SelectionBackColor = Color.White; dataGridView3.DefaultCellStyle.SelectionBackColor = Color.White; //선택했을때 검은색 글자색 dataGridView1.DefaultCellStyle.SelectionForeColor = Color.Black; dataGridView2.DefaultCellStyle.SelectionForeColor = Color.Black; dataGridView3.DefaultCellStyle.SelectionForeColor = Color.Black; dataGridView1.RowHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single; dataGridView1.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single; }