/// <summary> /// db에 파일정보를 저장한다. /// </summary> /// <param name="strConn"></param> /// <param name="strUpdateType"></param> /// <param name="strFileName"></param> public static void FileInfo_Save(Function.Db.OracleDB.strConnect strConn, enUType UType, string strUpdateType, System.IO.FileInfo fi, string strCRC, string strText, Function.Db.OracleDB.delExcuteProcedure_Progress evtP) { Function.Db.OracleDB clsDB = new Function.Db.OracleDB(strConn.strTNS, strConn.strID, strConn.strPass); OracleParameter[] param = new OracleParameter[] { new OracleParameter("ps_UpdateType", OracleDbType.Varchar2, 20), //0 new OracleParameter("ps_UType", OracleDbType.Varchar2, 20), //1 new OracleParameter("ps_FileName", OracleDbType.Varchar2, 100), //2 new OracleParameter("ps_FileName2", OracleDbType.Varchar2, 100), //3 new OracleParameter("ps_Version", OracleDbType.Varchar2, 20), //4 new OracleParameter("ps_FileDate", OracleDbType.Date, 8), //5 new OracleParameter("ps_FileImage", OracleDbType.Blob, Convert.ToInt32(fi.Length)), //6 new OracleParameter("ps_Text", OracleDbType.Varchar2, 400), //7 new OracleParameter("ps_CRC", OracleDbType.Varchar2, 100), //8 new OracleParameter("ps_FileSize", OracleDbType.Int32, 8) }; //9 param[0].Value = strUpdateType; param[1].Value = UType.ToString(); param[2].Value = fi.Name.ToUpper(); param[3].Value = fi.Name; param[4].Value = system.clsFile.FileGetVersion(fi.FullName); param[5].Value = fi.LastWriteTime; param[7].Value = Function.Db.OracleDB.Fnc.StringEmpty2DbNull(strText); param[8].Value = strCRC; param[9].Value = fi.Length; clsDB.Excute_StoredProcedure("AutoUpdater_PKG.FileInfo_Set", param, 6, fi, evtP); }
/// <summary> /// 기존 버젼으로 되돌린다. /// </summary> /// <param name="strConn"></param> /// <param name="strUpdateType"></param> /// <param name="UType"></param> /// <param name="strFileName"></param> /// <param name="strOldVersion"></param> /// <returns></returns> public static string FileInfo_Restore_OldVersion(Function.Db.OracleDB.strConnect strConn, string strUpdateType, enUType UType, string strFileName, string strOldVersion) { Function.Db.OracleDB clsDB = new Function.Db.OracleDB(strConn.strTNS, strConn.strID, strConn.strPass); OracleParameter[] param = new OracleParameter[] { new OracleParameter("ps_UpdateType", OracleDbType.Varchar2, 20), new OracleParameter("ps_UType", OracleDbType.Varchar2, 20), new OracleParameter("ps_FileName", OracleDbType.Varchar2, 100), new OracleParameter("ps_OldVersion", OracleDbType.Varchar2, 100), new OracleParameter("ps_Msg", OracleDbType.Varchar2, 400) }; param[4].Direction = ParameterDirection.Output; param[0].Value = strUpdateType; param[1].Value = UType.ToString(); param[2].Value = strFileName; param[3].Value = strOldVersion; clsDB.intExcute_StoredProcedure("AutoUpdater_PKG.FileInfo_Restore_OldVersion", param); return(Fnc.obj2String(param[4].Value)); }
/// <summary> /// 파일 update history 조회 /// </summary> /// <param name="strConn"></param> /// <param name="strUpdateType"></param> /// <param name="strUtype"></param> /// <param name="strFileName"></param> /// <returns></returns> public static DataSet FileInfo_Get_History(Function.Db.OracleDB.strConnect strConn, string strUpdateType, enUType UType, string strFileName) { Function.Db.OracleDB clsDB = new Function.Db.OracleDB(strConn.strTNS, strConn.strID, strConn.strPass); OracleParameter[] param = new OracleParameter[] { new OracleParameter("ps_UpdateType", OracleDbType.Varchar2, 20), new OracleParameter("ps_UType", OracleDbType.Varchar2, 20), new OracleParameter("ps_FileName", OracleDbType.Varchar2, 100), new OracleParameter("OUT_CURSOR", OracleDbType.RefCursor) }; param[3].Direction = ParameterDirection.Output; param[0].Value = strUpdateType; param[1].Value = UType.ToString(); param[2].Value = strFileName; return(clsDB.dsExcute_StoredProcedure("AutoUpdater_PKG.FileInfo_GetList_History", param)); }