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); }
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; }
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; }
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); }