//插入路径
public SqlState InsertRoute(string UserName, RouteInfo routeInfo)
{
int userId;
SqlState sqlState = GetIdByUserName(UserName, out userId);
if (sqlState != SqlState.Success)
{
return(sqlState);
}
routeInfo.UserId = userId;
sql.ExecuteQuery("PRAGMA foreign_keys = ON; ");
SqliteDataReader reader = sql.InsertValues(SQLUserRoute, new string[] { "User_Id", "Scene_Id", "Start", "Middle", "Destination", "Route", "RouteOrder", "StepNum", "Duration", "fieldOne", "fieldTwo", "MiddleStep" }, routeInfo.GetStr());
return(SqlState.Success);
}
