🚀 go-pugleaf

jeszcze inne wywolanie:

        private void button1_Click(object sender, EventArgs e)
        {
            var csb = new SqlConnectionStringBuilder();
            csb.IntegratedSecurity = true;
            csb.DataSource = "BAZA2005";
            using (var con = new SqlConnection(csb.ConnectionString))
            {
                con.Open();
                var cmd = new SqlCommand("SELECT 2 iIle, 2.55 dNorma,
120.57 dCena, 0.2 dWsp, '_.iIle * _.dNorma * _.dCena * (1 + _.dWsp) *
100' sFormula", con);
                using (var reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        dynamic param = new DynamicDataRow(reader);
                        //dynamic param = new ExpandoObject();
                        //param.iIle = 2;
                        //param.dNorma = 2.55M;
                        //param.dCena = 120.57M;
                        //param.dWsp = 0.2M;
                        try
                        {
                            //
MessageBox.Show(ScriptingInterface.ScriptProvider.RunScript(textBox1.Text,
param).ToString());
 
MessageBox.Show(ScriptingInterface.ScriptProvider.RunScript(param.sFormula,
param).ToString());
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                    }
                }
            }
        }

a tak np zamieniamy sobie IDataRecord na dynamic

    public class DynamicDataRow : DynamicObject
    {
        Dictionary<string, object> record_ = new Dictionary<string,
object>();
        public DynamicDataRow(IDataRecord record)
        {
            for (int i = 0; i < record.FieldCount; i++)
                record_[record.GetName(i)] = record[i];
        }
        public override bool TryGetMember(GetMemberBinder binder, out
object result)
        {
            return record_.TryGetValue(binder.Name, out result);
        }
        public override bool TrySetMember(SetMemberBinder binder,
object value)
        {
            record_[binder.Name] = value;
            return true;
        }
    }



mozna jeszcze dodac cachowanie skryptu

        static Dictionary<string, IScriptType> scriptcache = new
Dictionary<string, IScriptType>();

        public static dynamic RunScript(string code, dynamic param)
        {
            if (!scriptcache.ContainsKey(code))
                scriptcache[code] = new
ScriptingInterface.ScriptProvider(code).Script;
            return scriptcache[code].RunScript(param);
        }