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; }