コード例 #1
0
ファイル: BaseAcquireActivity.cs プロジェクト: wra222/testgit
 /// <summary>
 /// 
 /// </summary>
 /// <param name="type"></param>
 /// <param name="noName"></param>
 /// <param name="maxNo"></param>
 /// <param name="customer"></param>
 /// <returns></returns>
 protected NumControl GetANumControl(string type, string noName, string maxNo, string customer)
 {
     NumControl nc = new NumControl(0, type, noName, maxNo, customer);
     return nc;
 }
コード例 #2
0
ファイル: GenerateBoxID.cs プロジェクト: wra222/testgit
        private string getBoxId(string boxReg)
        {
            string boxID = "";
            //New Format of Box Id
            //RRRR-SSSSS 
            //Remark:
            //RRRR – @boxReg
            //- – 固定字符’-‘
            //SSSSS – 流水号,31进制,基字符'0123456789BCDFGHJKLMNPQRSTVWXYZ';起始值为R0000;最大值为VZZZZ

            string maxnum = "";
            string prestr = "";

            boxID = boxReg + "-";
            prestr = boxID;
            // 自己管理事务开始
            try
            {
                SqlTransactionManager.Begin();
               // IUnitOfWork uof = new UnitOfWork();//使用自己的UnitOfWork

                //ITC-1414-0065
                //从NumControl中获取流水号
                //GetMaxNumber
                INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                bool addflag = false;

                maxnum = numControl.GetMaxNumber("BOXID", prestr + "{0}");
                if (string.IsNullOrEmpty(maxnum))
                {
                    maxnum = "R0000";
                    addflag = true;
                }
                else
                {
                    MathSequenceWithCarryNumberRule marc = new MathSequenceWithCarryNumberRule(5, "0123456789BCDFGHJKLMNPQRSTVWXYZ");

                    //maxnum="CNU248000Y";                   
                    string numstr = maxnum.Substring(maxnum.Length - 5);
                    if (numstr.ToUpper() == "VZZZZ")
                    {
                        FisException fe = new FisException("CHK867", new string[] { });   //流水号已满!
                        throw fe;
                    }
                    numstr = marc.IncreaseToNumber(numstr, 1);
                    maxnum = numstr;

                }

                boxID = boxID + maxnum.ToUpper();

                //setSPValue = boxID;

                NumControl item = new NumControl();
                item.NOType = "BOXID";
                item.Value = boxID;
                item.NOName = "";
                item.Customer = "HP";

                numControl.SaveMaxNumber(item, addflag, prestr + "{0}");

                //uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值

                SqlTransactionManager.Commit();//提交事物,释放行级更新锁
                return boxID;
            }
            catch (Exception e)
            {
                SqlTransactionManager.Rollback();
                throw e;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }
        }
コード例 #3
0
ファイル: AcquireIMEI.cs プロジェクト: wra222/testgit
        private string getIMEISeq(string model,string preFixCode,string custom)
        {
            string numType ="IMEI";
            try
            {
                SqlTransactionManager.Begin();
                lock (_syncRoot_GetSeq)
                {
                    INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                    MACRange currentRange = numCtrlRepository.GetMACRange(preFixCode, new string[] { "R", "A" });
                    if (currentRange == null)
                    {
                        throw new FisException("ICT014", new string[] {});
                    }
                    else
                    {
                        if (!validateIMEISettingRange(currentRange.BegNo, currentRange.EndNo))
                        {
                            throw new FisException("CHK1086", new string[] { currentRange.BegNo + "~" + currentRange.EndNo });
                        }
                        NumControl currentMaxNum = numCtrlRepository.GetMaxValue(numType, preFixCode);
                        if (currentMaxNum == null)
                        {
                            currentMaxNum = new NumControl();
                            currentMaxNum.NOName = preFixCode;
                            currentMaxNum.NOType = numType;
                            currentMaxNum.Value = currentRange.BegNo;
                            currentMaxNum.Customer = custom;

                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.InsertNumControlDefered(uof, currentMaxNum);
                            if (currentMaxNum.Value == currentRange.EndNo)
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                            }
                            else
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Active);
                            }
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return currentMaxNum.Value;

                        }
                        else
                        {
                            if (currentMaxNum.Value == currentRange.EndNo)
                            {
                                numCtrlRepository.SetMACRangeStatus(currentRange.ID, MACRange.MACRangeStatus.Closed);
                                currentRange = numCtrlRepository.GetMACRange(preFixCode, new string[] { "R" });
                                if (!validateIMEISettingRange(currentRange.BegNo, currentRange.EndNo))
                                {
                                    throw new FisException("CHK1086", new string[] { currentRange.BegNo + "~" + currentRange.EndNo });
                                }

                                if (currentMaxNum.Value == currentRange.BegNo || currentMaxNum.Value == currentRange.EndNo)
                                {
                                    throw new FisException("ICT018", new string[] { currentMaxNum.Value });
                                }
                            }

                            int curNextNum = int.Parse(currentMaxNum.Value)+1;
                            currentMaxNum.Value = curNextNum.ToString("D12");                          

                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.Update(currentMaxNum, uof);
                            if (currentMaxNum.Value == currentRange.EndNo)
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                            }
                            else
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Active);
                            }
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return currentMaxNum.Value;
                        }
                    }
                }
            }
            catch (Exception e)
            {
                SqlTransactionManager.Rollback();
                throw e;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }


        }
コード例 #4
0
ファイル: AcquireVendorCTList.cs プロジェクト: wra222/testgit
        private string GetVendorCT(string vendorCode, string vendor, string mfgCode, string weekCode)
        {
            try
            {
                SqlTransactionManager.Begin();
                lock (_syncRoot_GetSeq)
                {
                    INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                    NumControl currentMaxNum = new NumControl();
                    string preSeqStr = vendorCode + mfgCode + "__" + weekCode;
                    string likecont = preSeqStr + "{0}";
                    string type = "KP";
                    string vendorCT = "";

                    string maxNumber = numCtrlRepository.GetMaxNumber(type, likecont, this.Customer);
                    if (maxNumber != null && maxNumber != "")
                    {
                        currentMaxNum = numCtrlRepository.GetNumControlByNoTypeAndValue(type, maxNumber)[0];
                    }

                    if (maxNumber == null || maxNumber == "")
                    {
                        IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();

                        SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor(vendor);
                        if (first == null)
                        {
                            throw new FisException("ICT013", new string[] { });
                        }

                        vendorCT = vendorCode + mfgCode + first.code + weekCode + "000";
                        currentMaxNum.NOName = "";
                        currentMaxNum.NOType = type;
                        currentMaxNum.Value = vendorCT;
                        currentMaxNum.Customer = this.Customer;
                        numCtrlRepository.InsertNumControl(currentMaxNum);
                        SqlTransactionManager.Commit();
                        return vendorCT;
                    }
                    else if (maxNumber.Substring(9, 2) != weekCode)
                    {
                        IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
                        SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor(vendor);
                        if (first == null)
                        {
                            throw new FisException("ICT013", new string[] { });
                        }

                        vendorCT = vendorCode + mfgCode + first.code + weekCode + "000";
                        currentMaxNum.Value = vendorCT;
                        IUnitOfWork uof = new UnitOfWork();
                        numCtrlRepository.Update(currentMaxNum, uof);
                        uof.Commit();
                        SqlTransactionManager.Commit();
                        return vendorCT;
                    }
                    else
                    {
                        if (maxNumber.EndsWith("ZZZ"))
                        {
                            IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
                            IList<SupplierCodeInfo> codeList = currentProductRepository.GetSupplierCodeListByCode(maxNumber.Substring(7, 2));

                            SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor(vendor, codeList[0].idex);
                            if (first == null)
                            {
                                throw new FisException("IEC003", new string[] { });
                            }

                            vendorCT = vendorCode + mfgCode + first.code + weekCode + "000";
                            currentMaxNum.Value = vendorCT;
                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.Update(currentMaxNum, uof);
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return vendorCT;
                        }
                        else
                        {
                            ISequenceConverter seqCvt = new SequenceConverterNormal("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ", 3, "ZZZ", "000", '0');
                            string sequenceNumber = maxNumber.Substring(11, 3);
                            sequenceNumber = seqCvt.NumberRule.IncreaseToNumber(sequenceNumber, 1);

                            currentMaxNum.Value = maxNumber.Substring(0, 11) + sequenceNumber;
                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.Update(currentMaxNum, uof);
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return vendorCode + mfgCode + maxNumber.Substring(7, 2) + weekCode + sequenceNumber;
                        }
                    }
                }
            }
            catch (Exception e)
            {
                SqlTransactionManager.Rollback();
                throw e;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }
        }
コード例 #5
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override ActivityExecutionStatus DoExecute(ActivityExecutionContext executionContext)
        {
            MB currenMB = CurrentSession.GetValue(Session.SessionKeys.MB) as MB;
            IMBRepository itemRepository = RepositoryFactory.GetInstance().GetRepository<IMBRepository>();
            INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
            //Modify UC Update 	前提条件:Station=15 ITC-1414-0024
            if (this.Station != "15")
            {
                return base.DoExecute(executionContext);
            }
    
            //-------------------------------------------------------------
            //2.28.	MBCode:若第6码为’M’,则取MBSN前3码为MBCode,若第5码为’M’,则取前2码
            //CheckCode:若MBSN的第5码为’M’,则取MBSN的第6码,否则取第7码
            string strMBCode ="";
            string strCheckCode = "";
            if (currenMB.Sn.Substring(5,1)=="M")
            {
                strMBCode = currenMB.Sn.Substring(0, 3);
                strCheckCode = currenMB.Sn.Substring(6, 1);
            }
            else if (currenMB.Sn.Substring(4,1)=="M")
            {
                strMBCode = currenMB.Sn.Substring(0, 2);
                strCheckCode = currenMB.Sn.Substring(5, 1);
            }
            else
            {
                strCheckCode = currenMB.Sn.Substring(6, 1);
            }
            //-------------------------------------------------------------
            //2.29.	MBSN子板/RCTO的判定:CheckCode为数字,则为子板,为’R’,则为RCTO
            if (strCheckCode == "R")
            {
                //为’R’,则为RCTO
            }
            else if (Char.IsNumber(strCheckCode, 0) == true)
            {
                //CheckCode为数字,则为子板
            }

            //Session.AddValue("IsDocking", true);
            // Docking  @Type=’PC’
            var isDocking = false;
            try
            {
                isDocking = (bool)CurrentSession.GetValue("IsDocking");
            }
            catch (Exception ex)
            {
                var strerr = ex.Message;
                isDocking = false;
            }
            //-------------------------------------------------------------
            //Type:
            //1、	若@MBSN的CheckCode为‘R’,则@Type=’RCTO’
            //2、	若IsFru Checked,则@Type=’Fru’
            //3、	其他,@Type=’PC’
            string strType = "";
            if (isDocking == false)
            {
                if (strCheckCode == "R")
                {
                    strType = "RCTO";
                }
                else if ((bool)CurrentSession.GetValue("bFruChecked")==true)
                {
                    strType = "Fru";
                }
                else
                {
                    strType = "PC";
                }
            }
            else
            {
                strType = "PC";
            }
            //-------------------------------------------------------------
            //[LotList]中是否存在@MBCode和@Type记录 +和@Line)
            //UC UPDATE 2012/06/20 LotList]中不存在(@MBCode、@Type、和@Line 和 Lot.Status=0)记录
            IMES.DataModel.LotInfo Conlot = new IMES.DataModel.LotInfo();
            Conlot.mbcode = strMBCode;
            Conlot.type = strType;
            Conlot.line = this.Line;
            Conlot.status = "0";//Add by kaisheng 2012/06/20
            IList<LotInfo> retlot = itemRepository.GetlotInfoList(Conlot);
            
                        
            if ((retlot == null) || (retlot.Count == 0))
            {
                //不存在@MBCode和@Type记录, 则执行‘15.1 LotNo生成规则’,产生该MBCode和Type的LotNo,并Insert Lot/PCBLot
                //LotNo规则:YYYYMMDDXXXX,XXXX代表流水码,10进制,自增,幅度为1
                // --------------------------------------------------------
                //1. LotNo生成
                string sublotNo = "";
                //string Watercode = "";
                sublotNo = DateTime.Today.Year.ToString("0000") + DateTime.Today.Month.ToString("00") + DateTime.Today.Day.ToString("00");
                try
                {

                    SqlTransactionManager.Begin();
                    lock (_syncRoot_GetSeq)
                    {
                        NumControl currentMaxNum = numCtrlRepository.GetMaxValue("LotNo", "LotNo");
                        if (currentMaxNum == null)
                        {
                            currentMaxNum = new NumControl();
                            currentMaxNum.NOType = "LotNo";
                            currentMaxNum.NOName = "LotNo";
                            currentMaxNum.Value = sublotNo + beginNO;
                            currentMaxNum.Customer = "";
                            numCtrlRepository.InsertNumControl(currentMaxNum);
                            SqlTransactionManager.Commit();
                            CurrentSession.AddValue(Session.SessionKeys.LotNo, sublotNo + beginNO);
                        }
                        else if (currentMaxNum.Value.Substring(0, 8) != sublotNo)
                        {
                            currentMaxNum.Value = sublotNo + beginNO;
                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.Update(currentMaxNum, uof);
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            CurrentSession.AddValue(Session.SessionKeys.LotNo, sublotNo + beginNO);
                        }
                        else
                        {
                            if (currentMaxNum.Value.EndsWith("9999"))
                            {
                                //SqlTransactionManager.Commit();
                                throw new FisException("CHK867", new string[] { }); //CHK, The Quantity of LotNo is full today, please contact IE!
                            }
                            else
                            {
                                ISequenceConverter seqCvt = new SequenceConverterNormal("0123456789", 4, "9999", beginNO, '0');
                                string sequenceNumber = currentMaxNum.Value.Substring(8, 4);
                                sequenceNumber = seqCvt.NumberRule.IncreaseToNumber(sequenceNumber, 1);
                                currentMaxNum.Value = sublotNo + sequenceNumber;//currentMaxNum.Value.Substring(0, 8) + sequenceNumber;
                                IUnitOfWork uof = new UnitOfWork();
                                numCtrlRepository.Update(currentMaxNum, uof);
                                uof.Commit();
                                SqlTransactionManager.Commit();
                                CurrentSession.AddValue(Session.SessionKeys.LotNo, sublotNo + sequenceNumber);
                            }
                        }
                    }
                }
                catch (Exception e)
                {
                    SqlTransactionManager.Rollback();
                    throw e;
                }
                finally
                {
                    SqlTransactionManager.Dispose();
                    SqlTransactionManager.End();
                }
                
                //Insert Lot/PCBLot 
                //Insert Lot:LotNo=新产生No, Line=当前Line,Type=@Type, Qty=1, Status=0
                //Insert PCBLot:LotNo=@LotNo, PCBNo=@MBSN, Status=1
                LotInfo conLotInfo = new LotInfo();
                conLotInfo.lotNo = (string)CurrentSession.GetValue(Session.SessionKeys.LotNo);
                conLotInfo.line = this.Line;
                conLotInfo.mbcode = strMBCode;
                conLotInfo.type = strType;
                conLotInfo.qty = 1;
                conLotInfo.status = "0";
                conLotInfo.editor = this.Editor;
                itemRepository.InsertLotInfoDefered(CurrentSession.UnitOfWork, conLotInfo);
                PcblotInfo conPcblotInfo = new PcblotInfo();
                conPcblotInfo.lotNo = (string)CurrentSession.GetValue(Session.SessionKeys.LotNo);
                conPcblotInfo.pcbno = currenMB.Sn;
                conPcblotInfo.status = "1";
                conPcblotInfo.editor = this.Editor;
                itemRepository.InsertPCBLotInfoDefered(CurrentSession.UnitOfWork, conPcblotInfo);
                CurrentSession.AddValue("LotNoQty", 1);

            }
            else
            {
                LotInfo conLotInfo = new LotInfo();
                //Get Qty

                //conLotInfo.lotNo = retlot[0].lotNo;
                ////conLotInfo.type = strType;
                //IList<LotInfo> getLotInfo = itemRepository.GetlotInfoList(conLotInfo);
                //CurrentSession.AddValue("LotNoQty", getLotInfo[0].qty + 1);
                
                CurrentSession.AddValue("LotNoQty",retlot[0].qty + 1);
                
                    //存在@MBCode和@Type记录,则Update Lot,Insert PCBLot
                //Update Lot:Qty=Qty+1, Editor, Udt where LotNo=@LotNo
                //Insert PCBLot:LotNo=@LotNo, PCBNo=@MBSN, Status=1
                LotInfo setLotInfo = new LotInfo();
                conLotInfo = new LotInfo();
                conLotInfo.lotNo = retlot[0].lotNo;
                //conLotInfo.type = strType;
                //setLotInfo.qty = retlot[0].qty + 1;//1;//setValue.Qty赋1,其他按需要赋值即可
                setLotInfo.qty = 1;
                setLotInfo.editor = this.Editor;
                setLotInfo.udt = DateTime.Now;
                //itemRepository.UpdateLotInfoDefered(CurrentSession.UnitOfWork, setLotInfo, conLotInfo);
                itemRepository.UpdateLotInfoForIncQtyDefered(CurrentSession.UnitOfWork, setLotInfo, conLotInfo);
                PcblotInfo conPcblotInfo = new PcblotInfo();
                conPcblotInfo.lotNo = retlot[0].lotNo;
                conPcblotInfo.pcbno = currenMB.Sn;
                conPcblotInfo.status = "1";
                conPcblotInfo.editor = this.Editor;
                itemRepository.InsertPCBLotInfoDefered(CurrentSession.UnitOfWork, conPcblotInfo);

                
            }
            //GetPassQtyfromlotSetting -Activity
            // Defered方法, +1 可能没立即保存--如何确保Qty值 ?? --
            int passQtyforLine = (int)CurrentSession.GetValue("PassQtyinlotSetting");



            //2、	Check @MBCode和@Type对应的Qty,若Qty>=PassQty,则Update Lot
            //Update Lot:Status=1 where LotNo=@LotNo
            int currentQty = (int)CurrentSession.GetValue("LotNoQty");
            if (currentQty >= passQtyforLine)
            {

                LotInfo setLotInfo = new LotInfo();
                LotInfo conLotInfo = new LotInfo();
                //DEBUG Mantis 1005
                if ((retlot == null) || (retlot.Count == 0))
                    conLotInfo.lotNo = (string)CurrentSession.GetValue(Session.SessionKeys.LotNo);
                else
                    conLotInfo.lotNo = retlot[0].lotNo;
                setLotInfo.status = "1";
                setLotInfo.udt = DateTime.Now;
                itemRepository.UpdateLotInfoDefered(CurrentSession.UnitOfWork, setLotInfo, conLotInfo);
            }
            return base.DoExecute(executionContext);
        }
コード例 #6
0
ファイル: AcquireMBCTList.cs プロジェクト: wra222/testgit
        private string GetMBCT(string cfg, string thisYear, string weekCode,string mbcfg)
        {
            try
            {
                SqlTransactionManager.Begin();
                lock (_syncRoot_GetSeq)
                {

                    INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                    NumControl currentMaxNum = numCtrlRepository.GetMaxValue("MBCT", mbcfg);
                    if (currentMaxNum == null)
                    {
                        IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();

                        SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB");
                        if (first == null)
                        {
                            throw new FisException("ICT013", new string[] { });
                        }

                        currentMaxNum = new NumControl();
                        currentMaxNum.NOName = mbcfg;
                        currentMaxNum.NOType = "MBCT";
                        currentMaxNum.Value = thisYear + weekCode + first.code + beginNO;
                        currentMaxNum.Customer = "";
                        numCtrlRepository.InsertNumControl(currentMaxNum);
                        SqlTransactionManager.Commit();
                        return cfg + "00" + first.code + weekCode + beginNO;
                    }
                    else if (currentMaxNum.Value.Substring(0, 6) != (thisYear + weekCode))
                    {
                        IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
                        SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB");
                        if (first == null)
                        {
                            throw new FisException("ICT013", new string[] { });
                        }

                        currentMaxNum.Value = thisYear + weekCode + first.code + beginNO;
                        IUnitOfWork uof = new UnitOfWork();
                        numCtrlRepository.Update(currentMaxNum, uof);
                        uof.Commit();
                        SqlTransactionManager.Commit();
                        return cfg + "00" + first.code + weekCode + beginNO;
                    }
                    else
                    {
                        if (currentMaxNum.Value.EndsWith("ZZZ"))
                        {
                            IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
                            IList<SupplierCodeInfo> codeList = currentProductRepository.GetSupplierCodeListByCode(currentMaxNum.Value.Substring(6, 2));

                            SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB", codeList[0].idex);
                            if (first == null)
                            {
                                throw new FisException("ICT005", new string[] { });
                            }

                            currentMaxNum.Value = thisYear + weekCode + first.code + beginNO;
                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.Update(currentMaxNum, uof);
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return cfg + "00" + first.code + weekCode + beginNO;
                        }
                        else
                        {
                            ISequenceConverter seqCvt = new SequenceConverterNormal("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ", 3, "ZZZ", beginNO, '0');
                            string sequenceNumber = currentMaxNum.Value.Substring(8, 3);
                            sequenceNumber = seqCvt.NumberRule.IncreaseToNumber(sequenceNumber, 1);

                            currentMaxNum.Value = currentMaxNum.Value.Substring(0, 8) + sequenceNumber;
                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.Update(currentMaxNum, uof);
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return cfg + "00" + currentMaxNum.Value.Substring(6, 2) + weekCode + sequenceNumber;
                        }
                    }
                }
            }
            catch (Exception e)
            {
                SqlTransactionManager.Rollback();
                throw e;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }
        }
コード例 #7
0
ファイル: AcquireEEP.cs プロジェクト: wra222/testgit
        /// <summary>
        /// 
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override ActivityExecutionStatus DoExecute(ActivityExecutionContext executionContext)
        {
            MB currenMB = CurrentSession.GetValue(Session.SessionKeys.MB) as MB;

            IPartRepository CurrentPartRepository = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>();
            string cust = CurrentPartRepository.GetPartInfoValue(currenMB.PCBModelID, "Cust");
            string[] CustCondition = { "ZELDA", "HALFPIPE", "MOSELEY" };

            if (CustCondition.Contains(cust))
            {
                IMBRepository currentMBRepository = RepositoryFactory.GetInstance().GetRepository<IMBRepository, IMB>();
                string eepValue = currentMBRepository.GetPCBInfoValue(currenMB.Sn, "EEPROM");
                if (string.IsNullOrEmpty(eepValue))
                {
                    try
                    {
                        SqlTransactionManager.Begin();
                        lock (_syncRoot_GetSeq)
                        {
                            INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                            string mbFamily = CurrentSession.GetValue(Session.SessionKeys.FamilyName) as string;
                            MACRange currentRange = numCtrlRepository.GetMACRange(mbFamily, new string[] { "R", "A" });
                            if (currentRange == null)
                            {
                                throw new FisException("ICT015", new string[] { });
                            }
                            else
                            {

                                NumControl currentMaxNum = numCtrlRepository.GetMaxValue("EEPROM", mbFamily);
                                if (currentMaxNum == null)
                                {
                                    currentMaxNum = new NumControl();
                                    currentMaxNum.NOName = mbFamily;
                                    currentMaxNum.NOType = "EEPROM";
                                    currentMaxNum.Value = currentRange.BegNo.Substring(0, 11) + "1";
                                    currentMaxNum.Customer = "";

                                    IUnitOfWork uof = new UnitOfWork();
                                    numCtrlRepository.InsertNumControlDefered(uof, currentMaxNum);
                                    if (currentMaxNum.Value.Substring(0, 11) == currentRange.EndNo.Substring(0, 11))
                                    {
                                        numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                                    }
                                    else
                                    {
                                        numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Active);
                                    }
                                    uof.Commit();
                                    SqlTransactionManager.Commit();
                                    CurrentSession.AddValue(Session.SessionKeys.EEP, currentMaxNum.Value);
                                }
                                else
                                {
                                    if (currentMaxNum.Value.Substring(0, 11) == currentRange.EndNo.Substring(0, 11))
                                    {
                                        numCtrlRepository.SetMACRangeStatus(currentRange.ID, MACRange.MACRangeStatus.Closed);
                                        currentRange = numCtrlRepository.GetMACRange(mbFamily, new string[] { "R" });
                                        if (currentMaxNum.Value.Substring(0, 11) == currentRange.BegNo.Substring(0, 11) || currentMaxNum.Value.Substring(0, 11) == currentRange.EndNo.Substring(0, 11))
                                        {
                                            throw new FisException("ICT017", new string[] { currentMaxNum.Value.Substring(0, 11) });
                                        }
                                    }

                                    if (string.Compare(currentMaxNum.Value.Substring(0, 11), currentRange.BegNo.Substring(0, 11)) < 0 || string.Compare(currentMaxNum.Value.Substring(0, 11), currentRange.EndNo.Substring(0, 11)) > 0)
                                    {
                                        currentMaxNum.Value = currentRange.BegNo.Substring(0, 11) + "1";
                                    }
                                    else
                                    {
                                        ISequenceConverter seqCvt = new SequenceConverterNormal("0123456789", 7, "9999999", "0000000", '0');
                                        string sequenceNumber = currentMaxNum.Value.Substring(4, 7);
                                        sequenceNumber = seqCvt.NumberRule.IncreaseToNumber(sequenceNumber, 1);
                                        currentMaxNum.Value = currentMaxNum.Value.Substring(0, 4) + sequenceNumber + "1";
                                    }


                                    IUnitOfWork uof = new UnitOfWork();
                                    numCtrlRepository.Update(currentMaxNum, uof);
                                    if (currentMaxNum.Value.Substring(0, 11) == currentRange.EndNo.Substring(0, 11))
                                    {
                                        numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                                    }
                                    else
                                    {
                                        numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Active);
                                    }
                                    uof.Commit();
                                    SqlTransactionManager.Commit();
                                    CurrentSession.AddValue(Session.SessionKeys.EEP, currentMaxNum.Value);
                                }
                            }
                        }
                    }
                    catch (Exception e)
                    {
                        SqlTransactionManager.Rollback();
                        throw e;
                    }
                    finally
                    {
                        SqlTransactionManager.Dispose();
                        SqlTransactionManager.End();
                    }

                }
            }

            return base.DoExecute(executionContext);
        }
コード例 #8
0
ファイル: GenSkodaSN.cs プロジェクト: wra222/testgit
        /// <summary>
        /// 產生CustomerSN號相关逻辑
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override System.Workflow.ComponentModel.ActivityExecutionStatus DoExecute(System.Workflow.ComponentModel.ActivityExecutionContext executionContext)
        {
            Session session = CurrentSession;
            IProduct product = (IProduct)session.GetValue(Session.SessionKeys.Product);
            IMB mb = (IMB)session.GetValue(Session.SessionKeys.MB);
            IProductRepository productRep = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
            IMBRepository mbRep = RepositoryFactory.GetInstance().GetRepository<IMBRepository>();
            IPartRepository partRepository = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>();
            IModelRepository modelRepository = RepositoryFactory.GetInstance().GetRepository<IModelRepository, Model>();
            ActivityCommonImpl utl = ActivityCommonImpl.Instance;

            string customSN = null;
            string customer = null;
           string family =null;
           if (product==null)
           {
               if (mb == null)
               {
                   family = utl.IsNull<string>(session, Session.SessionKeys.FamilyName);
               }
               else
               {
                   family = mb.MBCode;
                   customer = mb.Customer;
               }
            }
            else
            {
                family =  product.Family;
                customer = product.Customer;
            }

           if (string.IsNullOrEmpty(customer))
           {
               customer = this.Customer;
           }

            ConstValueInfo info = new ConstValueInfo();
            info.type = "CustSNExceptRule";
            info.name = family;
            IList<ConstValueInfo> retList = partRepository.GetConstValueInfoList(info);
            if (retList == null || retList.Count == 0)
            {
                // 請维护 ConstValue的 CustSNExceptRule
                //throw new FisException("CHK1076", new string[] { "ConstValue", "CustSNExceptRule" });
                string seqFormat = null;
              
                IList<ConstValueInfo> valueList = utl.ConstValue("CustSNRule", family, out seqFormat);
                string nextNum = utl.GenSN.GetNextSequence(product, customer, "CUSTSN",
                                                                           seqFormat);
                customSN = nextNum;
                if (product!=null)
                {
                    productRep.ExistsCustomSnThrowErrorDefered(session.UnitOfWork, product.ProId, customSN);
                    product.CUSTSN = nextNum;
                    productRep.Update(product, session.UnitOfWork);
                }
                else if (mb != null)
                {
                    mbRep.ExistsCustomSnThrowErrorDefered(session.UnitOfWork,mb.Sn,customSN);
                    mb.CustSn = nextNum;
                    mbRep.Update(mb, session.UnitOfWork);
                }

            }
            else
            {
                #region for Skoda model
                if (product == null)
                {
                    throw new FisException("CHK975", new List<string> { Session.SessionKeys.Product });
                }

                string skodaFamily4 = retList[0].value;
                if (string.IsNullOrEmpty(skodaFamily4) || skodaFamily4.Length != 4)
                {
                    throw new FisException("CHK1076", new string[] { "ConstValue", "CustSNExceptRule" });
                }

                IList<IMES.FisObject.Common.Model.ModelInfo> infoModel = modelRepository.GetModelInfoByModelAndName(product.Model, "Country");
                if (infoModel == null || infoModel.Count == 0)
                {
                    throw new FisException("CHK1076", new string[] { "ModelInfo", "Country" });
                }

                info = new ConstValueInfo();
                info.type = "SKODAConutryCode";
                info.name = infoModel[0].Value;
                retList = partRepository.GetConstValueInfoList(info);
                if (retList == null || retList.Count == 0)
                {
                    // 請维护 ConstValue的 SKODAConutryCode
                    throw new FisException("CHK1076", new string[] { "ConstValue", "SKODAConutryCode" });
                }

                string skodaCountry = retList[0].value;
                if (string.IsNullOrEmpty(skodaCountry) || skodaCountry.Length != 5)
                {
                    throw new FisException("CHK1076", new string[] { "ConstValue", "SKODAConutryCode" });
                }

                DateTime curDate = DateTime.Now;
                string year = curDate.Year.ToString();

                string prestr = ""; ;
                // 1~4位:是Family4内容
                prestr = skodaFamily4;

                //  5~9位:根据国别判断,如果不足5位末尾补0
                prestr += skodaCountry;

                // 第10位:年份最后一码
                prestr += year.Substring(year.Length - 1, 1);

                // 第11位:1-9月是数字,10月为A,11月B,12月C
                if (curDate.Month <= 9)
                    prestr += curDate.Month.ToString();
                else if (curDate.Month == 10)
                    prestr += "0";
                else if (curDate.Month == 11)
                    prestr += "A";
                else if (curDate.Month == 12)
                    prestr += "B";

                bool addflag = false;
                string custSn = "";

                try
                {
                    SqlTransactionManager.Begin();
                    lock (_syncRoot_GetSeq)
                    {
                        //从NumControl中获取流水号
                        //GetMaxNumber
                        INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                        //maxnum = numControl.GetMaxNumber("CPQSNO", prestr + "{0}");
                        //var maxObj = numControl.GetMaxNumberObj("CPQSNO", prestr + "{0}");

                        string maxnum = "";
                        var maxObj = numControl.GetMaxValue("SkodaSN", prestr);
                        //檢查有沒有lock index, 沒有lock index, 改變查詢條件
                        if (maxObj == null)
                        {
                            //lock NoType='CPQSNO' and NoName='Lock'
                            var data = numControl.GetMaxValue("SkodaSN", "Lock");
                            maxObj = numControl.GetMaxValue("SkodaSN", prestr);
                        }
                        if (maxObj != null)
                            maxnum = maxObj.Value;



                        if (string.IsNullOrEmpty(maxnum))
                        {
                            maxnum = "000000";    //起始值:000000
                            addflag = true;
                        }
                        else
                        {
                            //maxnum="CNU248000Y";
                            string temstr = "000000"; //起始值:000000

                            string numstr = maxnum.Substring(maxnum.Length - 6);
                            temstr = numstr;

                            if (numstr.ToUpper() == "999999")
                            {
                                FisException fe = new FisException("CHK867", new string[] { });   //流水号已满!
                                throw fe;
                            }

                            maxnum = GetSN(temstr);
                        }

                        custSn = prestr + maxnum.ToUpper();


                        // 自己管理事务开始
                        IUnitOfWork uof = new UnitOfWork();//使用自己的UnitOfWork

                        NumControl item = null;// new NumControl();

                        if (addflag)
                        {
                            item = new NumControl();
                            item.NOType = "SkodaSN";
                            item.Value = custSn;
                            item.NOName = prestr;
                            item.Customer = this.Customer;
                        }
                        else
                        {
                            item = maxObj;
                            item.Value = custSn;
                        }

                        //numControl.SaveMaxNumber(item, addflag, prestr + "{0}");
                        numControl.SaveMaxNumber(item, addflag);
                        customSN = custSn;
                        if (product != null)
                        {
                            product.CUSTSN = custSn;
                            productRep.Update(product, uof);
                        }
                        else if (mb != null)
                        {
                            mb.CustSn = custSn;
                            mbRep.Update(mb, uof);
                        }
                        uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值

                        // [Customer SN Print]保存结果:增加更新[CustomerSN_Qty]. CustomerSN_Qty栏位
                        //UPDATE [HPIMES].[dbo].[MO]
                        //SET [CustomerSN_Qty] =[ CustomerSN_Qty]+1
                        //From Product a,MO b  WHERE a.MO=b.MO and a.ProductID=ProductID#
                        if (product != null)
                        {
                            IMORepository moRepository = RepositoryFactory.GetInstance().GetRepository<IMORepository, MO>();
                            moRepository.UpdateMoForIncreaseCustomerSnQty(product.ProId, 1);
                        }
                    }
                    SqlTransactionManager.Commit();//提交事物,释放行级更新锁

                }
                catch (Exception)
                {
                    SqlTransactionManager.Rollback();
                    throw;
                }
                finally
                {
                    SqlTransactionManager.Dispose();
                    SqlTransactionManager.End();
                }
                #endregion
            }

            session.AddValue(Session.SessionKeys.CustSN, customSN);
            if (product != null)
            {
                session.AddValue(Session.SessionKeys.PrintLogName, product.Customer + "SNO");
                session.AddValue(Session.SessionKeys.PrintLogBegNo, product.CUSTSN);
                session.AddValue(Session.SessionKeys.PrintLogEndNo, product.CUSTSN);
                session.AddValue(Session.SessionKeys.PrintLogDescr, product.ProId);
            }
            else
            {
                session.AddValue(Session.SessionKeys.PrintLogName, this.Customer + "SNO");
                session.AddValue(Session.SessionKeys.PrintLogBegNo, customSN);
                session.AddValue(Session.SessionKeys.PrintLogEndNo, customSN);
                session.AddValue(Session.SessionKeys.PrintLogDescr, family);
            }

            return base.DoExecute(executionContext);
        }
コード例 #9
0
ファイル: GenerateCustomerSn.cs プロジェクト: wra222/testgit
        /// <summary>
        /// 產生CustomerSN號相关逻辑
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override System.Workflow.ComponentModel.ActivityExecutionStatus DoExecute(System.Workflow.ComponentModel.ActivityExecutionContext executionContext)
        { 
            IProduct product = (IProduct)CurrentSession.GetValue(Session.SessionKeys.Product);
            IProductRepository productRep = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
            IPartRepository PartRepository = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>();
            //lock (_syncRoot_GetSeq)//用于防止同一段代码被同时执行,以前只有一个Service时有效,现在多个Service没有去掉,聊胜于无

            //var logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            //logger.InfoFormat("GenerateCustomerSnActivity: CurrentSession Hash: {0}; CurrentSession Key: {1}; CurrentSession Type: {2}", CurrentSession.GetHashCode().ToString(), CurrentSession.Key, CurrentSession.Type.ToString());
            //logger.InfoFormat("GenerateCustomerSnActivity: IProduct Hash: {0}; IProduct Key: {1}", product.GetHashCode().ToString(), product.Key);

            //need modify
            try
            {
                //CN(中try国代码)+U(Site Code)+年尾码+周别码+流水码
                string custSn = "";
                DateTime curDate = DateTime.Now;
               // string year = curDate.Year.ToString();
                string maxnum = "";
                string prestr = "";
                //求当前日期是一年的中第几周
                //int weeks = 0;
                DateTime dateTime = DateTime.Now;//new DateTime(2016,1,1);
                var ret = IMES.Infrastructure.Utility.Generates.WeekRuleEngine.Calculate("103", dateTime);
                string weekCode = ret.Week.ToString().PadLeft(2, '0');
                string year = ret.Year.ToString();//dateTime.Year.ToString();
                IList<string> valueList = PartRepository.GetValueFromSysSettingByName("Site");
                if (valueList.Count == 0)
                {
                    throw new Exception("Error:尚未設定Site...");
                }
                else
                {
                    if (valueList[0] == "ICC")//重慶
                    {
                        custSn = "5CG";// +custSn + year.Substring(year.Length - 1, 1) + weekCode;
                    }
                    else //IPC 上海
                    {
                        custSn = "CNU";// +custSn + year.Substring(year.Length - 1, 1) + weekCode;//weeks.ToString("d2");
                    }
                }
                //custSn = "CN" + "U" + custSn + year.Substring(year.Length - 1, 1) + weekCode;//weeks.ToString("d2");
                ActivityCommonImpl commonImpl = ActivityCommonImpl.Instance;
                custSn = commonImpl.GetCustSNPreFix3(custSn,product.Family) + year.Substring(year.Length - 1, 1) + weekCode;//weeks.ToString("d2");
                prestr = custSn;
                // 自己管理事务开始
                SqlTransactionManager.Begin();
               // IUnitOfWork uof = new UnitOfWork();//使用自己的UnitOfWork

                //从NumControl中获取流水号
                //GetMaxNumber
                INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                bool addflag = false;

                //maxnum = numControl.GetMaxNumber("CPQSNO", prestr + "{0}");

                var maxObj = numControl.GetMaxNumberObj("CPQSNO", prestr + "{0}");
                if (maxObj != null)
                    maxnum = maxObj.Value;
                //Vincent 2012-12-04 change min sequence number
                if (string.IsNullOrEmpty(maxnum))
                {
                    maxnum = "0000";
                    addflag = true;
                }
                else
                {
                    // mantis 1515
                    Regex regex = new Regex("[MW]{3}", RegexOptions.Compiled | RegexOptions.Singleline);
                    string tmpnum = GetSN(maxnum);
                    int cntGetSN = 0;
                    while (regex.Match(tmpnum.ToUpper().Substring(tmpnum.Length - 3)).Success)
                    {
                        cntGetSN++;
                        if (cntGetSN > 3)
                        {
                            throw new NullReferenceException("Error, GetSn with type 'WM*'");
                        }
                        tmpnum = GetSN(tmpnum);
                    }
                    maxnum = tmpnum;
                }
                custSn = custSn + maxnum.ToUpper();

                if (productRep.CheckExistCustomSn(custSn))
                {
                    List<string> errpara = new List<string>();
                    errpara.Add(custSn);
                    throw new FisException("CHK1021", errpara);
                }

                product.CUSTSN = custSn;
                //productRep.Update(product, uof);
                productRep.Update(product, CurrentSession.UnitOfWork);

                NumControl item = null;// new NumControl();

                if (addflag)
                {
                    item = new NumControl();
                    item.NOType = "CPQSNO";
                    item.Value = custSn;
                    item.NOName = "";
                    item.Customer = "HP";
                }
                else
                {
                    item = maxObj;
                    item.Value = custSn;
                }

                //numControl.SaveMaxNumber(item, addflag, prestr + "{0}");
                numControl.SaveMaxNumber(item, addflag);
                 
              // uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值

                SqlTransactionManager.Commit();//提交事物,释放行级更新锁
                
                // [Customer SN Print]保存结果:增加更新[CustomerSN_Qty]. CustomerSN_Qty栏位
                //UPDATE [HPIMES].[dbo].[MO]
                //SET [CustomerSN_Qty] =[ CustomerSN_Qty]+1
                //From Product a,MO b  WHERE a.MO=b.MO and a.ProductID=ProductID#

                IMORepository moRepository = RepositoryFactory.GetInstance().GetRepository<IMORepository, MO>();
                moRepository.UpdateMoForIncreaseCustomerSnQty(product.ProId, 1);

            }
            catch (Exception)
            {
                SqlTransactionManager.Rollback();
                throw;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }
            if (IsNeedPrintlogParam)
            {
                CurrentSession.AddValue(Session.SessionKeys.PrintLogName, product.Customer + "SNO");
                CurrentSession.AddValue(Session.SessionKeys.PrintLogBegNo, product.CUSTSN);
                CurrentSession.AddValue(Session.SessionKeys.PrintLogEndNo, product.CUSTSN);
                CurrentSession.AddValue(Session.SessionKeys.PrintLogDescr, product.ProId);
        
            }
         
      
            
            return base.DoExecute(executionContext);
        }
コード例 #10
0
        /// <summary>
        /// 產生CustomerSN號相关逻辑
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override System.Workflow.ComponentModel.ActivityExecutionStatus DoExecute(System.Workflow.ComponentModel.ActivityExecutionContext executionContext)
        {
            IProduct product = (IProduct)CurrentSession.GetValue(Session.SessionKeys.Product);
            IProductRepository productRep = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
            IPartRepository ipartRepository = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>();

            //need modify
            try
            {
                //CN(中try国代码)+U(Site Code)+年尾码+周别码+流水码
                string custSn = "";
                DateTime curDate = DateTime.Now;
                // string year = curDate.Year.ToString();
                string maxnum = "";
                string prestr = "";
                //求当前日期是一年的中第几周
                //int weeks = 0;
                DateTime dateTime = DateTime.Now;//new DateTime(2016,1,1);
                var ret = IMES.Infrastructure.Utility.Generates.WeekRuleEngine.Calculate("103", dateTime);
                string weekCode = ret.Week.ToString().PadLeft(2, '0');
                string year = ret.Year.ToString();//dateTime.Year.ToString();

                custSn = "CN" + "U" + custSn + year.Substring(year.Length - 1, 1) + weekCode;//weeks.ToString("d2");
                prestr = custSn;
                // 自己管理事务开始
                SqlTransactionManager.Begin();
                IUnitOfWork uof = new UnitOfWork();//使用自己的UnitOfWork


                //从NumControl中获取流水号
                //GetMaxNumber
                INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                bool addflag = false;
                maxnum = numControl.GetMaxNumber("CPQSNO", prestr + "{0}");
                if (string.IsNullOrEmpty(maxnum))
                {
                    /* 2012-6-27,为产线测试用,正式使用时要修改回来
                    maxnum = "Z000";    //起始值:Z000
                    */
                    maxnum = "Z000";    //非正式起始值:V000

                    addflag = true;
                }
                else
                {
                    //maxnum="CNU248000Y";
                    /* 2012-6-27,为产线测试用,正式使用时要修改回来
                    string temstr = "Z000"; //起始值:Z000
                    */
                    string temstr = "Z000";

                    string numstr = maxnum.Substring(maxnum.Length - 4);
                    temstr = numstr;

                    //2012-6-27,为产线测试用,正式使用时要删除
                 /*   if (numstr.ToUpper() == "VZZZ")
                    {
                        FisException fe = new FisException("CHK867", new string[] { });   //流水号已满!
                        throw fe;
                    }
                    */

                    if (numstr.ToUpper() == "YZZZ")
                    {
                        FisException fe = new FisException("CHK867", new string[] { });   //流水号已满!
                        throw fe;
                    }

                    string[] seqLst = new string[4];
                    seqLst[0] = temstr.Substring(0, 1);
                    seqLst[1] = temstr.Substring(1, 1);
                    seqLst[2] = temstr.Substring(2, 1);
                    seqLst[3] = temstr.Substring(3, 1);

                    int[] idexLst = getSeqNum(seqLst);

                    if (idexLst[3] == 30)
                    {
                        if (idexLst[2] == 30)
                        {
                            if (idexLst[1] == 30)
                            {
                                if (idexLst[0] == 29)
                                {
                                    List<string> errpara = new List<string>();
                                    throw new FisException("CHK867", errpara);  //流水号已满!
                                }
                                else
                                {
                                    if (idexLst[0] == 30)
                                    {
                                        idexLst[0] = 28;
                                    }
                                    else if (idexLst[0] == 28)
                                    {
                                        idexLst[0] = 27;
                                    }
                                    else if (idexLst[0] == 27)
                                    {
                                        idexLst[0] = 29;
                                    }
                                    else
                                    {
                                        List<string> errpara = new List<string>();
                                        throw new FisException("CHK867", errpara);  //非合法的Z、X、W、Y,视为满
                                    }

                                    idexLst[1] = 0;
                                    idexLst[2] = 0;
                                    idexLst[3] = 0;
                                }
                            }
                            else
                            {
                                idexLst[1] += 1;
                                idexLst[2] = 0;
                                idexLst[3] = 0;
                            }
                        }
                        else
                        {
                            idexLst[2] += 1;
                            idexLst[3] = 0;
                        }
                    }
                    else
                    {
                        idexLst[3] += 1;
                    }

                    temstr = numLst[idexLst[0]] + numLst[idexLst[1]] + numLst[idexLst[2]] + numLst[idexLst[3]];
                    maxnum = temstr;
                }

                custSn = custSn + maxnum.ToUpper();

                product.CUSTSN = custSn;
                productRep.Update(product, uof);

                NumControl item = new NumControl();
                item.NOType = "CPQSNO";
                item.Value = custSn;
                item.NOName = "";
                item.Customer = "HP";

                numControl.SaveMaxNumber(item, addflag, prestr + "{0}");

                uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值

                SqlTransactionManager.Commit();//提交事物,释放行级更新锁

                //IMORepository moRepository = RepositoryFactory.GetInstance().GetRepository<IMORepository, MO>();
               // moRepository.UpdateMoForIncreaseCustomerSnQty(product.ProId, 1);

            }
            catch (Exception)
            {
                SqlTransactionManager.Rollback();
                throw;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }

            IList<string> values = ipartRepository.GetValueFromSysSettingByName("Customer");
            string value="";
            if (values.Count > 0)
                value = values[0];

            CurrentSession.AddValue(Session.SessionKeys.PrintLogName, value + " SNO");
            CurrentSession.AddValue(Session.SessionKeys.PrintLogBegNo, product.ProId);
            CurrentSession.AddValue(Session.SessionKeys.PrintLogEndNo, product.ProId);
            CurrentSession.AddValue(Session.SessionKeys.PrintLogDescr, product.CUSTSN);
            
            return base.DoExecute(executionContext);
        }
コード例 #11
0
        /// <summary>
        /// 產生CustomerSN號相关逻辑
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override System.Workflow.ComponentModel.ActivityExecutionStatus DoExecute(System.Workflow.ComponentModel.ActivityExecutionContext executionContext)
        {
            IProduct product = (IProduct)CurrentSession.GetValue(Session.SessionKeys.Product);
            IProductRepository productRep = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
            string stag =(string) CurrentSession.GetValue(Session.SessionKeys.CN);
            //need modify
            if (stag == "T") {
                return base.DoExecute(executionContext);
            }
            try
            {
                //CN(中国代码)+U(Site Code)+年尾码+周别码+流水码
                string custSn = "";
                //string weekCode="";
                DateTime curDate = DateTime.Now;
                //string year = curDate.Year.ToString();
                string maxnum = "";
                string prestr = "";
                bool addflag = false;

                DateTime dateTime = new DateTime(2016, 1, 1);
                var dd = DateTime.Now;
                var ret = IMES.Infrastructure.Utility.Generates.WeekRuleEngine.Calculate("103", DateTime.Now);

                string weekCode = ret.Week.ToString().PadLeft(2, '0');
                string year = ret.Year.ToString();
                prestr = custSn;

                SqlTransactionManager.Begin();
                IUnitOfWork uof = new UnitOfWork();//使用自己的UnitOfWork
                custSn = "CN" + "U" + custSn + year.Substring(year.Length - 1, 1) + weekCode;

                //从NumControl中获取流水号
                //GetMaxNumber
                INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                //maxnum = numControl.GetMaxNumber("CPQSNO", prestr + "{0}");

                var maxObj = numControl.GetMaxNumberObj("CPQSNO", prestr + "{0}");
                if (maxObj != null)
                    maxnum = maxObj.Value;

                if (string.IsNullOrEmpty(maxnum))
                {
                    maxnum = "9000";
                    addflag = true;
                }
                else
                {
                    //maxnum="CNU248000Y";
                    MathSequenceWithCarryNumberRule marc = new MathSequenceWithCarryNumberRule(4, "0123456789BCDFGHJKLMNPQRSTVWXYZ");
                    string numstr = maxnum.Substring(maxnum.Length - 4);

                    //string temstr = "0000";

                    if (numstr.ToUpper() == "YZZZ")
                    {
                        FisException fe = new FisException("CHK867", new string[] { });   //流水号已满!
                        throw fe;
                    }
                    numstr = marc.IncreaseToNumber(numstr, 1);
                    maxnum = numstr;
                }
                    
                custSn = custSn + maxnum.ToUpper();

                product.CUSTSN = custSn;
                //productRep.Update(product, CurrentSession.UnitOfWork);

                NumControl item = null;// new NumControl();

                if (addflag)
                {
                    item = new NumControl();
                    item.NOType = "CPQSNO";
                    item.Value = custSn;
                    item.NOName = "";
                    item.Customer = "HP";
                }
                else
                {
                    item = maxObj;
                    item.Value = custSn;
                }

                //numControl.SaveMaxNumber(item, addflag, prestr + "{0}");
                numControl.SaveMaxNumber(item, addflag);

                uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值

                SqlTransactionManager.Commit();//提交事物,释放行级更新锁

                // [Customer SN Print]保存结果:增加更新[CustomerSN_Qty]. CustomerSN_Qty栏位
                //UPDATE [HPIMES].[dbo].[MO]
                //SET [CustomerSN_Qty] =[ CustomerSN_Qty]+1
                //From Product a,MO b  WHERE a.MO=b.MO and a.ProductID=ProductID#

                IMORepository moRepository = RepositoryFactory.GetInstance().GetRepository<IMORepository, MO>();
                moRepository.UpdateMoForIncreaseCustomerSnQty(product.ProId, 1);
            }
            catch (Exception)
            {
                SqlTransactionManager.Rollback();
                throw;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }

                /*CurrentSession.AddValue(Session.SessionKeys.PrintLogName, product.Customer + " SNO");
            CurrentSession.AddValue(Session.SessionKeys.PrintLogBegNo, product.CUSTSN);
            CurrentSession.AddValue(Session.SessionKeys.PrintLogEndNo, product.CUSTSN);
            CurrentSession.AddValue(Session.SessionKeys.PrintLogDescr, product.ProId);
            */
            return base.DoExecute(executionContext);
        }
コード例 #12
0
ファイル: GetKitID.cs プロジェクト: wra222/testgit
        private static string GetFlowNumber()
        {
            long flow_number = 0;

            lock (SS_LOCK)
            {
                SqlTransactionManager.Begin();
                INumControlRepository rep = RepositoryFactory.GetInstance()
                    .GetRepository<INumControlRepository, NumControl>();
                NumControl next_avail = rep.GetMaxValue(SS_TYPE, SS_NAME);
                if (next_avail == null)
                {
                    next_avail = new NumControl();
                    next_avail.Customer = SS_CUST;
                    next_avail.NOType = SS_TYPE;
                    next_avail.NOName = SS_NAME;

                    flow_number = SS_INIT;
                    next_avail.Value = (flow_number + 1).ToString();

                    rep.InsertNumControl(next_avail);
                    SqlTransactionManager.Commit();
                }
                else
                {
                    flow_number = long.Parse(next_avail.Value);
                    next_avail.Value = (flow_number + 1).ToString();

                    IUnitOfWork uof = new UnitOfWork();
                    rep.Update(next_avail, uof);
                    uof.Commit();
                    SqlTransactionManager.Commit();
                }
            }

            return (flow_number % 100000).ToString("D5");
        }
コード例 #13
0
ファイル: GenerateRCTOCTNo.cs プロジェクト: wra222/testgit
        /// <summary>
        /// 產生Carton NO號相关逻辑
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override System.Workflow.ComponentModel.ActivityExecutionStatus DoExecute(System.Workflow.ComponentModel.ActivityExecutionContext executionContext)
        { 
            string ctno = (string)CurrentSession.GetValue("CTNO");
            int qty = (int)CurrentSession.GetValue("QTY");
            IProductRepository productRep = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();

            //获取Part.PartNo 和 Part.Descr
            //条件:Part.PartNo = PartInfo.PartNo and PartInfo.InfoValue=Left([CT No],5)
            //限制:Top 1
            //若Part.PartNo不存在,则报错:“错误的CT No”

            IPartRepository partRep = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>();
            PartInfo cond = new PartInfo();
            cond.PN = ctno.Substring(0, 5);
            IList<PartInfo> partList = partRep .GetPartInfoList(cond);                 
            PartInfo partinfo = partList[0];
            IPart part = partRep.Find(partinfo.PN);
                

            //Generate New CT No
            //方法:原[CT No] + 流水码
            //数量:Qty
            //流水码规则:
            //3位
            //31进制:0123456789BCDFGHJKLMNPQRSTVWXYZ
            //从000开始
            // 若为’ZZZ’,则报错:“流水号已用完”
            //[CT No]为前缀,若[CT No]改变,则流水码从000开始
            try
            {
                string newCtno = "";
                string maxnum = "";
                string prestr = "";
                bool addflag = false;
    
                prestr = ctno;
                // 自己管理事务开始
                //SqlTransactionManager.Begin();
                //IUnitOfWork uof = new UnitOfWork();//使用自己的UnitOfWork

                //从NumControl中获取流水号
                //GetMaxNumber
                INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                MathSequenceWithCarryNumberRule marc = new MathSequenceWithCarryNumberRule(3, "0123456789BCDFGHJKLMNPQRSTVWXYZ");

                NumControl maxObj = numControl.GetMaxNumberObj("CTNO", prestr + "{0}");
                if (maxObj != null)
                    maxnum = maxObj.Value;

                if (string.IsNullOrEmpty(maxnum))
                {
                    maxnum = "000";
                    addflag = true;
                }
                else
                {

                    string numstr = maxnum.Substring(maxnum.Length - 3);
                    long diff = marc.CalculateDifference(numstr,"ZZZ");
                    if (numstr.ToUpper() == "ZZZ" || diff < qty)
                    {
                        FisException fe = new FisException("CHK867", new string[] { });   //流水号已满!
                        throw fe;
                    }

                    numstr = marc.IncreaseToNumber(numstr, 1);
                    maxnum = numstr;
                }

                newCtno = ctno + maxnum.ToUpper();

                NumControl item = null;// new NumControl();
                if (addflag)
                {
                    item = new NumControl();
                    item.NOType = "CTNO";
                    item.Value = newCtno;
                    item.NOName = "";
                    item.Customer = "HP";
                }
                else
                {
                    item = maxObj;
                    item.Value = newCtno;
                }

                int count = 1;
                IPrintLogRepository printRep = RepositoryFactory.GetInstance().GetRepository<IPrintLogRepository, PrintLog>();
                IList<string> ctnoList = new List<string>(); 
                while(count <= qty)
                {
                    ctnoList.Add(item.Value);
                    numControl.SaveMaxNumber(item, addflag);

                    //Insert PartSN
                    //IECSN:产生的18位CT No
                    //IECPn:Step2中获取的Part.PartNo
                    //PartType:Step2中获取的Part.Descr
                    //VendorSN:输入的15码的[CT No]
                    IPartSnRepository partsnRep = RepositoryFactory.GetInstance().GetRepository<IPartSnRepository, PartSn>();
                    //PartSn(string iecSn, string iecPn, string type, string vendorSn, string vendorDCode, string vCode, string pn151, string editor, string dateCode);
                    PartSn partSn = new PartSn(newCtno, part.PN, part.Descr,ctno,"","","",this.Editor,"");
                    partsnRep.Add(partSn,CurrentSession.UnitOfWork);

                    //Insert PrintLog
                    //Name=’RCTO CT Label’
                    //BegNo=Begin [CT No]
                    //EndNo=End [CT No]
                    //Descr=[Qty]
                    var log = new PrintLog
                    {
                        Name = "RCTO CT Label",
                        BeginNo = newCtno,
                        EndNo = newCtno,
                        Descr = Convert.ToString(qty),
                        Editor = this.Editor
                    };
                    printRep.Add(log, CurrentSession.UnitOfWork);

                    //get next
                    count++;
                    addflag = false;
                    maxnum = marc.IncreaseToNumber(maxnum, 1);
                    newCtno = ctno + maxnum.ToUpper();
                    item = maxObj;
                    item.Value = newCtno;
                }             
                //uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值
                //SqlTransactionManager.Commit();//提交事物,释放行级更新锁 
             
                CurrentSession.AddValue("CTNOList", ctnoList);
                
            }
            catch (Exception)
            {
                //SqlTransactionManager.Rollback();
                throw;
            }
            finally
            {
                //SqlTransactionManager.Dispose();
                //SqlTransactionManager.End();
            }
            
            return base.DoExecute(executionContext);
        }
コード例 #14
0
        /// <summary>
        /// Generate DummyPalletNo, and Save the Relation with Product in the IMES_PAK..Dummy_ShipDet Table
        /// </summary>
        protected internal override ActivityExecutionStatus DoExecute(ActivityExecutionContext executionContext)
        {
            FisException ex;
            List<string> erpara = new List<string>();
          //  Product currentProduct = (Product)CurrentSession.GetValue(Session.SessionKeys.Product);
          //  string productId = currentProduct.ProId;
          //  绑定的是每一个刷入的CustSN的ProductID与DummyPalletNo的关系 
            IProductRepository productRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
            IList<string> ScanedProductIDList = (IList<string>)CurrentSession.GetValue(Session.SessionKeys.NewScanedProductIDList);

            IDeliveryRepository iDeliveryRepository = RepositoryFactory.GetInstance().GetRepository<IDeliveryRepository, Delivery>();
            IPalletRepository iPalletRepository = RepositoryFactory.GetInstance().GetRepository<IPalletRepository, Pallet>();
            string DPC = (string)CurrentSession.GetValue(Session.SessionKeys.DummyPalletCase);
            string dummyPalletNo = (string)CurrentSession.GetValue(Session.SessionKeys.DummyPalletNo);
            string generateDummyPalletNo = string.Empty;


            if (DPC == "NA" || DPC == "BA")
            {
                //DummyShipDetInfo currentDummyshipdet = (DummyShipDetInfo)CurrentSession.GetValue(Session.SessionKeys.DummyShipDet);

                //currentDummyshipdet.bol = dummyPalletNo;
                //currentDummyshipdet.editor = this.Editor;
                //currentDummyshipdet.cdt = DateTime.Now;
               
                ////update:
                //DummyShipDetInfo condDummyshipdet = new DummyShipDetInfo();
                //condDummyshipdet.snoId = currentDummyshipdet.snoId;
                //iDeliveryRepository.UpdateDummyShipDetInfo(currentDummyshipdet, condDummyshipdet);

            }

            else if (DPC == "NAN" || DPC == "BAN")
            {
                DummyShipDetInfo dummyshipdet = new DummyShipDetInfo();
                IList<DummyShipDetInfo> dummyshipdetList = null;

                //---- NumberControl ----
                INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                NumControl currentMaxNum = numCtrlRepository.GetMaxValue("Dummy", "DummyPalletNo");
                if (currentMaxNum == null)
                {
                    // 从数据库DummyShip_Det表获取当前最大值
                    dummyshipdetList = iDeliveryRepository.GetDummyShipDetInfoList(dummyshipdet); //拿全集

                    if (dummyshipdetList == null || dummyshipdetList.Count <= 0)
                    {
                        //generateDummyPalletNo = "9000000001";
                        //产线确认修改生产号规则:流水号初始值十进制   60000000
                        generateDummyPalletNo = "90" + "60000000";
                    }
                    else
                    {
                        int max = 0;
                        foreach (DummyShipDetInfo iDSD in dummyshipdetList)
                        {
                            if (iDSD.plt != null && iDSD.plt != "")
                            {
                                if (iDSD.plt.Length != 10)
                                {
                                    erpara.Add(iDSD.plt);
                                    ex = new FisException("PAK071", erpara);
                                    throw ex;
                                }

                                if (iDSD.plt.Substring(0, 2) != "90")
                                {
                                    erpara.Add(iDSD.plt);
                                    ex = new FisException("PAK048", erpara);
                                    throw ex;
                                }

                                Boolean exitLetter = Regex.Matches(iDSD.plt.Substring(2, 8), "[a-zA-Z]").Count > 0;

                                if (exitLetter)
                                {
                                    erpara.Add(iDSD.plt);
                                    ex = new FisException("PAK109", erpara);
                                    throw ex;
                                }

                                int temp = Convert.ToInt32(iDSD.plt.Substring(2, 8));
                                if (temp > max)
                                {
                                    max = temp;
                                }
                            }
                        }
                        if (max == 0)
                        {
                            generateDummyPalletNo = "90" + "60000000";
                        }
                        else
                        {
                            max = max + 1;
                            string maxString = max.ToString();
                            int maxlength = maxString.Length;
                            if (maxlength < 8)
                            {
                                int len = 8 - maxlength;
                                for (int i = 0; i < len; i++)
                                {
                                    maxString = "0" + maxString;
                                }
                            }
                            generateDummyPalletNo = "90" + maxString;
                        }
                    }

                    currentMaxNum = new NumControl();
                    currentMaxNum.NOName = "DummyPalletNo";
                    currentMaxNum.NOType = "Dummy";
                    currentMaxNum.Value = generateDummyPalletNo;
                    currentMaxNum.Customer = this.Customer;

                    IUnitOfWork uof = new UnitOfWork();
                    numCtrlRepository.InsertNumControlDefered(uof, currentMaxNum);
                    uof.Commit();
                    SqlTransactionManager.Commit();
                }
                else
                {
                    if (currentMaxNum.Value.Length != 10)
                    {
                        erpara.Add(currentMaxNum.Value);
                        ex = new FisException("PAK071", erpara);
                        throw ex;
                    }

                    if (currentMaxNum.Value.Substring(0, 2) != "90")
                    {
                        erpara.Add(currentMaxNum.Value);
                        ex = new FisException("PAK048", erpara);
                        throw ex;
                    }

                    int temp = Convert.ToInt32(currentMaxNum.Value.Substring(2, 8));
                    temp = temp + 1;
                    string maxtemp = temp.ToString();
                    int maxlength = maxtemp.Length;
                    if (maxlength < 8)
                    {
                        int len = 8 - maxlength;
                        for (int i = 0; i < len; i++)
                        {
                            maxtemp = "0" + maxtemp;
                        }
                    }
                    generateDummyPalletNo = "90" + maxtemp;

                
                    //currentMaxNum = new NumControl();
                    //currentMaxNum.NOName = "DummyPalletNo";
                    //currentMaxNum.NOType = "Dummy";
                    currentMaxNum.Value = generateDummyPalletNo;
                    //currentMaxNum.Customer = this.Customer;

                    IUnitOfWork uof = new UnitOfWork();

                    numCtrlRepository.Update(currentMaxNum, uof);
                    uof.Commit();
                    SqlTransactionManager.Commit();
                }

                //---- NumberControl ----

                // 每一个刷入的CustSN的ProductID与都要与该生成的DummyPalletNo绑定,并且bol应记录BOL (For NAN: dummyPalletNo = ideliveryRepository.GetDeliveryInfoValue(deliveryNo, "BOL");)
                foreach (string iprodId in ScanedProductIDList)
                {
                    dummyshipdet = new DummyShipDetInfo();

                    dummyshipdet.plt = generateDummyPalletNo;
                    dummyshipdet.snoId = iprodId;
                    dummyshipdet.bol = dummyPalletNo;
                    dummyshipdet.editor = this.Editor;
                    dummyshipdet.cdt = DateTime.Now;
                    dummyshipdet.udt = DateTime.Now;

                    // insert:
                    iDeliveryRepository.InsertDummyShipDetInfoDefered(CurrentSession.UnitOfWork, dummyshipdet);
                }

                
            }
            

            CurrentSession.AddValue(Session.SessionKeys.GenerateDummyPalletNo, generateDummyPalletNo);
           
            return base.DoExecute(executionContext);
        }
コード例 #15
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override ActivityExecutionStatus DoExecute(ActivityExecutionContext executionContext)
        {
            MB currenMB = CurrentSession.GetValue(Session.SessionKeys.MB) as MB;

            IPartRepository CurrentPartRepository = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>();
            string mbctValue = CurrentPartRepository.GetPartInfoValue(currenMB.PCBModelID, "MBCT");


            //if (mbctValue == "T")
            //{

                IMBRepository CurrentMBRepository = RepositoryFactory.GetInstance().GetRepository<IMBRepository, IMB>();
                MBCFGDef currentMBCFG = CurrentMBRepository.GetMBCFG(currenMB.MBCode, "PC");
                if (currentMBCFG == null || string.IsNullOrEmpty(currentMBCFG.CFG))
                {
                    throw new FisException("ICT006", new string[] { });
                }

               // string thisYear = DateTime.Today.Year.ToString("0000");
                string thisYear = "";
                string weekCode = "";
                IModelRepository CurrentModelRepository = RepositoryFactory.GetInstance().GetRepository<IModelRepository, Model>();
                //Vincent 2014-01-01 fixed  bug : used wrong this year cross year issue
                //IList<string> weekCodeList = CurrentModelRepository.GetCodeFromHPWeekCodeInRangeOfDescr();
                IList<HpweekcodeInfo> weekCodeList = CurrentModelRepository.GetHPWeekCodeInRangeOfDescr();
                if (weekCodeList != null && weekCodeList.Count > 0)
                {
                    weekCode = weekCodeList[0].code;
                    thisYear = weekCodeList[0].descr.Trim().Substring(0, 4);
                }
                else
                {
                    throw new FisException("ICT009", new string[] { });
                }

                try
                {
                    SqlTransactionManager.Begin();
                    lock (_syncRoot_GetSeq)
                    {
                        INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                        NumControl currentMaxNum = numCtrlRepository.GetMaxValue("MBCT", currentMBCFG.CFG);
                        if (currentMaxNum == null)
                        {
                            IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();

                            SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB");
                            if (first == null)
                            {
                                throw new FisException("ICT013", new string[] { });
                            }
                            currentMaxNum = new NumControl();
                            currentMaxNum.NOName = currentMBCFG.CFG;
                            currentMaxNum.NOType = "MBCT";
                            currentMaxNum.Value = thisYear + weekCode + first.code + "000";
                            currentMaxNum.Customer = "";
                            numCtrlRepository.InsertNumControl(currentMaxNum);
                            SqlTransactionManager.Commit();
                            CurrentSession.AddValue(Session.SessionKeys.MBCT, currentMBCFG.CFG + "00" + first.code + weekCode + "000");
                        }
                        else if (currentMaxNum.Value.Substring(0, 6) != (thisYear + weekCode))
                        {
                            IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
                            SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB");
                            if (first == null)
                            {
                                throw new FisException("ICT013", new string[] { });
                            }

                            currentMaxNum.Value = thisYear + weekCode + first.code + "000";
                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.Update(currentMaxNum, uof);
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            CurrentSession.AddValue(Session.SessionKeys.MBCT, currentMBCFG.CFG + "00" + first.code + weekCode + "000");
                        }
                        else
                        {
                            if (currentMaxNum.Value.EndsWith("ZZZ"))
                            {
                                IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
                                IList<SupplierCodeInfo> codeList = currentProductRepository.GetSupplierCodeListByCode(currentMaxNum.Value.Substring(6, 2));

                                SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB", codeList[0].idex);
                                if (first == null)
                                {
                                    throw new FisException("ICT005", new string[] { });
                                }

                                currentMaxNum.Value = thisYear + weekCode + first.code + "000";
                                IUnitOfWork uof = new UnitOfWork();
                                numCtrlRepository.Update(currentMaxNum, uof);
                                uof.Commit();
                                SqlTransactionManager.Commit();
                                CurrentSession.AddValue(Session.SessionKeys.MBCT, currentMBCFG.CFG + "00" + first.code + weekCode + "000");
                            }
                            else
                            {
                                ISequenceConverter seqCvt = new SequenceConverterNormal("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ", 3, "ZZZ", "000", '0');
                                string sequenceNumber = currentMaxNum.Value.Substring(8, 3);
                                sequenceNumber = seqCvt.NumberRule.IncreaseToNumber(sequenceNumber, 1);

                                currentMaxNum.Value = currentMaxNum.Value.Substring(0, 8) + sequenceNumber;
                                IUnitOfWork uof = new UnitOfWork();
                                numCtrlRepository.Update(currentMaxNum, uof);
                                uof.Commit();
                                SqlTransactionManager.Commit();
                                CurrentSession.AddValue(Session.SessionKeys.MBCT, currentMBCFG.CFG + "00" + currentMaxNum.Value.Substring(6, 2) + weekCode + sequenceNumber);
                            }
                        }
                    }
                }
                catch (Exception e)
                {
                    SqlTransactionManager.Rollback();
                    throw e;
                }
                finally
                {
                    SqlTransactionManager.Dispose();
                    SqlTransactionManager.End();
                }
            //}

            return base.DoExecute(executionContext);
        }
コード例 #16
0
ファイル: ReturnUsedKeysImpl.cs プロジェクト: wra222/testgit
        public ArrayList Save(List<string> SNList,
                              List<string> PNList,
                              List<string> errList, string Editor, string Station, string customer)
        {
            logger.Debug("(ReturnUsedKeysImpl)Save start" 
                
                + " [editor]:" + Editor
                + " [station]:" + Station
                + " [customer]:" + customer);
            FisException ex;
            List<string> erpara = new List<string>();
            ArrayList retvaluelist = new ArrayList();
            string ECOAReturnStatus = "0";
            var productRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
            var currentRepository = RepositoryFactory.GetInstance().GetRepository<ICOAStatusRepository, COAStatus>();

            try
            {
                ///生成group id
                SqlTransactionManager.Begin();
                IUnitOfWork Number_uof = new UnitOfWork();//使用自己的UnitOfWork
                string prestr = "";
                string maxnum = "";
                bool addflag = false;
               
                INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                maxnum = numControl.GetMaxNumber("GroupID", prestr + "{0}");
                if (string.IsNullOrEmpty(maxnum))
                {
                    maxnum = "001";
                    addflag = true;
                }
                else
                {
                    if (maxnum.Substring(6, 3).ToUpper() == "999")
                    {
                        maxnum = "001";
                    }
                    else
                    {
                        int count = Int32.Parse(maxnum.Substring(6, 3));
                        count = count + 1;
                        maxnum = (count).ToString().PadLeft(3, '0');
                    }
                }
                DateTime dd = DateTime.Now;
                string Groupid = dd.Year.ToString().Substring(2,2) + dd.Month.ToString().PadLeft(2, '0') + dd.Day.ToString().PadLeft(2, '0') + maxnum;
                NumControl item = new NumControl();
                item.NOType = "GroupID";
                item.Value = Groupid;
                item.NOName = "";
                item.Customer = "HP";

                numControl.SaveMaxNumber(item, addflag, prestr + "{0}");
               
                Number_uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值
                SqlTransactionManager.Commit();//提交事物,释放行级更新锁

                
                 
                /////////////////////////////////////////////////

                for (int i = 0; i < SNList.Count; i++)
                {
                    IProduct CurrentProduct = null;
                    if (errList[i] == "Pass")
                    {
                        string custSn = SNList[i];
                        
                        IUnitOfWork work = new UnitOfWork();
                        CurrentProduct = productRepository.GetProductByCustomSn(custSn);
                        if (CurrentProduct == null)
                        {
                            continue;
                        }
                        string line = CurrentProduct.Status.Line;
                        StationStatus Status = StationStatus.Pass;
                      
                        var productLog = new ProductLog
                        {
                            Model = CurrentProduct.Model,
                            Status = Status,
                            Editor = Editor,
                            Line = line,
                            Station = Station,
                            Cdt = DateTime.Now
                        };
                        CurrentProduct.AddLog(productLog);
                      
                        /////////update product status
                        var newStatus = new ProductStatus();
                        newStatus.Status = Status;
                        newStatus.StationId = Station;
                        newStatus.Editor = Editor;
                        newStatus.Line = line;
                        newStatus.TestFailCount = 0;

                        if (!string.IsNullOrEmpty(CurrentProduct.Status.ReworkCode) && productRepository.IsLastReworkStation(CurrentProduct.Status.ReworkCode, Station, (int)Status))
                        {
                            newStatus.ReworkCode = "";
                            IMES.DataModel.Rework r = new IMES.DataModel.Rework();
                            r.ReworkCode = CurrentProduct.Status.ReworkCode;
                            r.Editor = Editor;
                            r.Status = "3";
                            r.Udt = DateTime.Now;
                            productRepository.UpdateReworkConsideredProductStatusDefered(work, r, CurrentProduct.ProId);
                        }
                        else
                        {
                            newStatus.ReworkCode = CurrentProduct.Status.ReworkCode;
                        }
                        newStatus.ProId = CurrentProduct.ProId;
                        CurrentProduct.UpdateStatus(newStatus);
                        
                        productRepository.Update(CurrentProduct, work);

                        ECOAReturnStatus = "1";
                    }
                    dm.EcoareturnInfo item1 = new dm.EcoareturnInfo();
                    item1.custsn = SNList[i];
                    item1.partNo = PNList[i];
                    item1.message = errList[i];
                    item1.status = ECOAReturnStatus;
                    item1.line = CurrentProduct.Status.Line;
                    item1.groupNo = Groupid;
                    
                    currentRepository.InsertEcoareturn(item1);

                }
                retvaluelist.Add(Groupid);
                return retvaluelist;

            }
            catch (FisException e)
            {
                logger.Error(e.mErrmsg);

                throw e;
            }
            catch (Exception e)
            {
                logger.Error(e.Message);
                throw e;
            }
            finally
            {
                logger.Debug("(ReturnUsedKeysImpl)Save end" 
                    
                    + " [editor]:" + Editor
                    + " [station]:" + Station
                    + " [customer]:" + customer);
            }
        }
コード例 #17
0
ファイル: AcquireMBCT.cs プロジェクト: wra222/testgit
        /// <summary>
        /// 
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override ActivityExecutionStatus DoExecute(ActivityExecutionContext executionContext)
        {
            string check = (string)CurrentSession.GetValue(Session.SessionKeys.CN);
            string model = (string)CurrentSession.GetValue(Session.SessionKeys.ModelName);
            if ((check != null && check == "RCTO") || 
                ((model != null) && (model.IndexOf("173") == 0 || model.IndexOf("146") == 0)))
            {
                IMBRepository CurrentMBRepository = RepositoryFactory.GetInstance().GetRepository<IMBRepository, IMB>();
                IModelRepository CurrentModelRepository = RepositoryFactory.GetInstance().GetRepository<IModelRepository, Model>();
                var CurrentMB = (MB)CurrentSession.GetValue(Session.SessionKeys.MB);
                IList<IMES.FisObject.Common.Model.ModelInfo> infos = new List<IMES.FisObject.Common.Model.ModelInfo>();
                infos = CurrentModelRepository.GetModelInfoByModelAndName(model, "MN");
                string series = "";
                if (infos == null || infos.Count <= 0)
                {
                    throw new FisException("ICT006", new string[] { });
                }
                else
                {
                    series = infos[0].Value;
                }
                IList<MBCFGDef> currentMBCFGList = new List<MBCFGDef>();
                MBCFGDef currentMBCFG = new MBCFGDef();
                currentMBCFGList = CurrentMBRepository.GetMBCFGByCodeSeriesAndType(CurrentMB.MBCode, series, "RCTO");
                if (currentMBCFGList == null || currentMBCFGList.Count <= 0)
                {
                    throw new FisException("ICT006", new string[] { });
                }
                else
                {
                    currentMBCFG = currentMBCFGList[0];
                }
                //string thisYear = DateTime.Today.Year.ToString("0000");
                string thisYear = "";
                string weekCode = "";
                //Vincent 2014-01-01 fixed  bug : used wrong this year cross year issue
                //IList<string> weekCodeList = CurrentModelRepository.GetCodeFromHPWeekCodeInRangeOfDescr();
                IList<HpweekcodeInfo> weekCodeList = CurrentModelRepository.GetHPWeekCodeInRangeOfDescr();
                if (weekCodeList != null && weekCodeList.Count > 0)
                {
                    weekCode = weekCodeList[0].code;
                    thisYear = weekCodeList[0].descr.Trim().Substring(0, 4);
                }
                else
                {
                    throw new FisException("ICT009", new string[] { });
                }
                try
                {
                    SqlTransactionManager.Begin();
                    lock (_syncRoot_GetSeq)
                    {
                        INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                        NumControl currentMaxNum = numCtrlRepository.GetMaxValue("MBCT", currentMBCFG.CFG);
                        if (currentMaxNum == null)
                        {
                            IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();

                            SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB");
                            if (first == null)
                            {
                                throw new FisException("ICT013", new string[] { });
                            }
                            currentMaxNum = new NumControl();
                            currentMaxNum.NOName = currentMBCFG.CFG;
                            currentMaxNum.NOType = "MBCT";
                            currentMaxNum.Value = thisYear + weekCode + first.code + beginNO;
                            currentMaxNum.Customer = "";
                            numCtrlRepository.InsertNumControl(currentMaxNum);
                            SqlTransactionManager.Commit();
                            CurrentSession.AddValue("MBCT", currentMBCFG.CFG + "00" + first.code + weekCode + beginNO);
                        }
                        else if (currentMaxNum.Value.Substring(0, 6) != (thisYear + weekCode))
                        {
                            IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
                            SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB");
                            if (first == null)
                            {
                                throw new FisException("ICT013", new string[] { });
                            }

                            currentMaxNum.Value = thisYear + weekCode + first.code + beginNO;
                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.Update(currentMaxNum, uof);
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            CurrentSession.AddValue("MBCT", currentMBCFG.CFG + "00" + first.code + weekCode + beginNO);
                        }
                        else
                        {
                            if (currentMaxNum.Value.EndsWith("ZZZ"))
                            {
                                IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
                                IList<SupplierCodeInfo> codeList = currentProductRepository.GetSupplierCodeListByCode(currentMaxNum.Value.Substring(6, 2));

                                SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB", codeList[0].idex);
                                if (first == null)
                                {
                                    throw new FisException("ICT005", new string[] { });
                                }

                                currentMaxNum.Value = thisYear + weekCode + first.code + beginNO;
                                IUnitOfWork uof = new UnitOfWork();
                                numCtrlRepository.Update(currentMaxNum, uof);
                                uof.Commit();
                                SqlTransactionManager.Commit();
                                CurrentSession.AddValue("MBCT", currentMBCFG.CFG + "00" + first.code + weekCode + beginNO);
                            }
                            else
                            {
                                ISequenceConverter seqCvt = new SequenceConverterNormal("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ", 3, "ZZZ", beginNO, '0');
                                string sequenceNumber = currentMaxNum.Value.Substring(8, 3);
                                sequenceNumber = seqCvt.NumberRule.IncreaseToNumber(sequenceNumber, 1);

                                currentMaxNum.Value = currentMaxNum.Value.Substring(0, 8) + sequenceNumber;
                                IUnitOfWork uof = new UnitOfWork();
                                numCtrlRepository.Update(currentMaxNum, uof);
                                uof.Commit();
                                SqlTransactionManager.Commit();
                                CurrentSession.AddValue("MBCT", currentMBCFG.CFG + "00" + currentMaxNum.Value.Substring(6, 2) + weekCode + sequenceNumber);
                            }
                        }
                    }
                    /*string mbct = CurrentSession.GetValue("MBCT") as string;
                    if (!string.IsNullOrEmpty(mbct))
                    {
                        IMES.FisObject.PCA.MB.MBInfo mbctInfo = new IMES.FisObject.PCA.MB.MBInfo(0, CurrentMB.Sn, "MBCT", mbct, Editor, DateTime.Now, DateTime.Now);
                        CurrentMB.AddMBInfo(mbctInfo);
                    }*/
                }
                catch (Exception e)
                {
                    SqlTransactionManager.Rollback();
                    throw e;
                }
                finally
                {
                    SqlTransactionManager.Dispose();
                    SqlTransactionManager.End();
                }
            }
            else
            {
            
                MB currenMB = CurrentSession.GetValue(Session.SessionKeys.MB) as MB;
                string mbctValue = "T";
                if (!MustGenerate)
                {
                    IPartRepository CurrentPartRepository = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>();
                    mbctValue = CurrentPartRepository.GetPartInfoValue(currenMB.PCBModelID, "MBCT");
                }

                if (mbctValue == "T")
                {

                    IMBRepository CurrentMBRepository = RepositoryFactory.GetInstance().GetRepository<IMBRepository, IMB>();
                    MBCFGDef currentMBCFG = CurrentMBRepository.GetMBCFG(currenMB.MBCode, "PC");
                    if (currentMBCFG == null || string.IsNullOrEmpty(currentMBCFG.CFG))
                    {
                        throw new FisException("ICT006", new string[] { });
                    }

                    //string thisYear = DateTime.Today.Year.ToString("0000");
                    string thisYear = "";
                    string weekCode = "";
                    IModelRepository CurrentModelRepository = RepositoryFactory.GetInstance().GetRepository<IModelRepository, Model>();
                    //Vincent 2014-01-01 fixed  bug : used wrong this year cross year issue
                    //IList<string> weekCodeList = CurrentModelRepository.GetCodeFromHPWeekCodeInRangeOfDescr();
                    IList<HpweekcodeInfo> weekCodeList = CurrentModelRepository.GetHPWeekCodeInRangeOfDescr();
                    if (weekCodeList != null && weekCodeList.Count > 0)
                    {
                        weekCode = weekCodeList[0].code;
                        thisYear = weekCodeList[0].descr.Trim().Substring(0, 4);
                    }
                    else
                    {
                        throw new FisException("ICT009", new string[] { });
                    }

                    try
                    {
                        SqlTransactionManager.Begin();
                        lock (_syncRoot_GetSeq)
                        {
                            INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                            NumControl currentMaxNum = numCtrlRepository.GetMaxValue("MBCT", currentMBCFG.CFG);
                            if (currentMaxNum == null)
                            {
                                IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();

                                SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB");
                                if (first == null)
                                {
                                    throw new FisException("ICT013", new string[] { });
                                }
                                currentMaxNum = new NumControl();
                                currentMaxNum.NOName = currentMBCFG.CFG;
                                currentMaxNum.NOType = "MBCT";
                                currentMaxNum.Value = thisYear + weekCode + first.code + beginNO;
                                currentMaxNum.Customer = "";
                                numCtrlRepository.InsertNumControl(currentMaxNum);
                                SqlTransactionManager.Commit();
                                CurrentSession.AddValue(Session.SessionKeys.MBCT, currentMBCFG.CFG + "00" + first.code + weekCode + beginNO);
                            }
                            else if (currentMaxNum.Value.Substring(0, 6) != (thisYear + weekCode))
                            {
                                IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
                                SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB");
                                if (first == null)
                                {
                                    throw new FisException("ICT013", new string[] { });
                                }

                                currentMaxNum.Value = thisYear + weekCode + first.code + beginNO;
                                IUnitOfWork uof = new UnitOfWork();
                                numCtrlRepository.Update(currentMaxNum, uof);
                                uof.Commit();
                                SqlTransactionManager.Commit();
                                CurrentSession.AddValue(Session.SessionKeys.MBCT, currentMBCFG.CFG + "00" + first.code + weekCode + beginNO);
                            }
                            else
                            {
                                if (currentMaxNum.Value.EndsWith("ZZZ"))
                                {
                                    IProductRepository currentProductRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
                                    IList<SupplierCodeInfo> codeList = currentProductRepository.GetSupplierCodeListByCode(currentMaxNum.Value.Substring(6, 2));

                                    SupplierCodeInfo first = currentProductRepository.GetSupplierCodeByVendor("MB", codeList[0].idex);
                                    if (first == null)
                                    {
                                        throw new FisException("ICT005", new string[] { });
                                    }

                                    currentMaxNum.Value = thisYear + weekCode + first.code + beginNO;
                                    IUnitOfWork uof = new UnitOfWork();
                                    numCtrlRepository.Update(currentMaxNum, uof);
                                    uof.Commit();
                                    SqlTransactionManager.Commit();
                                    CurrentSession.AddValue(Session.SessionKeys.MBCT, currentMBCFG.CFG + "00" + first.code + weekCode + beginNO);
                                }
                                else
                                {
                                    ISequenceConverter seqCvt = new SequenceConverterNormal("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ", 3, "ZZZ", beginNO, '0');
                                    string sequenceNumber = currentMaxNum.Value.Substring(8, 3);
                                    sequenceNumber = seqCvt.NumberRule.IncreaseToNumber(sequenceNumber, 1);

                                    currentMaxNum.Value = currentMaxNum.Value.Substring(0, 8) + sequenceNumber;
                                    IUnitOfWork uof = new UnitOfWork();
                                    numCtrlRepository.Update(currentMaxNum, uof);
                                    uof.Commit();
                                    SqlTransactionManager.Commit();
                                    CurrentSession.AddValue(Session.SessionKeys.MBCT, currentMBCFG.CFG + "00" + currentMaxNum.Value.Substring(6, 2) + weekCode + sequenceNumber);
                                }
                            }
                        }
                    }
                    catch (Exception e)
                    {
                        SqlTransactionManager.Rollback();
                        throw e;
                    }
                    finally
                    {
                        SqlTransactionManager.Dispose();
                        SqlTransactionManager.End();
                    }
                }
            }

            return base.DoExecute(executionContext);
        }
コード例 #18
0
ファイル: AcquireMacSection.cs プロジェクト: wra222/testgit
        protected string getSequence(Session sess)
        {
            #region . Remarks  .
            ///1.	取得已经使用的最大的MAC
            ///GetData..[NumControl] – NoType = ‘MAC’and NoName = [MACRange].Code = 111 Level Part 的Code 属性 (PartInfo.InfoType = ‘Code’ 记录的InfoValue)

            ///2.	在该MAC 的基础上加1得到新的MAC

            ///3.	检查新的MAC 是否已经被其他MB 绑定,如果绑定则报告错误:”MAC Address<%MAC%> is used on another MB<%MB Sno%>, Please call PE!!”
            ///[PCB]

            ///4.	检查新的MAC 是否在合法MAC Range
            ///[MACRange] – Code = 111 Level Part 的Code 属性,Status IN (‘R’, ‘A’)

            ///5.	如果新的MAC 不在合法的MAC Range 中存在,则在[MACRange] 中选取一个新的Range 来使用
            ///SELECT TOP 1 BegNo as [New MAC] FROM MACRange WHERE Status = 'R' AND Code = @Code
            ///    ORDER BY Cdt

            ///6.	更新MACRange 状态
            ///[MACRange]
            ///新的MAC 所在的记录,如果新的MAC = [MACRange].EndNo,则更新该记录的Status = ‘C’;否则更新该记录的Status = ‘A’

            ///7.	更新GetData..[NumControl]
            #endregion

            int quantity = 1; //目前只支持一次取一個

            string model = ((MB)sess.GetValue(Session.SessionKeys.MB)).Model;
            // 2010-03-19 Liu Dong(eB1-4)         Modify 客户确认: IMES_PCA..MACRange.Code 栏位的数据不是111 Part 的Code 属性,而是111 Part 的Cust 属性
            //string _111PartCode = this.Get111PartCode(model);
            string _111PartCust = this.Get111PartCust(model);

            sess.AddValue(Session.SessionKeys.PN111Code, _111PartCust);

            INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
            string newNum = string.Empty;
            string maxNum = string.Empty;
            MACRange macr = null;
            lock (_syncRoot_GetSeq)
            {
                try
                {
                    SqlConnectionManager.Begin();

                    macr = numCtrlRepository.GetMaxMACRange(_111PartCust, MACRange.MACRangeStatus.Active, out maxNum);//Attempt #1
                    if (macr != null)
                    {
                        newNum = _mr.IncreaseToNumber(maxNum, quantity);
                    }
                    else
                    {
                        macr = numCtrlRepository.GetAvailableRange(_111PartCust, MACRange.MACRangeStatus.Virgin);//Attempt #2
                        if (macr != null)
                        {
                            newNum = macr.BegNo;
                        }
                        else
                        {
                            macr = numCtrlRepository.GetAvailableRange(_111PartCust, MACRange.MACRangeStatus.Active);//Attempt #3: 此Attempt爲了避免數據的不完整性: 如果NumControl裏的記錄丟失,則可以通過此來補上; 如果MACRange裏的記錄丟失,則必然會報下面的異常.
                            if (macr != null)
                            {
                                newNum = macr.BegNo;
                            }
                            else
                            {
                                throw new FisException("MDL002", new string[] { _111PartCust });
                            }
                        }
                    }

                    this.CheckBoundWithMB(newNum);

                    //TransactionOptions tsos = new TransactionOptions();
                    //tsos.IsolationLevel = IsolationLevel.ReadCommitted;
                    //using (TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNew, tsos))
                    //{
                    UnitOfWork uow = new UnitOfWork();

                    if (macr.IsEnd(newNum))
                    {
                        numCtrlRepository.SetMACRangeStatusDefered(uow, macr.ID, MACRange.MACRangeStatus.Closed);
                    }
                    else
                    {
                        numCtrlRepository.SetMACRangeStatusDefered(uow, macr.ID, MACRange.MACRangeStatus.Active);
                    }
                    NumControl newMax = new NumControl(0, GeneratesConstants.MappingToStandard(GeneratesConstants.Mac), _111PartCust, newNum, this.Customer);
                    // 2010-04-28 Liu Dong(eB1-4)         Modify 与需求不一致: MAC地址生成后,不是无条件地向NumControl里插入,而在已存在的情况下,更新当前值(不一定是最大值,因为不一定总是一个Range)就可以了.                    
                    //numCtrlRepository.SaveMaxNumberDefered(uow, newMax);
                    numCtrlRepository.SaveMaxMACDefered(uow, newMax);
                    // 2010-04-28 Liu Dong(eB1-4)         Modify 与需求不一致: MAC地址生成后,不是无条件地向NumControl里插入,而在已存在的情况下,更新当前值(不一定是最大值,因为不一定总是一个Range)就可以了.
                    uow.Commit();

                    SqlConnectionManager.Commit();

                    //    scope.Complete();
                    //}
                }
                catch (Exception)
                {
                    SqlConnectionManager.Rollback();
                    throw;
                }
                finally
                {
                    SqlConnectionManager.Dispose();
                    SqlConnectionManager.End();
                }
            }
            return newNum;
        }
コード例 #19
0
ファイル: GenerateRUNo.cs プロジェクト: wra222/testgit
        /// <summary>
        /// 產生BOX ID號號相关逻辑
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override System.Workflow.ComponentModel.ActivityExecutionStatus DoExecute(System.Workflow.ComponentModel.ActivityExecutionContext executionContext)
        {
            IProduct product = (IProduct)CurrentSession.GetValue(Session.SessionKeys.Product);
            Delivery delivery = (Delivery)CurrentSession.GetValue(Session.SessionKeys.Delivery);

            IProductRepository productRep = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
            IPalletRepository palletRep = RepositoryFactory.GetInstance().GetRepository<IPalletRepository, Pallet>();
            IDeliveryRepository deliveryRep = RepositoryFactory.GetInstance().GetRepository<IDeliveryRepository, Delivery>();
            IModelRepository modelRep = RepositoryFactory.GetInstance().GetRepository<IModelRepository, Model>();
            carton.ICartonSSCCRepository cartRep = RepositoryFactory.GetInstance().GetRepository<carton.ICartonSSCCRepository, IMES.FisObject.PAK.CartonSSCC.CartonSSCC>();

            try
            {
                //New Format of Box Id
                //Format of RU No
                //WWSSSSSS
                //Remark:
                //WW – HP Week Code
                //SSSSSS – 流水号,36进制,基字符
                string maxnum = "";
                string prestr = "";

                DateTime dateTime = DateTime.Now;
               // var ret = IMES.Infrastructure.Utility.Generates.WeekRuleEngine.Calculate("103", dateTime);
                IList<string> codeList = modelRep.GetCodeFromHPWeekCodeInRangeOfDescr();
                string weekCode = "";
                if (codeList.Count > 0)
                {
                    weekCode = codeList[0];
                }

                string runo = "";
                runo = weekCode ;
                prestr = runo;
                // 自己管理事务开始
                SqlTransactionManager.Begin();
                IUnitOfWork uof = new UnitOfWork();//使用自己的UnitOfWork

                //从NumControl中获取流水号
                //GetMaxNumber
                INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                bool addflag = false;

                maxnum = numControl.GetMaxNumber("RUNO", prestr + "{0}");
                if (string.IsNullOrEmpty(maxnum))
                {
                    maxnum = "000001";
                    addflag = true;
                }
                else
                {
                    MathSequenceWithCarryNumberRule marc = new MathSequenceWithCarryNumberRule(6, "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ");

                    string numstr = maxnum.Substring(maxnum.Length - 6);
                    if (numstr.ToUpper() == "ZZZZZZ")
                    {
                        FisException fe = new FisException("CHK867", new string[] { });   //流水号已满!
                        throw fe;
                    }
                    numstr = marc.IncreaseToNumber(numstr, 1);
                    maxnum = numstr;

                }

                runo = runo + maxnum.ToUpper();

                NumControl item = new NumControl();
                item.NOType = "RUNO";
                item.Value = runo;
                item.NOName = "";
                item.Customer = "HP";

                numControl.SaveMaxNumber(item, addflag, prestr + "{0}");

                uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值

                SqlTransactionManager.Commit();//提交事物,释放行级更新锁

                //INSERT INTO [CartonInfo]([CartonNo],[InfoType],[InfoValue],[Editor],[Cdt],[Udt])
	            //VALUES (@CartonNo, 'RUNo', @RUNo, @Editor, GETDATE(), GETDATE())
                CartonInfoInfo sinfo = new CartonInfoInfo();
                sinfo.cartonNo = product.CartonSN;
                sinfo.infoType = "RUNo";
                sinfo.infoValue = runo;
                sinfo.editor = Editor;
                sinfo.cdt = DateTime.Now;
                sinfo.udt = DateTime.Now;
                cartRep.InsertCartonInfoDefered(CurrentSession.UnitOfWork, sinfo);

                //Product结合Delivery and Carton
                //将页面上[Products in Carton] 中的每一个Product和页面选定的Delivery 已经上文生成的Carton No 进行结合 – Update Product
                //Product.DeliveryNo – Delivery No
                //Product.CartonSN – Carton No

                

                IList<IProduct> productList = (List<IProduct>)CurrentSession.GetValue(Session.SessionKeys.ProdList);
                foreach (var prod in productList)
                {
                    prod.DeliveryNo = delivery.DeliveryNo;
                    prod.CartonSN = product.CartonSN;
                    productRep.Update(prod, CurrentSession.UnitOfWork);
                }

                //6.	Update ProductStatus / Insert ProductLog


            } 

            catch (Exception)
            {
                SqlTransactionManager.Rollback();
                throw;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }

            return base.DoExecute(executionContext);
        }
コード例 #20
0
ファイル: GenerateBoxID.cs プロジェクト: wra222/testgit
        /// <summary>
        /// 產生BOX ID號號相关逻辑
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override System.Workflow.ComponentModel.ActivityExecutionStatus DoExecute(System.Workflow.ComponentModel.ActivityExecutionContext executionContext)
        {
            IProduct product = (IProduct)CurrentSession.GetValue(Session.SessionKeys.Product);
            IProductRepository productRep = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
            IPalletRepository palletRep = RepositoryFactory.GetInstance().GetRepository<IPalletRepository, Pallet>();
            IDeliveryRepository deliveryRep = RepositoryFactory.GetInstance().GetRepository<IDeliveryRepository, Delivery>();
            IModelRepository modelRep = RepositoryFactory.GetInstance().GetRepository<IModelRepository, Model>();
            carton.ICartonSSCCRepository cartRep = RepositoryFactory.GetInstance().GetRepository<carton.ICartonSSCCRepository, IMES.FisObject.PAK.CartonSSCC.CartonSSCC>();

            try
            {

                //仅当Delivery 的Flag 属性为N 的时候,需要Generate Ship to Carton Label Pdf Document:
                //1.	Generate Box Id
                //2.	Generate and Record Data for Ship to Carton Label   
                //3.	Generate Ship to Carton Label Pdf Document
                string boxID = "";
                Delivery curDev = deliveryRep.Find(product.DeliveryNo);
                //curDev.Editor = this.Editor;
                CurrentSession.AddValue(Session.SessionKeys.Delivery, curDev);

                string flagstr = (string)curDev.GetExtendedProperty("Flag");
                if (flagstr == "N")
                {

                    // 1.	解除Carton 结合的旧的Box Id
                    //参考方法:
                    //IF EXISTS (SELECT * FROM CartonInfo (NOLOCK ) WHERE CartonNo=@cn AND InfoType='BoxId')
                    //BEGIN
                    //DELETE CartonInfo WHERE artonNo=@cn AND InfoType='BoxId'
                    //END
                    CartonInfoInfo infoCond = new CartonInfoInfo();
                    infoCond.cartonNo = product.CartonSN;
                    infoCond.infoType = "BoxId";
                    IList<CartonInfoInfo> infoList = cartRep.GetCartonInfoInfo(infoCond);
                    if (infoList.Count > 0)
                    {
                        cartRep.DeleteCartonInfoDefered(CurrentSession.UnitOfWork, infoCond);
                    }

                    //2.	取当前日期/ Pallet UCC
                    //参考方法:
                    //SELECT @dt=GETDATE(),@ucc=''
                    //SELECT @ucc = UCC FROM Pallet (NOLOCK) WHERE PalletNo = @plt
                    string ucc = "";

                    Pallet curPallet = palletRep.Find(product.PalletNo);
                    ucc = curPallet.UCC;
                    int ucclength = ucc.TrimEnd().Length;
                    int index = ucc.TrimEnd().IndexOf(",");

                    //3.	取Delivery 相关属性
                    //参考方法:
                    //SELECT @po = RTRIM(PoNo), @model = Model FROM Delivery NOLOCK WHERE DeliveryNo = @dn
                    //SELECT @Flag = InfoValue FROM DeliveryInfo NOLOCK WHERE DeliveryNo = @dn AND InfoType = 'Flag'
                    //SELECT @BoxId_Tag = InfoValue FROM DeliveryInfo NOLOCK WHERE DeliveryNo = @dn AND InfoType = 'BoxId'
                    //SET @BoxId_Tag = LEFT(@BoxId_Tag, 10)
                    //SELECT @Region = InfoValue FROM DeliveryInfo NOLOCK WHERE DeliveryNo = @dn AND InfoType = 'RegId'
                    //SELECT @Deport = InfoValue FROM DeliveryInfo NOLOCK WHERE DeliveryNo = @dn AND InfoType = 'Deport'
                    //SELECT @boxReg = InfoValue FROM DeliveryInfo NOLOCK WHERE DeliveryNo = @dn AND InfoType = 'BoxReg'

                    string po = "";
                    string model = "";
                    //string descr = "";
                    string flag = "";
                    string boxId_Tag = "";
                    string region = "";
                    string deport = "";
                    string boxReg = "";

                    po = curDev.PoNo.TrimEnd();
                    model = curDev.ModelName;
                    flag = (string)curDev.GetExtendedProperty("Flag");
                    boxId_Tag = (string)curDev.GetExtendedProperty("BoxId");
                    if (!string.IsNullOrEmpty(boxId_Tag) && boxId_Tag.Length >= 10)
                    {
                        boxId_Tag = boxId_Tag.Substring(0, 10);
                    }
                    else
                    {
                        boxId_Tag = "";
                    }
                    region = (string)curDev.GetExtendedProperty("RegId");
                    deport = (string)curDev.GetExtendedProperty("Deport");
                    boxReg = (string)curDev.GetExtendedProperty("BoxReg");


                    //4.	如果@boxReg<>'',则按照如下规则产生Box Id,并将产生的Box Id 存到变量@BoxId 中
                    if (!string.IsNullOrEmpty(boxReg))
                    {
                        //New Format of Box Id
                        //RRRR-SSSSS 
                        //Remark:
                        //RRRR – @boxReg
                        //- – 固定字符’-‘
                        //SSSSS – 流水号,31进制,基字符'0123456789BCDFGHJKLMNPQRSTVWXYZ';起始值为R0000;最大值为VZZZZ

                        string maxnum = "";
                        string prestr = "";

                        boxID = boxReg + "-";
                        prestr = boxID;
                        // 自己管理事务开始
                        SqlTransactionManager.Begin();
                        IUnitOfWork uof = new UnitOfWork();//使用自己的UnitOfWork

                        //ITC-1414-0065
                        //从NumControl中获取流水号
                        //GetMaxNumber
                        INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                        bool addflag = false;

                        maxnum = numControl.GetMaxNumber("BOXID", prestr + "{0}");
                        if (string.IsNullOrEmpty(maxnum))
                        {
                            maxnum = "R0000";
                            addflag = true;
                        }
                        else
                        {
                            MathSequenceWithCarryNumberRule marc = new MathSequenceWithCarryNumberRule(5, "0123456789BCDFGHJKLMNPQRSTVWXYZ");

                            //maxnum="CNU248000Y";                   
                            string numstr = maxnum.Substring(maxnum.Length - 5);
                            if (numstr.ToUpper() == "VZZZZ")
                            {
                                FisException fe = new FisException("CHK867", new string[] { });   //流水号已满!
                                throw fe;
                            }
                            numstr = marc.IncreaseToNumber(numstr, 1);
                            maxnum = numstr;

                        }

                        boxID = boxID + maxnum.ToUpper();

                        NumControl item = new NumControl();
                        item.NOType = "BOXID";
                        item.Value = boxID;
                        item.NOName = "";
                        item.Customer = "HP";

                        numControl.SaveMaxNumber(item, addflag, prestr + "{0}");

                        uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值

                        SqlTransactionManager.Commit();//提交事物,释放行级更新锁

                    }
                    else
                    {
                        //5.	如果@boxReg='',则按照如下规则产生Box Id,并将产生的Box Id 存到变量@BoxId 中
                        //a)	当满足(LEN(RTRIM(@ucc))<>20 or (LEN(RTRIM(@ucc))=20 AND CHARINDEX(',',RTRIM(@ucc))>0)) AND RTRIM(@BoxId_Tag) ='' AND @Flag='N'条件时,按照如下规则产生Box Id

                        if ((ucclength != 20) || (ucclength == 20 && index >= 0 && string.IsNullOrEmpty(boxId_Tag.TrimEnd()) && flag == "N"))
                        {
                            string alarm = "";
                            switch (region)
                            {
                                case "SNA":
                                    alarm = "H410-Y";
                                    break;
                                case "SNL":
                                    alarm = "LA" + deport + "Y";
                                    break;
                                case "SNU":
                                    alarm = "D7" + deport + "Y";
                                    break;
                                case "SNE":
                                    alarm = "63D7-QY";
                                    break;
                                case "SAF":
                                    alarm = "H4FN-0C";
                                    break;
                            }
                            //SET ROWCOUNT 1
                            //SELECT @BoxId=RTRIM(BoxId) FROM SnoCtrl_BoxId WHERE Cust=@alarm AND valid=@editor
                            //IF @BoxId is not null
                            //DELETE FROM SnoCtrl_BoxId WHERE BoxId=@BoxId
                            //SET ROWCOUNT 0
                            //如果@BoxId IS NULL or @BoxId='',则报告错误:'BoxId已用完.'+@alarm
                            SnoCtrlBoxIdInfo snoConf = new SnoCtrlBoxIdInfo();
                            SnoCtrlBoxIdInfo snoSet = new SnoCtrlBoxIdInfo();
                            snoConf.cust = alarm;
                            snoConf.valid = "1";
                            IList<string> boxList = deliveryRep.GetBoxIdListFromSnoCtrlBoxId(snoConf);

                            snoSet.valid = Editor;
                            //deliveryRep.UpdateSnoCtrlBoxIdInfoDefered(CurrentSession.UnitOfWork, snoSet, snoConf);

                            if (boxList != null && boxList.Count > 0 && !string.IsNullOrEmpty(boxList[0]))
                            {
                                SnoCtrlBoxIdInfo dsnoConf = new SnoCtrlBoxIdInfo();
                                boxID = boxList[0].TrimEnd();
                                dsnoConf.boxId = boxID;
                                deliveryRep.DeleteSnoCtrlBoxIdInfoDefered(CurrentSession.UnitOfWork, dsnoConf);
                            }
                            else
                            {
                                List<string> erpara = new List<string>();
                                erpara.Add(alarm);
                                FisException fe = new FisException("PAK135", erpara);   //BoxId已用完.'+@alarm
                                throw fe;
                            }

                        }

                    }
                    //6.	如果LEN(RTRIM(@ucc))=20 AND CHARINDEX(',',@ucc)=0,则UCC 保存到CartonInfo 中;
                    //否则,将Box Id 保存到CartonInfo

                    //Record UCC
                    //IF EXISTS(SELECT * FROM CartonInfo NOLOCK WHERE CartonNo = @cn AND InfoType = 'UCC')
                    //UPDATE CartonInfo SET InfoValue = @ucc, Editor = @editor, Udt = GETDATE()
                    //WHERE CartonNo = @cn AND InfoType = 'UCC'
                    //ELSE
                    //INSERT INTO CartonInfo([CartonNo],[InfoType],[InfoValue],[Editor],[Cdt],[Udt])
                    //VALUES(@cn, 'UCC', @ucc, @editor, GETDATE(), GETDATE())
                    //Record Box Id
                    //IF EXISTS(SELECT * FROM CartonInfo NOLOCK WHERE CartonNo = @cn AND InfoType = 'BoxId')
                    //UPDATE CartonInfo SET InfoValue = @BoxId, Editor = @editor, Udt = GETDATE()
                    //WHERE CartonNo = @cn AND InfoType = 'BoxId'
                    //ELSE
                    //INSERT INTO CartonInfo([CartonNo],[InfoType],[InfoValue],[Editor],[Cdt],[Udt])
                    //VALUES(@cn, 'BoxId', @BoxId, @editor, GETDATE(), GETDATE())
                    string namestr = "";
                    string valuestr = "";
                    if ((ucclength == 20) && (index < 0))
                    {
                        namestr = "UCC";
                        valuestr = ucc;
                    }
                    else
                    {
                        namestr = "BoxId";
                        valuestr = boxID;
                    }

                    infoCond.infoType = namestr;
                    infoList = cartRep.GetCartonInfoInfo(infoCond);

                    CartonInfoInfo setCarton = new CartonInfoInfo();
                    setCarton.infoValue = valuestr;
                    setCarton.editor = Editor;
                    setCarton.udt = DateTime.Now;

                    if (infoList.Count > 0)
                    {
                        cartRep.UpdateCartonInfoDefered(CurrentSession.UnitOfWork, setCarton, infoCond);
                    }
                    else
                    {
                        setCarton.cartonNo = product.CartonSN;
                        setCarton.infoType = namestr;
                        setCarton.infoValue = valuestr;
                        cartRep.InsertCartonInfoDefered(CurrentSession.UnitOfWork, setCarton);
                    }
                }

                //Generate and Record Data for Ship to Carton Label 
                //调用HP_EDI.dbo.op_PackingData_20111031 @BoxId,@dn,@plt,@cn,@cdtEDI实现
                //Parameters:@BoxId – Box Id @dn – Delivery No @plt – Pallet No @cn – Carton No @cdtEDI - GETDATE()
                if (flagstr == "N")
                {
                    palletRep.CallOp_PackingDataDefered(CurrentSession.UnitOfWork, boxID, product.DeliveryNo, product.PalletNo, product.CartonSN, DateTime.Now);
                }
                
            }
            catch (Exception)
            {
                SqlTransactionManager.Rollback();
                throw;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }

            return base.DoExecute(executionContext);
        }
コード例 #21
0
ファイル: AcquireMAC.cs プロジェクト: wra222/testgit
        private string GetMAC(string cust)
        {
            try
            {
                SqlTransactionManager.Begin();
                lock (_syncRoot_GetSeq)
                {
                    INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                    MACRange currentRange = numCtrlRepository.GetMACRange(cust, new string[] { "R", "A" });
                    if (currentRange == null)
                    {
                        throw new FisException("ICT014", new string[] { });
                    }
                    else
                    {
                        NumControl currentMaxNum = numCtrlRepository.GetMaxValue("MAC", cust);
                        if (currentMaxNum == null)
                        {
                            currentMaxNum = new NumControl();
                            currentMaxNum.NOName = cust;
                            currentMaxNum.NOType = "MAC";
                            currentMaxNum.Value = currentRange.BegNo;
                            currentMaxNum.Customer = "";

                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.InsertNumControlDefered(uof, currentMaxNum);
                            if (currentMaxNum.Value == currentRange.EndNo)
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                            }
                            else
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Active);
                            }
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return currentMaxNum.Value;

                        }
                        else
                        {
                            if (currentMaxNum.Value == currentRange.EndNo)
                            {
                                numCtrlRepository.SetMACRangeStatus(currentRange.ID, MACRange.MACRangeStatus.Closed);
                                currentRange = numCtrlRepository.GetMACRange(cust, new string[] { "R" });
                                if (currentMaxNum.Value == currentRange.BegNo || currentMaxNum.Value == currentRange.EndNo)
                                {
                                    throw new FisException("ICT018", new string[] { currentMaxNum.Value });
                                }
                            }

                            string change34MaxNum = Change34(currentMaxNum.Value);
                            string change34BeginNo = Change34(currentRange.BegNo);
                            string change34EndNo = Change34(currentRange.EndNo);
                            if (string.Compare(change34MaxNum, change34BeginNo) < 0 || string.Compare(change34MaxNum, change34EndNo) > 0)
                            {
                                currentMaxNum.Value = currentRange.BegNo;
                            }
                            else
                            {
                                ISequenceConverter seqCvt = new SequenceConverterNormal("0123456789ABCDEF", 4, "FFFF", "0000", '0');
                                string sequenceNumber = currentMaxNum.Value.Substring(currentMaxNum.Value.Length - 4, 4);
                                string change34Sequence = sequenceNumber.Substring(1, 3).Insert(1, sequenceNumber.Substring(0, 1));
                                change34Sequence = seqCvt.NumberRule.IncreaseToNumber(change34Sequence, 1);
                                sequenceNumber = change34Sequence.Substring(1, 3).Insert(1, change34Sequence.Substring(0, 1));

                                currentMaxNum.Value = currentMaxNum.Value.Substring(0, currentMaxNum.Value.Length - 4) + sequenceNumber;
                            }


                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.Update(currentMaxNum, uof);
                            if (currentMaxNum.Value == currentRange.EndNo)
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                            }
                            else
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Active);
                            }
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return currentMaxNum.Value;
                        }
                    }
                }
            }
            catch (Exception e)
            {
                SqlTransactionManager.Rollback();
                throw e;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }


        }
コード例 #22
0
ファイル: GenerateAST.cs プロジェクト: wra222/testgit
        /// <summary>
        /// 产生Asset SN 
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override ActivityExecutionStatus DoExecute(ActivityExecutionContext executionContext) 
        {
            var currenProduct = (IProduct)CurrentSession.GetValue(Session.SessionKeys.Product);
            string customerSN = (string)CurrentSession.GetValue(Session.SessionKeys.CustSN);

            string custNum = "";
            string cust = currenProduct.ModelObj.GetAttribute("Cust");
            //if(string.IsNullOrEmpty(cust)){
            //    return base.DoExecute(executionContext);
            //}

            IPartRepository ipartRepository = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>();
            IList<AssetRangeInfo> assetSNRange = ipartRepository.GetAssetRangesByCode(cust);

            if (assetSNRange.Count == 0)
            {
                List<string> errpara = new List<string>();

                errpara.Add(customerSN);

                throw new FisException("CHK200", errpara);
            }

            AssetRangeInfo assetRange = null;
            foreach (AssetRangeInfo tempAssetRange in assetSNRange)
            {
                assetRange = tempAssetRange;
            }

            try         //2012-7-19
            {
                SqlTransactionManager.Begin();  //2012-7-19
                lock (_syncRoot_GetSeq)         //2012-7-19
                {
                    INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                    //ITC-1360-0495, Jessica Liu, 2012-2-22
                    //string largestCustNum = numCtrlRepository.GetMaxNumber("AST", cust + "{0}");
                    string largestCustNum = numCtrlRepository.GetMaxAssetNumber("AST", cust, "HP");

                    if (string.IsNullOrEmpty(largestCustNum))
                    {
                        custNum = assetRange.begin;

                        NumControl item = new NumControl(0, "AST", assetRange.code, custNum, "HP");
                        
                        //numCtrlRepository.SaveMaxNumber(item, true, string.Empty);
                        numCtrlRepository.SaveMaxAssetNumber(item, true);

                        //2012-7-19
                        SqlTransactionManager.Commit();
                    }
                    else
                    {
                        string numInLargestCustNum = "";
                        string numInEnd = "";
                        string preString = "";
                        string preEndString = "";
                        bool bHasNumber = false;

                        string s = largestCustNum;
                        int s_idx = 0;
                        bool bFoundDigit = false;
                        for (int i = 0; i < s.Length; i++)
                        {
                            if (s[i] < '0' || s[i] > '9')
                            {
                                bFoundDigit = false;
                            }
                            else if (bFoundDigit == false)
                            {
                                bFoundDigit = true;
                                s_idx = i;
                            }
                        }

                        if (bFoundDigit == true)
                        {
                            numInLargestCustNum = s.Substring(s_idx);
                            preString = s.Substring(0, s_idx);   
                            bHasNumber = true;
                        }

                        string t = assetRange.end;
                        int t_idx = 0;
                        bool bFoundDigit2 = false;
                        for (int i = 0; i < t.Length; i++)
                        {
                            if (t[i] < '0' || t[i] > '9')
                            {
                                bFoundDigit2 = false;
                            }
                            else if (bFoundDigit2 == false)
                            {
                                bFoundDigit2 = true;
                                t_idx = i;
                            }
                        }

                        if ((bFoundDigit2 == true) && (bHasNumber == true))
                        {
                            numInEnd = t.Substring(t_idx);
                            preEndString = t.Substring(0, t_idx);
                        }
                        else
                        {
                            bHasNumber = false;
                        }

                        if (bHasNumber == true)
                        {
                            if (preString == preEndString)
                            {
                                long largestNum = long.Parse(numInLargestCustNum);
                                long end = long.Parse(numInEnd);

                                if (largestNum >= end)
                                {
                                    List<string> errpara = new List<string>();

                                    errpara.Add(customerSN);

                                    throw new FisException("CHK201", errpara);
                                }
                                else
                                {
                                    largestNum++;
                                    //custNum = preString + largestNum.ToString();
                                    int largestNumCount = numInLargestCustNum.Length;
                                    string strNewLargestCustNum = largestNum.ToString();
                                    int newlargestNumCount = strNewLargestCustNum.Length;
                                    string strPreZero = "";
                                    if (numInLargestCustNum.Substring(0, 1) == "0")
                                    {
                                        for (int i = 0; i < (largestNumCount - newlargestNumCount); i++)
                                        {
                                            strPreZero += "0";
                                        }

                                        strNewLargestCustNum = strPreZero + strNewLargestCustNum;
                                    }
                                    custNum = preString + strNewLargestCustNum;

                                    NumControl item = new NumControl(0, "AST", assetRange.code, custNum, "HP");
                                    //numCtrlRepository.SaveMaxNumber(item, false, string.Empty);
                                    numCtrlRepository.SaveMaxAssetNumber(item, false);

                                    //2012-7-19
                                    SqlTransactionManager.Commit();
                                }
                            }
                            else
                            {
                                List<string> errpara = new List<string>();

                                errpara.Add(customerSN);

                                throw new FisException("CHK201", errpara);
                            }                        
                        }
                        else
                        {
                            List<string> errpara = new List<string>();

                            errpara.Add(customerSN);

                            throw new FisException("CHK201", errpara);
                        }                    
                    }
                }
            }
            catch (Exception e)     //2012-7-19
            {
                SqlTransactionManager.Rollback();
                throw e;
            }
            finally                 //2012-7-19
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }
            /*
            else
            {
                long largestNum = long.Parse(largestCustNum);
                long end = long.Parse(assetRange.end);

                if (largestNum == end)
                {
                    List<string> errpara = new List<string>();

                    errpara.Add(customerSN);

                    throw new FisException("CHK201", errpara);
                }

                largestNum++;
                custNum = largestNum.ToString();

                NumControl item = new NumControl(0, "AST", assetRange.code, custNum, "HP");
                //numCtrlRepository.SaveMaxNumber(item, false, string.Empty);
                numCtrlRepository.SaveMaxAssetNumber(item, false);
            } 
            */

            /* 2012-7-14, Jessica Liu, for mantis
            if (cust == "SCUSTA-1")
            {
                custNum = "000" + custNum.Trim() + "00";
            }
            else if (cust == "CUSTW-1")
            {
                custNum = custNum.Trim() + " HQ P47";
            }
            else if (cust == "CUSTW-2")
            {
                custNum = custNum.Trim() + " HQ P49";
            }
            */
            if (cust == "SCUSTA-1")
            {
                custNum = "000" + custNum.Trim() + "00";
            }
            ConstValueInfo info = new ConstValueInfo();
            info.type = "AST";
            info.name = cust;
            IPartRepository partRepository = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>();
            IList<ConstValueInfo> retList = partRepository.GetConstValueInfoList(info);
            if (retList != null && retList.Count != 0)
            {
                if (string.IsNullOrEmpty(retList[0].value) == false)
                {
                    custNum += retList[0].value;
                }
            }

            CurrentSession.AddValue("AssetSN", custNum);

            return base.DoExecute(executionContext);
        }
コード例 #23
0
ファイル: GenerateCartonNo.cs プロジェクト: wra222/testgit
        /// <summary>
        /// 產生Carton NO號相关逻辑
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override System.Workflow.ComponentModel.ActivityExecutionStatus DoExecute(System.Workflow.ComponentModel.ActivityExecutionContext executionContext)
        { 
            IProduct product = (IProduct)CurrentSession.GetValue(Session.SessionKeys.Product);
            IProductRepository productRep = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();

            //Format of Carton No
            //CYMDDSSSS
            //Remark:
            //T – 前缀,固定字符’C’
            //Y – Year Code,西元年的最后一位
            //M – Month Code,1~9 表示1~9 月,A~C 表示10~12 月
            //DD – Day Code,两位,00~31
            //SSSS – 流水号,10进制,起始值为0001
            try
            {
        
                string CartonNO = "";
                string maxnum = "";
                string prestr = "";
                //求当前日期是一年的中第几周
                //int weeks = 0;
                DateTime curDate = DateTime.Now;
                /*var ret = IMES.Infrastructure.Utility.Generates.WeekRuleEngine.Calculate("103", dateTime);
                string weekCode = ret.Week.ToString().PadLeft(2, '0');
                string year = ret.Year.ToString();
                string month = ret.*/
                string year = curDate.Year.ToString();
                //string month = Convert.ToString(curDate.Month,16);
                string month = curDate.Month.ToString("X");//2012/10/05
                string dd = curDate.Day.ToString("d2");

                CartonNO = "C" + year.Substring(year.Length - 1, 1) + month + dd;
                prestr = CartonNO;
                // 自己管理事务开始
                SqlTransactionManager.Begin();
                IUnitOfWork uof = new UnitOfWork();//使用自己的UnitOfWork

                //从NumControl中获取流水号
                //GetMaxNumber
                INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                bool addflag = false;

                //maxnum = numControl.GetMaxNumber("CARTONNO", prestr + "{0}");
                var maxObj = numControl.GetMaxValue("CARTONNO", prestr);
                //檢查有沒有lock index, 沒有lock index, 改變查詢條件
                if (maxObj == null)
                {
                    //lock NoType='CARTONNO'
                    //string maxData = numControl.GetMaxNumber("CARTONNO", "{0}");
                    //maxObj = numControl.GetMaxNumberObj("CARTONNO", prestr + "{0}");
                    var data = numControl.GetMaxValue("CARTONNO", "Lock");
                    maxObj = numControl.GetMaxValue("CARTONNO", prestr);
                }

                if (maxObj != null)
                {
                    maxnum = maxObj.Value;
                } 

                if (string.IsNullOrEmpty(maxnum))
                {
                    maxnum = "0001";//"8000";
                    addflag = true;
                }
                else
                {
                    //maxnum="CNU248000Y";                   
                    string numstr = maxnum.Substring(maxnum.Length - 4);
                    if (numstr.ToUpper() == "9999")
                    {
                        FisException fe = new FisException("CHK867", new string[] { });   //流水号已满!
                        throw fe;
                    }
                    //ITC-1414-0069
                    int result = Convert.ToInt32(numstr)+1;
                    maxnum = result.ToString("d4");
                }

                CartonNO = CartonNO + maxnum.ToUpper();

               
                NumControl item = null;// new NumControl();
                if (addflag)
                {
                    item = new NumControl();
                    item.NOType = "CARTONNO";
                    item.Value = CartonNO;
                    item.NOName = prestr;
                    item.Customer = this.Customer;
                }
                else
                {
                    item = maxObj;
                    item.Value = CartonNO;
                }

                //numControl.SaveMaxNumber(item, addflag, prestr + "{0}");
                numControl.SaveMaxNumber(item, addflag);

                uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值

                SqlTransactionManager.Commit();//提交事物,释放行级更新锁

                product.CartonSN = CartonNO;

                //a.	Insert CartonStatus
                //INSERT INTO [CartonStatus]([CartonNo],[Station],[Status],[Line],[Editor],[Cdt],[Udt])
	            //VALUES(@CartonNo, @Station, 1, @PdLine, @Editor, GETDATE(), GETDATE())
                carton.ICartonSSCCRepository cartRep = RepositoryFactory.GetInstance().GetRepository<carton.ICartonSSCCRepository, IMES.FisObject.PAK.CartonSSCC.CartonSSCC>();
                CartonStatusInfo sinfo = new CartonStatusInfo();
                sinfo.cartonNo = product.CartonSN;
                sinfo.station = Station;
                sinfo.status = 1;//pass
                sinfo.line = Line;
                sinfo.editor = Editor;
                sinfo.cdt = DateTime.Now;
                sinfo.udt = DateTime.Now;
                cartRep.AddCartonStatusInfoDefered(CurrentSession.UnitOfWork,sinfo);
                
                //b.	Insert CartonLog
                //INSERT INTO [CartonLog]([CartonNo],[Station],[Status],[Line],[Editor],[Cdt])
            	//VALUES(@CartonNo, @Station, 1, @PdLine, @Editor, GETDATE())
                CartonLogInfo linfo = new CartonLogInfo();
                linfo.cartonNo = product.CartonSN;
                linfo.station = Station;
                linfo.status = 1;//pass
                linfo.line = Line;
                linfo.editor = Editor;
                linfo.cdt = DateTime.Now;
                cartRep.AddCartonLogInfoDefered(CurrentSession.UnitOfWork,linfo);
                
            }
            catch (Exception)
            {
                SqlTransactionManager.Rollback();
                throw;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }
            
            return base.DoExecute(executionContext);
        }
コード例 #24
0
ファイル: GenerateATSN7.cs プロジェクト: wra222/testgit
        /// <summary>
        /// Generate ATSN7 label
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override ActivityExecutionStatus DoExecute(ActivityExecutionContext executionContext)
        {
            var productRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();
            var partRepository = RepositoryFactory.GetInstance().GetRepository<IPartRepository, IPart>();
            Product curProduct = (Product)CurrentSession.GetValue(Session.SessionKeys.Product);
            IList<string> pnList = CurrentSession.GetValue("PnListOfATSN7") as IList<string>;
            bool bCDSI = (bool)CurrentSession.GetValue("bCDSI");

            if (bCDSI == true)
            {
                string AST1 = "";
                CdsiastInfo cdi = new CdsiastInfo();
                cdi.tp = "ASSET_TAG";
                cdi.snoId = curProduct.ProId;
                IList<CdsiastInfo> cdsiastInfoList = productRepository.GetCdsiastInfoList(cdi);
                if (cdsiastInfoList != null && cdsiastInfoList.Count > 0)
                {
                    AST1 = cdsiastInfoList[0].sno;
                }

                string AST2 = "";
                CdsiastInfo cdi2 = new CdsiastInfo();
                cdi2.tp = "ASSET_TAG2";
                cdi2.snoId = curProduct.ProId;
                IList<CdsiastInfo> cdsiastInfoList2 = productRepository.GetCdsiastInfoList(cdi2);
                if (cdsiastInfoList2 != null && cdsiastInfoList2.Count > 0)
                {
                    AST2 = cdsiastInfoList2[0].sno;
                }

                if ((AST1 == "") && (AST2 == ""))
                {
                    List<string> errpara = new List<string>();
                    throw new FisException("CHK203", errpara);
                }
                else
                {
                    //不为空则存入
                    //保存product和Asset SN的绑定关系
                    foreach (string tmp in pnList)
                    {
                        if (AST1 != "")
                        {
                            IProductPart assetTag1 = new ProductPart();
                            assetTag1.ProductID = curProduct.ProId;
                            assetTag1.PartID = tmp;
                            assetTag1.PartType = "ATSN7";
                            assetTag1.Iecpn = "";
                            assetTag1.CustomerPn = "";
                            assetTag1.PartSn = AST1;
                            assetTag1.Station = Station;
                            assetTag1.Editor = Editor;
                            assetTag1.Cdt = DateTime.Now;
                            assetTag1.Udt = DateTime.Now;
                            assetTag1.BomNodeType = "AT";

                            curProduct.AddPart(assetTag1);
                            productRepository.Update(curProduct, CurrentSession.UnitOfWork);
                        }

                        if (AST2 != "")
                        {
                            IProductPart assetTag2 = new ProductPart();
                            assetTag2.ProductID = curProduct.ProId;
                            assetTag2.PartID = tmp;
                            assetTag2.PartType = "ATSN7";
                            assetTag2.Iecpn = "";
                            assetTag2.CustomerPn = "";
                            assetTag2.PartSn = AST2;
                            assetTag2.Station = Station;
                            assetTag2.Editor = Editor;
                            assetTag2.Cdt = DateTime.Now;
                            assetTag2.Udt = DateTime.Now;
                            assetTag2.BomNodeType = "AT";

                            curProduct.AddPart(assetTag2);
                            productRepository.Update(curProduct, CurrentSession.UnitOfWork);
                        }
                    }
                }
            }
            else    //Not CDSI
            {
                string custNum = "";

                string cust = curProduct.ModelObj.GetAttribute("Cust");
                IList<AssetRangeInfo> assetRangeList = partRepository.GetAssetRangesByCode(cust);
                if (assetRangeList.Count == 0)  //No AssetRange found
                {
                    List<string> errpara = new List<string>();
                    throw new FisException("CHK200", errpara);
                }
                AssetRangeInfo assetRange = assetRangeList[0];

                if (assetRange.begin.Length != assetRange.end.Length)   //Length of Begin and End mismatch
                {
                    List<string> errpara = new List<string>();
                    throw new FisException("CHK201", errpara);
                }
                
                try
                {
                    SqlTransactionManager.Begin();
                    lock (_syncRoot_GetSeq)
                    {
                        INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                        string largestCustNum = numCtrlRepository.GetMaxAssetNumber("AST", cust, "HP");

                        if (string.IsNullOrEmpty(largestCustNum))
                        {
                            custNum = assetRange.begin;
                            //Save current custNum to numControl
                            NumControl item = new NumControl(0, "AST", assetRange.code, custNum, "HP");
                            numCtrlRepository.SaveMaxAssetNumber(item, true);
                            SqlTransactionManager.Commit();
                        }
                        else
                        {
                            if (largestCustNum.Length != assetRange.begin.Length)   //Length of largestCustNum and assetRange.begin mismatch
                            {
                                List<string> errpara = new List<string>();
                                throw new FisException("CHK201", errpara);
                            }

                            string prePartCur = "";
                            string numPartCur = "";
                            ParseAst(largestCustNum, out prePartCur, out numPartCur);
                            if (numPartCur == "")
                            {
                                List<string> errpara = new List<string>();
                                throw new FisException("CHK201", errpara);
                            }

                            string prePartMax = "";
                            string numPartMax = "";
                            ParseAst(assetRange.end, out prePartMax, out numPartMax);
                            if (numPartMax == "")
                            {
                                List<string> errpara = new List<string>();
                                throw new FisException("CHK201", errpara);
                            }

                            if (prePartCur != prePartMax)   //Prefix of largestCustNum and assetRange.end mismatch
                            {
                                List<string> errpara = new List<string>();
                                throw new FisException("CHK201", errpara);
                            }

                            long numCur = long.Parse(numPartCur);
                            long numMax = long.Parse(numPartMax);
                            if (numCur >= numMax)
                            {
                                List<string> errpara = new List<string>();
                                throw new FisException("CHK201", errpara);
                            }

                            numCur++;

                            custNum = prePartCur;
                            int fillZeroCount = numPartCur.Length - numCur.ToString().Length;
                            for (int i = 0; i < fillZeroCount; i++)
                            {
                                custNum += "0";
                            }
                            custNum += numCur.ToString();

                            //Save current custNum to numControl
                            NumControl item = new NumControl(0, "AST", assetRange.code, custNum, "HP");
                            numCtrlRepository.SaveMaxAssetNumber(item, false);
                            SqlTransactionManager.Commit();
                        }
                    }
                }
                catch (Exception e)
                {
                    SqlTransactionManager.Rollback();
                    throw e;
                }
                finally
                {
                    SqlTransactionManager.Dispose();
                    SqlTransactionManager.End();
                }

                //Update custNum
                if (cust == "SCUSTA-1")
                {
                    custNum = "000" + custNum.Trim() + "00";
                }
                /*
                else if (cust == "CUSTW-1")
                {
                    custNum = custNum.Trim() + " HQ P47";
                }
                else if (cust == "CUSTW-2")
                {
                    custNum = custNum.Trim() + " HQ P49";
                }
                 */

                ConstValueInfo cond = new ConstValueInfo();
                cond.type = "AST";
                cond.name = cust;
                IList<ConstValueInfo> valList = partRepository.GetConstValueInfoList(cond);
                if (valList.Count > 0 && !String.IsNullOrEmpty(valList[0].value))
                {
                    custNum += valList[0].value.Trim();
                }

                //保存product和Asset SN的绑定关系
                foreach (string tmp in pnList)
                {
                    IProductPart assetTag = new ProductPart();
                    assetTag.ProductID = curProduct.ProId;
                    assetTag.PartID = tmp;
                    assetTag.PartType = "ATSN7";
                    assetTag.Iecpn = "";
                    assetTag.CustomerPn = "";
                    assetTag.PartSn = custNum;
                    assetTag.Station = Station;
                    assetTag.Editor = Editor;
                    assetTag.Cdt = DateTime.Now;
                    assetTag.Udt = DateTime.Now;
                    assetTag.BomNodeType = "AT";

                    curProduct.AddPart(assetTag);
                    productRepository.Update(curProduct, CurrentSession.UnitOfWork);
                }
            }

            return base.DoExecute(executionContext);
        }
コード例 #25
0
ファイル: GenerateBoxID.cs プロジェクト: wra222/testgit
        private string getUCCIDList()
        {
            try
            {
                SqlTransactionManager.Begin();
                lock (_syncRoot_GetSeq)
                {
                    IList<string> ret = new List<string>();
                    INumControlRepository numControlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                    long curMax = 0;
                    bool bInsert = false;
                    string curMaxStr = numControlRepository.GetMaxUCCIDNumber("UCCID");
                    if (curMaxStr == null || curMaxStr == "")
                    {
                        bInsert = true;
                        curMax = 2000000;
                    }
                    else
                    {
                        curMax = long.Parse(curMaxStr);
                    }
                 
                   
                    string s = "000008869889" + curMax.ToString("0000000");
                    int dig20 = 0;
                    int sum = 0;
                    for (int j = 0; j < 19; j++)
                    {
                        /*
                         * Answer to: ITC-1360-1155
                         * Description: Wrong processing while getting dig20.
                         */
                        if (j % 2 == 0) sum += (s[j] - '0') * 3;
                        else sum += s[j] - '0';
                    }
                    /*
                     * Answer to: ITC-1360-1153
                     * Description: Wrong processing while getting dig20.
                     */
                    dig20 = (10 - (sum % 10)) % 10;
                    s += dig20.ToString();                  
                    curMax++;
                    if (curMax == 6000000)
                    {
                        curMax = 2000000;
                    }                    

                    NumControl nc = new NumControl(-1, "UCCID", "", curMax.ToString(), "HP");
                    numControlRepository.SaveMaxNumber(nc, bInsert, "{0}");
                    SqlTransactionManager.Commit();

                    return s;
                }
            }
            catch (Exception e)
            {
                SqlTransactionManager.Rollback();
                throw e;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }
        }
コード例 #26
0
ファイル: GenCartonSN.cs プロジェクト: wra222/testgit
        /// <summary>
        /// 
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override ActivityExecutionStatus DoExecute(ActivityExecutionContext executionContext)
        {
            IProduct product = (IProduct)CurrentSession.GetValue(Session.SessionKeys.Product);
            IProductRepository productRep = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();

            //Format of Carton No
            //TYMDDSSSS
            //Remark:
            //T – 前缀,線別第一碼
            //Y – Year Code,西元年的最后一位
            //M – Month Code,1~9 表示1~9 月,A~C 表示10~12 月
            //DD – Day Code,两位,00~31
            //SSSS – 流水号,10进制,起始值为0001
            try
            {

                string CartonNO = "";
                string maxnum = "";
                string prestr = "";
                //求当前日期是一年的中第几周
                //int weeks = 0;
                DateTime curDate = DateTime.Now;
                /*var ret = IMES.Infrastructure.Utility.Generates.WeekRuleEngine.Calculate("103", dateTime);
                string weekCode = ret.Week.ToString().PadLeft(2, '0');
                string year = ret.Year.ToString();
                string month = ret.*/
                string year = curDate.Year.ToString();
                //string month = Convert.ToString(curDate.Month,16);
                string month = curDate.Month.ToString("X");//2012/10/05
                string dd = curDate.Day.ToString("d2");

                CartonNO = this.Line.Substring(0,1)+ year.Substring(year.Length - 1, 1) + month + dd;
                prestr = CartonNO;
                // 自己管理事务开始
                SqlTransactionManager.Begin();
                IUnitOfWork uof = new UnitOfWork();//使用自己的UnitOfWork

                //从NumControl中获取流水号
                //GetMaxNumber
                INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                bool addflag = false;
                //var maxObj = numControl.GetMaxNumberObj("CARTONNO", prestr + "{0}");
                var maxObj = numControl.GetMaxValue("CARTONNO", prestr);
               
                //檢查有沒有lock index, 沒有lock index, 改變查詢條件
                if (maxObj == null)
                {
                    //lock NoType='CARTONNO'
                    //string maxData = numControl.GetMaxNumber("CARTONNO", "{0}");
                    //maxObj = numControl.GetMaxNumberObj("CARTONNO", prestr + "{0}");
                    var data = numControl.GetMaxValue("CARTONNO", "Lock");
                    maxObj = numControl.GetMaxValue("CARTONNO", prestr);
                }

                if (maxObj != null)
                {
                    maxnum = maxObj.Value;
                } 
              
                //maxnum = numControl.GetMaxNumber("CARTONNO", prestr + "{0}");
                if (string.IsNullOrEmpty(maxnum))
                {
                    maxnum = "0001";//"8000";
                    addflag = true;
                }
                else
                {
                    //maxnum="CNU248000Y";                   
                    string numstr = maxnum.Substring(maxnum.Length - 4);
                    if (numstr.ToUpper() == "9999")
                    {
                        FisException fe = new FisException("CHK867", new string[] { });   //流水号已满!
                        throw fe;
                    }
                    //ITC-1414-0069
                    int result = Convert.ToInt32(numstr) + 1;
                    maxnum = result.ToString("d4");
                }

                CartonNO = CartonNO + maxnum.ToUpper();
                NumControl item = null;// new NumControl();
                if (addflag)
                {
                    item = new NumControl();
                    item.NOType = "CARTONNO";
                    item.Value = CartonNO;
                    item.NOName = prestr; //"";
                    item.Customer = "HP";
                }
                else
                {
                    item = maxObj;
                    item.Value = CartonNO;
                }

                //NumControl item = new NumControl();
                //item.NOType = "CARTONNO";
                //item.Value = CartonNO;
                //item.NOName = "";
                //item.Customer = "HP";

                //numControl.SaveMaxNumber(item, addflag, prestr + "{0}");

                numControl.SaveMaxNumber(item, addflag);
                
                //Create Carton object
                Carton carton = new Carton(CartonNO, CurrentSession.Station, 1, CurrentSession.Line, CurrentSession.Editor);
                ICartonRepository cartonRep = RepositoryFactory.GetInstance().GetRepository<ICartonRepository, Carton>();
                cartonRep.Add(carton, uof);

                uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值

                SqlTransactionManager.Commit();//提交事物,释放行级更新锁

                CurrentSession.AddValue(ExtendSession.SessionKeys.CartonSN, CartonNO);

                
                CurrentSession.AddValue(Session.SessionKeys.Carton, carton);              

            }
            catch (Exception)
            {
                SqlTransactionManager.Rollback();
                throw;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }
            return base.DoExecute(executionContext);
          
        }
コード例 #27
0
        /// <summary>
        /// 產生CustomerSN號相关逻辑
        /// </summary>
        /// <param name="executionContext"></param>
        /// <returns></returns>
        protected internal override System.Workflow.ComponentModel.ActivityExecutionStatus DoExecute(System.Workflow.ComponentModel.ActivityExecutionContext executionContext)
        { 
            IProduct product = (IProduct)CurrentSession.GetValue(Session.SessionKeys.Product);
            IProductRepository productRep = RepositoryFactory.GetInstance().GetRepository<IProductRepository, IProduct>();

            //lock (_syncRoot_GetSeq)//用于防止同一段代码被同时执行,以前只有一个Service时有效,现在多个Service没有去掉,聊胜于无

            //var logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
            //logger.InfoFormat("GenerateCustomerSnActivity: CurrentSession Hash: {0}; CurrentSession Key: {1}; CurrentSession Type: {2}", CurrentSession.GetHashCode().ToString(), CurrentSession.Key, CurrentSession.Type.ToString());
            //logger.InfoFormat("GenerateCustomerSnActivity: IProduct Hash: {0}; IProduct Key: {1}", product.GetHashCode().ToString(), product.Key);

            //need modify
            try
            {
                //CN(中try国代码)+U(Site Code)+年尾码+周别码+流水码
                string custSn = "";
                DateTime curDate = DateTime.Now;
               // string year = curDate.Year.ToString();
                string maxnum = "";
                string prestr = "";
                //求当前日期是一年的中第几周
                //int weeks = 0;
                DateTime dateTime = DateTime.Now;//new DateTime(2016,1,1);
                var ret = IMES.Infrastructure.Utility.Generates.WeekRuleEngine.Calculate("103", dateTime);
                string weekCode = ret.Week.ToString().PadLeft(2, '0');
                string year = ret.Year.ToString();//dateTime.Year.ToString();

                custSn = "CN" + "U" + custSn + year.Substring(year.Length - 1, 1) + weekCode;//weeks.ToString("d2");
                prestr = custSn;
                // 自己管理事务开始
                SqlTransactionManager.Begin();
                IUnitOfWork uof = new UnitOfWork();//使用自己的UnitOfWork


                //从NumControl中获取流水号
                //GetMaxNumber
                INumControlRepository numControl = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                bool addflag = false;
                maxnum = numControl.GetMaxNumber("CPQSNO", prestr + "{0}");
                if (string.IsNullOrEmpty(maxnum))
                {
                    maxnum = "Z000";    //起始值:Z000
                    addflag = true;
                }
                else
                {
                    //maxnum="CNU248000Y";
                    string temstr = "Z000"; //起始值:Z000
                    string numstr = maxnum.Substring(maxnum.Length - 4);
                    temstr = numstr;

                    if (numstr.ToUpper() == "YZZZ")
                    {
                        FisException fe = new FisException("CHK867", new string[] { });   //流水号已满!
                        throw fe;
                    }

                    string[] seqLst = new string[4];
                    seqLst[0] = temstr.Substring(0, 1);
                    seqLst[1] = temstr.Substring(1, 1);
                    seqLst[2] = temstr.Substring(2, 1);
                    seqLst[3] = temstr.Substring(3, 1);
                    
                    int[] idexLst = getSeqNum(seqLst);

                    if (idexLst[3] == 30)
                    {
                        if (idexLst[2] == 30)
                        {
                            if (idexLst[1] == 30)
                            {
                                if (idexLst[0] == 29)
                                {
                                    List<string> errpara = new List<string>();
                                    throw new FisException("CHK867", errpara);  //流水号已满!
                                }
                                else
                                {
                                    if (idexLst[0] == 30)
                                    {
                                        idexLst[0] = 28;
                                    }
                                    else if (idexLst[0] == 28)
                                    {
                                        idexLst[0] = 27;
                                    }
                                    else if (idexLst[0] == 27)
                                    {
                                        idexLst[0] = 29;
                                    }
                                    else
                                    {
                                        List<string> errpara = new List<string>();
                                        throw new FisException("CHK867", errpara);  //非合法的Z、X、W、Y,视为满
                                    }

                                    idexLst[1] = 0;
                                    idexLst[2] = 0;
                                    idexLst[3] = 0;
                                }
                            }
                            else
                            {
                                idexLst[1] += 1;
                                idexLst[2] = 0;
                                idexLst[3] = 0;
                            }
                        }
                        else
                        {
                            idexLst[2] += 1;
                            idexLst[3] = 0;
                        }
                    }
                    else
                    {
                        idexLst[3] += 1;
                    }

                    temstr = numLst[idexLst[0]] + numLst[idexLst[1]] + numLst[idexLst[2]] + numLst[idexLst[3]];
                    maxnum = temstr;
                }

                custSn = custSn + maxnum.ToUpper();

                product.CUSTSN = custSn;
                productRep.Update(product, uof);

                NumControl item = new NumControl();
                item.NOType = "CPQSNO";
                item.Value = custSn;
                item.NOName = "";
                item.Customer = "HP";

                numControl.SaveMaxNumber(item, addflag, prestr + "{0}");
                 
                uof.Commit();  //立即提交UnitOfWork更新NumControl里面的最大值

                SqlTransactionManager.Commit();//提交事物,释放行级更新锁
                
                // [Customer SN Print]保存结果:增加更新[CustomerSN_Qty]. CustomerSN_Qty栏位
                //UPDATE [HPIMES].[dbo].[MO]
                //SET [CustomerSN_Qty] =[ CustomerSN_Qty]+1
                //From Product a,MO b  WHERE a.MO=b.MO and a.ProductID=ProductID#

                IMORepository moRepository = RepositoryFactory.GetInstance().GetRepository<IMORepository, MO>();
                moRepository.UpdateMoForIncreaseCustomerSnQty(product.ProId, 1);

            }
            catch (Exception)
            {
                SqlTransactionManager.Rollback();
                throw;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }

            CurrentSession.AddValue(Session.SessionKeys.PrintLogName, product.Customer + "SNO");
            CurrentSession.AddValue(Session.SessionKeys.PrintLogBegNo, product.ProId);
            CurrentSession.AddValue(Session.SessionKeys.PrintLogEndNo, product.ProId);
            CurrentSession.AddValue(Session.SessionKeys.PrintLogDescr, product.CUSTSN);
            
            return base.DoExecute(executionContext);
        }
コード例 #28
0
ファイル: RCTOChangeMulti.cs プロジェクト: wra222/testgit
        private List<string> GetMaxMBSn(string prefix,int qty)
        {
            List<string> result = new List<string>();
            try
            {
                SqlTransactionManager.Begin();
                lock (_syncRoot_GetSeq)
                {
                    INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                    string currentMaxNum = numCtrlRepository.GetMaxNumber("MBSno", prefix + "{0}");
                    if (string.IsNullOrEmpty(currentMaxNum))
                    {
                        ISequenceConverter seqCvt = new SequenceConverterNormal("0123456789ABCDEFGHJKLMNPRSTVWXYZ", 4, "ZZZZ", beginNO, '0');
                        for (int i = 0; i < qty;i++ ) {
                            result.Add(prefix + "R" + seqCvt.NumberRule.IncreaseToNumber(beginNO, i));
                        }
                        NumControl currentNumControl = new NumControl();
                        currentNumControl.NOName = "";
                        currentNumControl.NOType = "MBSno";
                        currentNumControl.Customer = Customer;

                        currentNumControl.Value = result[qty-1];
                        
                        numCtrlRepository.InsertNumControl(currentNumControl);
                        SqlTransactionManager.Commit();
                        return result;
                    }
                    else
                    {
                        if (currentMaxNum.EndsWith("ZZZZ"))
                        {
                            throw new FisException("CHK162", new string[] { });
                        }
                        else
                        {
                            ISequenceConverter seqCvt = new SequenceConverterNormal("0123456789ABCDEFGHJKLMNPRSTVWXYZ", 4, "ZZZZ", beginNO, '0');
                            string sequenceNumber = currentMaxNum.Substring(currentMaxNum.Length - 4, 4);

                            for (int i = 1; i <= qty; i++)
                            {
                                result.Add(prefix + "R" + seqCvt.NumberRule.IncreaseToNumber(sequenceNumber, i));
                                if (result[i-1].EndsWith("ZZZZ"))
                                {
                                    throw new FisException("CHK162", new string[] { });
                                }
                            }


                            IList<NumControl> numCtrlLst = numCtrlRepository.GetNumControlByNoTypeAndValue("MBSno", currentMaxNum);
                            NumControl currentNumControl = numCtrlLst[0];

                            currentNumControl.Value = result[qty - 1];
                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.Update(currentNumControl, uof);
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return result;
                        }
                    }
                }
            }
            catch (Exception e)
            {
                SqlTransactionManager.Rollback();
                throw e;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }
        }
コード例 #29
0
ファイル: AcquireIMEI.cs プロジェクト: wra222/testgit
        private IList<string> getIMEISeq(string model, string preFixCode, string custom, int qty)
        {
            string numType = "IMEI";
            try
            {
                IList<string> ret = new List<string>();
                if (qty == 1)
                {
                    ret.Add(getIMEISeq(model, preFixCode, custom));
                    return ret;
                }

                SqlTransactionManager.Begin();
                lock (_syncRoot_GetSeq)
                {
                    INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();

                    MACRange currentRange = numCtrlRepository.GetMACRange(preFixCode, new string[] { "R", "A" });
                    if (currentRange == null)
                    {
                        throw new FisException("ICT014", new string[] { });
                    }
                    else
                    {
                        if (!validateIMEISettingRange(currentRange.BegNo, currentRange.EndNo))
                        {
                            throw new FisException("CHK1086", new string[] { currentRange.BegNo + "~" + currentRange.EndNo });
                        }
                        NumControl currentMaxNum = numCtrlRepository.GetMaxValue(numType, preFixCode);
                        if (currentMaxNum == null)
                        {
                            currentMaxNum = new NumControl();
                            currentMaxNum.NOName = preFixCode;
                            currentMaxNum.NOType = numType;
                            currentMaxNum.Value = currentRange.BegNo;
                            currentMaxNum.Customer = custom;
                            ret.Add(currentMaxNum.Value);
                            qty--;

                            IUnitOfWork uof = new UnitOfWork();
                            if (qty >0 && currentMaxNum.Value == currentRange.EndNo) //check Last Range
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                                currentRange = numCtrlRepository.GetMACRange(preFixCode, new string[] { "R", "A" });
                                if (currentRange == null)
                                {
                                    throw new FisException("ICT014", new string[] { });
                                }
                            }                         

                            int remainingCount = qty;
                           
                            for (int j = 0; j < qty; j++)
                            {
                                remainingCount--;
                                int curNum = int.Parse(currentMaxNum.Value) + 1;
                                currentMaxNum.Value = curNum.ToString("D12");
                                if (remainingCount >0  && currentMaxNum.Value == currentRange.EndNo) //check Last Range
                                {
                                    numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                                    currentRange = numCtrlRepository.GetMACRange(preFixCode, new string[] { "R", "A" });
                                    if (currentRange == null)
                                    {
                                        throw new FisException("ICT014", new string[] { });
                                    }

                                    if (!validateIMEISettingRange(currentRange.BegNo, currentRange.EndNo))
                                    {
                                        throw new FisException("CHK1086", new string[] { currentRange.BegNo + "~" + currentRange.EndNo });
                                    }

                                    if (currentMaxNum.Value == currentRange.BegNo || currentMaxNum.Value == currentRange.EndNo)
                                    {
                                        throw new FisException("ICT018", new string[] { currentMaxNum.Value });
                                    }
                                }
                                ret.Add(currentMaxNum.Value);
                            }

                            if (int.Parse(currentMaxNum.Value) > int.Parse(currentRange.EndNo))
                            {
                                throw new FisException("GEN022", new string[] { currentMaxNum.Value + ">" + currentRange.EndNo });
                            }

                            if (currentMaxNum.Value == currentRange.EndNo)
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                            }
                            else
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Active);
                            }
                            numCtrlRepository.InsertNumControlDefered(uof, currentMaxNum);
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return ret;

                        }
                        else
                        {
                            if (currentMaxNum.Value == currentRange.EndNo)
                            {
                                numCtrlRepository.SetMACRangeStatus(currentRange.ID, MACRange.MACRangeStatus.Closed);
                                currentRange = numCtrlRepository.GetMACRange(preFixCode, new string[] { "R","A" });
                                if (currentRange == null)
                                {
                                    throw new FisException("ICT014", new string[] { });
                                }

                                if (!validateIMEISettingRange(currentRange.BegNo, currentRange.EndNo))
                                {
                                    throw new FisException("CHK1086", new string[] { currentRange.BegNo + "~" + currentRange.EndNo });
                                }

                                if (currentMaxNum.Value == currentRange.BegNo || currentMaxNum.Value == currentRange.EndNo)
                                {
                                    throw new FisException("ICT018", new string[] { currentMaxNum.Value });
                                }
                            }

                            IUnitOfWork uof = new UnitOfWork();

                            int remainingCount = qty;
                            for (int j = 0; j < qty; j++)
                            {
                                remainingCount--;
                                int curNextNum = int.Parse(currentMaxNum.Value) + 1;
                                currentMaxNum.Value = curNextNum.ToString("D12");
                                ret.Add(currentMaxNum.Value);
                                if (remainingCount > 0 && currentMaxNum.Value == currentRange.EndNo) //check Last Range
                                {
                                    numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                                    currentRange = numCtrlRepository.GetMACRange(preFixCode, new string[] { "R", "A" });
                                    if (currentRange == null)
                                    {
                                        throw new FisException("ICT014", new string[] { });
                                    }

                                    if (!validateIMEISettingRange(currentRange.BegNo, currentRange.EndNo))
                                    {
                                        throw new FisException("CHK1086", new string[] { currentRange.BegNo + "~" + currentRange.EndNo });
                                    }

                                    if (currentMaxNum.Value == currentRange.BegNo || currentMaxNum.Value == currentRange.EndNo)
                                    {
                                        throw new FisException("ICT018", new string[] { currentMaxNum.Value });
                                    }
                                }                               
                            }

                            if (int.Parse(currentMaxNum.Value) > int.Parse(currentRange.EndNo))
                            {
                                throw new FisException("GEN022", new string[] { currentMaxNum.Value + ">" + currentRange.EndNo });
                            }

                          
                            numCtrlRepository.Update(currentMaxNum, uof);
                            if (currentMaxNum.Value == currentRange.EndNo)
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                            }
                            else
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Active);
                            }
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return ret;
                        }
                    }
                }
            }
            catch (Exception e)
            {
                SqlTransactionManager.Rollback();
                throw e;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }


        }
コード例 #30
0
ファイル: AcquireEEPList.cs プロジェクト: wra222/testgit
        private string GetEEP()
        {
            try
            {
                SqlTransactionManager.Begin();
                lock (_syncRoot_GetSeq)
                {
                    INumControlRepository numCtrlRepository = RepositoryFactory.GetInstance().GetRepository<INumControlRepository, NumControl>();
                    string mbFamily = CurrentSession.GetValue(Session.SessionKeys.FamilyName) as string;
                    MACRange currentRange = numCtrlRepository.GetMACRange(mbFamily, new string[] { "R", "A" });
                    if (currentRange == null)
                    {
                        throw new FisException("ICT015", new string[] { });
                    }
                    else
                    {

                        NumControl currentMaxNum = numCtrlRepository.GetMaxValue("EEPROM", mbFamily);
                        if (currentMaxNum == null)
                        {
                            currentMaxNum = new NumControl();
                            currentMaxNum.NOName = mbFamily;
                            currentMaxNum.NOType = "EEPROM";
                            currentMaxNum.Value = currentRange.BegNo.Substring(0, 11) + "1";
                            currentMaxNum.Customer = "";

                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.InsertNumControlDefered(uof, currentMaxNum);
                            if (currentMaxNum.Value.Substring(0, 11) == currentRange.EndNo.Substring(0, 11))
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                            }
                            else
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Active);
                            }
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return currentMaxNum.Value;
                        }
                        else
                        {
                            if (currentMaxNum.Value.Substring(0, 11) == currentRange.EndNo.Substring(0, 11))
                            {
                                numCtrlRepository.SetMACRangeStatus(currentRange.ID, MACRange.MACRangeStatus.Closed);
                                currentRange = numCtrlRepository.GetMACRange(mbFamily, new string[] { "R" });
                                if (currentMaxNum.Value.Substring(0, 11) == currentRange.BegNo.Substring(0, 11) || currentMaxNum.Value.Substring(0, 11) == currentRange.EndNo.Substring(0, 11))
                                {
                                    throw new FisException("ICT017", new string[] { currentMaxNum.Value.Substring(0, 11) });
                                }
                            }


                            if (string.Compare(currentMaxNum.Value.Substring(0, 11), currentRange.BegNo.Substring(0, 11)) < 0 || string.Compare(currentMaxNum.Value.Substring(0, 11), currentRange.EndNo.Substring(0, 11)) > 0)
                            {
                                currentMaxNum.Value = currentRange.BegNo.Substring(0, 11) + "1";
                            }
                            else
                            {
                                ISequenceConverter seqCvt = new SequenceConverterNormal("0123456789", 7, "9999999", "0000000", '0');
                                string sequenceNumber = currentMaxNum.Value.Substring(4, 7);
                                sequenceNumber = seqCvt.NumberRule.IncreaseToNumber(sequenceNumber, 1);
                                currentMaxNum.Value = currentMaxNum.Value.Substring(0, 4) + sequenceNumber + "1";
                            }

                            IUnitOfWork uof = new UnitOfWork();
                            numCtrlRepository.Update(currentMaxNum, uof);
                            if (currentMaxNum.Value.Substring(0, 11) == currentRange.EndNo.Substring(0, 11))
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Closed);
                            }
                            else
                            {
                                numCtrlRepository.SetMACRangeStatusDefered(uof, currentRange.ID, MACRange.MACRangeStatus.Active);
                            }
                            uof.Commit();
                            SqlTransactionManager.Commit();
                            return currentMaxNum.Value;
                        }
                    }
                }
            }
            catch (Exception e)
            {
                SqlTransactionManager.Rollback();
                throw e;
            }
            finally
            {
                SqlTransactionManager.Dispose();
                SqlTransactionManager.End();
            }
        }