/// <summary> /// 获取记录总数 /// </summary> public int GetRecordCount(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM SiteConfig "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = DbHelperSQLite.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.Pic model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Pic("); strSql.Append("ImageURL,AID,Type,Number,Title,Summary)"); strSql.Append(" values ("); strSql.Append("@ImageURL,@AID,@Type,@Number,@Title,@Summary)"); strSql.Append(";select LAST_INSERT_ROWID()"); SQLiteParameter[] parameters = { new SQLiteParameter("@ImageURL", DbType.String), new SQLiteParameter("@AID", DbType.String), new SQLiteParameter("@Type", DbType.String), new SQLiteParameter("@Number", DbType.String), new SQLiteParameter("@Title", DbType.String), new SQLiteParameter("@Summary", DbType.String) }; parameters[0].Value = model.ImageURL; parameters[1].Value = model.AID; parameters[2].Value = model.Type; parameters[3].Value = model.Number; parameters[4].Value = model.Title; parameters[5].Value = model.Summary; object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }