예제 #1
0
        /// <summary>
        /// 获取电量
        /// </summary>
        /// <example>
        /// sw.SearchTime   查询日期,查询某日的电量信息
        /// sw.USERID       护林员序号(多序号以逗号分隔)
        /// sw.DateBegin    开始日期
        /// sw.DateEnd      结束日期
        /// </example>
        /// <param name="sw">参见条件模型T_IPS_REALDATASW</param>
        /// <returns>参见模型T_IPS_REALDATAModel</returns>
        public static IEnumerable <T_IPS_REALDATAModel> getElectricModelList(T_IPS_REALDATASW sw)
        {
            var result = new List <T_IPS_REALDATAModel>();
            //获取当前登录用户有权限查看的组织机构
            DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
                SYSFLAG = ConfigCls.getSystemFlag()
            });
            //获取所有有权限查看的护林员
            DataTable dtFRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW {
                ISENABLE = "1", HID = sw.HID
            });
            DataTable dt = BaseDT.T_IPS_REALDATA.getDT(sw);

            DataRow[] dr = dt.Select("", "SBTIME desc");
            for (int i = 0; i < dr.Length; i++)
            {
                if (string.IsNullOrEmpty(dr[i]["ELECTRIC"].ToString()) == false)
                {
                    T_IPS_REALDATAModel m = new T_IPS_REALDATAModel();

                    m.REALDATAID = dr[i]["REALDATAID"].ToString();
                    m.PHONE      = dr[i]["PHONE"].ToString();//电话号码
                    m.LONGITUDE  = dr[i]["LONGITUDE"].ToString();
                    m.LATITUDE   = dr[i]["LATITUDE"].ToString();
                    m.HEIGHT     = dr[i]["HEIGHT"].ToString();
                    m.ELECTRIC   = dr[i]["ELECTRIC"].ToString();
                    m.SPEED      = dr[i]["SPEED"].ToString();
                    m.DIRECTION  = dr[i]["DIRECTION"].ToString();
                    m.SBTIME     = dr[i]["SBTIME"].ToString();
                    if (string.IsNullOrEmpty(m.SBTIME) == false)
                    {
                        m.SBTIME = PublicClassLibrary.ClsSwitch.SwitTM(m.SBTIME);
                    }
                    m.NOTE = dr[i]["NOTE"].ToString();

                    DataRow[] drFRUser = dtFRUser.Select("PHONE='" + m.PHONE + "'");
                    if (drFRUser.Length > 0)
                    {
                        m.HID     = drFRUser[0]["HID"].ToString();            //护林员编号
                        m.HNAME   = drFRUser[0]["HNAME"].ToString();          //护林员名称
                        m.ORGNO   = drFRUser[0]["BYORGNO"].ToString();        //组织机构编码
                        m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtOrg, m.ORGNO); //组织机构名称
                    }
                    result.Add(m);
                }
            }
            dtOrg.Clear();
            dtOrg.Dispose();
            dtFRUser.Clear();
            dtFRUser.Dispose();
            dt.Clear();
            dt.Dispose();
            return(result);
        }
예제 #2
0
        /// <summary>
        /// 根据电话号码获取实时传输数据
        /// </summary>
        /// <example>
        /// sw.SearchTime   查询日期,查询某日的电量信息
        /// sw.USERID       护林员序号(多序号以逗号分隔)
        /// sw.DateBegin    开始日期
        /// sw.DateEnd      结束日期
        /// </example>
        /// <param name="sw">参见条件模型T_IPS_REALDATASW</param>
        /// <returns>参见模型T_IPS_REALDATAModel</returns>
        public static IEnumerable <T_IPS_REALDATAModel> getModelList(T_IPS_REALDATASW sw)
        {
            var       result = new List <T_IPS_REALDATAModel>();
            DataTable dt     = BaseDT.T_IPS_REALDATA.getDT(sw);

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                T_IPS_REALDATAModel m = new T_IPS_REALDATAModel();
                m.REALDATAID = dt.Rows[i]["REALDATAID"].ToString();
                m.PHONE      = dt.Rows[i]["PHONE"].ToString();
                m.LONGITUDE  = dt.Rows[i]["LONGITUDE"].ToString(); //经度
                m.LATITUDE   = dt.Rows[i]["LATITUDE"].ToString();  //纬度
                if (sw.MapType != "Skyline")
                {
                    //******************计算坐标偏移量
                    string[] arr = PublicCls.switJWD(m.LATITUDE, m.LONGITUDE);
                    m.LATITUDE  = arr[0];
                    m.LONGITUDE = arr[1];
                    //******************计算坐标偏移量 End
                }
                m.HEIGHT    = dt.Rows[i]["HEIGHT"].ToString();
                m.ELECTRIC  = dt.Rows[i]["ELECTRIC"].ToString();
                m.SPEED     = dt.Rows[i]["SPEED"].ToString();
                m.DIRECTION = dt.Rows[i]["DIRECTION"].ToString();
                m.SBTIME    = dt.Rows[i]["SBTIME"].ToString();
                if (string.IsNullOrEmpty(m.SBTIME) == false)
                {
                    m.SBTIME = PublicClassLibrary.ClsSwitch.SwitTM(m.SBTIME);
                }
                m.NOTE = dt.Rows[i]["NOTE"].ToString();


                result.Add(m);
            }
            //dtHUser.Clear();
            //dtHUser.Dispose();
            dt.Clear();
            dt.Dispose();
            return(result);
        }