public void InsertConsultEvaluates(TodaySatisfaction todaySatisfaction) { using (IDbConnection connection = new MySqlConnection(_sqlStr)) { var result = connection.Execute("Insert into TodaySatisfaction(CreateTime,GridId, Rate) values (@CreateTime, @GridId, @Rate)", todaySatisfaction); } }
public void OnTimer(object sender, ElapsedEventArgs args) { // TODO: Insert monitoring activities here. if (DateTime.Now > DateTime.Today && DateTime.Now < DateTime.Today.AddHours(6)) { DapperDll dapperDll = new DapperDll(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString); dapperDll.DeleteTodaySatisfaction(); int count = dapperDll.GetTodaySatisfaction().Count(); if (count > 0) { } else { List <ConsultEvaluate> consultEvaluates = dapperDll.GetConsultEvaluates(); List <Gridding> griddings = dapperDll.GetGrid(); foreach (var item in griddings) { TodaySatisfaction todaySatisfaction = new TodaySatisfaction(); todaySatisfaction.CreateTime = DateTime.Now; int sum = consultEvaluates.Where(t => t.GridId == item.Id).Count(); int Satisfaction = consultEvaluates.Where(t => (t.SatisfactionDegree == 0 || t.SatisfactionDegree == 1) && t.GridId == item.Id).Count(); todaySatisfaction.GridId = item.Id; if (sum == 0) { todaySatisfaction.Rate = 1; } else { todaySatisfaction.Rate = (decimal)Satisfaction / sum; } dapperDll.InsertConsultEvaluates(todaySatisfaction); } } } }