/// <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 DoInsert()
{
if (ListPipe == null)
{
return(false);
}
TPipeInfo pipeinfo = new TPipeInfo(_dbpath, PassWord);
TPipeExtInfo pipextinfo = new TPipeExtInfo(_dbpath, PassWord);
TUSInfo usinfo = new TUSInfo(_dbpath, PassWord);
pipeinfo.OpenDB();
pipextinfo.OpenDB();
usinfo.OpenDB();
int i = 0;
foreach (CPipeInfo pipe in ListPipe)
{
CPipeInfo tmp = pipe;
//插入附加信息
CPipeExtInfo extmp = null;
if (!pipeinfo.Insert_PipeInfo(ref tmp))
{
continue;
}
if (ListPipeExt == null || ListPipeExt.Count == 0)
{
extmp = new CPipeExtInfo();
}
else
{
if (i < ListPipeExt.Count)
{
extmp = ListPipeExt.ElementAt(i);
}
else
{
extmp = new CPipeExtInfo();
}
}
extmp.PipeID = tmp.ID;
pipextinfo.Insert_PipeExtInfo(ref extmp);
//插入管道检测信息
CUSInfo ustmp = null;
if (ListUS == null || ListUS.Count == 0)
{
ustmp = new CUSInfo();
}
else
{
if (i < ListUS.Count)
{
ustmp = ListUS.ElementAt(i);
}
else
{
ustmp = new CUSInfo();
}
}
ustmp.PipeID = tmp.ID;
usinfo.Insert_USInfo(ref ustmp);
i++;
}
//close the db connection
pipeinfo.CloseDB();
pipextinfo.CloseDB();
usinfo.CloseDB();
return(true);
}
