/// <summary>
/// 更新一条数据
/// </summary>
public bool Update()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Note_Main] set ");
strSql.Append("Content=@Content,");
strSql.Append("State=@State,");
strSql.Append("AddRenID=@AddRenID,");
strSql.Append("AddTime=@AddTime");
strSql.Append(" where ID=@ID ");
string sql = strSql.ToString();
sql = sql.Replace("@ID", "'" + ID.Replace("'", "''") + "'");
sql = sql.Replace("@Content", "'" + Content.Replace("'", "''") + "'");
sql = sql.Replace("@State", State.ToString());
sql = sql.Replace("@AddRenID", "'" + AddRenID.Replace("'", "''") + "'");
sql = sql.Replace("@AddTime", "'" + AddTime.Replace("'", "''") + "'");
int rows = DbHelperSQLite.ExecuteSql(sql);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Note_Main] (");
strSql.Append("ID,Content,State,AddRenID,AddTime)");
strSql.Append(" values (");
strSql.Append("@ID,@Content,@State,@AddRenID,@AddTime)");
string sql = strSql.ToString();
sql = sql.Replace("@ID", "'" + ID.Replace("'", "''") + "'");
sql = sql.Replace("@Content", "'" + Content.Replace("'", "''") + "'");
sql = sql.Replace("@State", State.ToString());
sql = sql.Replace("@AddRenID", "'" + AddRenID.Replace("'", "''") + "'");
sql = sql.Replace("@AddTime", "'" + AddTime.Replace("'", "''") + "'");
DbHelperSQLite.ExecuteSql(sql);
}
