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);
}
private bool DoClear()
{
TJuncInfo juncinfo = new TJuncInfo(_dbpath, PassWord);
TJuncExtInfo juncextinfo = new TJuncExtInfo(_dbpath, PassWord);
juncinfo.Clear_JuncInfo();
juncextinfo.Clear_JuncExtInfo();
return(true);
}
private bool DoUpdate()
{
TJuncInfo juncinfo = new TJuncInfo(_dbpath, PassWord);
TJuncExtInfo juncextinfo = new TJuncExtInfo(_dbpath, PassWord);
if (ListJunc == null || ListJuncExt == null)
{
return(false);
}
bool b1 = juncinfo.Update_JuncInfo(ListJunc);
bool b2 = juncextinfo.Update_JuncExtInfo(ListJuncExt);
return(b1 & b2);
}
/// <summary>
/// load command
/// </summary>
/// <returns></returns>
private bool DoLoad()
{
TJuncInfo juncinfo = new TJuncInfo(_dbpath, PassWord);
TJuncExtInfo juncextinfo = new TJuncExtInfo(_dbpath, PassWord);
ListJunc = juncinfo.Load_JuncInfo();
if (ListJunc == null)
{
return(false);
}
ListJuncExt = juncextinfo.Load_JuncExtInfo();
if (ListJuncExt != null)
{
return(false);
}
return(true);
}
/// <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);
}
/// <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);
}
/// <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);
}
