private void ViewDetail(ZhuiSuItem item) { this.NavigationService.Navigate(new ZhuiSuRealTimePage() { AlarmTemporaryDID = item.Iden }); }
private void ViewDetail(ZhuiSuItem item) { this.NavigationService.Navigate(new ZhuiSuHistoryPage() { IdneDID = item.Iden }); }
/// <summary> /// 获取实时追溯信息2 /// </summary> /// <param name="processDID">当前选择的工序</param> /// <param name="pageNo"></param> /// <param name="pageSize"></param> /// <returns></returns> public IPagedList <ZhuiSuItem> GetPagedZhuiSuData2(int?processDID, int pageNo, int pageSize) { DataTable tb = getPagedZhuiSuData2(processDID); List <ZhuiSuItem> lst = new List <ZhuiSuItem>(); if (tb != null && tb.Rows.Count > 0) { foreach (DataRow row in tb.Rows) { ZhuiSuItem info = new ZhuiSuItem(); info.Iden = int.Parse(row[0].ToString()); info.ProductNo = row[1].ToString(); info.BatteryBarCode = row[2].ToString(); info.DeviceGroupDID = row[35].ToString(); info.ProcessDID = row[38].ToString(); info.No = row[4].ToString(); info.StartDate = DateTime.Parse(row[5].ToString()); info.Result = int.Parse(row[6].ToString()); info.LocateReturn = row[7].ToString(); info.LocateErrcode = int.Parse(row[8].ToString()); info.LsideReturn = row[9].ToString(); info.LsideErrcode = int.Parse(row[10].ToString()); info.RsideReturn = row[11].ToString(); info.RsideErrcode = int.Parse(row[12].ToString()); info.TailReturn = row[13].ToString(); info.TailErrcode = int.Parse(row[14].ToString()); info.MainBodyWidthTop = double.Parse(row[15].ToString()); info.MainBodyWidthButtom = double.Parse(row[16].ToString()); info.MainBodyHeight = double.Parse(row[17].ToString()); info.SideLeftFoldingHightTop = double.Parse(row[18].ToString()); info.SideLeftFoldingHightButtom = double.Parse(row[19].ToString()); info.SideRightFoldingHightTop = double.Parse(row[20].ToString()); info.SideRightFoldingHightButtom = double.Parse(row[21].ToString()); info.SideThickness1 = double.Parse(row[22].ToString()); info.FinalResult = row[23].ToString(); info.EndProductno = row[30].ToString(); info.Operator = row[32].ToString(); lst.Add(info); } } IQueryable <ZhuiSuItem> superset = lst.AsQueryable(); return(new PagedList <ZhuiSuItem>(superset, pageNo, pageSize)); }
/// <summary> /// 获取实时追溯信息 /// </summary> /// <param name="processDID">当前选择的工序</param> /// <param name="pageNo"></param> /// <param name="pageSize"></param> /// <returns></returns> public IPagedList <ZhuiSuItem> GetPagedZhuiSuData(int?processDID, int pageNo, int pageSize) { DataTable tb = getPagedZhuiSuData(processDID); List <ZhuiSuItem> lst = new List <ZhuiSuItem>(); if (tb != null && tb.Rows.Count > 0) { foreach (DataRow row in tb.Rows) { ZhuiSuItem info = new ZhuiSuItem(); info.Iden = int.Parse(row[0].ToString()); info.ProductNo = row[1].ToString(); info.BatteryBarCode = row[2].ToString(); info.DeviceGroupDID = row[60].ToString(); info.ProcessDID = row[57].ToString(); info.FacilityDID = int.Parse(row[5].ToString()); info.No = row[6].ToString(); info.StartDate = DateTime.Parse(row[7].ToString()); info.Result = int.Parse(row[8].ToString()); info.BackReturn = row[9].ToString(); info.BackErrcode = int.Parse(row[10].ToString()); info.FrontRetrun = row[11].ToString(); info.FrontErrcode = int.Parse(row[12].ToString()); info.HipotReturn = row[13].ToString(); info.HipotErrcode = int.Parse(row[14].ToString()); info.SidestripHeight = double.Parse(row[15].ToString()); info.SidestripWidth = double.Parse(row[16].ToString()); info.TopstripHeight = double.Parse(row[17].ToString()); info.MainBodyWidth = double.Parse(row[18].ToString()); info.MainBodyHeight = double.Parse(row[19].ToString()); info.DistanceBetweenTabs = double.Parse(row[20].ToString()); info.DistanceBetweenTab1Left = double.Parse(row[21].ToString()); info.DistanceBetwwnTab2Left = double.Parse(row[22].ToString()); info.BagAreaWidth = double.Parse(row[23].ToString()); info.TabALToSlotDistanceRight = double.Parse(row[24].ToString()); info.TabALToSlotDistanceLeft = double.Parse(row[25].ToString()); info.SealantHeightOfLeft1 = double.Parse(row[26].ToString()); info.SealantHeightOfLeft2 = double.Parse(row[27].ToString()); info.SealantHeightOfRight1 = double.Parse(row[28].ToString()); info.SealantHeightOfRight2 = double.Parse(row[29].ToString()); info.SealantToSlotDistanceLeft = double.Parse(row[30].ToString()); info.SealantToSlotDistanceRight = double.Parse(row[31].ToString()); info.measmode = int.Parse(row[33].ToString()); info.SidePoint1 = double.Parse(row[34].ToString()); info.SidePoint2 = double.Parse(row[35].ToString()); info.SidePoint3 = double.Parse(row[36].ToString()); info.TopPoint1 = double.Parse(row[37].ToString()); info.TopPoint2 = double.Parse(row[38].ToString()); info.TopPoint3 = double.Parse(row[39].ToString()); info.TabPoint1 = double.Parse(row[40].ToString()); info.TabPoint2 = double.Parse(row[41].ToString()); info.EndProductno = row[48].ToString(); info.Operator = row[53].ToString(); lst.Add(info); } } IQueryable <ZhuiSuItem> superset = lst.AsQueryable(); return(new PagedList <ZhuiSuItem>(superset, pageNo, pageSize)); }
/// <summary> /// 获取历史追溯记录2 /// </summary> /// <param name="keyword"></param> /// <param name="TimeStart"></param> /// <param name="TimeEnd"></param> /// <param name="pageNo"></param> /// <param name="pageSize"></param> /// <returns></returns> public IPagedList <ZhuiSuItem> GetPagedZhuiSuHistory2(string Keyword, DateTime?TimeStart, DateTime?TimeEnd, int PageNum, int PageSize) { string connectionString_ATL = @"server=127.0.0.1;database=IFactory;uid=root;pwd=root;Persist Security Info=True;Charset=utf8;"; MySqlConnection connatl = new MySqlConnection(connectionString_ATL); connatl.Open(); string sql = ""; sql = @"select *,c.craft_name from autoinspection2_facility_production_data auto join craft c on c.craft_did=auto.process_did join device_group de on de.device_group_did = auto.device_group_did where"; string w1 = " auto.batteryBarCode like '%" + Keyword + "%'"; if (TimeStart.ToString() != "") { w2 = TimeStart.HasValue ? " and auto.StartDate >= '" + TimeStart.Value.ToString() + "' " : ""; } if (TimeEnd.ToString() != "") { w3 = TimeStart.HasValue ? " and auto.StartDate < '" + TimeEnd.Value.AddDays(1.0).ToString() + "' " : ""; } else { TimeEnd = TimeStart; } string w4 = " order by auto.StartDate DESC"; MySqlDataAdapter b = new MySqlDataAdapter(sql + w1 + w2 + w3 + w4, connatl); DataTable bt = new DataTable(); b.Fill(bt); connatl.Close(); List <ZhuiSuItem> lstZ = new List <ZhuiSuItem>(); if (bt != null && bt.Rows.Count > 0) { foreach (DataRow row in bt.Rows) { ZhuiSuItem info = new ZhuiSuItem(); info.Iden = int.Parse(row[0].ToString()); info.ProductNo = row[1].ToString(); info.BatteryBarCode = row[2].ToString(); info.DeviceGroupDID = row[35].ToString(); info.ProcessDID = row[38].ToString(); info.No = row[4].ToString(); info.StartDate = DateTime.Parse(row[5].ToString()); info.Result = int.Parse(row[6].ToString()); info.LocateReturn = row[7].ToString(); info.LocateErrcode = int.Parse(row[8].ToString()); info.LsideReturn = row[9].ToString(); info.LsideErrcode = int.Parse(row[10].ToString()); info.RsideReturn = row[11].ToString(); info.RsideErrcode = int.Parse(row[12].ToString()); info.TailReturn = row[13].ToString(); info.TailErrcode = int.Parse(row[14].ToString()); info.MainBodyWidthTop = double.Parse(row[15].ToString()); info.MainBodyWidthButtom = double.Parse(row[16].ToString()); info.MainBodyHeight = double.Parse(row[17].ToString()); info.SideLeftFoldingHightTop = double.Parse(row[18].ToString()); info.SideLeftFoldingHightButtom = double.Parse(row[19].ToString()); info.SideRightFoldingHightTop = double.Parse(row[20].ToString()); info.SideRightFoldingHightButtom = double.Parse(row[21].ToString()); info.SideThickness1 = double.Parse(row[22].ToString()); info.FinalResult = row[23].ToString(); info.EndProductno = row[30].ToString(); info.Operator = row[32].ToString(); lstZ.Add(info); } } IQueryable <ZhuiSuItem> superset = lstZ.AsQueryable(); return(new PagedList <ZhuiSuItem>(superset, PageNum, PageSize)); }
/// <summary> /// 获取历史追溯记录 /// </summary> /// <param name="keyword"></param> /// <param name="TimeStart"></param> /// <param name="TimeEnd"></param> /// <param name="pageNo"></param> /// <param name="pageSize"></param> /// <returns></returns> public IPagedList <ZhuiSuItem> GetPagedZhuiSuHistory(string Keyword, DateTime?TimeStart, DateTime?TimeEnd, int PageNum, int PageSize) { string connectionString_ATL = @"server=127.0.0.1;database=IFactory;uid=root;pwd=root;Persist Security Info=True;Charset=utf8;"; MySqlConnection connatl = new MySqlConnection(connectionString_ATL); connatl.Open(); string sql = ""; sql = @"select *,c.craft_name from autoinspection1_facility_production_data auto join craft c on c.craft_did=auto.process_did join device_group de on de.device_group_did = auto.device_group_did where"; string w1 = " auto.batteryBarCode like '%" + Keyword + "%'"; if (TimeStart.ToString() != "") { w2 = TimeStart.HasValue ? " and auto.StartDate >= '" + TimeStart.Value.ToString() + "' " : ""; } if (TimeEnd.ToString() != "") { w3 = TimeStart.HasValue ? " and auto.StartDate < '" + TimeEnd.Value.AddDays(1.0).ToString() + "' " : ""; } else { TimeEnd = TimeStart; } string w4 = " order by auto.StartDate DESC"; MySqlDataAdapter b = new MySqlDataAdapter(sql + w1 + w2 + w3 + w4, connatl); DataTable bt = new DataTable(); b.Fill(bt); connatl.Close(); List <ZhuiSuItem> lstZ = new List <ZhuiSuItem>(); if (bt != null && bt.Rows.Count > 0) { foreach (DataRow row in bt.Rows) { ZhuiSuItem info = new ZhuiSuItem(); info.Iden = int.Parse(row[0].ToString()); info.ProductNo = row[1].ToString(); info.BatteryBarCode = row[2].ToString(); info.DeviceGroupDID = row[60].ToString(); info.ProcessDID = row[57].ToString(); info.FacilityDID = int.Parse(row[5].ToString()); info.No = row[6].ToString(); info.StartDate = DateTime.Parse(row[7].ToString()); info.Result = int.Parse(row[8].ToString()); info.BackReturn = row[9].ToString(); info.BackErrcode = int.Parse(row[10].ToString()); info.FrontRetrun = row[11].ToString(); info.FrontErrcode = int.Parse(row[12].ToString()); info.HipotReturn = row[13].ToString(); info.HipotErrcode = int.Parse(row[14].ToString()); info.SidestripHeight = double.Parse(row[15].ToString()); info.SidestripWidth = double.Parse(row[16].ToString()); info.TopstripHeight = double.Parse(row[17].ToString()); info.MainBodyWidth = double.Parse(row[18].ToString()); info.MainBodyHeight = double.Parse(row[19].ToString()); info.DistanceBetweenTabs = double.Parse(row[20].ToString()); info.DistanceBetweenTab1Left = double.Parse(row[21].ToString()); info.DistanceBetwwnTab2Left = double.Parse(row[22].ToString()); info.BagAreaWidth = double.Parse(row[23].ToString()); info.TabALToSlotDistanceRight = double.Parse(row[24].ToString()); info.TabALToSlotDistanceLeft = double.Parse(row[25].ToString()); info.SealantHeightOfLeft1 = double.Parse(row[26].ToString()); info.SealantHeightOfLeft2 = double.Parse(row[27].ToString()); info.SealantHeightOfRight1 = double.Parse(row[28].ToString()); info.SealantHeightOfRight2 = double.Parse(row[29].ToString()); info.SealantToSlotDistanceLeft = double.Parse(row[30].ToString()); info.SealantToSlotDistanceRight = double.Parse(row[31].ToString()); info.measmode = int.Parse(row[33].ToString()); info.SidePoint1 = double.Parse(row[34].ToString()); info.SidePoint2 = double.Parse(row[35].ToString()); info.SidePoint3 = double.Parse(row[36].ToString()); info.TopPoint1 = double.Parse(row[37].ToString()); info.TopPoint2 = double.Parse(row[38].ToString()); info.TopPoint3 = double.Parse(row[39].ToString()); info.TabPoint1 = double.Parse(row[40].ToString()); info.TabPoint2 = double.Parse(row[41].ToString()); info.EndProductno = row[48].ToString(); info.Operator = row[53].ToString(); lstZ.Add(info); } } IQueryable <ZhuiSuItem> superset = lstZ.AsQueryable(); return(new PagedList <ZhuiSuItem>(superset, PageNum, PageSize)); }