Beispiel #1
0
        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);
        }
Beispiel #2
0
        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);
        }
Beispiel #3
0
        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);
        }