} // 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
