private bool DoQuickInsert() { TJuncInfo juncinfo = new TJuncInfo(_dbpath, PassWord); TJuncExtInfo juncextinfo = new TJuncExtInfo(_dbpath, PassWord); if (ListJunc == null) { return(false); } List <int> listid = new List <int>(); //for junction id list //asume that the junclist size equal juncextlist size if (!juncinfo.Insert_JuncInfo(ListJunc, ref listid)) { return(false); } int nCount = 0; List <CJuncExtInfo> newlistext = new List <CJuncExtInfo>(); foreach (CJuncExtInfo junc in ListJuncExt) { junc.JuncID = listid.ElementAt(nCount++); newlistext.Add(junc); } if (!juncextinfo.Insert_JuncExtInfo(newlistext)) { return(false); } return(true); }
//返回插入junction的id protected int InsterDB(Cover c) { if (c == null) { return(0); } //change the coordinate Mercator to WGS84 Coords.Point p = new Coords.Point(); p.x = c.Location.X; p.y = c.Location.Y; p = Coords.Mercator2WGS84(p); //store to CJuncInfo info = new CJuncInfo(); info.X_Coor = p.x + Constants.COOR_X_OFFSET; info.Y_Coor = p.y + Constants.COOR_Y_OFFSET; info.Junc_Category = c.juncInfo.Junc_Category; //数据库操作 TJuncInfo juncinfo = new TJuncInfo(App._dbpath, App.PassWord); TJuncExtInfo juncextinfo = new TJuncExtInfo(App._dbpath, App.PassWord); if (!juncinfo.Insert_JuncInfo(ref info)) { return(0); } CJuncExtInfo extinfo = new CJuncExtInfo(); extinfo.JuncID = info.ID; juncextinfo.Insert_JuncExtInfo(ref extinfo); return(info.ID); }
/// <summary> /// 插入检查井信息,同时插入对应的检查井附加信息,若不存在附加信息 /// 则创建新的信息 /// </summary> /// <returns></returns> private bool DoInsert() { TJuncInfo juncinfo = new TJuncInfo(_dbpath, PassWord); TJuncExtInfo juncextinfo = new TJuncExtInfo(_dbpath, PassWord); if (ListJunc == null) { return(false); } int i = 0; foreach (CJuncInfo junc in ListJunc) { CJuncInfo tmp = junc; if (!juncinfo.Insert_JuncInfo(ref tmp)) { continue; } CJuncExtInfo extmp = null; if (ListJuncExt == null || ListJuncExt.Count == 0) { extmp = new CJuncExtInfo(); } else { if (i < ListJuncExt.Count) { extmp = ListJuncExt.ElementAt(i); } else { extmp = new CJuncExtInfo(); } } extmp.JuncID = tmp.ID; juncextinfo.Insert_JuncExtInfo(ref extmp); i++; } if (i <= 0) { return(false); } return(true); }