//数据查看
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() + "条"; //记录数量
}
//删除数据
private void DeleteSN_List(DataDelivery e)
{
try
{
SerialNumber sn = new SerialNumber();
tb_PrintRecord print = new tb_PrintRecord();
int temRecordCount = 0;
switch (e.Option)
{
//删除已包装
case 0:
Update_SN_TO_Not_Pack(ref e, sn, ref temRecordCount);
break;
//删除已打印
case 1:
foreach (object _sn in e.SNlist)
{
string tem = "";
if (_sn.ToString().Length > 10)
{
tem = _sn.ToString().Substring(0, 10);
}
else
{
tem = _sn.ToString();
}
print.Delete(tem);
temRecordCount++;
}
My_MessageBox.My_MessageBox_Message("成功删除已打印:" + temRecordCount + "");
break;
//删除已装箱
case 2:
foreach (object _sn in e.SNlist)
{
Maticsoft.Model.SerialNumber _serialNumber = sn.GetModel(_sn.ToString());
_serialNumber.State = Maticsoft.Model.E_Barcode_State.Not_Encasement.ToString();
if (sn.Update(_serialNumber))
{
temRecordCount++;
}
}
My_MessageBox.My_MessageBox_Message("成功删除已装箱" + temRecordCount + "");
break;
case 3:
foreach (object _sn in e.SNlist)
{
if (sn.Delete(_sn.ToString()))
{
temRecordCount++;
}
}
My_MessageBox.My_MessageBox_Message("成功删除条码" + temRecordCount + "");
break;
default:
My_MessageBox.My_MessageBox_Message("不包含此项目");
break;
}
}
catch (Exception ex)
{
My_MessageBox.My_MessageBox_Message(ex.Message);
}
}
