Esempio n. 1
0
        public int Init(System.Data.DataTable dataTable, TypeCnfFile typeFile)
        {
            int result;

            if (this._isServerTransData)
            {
                result = 0;
            }
            else
            {
                ErrCode  errCode  = ErrCode.ok;
                InitData initData = new InitData(dataTable, typeFile, this._itemsData, out errCode);
                if (errCode != ErrCode.ok)
                {
                    this._errNum = initData.ErrNum;
                    this._errTxt = initData.ErrTxt;
                    result       = (int)errCode;
                }
                else
                {
                    this.ErrCodeParse(ErrCode.ok, "Init");
                    result = 0;
                }
            }
            return(result);
        }
Esempio n. 2
0
        public InitData(string pathFile, TypeCnfFile typeFile, ItemsData items, out ErrCode errInit)
        {
            this._resultData = items;
            this.ClearItems();
            ErrCode errCode;

            switch (typeFile)
            {
            case TypeCnfFile.xlsxTable1:
            case TypeCnfFile.xlsxTable2:
                errCode = this.SelectInitTable(pathFile, typeFile);
                break;

            case TypeCnfFile.txtFile:
                errCode = this.InitFromTxt(pathFile);
                break;

            case TypeCnfFile.xmlFile:
                errCode = this.InitFromXML(pathFile);
                break;

            default:
                errCode = ErrCode.initFileNotFound;
                break;
            }
            if (errCode != ErrCode.ok)
            {
                this.ClearItems();
            }
            errInit = errCode;
        }
Esempio n. 3
0
        public InitData(System.Data.DataTable dataTable, TypeCnfFile typeFile, ItemsData items, out ErrCode errInit)
        {
            this._resultData = items;
            this.ClearItems();
            ErrCode errCode = this.InitFromDataTable(dataTable);

            if (errCode != ErrCode.ok)
            {
                this.ClearItems();
            }
            errInit = errCode;
        }
Esempio n. 4
0
        private ErrCode SelectInitTable(string pathFile, TypeCnfFile typeFile)
        {
            ErrCode errCode = ErrCode.ok;

            System.IO.FileStream fileStream;
            ErrCode result;

            try
            {
                fileStream = System.IO.File.Open(pathFile, System.IO.FileMode.Open, System.IO.FileAccess.Read);
            }
            catch (System.IO.FileNotFoundException var_2_10)
            {
                this.ErrCodeParse(ErrCode.initFileNotFound);
                result = ErrCode.initFileNotFound;
                return(result);
            }
            IExcelDataReader excelDataReader = ExcelReaderFactory.CreateOpenXmlReader(fileStream);

            excelDataReader.IsFirstRowAsColumnNames = true;
            System.Data.DataSet dataSet = excelDataReader.AsDataSet();
            fileStream.Close();
            if (typeFile == TypeCnfFile.xlsxTable1)
            {
                if (dataSet.Tables.Contains("Read"))
                {
                    errCode = this.TableRead(dataSet.Tables["Read"]);
                    if (errCode != ErrCode.ok)
                    {
                        result = errCode;
                        return(result);
                    }
                }
                if (dataSet.Tables.Contains("Write"))
                {
                    errCode = this.TableWrite(dataSet.Tables["Write"]);
                    if (errCode != ErrCode.ok)
                    {
                        result = errCode;
                        return(result);
                    }
                }
            }
            else
            {
                errCode = this.TableOver(dataSet.Tables[0]);
            }
            result = errCode;
            return(result);
        }