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