public InstallFileJSON UpdateFile(string staffCode, InstallFile installFile)
{
InstallFileJSON result = new InstallFileJSON();
if (installFile != null)
{
StringBuilder sbSQL = new StringBuilder();
try
{
using (NpgDB npgDB = Connection.DBConnect())
{
sbSQL.AppendLine("INSERT INTO dinstallfile");
sbSQL.AppendLine("(appid, vercd, vernm, filenm, upopr)");
sbSQL.AppendLine("VALUES (");
sbSQL.AppendLine(":p_appid, :p_vercd, :p_vernm, :p_filenm, :p_upopr");
sbSQL.AppendLine(")");
sbSQL.AppendLine("RETURNING appid, vercd, vernm, filenm, upopr");
npgDB.Command = sbSQL.ToString();
npgDB.SetParams(":p_appid", installFile.appId);
npgDB.SetParamsLongString(":p_vercd", installFile.verCd + "");
npgDB.SetParams(":p_vernm", installFile.verNm);
npgDB.SetParams(":p_filenm", installFile.fileNm);
npgDB.SetParams(":p_upopr", staffCode);
using (NpgsqlDataReader rec = npgDB.Query())
{
if (rec.Read())
{
result.fileContent = new InstallFile(rec);
result.success = true;
}
}
}
}
catch (Exception ex) { }
}
return(result);
}
