private void btn_download_Click(object sender, EventArgs e)
{
string message;
TMRIQuery.QueryExaminator(out message, textBox_fzjg.Text, textBox_glbm.Text, textBox_gxsj.Text);
MessageBox.Show(message);
dataGridView_examiner.DataSource = mDBM.Select(examinerViewSQL).Tables[0];
}
private void btn_download_Click(object sender, EventArgs e)
{
string message;
TMRIQuery.QueryGroup(out message, textBox_glbm.Text, comboBox_kskm.Text, dateTimePicker_ksrq.Value, textBox_kcxh.Text, comboBox_kscx.Text, comboBox_kscc.Text);
MessageBox.Show(message);
dataGridView_Grouping.DataSource = mDBM.Select(groupingQuerySql).Tables[0];
}
private void btn_download_Click(object sender, EventArgs e)
{
string message;
TMRIQuery.QueryPlace(out message, textBox_fzjg.Text, comboBox_kskm.Text, dateTimePicker_gxsj.Checked ? dateTimePicker_gxsj.Value.ToString("yyyy-MM-dd HH:mm:ss") : null);
MessageBox.Show(message);
dataGridView_place.DataSource = mDBM.Select(placeViewSQL).Tables[0];
}
private void btn_download_Click(object sender, EventArgs e)
{
string message;
TMRIQuery.QuerySchool(out message, textBox_fzjg.Text, textBox_gxsj.Text);
MessageBox.Show(message);
dataGridView_school.DataSource = mDBM.Select(schoolViewSQL).Tables[0];
}
private void btn_download_Click(object sender, EventArgs e)
{
string message;
TMRIQuery.QueryBook(out message, comboBox_kskm.Text, dateTimePicker_ksrq.Value, textBox_kcxh.Text, textBox_sfzmhm.Text);
MessageBox.Show(message);
dataGridView_booking.DataSource = mDBM.Select(bookingViewSQL).Tables[0];
}
private void dataGridView_grouping_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
string fzxh = (sender as DataGridView).Rows[e.RowIndex].Cells["分组序号"].Value.ToString();
string message;
TMRIQuery.QueryGroupDetail(out message, fzxh);
MessageBox.Show("分组明细" + message);
dataGridView_GroupingDetail.DataSource = mDBM.Select(groupingDetailQuerySql).Tables[0];
}
}
private void button_TimeSync_Click(object sender, EventArgs e)
{
string message;
bool flag = TMRIQuery.QueryTime(out message, textBox_SystemSerialNumber.Text);
MessageBox.Show(message);
if (flag)
{
MessageBox.Show("时间同步成功");
}
}
private void button_downloadPhoto_Click(object sender, EventArgs e)
{
string message;
Bitmap photo;
if (!TMRIQuery.QueryPhoto(out message, idNo, out photo))
{
MessageBox.Show(message);
return;
}
pictureBox_new.Image = photo;
MemoryStream ms = new MemoryStream();
photo.Save(ms, ImageFormat.Bmp);
photoBytes[1] = ms.ToArray();
MessageBox.Show($"学员：{idNo}照片下载成功");
}
