/// <summary> /// 增加一条数据 /// </summary> public void Add(Model.Revert model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into myRevert("); strSql.Append("Content,ArticleID,[user]"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + model.Content + "',"); strSql.Append("" + model.ArticleID + ","); strSql.Append("'" + model.User + "'"); strSql.Append(")"); SQLHelper.ExecuteNonQuery(strSql.ToString()); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Revert GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" ID,Content,user,ArticleID,date "); strSql.Append(" from myRevert "); strSql.Append(" where ID=" + ID + " "); using (IDataReader dataReader = SQLHelper.ExecuteReader(strSql.ToString())) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }