public JsonState UpdateData(int id, DateTime updateStart, DateTime updateEnd)
 {
     JsonState jsonState = new JsonState();
     string formula = "";
     jsonState.state = 0;
     if (id > 0)
     {
         Sql sql = new Sql();
         sql.Select("*").From("tn_FormulaSetting").Where("Id=@0", id);
         FormulaSetting formulaSetting = db.Fetch<FormulaSetting>(sql).FirstOrDefault();
         if (formulaSetting != null)
         {
             formula = formulaSetting.Formula;
             List<string> pipoints = GetPiPoints(formulaSetting.Formula);
             List<FormulaPoint> formulaPoints = new List<FormulaPoint>();
             formulaPoints = db.Fetch<FormulaPoint>("select * from tn_FormulaPoint");
             IDictionary<string, List<PIAvgRecords>> piAvgRecords = new Dictionary<string, List<PIAvgRecords>>();
             foreach (string pipoint in pipoints)
             {
                 string pointName = pipoint.Replace("_MONTHAVG", "").Replace("_MONTH", "");
                 FormulaPoint formulaPoint = formulaPoints.Where(n => n.PointName == pointName).FirstOrDefault();
                 if (formulaPoint != null)
                     sql = new Sql("select * from " + formulaPoint.TableName + " where pname=@0 and timestamps<=@1 and timestamps>=@2", pointName, updateEnd, updateStart);
                 else
                     sql = new Sql("select * from PIAvgRecords where pname=@0 and timestamps<=@1 and timestamps>=@2", pointName, updateEnd, updateStart);
                 piAvgRecords[pipoint] = db.Fetch<PIAvgRecords>(sql);
             }
             Expre(pipoints, piAvgRecords, formulaSetting, updateStart, updateEnd);
             jsonState.state = 1;
         }
     }
     return jsonState;
 }
 public FormulaSetting Post(FormulaSetting editformulaSetting)
 {
     Sql sql = new Sql();
     sql.Select("*").From("tn_FormulaSetting").Where("Id=@0", editformulaSetting.Id);
     FormulaSetting formulaSetting = db.Fetch<FormulaSetting>(sql).FirstOrDefault();
     if (editformulaSetting != null && formulaSetting != null)
     {
         formulaSetting.Formula = editformulaSetting.Formula;
         formulaSetting.Remarks = editformulaSetting.Remarks;
         db.Update("tn_FormulaSetting", "Id", formulaSetting);
     }
     return formulaSetting;
 }