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