/* End */
#endregion
#region 数据查询
/***************************** 数据查询 *********************************/
//
//
//查找数据
private void btn_Find_Click(object sender, RoutedEventArgs e)
{
DataDelivery temdata = new DataDelivery();
temdata.Option = cmb_Find_Option.SelectedIndex;
temdata._BarCode = txb_Find_OrderID.Text;
FindData(temdata);
}
/* End */
#endregion
#region 除数据
/***************************** 删除条码 *********************************/
//
//删除数据
//
private void btn_Delete_Click(object sender, RoutedEventArgs e)
{
User_Verify f = new User_Verify();
f.ShowDialog();
if (f.Result_InspectUser == true && f.SysUser.Privilege == "系统管理员" || f.SysUser.Privilege == "主管" || f.SysUser.Privilege == "工程师" || f.SysUser.Privilege == "助理")
{
My_MessageBox.My_MessageBox_Message("用户：" + f.SysUser.UserName);
DataDelivery temData = new DataDelivery();
object[] temList = new string[this.lst_DeleteList.Items.Count];
lst_DeleteList.Items.CopyTo(temList, 0);
temData.Option = cmb_Delete_Option.SelectedIndex;
temData.SNlist = temList;
temData.IsDeleteSourceData = ckb_DeleteSorceData.IsChecked;
if (temData.Option != -1) //如果已经选择
{
if (temData.Option == 3) //如果为删除源码
{
if (f.SysUser.Privilege == "助理" || f.SysUser.Privilege == "系统管理员")
{
DeleteSN_List(temData);
}
else
{
My_MessageBox.My_MessageBox_Message("对不起！您无权删除原始条码！请联系系统管理员或工程师！");
}
}
else
{
DeleteSN_List(temData);
}
}
lst_DeleteList.Items.Clear();
DeleteRecord = 0;
lab_DeleteRecord.Text = DeleteRecord + "条";
MCP_CS._Operation_log.UserName = f.SysUser.UserName;
MCP_CS._Operation_log.Operation = "删除";
}
else
{
My_MessageBox.My_MessageBox_Message("未执行，操作被用户终止！或未通过验证 请确定您是否有权限删除数据！");
}
}
//数据查看
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() + "条"; //记录数量
}
/// <summary>
/// 条码更改为 未包装
/// </summary>
private static void Update_SN_TO_Not_Pack(ref DataDelivery e, SerialNumber sn, ref int temRecordCount)
{
//原始数据删除数量 计数
int temCount = 0;
int fillDelete_snCount = 0;
string fillDelete_snList = "";
Pack_3D pk_3d = new Pack_3D();
Pack_Exfo pk_Exfo = new Pack_Exfo();
Maticsoft.BLL.User_3D_Test_Good user3D = new User_3D_Test_Good();
string temSN = "";
foreach (object _sn in e.SNlist)
{
//如果长度大于13 temSN = 前13位条码
if (_sn.ToString().Length > 13)
{
temSN = _sn.ToString().Substring(0, 10);
}
else
{
temSN = _sn.ToString();
}
temSN = _sn.ToString();
//删除原始数据
if (e.IsDeleteSourceData == true)
{
//删除3D数据
if (_sn.ToString().Length > 13)
{
if (user3D.Delete(_sn.ToString(), 1))
{
temCount++;
}
}
else
{
Maticsoft.BLL.MultiFiber _MPO_3D = new MultiFiber();
if (user3D.Delete(_sn.ToString(), 2) || _MPO_3D.Delete(_sn.ToString()))
{
temCount++;
}
}
//删除Exfo数据
}
//删除Pack中的数据
pk_Exfo.Delete("SN Like '" + temSN + "%'");
pk_3d.Delete("SN Like '" + temSN + "%'");
//将已包装改写为未包装
Maticsoft.Model.SerialNumber _serialNumber = sn.GetModel(temSN);
if (_serialNumber != null)
{
_serialNumber.State = Maticsoft.Model.E_Barcode_State.Not_Pack.ToString();
//如果更新成功
if (sn.Update(_serialNumber))
{
temRecordCount++;
}
else
{
fillDelete_snCount++;
}
}
else
{
fillDelete_snCount++;
}
MCP_CS._Operation_log.Remarks += "," + _sn;
}
MCP_CS._Operation_log.DateTime = DateTime.Now;
MCP_CS.Operation_Log.Add(MCP_CS._Operation_log); //添加删除记录
My_MessageBox.My_MessageBox_Message("成功删除已包装:" + temRecordCount + "条 原始数据:" + temCount + "条；\r\n失败" + fillDelete_snCount + "条 \r\n" + fillDelete_snList);
}
//删除数据
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);
}
}
