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; }
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; }
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; }
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; }