private void OnTaskArrivalStation_OutClick(object sender, EventArgs e) { try { string Task_Id = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle)[_BLL.KeyFieldName].ToString(); string Task_Type = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle)[tb_WMS_Task.Task_TaskType].ToString(); string Task_Status = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle)[tb_WMS_Task.Task_TaskStatus].ToString(); if (Task_Type == "201") { if (Task_Status == "220") { string execSql = string.Format("exec Tmp_ArrivalStation_Out '{0}'", Task_Id); DataTable dt = new bllWMS_Task().ExecuteSQL(execSql); DoSearchSummary(); } else { Msg.Warning("任务堆垛机没有完成,禁止操作!!!"); } } else { Msg.Warning("不是出库任务,你不能进行该操作!!!"); } } catch (Exception ex) { Msg.ShowException(ex); } }
private void OnTaskAllInNewClick(object sender, EventArgs e) { try { string execSql = "exec Tmp_CreateAllInTask"; DataTable dt = new bllWMS_Task().ExecuteSQL(execSql); DoSearchSummary(); } catch (Exception ex) { Msg.ShowException(ex); } }
private void OnCreateOutClick(object sender, EventArgs e) { try { string PalletId = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle)[tb_WMS_Stock.Stock_PalletId].ToString(); string Stock_Type = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle)[tb_WMS_StockDtl.StockDtl_Type].ToString(); if (Stock_Type == "3") { string execSql = string.Format("exec Tmp_CreateAllOutTask '{0}'", PalletId); DataTable dt = new bllWMS_Task().ExecuteSQL(execSql); } else { Msg.Warning("库存状态不是正式库存,你不能进行任务创建操作!!!"); } } catch (Exception ex) { Msg.ShowException(ex); } }
private void OnTaskFinishTaskClick(object sender, EventArgs e) { try { string Task_Id = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle)[_BLL.KeyFieldName].ToString(); string Task_Type = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle)[tb_WMS_Task.Task_TaskType].ToString(); string Task_Status = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle)[tb_WMS_Task.Task_TaskStatus].ToString(); if (Task_Type == "101") { if (Task_Status == "390") { string execSql = string.Format("exec Tmp_TaskFinish '{0}','{1}'", Task_Id, Task_Type); DataTable dt = new bllWMS_Task().ExecuteSQL(execSql); DoSearchSummary(); } else { Msg.Warning("堆垛机没有完成该任务,禁止操作!!!"); } } else if (Task_Type == "201") { if (Task_Status == "290") { string execSql = string.Format("exec Tmp_TaskFinish '{0}','{1}'", Task_Id, Task_Type); DataTable dt = new bllWMS_Task().ExecuteSQL(execSql); DoSearchSummary(); } else { Msg.Warning("堆垛机没有完成该任务,禁止操作!!!"); } } } catch (Exception ex) { Msg.ShowException(ex); } }
private void OnTaskAssignClick2(object sender, EventArgs e) { try { string Task_Id = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle)[_BLL.KeyFieldName].ToString(); string Task_Type = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle)[tb_WMS_Task.Task_TaskType].ToString(); string Task_Status = _SummaryView.GetDataRow(_SummaryView.FocusedRowHandle)[tb_WMS_Task.Task_TaskStatus].ToString(); if (Task_Status == "100") { string execSql = string.Format("exec Tmp_TaskAssign '{0}','{1}'", Task_Id, Task_Type); DataTable dt = new bllWMS_Task().ExecuteSQL(execSql); DoSearchSummary(); } else { Msg.Warning("任务不是开始状态,你不能进行下发操作!!!"); } } catch (Exception ex) { Msg.ShowException(ex); } }
/// <summary> /// 初始化窗体/// /// </summary> protected override void InitializeForm() { // //_BLL = new bllWMS_Bill();// 业务逻辑层实例 _BLL = new bllWMS_Task(); _SummaryView = new DevGridView(gvSummary); _ActiveEditor = textTaskId; _DetailGroupControl = panelControl1; base.InitializeForm(); //这行代码放到初始化变量后最好 frmGridCustomize.RegisterGrid(gvSummary); frmGridCustomize.AddMenuItem(gvSummary, "入库任务新建", null, OnTaskAllInNewClick, true); frmGridCustomize.AddMenuItem(gvSummary, "任务下发", null, OnTaskAssignClick2, true); frmGridCustomize.AddMenuItem(gvSummary, "入库口入库", null, OnTaskArrivalPort_InClick, true); frmGridCustomize.AddMenuItem(gvSummary, "到达入库站台", null, OnTaskArrivalStation_InClick, true); frmGridCustomize.AddMenuItem(gvSummary, "堆垛机接收任务", null, OnTaskScReceiveClick, true); frmGridCustomize.AddMenuItem(gvSummary, "堆垛机完成任务", null, OnTaskScFinishClick, true); frmGridCustomize.AddMenuItem(gvSummary, "达到出库站台", null, OnTaskArrivalStation_OutClick, true); frmGridCustomize.AddMenuItem(gvSummary, "达到出库口", null, OnTaskArrivalPort_OutClick, true); frmGridCustomize.AddMenuItem(gvSummary, "任务过账", null, OnTaskFinishTaskClick, true); #region //if (SystemAuthentication.ButtonAuthorized("MenuItemTaskAssign")) //{ // frmGridCustomize.AddMenuItem(gvSummary, "任务下发", null, OnTaskAssignClick, true); //} //if (SystemAuthentication.ButtonAuthorized("MenuItemTaskCancel")) //{ // frmGridCustomize.AddMenuItem(gvSummary, "任务取消", null, OnTaskCancelClick, true); //} //if (SystemAuthentication.ButtonAuthorized("MenuItemTaskManualAccount")) //{ // frmGridCustomize.AddMenuItem(gvSummary, "手动过账", null, OnTaskAccountByManualClick, true); //} //if (SystemAuthentication.ButtonAuthorized("MenuItemTaskStatusModify")) //{ // frmGridCustomize.AddMenuItem(gvSummary, "状态修改", null, OnTaskStatusModifyClick, true); //} //if (SystemAuthentication.ButtonAuthorized("MenuItemTaskStationModify")) //{ // frmGridCustomize.AddMenuItem(gvSummary, "站台修改", null, OnTaskStationModifyClick, true); //} //if (SystemAuthentication.ButtonAuthorized("MenuItemTaskPortModify")) //{ // frmGridCustomize.AddMenuItem(gvSummary, "出库口修改", null, OnTaskPortNumModifyClick, true); //} //if (SystemAuthentication.ButtonAuthorized("MenuItemTaskPriorityModify")) //{ // frmGridCustomize.AddMenuItem(gvSummary, "优先级修改", null, OnTaskPriorityModifyClick, true); //} #endregion DevStyle.SetGridControlLayout(gcSummary, false); //表格设置 DevStyle.SetGridControlLayout(gcDetail, true); //表格设置 DevStyle.SetSummaryGridViewLayout(gvSummary); DevStyle.SetDetailGridViewLayout(gvDetail); //主表 BindingSummaryNavigator(controlNavigatorSummary, gcSummary); //Summary导航条. BindingSummarySearchPanel(btnQuery, btnEmpty, gcFindGroup); gvSummary.DoubleClick += new EventHandler(OnSeeTask); //主表DoubleClict txt_DocDateFrom.DateTime = DateTime.Today.AddDays(-7); txt_DocDateTo.DateTime = DateTime.Today.AddDays(1); //查询条件 DataBinder.BindingLookupEditDataSource(lookUpEditDocType, DataDictCache.Cache.TaskType, tb_CommonDataDict.NativeName, tb_CommonDataDict.DataCode); DataBinder.BindingLookupEditDataSource(lookUpEditDocStatus, DataDictCache.Cache.TaskStatus, tb_CommonDataDict.NativeName, tb_CommonDataDict.DataCode); DataBinder.BindingLookupEditDataSource(repositoryItemLookUpEditDocType, DataDictCache.Cache.TaskType, tb_CommonDataDict.NativeName, tb_CommonDataDict.DataCode); DataBinder.BindingLookupEditDataSource(repositoryItemLookUpEditDocStatus, DataDictCache.Cache.TaskStatus, tb_CommonDataDict.NativeName, tb_CommonDataDict.DataCode); _BLL.GetBusinessByKey("-", true); //加载一个空的业务对象. DoSearchSummary(); ShowSummaryPage(true); //一切初始化完毕后显示SummaryPage }
/// <summary> /// 初始化窗体/// /// </summary> protected override void InitializeForm() { // //_BLL = new bllWMS_Bill();// 业务逻辑层实例 _BLL = new bllWMS_Task(); _SummaryView = new DevGridView(gvSummary); _ActiveEditor = txtTaskId; _DetailGroupControl = panelControl1; base.InitializeForm(); //这行代码放到初始化变量后最好 frmGridCustomize.RegisterGrid(gvSummary); if (SystemAuthentication.ButtonAuthorized("MenuItemTaskSee")) { frmGridCustomize.AddMenuItem(gvSummary, "任务查看", null, OnTaskSeeClick, true); } if (SystemAuthentication.ButtonAuthorized("MenuItemTaskAssign")) { frmGridCustomize.AddMenuItem(gvSummary, "任务下发", null, OnTaskAssignClick, true); } if (SystemAuthentication.ButtonAuthorized("MenuItemTaskCancel")) { frmGridCustomize.AddMenuItem(gvSummary, "任务取消", null, OnTaskCancelClick, true); } if (SystemAuthentication.ButtonAuthorized("MenuItemTaskManualAccount")) { frmGridCustomize.AddMenuItem(gvSummary, "手动过账", null, OnTaskAccountByManualClick, true); } if (SystemAuthentication.ButtonAuthorized("MenuItemTaskStatusModify")) { frmGridCustomize.AddMenuItem(gvSummary, "状态修改", null, OnTaskStatusModifyClick, true); } if (SystemAuthentication.ButtonAuthorized("MenuItemTaskStationModify")) { frmGridCustomize.AddMenuItem(gvSummary, "站台修改", null, OnTaskStationModifyClick, true); } if (SystemAuthentication.ButtonAuthorized("MenuItemTaskPortModify")) { frmGridCustomize.AddMenuItem(gvSummary, "出库口修改", null, OnTaskPortNumModifyClick, true); } if (SystemAuthentication.ButtonAuthorized("MenuItemTaskPriorityModify")) { frmGridCustomize.AddMenuItem(gvSummary, "优先级修改", null, OnTaskPriorityModifyClick, true); } DevStyle.SetGridControlLayout(gcSummary, false); //表格设置 DevStyle.SetGridControlLayout(gcDetail, true); //表格设置 DevStyle.SetSummaryGridViewLayout(gvSummary); DevStyle.SetDetailGridViewLayout(gvDetail); //主表 BindingSummaryNavigator(controlNavigatorSummary, gcSummary); //Summary导航条. BindingSummarySearchPanel(btnQuery, btnEmpty, gcFindGroup); // //从表 // gcDetail.EmbeddedNavigator.ButtonClick += new NavigatorButtonClickEventHandler(this.OnEmbeddedNavigatorButtonClick); //表格按钮事件 // gvDetail.CellValueChanged += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(OnCellValueChanged); //表格值改变 // gvSummary.DoubleClick += new EventHandler(OnGridViewDoubleClick); //主表DoubleClict txt_DocDateFrom.DateTime = DateTime.Today.AddDays(-7); txt_DocDateTo.DateTime = DateTime.Today.AddDays(1); //查询条件 DataBinder.BindingLookupEditDataSource(lookUpEditDocType, DataDictCache.Cache.TaskType, tb_CommonDataDict.NativeName, tb_CommonDataDict.DataCode); DataBinder.BindingLookupEditDataSource(lookUpEditDocStatus, DataDictCache.Cache.TaskStatus, tb_CommonDataDict.NativeName, tb_CommonDataDict.DataCode); DataBinder.BindingLookupEditDataSource(repositoryItemLookUpEditDocType, DataDictCache.Cache.TaskType, tb_CommonDataDict.NativeName, tb_CommonDataDict.DataCode); DataBinder.BindingLookupEditDataSource(repositoryItemLookUpEditDocStatus, DataDictCache.Cache.TaskStatus, tb_CommonDataDict.NativeName, tb_CommonDataDict.DataCode); // (colIsId.ColumnEdit as RepositoryItemButtonEdit).ButtonClick += new ButtonPressedEventHandler(OnStockCode_ButtonClick); // (colIsId.ColumnEdit as RepositoryItemButtonEdit).Validating += new CancelEventHandler(OnStockCode_Validating); //sqlConst=string.Format(" and Task_CreatorDate between '{0}' and '{1}'",txt_DocDateFrom.DateTime,txt_DocDateTo.DateTime); //((bllWMS_Task)_BLL).GetTask(sqlConst); _BLL.GetBusinessByKey("-", true); //加载一个空的业务对象. ShowSummaryPage(true); //一切初始化完毕后显示SummaryPage }