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();
}
partial void DeleteWeChatUser(WeChatUser instance);
partial void UpdateWeChatUser(WeChatUser instance);
partial void InsertWeChatUser(WeChatUser instance);
