ToolGood.Algorithm

快速上手

    AlgorithmEngine engine = new AlgorithmEngine();

    // 编译并执行公式
    var fn = engine.Parse("1+2");
    var o = engine.Evaluate(fn);
    double a = o.DoubleValue; // Return: 3 返回:3

    var b = engine.TryEvaluate("1=1 && 1<2 || 7-8>1", 0);// Support(支持) && || 
    var c = engine.TryEvaluate("2+3", 0);
    var q = engine.TryEvaluate("-7 < -2 ?1 : 2", 0);
    var e = engine.TryEvaluate("count(array(1, 2, 3, 4))", 0);//{} represents array, return: 4 {}代表数组, 返回:4
    var s = engine.TryEvaluate("'aa'&'bb'", ""); //String connection, return: aabb 字符串连接, 返回:aabb
    var r = engine.TryEvaluate("(1=1)*9+2", 0); //Return: 11 返回:11
    var d = engine.TryEvaluate("'2016-1-1'+1", DateTime.MinValue); //Return date: 2016-1-2 返回日期:2016-1-2
    var j = engine.TryEvaluate("json('{\"Name\":\"William Shakespeare\", \"Age\":51, \"Birthday\":\"04/26/1564 00:00:00\"}').Age", null);//Return 51 返回51
    var k = engine.TryEvaluate("json('{\"Name\":\"William Shakespeare   \", \"Age\":51, \"Birthday\":\"04/26/1564 00:00:00\"}')['Name'].Trim()", null);//Return "William Shakespeare"  返回"William Shakespeare" (不带空格)
    var l = engine.TryEvaluate("json('{\"Name1\":\"William Shakespeare \", \"Age\":51, \"Birthday\":\"04/26/1564 00:00:00\"}')['Name'& 1].Trim().substring(2, 3)", null);//Return "ill"  返回"ill"
    var n = engine.TryEvaluate("{Name:\"William Shakespeare\", Age:51, Birthday:\"04/26/1564 00:00:00\"}.Age", null);//Return 51 返回51
    var m = engine.TryEvaluate("[1,2,3,4,5,6].has(13)", true);//Return false 返回false

自定义参数

    //Define cylinder information  定义圆柱信息 
    public class Cylinder : AlgorithmEngine
    {
        private int _radius;
        private int _height;
        public Cylinder(int radius, int height)
        {
            _radius = radius;
            _height = height;
        }

        protected override Operand GetParameter(string parameter)
        {
            if (parameter == "半径")
            {
                return Operand.Create(_radius);
            }
            if (parameter == "直径")
            {
                return Operand.Create(_radius * 2);
            }
            if (parameter == "高")
            {
                return Operand.Create(_height);
            }
            return base.GetParameter(parameter);
        }
    }
    //Call method  调用方法
    Cylinder c = new Cylinder(3, 10);
    c.TryEvaluate("半径*半径*pi()", 0.0);      //Round bottom area  圆底面积
    c.TryEvaluate("直径*pi()", 0.0);            //The length of the circle  圆的周长
    c.TryEvaluate("半径*半径*pi()*高", 0.0); //Volume of circle 圆的体积
    c.TryEvaluate("'圆-'&半径&'-'&高", ""); // Return: 圆-3-10

辅助方法

    // DiyNameInfo 位于 ToolGood.Algorithm.Internals 命名空间
    DiyNameInfo p5 = AlgorithmEngineHelper.GetDiyNames("ddd(d1, 22)");
    Assert.AreEqual("ddd", p5.Functions[0].Name);
    Assert.AreEqual("d1", p5.Parameters[0].Name);

支持单位

    AlgorithmEngine engine = new AlgorithmEngine();
    bool a = engine.TryEvaluate("1=1m", false); // return true
    bool b = engine.TryEvaluate("1=1m2", false); // return true
    bool c = engine.TryEvaluate("1=1m3", false); // return true
    bool d = engine.TryEvaluate("1=1kg", false); // return true

    // 单位转化
    var num = AlgorithmEngineHelper.UnitConversion(1M,"米","千米"); 

    // 不抛错例子
    bool error = engine.TryEvaluate("1m=1m2", false); // return true

计算逻辑引擎

using ToolGood.Algorithm.CalculationLogic;

var logic = new CalculationLogicEngine(new FunctionCache(), useCalculationLogicInfo: true);

logic.SetSceneName("折扣计算");                      // 设置场景名称
logic.InitValue("price", 100M);                     // 初始化值
logic.InitValue("count", 3M);

if (logic.CheckCondition("count>=3", 1)) {          // 检查条件（支持层级）
    logic.SetFormula("total", "price*count*0.8", 0, "满3件打8折");   // 用公式赋值
} else {
    logic.SetFormula("total", "price*count", 0); 
}

Console.WriteLine(logic.ToInfoString());
// 输出：
// [初始] price=100;count=3;
// ===== 折扣计算 =====
// [成功]    if count>=3: // 3>=3
// [赋值] total = price*count*0.8 = 100*3*0.8 = 240 // 满3件打8折

Excel公式

逻辑函数

数学与三角函数

文本函数

日期与时间函数

扩展函数

财务函数

统计函数

增加函数 类C#方法