/// <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() + "条"; //记录数量
}