C# (CSharp) Data.SIMSDataContext.SP_DCPID_Report Exemples

Exemple #1

        private IEnumerable <DCPIDDataItem> GetData()
        {
            string status    = "assigned";
            int    wsc_id    = WSCID;
            int    office_id = OfficeID;
            int    trip_id   = TripID;

            if (!ShowAssignedIDs)
            {
                status    = "unassigned";
                office_id = 0;
                trip_id   = 0;
            }

            var ret = db.SP_DCPID_Report(wsc_id, office_id, trip_id, SiteNo, status).Select(p => new DCPIDDataItem()
            {
                site_id      = p.site_id.ToString(),
                site_no      = p.site_no,
                station_nm   = p.station_nm,
                DCPID        = p.dcp_id,
                channel      = p.primary_ch.ToString() + "/" + p.random_ch.ToString(),
                baud         = p.primary_bd.ToString() + "/" + p.random_bd.ToString(),
                elevation    = FormatElevation(p.ant_azimuth.ToString(), p.satellite.ToString(), p.ant_elev.ToString()),
                transmission = p.assigned_time + "/" + p.trans_interval + "/" + p.window
            }).ToList();

            return(ret);
        }