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, "系统提示"); } }