using SQLData;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SiteCore.Handler
{
    public partial class app
    {
        public void get_czmap()
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("select lat as latitude,lng as longitude from S_RunCZGps ;");
            sql.Append("select code as id,name,lat as latitude,lng as longitude,type,rotate,direction as dit from S_RunCZPoints ;");
            DataSet ds = DbHelper.DbConn.ExecuteDataset(sql.ToString());
            DataTable dt = ds.Tables[0];
            conSuccessData("1", "{\"users\":{\"run_cur\":0},\"lines\":"+Utils.Serialization.JsonString.DataTable2LowerAjaxJson(dt) + ",\"points\":" + Utils.Serialization.JsonString.DataTable2LowerAjaxJson(ds.Tables[1])+"}");
        }

    }
}