private static void Query(DapperDbContext db) { var a1 = db.Query <User>(x => x.Name == "张三").Select(x => new { title = x.Name }).ToList(); var a2 = db.Query <User>(x => x.Id > 0).ToList(); var a3 = db.SqlQueryDynamic(" select * from users ", null); var a4 = db.Query <User>(x => x.Id == 12).FirstOrDefault(); var a5 = db.Query <User>(x => x.Id > 1).OrderBy(x => x.Id).ThenByDescending(x => x.Age).ToList(); var total = 0; var a6 = db.Query <User>(x => x.Id > 1).OrderBy(x => x.Id).ThenByDescending(x => x.Age).ToPageList(1, 5, out total); var a7 = db.Query <User>(x => x.Id > 0).GroupBy(x => x.Age).Select(x => x.Id).ToList(); var a8 = db.Query <User>(x => x.Id > 0).Max(x => x.Id); var a9 = db.Query <User>().Where("age=1").FirstOrDefault(); var id = 10; var a10 = db.Query <User>(x => x.Id == id).FirstOrDefault(); var g = true; var a11 = db.Query <User>(x => x.Gender1 && x.Gender1 == g).FirstOrDefault(); }
public void Main() { using (IQuery con = new DapperDbContext(DatabaseConst.SMSGateway)) { keywords = con.Query <QuizModel>("GetKeyword"); } ipStr = ConfigurationManager.AppSettings["SMSGWIPServer"]; portStr = ConfigurationManager.AppSettings["SMSGWPortServer"];; }
public void Main() { using (IQuery con = new DapperDbContext(DatabaseConst.SMSGateway)) { keywords = con.Query<QuizModel>("GetKeyword"); } ipStr = ConfigurationManager.AppSettings["SMSGWIPServer"]; portStr = ConfigurationManager.AppSettings["SMSGWPortServer"];; }
private static void Delete(DapperDbContext db) { var user = db.Query <User>(x => x.Name == "张三").FirstOrDefault(); db.Delete(user); Add(db); db.Delete <User>(x => x.Name == "张三"); Add(db); db.DeleteAll <User>(); Add(db); }
//public void OnDataSent(string data) //{ //} public void OnDataReceived(string data) { List <BaseResult <SMSReadResult> > list = JsonHelper.JsonDeserialize <List <BaseResult <SMSReadResult> > >(data); if (list.Count > 0) { foreach (BaseResult <SMSReadResult> read in list) { if (read.Response.TypeName.Contains("SMSRead")) { if (keywords.Any()) { foreach (QuizModel keyword in keywords) { Match match = new Regex(@"(.*[a-zA-Z]) (.*[a-zA-Z])").Match(keyword.Keyword); if (match.Success) { if (read.Response.Message.ToLower().Contains(match.Groups[1].Value.ToLower())) { string[] arg = read.Response.Message.ToLower().Split(new string[] { match.Groups[1].Value.ToLower() }, StringSplitOptions.RemoveEmptyEntries); using (IQuery con = new DapperDbContext(DatabaseConst.SMSGateway)) { List <Answer> result = con.Query <Answer>(keyword.Response, new { KeyID = arg[0].Trim() }); if (result.Any()) { smsSender = new GSMClient.Client(ipStr, Convert.ToInt32(portStr)); smsSender.Open(); smsSender.Send(string.Format(GSMClient.Command.CommandCollection.SMSSend, read.Response.From, result.SingleOrDefault().Description)); smsSender.Close(); } } break; } } } } } } } }
//public void OnDataSent(string data) //{ //} public void OnDataReceived(string data) { List<BaseResult<SMSReadResult>> list = JsonHelper.JsonDeserialize<List<BaseResult<SMSReadResult>>>(data); if (list.Count > 0) { foreach (BaseResult<SMSReadResult> read in list) { if (read.Response.TypeName.Contains("SMSRead")) { if (keywords.Any()) { foreach (QuizModel keyword in keywords) { Match match = new Regex(@"(.*[a-zA-Z]) (.*[a-zA-Z])").Match(keyword.Keyword); if (match.Success) { if (read.Response.Message.ToLower().Contains(match.Groups[1].Value.ToLower())) { string[] arg = read.Response.Message.ToLower().Split(new string[] { match.Groups[1].Value.ToLower() }, StringSplitOptions.RemoveEmptyEntries); using (IQuery con = new DapperDbContext(DatabaseConst.SMSGateway)) { List<Answer> result = con.Query<Answer>(keyword.Response, new { KeyID = arg[0].Trim() }); if (result.Any()) { smsSender = new GSMClient.Client(ipStr, Convert.ToInt32(portStr)); smsSender.Open(); smsSender.Send(string.Format(GSMClient.Command.CommandCollection.SMSSend, read.Response.From, result.SingleOrDefault().Description)); smsSender.Close(); } } break; } } } } } } } }