public bool UpdateOneValue(string tableName, string column, string value, string where, string additionalMessage = "")
{
try
{
var whereCnd = ConvertionHelper.GetWhere(where);
var sql = string.Format(@"UPDATE {0} SET {1} = '{2}', {3} = '{4}' {5}",
tableName, column, ConvertionHelper.CleanStringForSQL(value), DbCIC.ModifyOn, DateTime.Now.ToString(), whereCnd);
var result = m_Execute.ExecuteNonQuery(sql);
if (result == -2)
{
return(false);
}
return(true);
}
catch (Exception ex)
{
SLLog.WriteError(new LogData
{
Source = ToString(),
FunctionName = "UpdateOneValue Error!",
AdditionalMessage = additionalMessage,
Ex = ex,
});
if (Settings.ThrowExceptions)
{
throw new Exception("UpdateOneValue Error!", ex);
}
return(false);
}
}
