/// <summary> /// 删除检查井信息,同时删除检查井附加信息 /// </summary> /// <returns></returns> private bool DoDelete() { if (ListJunc == null) return false; TJuncInfo juncinfo = new TJuncInfo(_dbpath, PassWord); TJuncExtInfo juncextinfo = new TJuncExtInfo(_dbpath, PassWord); foreach (CJuncInfo junc in ListJunc) { juncinfo.Delete_JuncInfo(junc); List<CJuncExtInfo> list = juncextinfo.Sel_JuncExtInfo(junc.ID); if (list != null && list.Count > 0) juncextinfo.Delete_JuncExtInfo(list.ElementAt(0)); } return true; }
/// <summary> /// select command. /// </summary> /// <returns></returns> private bool DoSelect() { TJuncInfo juncinfo = new TJuncInfo(_dbpath, PassWord); TJuncExtInfo juncextinfo = new TJuncExtInfo(_dbpath, PassWord); if (JuncName != null && JuncName.Length > 0) { ListJunc = juncinfo.Sel_JuncInfo(JuncName); if (ListJunc == null) return false; ListJuncExt = new List<CJuncExtInfo>(); foreach (CJuncInfo junc in ListJunc) { List<CJuncExtInfo> tmplist = juncextinfo.Sel_JuncExtInfo(junc.ID); if (tmplist != null&&tmplist.Count>0) ListJuncExt.Add(tmplist.ElementAt(0)); } } else { CJuncInfo ji= juncinfo.Sel_JuncInfo(ID); ListJunc = new List<CJuncInfo>(); if (ji != null) ListJunc.Add(ji); ListJuncExt = new List<CJuncExtInfo>(); foreach (CJuncInfo junc in ListJunc) { List<CJuncExtInfo> tmplist = juncextinfo.Sel_JuncExtInfo(junc.ID); if (tmplist != null && tmplist.Count > 0) ListJuncExt.Add(tmplist.ElementAt(0)); } } return true; }