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
}
