private void timer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e) { string TimePhase = System.Configuration.ConfigurationSettings.AppSettings["TimePhase"].ToString(); if (DateTime.Now.ToString("HH:mm:ss") == TimePhase) { IConstructInterface construct = new ConstructService();; var result = construct.GetConstruct(); foreach (var model in result) { SmsMessage c = new SmsMessage(); var smsState = c.SendMessages(model.Phone, model.ConstName, model.Phase.Value, model.Role); //SmsMessage c = new SmsMessage(); //var smsState = "0";//c.SendMessages(model.Phone, model.ConstName, model.Phase.Value, model.Role); if (smsState == "0") { Mapper.Initialize(x => x.CreateMap <SMSEvalLogDTO, SMSEvalLog>()); SMSEvalLog sms = Mapper.Map <SMSEvalLogDTO, SMSEvalLog>(model); sms.CreateTime = DateTime.Now; construct.AddSMSLog(sms); } } } }
public int AddSMSLog(SMSEvalLog model) { using (IDbConnection conn = SqlConn.OpenConnectionPS()) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"INSERT INTO SMSEvalLog(ConstId,Phone,ConstName,Phase,Role,CreateTime) VALUES(@ConstId, @Phone, @ConstName, @Phase,@Role, @CreateTime)"); return(conn.Execute(strSql.ToString(), new { ConstId = model.ConstId, Phone = model.Phone, ConstName = model.ConstName, Phase = model.Phase, Role = model.Role, CreateTime = model.CreateTime } )); } }