public IEnumerable <WeChatUserRecord> Query(string openId, string keywords)
{
var user = new WeChatUser {
OpenId = openId
};
user.InsertIfNotExist();
var context = new AliSqlContext();
return(context.WeChatUserRecords.Where(rec => rec.OpenId == openId && rec.Category == user.Category && rec.Content.Contains(keywords)));
}
public IEnumerable <WeChatUserRecord> Query(string openId, int skip, int take)
{
var user = new WeChatUser {
OpenId = openId
};
user.InsertIfNotExist();
var context = new AliSqlContext();
return(context.WeChatUserRecords.Where(rec => rec.OpenId == openId && rec.Category == user.Category)
.Skip(skip)
.Take(take));
}
public void Push()
{
WeChatUser user = new WeChatUser()
{
OpenId = this.OpenId,
Category = "Todo"
};
user.InsertIfNotExist();
this.Category = user.Category;
this.CreateDate = DateTime.Now;
var context = new AliSqlContext();
context.WeChatUserRecords.InsertOnSubmit(this);
context.SubmitChanges();
}
public void InsertIfNotExist()
{
var context = new AliSqlContext();
var dbUser = context.WeChatUsers.FirstOrDefault(u => u.OpenId == this.OpenId);
if (dbUser != null)
{
this.Category = dbUser.Category;
this.CreateDate = dbUser.CreateDate;
this.Id = dbUser.Id;
return;
}
this.CreateDate = DateTime.Now;
this.Category = "Todo";
context.WeChatUsers.InsertOnSubmit(this);
context.SubmitChanges();
}
