コード例 #1
0
ファイル: BasketFlow.cs プロジェクト: SoftSuite/ABB
        private bool UpdateProductMaster(string UserID, BasketData bkData)
        {
            bool ret = true;
            ProductMasterDAL oDAL = new ProductMasterDAL();

            oDAL.GetDataByLOID(bkData.PRODUCTMASTER, null);
            oDAL.CODE = bkData.CODE;
            oDAL.NAME = bkData.NAME;
            oDAL.ENAME = bkData.ENAME;
            oDAL.UNIT = bkData.UNITBASKET;
            oDAL.PRODUCTGROUP = bkData.PRODUCTGROUP;
            oDAL.ACTIVE = bkData.ACTIVE;

            ret = oDAL.UpdateCurrentData(UserID, null);
            if (ret == false)
            {
                _error = oDAL.ErrorMessage;
                return ret;
            }
            else
                return ret;
        }
コード例 #2
0
ファイル: ProductBarcodeDAL.cs プロジェクト: SoftSuite/ABB
        public static string GetLotNo(string userID, double productLOID, OracleTransaction zTrans)
        {
            bool LetClose = false;
            string code = "";
            OracleConnection zConn = null;
            if (zTrans == null)
            {
                LetClose = true;
                zConn = OracleDB.GetConnection();
                zTrans = zConn.BeginTransaction(IsolationLevel.ReadCommitted);
            }

            ProductBarcodeDAL _bDAL = new ProductBarcodeDAL();
            if (_bDAL.GetDataByLOID(productLOID, zTrans))
            {
                ProductMasterDAL _dal = new ProductMasterDAL();
                if (_dal.GetDataByLOID(_bDAL.PRODUCTMASTER, zTrans))
                {
                    if (_dal.YEAR == (DateTime.Now.Year + 543).ToString().Substring(2))
                    {
                        if (_dal.RUNNING == "9")
                        {
                            _dal.RUNNING = "1";
                            switch (_dal.LOTNO)
                            {
                                case "A": _dal.LOTNO = "B"; break;
                                case "B": _dal.LOTNO = "C"; break;
                                case "C": _dal.LOTNO = "D"; break;
                                case "D": _dal.LOTNO = "E"; break;
                                case "E": _dal.LOTNO = "F"; break;
                                case "F": _dal.LOTNO = "G"; break;
                                case "G": _dal.LOTNO = "H"; break;
                                case "H": _dal.LOTNO = "I"; break;
                                case "I": _dal.LOTNO = "J"; break;
                                case "J": _dal.LOTNO = "K"; break;
                                case "K": _dal.LOTNO = "L"; break;
                                case "L": _dal.LOTNO = "M"; break;
                                case "M": _dal.LOTNO = "N"; break;
                                case "N": _dal.LOTNO = "O"; break;
                                case "O": _dal.LOTNO = "P"; break;
                                case "P": _dal.LOTNO = "Q"; break;
                                case "Q": _dal.LOTNO = "R"; break;
                                case "R": _dal.LOTNO = "S"; break;
                                case "S": _dal.LOTNO = "T"; break;
                                case "T": _dal.LOTNO = "U"; break;
                                case "U": _dal.LOTNO = "V"; break;
                                case "V": _dal.LOTNO = "W"; break;
                                case "W": _dal.LOTNO = "X"; break;
                                case "X": _dal.LOTNO = "Y"; break;
                                case "Y": _dal.LOTNO = "Z"; break;
                                case "Z": _dal.LOTNO = "A"; break;
                                default: _dal.LOTNO = "A"; break;
                            }
                        }
                        else
                        {
                            _dal.RUNNING = (Convert.ToInt32(_dal.RUNNING == "" ? "0" : _dal.RUNNING) + 1).ToString().Trim();
                        }
                    }
                    else
                    {
                        _dal.LOTNO = "A";
                        _dal.RUNNING = "1";
                        _dal.YEAR = (DateTime.Now.Year + 543).ToString().Substring(2);
                    }

                    if (!_dal.UpdateCurrentData(userID, zTrans))
                    {
                        if (LetClose)
                        {
                            zTrans.Commit();
                            zConn.Close();
                        }
                        throw new ApplicationException(_dal.ErrorMessage);
                    }
                    else
                    {
                        code = (_dal.CODE.Length > 3 ? _dal.CODE.Substring(0, 3) : _dal.CODE) + " " + _dal.LOTNO + _dal.RUNNING + _dal.YEAR;
                    }
                }
            }


            if (LetClose)
            {
                zTrans.Commit();
                zConn.Close();
            }

            return code.ToUpper();
        }