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