} // O private void SerialSearch_Click_1(object sender, EventArgs e) { String SearchedNum = SerialNum.Text; MySqlConnection myConnection = new MySqlConnection(connectionString); myConnection.Open(); ProductInfoDAC dac = new ProductInfoDAC(myConnection); myConnection.Close(); ProductGrid.DataSource = dac.SearchSerialNum(SearchedNum).Tables["serial"]; } // O
} // O private void ProductDateTime_ValueChanged_1(object sender, EventArgs e) { string date = ProductDateTime.Value.ToString("yyyy-MM-dd"); MySqlConnection myConnection = new MySqlConnection(connectionString); myConnection.Open(); ProductInfoDAC dac = new ProductInfoDAC(myConnection); myConnection.Close(); ProductGrid.DataSource = dac.SearchProductDate(date).Tables["productDate"]; ProductGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } // O
private void SelectYear_SelectedIndexChanged(object sender, EventArgs e) { MySqlConnection myConnection = new MySqlConnection(connectionString); myConnection.Open(); ProductInfoDAC dac = new ProductInfoDAC(myConnection); MonthlyProductionChart.Series[0].XValueMember = "m"; MonthlyProductionChart.Series[0].YValueMembers = "COUNT(*)"; MonthlyProductionChart.DataSource = dac.SearchMonthly(Convert.ToInt16(SelectYear.Text)).Tables["month"]; MonthlyProductionChart.DataBind(); // 차트 타입 MonthlyProductionChart.Series[0].ChartType = SeriesChartType. myConnection.Close(); } // O
} // O private void SelectMonth_SelectedIndexChanged_2(object sender, EventArgs e) { int sel = SelectMonth.SelectedIndex; string month = SelectMonth.Text; MySqlConnection myConnection = new MySqlConnection(connectionString); myConnection.Open(); ProductInfoDAC dac = new ProductInfoDAC(myConnection); dailyProductionChart.Series[0].XValueMember = "m"; dailyProductionChart.Series[0].YValueMembers = "COUNT(*)"; dailyProductionChart.DataSource = dac.SearchDaily(sel, month).Tables["day"]; dailyProductionChart.DataBind(); myConnection.Close(); } // O