コード例 #1
0
        private void HandleExit(string pPlanCode)
        {
            if (string.IsNullOrWhiteSpace(pPlanCode))
            {
                return;
            }
            string order_code = PlanFactory.GetOrderCodeByPlan(pPlanCode);
            List <PlanProcessEntity> ent_process = PlanProcessFactory.GetByOrderCode(order_code);
            var s = from a in ent_process where a.ORDER_CODE == orderCode && a.WORKUNIT_CODE == WorkunitCode orderby a.PROCESS_CODE select a.PROCESS_CODE;

            if (s.Count() == 0)
            {
                return;
            }
            string process_code = s.First();

            if (process_code != "0010")
            {
                return;
            }

            List <ProductCompleteEntity> lst = ProductCompleteFactory.GetByPlanStation(planCode, StationCode);
            var s1 = from a in lst where a.COMPLETE_FLAG == "0" select a;

            if (s1.Count() == 0)
            {
                return;
            }
            //如果有complete_time=null记录,则此站点未完成操作

            var s2           = from a in lst where a.COMPLETE_FLAG != "0" select a.BATCH_QTY;
            int complete_qty = s2.Sum();

            PlanEntity ent = PlanFactory.GetByKey(planCode);

            ent.ONLINE_QTY = complete_qty;
            DB.GetInstance().Update(ent);

            DB.GetInstance().Delete(s1.First() as ProductCompleteEntity);
        }
コード例 #2
0
ファイル: PlanProcessDal.cs プロジェクト: radtek/DCEC
        public List <PlanProcessEntity> GetByPlan(string PlanCode)
        {
            string order_code = PlanFactory.GetOrderCodeByPlan(PlanCode);

            return(db.Fetch <PlanProcessEntity>("WHERE ORDER_CODE=@0 order by process_code", order_code));
        }