/// <summary>
/// 堆垛机指令结束
/// </summary>
/// <param name="Objid"></param>
/// <returns></returns>
public bool FinishWbsTaskCmd(string Objid)
{
try
{
if (string.IsNullOrEmpty(Objid) || Objid.Equals("0"))
{
return(false);
}
var errCode = 0;
var errDesc = string.Empty;
var service = ProcedureServiceFactory.CreateInstance <IProcWmsFinishCmdService>();
service.ExcuteProcedure(new ProcWmsFinishCmd()
{
IParamObjid = int.Parse(Objid), OErrCode = errCode, OErrDesc = errDesc
});
if (errCode == 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
log.Error(ex);
return(false);
}
}
/// <summary>
/// 获取所有的页面操作信息
/// </summary>
/// <returns></returns>
/// <remarks></remarks>
public DataSet GetAllPageMenuAction()
{
var service = ProcedureServiceFactory.CreateInstance <IProcPageMenuActionAllService>();
var param = new ProcPageMenuActionAll();
return(service.ExcuteProcedure(param).ProcedureDataSetResult);
}
/// <summary>
/// 获取库存信息统计
/// </summary>
/// <param name="Btime"></param>
/// <param name="Etime"></param>
/// <returns></returns>
public PageResult GetBinStoreBatchno(DateTime Btime, DateTime Etime, string batchNo)
{
var transaction = TransactionServiceFatory.CreateInstance <ITransactionService>();
try
{
var procService = ProcedureServiceFactory.CreateInstance <IProcGetBinstoreBatchnoService>();
transaction.BeginTransaction();
var para = new ProcGetBinstoreBatchno();
para.IBtime = Btime;
para.IEdate = Etime;
para.IBatchNo = batchNo;
procService.ExcuteProcedure(para);
transaction.CompleteTransaction();
var pageResult = new PageResult();
var stmtId = "GetZ30BinStoreBatchNo";
pageResult.StatementId = stmtId;
return(this.GetPageDataByReader(pageResult));
}
catch (Exception ex)
{
transaction.RollbackTransaction();
return(null);
}
}
/// <summary>
/// 任务请求
/// </summary>
public string RequestTaskCmd(string palletNo, string sLocNo)
{
var taskSeq = SequenceServiceFactory.CreateInstance <ISeqTproc0100TaskRequestService>();
var taskTable = TableViewServiceFactory.CreateInstance <ITproc0100TaskRequestService>();
var taskSever = ProcedureServiceFactory.CreateInstance <IProc0100TaskRequestService>();
var cmdSeq = SequenceServiceFactory.CreateInstance <ISeqTproc0200CmdRequestService>();
var cmdTable = TableViewServiceFactory.CreateInstance <ITproc0200CmdRequestService>();
var cmdSever = ProcedureServiceFactory.CreateInstance <IProc0200CmdRequestService>();
try
{
var taskId = taskSeq.NEXTVAL;
taskTable.Insert(new Tproc0100TaskRequest()
{
ObjId = taskId,
PalletNo = palletNo,
SlocNo = sLocNo,
OrderTypeNo = "100064"
});
var TaskResult = taskSever.ExcuteProcedure(new Proc0100TaskRequest()
{
IParamObjid = taskId, OTaskNo = 0, OErrCode = 0, OErrDesc = ""
});
var taskNo = TaskResult.OTaskNo;
var errCode = TaskResult.OErrCode;
var errDesc = TaskResult.OErrDesc;
if (errCode != 0 || taskNo == 0)
{
return(errDesc);
}
var cmdId = cmdSeq.NEXTVAL;
cmdTable.Insert(new Tproc0200CmdRequest()
{
ObjId = cmdId,
TaskNo = taskNo,
CurrLocNo = sLocNo
});
var CmdResult = cmdSever.ExcuteProcedure(new Proc0200CmdRequest()
{
IParamObjid = cmdId, OCmdObjid = 0, OErrCode = 0, OErrDesc = ""
});
var cmdObjid = CmdResult.OCmdObjid;
errCode = CmdResult.OErrCode;
errDesc = CmdResult.OErrDesc;
if (errCode != 0 || cmdObjid == 0)
{
return(errDesc);
}
return(string.Empty);
}
catch (Exception ex)
{
log.Error(ex);
throw ex;
}
}
public void DeleteBin(string binNo)
{
try
{
var service = ProcedureServiceFactory.CreateInstance <IProcWmsDeleteBinService>();
service.ExcuteProcedure(new ProcWmsDeleteBin()
{
IBinNo = binNo
});
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
}
public string UpdateSrmArea(string CrnNo, string MinCol, string MaxCol)
{
try
{
var service = ProcedureServiceFactory.CreateInstance <IProcWmsUpdateSrmAreaService>();
service.ExcuteProcedure(new ProcWmsUpdateSrmArea()
{
ICrnNo = CrnNo,
IMinCol = int.Parse(MinCol),
IMaxCol = int.Parse(MaxCol)
});
return(string.Empty);
}
catch (Exception ex)
{
log.Error(ex);
throw ex;
}
}
/// <summary>
/// 任务删除
/// </summary>
/// <param name="Objid"></param>
/// <returns></returns>
public bool DeleteWbsTask(string TaskNo)
{
try
{
if (string.IsNullOrEmpty(TaskNo))
{
return(false);
}
var service = ProcedureServiceFactory.CreateInstance <IProcWmsDeleteTaskService>();
service.ExcuteProcedure(new ProcWmsDeleteTask()
{
ITaskNo = int.Parse(TaskNo)
});
return(true);
}
catch (Exception ex)
{
log.Error(ex);
return(false);
}
}
/// <summary>
/// 堆垛机指令删除
/// </summary>
/// <param name="Objid"></param>
/// <returns></returns>
public bool DeleteWbsTaskCmd(string Objid)
{
try
{
if (string.IsNullOrEmpty(Objid) || Objid.Equals("0"))
{
return(false);
}
var service = ProcedureServiceFactory.CreateInstance <IProcWmsDeleteCmdService>();
service.ExcuteProcedure(new ProcWmsDeleteCmd()
{
IObjid = int.Parse(Objid)
});
return(true);
}
catch (Exception ex)
{
log.Error(ex);
return(false);
}
}
public string CancelSelectTask(WbsTask[] tasks, string FinishDesc, int TaskNo)
{
var transaction = TransactionServiceFatory.CreateInstance <ITransactionService>();
var procService = ProcedureServiceFactory.CreateInstance <IProcTaskFinishService>();
transaction.BeginTransaction();
try
{
procService.ExcuteProcedure(new ProcTaskFinish()
{
InTaskNo = TaskNo, InFinishDesc = FinishDesc
});
transaction.CompleteTransaction();
}
catch (Exception ex)
{
log.Error(ex);
transaction.RollbackTransaction();
throw ex;
}
return("");
}
/// <summary>
/// 任务请求
/// </summary>
/// <param name="palletNo1"></param>
/// <param name="palletNo2"></param>
/// <param name="sLocNo"></param>
/// <returns></returns>
public string RequestTaskCmd(string palletNo1, string palletNo2, string sLocNo)
{
var taskSeq = SequenceServiceFactory.CreateInstance <ISeqTproc0100TaskRequestService>();
var taskTable = TableViewServiceFactory.CreateInstance <ITproc0100TaskRequestService>();
var taskSever = ProcedureServiceFactory.CreateInstance <IProc0100TaskRequestService>();
var cmdSeq = SequenceServiceFactory.CreateInstance <ISeqTproc0200CmdRequestService>();
var cmdTable = TableViewServiceFactory.CreateInstance <ITproc0200CmdRequestService>();
var cmdSever = ProcedureServiceFactory.CreateInstance <IProc0200CmdRequestService>();
try
{
var taskId = taskSeq.NEXTVAL;
taskTable.Insert(new Tproc0100TaskRequest()
{
ObjId = taskId,
PalletNo1 = palletNo1,
PalletNo2 = palletNo2,
SlocNo = sLocNo,
OrderTypeNo = "100064"
});
taskSever.ExcuteProcedure(new Proc0100TaskRequest()
{
IParamObjid = taskId
});
var dtRequestTask = taskTable.GetEntityList(new Tproc0100TaskRequest()
{
ObjId = taskId
}).FirstOrDefault();
if (dtRequestTask.ErrCode != 0)
{
return(dtRequestTask.ErrDesc);
}
var cmdId = cmdSeq.NEXTVAL;
cmdTable.Insert(new Tproc0200CmdRequest()
{
ObjId = cmdId,
TaskNo = int.Parse(dtRequestTask.TaskNo.ToString().Trim()),
CurrLocNo = sLocNo
});
cmdSever.ExcuteProcedure(new Proc0200CmdRequest()
{
IParamObjid = cmdId
});
var dtRequestCmd = cmdTable.GetEntityList(new Tproc0200CmdRequest()
{
ObjId = cmdId
}).FirstOrDefault();
if (dtRequestCmd.ErrCode != 0)
{
return(dtRequestCmd.ErrDesc);
}
return(string.Empty);
}
catch (Exception ex)
{
log.Error(ex);
throw ex;
}
}
