private bool DoQuickInsert()
{
if (ListPipe == null||ListPipe.Count==0)
{
if (ListUS != null && ListUS.Count > 0)
return InsertUs();
else
return false;
}
TPipeInfo pipeinfo = new TPipeInfo(_dbpath, PassWord);
TPipeExtInfo pipextinfo = new TPipeExtInfo(_dbpath, PassWord);
pipeinfo.OpenDB();
pipextinfo.OpenDB();
List<int> listid = new List<int>();
if (!pipeinfo.Insert_PipeInfo(ListPipe, ref listid))
return false;
int nCount = 0;
List<CPipeExtInfo> newllist = new List<CPipeExtInfo>();
foreach (CPipeExtInfo pipe in ListPipeExt)
{
pipe.PipeID = listid.ElementAt(nCount++);
newllist.Add(pipe);
}
if (!pipextinfo.Insert_PipeExtInfo(ListPipeExt))
return false;
pipeinfo.CloseDB();
pipextinfo.CloseDB();
return true;
}
protected int InsterDb(Pipe pipe , Cover injunc , Cover outjunc)
{
CPipeInfo pipeInfo = new CPipeInfo();
CPipeExtInfo pipeExtInfo = new CPipeExtInfo();
CUSInfo UsInfo = new CUSInfo();
pipeInfo.PipeName = pipe.Name;
pipeInfo.In_JunID = injunc.juncInfo.ID;
pipeInfo.Out_JunID = outjunc.juncInfo.ID;
pipeInfo.Pipe_Category = pipe.pipeInfo.Pipe_Category;
UsInfo.Struct_Class = 0;
TPipeInfo tpipeinfo = new TPipeInfo(App._dbpath, App.PassWord);
TPipeExtInfo tpipextinfo = new TPipeExtInfo(App._dbpath, App.PassWord);
TUSInfo tusinfo = new TUSInfo(App._dbpath, App.PassWord);
tpipeinfo.Insert_PipeInfo(ref pipeInfo);
pipeExtInfo.PipeID = pipeInfo.ID;
tpipextinfo.Insert_PipeExtInfo(ref pipeExtInfo);
UsInfo.PipeID = pipeInfo.ID;
tusinfo.Insert_USInfo(ref UsInfo);
return pipeInfo.ID;
}
/// <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;
}