//当前只显示用户名未显示用户真实姓名
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);
}
}
