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();
}
public int edit_localdata(LocalData ld)
{
DLocalData dld = new DLocalData();
return(dld.UPDATE(ld));
}