internal bool DeleteAreaTrack(AreaTrack areatra)
{
string sql = string.Format("DELETE FROM `area_track` where id = '{0}'", areatra.id);
int row = mSql.ExcuteSql(sql);
return(row >= 1);
}
internal bool AddAreaTrack(AreaTrack areatra)
{
string str = "INSERT INTO `area_track`(`area_id`, `track_id`, `track_type`) VALUES('{0}', '{1}', '{2}')";
string sql = string.Format(@str, areatra.area_id, areatra.track_id, areatra.track_type);
int row = mSql.ExcuteSql(sql);
return(row >= 1);
}
internal bool EditAreaTrack(AreaTrack areatra)
{
string sql = "UPDATE `area_track` set area_id = '{0}', `track_id` = {1} where id = '{2}'";
sql = string.Format(sql, areatra.area_id, areatra.track_id, areatra.id);
int row = mSql.ExcuteSql(sql);
return(row >= 1);
}