private bool ReInsert(ref CPipeExtInfo pipe)
{
MySqlDataReader reader;
string strcmd = "INSERT INTO PipeExtInfo (PipeID,Lane_Way,Pressure_Type,Wall_Thick,Liner_Material,Conn_Type" +
",Pipe_Slop,Invert_Silphon,Origin_Strue,Constr_Method,Status,DataIsFull,LoseReason,Remark)" +
"values(" +
pipe.PipeID + " ,'" + pipe.Lane_Way + "', " + pipe.Pressure_Type + " ,'" + pipe.Wall_Thick + "', " + pipe.Liner_Material + " , " +
pipe.Conn_Type + " ,'" + pipe.Pipe_Slop + "', " + Convert.ToInt32(pipe.Invert_Silphon) + " , " + pipe.Origin_Strue + " , " +
pipe.Constr_Method + " , " + pipe.Status + " , " + Convert.ToInt32(pipe.DataIsFull) + " ,'" + pipe.LoseReason + "','" + pipe.Remark + "')";
try
{
connect.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connect;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strcmd;
strcmd = "SELECT MAX(ID) AS MAXID FROM PipeExtInfo";
cmd.ExecuteNonQuery();
cmd.CommandText = strcmd;
reader = cmd.ExecuteReader();
reader.Read();
pipe.ID = Convert.ToInt32(reader[0].ToString());
}
catch (System.Exception ex)
{
Console.WriteLine("ReINsert PipeExt Error : " + ex.Message);
return(false);
}
Console.WriteLine("Success!");
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 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>
/// 插入一个管道信息，并返回管道插入的ID
/// </summary>
/// <param name="pipe"></param>
/// <returns></returns>
public bool Insert_PipeExtInfo(ref CPipeExtInfo pipe)
{
MySqlDataReader reader;
MySqlCommand cmd;
string strcmd = "INSERT INTO PipeExtInfo (PipeID,Lane_Way,Pressure_Type,Wall_Thick,Liner_Material,Conn_Type" +
",Pipe_Slop,Invert_Silphon,Origin_Strue,Constr_Method,Status,DataIsFull,LoseReason,Remark)" +
"values(" +
pipe.PipeID + " ,'" + pipe.Lane_Way + "', " + pipe.Pressure_Type + " ,'" + pipe.Wall_Thick + "', " + pipe.Liner_Material + " , " +
pipe.Conn_Type + " ,'" + pipe.Pipe_Slop + "', " + Convert.ToInt32(pipe.Invert_Silphon) + " , " + pipe.Origin_Strue + " , " +
pipe.Constr_Method + " , " + pipe.Status + " , " + Convert.ToInt32(pipe.DataIsFull) + " ,'" + pipe.LoseReason + "','" + pipe.Remark + "')";
try
{
if (ConnectionState.Closed == connect.State)
{
connect.Open();
cmd = new MySqlCommand();
count = 0;
}
else if (count >= NUMBER)
{
count = 0;
connect.Close();
mysqlcmd = new MySqlCommand();
cmd = mysqlcmd;
connect.Open();
}
else
{
count++;
cmd = mysqlcmd.Clone();
}
cmd.Connection = connect;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strcmd;
strcmd = "SELECT MAX(ID) AS MAXID FROM PipeExtInfo";
cmd.ExecuteNonQuery();
cmd.CommandText = strcmd;
reader = cmd.ExecuteReader();
reader.Read();
pipe.ID = Convert.ToInt32(reader[0].ToString());
}
catch (System.Exception ex)
{
Console.WriteLine("Pipe of PipeExt error : " + ex.Message);
Console.WriteLine("Reinsert PipeExt");
connect.Close();
return(ReInsert(ref pipe));
}
finally
{
//connect.Close();
}
return(true);
}
public bool Delete_PipeExtInfo(CPipeExtInfo pipe)
{
List <string> listcmd = new List <string>();
try
{
string cmd = "DELETE FROM PipeExtInfo where ID = " + pipe.ID;
listcmd.Add(cmd);
ExectueCmd(listcmd);
}
catch (System.Exception ex)
{
Console.WriteLine("Pipe of PipeExt error : " + ex.Message);
return(false);
}
return(true);
}
private List <CPipeExtInfo> Select(string cmd)
{
List <CPipeExtInfo> listpipe = new List <CPipeExtInfo>();
MySqlCommand com;
MySqlDataReader reader;
try
{
if (ConnectionState.Closed == connect.State)
{
connect.Open();
}
com = new MySqlCommand(cmd, connect);
reader = com.ExecuteReader();
while (reader.Read())
{
CPipeExtInfo pipe = new CPipeExtInfo();
int i = 0;
string tmp;
pipe.ID = Convert.ToInt32(reader[i++].ToString());
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
pipe.PipeID = Convert.ToInt32(tmp);
}
pipe.Lane_Way = reader[i++].ToString();
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
pipe.Pressure_Type = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
pipe.Wall_Thick = Convert.ToDouble(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
pipe.Liner_Material = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
pipe.Conn_Type = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
pipe.Pipe_Slop = Convert.ToDouble(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
pipe.Invert_Silphon = Convert.ToBoolean(Convert.ToInt32(tmp));
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
pipe.Origin_Strue = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
pipe.Constr_Method = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
pipe.Status = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
pipe.DataIsFull = Convert.ToBoolean(Convert.ToInt32(tmp));
}
pipe.LoseReason = reader[i++].ToString();
pipe.Remark = reader[i++].ToString();
listpipe.Add(pipe);
}
}
catch (System.Exception ex)
{
Console.WriteLine("Pipe of PipeExt error : " + ex.Message);
return(null);
}
finally
{
connect.Close();
}
return(listpipe);
}
/// <summary>
/// 插入一个管道信息，并返回管道插入的ID
/// </summary>
/// <param name="pipe"></param>
/// <returns></returns>
public bool Insert_PipeExtInfo(ref CPipeExtInfo pipe)
{
MySqlDataReader reader;
MySqlCommand cmd;
string strcmd = "INSERT INTO PipeExtInfo (PipeID,Lane_Way,Pressure_Type,Wall_Thick,Liner_Material,Conn_Type" +
",Pipe_Slop,Invert_Silphon,Origin_Strue,Constr_Method,Status,DataIsFull,LoseReason,Remark)" +
"values(" +
pipe.PipeID + " ,'" + pipe.Lane_Way + "', " + pipe.Pressure_Type + " ,'" + pipe.Wall_Thick + "', " + pipe.Liner_Material + " , " +
pipe.Conn_Type + " ,'" + pipe.Pipe_Slop + "', " + Convert.ToInt32(pipe.Invert_Silphon) + " , " + pipe.Origin_Strue + " , " +
pipe.Constr_Method + " , " + pipe.Status +" , "+Convert.ToInt32(pipe.DataIsFull)+ " ,'"+pipe.LoseReason+"','" + pipe.Remark + "')";
try
{
if (ConnectionState.Closed == connect.State)
{
connect.Open();
cmd = new MySqlCommand();
count = 0;
}
else if (count >= NUMBER)
{
count = 0;
connect.Close();
mysqlcmd = new MySqlCommand();
cmd = mysqlcmd;
connect.Open();
}
else
{
count++;
cmd = mysqlcmd.Clone();
}
cmd.Connection = connect;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strcmd;
strcmd = "SELECT MAX(ID) AS MAXID FROM PipeExtInfo";
cmd.ExecuteNonQuery();
cmd.CommandText = strcmd;
reader = cmd.ExecuteReader();
reader.Read();
pipe.ID = Convert.ToInt32(reader[0].ToString());
}
catch (System.Exception ex)
{
Console.WriteLine("Pipe of PipeExt error : " + ex.Message);
Console.WriteLine("Reinsert PipeExt");
connect.Close();
return ReInsert(ref pipe);
}
finally
{
//connect.Close();
}
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;
}
/// <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);
}
public bool Delete_PipeExtInfo(CPipeExtInfo pipe)
{
List<string> listcmd = new List<string>();
try
{
string cmd = "DELETE FROM PipeExtInfo where ID = " + pipe.ID;
listcmd.Add(cmd);
ExectueCmd(listcmd);
}
catch (System.Exception ex)
{
Console.WriteLine("Pipe of PipeExt error : " + ex.Message);
return false;
}
return true;
}
private bool SaverTodb(List <PipeSheetData> list)
{
//get the juncinfo. then
if (list == null || list.Count <= 0)
{
return(false);
}
QuickInsert icm = new QuickInsert();
PipeRev rev = new PipeRev();
rev.ListPipe = new List <CPipeInfo>();
rev.ListPipeExt = new List <CPipeExtInfo>();
LoadCmd lcmd = new LoadCmd();
JuncRev junrev = new JuncRev();
lcmd.SetReceiver(junrev);
lcmd.Execute();
string pname = "";
try
{
foreach (PipeSheetData data in list)
{
CPipeInfo info = new CPipeInfo();
CPipeExtInfo extinfo = new CPipeExtInfo();
extinfo.Lane_Way = data.RoadName;
info.PipeName = data.PipeName;
info.Pipe_Category = GetCategory(data.PipeCategory);
info.Pipe_Len = 0;//default
int inid = CheckID(data.InCode, junrev.ListJunc);
int outid = CheckID(data.OutCode, junrev.ListJunc);
info.In_JunID = inid;
info.Out_JunID = outid;
info.In_UpEle = data.In_UpEle;
info.In_BottomEle = data.In_BottomEle;
info.Out_UpEle = data.Out_UpEle;
info.Out_BottomEle = data.Out_UpEle;
info.Shape_Data1 = data.In_R;
info.Shape_Data2 = data.Out_R;
info.ShapeType = GetShapeType(data.ShapeType);
info.ShapeData = data.ShapeData;
info.Material = Getmaterial(data.Matrial);
info.Roughness = data.Roughness;
info.DataSource = GetDataSource(data.DataSource);
info.Record_Date = data.DataTime;
info.ReportDept = data.RecordDept;
info.ReportDate = data.RecordTime;
extinfo.DataIsFull = data.DataFull;
extinfo.LoseReason = data.LoseReson;
extinfo.Remark = data.Remark;
rev.ListPipe.Add(info);
rev.ListPipeExt.Add(extinfo);
pname = data.PipeName;
}
}
catch (Exception e)
{
Console.WriteLine("PipeName : {0} in exception{1}", pname, e.Message);
}
icm.SetReceiver(rev);
icm.Execute();
return(true);
}
private ObservableCollection<Mesage> GetData(int id)
{
var Datas = new ObservableCollection<Mesage>();
TPipeInfo tpipeinfo = new TPipeInfo(App._dbpath, App.PassWord);
TPipeExtInfo tpipeextinfo = new TPipeExtInfo(App._dbpath, App.PassWord);
mPipeInfo = tpipeinfo.Sel_PipeInfoByid(id);
mPipeExtInfo = tpipeextinfo.Sel_PipeExtInfoByPipeId(id);
if (mPipeInfo == null||mPipeExtInfo==null)
{
MessageBox.Show("读取管道数据失败");
return null;
}
Datas.Add(new Mesage { ItemName = "排水管标识码", ValueName = mPipeInfo.PipeName });
Datas.Add(new Mesage { ItemName = "排水系统编码/路名", ValueName = mPipeExtInfo.Lane_Way });
Datas.Add(new Mesage { ItemName = "管道类别", ValueName = GetCategoryName(mPipeInfo.Pipe_Category) });
Datas.Add(new Mesage { ItemName = "起点编码", ValueName = GetJuncName(mPipeInfo.In_JunID) });
Datas.Add(new Mesage { ItemName = "终点编码", ValueName = GetJuncName(mPipeInfo.Out_JunID) });
Datas.Add(new Mesage { ItemName = "起点管顶标高", ValueName = Convert.ToString(mPipeInfo.In_UpEle) });
Datas.Add(new Mesage { ItemName = "起点管底标高", ValueName = Convert.ToString(mPipeInfo.In_BottomEle) });
Datas.Add(new Mesage { ItemName = "终点管顶标高", ValueName = Convert.ToString(mPipeInfo.Out_UpEle) });
Datas.Add(new Mesage { ItemName = "终点管底标高", ValueName = Convert.ToString(mPipeInfo.Out_BottomEle) });
Datas.Add(new Mesage { ItemName = "起点实测管径", ValueName = Convert.ToString(mPipeInfo.Shape_Data1) });
Datas.Add(new Mesage { ItemName = "终点实测管径", ValueName = Convert.ToString(mPipeInfo.Shape_Data2) });
Datas.Add(new Mesage { ItemName = "断面形式", ValueName = GetShapeType(mPipeInfo.ShapeType) });
Datas.Add(new Mesage { ItemName = "断面数据", ValueName = mPipeInfo.ShapeData });
Datas.Add(new Mesage { ItemName = "管道材质", ValueName = Getmaterial(mPipeInfo.Material) });
Datas.Add(new Mesage { ItemName = "管顶糙率", ValueName = Convert.ToString(mPipeInfo.Roughness) });
Datas.Add(new Mesage { ItemName = "数据来源", ValueName = GetDataSource(mPipeInfo.DataSource) });
Datas.Add(new Mesage { ItemName = "数据获取时间", ValueName = Convert.ToString(mPipeInfo.Record_Date) });
Datas.Add(new Mesage { ItemName = "填报单位", ValueName = mPipeInfo.ReportDept });
Datas.Add(new Mesage { ItemName = "填报日期", ValueName = Convert.ToString(mPipeInfo.ReportDate) });
Datas.Add(new Mesage { ItemName = "数据是否完整", ValueName = bool2str(mPipeExtInfo.DataIsFull) });
Datas.Add(new Mesage { ItemName = "数据缺失原因", ValueName = mPipeExtInfo.LoseReason });
Datas.Add(new Mesage { ItemName = "备注", ValueName = mPipeExtInfo.Remark });
return Datas;
}
private ObservableCollection<Mesage> GetData(string pipename)
{
var Datas = new ObservableCollection<Mesage>();
SelectCmd scmd = new SelectCmd();
PipeRev pr = new PipeRev();
pr.PipeName = pipename;
scmd.SetReceiver(pr);
scmd.Execute();
if (pr.ListPipe == null || pr.ListPipe.Count <= 0)
return null;
mPipeInfo = pr.ListPipe.ElementAt(0);
mPipeExtInfo = pr.ListPipeExt.ElementAt(0);
Datas.Add(new Mesage { ItemName = "排水管标识码", ValueName = mPipeInfo.PipeName });
Datas.Add(new Mesage { ItemName = "排水系统编码/路名", ValueName = mPipeExtInfo.Lane_Way });
Datas.Add(new Mesage { ItemName = "管道类别", ValueName = GetCategoryName(mPipeInfo.Pipe_Category) });
Datas.Add(new Mesage { ItemName = "起点编码", ValueName = GetJuncName(mPipeInfo.In_JunID) });
Datas.Add(new Mesage { ItemName = "终点编码", ValueName = GetJuncName(mPipeInfo.Out_JunID) });
Datas.Add(new Mesage { ItemName = "起点管顶标高", ValueName = Convert.ToString(mPipeInfo.In_UpEle) });
Datas.Add(new Mesage { ItemName = "起点管底标高", ValueName = Convert.ToString(mPipeInfo.In_BottomEle) });
Datas.Add(new Mesage { ItemName = "终点管顶标高", ValueName = Convert.ToString(mPipeInfo.Out_UpEle) });
Datas.Add(new Mesage { ItemName = "终点管底标高", ValueName = Convert.ToString(mPipeInfo.Out_BottomEle) });
Datas.Add(new Mesage { ItemName = "起点实测管径", ValueName = Convert.ToString(mPipeInfo.Shape_Data1) });
Datas.Add(new Mesage { ItemName = "终点实测管径", ValueName = Convert.ToString(mPipeInfo.Shape_Data2) });
Datas.Add(new Mesage { ItemName = "断面形式", ValueName = GetShapeType(mPipeInfo.ShapeType) });
Datas.Add(new Mesage { ItemName = "断面数据", ValueName = mPipeInfo.ShapeData });
Datas.Add(new Mesage { ItemName = "管道材质", ValueName = Getmaterial(mPipeInfo.Material) });
Datas.Add(new Mesage { ItemName = "管顶糙率", ValueName = Convert.ToString(mPipeInfo.Roughness) });
Datas.Add(new Mesage { ItemName = "数据来源", ValueName = GetDataSource(mPipeInfo.DataSource) });
Datas.Add(new Mesage { ItemName = "数据获取时间", ValueName = Convert.ToString(mPipeInfo.Record_Date) });
Datas.Add(new Mesage { ItemName = "填报单位", ValueName = mPipeInfo.ReportDept });
Datas.Add(new Mesage { ItemName = "填报日期", ValueName = Convert.ToString(mPipeInfo.ReportDate) });
Datas.Add(new Mesage { ItemName = "数据是否完整", ValueName = bool2str(mPipeExtInfo.DataIsFull) });
Datas.Add(new Mesage { ItemName = "数据缺失原因", ValueName = mPipeExtInfo.LoseReason });
Datas.Add(new Mesage { ItemName = "备注", ValueName = mPipeExtInfo.Remark });
return Datas;
}
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;
}
private ObservableCollection <Mesage> GetData(string pipename)
{
var Datas = new ObservableCollection <Mesage>();
SelectCmd scmd = new SelectCmd();
PipeRev pr = new PipeRev();
pr.PipeName = pipename;
scmd.SetReceiver(pr);
scmd.Execute();
if (pr.ListPipe == null || pr.ListPipe.Count <= 0)
{
return(null);
}
mPipeInfo = pr.ListPipe.ElementAt(0);
mPipeExtInfo = pr.ListPipeExt.ElementAt(0);
Datas.Add(new Mesage {
ItemName = "排水管标识码", ValueName = mPipeInfo.PipeName
});
Datas.Add(new Mesage {
ItemName = "排水系统编码/路名", ValueName = mPipeExtInfo.Lane_Way
});
Datas.Add(new Mesage {
ItemName = "管道类别", ValueName = GetCategoryName(mPipeInfo.Pipe_Category)
});
Datas.Add(new Mesage {
ItemName = "起点编码", ValueName = GetJuncName(mPipeInfo.In_JunID)
});
Datas.Add(new Mesage {
ItemName = "终点编码", ValueName = GetJuncName(mPipeInfo.Out_JunID)
});
Datas.Add(new Mesage {
ItemName = "起点管顶标高", ValueName = Convert.ToString(mPipeInfo.In_UpEle)
});
Datas.Add(new Mesage {
ItemName = "起点管底标高", ValueName = Convert.ToString(mPipeInfo.In_BottomEle)
});
Datas.Add(new Mesage {
ItemName = "终点管顶标高", ValueName = Convert.ToString(mPipeInfo.Out_UpEle)
});
Datas.Add(new Mesage {
ItemName = "终点管底标高", ValueName = Convert.ToString(mPipeInfo.Out_BottomEle)
});
Datas.Add(new Mesage {
ItemName = "起点实测管径", ValueName = Convert.ToString(mPipeInfo.Shape_Data1)
});
Datas.Add(new Mesage {
ItemName = "终点实测管径", ValueName = Convert.ToString(mPipeInfo.Shape_Data2)
});
Datas.Add(new Mesage {
ItemName = "断面形式", ValueName = GetShapeType(mPipeInfo.ShapeType)
});
Datas.Add(new Mesage {
ItemName = "断面数据", ValueName = mPipeInfo.ShapeData
});
Datas.Add(new Mesage {
ItemName = "管道材质", ValueName = Getmaterial(mPipeInfo.Material)
});
Datas.Add(new Mesage {
ItemName = "管顶糙率", ValueName = Convert.ToString(mPipeInfo.Roughness)
});
Datas.Add(new Mesage {
ItemName = "数据来源", ValueName = GetDataSource(mPipeInfo.DataSource)
});
Datas.Add(new Mesage {
ItemName = "数据获取时间", ValueName = Convert.ToString(mPipeInfo.Record_Date)
});
Datas.Add(new Mesage {
ItemName = "填报单位", ValueName = mPipeInfo.ReportDept
});
Datas.Add(new Mesage {
ItemName = "填报日期", ValueName = Convert.ToString(mPipeInfo.ReportDate)
});
Datas.Add(new Mesage {
ItemName = "数据是否完整", ValueName = bool2str(mPipeExtInfo.DataIsFull)
});
Datas.Add(new Mesage {
ItemName = "数据缺失原因", ValueName = mPipeExtInfo.LoseReason
});
Datas.Add(new Mesage {
ItemName = "备注", ValueName = mPipeExtInfo.Remark
});
return(Datas);
}
private ObservableCollection <Mesage> GetData(int id)
{
var Datas = new ObservableCollection <Mesage>();
TPipeInfo tpipeinfo = new TPipeInfo(App._dbpath, App.PassWord);
TPipeExtInfo tpipeextinfo = new TPipeExtInfo(App._dbpath, App.PassWord);
mPipeInfo = tpipeinfo.Sel_PipeInfoByid(id);
mPipeExtInfo = tpipeextinfo.Sel_PipeExtInfoByPipeId(id);
if (mPipeInfo == null || mPipeExtInfo == null)
{
MessageBox.Show("读取管道数据失败");
return(null);
}
Datas.Add(new Mesage {
ItemName = "排水管标识码", ValueName = mPipeInfo.PipeName
});
Datas.Add(new Mesage {
ItemName = "排水系统编码/路名", ValueName = mPipeExtInfo.Lane_Way
});
Datas.Add(new Mesage {
ItemName = "管道类别", ValueName = GetCategoryName(mPipeInfo.Pipe_Category)
});
Datas.Add(new Mesage {
ItemName = "起点编码", ValueName = GetJuncName(mPipeInfo.In_JunID)
});
Datas.Add(new Mesage {
ItemName = "终点编码", ValueName = GetJuncName(mPipeInfo.Out_JunID)
});
Datas.Add(new Mesage {
ItemName = "起点管顶标高", ValueName = Convert.ToString(mPipeInfo.In_UpEle)
});
Datas.Add(new Mesage {
ItemName = "起点管底标高", ValueName = Convert.ToString(mPipeInfo.In_BottomEle)
});
Datas.Add(new Mesage {
ItemName = "终点管顶标高", ValueName = Convert.ToString(mPipeInfo.Out_UpEle)
});
Datas.Add(new Mesage {
ItemName = "终点管底标高", ValueName = Convert.ToString(mPipeInfo.Out_BottomEle)
});
Datas.Add(new Mesage {
ItemName = "起点实测管径", ValueName = Convert.ToString(mPipeInfo.Shape_Data1)
});
Datas.Add(new Mesage {
ItemName = "终点实测管径", ValueName = Convert.ToString(mPipeInfo.Shape_Data2)
});
Datas.Add(new Mesage {
ItemName = "断面形式", ValueName = GetShapeType(mPipeInfo.ShapeType)
});
Datas.Add(new Mesage {
ItemName = "断面数据", ValueName = mPipeInfo.ShapeData
});
Datas.Add(new Mesage {
ItemName = "管道材质", ValueName = Getmaterial(mPipeInfo.Material)
});
Datas.Add(new Mesage {
ItemName = "管顶糙率", ValueName = Convert.ToString(mPipeInfo.Roughness)
});
Datas.Add(new Mesage {
ItemName = "数据来源", ValueName = GetDataSource(mPipeInfo.DataSource)
});
Datas.Add(new Mesage {
ItemName = "数据获取时间", ValueName = Convert.ToString(mPipeInfo.Record_Date)
});
Datas.Add(new Mesage {
ItemName = "填报单位", ValueName = mPipeInfo.ReportDept
});
Datas.Add(new Mesage {
ItemName = "填报日期", ValueName = Convert.ToString(mPipeInfo.ReportDate)
});
Datas.Add(new Mesage {
ItemName = "数据是否完整", ValueName = bool2str(mPipeExtInfo.DataIsFull)
});
Datas.Add(new Mesage {
ItemName = "数据缺失原因", ValueName = mPipeExtInfo.LoseReason
});
Datas.Add(new Mesage {
ItemName = "备注", ValueName = mPipeExtInfo.Remark
});
return(Datas);
}
private List<CPipeExtInfo> Select(string cmd)
{
List<CPipeExtInfo> listpipe = new List<CPipeExtInfo>();
MySqlCommand com;
MySqlDataReader reader;
try
{
if (ConnectionState.Closed == connect.State)
connect.Open();
com = new MySqlCommand(cmd, connect);
reader = com.ExecuteReader();
while (reader.Read())
{
CPipeExtInfo pipe = new CPipeExtInfo();
int i = 0;
string tmp;
pipe.ID = Convert.ToInt32(reader[i++].ToString());
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
pipe.PipeID = Convert.ToInt32(tmp);
pipe.Lane_Way = reader[i++].ToString();
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
pipe.Pressure_Type = Convert.ToInt32(tmp);
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
pipe.Wall_Thick = Convert.ToDouble(tmp);
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
pipe.Liner_Material = Convert.ToInt32(tmp);
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
pipe.Conn_Type = Convert.ToInt32(tmp);
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
pipe.Pipe_Slop = Convert.ToDouble(tmp);
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
pipe.Invert_Silphon = Convert.ToBoolean(Convert.ToInt32(tmp));
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
pipe.Origin_Strue = Convert.ToInt32(tmp);
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
pipe.Constr_Method = Convert.ToInt32(tmp);
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
pipe.Status = Convert.ToInt32(tmp);
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
pipe.DataIsFull = Convert.ToBoolean(Convert.ToInt32(tmp));
pipe.LoseReason = reader[i++].ToString();
pipe.Remark = reader[i++].ToString();
listpipe.Add(pipe);
}
}
catch (System.Exception ex)
{
Console.WriteLine("Pipe of PipeExt error : " + ex.Message);
return null;
}
finally
{
connect.Close();
}
return listpipe;
}
private bool ReInsert(ref CPipeExtInfo pipe)
{
MySqlDataReader reader;
string strcmd = "INSERT INTO PipeExtInfo (PipeID,Lane_Way,Pressure_Type,Wall_Thick,Liner_Material,Conn_Type" +
",Pipe_Slop,Invert_Silphon,Origin_Strue,Constr_Method,Status,DataIsFull,LoseReason,Remark)" +
"values(" +
pipe.PipeID + " ,'" + pipe.Lane_Way + "', " + pipe.Pressure_Type + " ,'" + pipe.Wall_Thick + "', " + pipe.Liner_Material + " , " +
pipe.Conn_Type + " ,'" + pipe.Pipe_Slop + "', " + Convert.ToInt32(pipe.Invert_Silphon) + " , " + pipe.Origin_Strue + " , " +
pipe.Constr_Method + " , " + pipe.Status + " , " + Convert.ToInt32(pipe.DataIsFull) + " ,'" + pipe.LoseReason + "','" + pipe.Remark + "')";
try
{
connect.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connect;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strcmd;
strcmd = "SELECT MAX(ID) AS MAXID FROM PipeExtInfo";
cmd.ExecuteNonQuery();
cmd.CommandText = strcmd;
reader = cmd.ExecuteReader();
reader.Read();
pipe.ID = Convert.ToInt32(reader[0].ToString());
}
catch (System.Exception ex)
{
Console.WriteLine("ReINsert PipeExt Error : " + ex.Message);
return false;
}
Console.WriteLine("Success!");
return true;
}
private bool SaverTodb(List<PipeSheetData> list)
{
//get the juncinfo. then
if (list == null || list.Count <= 0)
return false;
QuickInsert icm = new QuickInsert();
PipeRev rev = new PipeRev();
rev.ListPipe = new List<CPipeInfo>();
rev.ListPipeExt = new List<CPipeExtInfo>();
LoadCmd lcmd = new LoadCmd();
JuncRev junrev = new JuncRev();
lcmd.SetReceiver(junrev);
lcmd.Execute();
string pname = "";
try
{
foreach (PipeSheetData data in list)
{
CPipeInfo info = new CPipeInfo();
CPipeExtInfo extinfo = new CPipeExtInfo();
extinfo.Lane_Way = data.RoadName;
info.PipeName = data.PipeName;
info.Pipe_Category = GetCategory(data.PipeCategory);
info.Pipe_Len = 0;//default
int inid = CheckID(data.InCode, junrev.ListJunc);
int outid = CheckID(data.OutCode, junrev.ListJunc);
info.In_JunID = inid;
info.Out_JunID = outid;
info.In_UpEle = data.In_UpEle;
info.In_BottomEle = data.In_BottomEle;
info.Out_UpEle = data.Out_UpEle;
info.Out_BottomEle = data.Out_UpEle;
info.Shape_Data1 = data.In_R;
info.Shape_Data2 = data.Out_R;
info.ShapeType = GetShapeType(data.ShapeType);
info.ShapeData = data.ShapeData;
info.Material = Getmaterial(data.Matrial);
info.Roughness = data.Roughness;
info.DataSource = GetDataSource(data.DataSource);
info.Record_Date = data.DataTime;
info.ReportDept = data.RecordDept;
info.ReportDate = data.RecordTime;
extinfo.DataIsFull = data.DataFull;
extinfo.LoseReason = data.LoseReson;
extinfo.Remark = data.Remark;
rev.ListPipe.Add(info);
rev.ListPipeExt.Add(extinfo);
pname = data.PipeName;
}
}
catch(Exception e)
{
Console.WriteLine("PipeName : {0} in exception{1}",pname,e.Message);
}
icm.SetReceiver(rev);
icm.Execute();
return true;
}
