/// <summary>
/// 将指定人员的数据从数据库读取并显示，方便编辑人员信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void 编辑ToolStripMenuItem_Click(object sender, EventArgs e)
{
SchoolInfoInit();
PersonnelManagement personnelManagement = new PersonnelManagement();
int rowIndex = dgvPerson.CurrentRow.Index; //获取选择行号
tbUID.Text = dgvPerson.Rows[rowIndex].Cells[0].Value.ToString();
uint uID = (UInt32)Convert.ToInt32(tbUID.Text);
int index = personnelManagement.uIDtoIndex(uID);
if (index < 0)
{
output("数据库中没有指定ID用户");
return;
}
tbName.Text = personnelManagement.PersonList[index].name;
cbSex.Text = personnelManagement.PersonList[index].sex;
tbStudentID.Text = personnelManagement.PersonList[index].studentID;
string domitory = personnelManagement.PersonList[index].dormitory;
byte one = (byte)domitory.LastIndexOf("）");
string Building = domitory.Substring(0, one + 1);
string Floor = domitory.Substring(one + 1, 1);
tbDomitory.Text = domitory.Substring(one + 2, 3);
if (cbBuilding.Items.Contains(Building))
{
cbBuilding.DropDownStyle = ComboBoxStyle.DropDownList;
cbBuilding.Text = Building;
}
else
{
cbBuilding.DropDownStyle = ComboBoxStyle.Simple;
cbBuilding.Text = Building;
}
if (cbFloor.Items.Contains(Floor))
{
cbFloor.DropDownStyle = ComboBoxStyle.DropDownList;
cbFloor.Text = Floor;
}
else
{
cbFloor.DropDownStyle = ComboBoxStyle.Simple;
cbFloor.Text = Floor;
}
cbActiveState.Checked = personnelManagement.PersonList[index].activeState == 0 ? false : true;
string authority = personnelManagement.PersonList[index].authority;
cbAuthority = CheckBoxComboBoxOP.checkItem(cbAuthority, authority);
string major = personnelManagement.PersonList[index].major;
one = (byte)major.LastIndexOf(" ");
string Institute = major.Substring(0, one);
string Major = major.Substring(one + 1, major.Length - one - 1);
if (cbInstitute.Items.Contains(Institute))
{
cbInstitute.DropDownStyle = ComboBoxStyle.DropDownList;
cbInstitute.Text = Institute;
}
else
{
cbInstitute.DropDownStyle = ComboBoxStyle.Simple;
cbInstitute.Text = Institute;
}
if (cbMajor.Items.Contains(Major))
{
cbMajor.DropDownStyle = ComboBoxStyle.DropDownList;
cbMajor.Text = Major;
}
else
{
cbMajor.DropDownStyle = ComboBoxStyle.Simple;
cbMajor.Text = Major;
}
//cbInstitute.Text = major.Substring(0, one);
//cbMajor.Text = major.Substring(one + 1, major.Length - one - 1);
tbQQ.Text = personnelManagement.PersonList[index].QQ;
tbWeiXin.Text = personnelManagement.PersonList[index].weiXin;
tbTel.Text = personnelManagement.PersonList[index].tel;
dtpBirthday.Value = DateTime.Parse(personnelManagement.PersonList[index].birthday);
cbIsLimitTime.Checked = personnelManagement.PersonList[index].isLimitTime == 0 ? false : true;
dtpLimitTime.Value = DateTime.Parse(personnelManagement.PersonList[index].limitTime);
tbRFID.Text = personnelManagement.PersonList[index].cardID.ToString("X8");;
tbEigen1.Text = personnelManagement.PersonList[index].eigen[0];
tbEigen2.Text = personnelManagement.PersonList[index].eigen[1];
tbEigen3.Text = personnelManagement.PersonList[index].eigen[2];
tbEigen4.Text = personnelManagement.PersonList[index].eigen[3];
tbEigen5.Text = personnelManagement.PersonList[index].eigen[4];
fPath = Environment.CurrentDirectory + @"\picture\" + tbUID.Text.PadLeft(4, '0') + "_" + tbName.Text + ".jpg";
try
{
if (File.Exists(fPath) != true)
{
output("头像不存在！"); pbPortrait.Image = null; return;
}
pbPortrait.Image = Image.FromFile(Environment.CurrentDirectory + @"\picture\" + tbUID.Text.PadLeft(4, '0') + "_" + tbName.Text + ".jpg");
output("读取信息成功！");
}
catch (Exception ex)
{
output(ex.Message);
}
}
/// <summary>
/// 清空所有文本框的数据，方便下次添加人员
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void 新增toolStripMenuItem1_Click(object sender, EventArgs e)
{
SchoolInfoInit();
string cellString = "";
int rowsCount = dgvPerson.Rows.Count;//获取总人数
if (rowsCount == 0)
{
tbUID.Text = 1.ToString();
}
else
{
cellString = dgvPerson.Rows[rowsCount - 1].Cells[0].Value.ToString().Trim();//初始化为最后一行的用户号
}
tbUID.Text = (rowsCount + 1).ToString();
tbName.Text = null;
cbSex.Text = null;
tbStudentID.Text = null;
tbQQ.Text = null;
tbTel.Text = null;
cbBuilding.Text = null; cbFloor.Text = null; tbDomitory.Text = null;
cbAuthority = CheckBoxComboBoxOP.checkItem(cbAuthority, "");
cbInstitute.Text = null;
cbMajor.Text = null;
tbWeiXin.Text = null;
tbRFID.Text = null;
tbEigen1.Text = null;
tbEigen2.Text = null;
tbEigen3.Text = null;
tbEigen4.Text = null;
tbEigen5.Text = null;
dtpBirthday.Value = DateTime.Now;
pbPortrait.Image = null;
fPath = Environment.CurrentDirectory + @"\picture\defaultAvatar.jpg";
Image pic = Image.FromFile(fPath);
pbPortrait.Image = pic;
if (cellString != "")
{
if (rowsCount != int.Parse(cellString))//如果最后一行用户号不等于用户数，则有空缺的用户号
{
bool isSearch = false;
for (int i = 1; i < rowsCount; i++)//从1号一直搜索到rowsCount - 1号用户
{
isSearch = false;
for (int j = 0; j < rowsCount; j++) //搜索有无第i号用户
{
cellString = dgvPerson.Rows[j].Cells[0].Value.ToString().Trim(); //得到用户号
if (i == int.Parse(cellString))
{
isSearch = true;//如果搜索到有第i号用户，跳出循环，搜索下一用户
break;
}
}
if (isSearch == false)//如果没有搜索到i号用户，证明第i号用户空缺
{
tbUID.Text = i.ToString();
break;
}
}
}
}
}