private void btnSearch_Click(object sender, EventArgs e)
{
SelectDate sd = new SelectDate();
if (sd.ShowDialog() == DialogResult.Yes)
{
var DateStart = string.Empty;
var DateEnd = string.Empty;
if (chk8x8.Checked)
{
DateStart = sd.dtpStart.Value.ToString("yyyy-MM-dd 08:10:00");
DateEnd = sd.dtpEnd.Value.AddDays(1).ToString("yyyy-MM-dd 08:10:00");
}
else
{
DateStart = sd.dtpStart.Value.ToString("yyyy-MM-dd 00:00:00");
DateEnd = sd.dtpEnd.Value.ToString("yyyy-MM-dd 23:59:59");
}
dgvEwproject.DataSource = GetSQL.DrymcseRecordTime("FF", "補線機", DateStart, DateEnd);
dgvEwproject.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dgvAOI.DataSource = GetSQL.AOIChkReportNO(DateStart, DateEnd);
dgvAOI.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
lblEwprojectCount.Text = "筆數：" + Convert.ToInt32(dgvEwproject.Rows.Count);
lblAOICount.Text = "筆數：" + Convert.ToInt32(dgvAOI.Rows.Count);
}
else
{
sd.Dispose();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
SelectDate sd = new SelectDate();
if (sd.ShowDialog() == DialogResult.Yes)
{
dgvMain.DataSource = GetSQL.Get乾膜AOI檢查日報紀錄(sd.dtpStart.Value.ToString("yyyy-MM-dd 00:00:00"),
sd.dtpEnd.Value.ToString("yyyy-MM-dd 00:00:00"));
dgvMain.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
if (dgvMain.Rows.Count > 0)
{
dgvMain.Focus();
dgvMain.CurrentCell = dgvMain[0, 0];
}
}
else
{
sd.Dispose();
}
}
