static void changeData08222018()
{
StreamReader sr = new StreamReader("C://ttxy/download/script.txt", Encoding.UTF8);
String line = sr.ReadToEnd();
IList <LocalData> upd = new List <LocalData>();
if (line != null)
{
String[] list = line.Split(';');
foreach (String element in list)
{
String[] s = element.Split('#');
if (s[0] == "")
{
Console.WriteLine(element);
}
else
{
LocalData tmp = new LocalData();
tmp.ID = int.Parse(s[0]);
tmp.Name = s[1];
tmp.Address = s[2];
tmp.Tele = s[8];
upd.Add(tmp);
}
}
Console.WriteLine(upd.Count);
DLocalDataWGS dldw = new DLocalDataWGS();
int countName = 0;
int countTele = 0;
foreach (LocalData eld in upd)
{
if (eld.ID != 0)
{
LocalData stmp = dldw.SELECT_BY_ID(eld.ID);
if (eld.Name != stmp.Name)
{
stmp.Name = eld.Name;
dldw.UPDATE(stmp);
countName++;
}
if (eld.Tele != stmp.Tele)
{
stmp.Tele = eld.Tele;
dldw.UPDATE(stmp);
countTele++;
}
}
}
Console.WriteLine();
Console.WriteLine("Name Change: " + countName);
Console.WriteLine("Telenum Change: " + countTele);
//Console.WriteLine(line.ToString());
//Console.WriteLine(list[0]);
//Console.WriteLine(list[1]);
//Console.WriteLine(list.Length);
}
}
static void synFromWGS_BaseonAddr08222018()
{
DLocalData dld = new DLocalData();
DLocalDataGCJ gcj = new DLocalDataGCJ();
DLocalDataWGS wgs = new DLocalDataWGS();
IList <LocalData> ldwgs = wgs.SELECT_ALL();
int countName = 0;
int countTele = 0;
foreach (LocalData ele in ldwgs)
{
LocalData edd = dld.SELECT_BY_ADDR(ele.Address);
LocalData edg = gcj.SELECT_BY_ADDR(ele.Address);
if (ele.Name != edd.Name)
{
edd.Name = ele.Name;
edg.Name = ele.Name;
dld.UPDATE(edd);
gcj.UPDATE(edg);
countName++;
}
if (ele.Tele != edd.Tele)
{
edd.Tele = ele.Tele;
edg.Tele = ele.Tele;
dld.UPDATE(edd);
gcj.UPDATE(edg);
countTele++;
}
}
Console.WriteLine();
Console.WriteLine("Name changes: " + countName);
Console.WriteLine("Telenum changes: " + countTele);
}
/// <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();
}
static void checkidqueue()
{
DLocalDataWGS wgs = new DLocalDataWGS();
IList <LocalData> ldwgs = wgs.SELECT_ALL();
for (int i = 0; i < ldwgs.Count - 1; i++)
{
if (ldwgs[i].ID + 1 != ldwgs[i + 1].ID)
{
Console.WriteLine(ldwgs[i].ID);
}
}
}
/// <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 int edit_localdata_wgs(LocalData ld)
{
DLocalDataWGS dldwgs = new DLocalDataWGS();
return(dldwgs.UPDATE(ld));
}
public int add_localdata_wgs(LocalData ld)
{
DLocalDataWGS dldwgs = new DLocalDataWGS();
return(dldwgs.INSERT(ld));
}
public LocalData get_local_wgs(int id)
{
DLocalDataWGS dld = new DLocalDataWGS();
return(dld.SELECT_BY_ID(id));
}
public IList <LocalData> search_local_wgs(string kw, string group)
{
DLocalDataWGS dld = new DLocalDataWGS();
return(dld.SELECT_BY_KW_GROUP(kw, group));
}
public IList <LocalData> search_local_wgs(string kw)
{
DLocalDataWGS dld = new DLocalDataWGS();
return(dld.SELECT_BY_KW(kw));
}
public IList <LocalData> get_local_wgs(bool isused)
{
DLocalDataWGS dld = new DLocalDataWGS();
return(dld.SELECT_BY_ISUSED(1));
}
public IList <LocalData> get_local_wgs(string group)
{
DLocalDataWGS wgs = new DLocalDataWGS();
return(wgs.SELECT_BY_GROUP(group));
}
public IList <LocalData> get_local_wgs()
{
DLocalDataWGS dld = new DLocalDataWGS();
return(dld.SELECT_ALL());
}
