示例#1
0
        public DTOResponse Save(PlanDetailRequest request)
        {
            DTOResponse dtoResponse = new DTOResponse();

            try
            {
                if (string.IsNullOrEmpty(request.PostData))
                {
                    throw new Exception("传入的参数为空!");
                }
                long count = 0;
                using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
                {
                    //获取对象值
                    request.Entity = HelperSerializer.GetObjectFromJsonString <PlanDetailEntity>(request.PostData);

                    if (request.ACTION == OPAction.CREATE)
                    {
                        ProductEntity productEntity = dbConn.Single <ProductEntity>(x => x.PRODUCTNO == request.Entity.PRODUCTNO);
                        if (productEntity == null)
                        {
                            throw new Exception("物料" + request.Entity.PRODUCTNO + "不存在!");
                        }

                        //获取计划序号
                        SysSequenceResult sequenceResult =
                            SysSequenceInstance.Instance().GetSysSequence("PLANID");

                        PlanDetailEntity entity = new PlanDetailEntity();
                        entity.PLANID     = long.Parse(sequenceResult.SEQVALUE);
                        entity.PLANNO     = sequenceResult.SEQVALUE + "#" + request.Entity.PLANNO;
                        entity.PLANTYPE   = request.Entity.PLANTYPE;
                        entity.LINENUM    = 1;
                        entity.LINESTATE  = 0;
                        entity.BPNO       = request.Entity.BPNO;
                        entity.BPNAME     = request.Entity.BPNAME;
                        entity.STATIONNO  = request.Entity.STATIONNO;
                        entity.MODIFYBY   = SysInfo.GetCurrentUserInfo();
                        entity.MODIFYDATE = Utils.GetTodayDateTimeNow();

                        /*entity.BOMID = "";
                         * entity.BOMNO = "";
                         * entity.BOMNAME = "";
                         * entity.BOMBATCHNO = "";*/
                        entity.PRODUCTID    = productEntity.ID;
                        entity.PRODUCTNO    = productEntity.PRODUCTNO;
                        entity.PRODUCTNAME  = productEntity.PRODUCTNAME;
                        entity.PRODUCTSPEC  = productEntity.PRODUCTSPEC;
                        entity.PRODUCTCLASS = productEntity.PRODUCTCLASS;
                        entity.PRODUCTTYPE  = productEntity.PRODUCTTYPE;
                        entity.BATCHNO      = request.Entity.BATCHNO;
                        entity.Q01          = request.Entity.Q01;
                        entity.Q02          = 0;
                        entity.Q03          = 0;
                        entity.Q04          = 0;
                        entity.Q05          = request.Entity.Q05;
                        entity.Q06          = request.Entity.Q06;
                        entity.MAINUNIT     = productEntity.MAINUNIT;
                        entity.BASICUNIT    = productEntity.MAINUNIT;
                        entity.REMARK1      = request.Entity.REMARK1;
                        entity.P01          = request.Entity.P01;
                        entity.P02          = request.Entity.P02;

                        /*entity.REMARK2 = "";
                         *
                         * entity.P03 = "";
                         * entity.P04 = "";
                         * entity.P05 = "";
                         * entity.P06 = "";
                         * entity.P07 = "";
                         * entity.P08 = "";
                         * entity.P09 = "";
                         * entity.P10 = "";
                         * entity.P11 = "";
                         * entity.P12 = "";
                         * entity.P13 = "";
                         * entity.P14 = "";
                         * entity.P15 = "";
                         * entity.P16 = "";
                         * entity.P17 = "";
                         * entity.P18 = "";
                         * entity.P19 = "";
                         * entity.P20 = "";*/

                        //插入记录
                        count = dbConn.Insert <PlanDetailEntity>(entity);
                    }
                    else if (request.ACTION == OPAction.UPDATE)
                    {
                        //更新记录
                        count = dbConn.SaveAll <PlanDetailEntity>(new List <PlanDetailEntity>()
                        {
                            request.Entity
                        });
                    }

                    dtoResponse.IsSuccess   = true;
                    dtoResponse.MessageText = "操作成功!" + count;
                    return(dtoResponse);
                }
            }
            catch (Exception ex)
            {
                dtoResponse.IsSuccess   = false;
                dtoResponse.MessageText = ex.Message;
                logger.Error((object)ex);
                return(dtoResponse);
            }
        }
示例#2
0
        protected DTOResponse CreateTaskByMen(
            MoveRequest request,
            IDbConnection dbCon,
            IDbTransaction dbTrans)
        {
            DTOResponse dtoResponse = new DTOResponse();

            try
            {
                if (string.IsNullOrEmpty(request.StationNo))
                {
                    throw new Exception("参数不正确!@StationNo");
                }
                if (string.IsNullOrEmpty(request.Destination))
                {
                    throw new Exception("参数不正确!@Destination");
                }

                LocStationInfoEntity locStation1 = dbCon.Single <LocStationInfoEntity>(x => x.CONTROLNO == request.StationNo);
                if (locStation1 == null)
                {
                    throw new Exception(string.Format("站台:{0}不存在!", request.StationNo));
                }

                LocStationInfoEntity locStation2 = dbCon.Single <LocStationInfoEntity>(x => x.CONTROLNO == request.Destination);
                if (locStation2 == null)
                {
                    throw new Exception(string.Format("站台:{0}不存在!", request.Destination));
                }

                if (string.IsNullOrEmpty(request.PalletNo))
                {
                    request.PalletNo = "0";
                }
                if (string.IsNullOrEmpty(request.PalletType))
                {
                    request.PalletType = "1";
                }
                if (request.Priority < 1)
                {
                    request.Priority = 1;
                }

                SysSequenceResult sysSequence = SysSequenceInstance.Instance().GetSysSequence("TASKID");
                TaskEntity        taskEntity  = new TaskEntity()
                {
                    TASKNO          = long.Parse(sysSequence.SEQVALUE).ToString(),
                    TASKDATE        = Utils.GetToday(),
                    TASKTCLASS      = "3",
                    TASKTYPE        = "0",
                    PRIORITY        = request.Priority,
                    TASKGROUPNO     = "",
                    PRETASKNO       = "",
                    STRATEGYID01    = "",
                    STRATEGYNAME01  = "",
                    SOURCEAREA      = locStation1.GROUPNO,
                    SOURCE01        = locStation1.STATIONNO,
                    SOURCE02        = locStation1.CONTROLNO,
                    STRATEGYID02    = "",
                    STRATEGYNAME02  = "",
                    DESTINATIONAREA = locStation2.GROUPNO,
                    DESTINATION01   = locStation2.STATIONNO,
                    DESTINATION02   = locStation2.CONTROLNO,
                    TASKORDERDATA   = "",
                    CREATEDATE      = Utils.GetTodayNow(),
                    CREATEBY        = SysInfo.CurrentUserName,
                    STARTDATE       = "",
                    ENDDATE         = "",
                    CANCELDATE      = "",
                    CANCELREASON    = "",
                    TASKSTATE       = "0",
                    BILLID          = "0",
                    BILLID_LINENUM  = 0,
                    PALLETNO        = request.PalletNo,
                    PALLETTYPE      = request.PalletType
                };
                taskEntity.TASKDESC = string.Format("人工任务:从{0}到{1}", taskEntity.SOURCE02, taskEntity.DESTINATION02);
                long num = dbCon.Insert <TaskEntity>(taskEntity, false);

                dtoResponse.MessageText = "任务号:" + taskEntity.TASKNO + "容器编号:" + request.PalletNo + "从" + locStation1.CONTROLNO + "到" + locStation2.CONTROLNO;
                dtoResponse.IsSuccess   = num == 1 ? true : false;
                LogService.logger.Info((object)dtoResponse.ToString());
                return(dtoResponse);
            }
            catch (Exception ex)
            {
                dtoResponse.IsSuccess   = false;
                dtoResponse.MessageText = ex.Message;
                LogService.logger.Error((object)ex);
                return(dtoResponse);
            }
        }
示例#3
0
        public DTOResponse TaskOprationByMen(TaskRequest request)
        {
            DTOResponse dtoResponse = new DTOResponse();

            try
            {
                if (request.TASKOPACTION == "Cancel")
                {
                    using (IDbConnection dbConnection = HelperConnection.GetConnectionFactory().OpenDbConnection())
                    {
                        using (IDbTransaction dbTrans = dbConnection.OpenTransaction())
                        {
                            TaskEntity taskEntity = OrmLiteReadExpressionsApi.Single <TaskEntity>(dbConnection, (Expression <Func <TaskEntity, bool> >)(x => x.TASKNO == request.TASKNO));
                            if (taskEntity == null)
                            {
                                throw new Exception("未查询到任务:" + request.TASKNO);
                            }
                            //dtoResponse = BPCommon.TaskCancel(dbConnection, dbTrans, taskEntity);
                            //if (!dtoResponse.IsSuccess)
                            //{
                            //    dtoResponse.MessageText = "取消任务操作1失败:" + dtoResponse.MessageText;
                            //    dbTrans.Rollback();
                            //    return dtoResponse;
                            //}
                            //int jobType = 2;
                            //dtoResponse = BPCommon.OrderTask(dbConnection, dbTrans, taskEntity, jobType);
                            //if (dtoResponse.IsSuccess)
                            //{
                            //    dtoResponse.MessageText = "取消任务操作2成功!" + dtoResponse.MessageText;
                            //    dbTrans.Commit();
                            //    return dtoResponse;
                            //}
                            dtoResponse.MessageText = "取消任务操作2失败:" + dtoResponse.MessageText;
                            dbTrans.Rollback();
                            return(dtoResponse);
                        }
                    }
                }

                if (request.TASKOPACTION == "OrderDCS")
                {
                    using (IDbConnection dbConnection = HelperConnection.GetConnectionFactory().OpenDbConnection())
                    {
                        using (IDbTransaction dbTrans = dbConnection.OpenTransaction())
                        {
                            TaskEntity taskEntity = OrmLiteReadExpressionsApi.Single <TaskEntity>(dbConnection, (Expression <Func <TaskEntity, bool> >)(x => x.TASKNO == request.TASKNO));
                            if (taskEntity == null)
                            {
                                throw new Exception("未查询到任务:" + request.TASKNO);
                            }

                            SysSequenceResult sequenceResult = SysSequenceInstance.Instance().GetSysSequence("TASKID");
                            taskEntity.TASKNO = int.Parse(sequenceResult.SEQVALUE).ToString();

                            SqlExpression <TaskEntity> sqlExpression = dbConnection.From <TaskEntity>();
                            sqlExpression.Where(x => x.ID == taskEntity.ID);
                            sqlExpression.UpdateFields.Add("TASKNO");
                            int count = dbConnection.UpdateOnly <TaskEntity>(taskEntity, sqlExpression);

                            int jobType = BPCommonBase.ConvertJobtype(taskEntity.TASKTCLASS);

                            dtoResponse = BPCommonBase.OrderTask(dbConnection, dbTrans, taskEntity, jobType);
                            if (dtoResponse.IsSuccess)
                            {
                                dtoResponse.MessageText = "重新下达任务操作成功!" + dtoResponse.MessageText;
                                dbTrans.Commit();
                                return(dtoResponse);
                            }
                            else
                            {
                                dtoResponse.MessageText = "重新下达任务操作失败:" + dtoResponse.MessageText;
                                dbTrans.Rollback();
                                return(dtoResponse);
                            }
                        }
                    }
                }

                if (request.TASKOPACTION == "Over")
                {
                    List <INF_JOBFEEDBACKEntity> jobfeedbackEntityList = new List <INF_JOBFEEDBACKEntity>();

                    INF_JOBFEEDBACKEntity jobfeedbackEntity1 = new INF_JOBFEEDBACKEntity();
                    jobfeedbackEntity1.ID             = Utils.GetDateTimeGuid();
                    jobfeedbackEntity1.JOBID          = request.TASKNO;
                    jobfeedbackEntity1.WAREHOUSEID    = "none";
                    jobfeedbackEntity1.FEEDBACKSTATUS = "1";
                    jobfeedbackEntity1.ERRORCODE      = "0";
                    jobfeedbackEntity1.ENTERDATE      = Utils.GetTodayNow();
                    jobfeedbackEntity1.CREATEDATE     = Utils.GetTodayNow();
                    jobfeedbackEntity1.RESPONDCOUNT   = 0;
                    jobfeedbackEntity1.STATUS         = 0;
                    jobfeedbackEntity1.FULLCOUNT      = 0;
                    jobfeedbackEntity1.ROWVERSION     = 0;
                    jobfeedbackEntityList.Add(jobfeedbackEntity1);

                    INF_JOBFEEDBACKEntity jobfeedbackEntity2 = new INF_JOBFEEDBACKEntity();
                    jobfeedbackEntity2.ID             = Utils.GetDateTimeGuid();
                    jobfeedbackEntity2.JOBID          = request.TASKNO;
                    jobfeedbackEntity2.WAREHOUSEID    = "none";
                    jobfeedbackEntity2.FEEDBACKSTATUS = "99";
                    jobfeedbackEntity2.ERRORCODE      = "0";
                    jobfeedbackEntity2.ENTERDATE      = Utils.GetTodayNow();
                    jobfeedbackEntity2.CREATEDATE     = Utils.GetTodayNow();
                    jobfeedbackEntity2.RESPONDCOUNT   = 0;
                    jobfeedbackEntity2.STATUS         = 0;
                    jobfeedbackEntity2.FULLCOUNT      = 0;
                    jobfeedbackEntity2.ROWVERSION     = 0;
                    jobfeedbackEntityList.Add(jobfeedbackEntity2);

                    long num1 = 0;
                    using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
                    {
                        foreach (INF_JOBFEEDBACKEntity jobfeedbackEntity in jobfeedbackEntityList)
                        {
                            long num2 = dbConn.Insert <INF_JOBFEEDBACKEntity>(jobfeedbackEntity, false);
                            num1 += num2;
                        }
                    }
                    dtoResponse.IsSuccess   = num1 > 1L;
                    dtoResponse.MessageText = "任务操作成功";
                    return(dtoResponse);
                }
                else
                {
                    List <INF_JOBFEEDBACKEntity> jobfeedbackEntityList = new List <INF_JOBFEEDBACKEntity>();

                    jobfeedbackEntityList.Add(new INF_JOBFEEDBACKEntity()
                    {
                        ID             = Utils.GetDateTimeGuid(),
                        JOBID          = request.TASKNO,
                        WAREHOUSEID    = "none",
                        FEEDBACKSTATUS = request.TASKOPACTION,
                        ERRORCODE      = "0",
                        ENTERDATE      = Utils.GetTodayNow(),
                        CREATEDATE     = Utils.GetTodayNow(),
                        RESPONDCOUNT   = 0,
                        STATUS         = 0,
                        FULLCOUNT      = 0,
                        ROWVERSION     = 0
                    });

                    long num1 = 0;
                    using (IDbConnection dbConn = HelperConnection.GetConnectionFactory().OpenDbConnection())
                    {
                        foreach (INF_JOBFEEDBACKEntity jobfeedbackEntity in jobfeedbackEntityList)
                        {
                            long num2 = dbConn.Insert <INF_JOBFEEDBACKEntity>(jobfeedbackEntity, false);
                            num1 += num2;
                        }
                    }
                    dtoResponse.IsSuccess   = num1 > 1L;
                    dtoResponse.MessageText = "任务操作成功";
                    return(dtoResponse);
                }
            }
            catch (Exception ex)
            {
                dtoResponse.IsSuccess   = false;
                dtoResponse.MessageText = ex.Message;
                TaskService.logger.Error((object)ex);
            }
            return(dtoResponse);
        }