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