/// <summary>
///
/// </summary>
static void trimAddr()
{
//DLocalDataGCJ dldgcj = new DLocalDataGCJ();
//LocalData tp = dldgcj.SELECT_BY_ID(266);
//if (tp.Address.Contains("\r\n"))
//{
// Console.WriteLine("true");
//}
//if (tp.Address.Contains("\""))
//{
// Console.WriteLine("true//////");
//}
//Console.WriteLine(tp.Address.Replace("\r\n", "").Replace("\"", ""));
DLocalData dld = new DLocalData();
IList <LocalData> ld = dld.SELECT_ALL();
for (int i = 0; i < ld.Count; i++)
{
if (ld[i].Address.Contains("\r\n"))
{
Console.Write("localdata: " + ld[i].ID + ";");
ld[i].Address = ld[i].Address.Replace("\r\n", "").Replace("\"", "");
dld.UPDATE(ld[i]);
}
}
Console.WriteLine();
DLocalDataGCJ dldgcj = new DLocalDataGCJ();
IList <LocalData> ldgcj = dldgcj.SELECT_ALL();
for (int i = 0; i < ldgcj.Count; i++)
{
if (ldgcj[i].Address.Contains("\r\n"))
{
Console.Write("localdata_gcj: " + ldgcj[i].ID + ";");
ldgcj[i].Address = ldgcj[i].Address.Replace("\r\n", "").Replace("\"", "");
dldgcj.UPDATE(ldgcj[i]);
}
}
Console.WriteLine();
DLocalDataWGS dldwgs = new DLocalDataWGS();
IList <LocalData> ldwgs = dldwgs.SELECT_ALL();
for (int i = 0; i < ldwgs.Count; i++)
{
if (ldwgs[i].Address.Contains("\r\n"))
{
Console.Write("localdata_wgs: " + ldwgs[i].ID + ";");
ldwgs[i].Address = ldwgs[i].Address.Replace("\r\n", "").Replace("\"", "");
dldwgs.UPDATE(ldwgs[i]);
}
}
Console.WriteLine();
}
/// <summary>
/// 拷贝数据库表格并转换坐标
/// BD09转向GCJ02
/// localdata -> localdatagcj
/// </summary>
public void copydata_bd2gcj()
{
DLocalData dld = new DLocalData();
DLocalDataGCJ dldgcj = new DLocalDataGCJ();
IList <LocalData> bd = dld.SELECT_ALL();
Console.WriteLine("开始转换......");
int count = 0;
foreach (LocalData tmp in bd)
{
double[] gcj = BD09toGCJ02(tmp.Lng, tmp.Lat);
tmp.Lng = gcj[0];
tmp.Lat = gcj[1];
int t = dldgcj.INSERT(tmp);
if (t > 0)
{
count++;
}
}
Console.WriteLine("成功执行了：{0}行。", count);
}
/// <summary>
/// 拷贝数据库表格并转换坐标
/// BD09转向WGS84
/// localdata -> localdatawgs
/// </summary>
public void copydata_bd2wgs()
{
DLocalData dld = new DLocalData();
DLocalDataWGS dldwgs = new DLocalDataWGS();
IList <LocalData> bd = dld.SELECT_ALL();
Console.WriteLine("开始转换......");
int count = 0;
foreach (LocalData tmp in bd)
{
double[] gcj = BD09toGCJ02(tmp.Lng, tmp.Lat);
double[] wgs = GCJ02toWGS84(gcj[0], gcj[1]);
tmp.Lng = wgs[0];
tmp.Lat = wgs[1];
int t = dldwgs.INSERT(tmp);
if (t > 0)
{
count++;
}
}
Console.WriteLine("成功执行了：{0}行。", count);
}
public IList <LocalData> get_local()
{
DLocalData dld = new DLocalData();
return(dld.SELECT_ALL());
}