private void timeupEx()
{
if (bOpen)
{
int errcode = Advantech.Digital_ReadByteFromPort(DeviceHandle, short.Parse(Public.GetXmlValue("PCLPort")), out DiValue);
UpdateLED();
}
}
private bool getPCLA()
{
bool ret = false;
short MaxEntries = 9;
int i;
int ii;
string tempStr;
int tempNum;
try
{
int errcode = Advantech.GetDeviceList(out devlistarray, ref outEntries);
if (errcode != 0)
{
MessageBox.Show("获取设备列表失败，错误代码：" + errcode.ToString());
}
else
{
errcode = Advantech.DRV_DeviceGetNumOfList(ref MaxEntries);
if (errcode != 0)
{
MessageBox.Show("获取设备数，错误代码：" + errcode.ToString());
}
else
{
for (i = 0; i < MaxEntries; i++)
{
tempStr = "";
tempStr = devlistarray.Devices[i].szDeviceName;
MessageBox.Show(tempStr);
string pzDevice = Public.GetXmlValue("type");//获取设备类型
tempNum = tempStr.IndexOf(pzDevice);
if (tempNum != -1)
{
gnNumOfSubdevices = devlistarray.Devices[i].nNumOfSubdevices;
if (gnNumOfSubdevices > MaxDev)
{
gnNumOfSubdevices = MaxDev;
}
if (gnNumOfSubdevices == 0)
{
dwDeviceNum = devlistarray.Devices[i].dwDeviceNum;
errcode = Advantech.DRV_DeviceOpen(dwDeviceNum, ref DeviceHandle);
if (errcode != 0)
{
MessageBox.Show("打开设备失败，错误代码：" + errcode.ToString());
}
else
{
ret = true;
bOpen = true;
}
//PCLDevice.ptDevGetFeatures.buffer = &lpDevFeatures;
}
}
else
{
MessageBox.Show("没有安装PCL-730");
ret = false;
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(ret);
}
private void button1_Click(object sender, EventArgs e)
{
if (dgvwgd.SelectedRows.Count == 0)
{
MessageBox.Show("选择完工单！", "系统提示");
return;
}
if (!Public.getWeightManageAuthority(Public.usermangno, "SearchWGD"))
{
MessageBox.Show("没有权限！", "系统提示");
return;
}
string wgdh = dgvwgd.SelectedRows[0].Cells[0].Value.ToString();
string pch = dgvwgd.SelectedRows[0].Cells[1].Value.ToString();
string sqlstr = "select top 3000 * from WMS_Com_Log where ComResult=1 and DOCID='" + wgdh + "'";
DataSet ds = null;
ds = DbEntry.Context.ExecuteDataset(sqlstr);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
if (MessageBox.Show("完工单已经回传NC，是否继续？", "系统提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
sqlstr = "select top 3000 * from WMS_Com_Log where ComResult=1 and DOCID='" + pch + "'";
ds = DbEntry.Context.ExecuteDataset(sqlstr);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
if (MessageBox.Show("材料出库单已经回传NC，是否继续？", "系统提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
if (int.Parse(dgvwgd.SelectedRows[0].Cells["colwcbz"].Value.ToString()) < 2)
{
MessageBox.Show("无需重置！", "系统提示");
return;
}
if (MessageBox.Show("是否重置完工单，批次号【" + pch + "】", "系统提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
try
{
DbEntry.UsingTransaction(delegate()
{
sqlstr = "update WMS_Bms_Rec_WGD set wcbz=1 , sendend=0 where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "insert into WMS_Bms_Rec_WGD_ManageLog(barcode,zl,sx,gh,yzl,ysx,ygh,opetype,oper)" +
" values('" + wgdh + "','0',' ',0,0,' ',0,'重置完工单','" + Public.usermangno + "')";
DbEntry.Context.ExecuteNonQuery(sqlstr);
MessageBox.Show("重置成功！");
searchwgd();
});
}
catch (Exception ex)
{
MessageBox.Show("重置失败:" + ex.Message, "系统提示");
}
}
private void button3_Click(object sender, EventArgs e)
{
if (dgvwgd.SelectedRows.Count == 0)
{
MessageBox.Show("选择完工单！", "系统提示");
return;
}
if (!Public.getWeightManageAuthority(Public.usermangno, "DelWgd"))
{
MessageBox.Show("没有权限！", "系统提示");
return;
}
string wgdh = dgvwgd.SelectedRows[0].Cells[0].Value.ToString();
string pch = dgvwgd.SelectedRows[0].Cells[1].Value.ToString();
string sqlstr = "select top 3000 * from WMS_Com_Log where ComResult=1 and DOCID='" + wgdh + "'";
DataSet ds = null;
ds = DbEntry.Context.ExecuteDataset(sqlstr);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
if (MessageBox.Show("完工单已经回传NC，是否继续？", "系统提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
sqlstr = "select top 3000 * from WMS_Com_Log where ComResult=1 and DOCID='" + pch + "'";
ds = DbEntry.Context.ExecuteDataset(sqlstr);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
if (MessageBox.Show("材料出库单已经回传NC，是否继续？", "系统提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
string wcbz = dgvwgd.SelectedRows[0].Cells["colwcbz"].ToString();
string msg = "";
switch (wcbz)
{
case "0":
msg = "是否删除？";
break;
case "1":
msg = "已经生产，是否删除？";
break;
case "2":
msg = "已经生产结束，是否删除?";
break;
case "3":
msg = "已经入库，是否删除？";
break;
default:
msg = "是否删除？";
break;
}
sqlstr = "select count(1) as fcount from WMS_Bms_Inv_OutInfo where pch='" + pch + "'";
ds = DbEntry.Context.ExecuteDataset(sqlstr);
if (int.Parse(ds.Tables[0].Rows[0]["fcount"].ToString()) > 0)
{
MessageBox.Show("已经出库，不能删除", "系统提示"); return;
}
if (MessageBox.Show(msg + "删除动作将不能恢复？", "系统警告", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
try
{
DbEntry.UsingTransaction(delegate()
{
sqlstr = "delete WMS_Bms_Rec_WGD where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "delete WMS_Bms_Rec_WGD_item where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "delete from WMS_Bms_Inv_Info where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "delete from WMS_Bms_Rec_WGD_Free where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "delete from WMS_Bms_Rec_WGD_Item_Free where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "delete from Wms_Bms_Inv_Bzzl where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "delete from WMS_Bms_Rec_WGD_Liquid where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "insert into WMS_Bms_Rec_WGD_ManageLog(barcode,zl,sx,gh,yzl,ysx,ygh,opetype,oper)" +
" values('" + wgdh + "','0',' ',0,0,' ',0,'删除完工单','" + Public.usermangno + "')";
DbEntry.Context.ExecuteNonQuery(sqlstr);
MessageBox.Show("操作成功！");
searchwgd();
});
}
catch (Exception ex)
{
MessageBox.Show("操作失败:" + ex.Message, "系统提示");
}
}
private void button2_Click(object sender, EventArgs e)
{
if (dgvwgd.SelectedRows.Count == 0)
{
MessageBox.Show("选择完工单！", "系统提示");
return;
}
if (!Public.getWeightManageAuthority(Public.usermangno, "ReCheck"))
{
MessageBox.Show("没有权限！", "系统提示");
return;
}
string wgdh = dgvwgd.SelectedRows[0].Cells[0].Value.ToString();
string pch = dgvwgd.SelectedRows[0].Cells[1].Value.ToString();
string sqlstr = "select top 3000 * from WMS_Com_Log where ComResult=1 and DOCID='" + wgdh + "'";
DataSet ds = null;
ds = DbEntry.Context.ExecuteDataset(sqlstr);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
if (MessageBox.Show("完工单已经回传NC，是否继续？", "系统提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
sqlstr = "select top 3000 * from WMS_Com_Log where ComResult=1 and DOCID='" + pch + "'";
ds = DbEntry.Context.ExecuteDataset(sqlstr);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
if (MessageBox.Show("材料出库单已经回传NC，是否继续？", "系统提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
if (dgvwgd.SelectedRows[0].Cells["colzjbz"].Value.ToString() == "0")
{
MessageBox.Show("未质检，不用重新质检！", "系统提示");
return;
}
sqlstr = "select count(1) as fcount from WMS_Bms_Inv_Info where pch='" + pch + "'";
ds = DbEntry.Context.ExecuteDataset(sqlstr);
if (int.Parse(ds.Tables[0].Rows[0]["fcount"].ToString()) > 0)
{
if (MessageBox.Show("已经生产，是否继续？继续将删除已生产的线材", "系统提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
sqlstr = "select count(1) as fcount from WMS_Bms_Inv_OutInfo where pch='" + pch + "'";
ds = DbEntry.Context.ExecuteDataset(sqlstr);
if (int.Parse(ds.Tables[0].Rows[0]["fcount"].ToString()) > 0)
{
MessageBox.Show("已经出库，不能重新质检", "系统提示"); return;
}
if (MessageBox.Show("是否重新质检，删除动作将不能恢复？", "系统警告", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
try
{
DbEntry.UsingTransaction(delegate()
{
sqlstr = "update WMS_Bms_Rec_WGD set PGBZ=0,wcbz=0,zjbz=0,sendend=0 where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "delete from WMS_Bms_Inv_Info where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "delete from Wms_Bms_Inv_Bzzl where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "delete from WMS_Bms_Rec_WGD_Liquid where pch='" + pch + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "insert into WMS_Bms_Rec_WGD_ManageLog(barcode,zl,sx,gh,yzl,ysx,ygh,opetype,oper)" +
" values('" + wgdh + "','0',' ',0,0,' ',0,'重新质检完工单','" + Public.usermangno + "')";
DbEntry.Context.ExecuteNonQuery(sqlstr);
MessageBox.Show("操作成功！");
searchwgd();
}
);
}
catch (Exception ex)
{
MessageBox.Show("操作失败:" + ex.Message, "系统提示");
}
}
private void btnDel_Click(object sender, EventArgs e)
{
if (dgv.SelectedRows.Count == 0)
{
MessageBox.Show("选择单卷信息", "系统提示");
return;
}
//Boolean v = Common.getWeightManageAuthority(Common.userno, "QuDel");
Boolean t = Public.getWeightManageAuthority(Public.usermangno, "QuDel");
if (!t)
{
MessageBox.Show("没有删除卷信息的权限！", "系统提示");
return;
}
DataSet ds = null;
string sqlstr = "";
string pch = dgv.SelectedRows[0].Cells[1].Value.ToString();
string barcode = dgv.SelectedRows[0].Cells["Column6"].Value.ToString();
//string mcbarcode = dgv.SelectedRows[0].Cells["Column13"].Value.ToString();
sqlstr = "select count(1) as f from WMS_Com_Log where ComResult=1 and DOCID=(select WGDH from WMS_Bms_Rec_WGD where pch='" + pch + "')";
ds = DbEntry.Context.ExecuteDataset(sqlstr);
if (ds.Tables[0].Rows[0]["f"].ToString() != "0")
{
if (MessageBox.Show("已回传NC，是否继续？", "系统提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
sqlstr = "select wcbz from WMS_Bms_Rec_WGD where pch='" + pch + "'";
ds = DbEntry.Context.ExecuteDataset(sqlstr);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["wcbz"].ToString() == "3")
{
MessageBox.Show("完工单已经结束批次，不能删除，在批次管理中放开完工单后再进行此操作！", "系统提示");
return;
}
}
else
{
MessageBox.Show("完工单不存在，请重新查询！", "系统提示");
return;
}
string msg = "是否删除，删除后将不能恢复？";
//sqlstr = "select barcode from Wms_Bms_Inv_MC where mcbarcode='" + mcbarcode + "'";
//ds = DbEntry.Context.ExecuteDataset(sqlstr);
//string cjbarcodelist = "";
//if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 1)
//{
// foreach (DataRow dr in ds.Tables[0].Rows)
// {
// cjbarcodelist += dr["barcode"].ToString() + ",";
// }
// cjbarcodelist = cjbarcodelist.Substring(0, cjbarcodelist.Length - 1);
// msg = "系统将自动删除相同母材的产品条码，产品条码为【" + cjbarcodelist + "】，请对不需要删除的产品条码进行重新打印！是否继续？";
//}
if (MessageBox.Show(msg, "系统提示", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
try
{
DbEntry.UsingTransaction(delegate()
{
sqlstr = "delete from WMS_Bms_Inv_Info where barcode='" + barcode + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "insert into WMS_Bms_Rec_WGD_ManageLog(barcode,zl,sx,gh,yzl,ysx,ygh,opetype,oper)" +
" values('" + barcode +
"','" + dgv.SelectedRows[0].Cells["Column5"].Value.ToString() +
"','" + dgv.SelectedRows[0].Cells["Column8"].Value.ToString() + "','" +
"0" +
"','" + dgv.SelectedRows[0].Cells["Column5"].Value.ToString() +
"','" + dgv.SelectedRows[0].Cells["Column8"].Value.ToString() +
"','" + "0" +
"','单卷删除','" + Public.userno + "')";
DbEntry.Context.ExecuteNonQuery(sqlstr);
sqlstr = "delete from wms_bms_inv_Bzzl where barcode='" + barcode + "'";
DbEntry.Context.ExecuteNonQuery(sqlstr);
MessageBox.Show("删除成功！");
ds = DbEntry.Context.ExecuteDataset("select count(1) as f from wms_bms_inv_info where pch='" + pch + "'");
if (ds.Tables[0].Rows[0]["f"].ToString() == "0")
{
DbEntry.Context.ExecuteNonQuery("update WMS_Bms_Rec_WGD set wcbz=0 where pch='" + pch + "'");
}
search();
});
}
catch (System.Exception ex)
{
MessageBox.Show("删除失败:" + ex.Message, "系统提示");
}
}
