/// <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);
}
CUSInfo FindUSInfo(List <CUSInfo> usinfolist, int pipeId)
{
CUSInfo info = null;
info = usinfolist.Find(us => us.PipeID == pipeId);
return(info);
}
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);
}
public bool Insert_USInfo(ref CUSInfo us)
{
MySqlDataReader reader;
MySqlCommand cmd = null;
string strcmd = "INSERT INTO USInfo (PipeID,JobID,DetectDate,DetectDep,Detect_Person,Contacts,Detect_Method,Detect_Dir" +
",Pipe_Stop,Func_Defect,Func_Class,Strcut_Defect,Struct_Class,Repire_Index,Matain_Index,Problem," +
"Video_Filename,ReportDept,ReportDate,DataIsFull,LoseReason,Remark" +
")values(" +
us.PipeID + ",'" + us.JobID + "','" + Convert.ToDateTime(us.DetectDate) + "','" + us.DetectDep + "','" + us.Detect_Person + "','" + us.Contacts + "'," + us.Detect_Method
+ "," + us.Detect_Dir + ",'" + us.Pipe_Stop + "'," + us.Func_Defect + "," + us.Func_Class + "," + us.Strcut_Defect + "," + us.Struct_Class + ",'" +
us.Repair_Index + "','" + us.Matain_Index + "','" + us.Problem + "','" + us.Video_Filename + "','" + us.ReportDept + "','" +
Convert.ToString(us.ReportDate) + "'," + Convert.ToString(us.DataIsFull) + ",'" + us.LoseReason + "','" + us.Remark +
"')";
try
{
if (ConnectionState.Closed == connect.State)
{
connect.Open();
cmd = new MySqlCommand();
count = 0;
}
cmd.Connection = connect;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strcmd;
strcmd = "SELECT MAX(ID) AS MAXID FROM USInfo";
cmd.ExecuteNonQuery();
cmd.CommandText = strcmd;
reader = cmd.ExecuteReader();
reader.Read();
us.ID = Convert.ToInt32(reader[0].ToString());
}
catch (System.Exception ex)
{
Console.WriteLine("Pipe of Usinfo error : " + ex.Message);
Console.WriteLine("Reinsert Usinfo");
connect.Close();
return(ReInsert(ref us));
}
finally
{
// connect.Close();
}
return(true);
}
public bool Delete_USInfo(CUSInfo us)
{
List <string> listcmd = new List <string>();
try
{
string cmd = "DELETE FROM USInfo where ID = " + us.ID;
listcmd.Add(cmd);
ExectueCmd(listcmd);
}
catch (System.Exception ex)
{
Console.WriteLine("Pipe of Usinfo error : " + ex.Message);
return(false);
}
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);
}
private List <CUSInfo> Select(string cmd)
{
List <CUSInfo> listus = new List <CUSInfo>();
MySqlCommand com;
MySqlDataReader reader;
try
{
if (ConnectionState.Closed == connect.State)
{
connect.Open();
}
com = new MySqlCommand(cmd, connect);
reader = com.ExecuteReader();
while (reader.Read())
{
CUSInfo us = new CUSInfo();
int i = 0;
string tmp;
us.ID = Convert.ToInt32(reader[i++].ToString());
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.PipeID = Convert.ToInt32(tmp);
}
us.JobID = reader[i++].ToString();
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.DetectDate = Convert.ToDateTime(tmp);
}
us.DetectDep = reader[i++].ToString();
us.Detect_Person = reader[i++].ToString();
us.Contacts = reader[i++].ToString();
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.Detect_Method = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.Detect_Dir = Convert.ToInt32(tmp);
}
us.Pipe_Stop = reader[i++].ToString();
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.Func_Defect = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.Func_Class = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.Strcut_Defect = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.Struct_Class = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.Repair_Index = Convert.ToInt32(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.Matain_Index = Convert.ToInt32(tmp);
}
us.Problem = reader[i++].ToString();
us.Video_Filename = reader[i++].ToString();
us.ReportDept = reader[i++].ToString();
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.ReportDate = Convert.ToDateTime(tmp);
}
tmp = reader[i++].ToString();
if (tmp != null && tmp.Length > 0)
{
us.DataIsFull = Convert.ToBoolean(Convert.ToInt32(tmp));
}
us.LoseReason = reader[i++].ToString();
us.Remark = reader[i++].ToString();
listus.Add(us);
}
}
catch (System.Exception ex)
{
Console.WriteLine("Pipe of Usinfo error : " + ex.Message);
return(null);
}
finally
{
//connect.Close();
}
return(listus);
}
private ObservableCollection <Mesage> GetData(int id)
{
var Datas = new ObservableCollection <Mesage>();
TUSInfo tusinfo = new TUSInfo(App._dbpath, App.PassWord);
mUSinfo = tusinfo.Sel_USInfoByPipeid(id);
if (mUSinfo == null)
{
MessageBox.Show("读取内窥数据失败");
return(null);
}
Datas.Add(new Mesage {
ItemName = "排水管标识码", ValueName = "-"
});
Datas.Add(new Mesage {
ItemName = "作业编号", ValueName = mUSinfo.JobID
});
Datas.Add(new Mesage {
ItemName = "检测日期", ValueName = Convert.ToString(mUSinfo.DetectDate)
});
Datas.Add(new Mesage {
ItemName = "检测单位", ValueName = mUSinfo.DetectDep
});
Datas.Add(new Mesage {
ItemName = "检测操作人员", ValueName = mUSinfo.Detect_Person
});
Datas.Add(new Mesage {
ItemName = "检测单位联系方式", ValueName = mUSinfo.Contacts
});
Datas.Add(new Mesage {
ItemName = "检测方法", ValueName = GetCheckMethod(mUSinfo.Detect_Method)
});
Datas.Add(new Mesage {
ItemName = "检测方向", ValueName = GetCheckDir(mUSinfo.Detect_Dir)
});
Datas.Add(new Mesage {
ItemName = "封堵情况", ValueName = mUSinfo.Pipe_Stop
});
Datas.Add(new Mesage {
ItemName = "功能性缺失", ValueName = GetFuncDef(mUSinfo.Func_Defect)
});
Datas.Add(new Mesage {
ItemName = "功能性缺失等级", ValueName = GetClass(mUSinfo.Func_Class)
});
Datas.Add(new Mesage {
ItemName = "结构性缺陷", ValueName = GetStructDef(mUSinfo.Strcut_Defect)
});
Datas.Add(new Mesage {
ItemName = "结构性缺陷等级", ValueName = GetClass(mUSinfo.Struct_Class)
});
Datas.Add(new Mesage {
ItemName = "修复指数RI", ValueName = Convert.ToString(mUSinfo.Repair_Index)
});
Datas.Add(new Mesage {
ItemName = "养护指数MI", ValueName = Convert.ToString(mUSinfo.Matain_Index)
});
Datas.Add(new Mesage {
ItemName = "缺陷描述", ValueName = mUSinfo.Problem
});
Datas.Add(new Mesage {
ItemName = "检测影像文件的文件", ValueName = mUSinfo.Video_Filename
});
Datas.Add(new Mesage {
ItemName = "数据填报单位", ValueName = Convert.ToString(mUSinfo.ReportDept)
});
Datas.Add(new Mesage {
ItemName = "填报日期", ValueName = Convert.ToString(mUSinfo.ReportDate)
});
Datas.Add(new Mesage {
ItemName = "数据是否完整", ValueName = bool2str(mUSinfo.DataIsFull)
});
Datas.Add(new Mesage {
ItemName = "数据缺失原因", ValueName = mUSinfo.LoseReason
});
Datas.Add(new Mesage {
ItemName = "备注", ValueName = mUSinfo.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.ListUS == null || pr.ListUS.Count <= 0)
{
return(null);
}
mUSinfo = pr.ListUS.ElementAt(0);
Datas.Add(new Mesage {
ItemName = "排水管标识码", ValueName = pr.PipeName
});
Datas.Add(new Mesage {
ItemName = "作业编号", ValueName = mUSinfo.JobID
});
Datas.Add(new Mesage {
ItemName = "检测日期", ValueName = Convert.ToString(mUSinfo.DetectDate)
});
Datas.Add(new Mesage {
ItemName = "检测单位", ValueName = mUSinfo.DetectDep
});
Datas.Add(new Mesage {
ItemName = "检测操作人员", ValueName = mUSinfo.Detect_Person
});
Datas.Add(new Mesage {
ItemName = "检测单位联系方式", ValueName = mUSinfo.Contacts
});
Datas.Add(new Mesage {
ItemName = "检测方法", ValueName = GetCheckMethod(mUSinfo.Detect_Method)
});
Datas.Add(new Mesage {
ItemName = "检测方向", ValueName = GetCheckDir(mUSinfo.Detect_Dir)
});
Datas.Add(new Mesage {
ItemName = "封堵情况", ValueName = mUSinfo.Pipe_Stop
});
Datas.Add(new Mesage {
ItemName = "功能性缺失", ValueName = GetFuncDef(mUSinfo.Func_Defect)
});
Datas.Add(new Mesage {
ItemName = "功能性缺失等级", ValueName = GetClass(mUSinfo.Func_Class)
});
Datas.Add(new Mesage {
ItemName = "结构性缺陷", ValueName = GetStructDef(mUSinfo.Strcut_Defect)
});
Datas.Add(new Mesage {
ItemName = "结构性缺陷等级", ValueName = GetClass(mUSinfo.Struct_Class)
});
Datas.Add(new Mesage {
ItemName = "修复指数RI", ValueName = Convert.ToString(mUSinfo.Repair_Index)
});
Datas.Add(new Mesage {
ItemName = "养护指数MI", ValueName = Convert.ToString(mUSinfo.Matain_Index)
});
Datas.Add(new Mesage {
ItemName = "缺陷描述", ValueName = mUSinfo.Problem
});
Datas.Add(new Mesage {
ItemName = "检测影像文件的文件", ValueName = mUSinfo.Video_Filename
});
Datas.Add(new Mesage {
ItemName = "数据填报单位", ValueName = Convert.ToString(mUSinfo.ReportDept)
});
Datas.Add(new Mesage {
ItemName = "填报日期", ValueName = Convert.ToString(mUSinfo.ReportDate)
});
Datas.Add(new Mesage {
ItemName = "数据是否完整", ValueName = bool2str(mUSinfo.DataIsFull)
});
Datas.Add(new Mesage {
ItemName = "数据缺失原因", ValueName = mUSinfo.LoseReason
});
Datas.Add(new Mesage {
ItemName = "备注", ValueName = mUSinfo.Remark
});
return(Datas);
}
private bool SaverTodb(List <USSheetData> list)
{
if (list == null || list.Count <= 0)
{
return(false);
}
QuickInsert icm = new QuickInsert();
PipeRev rev = new PipeRev();
LoadCmd lcmd = new LoadCmd();
lcmd.SetReceiver(rev);
lcmd.Execute();
string pname = "";
try
{
foreach (USSheetData data in list)
{
CUSInfo info = new CUSInfo();
info.PipeID = GetPipeID(data.PipeName, rev.ListPipe);
info.JobID = data.JobID;
info.DetectDate = data.CheckDate;
info.DetectDep = data.CheckDept;
info.Detect_Person = data.CheckPerson;
info.Contacts = data.CheckContact;
info.Detect_Method = GetCheckMethod(data.CheckMethod);
info.Detect_Dir = GetCheckDir(data.CheckDirect);
info.Pipe_Stop = data.Pipe_Stop;
info.Func_Defect = GetFuncDef(data.Func_Defect);
info.Func_Class = GetClass(data.Func_Class);
info.Strcut_Defect = GetStructDef(data.Struct_Defect);
info.Struct_Class = GetClass(data.Struct_Class);
if (IsDouble(data.Repire_Index))
{
info.Repair_Index = Convert.ToDouble(data.Repire_Index);
}
else
{
info.Repair_Index = 0;
}
if (IsDouble(data.Matain_Index))
{
info.Matain_Index = Convert.ToDouble(data.Matain_Index);
}
else
{
info.Matain_Index = 0;
}
info.Problem = data.Problem;
info.Video_Filename = data.Video_Filename;
info.ReportDept = data.RecordDept;
info.ReportDate = data.RecordTime;
info.DataIsFull = data.DataFull;
info.LoseReason = data.LoseReson;
info.Remark = data.Remark;
rev.ListUS.Add(info);
pname = data.PipeName;
}
}
catch (Exception e)
{
Console.WriteLine("PipeName : {0} in exception{1}", pname, e.Message);
}
rev.ListPipe.Clear();
rev.ListPipeExt.Clear();
icm.SetReceiver(rev);
icm.Execute();
return(true);
}
