/// <summary> /// 添加工单基本信息 /// </summary> /// <returns></returns> private void Add_orderInfo(Maticsoft.Model.WorkOrder _workOrder) { _workOrder = new Maticsoft.Model.WorkOrder() { OrderID = txb_OrderID.Text.ToString(), //工单单号 Client = "Ezconn", ProductName = txb_ProductName.Text.ToString(), Model = txb_Model.Text.ToString(), Count = txb_Order_Count.Text.ToString(), //枚举类型的检测方法 InspectMethod = (Maticsoft.Model.E_InspectMethod)Enum.Parse(typeof(Maticsoft.Model.E_InspectMethod), cmb_InspectMethod.SelectedItem.ToString(), false), //枚举类型检测选项 InspectType = (Maticsoft.Model.E_InspectType)Enum.Parse(typeof(Maticsoft.Model.E_InspectType), cmb_InspectType.Text.ToString(), false), DeliveryDate = date_DeliveryDate.Text.ToString(), // LabelType = cmb_LabType.Text.ToString(), ModelNo = txb_Model.Text.ToString(), Workshop = cmb_WorkShop.Text.ToString(), State = "待生产" , ID_Key = _workOrder.ID_Key }; //判断是否添加成功 if (_M_WorkOrder.Update(_workOrder)) { _dt_OrderMaterial = _M_WorkOrder.GetOrderMaterial(txb_OrderID.Text); //工单物料需领用量 Add_orderMaterial(_dt_OrderMaterial); //添加工单中的物料清单 Add_MaterialInfo(_dt_OrderMaterial); //添加物料信息 暂时使用 用于收集物料信息 //弹出提示信息 My_MessageBox.My_MessageBox_Message("工单" + txb_OrderID.Text.ToString() + "添加成功!"); //保存条码 if (txb_Stat_SN.Text != "") { Maticsoft.BLL.SerialNumber _M_SerialNumber = new SerialNumber(); if (_M_SerialNumber.GetList("OrderID = '" + txb_OrderID.Text.Trim() + "'").Tables[0].Rows.Count < 1) { addSerialNumber(long.Parse(txb_Stat_SN.Text.ToString()), int.Parse(txb_Order_Count.Text)); } else { if (MessageBox.Show("工单" + txb_OrderID.Text.ToString() + "已经存在条码,继续将替换原有条码!\r\n是否继续添加", "系统提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error) == DialogResult.OK) { // _M_SerialNumber.DeleteList("OrderID = '" + txb_OrderID.Text.Trim() + "'"); addSerialNumber(long.Parse(txb_Stat_SN.Text.ToString()), int.Parse(txb_Order_Count.Text)); } } } else { My_MessageBox.My_MessageBox_Message("开始条码 为空 将不进行条码添加!"); } #region 清空文本框 txb_OrderID.Text = ""; txb_ProductName.Text = ""; txb_Model.Text = ""; txb_Order_Count.Text = ""; cmb_InspectMethod.Text = ""; cmb_InspectType.Text = ""; date_DeliveryDate.Text = ""; txb_Model.Text = ""; cmb_WorkShop.Text = ""; txb_Stat_SN.Text = ""; _GLL_Lst_SerialNumber.Clear(); #endregion } else { //弹出提示信息 My_MessageBox.My_MessageBox_Erry("工单" + txb_OrderID.Text.ToString() + "添加失败!"); } }
//数据查看 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() + "条"; //记录数量 }