public bool Update(Model.manual_report model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update manual_report set "); strSql.Append("query_id=@query_id,"); strSql.Append("rep_type=@rep_type,"); strSql.Append("appellation=@appellation,"); strSql.Append("rep_str=@rep_str,"); strSql.Append("add_user=@add_user,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); SQLiteParameter[] parameters = { new SQLiteParameter("@query_id", DbType.Int32, 8), new SQLiteParameter("@rep_type", DbType.String, 8), new SQLiteParameter("@appellation", DbType.String, 8), new SQLiteParameter("@rep_str", DbType.String, 255), new SQLiteParameter("@add_user", DbType.String, 50), new SQLiteParameter("@add_time", DbType.DateTime), new SQLiteParameter("@id", DbType.Int32, 8) }; parameters[0].Value = model.query_id; parameters[1].Value = model.rep_type; parameters[2].Value = model.appellation; parameters[3].Value = model.rep_str; parameters[4].Value = model.add_user; parameters[5].Value = model.add_time; parameters[6].Value = model.id; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public int Add(Model.manual_report model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into manual_report("); strSql.Append("query_id,rep_type,appellation,rep_str,add_user,add_time)"); strSql.Append(" values ("); strSql.Append("@query_id,@rep_type,@appellation,@rep_str,@add_user,@add_time)"); strSql.Append(";select LAST_INSERT_ROWID()"); SQLiteParameter[] parameters = { new SQLiteParameter("@query_id", DbType.Int32, 8), new SQLiteParameter("@rep_type", DbType.String, 8), new SQLiteParameter("@appellation", DbType.String, 8), new SQLiteParameter("@rep_str", DbType.String, 255), new SQLiteParameter("@add_user", DbType.String, 50), new SQLiteParameter("@add_time", DbType.DateTime) }; parameters[0].Value = model.query_id; parameters[1].Value = model.rep_type; parameters[2].Value = model.appellation; parameters[3].Value = model.rep_str; parameters[4].Value = model.add_user; parameters[5].Value = model.add_time; object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }