private void btnSearch_Click(object sender, EventArgs e) { CardConnectForm frmCardConnect = new CardConnectForm(); frmCardConnect.ShowDialog(); if (frmCardConnect.cardNo == "") return; studentsPreregBindingSource.MoveFirst(); while (dgvPreregStudents.SelectedRows[0].Cells["CardNoColumn"].Value.ToString() != frmCardConnect.cardNo && dgvPreregStudents.SelectedRows[0].Index < dgvPreregStudents.Rows.Count - 1) { studentsPreregBindingSource.MoveNext(); } }
private void btnCardConnect_Click(object sender, EventArgs e) { if (dgvStudents.SelectedRows.Count <= 0) return; DataGridViewRow row = dgvStudents.SelectedRows[0]; // 获取卡号 CardConnectForm frmCardConnect = new CardConnectForm(); frmCardConnect.ShowDialog(); if (frmCardConnect.cardNo == "") return; // 查询是否有卡号冲突 DataRow[] rows = studentsDataSet.CardList.Select("CardNo = '" + frmCardConnect.cardNo + "'"); if (rows.Length > 0) { DataRow cardInfoRow = rows[0]; MessageBox.Show("该卡片[" + frmCardConnect.cardNo + "]已被学生[" + cardInfoRow.Field<string>("Name") + "]所使用,请使用新卡片", "卡号已被使用", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; }; // 获取卡号的类型 CardTypeSelectForm frmCardTypeSelect = new CardTypeSelectForm(); if (frmCardTypeSelect.ShowDialog() != DialogResult.OK) return; int cardType = frmCardTypeSelect.CardType; string cardTypeName = ""; switch (cardType) { case 0: cardTypeName = "普通卡"; break; case 1: cardTypeName = "VIP卡"; break; } // 显示确认对话框 ConfirmCardConnectForm frmConfirmCardConnect = new ConfirmCardConnectForm(); frmConfirmCardConnect.CardNo = frmCardConnect.cardNo; frmConfirmCardConnect.CardType = cardTypeName; frmConfirmCardConnect.StudentName = txtName.Text; frmConfirmCardConnect.StudentSex = row.Cells["SexColumn"].Value.ToString(); frmConfirmCardConnect.StudentBirthday = row.Cells["BirthdayColumn"].Value.ToString(); frmConfirmCardConnect.StudentAddress = row.Cells["AddressColumn"].Value.ToString(); frmConfirmCardConnect.StudentPhone = row.Cells["PhoneColumn"].Value.ToString(); frmConfirmCardConnect.StudentFartherName = row.Cells["FartherNameColumn"].Value.ToString(); frmConfirmCardConnect.StudentFartherPhone = row.Cells["FartherTelColumn"].Value.ToString(); frmConfirmCardConnect.StudentFartherWork = row.Cells["FartherWorkColumn"].Value.ToString(); frmConfirmCardConnect.StudentMotherName = row.Cells["MotherNameColumn"].Value.ToString(); frmConfirmCardConnect.StudentMotherPhone = row.Cells["MotherTelColumn"].Value.ToString(); frmConfirmCardConnect.StudentMotherWork = row.Cells["MotherWorkColumn"].Value.ToString(); if (frmConfirmCardConnect.ShowDialog() != DialogResult.OK) return; // 更新卡号信息 studentsTableAdapter.UpdateCardInfo(frmCardConnect.cardNo, cardType, int.Parse(txtID.Text)); // 刷新界面 txtCardNo.Text = frmCardConnect.cardNo; txtCardType.Text = cardTypeName; row.Cells["CardNoColumn"].Value = txtCardNo.Text; row.Cells["CardTypeNameColumn"].Value = cardTypeName; }
private void btnSearchByCardNo_Click(object sender, EventArgs e) { CardConnectForm frmCardConnect = new CardConnectForm(); frmCardConnect.ShowDialog(); if (frmCardConnect.cardNo == "") return; foreach (DataGridViewRow row in dgvStudents.Rows) { if (row.Cells["CardNoColumn"].Value.ToString() == frmCardConnect.cardNo) { studentsBindingSource.Position = row.Index; positionChange(row.Index); return; } } MessageBox.Show("找不到卡号为“" + frmCardConnect.cardNo + "”的学生", "找不到学生", MessageBoxButtons.OK, MessageBoxIcon.Information); }