static public int GetId(SqlCommand command,
                                string fltsegment,
                                string flightcode,
                                string flighttime,
                                string flightdate)
        {
            object o = DbUtility.ExecuteScalar(command, SP_flr_GetId,
                                               SqlHelper.BuildParameter("fltsegment", fltsegment),
                                               SqlHelper.BuildParameter("flightcode", flightcode),
                                               SqlHelper.BuildParameter("flighttime", flighttime),
                                               SqlHelper.BuildParameter("flightdate", flightdate));

            if (o == null)
            {
                return(-1);
            }
            return((int)o);
        }