private void frmUserList_Load(object sender, EventArgs e) { bll.ExecNonQuery("Security.InsertGroupOperationList"); colbtn.Name = "Detail"; colbtn.DefaultCellStyle.NullValue = "删除用户"; InitSmartTree(); }
private void btnOK_Click(object sender, EventArgs e) { try { BLL.BLLBase bll = new BLL.BLLBase(); if (drGroup != null) { int Count = bll.GetRowCount("sys_GroupList", string.Format("GroupID<>{0} and GroupName='{1}'", drGroup["GroupID"].ToString(), this.txtGroupName.Text.Trim())); if (Count > 0) { MessageBox.Show("該用戶組名稱已經存在!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } bll.ExecNonQuery("Security.UpdateGroupInfo", new DataParameter[] { new DataParameter("@GroupName", this.txtGroupName.Text.Trim()), new DataParameter("@Memo", this.txtMemo.Text.Trim()), new DataParameter("@GroupID", drGroup["GroupID"].ToString()) }); } else { int Count = bll.GetRowCount("sys_GroupList", string.Format("GroupName='{0}'", this.txtGroupName.Text.Trim())); if (Count > 0) { MessageBox.Show("該用戶組名稱已經存在!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } bll.ExecNonQuery("Security.InsertGroup", new DataParameter[] { new DataParameter("@GroupName", this.txtGroupName.Text.Trim()), new DataParameter("@Memo", this.txtMemo.Text.Trim()), new DataParameter("@State", 1) }); } this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }
protected void btnSave_Click(object sender, EventArgs e) { if (this.txtWHID.Text.Trim().Length == 0)//新增 { int count = bll.GetRowCount("CMD_WAREHOUSE", string.Format("WarehouseCode='{0}'", this.txtWhCode.Text)); if (count > 0) { WMS.App_Code.JScript.Instance.ShowMessage(this, "此仓库编码已存在,不能新增!"); return; } //新增 bll.ExecNonQuery("Cmd.InsertWarehouse", new DataParameter[] { new DataParameter("@WarehouseCode", this.txtWhCode.Text), new DataParameter("@WarehouseName", this.txtWhName.Text.Trim().Replace("\'", "\''")), new DataParameter("@MEMO", this.txtMemo.Text.Trim()) }); WMS.App_Code.JScript.Instance.RegisterScript(this, "ReloadParent();"); AddOperateLog("仓库管理", "添加仓库信息"); } else { //更新 bll.ExecNonQuery("Cmd.UpdateWarehouse", new DataParameter[] { new DataParameter("@WarehouseCode", this.txtWhCode.Text), new DataParameter("@WarehouseName", this.txtWhName.Text.Trim().Replace("\'", "\''")), new DataParameter("@MEMO", this.txtMemo.Text.Trim()), new DataParameter("{0}", this.txtWhCode.Text) }); WMS.App_Code.JScript.Instance.RegisterScript(this, "UpdateParent();"); AddOperateLog("仓库管理", "修改仓库信息"); } WMS.App_Code.JScript.Instance.RegisterScript(this, "window.close();"); }
protected void btnDeleteUser_Click(object sender, EventArgs e) { bll.ExecNonQuery("Security.UpdateUserGroup", new DataParameter[] { new DataParameter("@GroupID", 0), new DataParameter("{0}", ((Button)sender).CommandArgument) }); BindDataSub(this.hdnRowValue.Value); }
private void btnOK_Click(object sender, EventArgs e) { DataTable dt = bll.FillDataTable("Cmd.SelectCell", new DataParameter[] { new DataParameter("{0}", string.Format("CellName='{0}'", this.txtNewCellCode.Text)) }); if (dt.Rows.Count > 0) { string AreaCode = dt.Rows[0]["AreaCode"].ToString(); string AisleNo = dt.Rows[0]["AisleNo"].ToString(); string CellCode = dt.Rows[0]["CellCode"].ToString(); if (txtAreaCode.Text != AreaCode) { MessageBox.Show("指定的貨位與原有貨位庫區不一致,無法重新分配貨位!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (txtAisleNo.Text != AisleNo) { MessageBox.Show("指定的貨位與原有貨位巷道不一致,無法重新分配貨位!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (OptionCode == 0) { bll.ExecNonQuery("WCS.UpdateTaskFromCellCode", new DataParameter[] { new DataParameter("@NewCellCode", CellCode), new DataParameter("@NewCellName", this.txtNewCellCode.Text), new DataParameter("@TaskNo", this.txtTaskNo.Text) }); } else { bll.ExecNonQuery("WCS.UpdateTaskToCellCode", new DataParameter[] { new DataParameter("@NewCellCode", CellCode), new DataParameter("@NewCellName", this.txtNewCellCode.Text), new DataParameter("@TaskNo", this.txtTaskNo.Text) }); } this.DialogResult = System.Windows.Forms.DialogResult.OK; } else { MessageBox.Show("指定的貨位不存在,請確認!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } }
protected void btnSave_Click(object sender, EventArgs e) { if (strID == "") //新增 { int Count = bll.GetRowCount("CMD_BillType", string.Format("BillTypeCode='{0}'", this.txtID.Text)); if (Count > 0) { WMS.App_Code.JScript.Instance.ShowMessage(this.Page, "该类型编码已经存在!"); return; } bll.ExecNonQuery("Cmd.InsertBillType", new DataParameter[] { new DataParameter("@BillTypeCode", this.txtID.Text.Trim()), new DataParameter("@BillTypeName", this.txtBillTypeName.Text.Trim()), new DataParameter("@Flag", "1"), new DataParameter("@TaskType", "11"), new DataParameter("@TaskLevel", 1), new DataParameter("@Memo", this.txtMemo.Text.Trim()), new DataParameter("@Creator", Session["EmployeeCode"].ToString()), new DataParameter("@Updater", Session["EmployeeCode"].ToString()) }); } else //修改 { bll.ExecNonQuery("Cmd.UpdateTrainType", new DataParameter[] { new DataParameter("@BillTypeName", this.txtBillTypeName.Text.Trim()), new DataParameter("@Memo", this.txtMemo.Text.Trim()), new DataParameter("@Updater", Session["EmployeeCode"].ToString()), new DataParameter("@BillTypeCode", this.txtID.Text.Trim()) }); } Response.Redirect(FormID + "View.aspx?SubModuleCode=" + SubModuleCode + "&FormID=" + Server.UrlEncode(FormID) + "&SqlCmd=" + SqlCmd + "&ID=" + Server.UrlEncode(this.txtID.Text)); }
private void toolStripButton_Del_Click(object sender, EventArgs e) { if (MessageBox.Show("确定要删除数据吗?", "询问", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { string strCode = "'-1',"; for (int i = 0; i < dgvMain.RowCount; i++) { if (dgvMain.Rows[i].Cells[0].EditedFormattedValue.ToString() == "True") { DataRow dr = ((DataRowView)dgvMain.Rows[i].DataBoundItem).Row; DataTable dt = bll.FillDataTable("WMS.SelectOutStock", new DataParameter[] { new DataParameter("{0}", "BillID='" + dr["BillID"].ToString() + "'") }); if (int.Parse(dt.Rows[0]["State"].ToString()) > 0) { Logger.Info("出库单号 " + dr["BillID"].ToString() + " 已经" + dt.Rows[0]["StateDesc"].ToString() + ",不能修改!"); return; } if (dr["SourceBillID"].ToString().Length != 0) { Logger.Info("MES上传单据,不能修改!"); return; } strCode += "'" + dr["BillID"].ToString() + "',"; } } strCode += "'-1'"; bll.ExecNonQuery("WMS.DeleteOutStock", new DataParameter[] { new DataParameter("{0}", strCode) }); Logger.Info("删除出库单号:" + strCode.Replace("'-1',", "").Replace(",'-1'", "").Replace("'", "")); this.BindData(); } }
private void ToolStripMenuItem_Click(object sender, EventArgs e) { string ItemName = ((ToolStripMenuItem)sender).Name; string State = ItemName.Replace("ToolStripMenuItem1", ""); if (this.dgvMain.CurrentCell != null) { DataRow dataRow = (this.dgvMain.Rows[this.dgvMain.CurrentCell.RowIndex].DataBoundItem as DataRowView).Row; BLL.BLLBase bll = new BLL.BLLBase(); string TaskNo = dataRow["TaskNo"].ToString(); string AreaCode = dataRow["AreaCode"].ToString(); string TaskType = dataRow["TaskType"].ToString(); DataParameter[] param = new DataParameter[] { new DataParameter("@TaskNo", TaskNo), new DataParameter("@State", State) }; bll.ExecNonQueryTran("WCS.Sp_UpdateTaskState", param); BLL.BLLBase bllMiddle = new BLL.BLLBase("MiddleDB"); Logger.Info("手動修改任务號:" + TaskNo + ",状态為" + State); if (State == "7") //手動執行后,修改中間表 { string TaskID = dataRow["TaskID"].ToString(); string SubTaskID = dataRow["SubTaskID"].ToString(); string PalletCode = dataRow["PalletCode"].ToString(); if (AreaCode == "UL" && TaskType == "12") { if (bll.GetRowCount("WCS_Task", string.Format("TaskID={0} and Palletcode='{1}' and SubTaskID!={2} and AreaCode='{3}' and State in (0,1,10) ", TaskID, PalletCode, SubTaskID, "UL")) == 0) { DataTable dtMiddle = bllMiddle.FillDataTable("Middle.SelectConveyMoveTask", new DataParameter[] { new DataParameter("@Device", "UL"), new DataParameter("{0}", string.Format("main.task_id={0} and hu_id='{1}' and subtask_id!={2} ", TaskID, PalletCode, SubTaskID)) }); if (dtMiddle.Rows.Count > 0) { dtMiddle.Rows[0]["location_id"] = dataRow["ToStation"].ToString(); BLL.Server.InsertTaskToWcs(dtMiddle, false); } else { Logger.Error("ConveyPickProcess中找不到托盤號:" + PalletCode + " 的後續處理方式!"); } } } //List<DataParameter[]> paras = new List<DataParameter[]>(); //List<string> Comds = new List<string>(); //Comds.Add("Middle.UpdateAsrsTaskRTN"); //Comds.Add("Middle.UpdateAsrsSubTaskRTN"); //paras.Add(new DataParameter[] { new DataParameter("@TaskID", TaskID) }); //paras.Add(new DataParameter[] { new DataParameter("@SubTaskID", SubTaskID) }); //bllMiddle.ExecTran(Comds.ToArray(), paras); bllMiddle.ExecNonQuery("Middle.UpdateAsrsTaskRTN", new DataParameter[] { new DataParameter("@TaskID", TaskID) }); bllMiddle.ExecNonQuery("Middle.UpdateAsrsSubTaskRTN", new DataParameter[] { new DataParameter("@SubTaskID", SubTaskID) }); if (bllMiddle.GetRowCount("si_asrs_task_Detail", string.Format("task_id={0} and status in ('ADD','ISS','ACK') and subtask_id<>{1}", TaskID, SubTaskID)) == 0) { bll.ExecNonQuery("WCS.sp_FinshedTaskToBak", new DataParameter[] { new DataParameter("@TaskID", TaskID) }); } } else if (State == "9") { } BindData(); } }
private void frmUserList_Load(object sender, EventArgs e) { bll.ExecNonQuery("Security.InsertGroupOperationList"); colbtn.Name = "Detail"; colbtn.DefaultCellStyle.NullValue = "删除用户"; InitSmartTree(); DataTable dt = Program.dtUserPermission; //用户资料 string filter = "SubModuleCode='MNU_W00C_00E' and OperatorCode='2'"; DataRow[] drs = dt.Select(filter); if (drs.Length <= 0) { this.toolStripButton_AddUser.Visible = false; } else { this.toolStripButton_AddUser.Visible = true; } filter = "SubModuleCode='MNU_W00C_00E' and OperatorCode='3'"; drs = dt.Select(filter); if (drs.Length <= 0) { this.dgvGroupUser.Columns[2].Visible = false; } else { this.dgvGroupUser.Columns[2].Visible = true; } }
protected void btnSave_Click(object sender, EventArgs e) { if (this.txtAreaID.Text.Trim().Length == 0)//新增 { int count = bll.GetRowCount(TableName, string.Format("AreaCode='{0}'", this.txtAreaCode.Text)); if (count > 0) { WMS.App_Code.JScript.Instance.ShowMessage(this, "此库区编码已存在,不能新增!"); return; } bll.ExecNonQuery("Cmd.InsertArea", new DataParameter[] { new DataParameter("@AreaCode", this.txtAreaCode.Text), new DataParameter("@AreaName", this.txtAreaName.Text.Trim().Replace("\'", "\''")), new DataParameter("@WarehouseCode", this.txtWHID.Text), new DataParameter("@Memo", this.txtMemo.Text.Trim()) }); WMS.App_Code.JScript.Instance.RegisterScript(this, "ReloadParent();"); AddOperateLog("库区管理", "添加库区信息"); } else { bll.ExecNonQuery("Cmd.UpdateArea", new DataParameter[] { new DataParameter("@AreaName", this.txtAreaName.Text.Trim().Replace("\'", "\''")), new DataParameter("@MEMO", this.txtMemo.Text.Trim()), new DataParameter("{0}", this.txtAreaID.Text) }); WMS.App_Code.JScript.Instance.RegisterScript(this, "UpdateParent();"); AddOperateLog("库区管理", "修改库区信息"); } }
protected void btnSave_Click(object sender, EventArgs e) { if (strID == "") //新增 { int Count = bll.GetRowCount("CMD_Car", string.Format("CarNo='{0}'", this.txtID.Text)); if (Count > 0) { WMS.App_Code.JScript.Instance.ShowMessage(this.Page, "该小车编码已经存在!"); return; } bll.ExecNonQuery("Cmd.InsertCar", new DataParameter[] { new DataParameter("@CarNo", this.txtID.Text.Trim()), new DataParameter("@CarName", this.txtTypeName.Text.Trim()), new DataParameter("@State", this.ddlActive.SelectedValue), new DataParameter("@Memo", this.txtMemo.Text.Trim()) }); } else //修改 { bll.ExecNonQuery("Cmd.UpdateCar", new DataParameter[] { new DataParameter("@CarName", this.txtTypeName.Text.Trim()), new DataParameter("@State", this.ddlActive.SelectedValue), new DataParameter("@Memo", this.txtMemo.Text.Trim()), new DataParameter("@CarNo", this.txtID.Text.Trim()) }); } Response.Redirect(FormID + "View.aspx?SubModuleCode=" + SubModuleCode + "&FormID=" + Server.UrlEncode(FormID) + "&SqlCmd=" + SqlCmd + "&ID=" + Server.UrlEncode(this.txtID.Text)); }
private void ToolStripMenuItemReassign_Click(object sender, EventArgs e) { if (this.dgvMain.CurrentCell != null) { BLL.BLLBase bll = new BLL.BLLBase(); string TaskNo = this.dgvMain.Rows[this.dgvMain.CurrentCell.RowIndex].Cells[0].Value.ToString(); string TaskType = this.dgvMain.Rows[this.dgvMain.CurrentCell.RowIndex].Cells["colTaskType"].Value.ToString(); if (TaskType == "11") { bll.ExecNonQuery("WCS.UpdateTaskStateByTaskNo", new DataParameter[] { new DataParameter("@State", 2), new DataParameter("@TaskNo", TaskNo) }); } else if (TaskType == "12" || TaskType == "13") { bll.ExecNonQuery("WCS.UpdateTaskStateByTaskNo", new DataParameter[] { new DataParameter("@State", 0), new DataParameter("@TaskNo", TaskNo) }); } else if (TaskType == "14") { frmTaskOption f = new frmTaskOption(); if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK) { if (f.option == 0) { bll.ExecNonQuery("WCS.UpdateTaskStateByTaskNo", new DataParameter[] { new DataParameter("@State", 2), new DataParameter("@TaskNo", TaskNo) }); } else { bll.ExecNonQuery("WCS.UpdateTaskStateByTaskNo", new DataParameter[] { new DataParameter("@State", 5), new DataParameter("@TaskNo", TaskNo) }); } } } this.BindData(); } }
private void btnOK_Click(object sender, EventArgs e) { int Pallets = 0; if (this.txtProductCode.Text.Trim().Length <= 0) { MessageBox.Show("产品编号不能为空,请选取!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.btnProductCode.Focus(); return; } if (this.txtBillID.Text.Trim().Length <= 0) { MessageBox.Show("单号不能为空,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.txtBillID.Focus(); return; } int.TryParse(this.txtPallets.Text.Trim(), out Pallets); if (Pallets <= 0) { MessageBox.Show("计划盘数不正确,请重输!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.txtPallets.Focus(); return; } if (BillID.Length <= 0) //新增 { int Count = bll.GetRowCount("WCS_ProducePlan", string.Format("BillID='{0}'", this.txtBillID.Text.Trim())); if (Count > 0) { this.txtBillID.Text = bll.GetAutoCode("PP", this.dtpBillDate.Value, "1=1"); } bll.ExecNonQuery("WCS.InsertProducePlan", new DataParameter[] { new DataParameter("@BillDate", this.dtpBillDate.Value), new DataParameter("@BillID", this.txtBillID.Text), new DataParameter("@ProductCode", this.txtProductCode.Text.Trim()), new DataParameter("@Pallets", Pallets), new DataParameter("@AdjustedPallets", Pallets), new DataParameter("@State", "0"), new DataParameter("@Memo", this.txtMemo.Text.Trim()), new DataParameter("@Creator", "admin"), new DataParameter("@Adjuster", "admin") }); } else { bll.ExecNonQuery("WCS.UpdateProducePlan", new DataParameter[] { new DataParameter("@BillID", this.txtBillID.Text), new DataParameter("@AdjustedPallets", Pallets), new DataParameter("@Memo", this.txtMemo.Text.Trim()), new DataParameter("@Adjuster", "admin") }); } this.DialogResult = System.Windows.Forms.DialogResult.OK; }
private void btnOK_Click(object sender, EventArgs e) { if (this.txtDeviceNo.Text.Trim().Length <= 0) { MessageBox.Show("设备编号不能为空,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.txtDeviceNo.Focus(); return; } if (this.txtDeviceName.Text.Trim().Length <= 0) { MessageBox.Show("设备名称不能为空,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.txtDeviceName.Focus(); return; } if (DeviceNo.Length <= 0) //新增 { int Count = bll.GetRowCount("CMD_Device", string.Format("DeviceNo='{0}'", this.txtDeviceNo.Text.Trim())); if (Count > 0) { MessageBox.Show("该设备编号已经存在,请确认!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.txtDeviceNo.Focus(); return; } bll.ExecNonQuery("Cmd.InsertDevice", new DataParameter[] { new DataParameter("@Flag", dr["Flag"]), new DataParameter("@DeviceType", dr["DeviceType"]), new DataParameter("@DeviceNo", this.txtDeviceNo.Text.Trim()), new DataParameter("@DeviceNo2", this.txtDeviceNo2.Text.Trim()), new DataParameter("@DeviceName", this.txtDeviceName.Text), new DataParameter("@State", this.cmbState.SelectedIndex), new DataParameter("@AlarmCode", this.txtAlarmCode.Text), new DataParameter("@ServiceName", this.txtServiceName.Text), new DataParameter("@Memo", this.txtMemo.Text.Trim()), new DataParameter("@Creator", "admin"), new DataParameter("@Updater", "admin") }); } else //修改 { bll.ExecNonQuery("Cmd.UpdateDevice", new DataParameter[] { new DataParameter("@Flag", this.txtFlag.Text), new DataParameter("@DeviceType", this.txtDeviceType.Text), new DataParameter("@DeviceNo", this.txtDeviceNo.Text.Trim()), new DataParameter("@DeviceNo2", this.txtDeviceNo2.Text.Trim()), new DataParameter("@DeviceName", this.txtDeviceName.Text), new DataParameter("@State", this.cmbState.SelectedIndex), new DataParameter("@AlarmCode", this.txtAlarmCode.Text), new DataParameter("@ServiceName", this.txtServiceName.Text), new DataParameter("@Memo", this.txtMemo.Text.Trim()), new DataParameter("@Updater", "admin") }); } this.DialogResult = System.Windows.Forms.DialogResult.OK; }
private void Send2PLC(string serviceName, DataRow dr, string carNo) { string TaskNo = dr["TaskNo"].ToString(); string BillID = dr["BillID"].ToString(); string TaskType = dr["TaskType"].ToString(); string state = dr["State"].ToString(); int taskType = 10; string NextState = "3"; if (state == "0") { if (TaskType == "13") { taskType = 9; NextState = "4"; } else { taskType = 11; NextState = "4"; } } string fromStation = dr["FromStation"].ToString(); string toStation = dr["ToStation"].ToString(); int[] cellAddr = new int[10]; cellAddr[0] = 0; cellAddr[1] = 0; cellAddr[2] = 0; cellAddr[3] = byte.Parse(fromStation.Substring(0, 3)); cellAddr[4] = byte.Parse(fromStation.Substring(3, 3)); cellAddr[5] = byte.Parse(fromStation.Substring(6, 3)); cellAddr[6] = byte.Parse(toStation.Substring(0, 3)); cellAddr[7] = byte.Parse(toStation.Substring(3, 3)); cellAddr[8] = byte.Parse(toStation.Substring(6, 3)); cellAddr[9] = taskType; int taskNo = int.Parse(TaskNo); Context.ProcessDispatcher.WriteToService(serviceName, "TaskAddress", cellAddr); Context.ProcessDispatcher.WriteToService(serviceName, "TaskNo", taskNo); if (WriteToService(serviceName, "WriteFinished", 1)) { bll.ExecNonQuery("WCS.UpdateTaskTimeByTaskNo", new DataParameter[] { new DataParameter("@State", NextState), new DataParameter("@CarNo", carNo), new DataParameter("@TaskNo", TaskNo) }); bll.ExecNonQuery("WCS.UpdateBillStateByBillID", new DataParameter[] { new DataParameter("@State", 3), new DataParameter("@BillID", BillID) }); } Logger.Info("任务:" + dr["TaskNo"].ToString() + "已下发给" + carNo + "穿梭车;起始地址:" + fromStation + ",目标地址:" + toStation); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (this.txtShelfID.Text.Trim().Length == 0) { int count = bll.GetRowCount("CMD_WH_SHELF", string.Format("ShelfCode='{0}'", this.txtShelfCode.Text)); if (count > 0) { WMS.App_Code.JScript.Instance.ShowMessage(this, "此货架编码已存在,不能新增!"); return; } bll.ExecNonQuery("Cmd.InsertShelf", new DataParameter[] { new DataParameter("@WarehouseCode", this.txtWHID.Text), new DataParameter("@AreaCode", this.txtAreaID.Text.Trim()), new DataParameter("@ShelfCode", this.txtShelfCode.Text), new DataParameter("@ShelfName", this.txtShelfName.Text.Trim()), new DataParameter("@Rows", this.txtCellRows.Text), new DataParameter("@Columns", this.txtCellCols.Text.Trim()), new DataParameter("@IsActive", this.ddlActive.SelectedValue), new DataParameter("@Memo", this.txtMemo.Text.Trim()) }); //this.btnContinue.Enabled = true; //this.btnSave.Enabled = false; WMS.App_Code.JScript.Instance.RegisterScript(this, "ReloadParent();"); AddOperateLog("货贺管理", "添加货贺信息"); } else { bll.ExecNonQuery("Cmd.UpdateShelf", new DataParameter[] { new DataParameter("@WarehouseCode", this.txtWHID.Text), new DataParameter("@AreaCode", this.txtAreaID.Text.Trim()), new DataParameter("@ShelfName", this.txtShelfName.Text.Trim()), new DataParameter("@Rows", this.txtCellRows.Text), new DataParameter("@Columns", this.txtCellCols.Text.Trim()), new DataParameter("@IsActive", this.ddlActive.SelectedValue), new DataParameter("@Memo", this.txtMemo.Text.Trim()), new DataParameter("{0}", this.txtShelfID.Text) }); WMS.App_Code.JScript.Instance.RegisterScript(this, "UpdateParent();"); AddOperateLog("货贺管理", "修改货贺信息"); } } catch (Exception exp) { WMS.App_Code.JScript.Instance.ShowMessage(this, exp.Message); } //JScript.Instance.RegisterScript(this, "window.close();"); }
private void dgvGroupUser_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 2) { if ((this.dgvGroupUser.Rows[e.RowIndex].DataBoundItem as DataRowView).Row["UserName"].ToString() != "admin") { bll.ExecNonQuery("Security.UpdateUserGroup", new DataParameter[] { new DataParameter("@GroupID", 0), new DataParameter("{0}", (this.dgvGroupUser.Rows[e.RowIndex].DataBoundItem as DataRowView).Row["UserID"].ToString()) }); BindDataSub(); } else { Logger.Info("用户组不能删除管理员账号!"); } } }
void Logger_OnLog(MCP.LogEventArgs args) { if (InvokeRequired) { BeginInvoke(new LogEventHandler(Logger_OnLog), args); } else { lock (lbLog) { string msg1 = string.Format("[{0}]", args.LogLevel); string msg2 = string.Format(" {0}", DateTime.Now); string msg3 = string.Format(" {0}", args.Message); if (args.LogLevel != LogLevel.DEBUG) { this.lbLog.BeginUpdate(); ListViewItem item = new ListViewItem(new string[] { msg1, msg2, msg3 }); if (msg1.Contains("[ERROR]")) { //item.ForeColor = Color.Red; item.BackColor = Color.Red; } lbLog.Items.Insert(0, item); this.lbLog.EndUpdate(); } WriteLoggerFile(msg1 + msg2 + msg3); if (!msg1.Contains("[DEBUG]")) { bll.ExecNonQuery("WCS.InsertLog", new DataParameter[] { new DataParameter("@LogDate", DateTime.Now), new DataParameter("@LogType", args.LogLevel.ToString()), new DataParameter("@Info", args.Message.ToString()) }); } } } }
private void Send2PLCAGV(DataRow dr) { string TaskNo = dr["TaskNo"].ToString(); BLL.BLLBase bllAGV = new BLL.BLLBase("AGVDB"); DataTable dt = bllAGV.FillDataTable("WCS.SelectAGVTask", new DataParameter[] { new DataParameter("{0}", string.Format("call_from='{0}'", TaskNo)) }); //将A改成 中间库的实际表明 bool blnInsert = false; if (dt.Rows.Count == 0) { blnInsert = true; } if (dt.Rows.Count > 0) { DataRow[] drs = dt.Select("Status in (0,1,5)"); if (drs.Length == 0) { blnInsert = true; } } if (blnInsert) { bllAGV.ExecNonQuery("WCS.InsertAGVTask", new DataParameter[] { new DataParameter("@from_station", ""), new DataParameter("@to_station", ""), new DataParameter("@TaskNo", TaskNo) }); Logger.Info("重新下发AGV任务,任务号:" + TaskNo); } }
private void toolStripButton_Delete_Click(object sender, EventArgs e) { if (this.dgvMain.CurrentRow == null) { return; } if (this.dgvMain.CurrentRow.Index >= 0) { string ProductCode = this.dgvMain.SelectedRows[0].Cells[0].Value.ToString(); if (this.dgvMain.SelectedRows[0].Cells["colFixed"].Value.ToString() == "0") { //删除产品,先判断此产品是否被用到 //判断能否删除 int Count = bll.GetRowCount("VUsed_CMD_Product", string.Format("ProductCode='{0}'", ProductCode)); if (Count > 0) { MessageBox.Show("此产品已被单据使用,不可删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (MessageBox.Show("您确定要删除此产品吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { bll.ExecNonQuery("Cmd.DeleteProduct", new DataParameter[] { new DataParameter("{0}", ProductCode) }); this.BindData(); } } else { MessageBox.Show("此产品为系统内定,不可删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } }
/// <summary> /// 保存当前组用户 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { try { UpdateTempUser(); string users = "-1,"; if (ViewState["hdnRowValue"].ToString().Length > 0) { users += ViewState["hdnRowValue"].ToString().Replace("'", ""); } users += "-1"; BLL.BLLBase bll = new BLL.BLLBase(); bll.ExecNonQuery("Security.UpdateUserGroup", new DataParameter[] { new DataParameter("@GroupID", GroupID), new DataParameter("{0}", users) }); ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.UpdatePanel1.GetType(), "Resize", "Close('1');", true); } catch (Exception ex) { System.Diagnostics.StackFrame frame = new System.Diagnostics.StackFrame(0); Session["ModuleName"] = this.Page.Title; Session["FunctionName"] = frame.GetMethod().Name; Session["ExceptionalType"] = ex.GetType().FullName; Session["ExceptionalDescription"] = ex.Message; Response.Redirect("../../../Common/MistakesPage.aspx"); } }
protected void btnDelete_Click(object sender, EventArgs e) { try { string strUserID = "-1,"; for (int i = 0; i < gvMain.Rows.Count; i++) { CheckBox chk = (CheckBox)gvMain.Rows[i].Cells[0].Controls[0]; if (gvMain.Rows[i].Cells[1].Text == "admin" && chk.Checked) { WMS.App_Code.JScript.Instance.ShowMessage(this.UpdatePanel1, "管理员帐号不能删除!"); continue; } if (chk.Enabled && chk.Checked) { strUserID += dtUser.Rows[i]["UserID"].ToString() + ","; } } strUserID += "-1"; bll.ExecNonQuery("Security.DeleteUser", new DataParameter[] { new DataParameter("{0}", strUserID) }); AddOperateLog("用户管理", "删除用户信息"); SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, gvMain, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1); } catch (Exception exp) { WMS.App_Code.JScript.Instance.ShowMessage(this.UpdatePanel1, exp.Message); } }
private void btnOK_Click(object sender, EventArgs e) { if (this.txtUser.Text.Trim().Length == 0) { MessageBox.Show("请输入用户!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (this.txtPWD.Text.Trim().Length == 0) { MessageBox.Show("请输入密码!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } try { BLL.BLLBase bll = new BLL.BLLBase(); DataTable dt = bll.FillDataTable("WCS.SelectUserByName", new DataParameter[] { new DataParameter("{0}", this.txtUser.Text.Trim()) }); if (dt.Rows.Count > 0) { MessageBox.Show("该用户已经存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { bll.ExecNonQuery("WCS.InserUser", new DataParameter[] { new DataParameter("{0}", this.txtUser.Text.Trim()), new DataParameter("{1}", this.txtPWD.Text.Trim()) }); this.DialogResult = DialogResult.OK; } } catch (Exception ex) { MessageBox.Show("请输入正确数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } }
/// <summary> /// 保存当前组用户 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { try { UpdateTempUser(); string users = "-1,"; if (ViewState["hdnRowValue"].ToString().Length > 0) users += ViewState["hdnRowValue"].ToString().Replace("'", ""); users += "-1"; BLL.BLLBase bll = new BLL.BLLBase(); bll.ExecNonQuery("Security.UpdateUserGroup", new DataParameter[] { new DataParameter("@GroupID", GroupID), new DataParameter("{0}", users) }); ScriptManager.RegisterClientScriptBlock(this.UpdatePanel1, this.UpdatePanel1.GetType(), "Resize", "Close('1');", true); } catch(Exception ex) { System.Diagnostics.StackFrame frame = new System.Diagnostics.StackFrame(0); Session["ModuleName"] = this.Page.Title; Session["FunctionName"] = frame.GetMethod().Name; Session["ExceptionalType"] = ex.GetType().FullName; Session["ExceptionalDescription"] = ex.Message; Response.Redirect("../../../Common/MistakesPage.aspx"); } }
public string ImportWCSTask(string taskData) { Log.WriteToLog("1", "transSRMTask-Rec", taskData); string json = ""; string id = ""; string state = ""; string State = ""; try { DataTable dt = Util.JsonHelper.Json2Dtb(taskData); if (dt.Rows.Count > 0) { id = dt.Rows[0]["id"].ToString(); } else { id = ""; } bll.ExecNonQuery("WCS.DeleteWcsTemp"); bll.BatchInsertTable(dt, "WCS_TaskTemp"); bll.ExecNonQueryTran("WCS.Sp_ImportWmsTask"); json = "{\"id\":\"" + id + "\",\"returnCode\":\"000\"" + ",\"message\":\"成功\",\"finishDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\",\"field1\":\"null\"}"; } catch (Exception ex) { json = "{\"id\":\"" + id + "\",\"returnCode\":\"001\"" + ",\"message\":\"" + ex.Message + "\"" + ",\"finishDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\",\"field1\":\"" + ex.Message + "\"}"; } Log.WriteToLog("1", "transSRMTask-Rtn", json); return(json); }
protected void btnDeletet_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 && cb.Enabled) { HyperLink hk = (HyperLink)(this.GridView1.Rows[i].FindControl("HyperLink1")); //判断能否删除 int Count = bll.GetRowCount("VUsed_CMD_ProductType", string.Format("ProductTypeCode='{0}'", hk.Text)); if (Count > 0) { WMS.App_Code.JScript.Instance.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "产品类别被其它单据使用,请调整后再删除!"); return; } strColorCode += "'" + hk.Text + "',"; } } strColorCode += "'-1'"; bll.ExecNonQuery("Cmd.DeleteProductType", new DataParameter[] { new DataParameter("{0}", strColorCode) }); AddOperateLog("产品类别", "删除单号:" + strColorCode.Replace("'-1',", "").Replace(",'-1'", "")); SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, GridView1, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1); }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { string strModuleName, strFunctionName, strExceptionalType, strExceptionalDescription; strModuleName = Session["ModuleName"].ToString(); strFunctionName = Session["FunctionName"].ToString(); strExceptionalType = Session["ExceptionalType"].ToString(); strExceptionalDescription = Session["ExceptionalDescription"].ToString(); labModuleName.Text = strModuleName; labFunctionName.Text = strFunctionName; labExceptionalType.Text = strExceptionalType; labExceptionalDescription.Text = strExceptionalDescription; BLL.BLLBase bll = new BLL.BLLBase(); bll.ExecNonQuery("Security.InsertExceptionalLog", new DataParameter[] { new DataParameter("@CatchTime", System.DateTime.Now), new DataParameter("@ModuleName", strModuleName), new DataParameter("@FunctionName", strFunctionName), new DataParameter("@ExceptionalType", strExceptionalType), new DataParameter("@ExceptionalDescription", strExceptionalDescription) }); } } catch (Exception ex) { Response.Write(ex.Message); } }
private void toolStripButton_Del_Click(object sender, EventArgs e) { if (MessageBox.Show("确定要删除数据吗?", "询问", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { string strCode = "'-1',"; for (int i = 0; i < dgvMain.RowCount; i++) { if (dgvMain.Rows[i].Cells[0].EditedFormattedValue.ToString() == "True") { DataRow dr = ((DataRowView)dgvMain.Rows[i].DataBoundItem).Row; if (bll.GetRowCount("VUsed_CMD_ProductCategory", "CategoryCode='" + dr["CategoryCode"].ToString() + "'") > 0) { Logger.Info("产品类别编号 " + dr["CategoryCode"].ToString() + " 已经被其它单据使用,无法删除!"); return; } strCode += "'" + dr["CategoryCode"].ToString() + "',"; } } strCode += "'-1'"; bll.ExecNonQuery("Cmd.DeleteProductCategory", new DataParameter[] { new DataParameter("{0}", strCode) }); Logger.Info("删除产品类别编号:" + strCode.Replace("'-1',", "").Replace(",'-1'", "").Replace("'", "")); this.BindData("1=1"); } }
protected void btnDeletet_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) { HyperLink hk = (HyperLink)(this.GridView1.Rows[i].FindControl("HyperLink1")); //判断能否删除 int Count = bll.GetRowCount("VUsed_CMD_BillType", string.Format("BillTypeCode='{0}'", hk.Text)); if (Count > 0) { WMS.App_Code.JScript.Instance.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "入库类型被其它单据使用,请调整后再删除!"); return; } strColorCode += "'" + hk.Text + "',"; } } strColorCode += "'-1'"; bll.ExecNonQuery("Cmd.DeleteBillType", new DataParameter[] { new DataParameter("{0}", strColorCode) }); AddOperateLog("入库类型", "删除单号:" + strColorCode.Replace("'-1',", "").Replace(",'-1'", "")); SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, GridView1, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1); }
private void toolStripButton_Del_Click(object sender, EventArgs e) { if (this.dgvMain.CurrentRow == null) { return; } if (this.dgvMain.CurrentRow.Index >= 0) { if (this.dgvMain.CurrentRow.Cells["colGroupName"].Value.ToString() != "admin") { if (DialogResult.Yes == MessageBox.Show("您确定要删除此用户组吗?", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { int membercount = (int)bll.ExecScalar("Security.SelectGroupMemberCount", new DataParameter[] { new DataParameter("@GroupID", Convert.ToInt32((this.dgvMain.CurrentRow.DataBoundItem as DataRowView).Row["GroupID"]).ToString()) }); if (membercount > 0) { Logger.Info("用户组还有用户存在,请调整后再删除!"); return; } bll.ExecNonQuery("Security.DeleteGroup", new DataParameter[] { new DataParameter("{0}", (this.dgvMain.CurrentRow.DataBoundItem as DataRowView).Row["GroupID"].ToString()) }); this.BindData(); } } else { Logger.Info("管理用户组不能删除!"); return; } } }
private void btnOK_Click(object sender, EventArgs e) { try { string users = "-1,"; for (int i = 0; i < dgvMain.Rows.Count; i++) { if (dgvMain.Rows[i].Cells[0].Value != null) { if (dgvMain.Rows[i].Cells[0].Value.ToString() == "True") { users += (dgvMain.Rows[i].DataBoundItem as DataRowView).Row["UserID"].ToString() + ","; } } } users += "-1"; bll.ExecNonQuery("Security.UpdateUserGroup", new DataParameter[] { new DataParameter("@GroupID", GroupID), new DataParameter("{0}", users) }); this.DialogResult = DialogResult.OK; } catch (Exception ex) { } }
public TaskRtn transWCSTask(List <Task> list) { lock (this) { string Json = List2Json(list); Log.WriteToLog("1", "transSRMTask--Rec", Json); string rtnMessage = ""; string id = ""; TaskRtn taskRtn = new TaskRtn(); try { DataTable dt = Util.JsonHelper.Json2Dtb(Json); if (dt.Rows.Count > 0) { id = dt.Rows[0]["id"].ToString(); } else { id = ""; } BLL.BLLBase bll = new BLL.BLLBase(); bll.ExecNonQuery("WCS.DeleteWcsTemp"); bll.BatchInsertTable(dt, "WCS_TaskTemp"); DataTable dtTask = bll.FillDataTable("WCS.Sp_ImportWmsTask"); if (dtTask.Rows.Count > 0) { taskRtn.id = id; taskRtn.returnCode = "000"; taskRtn.message = "成功"; taskRtn.finishDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); taskRtn.field1 = "null"; rtnMessage = "{\"id\":\"" + id + "\",\"returnCode\":\"000\"" + ",\"message\":\"成功\",\"finishDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\",\"field1\":\"null\"}"; } else { taskRtn.id = id; taskRtn.returnCode = "001"; taskRtn.message = "失败"; taskRtn.finishDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); taskRtn.field1 = "null"; rtnMessage = "{\"id\":\"" + id + "\",\"returnCode\":\"001\"" + ",\"message\":\"" + taskRtn.message + "\"" + ",\"finishDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\",\"field1\":\"null\"}"; } } catch (Exception ex) { taskRtn.id = id; taskRtn.returnCode = "001"; taskRtn.message = ex.Message; taskRtn.finishDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"); taskRtn.field1 = "null"; rtnMessage = "{\"id\":\"" + id + "\",\"returnCode\":\"001\"" + ",\"message\":\"" + ex.Message + "\"" + ",\"finishDate\":\"" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "\",\"field1\":\"" + ex.Message + "\"}"; } Log.WriteToLog("1", "transSRMTask-Rtn", rtnMessage); return(taskRtn); //return rtnMessage; } }
protected void btnSave_Click(object sender, EventArgs e) { BLL.BLLBase bll = new BLL.BLLBase(); bll.ExecNonQuery("Security.DeleteQuickDestop", new DataParameter[] { new DataParameter("@UserID", Convert.ToInt32(Session["UserID"].ToString())) }); foreach (TreeNode tnRoot in this.sTreeModule.Nodes) { foreach (TreeNode tnSub in tnRoot.ChildNodes) { if (tnSub.Checked) { string strModuleID = tnSub.Value; bll.ExecNonQuery("Security.InsertQuickDestop", new DataParameter[] { new DataParameter("@UserID", Convert.ToInt32(Session["UserID"].ToString())), new DataParameter("@ModuleID", strModuleID) }); } } } WMS.App_Code.JScript.Instance.ShowMessage(this, "设置成功!"); }
private void ToolStripMenuItemChangeCarNo_Click(object sender, EventArgs e) { string ItemName = ((ToolStripMenuItem)sender).Name; string State = ItemName.Substring(ItemName.Length - 1, 1); if (this.dgvMain.CurrentCell != null) { BLL.BLLBase bll = new BLL.BLLBase(); string TaskNo = this.dgvMain.Rows[this.dgvMain.CurrentCell.RowIndex].Cells[0].Value.ToString(); string CraneNo = this.dgvMain.Rows[this.dgvMain.CurrentCell.RowIndex].Cells["colCraneNo"].Value.ToString(); frmTaskCarNo f = new frmTaskCarNo(CraneNo); if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string CarNo = f.carNo; bll.ExecNonQuery("WCS.UpdateTaskCarNoByTaskNo", new DataParameter[] { new DataParameter("@CarNo", CarNo), new DataParameter("@TaskNo", TaskNo) }); } BindData(); } }
private void ToolStripMenuItemReassign_Click(object sender, EventArgs e) { if (this.dgvMain.CurrentCell != null) { BLL.BLLBase bll = new BLL.BLLBase(); string TaskNo = this.dgvMain.Rows[this.dgvMain.CurrentCell.RowIndex].Cells[0].Value.ToString(); string TaskType = this.dgvMain.Rows[this.dgvMain.CurrentCell.RowIndex].Cells["colTaskType"].Value.ToString(); if (TaskType == "11") bll.ExecNonQuery("WCS.UpdateTaskStateByTaskNo", new DataParameter[] { new DataParameter("@State", 2), new DataParameter("@TaskNo", TaskNo) }); else if (TaskType == "12" || TaskType == "13") bll.ExecNonQuery("WCS.UpdateTaskStateByTaskNo", new DataParameter[] { new DataParameter("@State", 0), new DataParameter("@TaskNo", TaskNo) }); else if (TaskType == "14") { frmTaskOption f = new frmTaskOption(); if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK) { if(f.option==0) bll.ExecNonQuery("WCS.UpdateTaskStateByTaskNo", new DataParameter[] { new DataParameter("@State", 2), new DataParameter("@TaskNo", TaskNo) }); else bll.ExecNonQuery("WCS.UpdateTaskStateByTaskNo", new DataParameter[] { new DataParameter("@State", 5), new DataParameter("@TaskNo", TaskNo) }); } } this.BindData(); } }
protected override void StateChanged(StateItem stateItem, IProcessDispatcher dispatcher) { try { object obj = ObjectUtil.GetObject(stateItem.State); if (obj == null) return; if (obj.ToString() == "48" || obj.ToString() == "0") return; string carNo = stateItem.ItemName.Substring(0, 2); Logger.Info("小车" + carNo + "接到入库确认请求"); string CraneNo = "01"; if (carNo == "02") CraneNo = "02"; BLL.BLLBase bll = new BLL.BLLBase(); //判断堆垛机状态是否可用 //查找有无请求状态(state='1')的任务,如没有则认为是空托盘回库 string filter = string.Format("WCS_Task.State='1' and WCS_TASK.TaskType='11' and WCS_TASK.CarNo='{0}'", carNo); DataParameter[] parameter = new DataParameter[] { new DataParameter("{0}", filter) }; DataTable dt = bll.FillDataTable("WCS.SelectTask", parameter); int rows = 0; if (dt.Rows.Count > 0) { rows = bll.ExecNonQuery("WCS.UpdateTaskState", new DataParameter[] { new DataParameter("@State", 2), new DataParameter("@CarNo", carNo) }); WriteToService("CarPLC", carNo + "_CarReply", 49); Logger.Info("小车:" + carNo + "收到入库请求,更新任务状态,影响行数" + rows); } else { //判断有无正在执行的任务,如有不做处理,如没有则产生一笔空盘回库任务 filter = string.Format("WCS_Task.State='3' and WCS_TASK.TaskType='11' and WCS_TASK.CarNo='{0}'", carNo); parameter = new DataParameter[] { new DataParameter("{0}", filter) }; DataTable dting = bll.FillDataTable("WCS.SelectTask", parameter); if (dting.Rows.Count > 0) { WriteToService("CarPLC", carNo + "_CarReply", 50); return; } //有无盘点回库任务 filter = string.Format("WCS_Task.State='4' and WCS_TASK.TaskType='14' and WCS_TASK.CarNo='{0}'", carNo); parameter = new DataParameter[] { new DataParameter("{0}", filter) }; dting = bll.FillDataTable("WCS.SelectTask", parameter); if (dting.Rows.Count > 0) { //盘点任务改变状态为5,堆垛机调度回库 string TaskNo = dting.Rows[0]["TaskNo"].ToString(); bll.ExecNonQuery("WCS.UpdateTaskStateByTaskNo", new DataParameter[] { new DataParameter("@State", 5), new DataParameter("@TaskNo", TaskNo) }); WriteToService("CarPLC", carNo + "_CarReply", 49); return; } //查找锁定货位,且产品是托盘的货位,如有判断为实托盘出库后,托盘回库 string ProductCode = "00" + CraneNo; parameter = new DataParameter[] { new DataParameter("{0}", string.Format("CMD_Cell.ProductCode='{0}' and CMD_Cell.IsActive='1' and CMD_Cell.IsLock='1' and CMD_Cell.ErrorFlag!='1'",ProductCode)), new DataParameter("{1}", carNo) }; dt = bll.FillDataTable("CMD.SelectCellByCar", parameter); if (dt.Rows.Count > 0) { //产生一笔空托盘入库任务 //锁定货位 parameter = new DataParameter[] { new DataParameter("@CarNo", carNo), new DataParameter("@CraneNo", CraneNo), new DataParameter("@CellCode", dt.Rows[0]["CellCode"].ToString()) }; bll.ExecNonQueryTran("WCS.Sp_RequestPalletInTask", parameter); WriteToService("CarPLC", carNo + "_CarReply", 49); Logger.Info("小车:" + carNo + "接到入库请求,产生一笔托盘回库任务"); } } WriteToService("CarPLC", carNo + "_CarReply", 50); } catch (Exception e) { Logger.Error("Dispatching.Process.CarProcess:" + e.Message); } }
/// <summary> /// 添加操作日志 /// </summary> /// <param name="moduleName">操作模块</param> /// <param name="executeOperation">操作内容</param> protected void AddOperateLog(string moduleName, string executeOperation) { BLL.BLLBase bll = new BLL.BLLBase(); bll.ExecNonQuery("Security.InsertOperatorLog", new IDAL.DataParameter[]{new IDAL.DataParameter("@LoginUser",App_Code.LoginUserInfo.UserName),new IDAL.DataParameter("@LoginTime",DateTime.Now), new IDAL.DataParameter("@LoginModule",moduleName),new IDAL.DataParameter("@ExecuteOperator",executeOperation)}); }
private void UpdatedgvMainState(string State) { if (this.dgvMain.CurrentCell != null) { BLL.BLLBase bll = new BLL.BLLBase(); string TaskNo = this.dgvMain.Rows[this.dgvMain.CurrentCell.RowIndex].Cells[0].Value.ToString(); bll.ExecNonQuery("WCS.UpdateTaskStateByTaskNo", new DataParameter[] { new DataParameter("@State", State), new DataParameter("@TaskNo", TaskNo) }); //堆垛机完成执行 if (State == "7") { DataParameter[] param = new DataParameter[] { new DataParameter("@TaskNo", TaskNo) }; bll.ExecNonQueryTran("WCS.Sp_TaskProcess", param); } BindData(); } }
//protected void Page_Load(object sender, EventArgs e) //{ // if (Page.Request.Url.Query != "") // { // //ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Resize", "alert(\"对不起,操作时限已过,请重新登入!\");window.top.location =\"Login.aspx\";", true); // } //} protected void btnLogin_Click(object sender, EventArgs e) { //测试 Request.Cookies.Clear(); if (txtUserName.Text.Trim() != "") { try { string key = txtUserName.Text.ToLower(); string UserCache = Convert.ToString(Cache[key]); UserBll userBll = new UserBll(); DataTable dtUserList = userBll.GetUserInfo(txtUserName.Text.Trim()); if (dtUserList != null && dtUserList.Rows.Count > 0) { if (dtUserList.Rows[0]["UserPassword"].ToString().Trim() == txtPassWord.Text.Trim()) { FormsAuthentication.SetAuthCookie(this.txtUserName.Text, false); Session["UserID"] = dtUserList.Rows[0]["UserID"].ToString(); Session["GroupID"] = dtUserList.Rows[0]["GroupID"].ToString(); Session["G_user"] = dtUserList.Rows[0]["UserName"].ToString(); string EmployeeCode = dtUserList.Rows[0]["EmployeeCode"].ToString(); App_Code.LoginUserInfo.UserName = dtUserList.Rows[0]["UserName"].ToString(); App_Code.LoginUserInfo.UserCode = EmployeeCode; Session["EmployeeCode"] = dtUserList.Rows[0]["EmployeeCode"].ToString(); //Session["sys_PageCount"] = 15; //Session["grid_ColumnTitleFont"] = "楷体_GB2312,Coral,10,加粗"; //Session["grid_ContentFont"] = "宋体,Black,10,正常"; //Session["grid_ColumnTextAlign"] = "1"; //Session["grid_ContentTextAlign"] = "1"; //Session["grid_NumberColumnAlign"] = "1"; //Session["grid_MoneyColumnAlign"] = "1"; //Session["grid_SelectMode"] = "0"; //Session["grid_IsRefreshBeforeAdd"] = "1"; //Session["grid_IsRefreshBeforeUpdate"] = "1"; //Session["grid_IsRefreshBeforeDelete"] = "1"; //Session["grid_OddRowColor"] = "White"; //Session["grid_EvenRowColor"] = "AliceBlue"; //Session.Timeout = int.Parse(ConfigurationManager.AppSettings["SessionTimeOut"]); #region 添加登录日志 BLL.BLLBase bll = new BLL.BLLBase(); bll.ExecNonQuery("Security.InsertOperatorLog", new IDAL.DataParameter[]{new IDAL.DataParameter("@LoginUser",App_Code.LoginUserInfo.UserName),new IDAL.DataParameter("@LoginTime",DateTime.Now), new IDAL.DataParameter("@LoginModule","登录系统"),new IDAL.DataParameter("@ExecuteOperator","用户登录")}); #endregion TimeSpan stLogin = new TimeSpan(0, 0, System.Web.HttpContext.Current.Session.Timeout, 0, 0); HttpContext.Current.Cache.Insert(key, Page.Request.UserHostAddress, null, DateTime.MaxValue, stLogin, System.Web.Caching.CacheItemPriority.NotRemovable, null); Response.Redirect("Default.aspx", false); } else { BLL.BLLBase bll = new BLL.BLLBase(); bll.ExecNonQuery("Security.InsertOperatorLog", new IDAL.DataParameter[]{new IDAL.DataParameter("@LoginUser",this.txtUserName.Text.Trim()),new IDAL.DataParameter("@LoginTime",DateTime.Now), new IDAL.DataParameter("@LoginModule","登录页面"),new IDAL.DataParameter("@ExecuteOperator","登录(用户密码有误)")}); ltlMessage.Text = "对不起,您输入的密码有误!"; } } else { ltlMessage.Text = "对不起,您输入的用户名不存在!"; } } catch (Exception exp) { System.Diagnostics.StackFrame frame = new System.Diagnostics.StackFrame(0); Session["ModuleName"] = this.Page.Title; Session["FunctionName"] = frame.GetMethod().Name; Session["ExceptionalType"] = exp.GetType().FullName; Session["ExceptionalDescription"] = exp.Message; Response.Redirect("Common/MistakesPage.aspx", false); } } else { ltlMessage.Text = "请输入用户名!"; } }