public void InitializePopup()
        {
            this._wsSPC          = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
            this._mlthandler     = MultiLanguageHandler.getInstance();
            this._Initialization = new Initialization();
            this._Initialization.InitializePath();

            this._SpreadUtil = new BSpreadUtility();
            this._ComUtil    = new CommonUtility();

            if (this._sSelectedContextValues != null)
            {
                this.Title = "Set Context Value List";
                _bContext  = true;
            }
            else if (this._sSelectedExcludeValues != null)
            {
                this.Title = "Set Exclude Value List";
                _bContext  = false;
            }

            _dsContextKey = this._wsSPC.GetSPCContextKeyTableAndColumns();

            _arrLstDBContextKeys = new ArrayList();

            for (int i = 0; i < _dsContextKey.Tables[0].Rows.Count; i++)
            {
                this._arrLstDBContextKeys.Add(_dsContextKey.Tables[0].Rows[i]["CONTEXT_KEY"].ToString());
            }

            this.InitializeBTabControl();
        }
Esempio n. 2
0
        public void InitializePopup()
        {
            this._wsSPC          = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
            this._mlthandler     = MultiLanguageHandler.getInstance();
            this._Initialization = new Initialization();
            this._Initialization.InitializePath();

            this._SpreadUtil = new BSpreadUtility();
            this._ComUtil    = new CommonUtility();

            this.InitializeBSpread();
        }
Esempio n. 3
0
        public void InitializePage()
        {
            this._ComUtil        = new CommonUtility();
            this._bSpreadUtil    = new BSpreadUtility();
            this._lang           = MultiLanguageHandler.getInstance();
            this._wsSPC          = new eSPCWebService.eSPCWebService();
            this._Initialization = new Initialization();
            this._Initialization.InitializePath();

            this.InitializeLayout();
            this.InitializeDataButton();
            this.InitializeBSpread();
        }
Esempio n. 4
0
        public void InitializePage()
        {
            this._wsSPC      = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
            this._mlthandler = MultiLanguageHandler.getInstance();

            this._Initialization = new Initialization();
            this._Initialization.InitializePath();

            this._SpreadUtil = new BSpreadUtility();
            this._ComUtil    = new CommonUtility();

            this.InitializeBSpread();
            this._bUseComma = AppConfiguration.GetConfigValue(Definition.PATH_ESPC, Definition.PATH_SPC_MODELING, Definition.CONFIG_USE_COMMA, false);
        }
Esempio n. 5
0
        public DataSet DecompressData(DataTable _dtData, LinkedList _llstCondition, LinkedList _llstContextType, bool bDataParsing, bool includingToggleOffData)
        {
            DataSet       dsRetrun = null;
            string        sRef     = string.Empty;
            CommonUtility _comUtil = new CommonUtility();

            string[] arrData         = null;
            string[] arrContext      = null;
            string   strData_List    = "";
            string   strContext_List = "";

            try
            {
                int idxTemp = 0;

                for (int i = 0; i < _dtData.Columns.Count; i++)
                {
                    if (_dtData.Columns[i].ToString().IndexOf(COLUMN.DATA_LIST) >= 0)
                    {
                        idxTemp++;
                    }
                }

                if (_dtData != null && _dtData.Rows.Count > 0)
                {
                    dsRetrun = new DataSet();

                    foreach (DataRow drData in _dtData.Rows)
                    {
                        strData_List = "";

                        if (idxTemp <= 1)
                        {
                            strData_List    = drData[COLUMN.DATA_LIST].ToString();
                            strContext_List = drData[COLUMN.CONTEXT_LIST].ToString();
                        }
                        else
                        {
                            strData_List    = drData[COLUMN.DATA_LIST].ToString();
                            strContext_List = drData[COLUMN.CONTEXT_LIST].ToString();

                            for (int i = 1; i < idxTemp; i++)
                            {
                                strData_List    += drData[COLUMN.DATA_LIST + i.ToString()].ToString();
                                strContext_List += drData[COLUMN.CONTEXT_LIST + i.ToString()].ToString();
                            }
                        }

                        arrContext = strContext_List.ToString().Split('\t');
                        arrData    = strData_List.ToString().Split('\t');

                        AddColumn(arrContext, _dtData, drData, _llstContextType, bDataParsing);
                        AddColumn(arrData, _dtData, drData, _llstContextType, bDataParsing);
                    }

                    if (!_dtData.Columns.Contains(Definition.CHART_COLUMN.TABLENAME))
                    {
                        _dtData.Columns.Add(Definition.CHART_COLUMN.TABLENAME);
                    }

                    for (int i = 0; i < _dtData.Rows.Count; i++)
                    {
                        _dtData.Rows[i][Definition.CHART_COLUMN.TABLENAME] = Definition.TableName.USERNAME_TEMPDATA_SHORT;
                    }

                    if (!includingToggleOffData)
                    {
                        DeleteToggleOffData(_dtData);
                    }

                    DataRow[] drSelectParams = _dtData.Select(_comUtil.NVL(_llstCondition[Definition.CONDITION_KEY_CONTEXT_KEY_LIST]));
                    dsRetrun.Merge(drSelectParams);
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex);
                LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex);
            }
            finally
            {
                if (_dtData != null)
                {
                    _dtData.Dispose();
                }
            }

            return(dsRetrun);
        }