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); } }