private static void padding_EightCore(Maticsoft.BLL.Report.ImportEventArgs e, Excel.Application xlApp) { Maticsoft.BLL.Pack_Exfo _M_PackExfo = new Pack_Exfo(); SerialNumber _M_SerialNumber = new SerialNumber(); ArrayList _SN_Data = _M_SerialNumber.Get_SN_List(" BatchNo = '" + e.BatchNo.BatchNo + "' AND State = 'Yet_Pack'"); int temcount = 0; int _exRow = 5; foreach (string _SN in _SN_Data) { xlApp.Cells[_exRow, 1] = _SN; // 1 PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-1" + "' AND (Wave = '1550nm')"), _exRow, 3); PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-2" + "' AND (Wave = '1550nm')"), _exRow, 5); // 2 PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-3" + "' AND (Wave = '1550nm')"), _exRow, 7); PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-4" + "' AND (Wave = '1550nm')"), _exRow, 9); // 3 PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-5" + "' AND (Wave = '1550nm')"), _exRow, 11); PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-6" + "' AND (Wave = '1550nm')"), _exRow, 13); // 4 PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-7" + "' AND (Wave = '1550nm')"), _exRow, 15); PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-8" + "' AND (Wave = '1550nm')"), _exRow, 17); temcount++; _exRow++; e.StatUpProgressBar(0, _SN_Data.Count, temcount); } }
//批号下拉菜单 private void cmb_BatchNo_DropDownClosed(object sender, EventArgs e) { try { txb_BoxSN.IsEnabled = true; txb_BoxSN.Text = ""; //获取批号信息 PackBatch _M_PackBatch = new PackBatch(); Maticsoft.Model.PackBatch _PackBatch = new Maticsoft.Model.PackBatch(); _PackBatch = _M_PackBatch.GetModel(cmb_BatchNo.Text.Trim()); txb_BatchCount.Text = _PackBatch.Count.ToString(); //获取装箱信息 EncasementSet _M_EncasementSet = new EncasementSet(); Maticsoft.Model.EncasementSet _EncasementSet = new Maticsoft.Model.EncasementSet(); _EncasementSet = _M_EncasementSet.GetModel(cmb_BatchNo.Text.Trim()); if (_EncasementSet != null) { Info_Device.Text = _EncasementSet.Device; Info_DeviceQty.Text = _EncasementSet.DeviceQty; Info_SackQty.Text = _EncasementSet.SackQty; //****************************************************** 2015-6-25 增加 对标签检测进行设置 if (_EncasementSet.DeviceQty == "2") { labCheck.vm.IsEnSN2 = true; } labCheck.vm.OrderID = _PackBatch.OrderID; } //已包装数量 Maticsoft.BLL.SerialNumber _M_SerialNumber = new Maticsoft.BLL.SerialNumber(); Info_YetPack_Count.Text = _M_SerialNumber.Get_PackCount_Batch(" (BatchNO = '" + cmb_BatchNo.Text.Trim() + "') AND (State = '" + Maticsoft.Model.E_Barcode_State.Yet_Pack + "')").ToString(); //已装箱数量 Maticsoft.BLL.BoxInfo _M_BoxInfo = new Maticsoft.BLL.BoxInfo(); Info_YetEncasement_Count.Text = _M_BoxInfo.GetYetEncasementCount("tb_BoxInfo.BatchNo = '" + cmb_BatchNo.Text.Trim() + "'").ToString(); //批号装箱完成 if (int.Parse(Info_YetEncasement_Count.Text.Trim()) >= int.Parse(txb_BatchCount.Text.Trim())) { My_MessageBox.My_MessageBox_Message("批号:" + cmb_BatchNo.Text.Trim() + "数量:" + txb_BatchCount.Text.Trim() + "\r\n装箱完毕!"); txb_Device.IsEnabled = false; txb_SerialNumber.IsEnabled = false; } } catch { } }
//数据查看 private void FindData(DataDelivery e) { Maticsoft.BLL.SerialNumber sn = new Maticsoft.BLL.SerialNumber(); //条码操作类 Type BarcodeState = typeof(Maticsoft.Model.E_Barcode_State); //条码状态 string s = BarcodeState.GetEnumName(e.Option); //根据 索引获取 字符串 结果为 red Maticsoft.BLL.Pack_3D _M_Pack3D = new Pack_3D(); SerialNumber _M_SerialNumber = new SerialNumber(); switch (e.Option) { case 0: //未包装 ds_Record = sn.GetList("(State = '" + s + "') AND (OrderID = '" + txb_Find_OrderID.Text + "')"); break; case 1: //已包装 ds_Record = sn.GetList("(State = '" + s + "') AND (OrderID = '" + txb_Find_OrderID.Text + "')"); break; case 2: //未装箱 ds_Record = sn.GetList("(State = '" + s + "') AND (OrderID = '" + txb_Find_OrderID.Text + "')"); break; case 3: //已装箱 ds_Record = sn.GetList("(State = '" + s + "') AND (OrderID = '" + txb_Find_OrderID.Text + "')"); break; case 4: //未打印 break; case 5: //已打印 Maticsoft.BLL.tb_PrintRecord print_Record = new tb_PrintRecord(); ds_Record = print_Record.GetList("(OrderID = '" + txb_Find_OrderID.Text + "')"); break; case 6: //客户编码 ds_Record = _M_Pack3D.GetList("ClientSN ='" + txb_Find_OrderID.Text.Trim() + "'"); // ds_Record = _M_Pack3D.Get_PackData(txb_Find_OrderID.Text.Trim(), Maticsoft.Model.E_InspectMethod.配组_四十八芯); break; case 7: //客户编码 ds_Record = _M_Pack3D.GetList("SN ='" + txb_Find_OrderID.Text.Trim() + "'"); break; case 8: //SN查询 ds_Record = _M_SerialNumber.GetList("SN ='" + txb_Find_OrderID.Text.Trim() + "'"); break; case 9: //原始数据3D查询 根据SN ds_Record = MCP_CS._M_User_3D_Test_Good.GetList("SN LIKE '" + txb_Find_OrderID.Text.Trim() + "%'"); break; case 10: //原始数据JDS查询 根据SN ds_Record = MCP_CS._M_User_JDS_Test_Good.GetList("SN LIKE '" + txb_Find_OrderID.Text.Trim() + "%'"); break; case 11: //删除记录查询 ds_Record = MCP_CS.Operation_Log.GetList("Remarks LIKE '%" + txb_Find_OrderID.Text.Trim() + "%'"); break; } dgv_Info.ItemsSource = ds_Record.Tables[0].DefaultView; //显示控件中显示 lab_Record.Text = ds_Record.Tables[0].Rows.Count.ToString() + "条"; //记录数量 }