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