Example #1
0
        public static void PostBack(IWebSocketConnection socket, string message)
        {
            //qc|car|6e09f918_d4ef_4f27_8ed3_ab4800f5f488     //取前最近36条数据
            //qc|car|6e09f918_d4ef_4f27_8ed3_ab4800f5f488|startTime  多个car用,隔开(多个car时同时若存在startTime,startTime也要用,隔开)  //取大于startTime的数据,不超过36条
            //返回为Json字符串 格式为

            /*
             * [
             * {"carId":"abc1","data":[
             *      {"time":"2020-12-12 12:12:14","jingDu":123,"weiDu":123,"suDu":123,"fangXiang":123},
             * {"time":"2020-12-12 12:12:13","jingDu":123,"weiDu":123,"suDu":123,"fangXiang":123},
             * {"time":"2020-12-12 12:12:12","jingDu":123,"weiDu":123,"suDu":123,"fangXiang":123}
             *                  ]     },
             * {"carId":"abc2","data":[
             *                  {"time":"2020-12-12 12:12:14","jingDu":123,"weiDu":123,"suDu":123,"fangXiang":123},
             * {"time":"2020-12-12 12:12:13","jingDu":123,"weiDu":123,"suDu":123,"fangXiang":123},
             * {"time":"2020-12-12 12:12:12","jingDu":123,"weiDu":123,"suDu":123,"fangXiang":123}
             *                  ]     }
             * ]
             */
            if (message.StartsWith("qc|bigScreenAlert"))
            {
                socket.Send(Redis.Read("bigScreenAlert"));
            }
            if (message.StartsWith("qc|alert|"))
            {
                string[] item   = message.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
                string   userId = item[2].Trim();
                socket.Send(Redis.Read("alert:" + userId));
            }
            if (message.StartsWith("qc|car|"))
            {
                string[] item       = message.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
                string[] startTimes = null;
                if (item.Length > 3)
                {
                    string _startTimes = item[3].Trim();
                    startTimes = _startTimes.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
                }
                string   carIDs = item[2].Trim();
                string[] cars   = carIDs.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
                string[] sqls   = new string[cars.Length];
                for (int i = 0; i < cars.Length; i++)
                {
                    if (startTimes == null)
                    {
                        sqls[i] = "select * from tb_gps where carFid='" + str.D2DD(cars[i]) + "' order by addtime desc  limit 36";
                    }
                    else
                    {
                        sqls[i] = "select * from tb_gps where carFid='" + str.D2DD(cars[i]) + "' and addtime>'" + str.D2DD(startTimes[i]) + "' order by addtime desc limit 36";
                    }
                }
                StringBuilder sb = new StringBuilder(100);
                sb.Append("[");
                using (DB db = new DB())
                {
                    db.Open(Const.MySql_ConnStr);
                    for (int i = 0; i < cars.Length; i++)
                    {
                        string sql = sqls[i];
                        if (i > 0)
                        {
                            sb.Append(",");
                        }
                        sb.Append("{\"carId\":\"" + cars[i] + "\",\"data\":[");
                        bool hasdata = false;
                        using (DR dr = db.OpenRecord(sql))
                        {
                            while (dr.Read())
                            {
                                if (hasdata)
                                {
                                    sb.Append(",");
                                }
                                GPSPoint gp = GPSChange.WGS84_to_GCJ02(Convert.ToDouble(dr.GetDecimal("weidu")), Convert.ToDouble(dr.GetDecimal("jingdu")));
                                sb.Append("{\"time\":\"" + FTFrame.Tool.str.GetDateTime(dr.GetDateTime("addtime")) + "\",\"jingDu\":" + gp.GetLng() + ",\"weiDu\":" + gp.GetLat() + ",\"suDu\":" + dr.GetDecimal("sudu") + ",\"fangXiang\":" + dr.GetDecimal("fangxiang") + "}");
                                hasdata = true;
                            }
                        }
                        sb.Append("]}");
                    }
                }
                sb.Append("]");
                socket.Send(sb.ToString());
            }
        }