/// <summary> /// 파일조회 /// </summary> public string FileInfo_GetFileData(AutoDownloadEntity pAutoDownloadEntity) { try { using (DBManager pDBManager = new DBManager()) { DataTable pDataTable = new AutoDownloadProvider(pDBManager).FileInfo_GetFileData(pAutoDownloadEntity); byte[] bLob = (byte[])pDataTable.Rows[0]["FILE_DATA"]; using (FileStream fs = new FileStream(pAutoDownloadEntity.FILE_PATH + pAutoDownloadEntity.FILENAME, FileMode.Create, FileAccess.Write, FileShare.ReadWrite)) { fs.Write(bLob, 0, bLob.Length); fs.Flush(); fs.Close(); fs.Dispose(); } } FileInfo fi = new FileInfo(pAutoDownloadEntity.FILE_PATH + pAutoDownloadEntity.FILENAME); return(CoFAS_FileManager.Get_Crc32(fi)); } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "FileInfo_GetFileData(AutoDownloadEntity pAutoDownloadEntity)", pException); } }
private void Initialize() { try { switch (Properties.Settings.Default.DB_TYPE.ToString()) { case "MySql": DBManager.PrimaryDBManagerType = DBManagerType.MySql; break; case "SQLServer": DBManager.PrimaryDBManagerType = DBManagerType.SQLServer; break; default: DBManager.PrimaryDBManagerType = DBManagerType.MySql; break; } DBManager.InitDatabaseServer = Properties.Settings.Default.SERVER_IP.ToString(); DBManager.InitDatabaseName = Properties.Settings.Default.DB_NAME.ToString(); DBManager.InitDatabaseID = Properties.Settings.Default.DB_ID.ToString(); DBManager.InitDatabasePass = "******"; DBManager.PrimaryConnectionString = string.Format ( "Server={0};Database={1};UID={2};PWD={3}", DBManager.InitDatabaseServer, //Properties.Settings.Default.SERVER_IP.ToString(), DBManager.InitDatabaseName, //Properties.Settings.Default.DB_NAME.ToString(), DBManager.InitDatabaseID, //Properties.Settings.Default.DB_ID.ToString(), DBManager.InitDatabasePass //"coever119!#%" ); if (!CoFAS_FileManager.FolderExists(strPathUpdate)) { CoFAS_FileManager.FolderCreate(strPathUpdate); } pAutoDownloadEntity = new AutoDownloadEntity(); pAutoDownloadEntity.CORP_CODE = Properties.Settings.Default.CORP_CODE.ToString(); //clsLog.WLog("업데이트 프로그램을 실행합니다.\tv" + Application.ProductVersion); } catch (Exception pException) { throw new ExceptionManager(this, "Initialize()", pException); } }
/// <summary> /// 파일정보 조회하기 /// </summary> public DataTable FileInfo_GetList(AutoDownloadEntity pAutoDownloadEntity) { try { using (DBManager pDBManager = new DBManager()) { DataTable pDataTable = new AutoDownloadProvider(pDBManager).FileInfo_GetList(pAutoDownloadEntity); return(pDataTable); } } catch (ExceptionManager pExceptionManager) { throw pExceptionManager; } catch (Exception pException) { throw new ExceptionManager(this, "FileInfo_GetList(string pFILE_TYPE)", pException); } }