private void setHisAdmissionList(List <AdmissionExit> admissionExits)
{
List <AdmissionExit> admissions = admissionExits.Where(a => a.Model.Equals(AdmissionExit.ADMISSION)).ToList();
daTagListView.Items.Clear();
int length = admissions.Count;
for (int i = 0; i < length; i++)
{
ListViewItem item = new ListViewItem();
item.Text = admissions[i].TagID;
item.Name = admissions[i].TagID;
item.SubItems.Add(admissions[i].Name);
item.SubItems.Add(XwDataUtils.dataFromTimeStamp((Int32)admissions[i].Time)); //入场时间
item.SubItems.Add("--");
String workIDs = "";
for (int j = 0; j < 16; j++)
{
workIDs += admissions[i].WorkIDbyte[j].ToString("X2");
}
item.SubItems.Add(workIDs);
daTagListView.Items.Add(item);
}
}
public void saveCardXlsFile(string filePath)
{
try
{
if (hisAdmissionExits == null)
{
MessageBox.Show("數據發生錯誤！！");
return;
}
List <AdmissionExit> admissions = hisAdmissionExits.Where(a => a.Model.Equals(AdmissionExit.ADMISSION)).ToList();
List <AdmissionExit> exits = hisAdmissionExits.Where(a => a.Model.Equals(AdmissionExit.EXIT)).ToList();
List <ImportAdmissExit> importAdmissionExit = new List <ImportAdmissExit>(); //合并一下进出场数据
int length = admissions.Count;
for (int i = 0; i < length; i++)
{
ImportAdmissExit importData = new ImportAdmissExit();
importData.setAdmissData(admissions[i]);
String endTime = "";
for (int j = 0; j < exits.Count; j++)
{
if (exits[j].TagID.Equals(admissions[i].TagID) && exits[j].Time > admissions[i].Time)
// && admissions[i].Time + 72000 > exits[j].Time) //72000是秒 = 20小时，20小时内应该有一套上下班的
{
endTime = XwDataUtils.dataFromTimeStamp((Int32)exits[j].Time);
break;
}
}
importData.ExitTime = endTime;
importAdmissionExit.Add(importData);
}
Dictionary <string, string> cellheader = new Dictionary <string, string> {
{ "Name", "名稱" },
{ "TagID", "卡片ID" },
{ "WorkID", "進出場ID" },
{ "AdmissTime", "進場時間" },
{ "ExitTime", "出場時間" },
};
string urlPath = ExcelHelper.EntityListToExcel2003(cellheader, importAdmissionExit, filePath, "AdmissionExit", ExcelWeithEnum.ADMISSIONEXIT_PUTONG);
}
catch (Exception ex)
{
Debug.Write("saveCardXlsFile" + ex.Message);
}
}
public static ListViewItem getlvItem(LocationNode loca_node)
{
if (loca_node == null)
{
return(null);
}
if (loca_node.ID_C == null || loca_node.ID_J == null)
{
return(null);
}
ListViewItem lvItem = new ListViewItem();
lvItem.SubItems[0].Text = loca_node.ID_C_str;
lvItem.SubItems.Add(loca_node.ID_J_str);
lvItem.SubItems.Add(loca_node.Version_str);
lvItem.SubItems.Add(XwDataUtils.dataFromTimeStamp(loca_node.TimeStamp));
return(lvItem);
}
/// <summary>
/// 设置历史出厂入场数据给列表
/// </summary>
private void setHisAdmiExitList(List <AdmissionExit> admissionExits)
{
List <AdmissionExit> admissions = admissionExits.Where(a => a.Model.Equals(AdmissionExit.ADMISSION)).ToList();
List <AdmissionExit> exits = admissionExits.Where(a => a.Model.Equals(AdmissionExit.EXIT)).ToList();
daTagListView.Items.Clear();
int length = admissions.Count;
for (int i = 0; i < length; i++)
{
ListViewItem item = new ListViewItem();
item.Text = admissions[i].TagID;
item.Name = admissions[i].TagID;
item.SubItems.Add(admissions[i].Name);
String startTime = XwDataUtils.dataFromTimeStamp((Int32)admissions[i].Time);
item.SubItems.Add(startTime); //入场时间
String endTime = "";
for (int j = 0; j < exits.Count; j++)
{
if (exits[j].TagID.Equals(admissions[i].TagID) && exits[j].Time > admissions[i].Time)
// && admissions[i].Time + 72000 > exits[j].Time) //72000是秒 = 20小时，20小时内应该有一套上下班的
{
endTime = XwDataUtils.dataFromTimeStamp((Int32)exits[j].Time);
break;
}
}
item.SubItems.Add(endTime);//出厂时间
String workIDs = "";
if (admissions[i].WorkIDbyte != null)
{
for (int j = 0; j < 16; j++)
{
workIDs += admissions[i].WorkIDbyte[j].ToString("X2");
}
}
item.SubItems.Add(workIDs);
daTagListView.Items.Add(item);
}
}
/// <summary>
/// 設置所有的歷史進出場數據
/// </summary>
/// <param name="admissionExits"></param>
private void setHisAllAdmiExitList(List <AdmissionExit> admissionExits)
{
listView1.Items.Clear();
int length = admissionExits.Count;
for (int i = 0; i < length; i++)
{
ListViewItem item = new ListViewItem();
item.Text = admissionExits[i].TagID;
item.Name = admissionExits[i].TagID;
item.SubItems.Add(admissionExits[i].Name);
item.SubItems.Add(admissionExits[i].Model);
item.SubItems.Add(XwDataUtils.dataFromTimeStamp((Int32)admissionExits[i].Time)); //進出厂时间
String workIDs = "";
for (int j = 0; j < 16; j++)
{
workIDs += admissionExits[i].WorkIDbyte[j].ToString("X2");
}
item.SubItems.Add(workIDs);
listView1.Items.Add(item);
}
}
