public int InsertRecommendedHistory(RecommendedHistory history) { int ret = 0; SQLiteHelper sh = new SQLiteHelper(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RecommendedHistory("); strSql.Append("Id,OpenId,DishesId,DishName,Score,CreateTime)"); strSql.Append(" values ("); strSql.Append("@Id,@OpenId,@DishesId,@DishName,@Score,@CreateTime)"); SQLiteParameter[] parameters = { sh.MakeSQLiteParameter("@Id", DbType.String, history.Id), sh.MakeSQLiteParameter("@OpenId", DbType.String, history.OpenId), sh.MakeSQLiteParameter("@DishesId", DbType.String, history.DishesId), sh.MakeSQLiteParameter("@DishName", DbType.String, history.DishName), sh.MakeSQLiteParameter("@Score", DbType.Double, history.Score), sh.MakeSQLiteParameter("@CreateTime", DbType.DateTime, history.CreateTime) }; if (sh.ExecuteSql(strSql.ToString(), parameters) >= 1) { ret = 1; } return(ret); }
public void SaveRecommendHistory(string openId, string dishesId, double score, string dishName) { RecommendedHistory history = new RecommendedHistory() { Id = Guid.NewGuid().ToString(), OpenId = openId, DishesId = dishesId, DishName = dishName, Score = score, CreateTime = DateTime.Now, }; InsertRecommendedHistory(history); }