protected void btnUnTask_Click(object sender, EventArgs e) { BLL.BLLBase bll = new BLL.BLLBase(); int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", this.txtID.Text))); if (State < 2) { JScript.ShowMessage(this.updatePanel, this.txtID.Text + "单号还未作业,不能进行取消作业。"); return; } if (State > 2) { JScript.ShowMessage(this.updatePanel, this.txtID.Text + "单号已经执行,不能再进行取消作业。"); return; } try { bll.ExecNonQueryTran("WMS.SpCancelOutStockTask", new DataParameter[] { new DataParameter("@BillID", strID), new DataParameter("@UserName", Session["EmployeeCode"].ToString()) }); AddOperateLog("入库单", "入库取消作业单号:" + this.txtID.Text); DataTable dt = bll.FillDataTable("WMS.SelectBillMaster", new DataParameter[] { new DataParameter("{0}", string.Format("BillID='{0}'", strID)) }); BindData(dt); } catch (Exception ex) { JScript.ShowMessage(this.updatePanel, ex.Message); } }
//入库完成 private void TMITaskInFinished_Click(object sender, EventArgs e) { if (this.dgvMain.CurrentCell != null) //判断该任务是否堆垛机已经执行? { try { string TaskNo = this.dgvMain.Rows[this.dgvMain.CurrentCell.RowIndex].Cells[2].Value.ToString(); string PalletCode = this.dgvMain.Rows[this.dgvMain.CurrentCell.RowIndex].Cells[4].Value.ToString(); bll.ExecNonQueryTran("WCS.SpTaskFinished", new DataParameter[] { new DataParameter("VTaskNo", TaskNo) }); Logger.Info("入库任务:" + TaskNo + "托盘编号:" + PalletCode + "手动更新完成!"); this.BindData(); } catch (Exception ex) { Logger.Error("Main中入库任务手动更新完成出现异常" + ex.Message); } } }
protected void btnAdd_Click(object sender, EventArgs e) { string strColorCode = "'-1',"; BLL.BLLBase bll = new BLL.BLLBase(); for (int i = 0; i < this.GridView1.Rows.Count; i++) { CheckBox cb = (CheckBox)(this.GridView1.Rows[i].FindControl("cbSelect")); if (cb != null && cb.Checked) { string hk = this.GridView1.Rows[i].Cells[1].Text; //判断能否删除 int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", hk))); if (State == 0) { JScript.Instance.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "单号还未审核不能作业,请审核后,再进行盘库作业。"); BindDataSub(this.hdnRowValue.Value); return; } if (State > 1) { JScript.Instance.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "单号已经作业,不能再进行盘库作业。"); BindDataSub(this.hdnRowValue.Value); return; } strColorCode += "'" + hk + "',"; } } strColorCode += "'-1'"; if (strColorCode.Replace("'-1','-1'", "").Trim().Length == 0) { JScript.Instance.ShowMessage(this.UpdatePanel1, "请选择单据!"); SetGridViewEmptyRow(GridView1, (DataTable)ViewState[FormID + "_MainFormData"]); BindDataSub(this.hdnRowValue.Value); return; } try { bll.ExecNonQueryTran("WMS.SpInventoryStockTask", new DataParameter[] { new DataParameter("@strWhere", strColorCode), new DataParameter("@UserName", Session["EmployeeCode"].ToString()) }); AddOperateLog("盘库单", "盘库作业单号:" + strColorCode.Replace("'-1',", "").Replace(",'-1'", "")); DataTable dt = SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, GridView1, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1); SetBindDataSub(dt); } catch (Exception ex) { BindDataSub(this.hdnRowValue.Value); JScript.Instance.ShowMessage(this.UpdatePanel1, ex.Message); } }
protected void btnAdd_Click(object sender, EventArgs e) { string strColorCode = "'-1',"; BLL.BLLBase bll = new BLL.BLLBase(); for (int i = 0; i < this.GridView1.Rows.Count; i++) { CheckBox cb = (CheckBox)(this.GridView1.Rows[i].FindControl("cbSelect")); if (cb != null && cb.Checked) { string hk = this.GridView1.Rows[i].Cells[1].Text; //判断能否删除 int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", hk))); if (State == 0) { JScript.Instance.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "单号还未审核不能作业,请审核后,再进行入库作业。"); BindDataSub(this.hdnRowValue.Value); return; } if (State > 1) { JScript.Instance.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "单号已经作业,不能再进行入库作业。"); BindDataSub(this.hdnRowValue.Value); return; } strColorCode += "'" + hk + "',"; } } strColorCode += "'-1'"; if (strColorCode.Replace("'-1','-1'", "").Trim().Length == 0) { JScript.Instance.ShowMessage(this.UpdatePanel1, "请选择单据!"); SetGridViewEmptyRow(GridView1, (DataTable)ViewState[FormID + "_MainFormData"]); BindDataSub(this.hdnRowValue.Value); return; } try { bll.ExecNonQueryTran("WMS.SpInstockTask", new DataParameter[] { new DataParameter("@strWhere", strColorCode), new DataParameter("@UserName", Session["EmployeeCode"].ToString()) }); AddOperateLog("入库单", "入库作业单号:" + strColorCode.Replace("'-1',", "").Replace(",'-1'", "")); DataTable dt = SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, GridView1, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1); SetBindDataSub(dt); } catch (Exception ex) { BindDataSub(this.hdnRowValue.Value); JScript.Instance.ShowMessage(this.UpdatePanel1, ex.Message); } }
protected void btnCreate_Click(object sender, EventArgs e) { try { DataParameter[] para = new DataParameter[] { new DataParameter("@ProductCode", strID), new DataParameter("@ProductNewCode", this.txtProductNewCode.Text), new DataParameter("@UserName", Session["EmployeeCode"].ToString()), }; bll.ExecNonQueryTran("CMD.spBatchChangeProductNo", para); JScript.ShowMessage(this, "编号修改成功!"); Response.Redirect(FormID + "View.aspx?SubModuleCode=" + SubModuleCode + "&FormID=" + Server.UrlEncode(FormID) + "&SqlCmd=" + SqlCmd + "&ID=" + Server.UrlEncode(this.txtProductNewCode.Text)); } catch (Exception ex) { JScript.ShowMessage(this, ex.Message); return; } }
private void tmCraneWorker(object sender, System.Timers.ElapsedEventArgs e) { try { tmCraneErr.Stop(); for (int i = 1; i <= dtCrane.Rows.Count; i++) { if (dtCrane.Rows[i - 1]["ISENABLED"].ToString() == "0") { continue; } string serviceName = "CranePLC" + i; int ErrCode = int.Parse(ObjectUtil.GetObject(context.ProcessDispatcher.WriteToService(serviceName, "nAlarmCode")).ToString()); if (ErrCode == 0) { continue; } if (ErrCode == 505) { string plcTaskNo = ConvertStringChar.BytesToString(ObjectUtil.GetObjects(context.ProcessDispatcher.WriteToService(serviceName, "ReadTaskNo"))); DataTable dtTask = bll.FillDataTable("WCS.SelectWmsTask", new DataParameter[] { new DataParameter("{0}", string.Format("TASKID='{0}' and ASRSID='{1}'", plcTaskNo, i)) }); if (dtTask.Rows.Count > 0) { string TaskType = dtTask.Rows[0]["TASKTYPE"].ToString(); string plcPalletCode = dtTask.Rows[0]["PALLETID"].ToString(); DataTable dtErr = bll.FillDataTable("WCS.SelectWmsSend", new DataParameter[] { new DataParameter("{0}", string.Format("TASKID='{0}'", plcTaskNo)) }); if (dtErr.Rows.Count > 0) { string Taskstatus = dtErr.Rows[0]["TASKSTATUS"].ToString(); if (Taskstatus == "4") { //crane.ErrCode == 505,重入异常 if (TaskType == "OB") { continue; } bll.ExecNonQueryTran("WCS.SPCancelTask", new DataParameter[] { new DataParameter("VTASKNO", plcTaskNo) }); Logger.Info("入库任务:" + plcTaskNo + "托盘编号:" + plcPalletCode + "取消!"); DataTable dtTaskNew = bll.FillDataTable("WCS.SelectWmsTask", new DataParameter[] { new DataParameter("{0}", string.Format("PALLETID='{0}' AND TASKSTATUS='0' AND ASRSID='{1}'", plcPalletCode, i)) }); if (dtTaskNew.Rows.Count > 0) { string TaskNo = dtTaskNew.Rows[0]["TASKID"].ToString(); sbyte[] staskNo = new sbyte[20]; Util.ConvertStringChar.stringToBytes(TaskNo, 12).CopyTo(staskNo, 0); Util.ConvertStringChar.stringToBytes(plcPalletCode, 8).CopyTo(staskNo, 12); string strDLocation = dtTaskNew.Rows[0]["DLOCATION"].ToString(); int[] Location = new int[6]; Location[0] = 0; Location[1] = 0; Location[2] = 0; Location[3] = int.Parse(strDLocation.Split('-')[0]); Location[4] = int.Parse(strDLocation.Split('-')[1]); int ToRow = int.Parse(strDLocation.Split('-')[2]); if (ToRow > 1) { ToRow += 1; } Location[5] = ToRow; context.ProcessDispatcher.WriteToService(serviceName, "Address", Location); context.ProcessDispatcher.WriteToService(serviceName, "WriteTask", staskNo); if (context.ProcessDispatcher.WriteToService(serviceName, "WriteFinish", true)) { bll.ExecNonQueryTran("WCS.SPReciveWmsTask", new DataParameter[] { new DataParameter("VTASKNO", TaskNo) }); //更新WCSTask状态为3 bll.ExecNonQuery("WCS.UpdateWCSTaskState", new DataParameter[] { new DataParameter("{0}", 3), new DataParameter("{1}", TaskNo) }); Logger.Info("入库任务:" + TaskNo + " 托盘编号:" + plcPalletCode + " 位:" + strDLocation + " 已下发给" + i + "堆垛机"); } else { Logger.Error("入库任务:" + TaskNo + " 托盘编号:" + plcPalletCode + " 无法写入堆垛机" + i); } } } } } } } } catch (Exception ex) { Logger.Error("MainServer中tmCraneWorker出现异常:" + ex.Message); } finally { tmCraneErr.Start(); } }