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 showpoints() { DLocalDataGCJ dd = new DLocalDataGCJ(); IList <LocalData> tt = dd.SELECT_ALL(); string ss = LbsMaker.MakeMapPointsTDT(tt); //string ss = LbsMaker.MakeMapPoints(tt); File.WriteAllText("C:/ttxy/desktop/lbs/points.txt", ss); Console.WriteLine(ss); }
/// <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); }
public int edit_localdata_gcj(LocalData ld) { DLocalDataGCJ dldgcj = new DLocalDataGCJ(); return(dldgcj.UPDATE(ld)); }
public int add_localdata_gcj(LocalData ld) { DLocalDataGCJ dldgcj = new DLocalDataGCJ(); return(dldgcj.INSERT(ld)); }