C# Code:


/// <summary>
/// SQL测试表达式
/// </summary>
/// <param name="expression"></param>
/// <returns></returns>
public object Calculate(string expression)
{
   try
   {
      string SQL = "SELECT (" + expression + ") AS Result";
      CommandHelper cmd = _Database.CreateCommand(SQL);
      return ConvertEx.ToFloat(_Database.ExecuteScalar(SQL));
   }
   catch
   {
      return DBNull.Value;
   }
}

/// <summary>
/// SQL测试表达式
/// </summary>
/// <param name="expression">表达式</param>
/// <param name="result"></param>
/// <returns></returns>
public bool TestFormula(string expression, out float result)
{
   result = 0;
   try
   {
      string SQL = "SELECT (" + expression + ") AS Result";
      CommandHelper cmd = _Database.CreateCommand(SQL);
      result = ConvertEx.ToFloat(_Database.ExecuteScalar(SQL));
      return true;
   }
   catch
   {
      return false;
   }
}

//来源:C/S框架网(www.csframework.com) QQ:23404761