/// <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>
/// db에 파일정보를 저장한다.
/// </summary>
/// <param name="strConn"></param>
/// <param name="strUpdateType"></param>
/// <param name="strFileName"></param>
public static void FileInfo_Save(Function.Db.OracleDB.strConnect strConn, string strUpdateType, System.IO.FileInfo fi, string strCRC)
{
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_FileName", OracleDbType.Varchar2, 100),
new OracleParameter("ps_VERSION", OracleDbType.Varchar2, 20),
new OracleParameter("ps_FileDATE", OracleDbType.Date, 8),
new OracleParameter("ps_FileImage", OracleDbType.Blob, Convert.ToInt32(fi.Length)),
new OracleParameter("ps_CRC", OracleDbType.Varchar2, 100)
};
param[0].Value = strUpdateType;
param[1].Value = fi.Name.ToUpper();
param[2].Value = system.clsFile.FileGetVersion(fi.FullName);
param[3].Value = fi.LastWriteTime;
param[5].Value = strCRC;
clsDB.Excute_StoredProcedure("AutoUpdater_PKG.FileInfo_Get", param, 4, fi);
}