private void RefreshData()
{
RecvDataFromDBHelper recvData = new RecvDataFromDBHelper();
var data = recvData.ReveiveAllUserInfo();
dgvUsersInfo.DataSource = data;
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (CheckInputInfo())
{
try
{
RecvDataFromDBHelper recvDataFromDBHelper = new RecvDataFromDBHelper();
if (recvDataFromDBHelper.JudgeIfManagerExist(GetManager()))
{
MessageBox.Show("身份验证通过！");
this.BeginInvoke(new Action(() =>
{
this.Close();
}));
isManager = true;
}
else
{
MessageBox.Show("验证未通过！身份信息错误！");
isManager = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
isManager = false;
}
}
}
private static List <LeaveMessage> GetBaseData()
{
RecvDataFromDBHelper recvDataFromDBHelper = new RecvDataFromDBHelper();
var data = recvDataFromDBHelper.ReceiveLeaveMsg();
var newData = data.OrderByDescending(x => x.LeaveTime).ToList();
return(newData);
}
private void SetID()
{
RecvDataFromDBHelper recvDataFromDBHelper = new RecvDataFromDBHelper();
var count = recvDataFromDBHelper.ReveiveAllUserInfo().ToList().Count;
for (int i = 1; i <= count; i++)
{
dataGridView1.Rows[i - 1].Cells["ID"].Value = i;
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (CheckInputInfo())
{
//Thread th = new Thread(() =>
// {
try
{
RecvDataFromDBHelper recvDataFromDBHelper = new RecvDataFromDBHelper();
if (recvDataFromDBHelper.JudgeIfManagerExist(GetManager()))
{
MessageBox.Show("身份验证通过！");
this.BeginInvoke(new Action(() =>
{
this.Close();
}));
isManager = true;
}
else
{
MessageBox.Show("验证未通过！身份信息错误！");
isManager = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
isManager = false;
}
// });
//th.IsBackground = true;
//th.Start();
//主线程卡死
//this.BeginInvoke(new Action(() =>
//{
// RecvDataFromDBHelper recvDataFromDBHelper = new RecvDataFromDBHelper();
// if (recvDataFromDBHelper.JudgeIfManagerExist(GetManager()))
// {
// MessageBox.Show("身份验证通过！");
// isManager = true;
// this.Close();
// }
// else
// {
// MessageBox.Show("验证未通过！身份信息错误！");
// isManager = false;
// }
//}));
}
}
private void btnQuery_Click(object sender, EventArgs e)
{
if (!CheckInput())
{
return;
}
var RealName = textBox1.Text;
var type = "";
if (cboChooseType.SelectedItem.ToString() == "实验表")
{
type = "experiment";
}
if (cboChooseType.SelectedItem.ToString() == "课程表")
{
type = "course";
}
RecvDataFromDBHelper recvDataFromDBHelper = new RecvDataFromDBHelper();
var pictures = recvDataFromDBHelper.ReveicePicture(RealName, type);
if (pictures == null)
{
MessageBox.Show("未找到信息表！");
return;
}
if (pictures.Count == 1)
{
//将图片显示
var picture = pictures.First().Picture;
if (picture == null)
{
MessageBox.Show("未找到信息表！");
return;
}
//将字节数组转换为图片并加以显示
MemoryStream ms = new MemoryStream(picture);
Image image = Image.FromStream(ms);
picTimeTable.Image = image;
}
}
//当前只显示用户名未显示用户真实姓名
private void ShowSignInfo()
{
try
{
RecvDataFromDBHelper recvDataFromDBHelper = new RecvDataFromDBHelper();
var users = recvDataFromDBHelper.ReveiveAllUserInfo();
var signInfos = recvDataFromDBHelper.ReceiveTodaySignInfo();
var data = new List <PersonSignInfo>();
foreach (var item in users)
{
var signInfo = new PersonSignInfo();
foreach (var item1 in signInfos)
{
if (item.UserNickName == item1.UserNickName)
{
signInfo.UserNickName = item.UserNickName;
signInfo.SignTime = item1.SignTime;
signInfo.IsSign = true;
data.Add(signInfo);
break;
}
}
if (signInfo.UserNickName == null)
{
signInfo.UserNickName = item.UserNickName;
signInfo.IsSign = false;
data.Add(signInfo);
}
}
dataGridView1.DataSource = data;
//显示真实姓名
var nickNames = new List <string>();
foreach (DataGridViewRow item in dataGridView1.Rows)
{
nickNames.Add(item.Cells["UserNickName"].Value.ToString());
}
var newColumn = new DataGridViewTextBoxColumn();
if (dataGridView1.Columns["RealName"] == null)
{
//获取到真实姓名
newColumn.HeaderText = "真实姓名";
newColumn.Name = "RealName";
}
var RealNames = recvDataFromDBHelper.ReceiveRealName(nickNames);
if (count == 0)
{
dataGridView1.Columns.Add(newColumn);
}
count++;
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
dataGridView1.Rows[i].Cells["RealName"].Value = RealNames[i];
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
