private void dataGridView_Car_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0 && dataGridView_Grouping.RowCount > 0)
{
string kchp = (sender as DataGridView).Rows[e.RowIndex].Cells["考车号牌"].Value.ToString();
int rowIndex = dataGridView_Grouping.SelectedCells[0].RowIndex;
string kcxh = dataGridView_Grouping.Rows[rowIndex].Cells["考场序号"].Value.ToString();
string kscc = dataGridView_Grouping.Rows[rowIndex].Cells["考试场次"].Value.ToString();
string qdxm = null;
TMRIWriteResponse response;
if (TMRIWrite.WriteCarAllocation(out response, kchp, kcxh, kscc, qdxm))
{
MessageBox.Show("考试车辆分配成功");
(sender as DataGridView).Rows[e.RowIndex].Cells["身份证明号码"].Value = response.message;
// string sql = $"update BAS_GROUPING_DETAIL set CAR_ID=(select ID from BAS_CAR where LICENSE_PLATE={kchp}) where STUDENT_ID=(select ID from BAS_STUDENT where IDNUMBER={response.message})";
string sql = $"update BAS_BOOKING " +
$"set EXAMINER1_ID=(select EXAMINER_ID from BAS_GROUPING where PLACE_ID=(select ID from BAS_PLACE where SEQUENCENUMBER='{kcxh}') and ROWNUM=1), " +
$"CAR_ID=(select ID from BAS_CAR where LICENSE_PLATE='{kchp}')" +
$" where STUDENT_ID=(select ID from BAS_STUDENT where IDNUMBER='{response.message}')";
mDBM.Select(sql);
dataGridView_GroupingDetail.DataSource = mDBM.Select(groupingDetailQuerySql).Tables[0];
}
else if (null != response)
{
MessageBox.Show($"Error: {response.code}\nMessage: {response.message}", "错误");
}
}
}
private void button_CarAllocation_Click(object sender, EventArgs e)
{
int rowIndex = dataGridView_Grouping.SelectedCells[0].RowIndex;
string kcxh = dataGridView_Grouping.Rows[rowIndex].Cells["考场序号"].Value.ToString();
string kscc = dataGridView_Grouping.Rows[rowIndex].Cells["考试场次"].Value.ToString();
string qdxm = null;
TMRIWriteResponse response;
for (int i = 0; i < dataGridView_Car.RowCount; i++)
{
string kchp = dataGridView_Car.Rows[i].Cells["考车号牌"].Value.ToString();
if (TMRIWrite.WriteCarAllocation(out response, kchp, kcxh, kscc, qdxm))
{
dataGridView_Car.Rows[i].Cells["身份证明号码"].Value = response.message;
string sql = $"update BAS_GROUPING_DETAIL set CAR_ID=(select ID from BAS_CAR where LICENSE_PLATE={kchp}) where STUDENT_ID=(select ID from BAS_STUDENT where IDNUMBER={response.message})";
mDBM.Select(sql);
}
else if (null != response)
{
MessageBox.Show($"Error: {response.code}\nMessage: {response.message}", "错误");
}
}
dataGridView_GroupingDetail.DataSource = mDBM.Select(groupingDetailQuerySql).Tables[0];
MessageBox.Show("全部考试车辆分配成功");
}
private void button_CheckIn_Click(object sender, EventArgs e)
{
int index = dataGridView_booking.SelectedCells[0].RowIndex;
TMRIWriteResponse response;
string sfzmhm = dataGridView_booking.Rows[index].Cells["身份证明号码"].Value.ToString();
string kskm = dataGridView_booking.Rows[index].Cells["考试科目"].Value.ToString();
string kcxh = dataGridView_booking.Rows[index].Cells["考场序号"].Value.ToString();
string kscc = dataGridView_booking.Rows[index].Cells["考试场次"].Value.ToString();
if (TMRIWrite.WriteCheckIn(out response, sfzmhm, kskm, kcxh, kscc, null))
{
MessageBox.Show(response.message);
string sql = $"update BAS_BOOKING set SIGN_STATUS=1 where ID={dataGridView_booking.Rows[index].Cells["序号"].Value.ToString()}";
mDBM.Select(sql);
dataGridView_booking.DataSource = mDBM.Select(bookingQuerySql).Tables[0];
}
else if (null != response)
{
MessageBox.Show($"Error: {response.code}\nMessage: {response.message}", "错误");
}
}
