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