/// <summary>
/// 删除管道的基本信息，同时删除其他关联信息,
/// :附加信息，管道检测信息，管道日志，图片，报告，视频信息
/// </summary>
/// <returns></returns>
private bool DoDelete()
{
TPipeInfo pipeinfo = new TPipeInfo(_dbpath, PassWord);
TPipeExtInfo pipextinfo = new TPipeExtInfo(_dbpath, PassWord);
TUSInfo usinfo = new TUSInfo(_dbpath, PassWord);
if (ListPipe == null || ListPipe.Count == 0)
{
return(false);
}
foreach (CPipeInfo pipe in ListPipe)
{
pipeinfo.Delete_PipeInfo(pipe);
CPipeExtInfo ext = null;
ListPipeExt = pipextinfo.Sel_PipeExtInfo(pipe.ID);
if (ListPipeExt != null && ListPipeExt.Count > 0)
{
ext = ListPipeExt.ElementAt(0);
}
pipextinfo.Delete_PipeExtInfo(ext);
CUSInfo us = null;
ListUS = usinfo.Sel_USInfo(pipe.ID);
if (ListUS != null && ListUS.Count > 0)
{
us = ListUS.ElementAt(0);
}
usinfo.Delete_USInfo(us);
}
return(true);
}
/// <summary>
/// 根据管道名称获取管道信息，附加信息;管道检测信息，管道日志，图片，报告，视频信息
/// </summary>
/// <returns></returns>
private bool DoSelect()
{
if (PipeName == null || PipeName.Length <= 0)
{
return(false);
}
TPipeInfo pipeinfo = new TPipeInfo(_dbpath, PassWord);
TPipeExtInfo pipextinfo = new TPipeExtInfo(_dbpath, PassWord);
TUSInfo usinfo = new TUSInfo(_dbpath, PassWord);
ListPipe = pipeinfo.Sel_PipeInfo(PipeName);
if (ListPipe == null || ListPipe.Count <= 0)
{
return(false);
}
ListPipeExt = new List <CPipeExtInfo>();
ListUS = new List <CUSInfo>();
foreach (CPipeInfo pipe in ListPipe)
{
int id = pipe.ID;
List <CPipeExtInfo> list1 = pipextinfo.Sel_PipeExtInfo(id);
if (list1 != null && list1.Count > 0)
{
ListPipeExt.Add(list1.ElementAt(0));
}
List <CUSInfo> list2 = usinfo.Sel_USInfo(id);
if (list2 != null && list2.Count > 0)
{
ListUS.Add(list2.ElementAt(0));
}
}
return(true);
}