private ObservableCollection<JuncMesage> GetData(int id) { var Datas = new ObservableCollection<JuncMesage>(); SelectCmd scmd = new SelectCmd(); JuncRev rev = new JuncRev(); rev.ID = id; scmd.SetReceiver(rev); scmd.Execute(); if (rev.ListJunc == null || rev.ListJunc.Count <= 0) return null; mJunc = rev.ListJunc.ElementAt(0); mJuncext = rev.ListJuncExt.ElementAt(0); Datas.Add(new JuncMesage { ItemName = "井盖名称", ValueName = mJunc.JuncName }); Datas.Add(new JuncMesage { ItemName = "道路名称", ValueName = mJuncext.Lane_Way }); Datas.Add(new JuncMesage { ItemName = "经度", ValueName = Convert.ToString(mJunc.X_Coor) }); Datas.Add(new JuncMesage { ItemName = "纬度", ValueName = Convert.ToString(mJunc.Y_Coor) }); Datas.Add(new JuncMesage { ItemName = "检查井类别", ValueName = GetCategoryName(mJunc.Junc_Category) }); Datas.Add(new JuncMesage { ItemName = "检查井类型", ValueName = GetType(mJunc.Junc_Type) }); Datas.Add(new JuncMesage { ItemName = "检查井形式", ValueName = GetStyle(mJunc.Junc_Style) }); Datas.Add(new JuncMesage { ItemName = "井深", ValueName = GetDepth(mJunc.Depth) }); Datas.Add(new JuncMesage { ItemName = "井盖所处的地面高程", ValueName = GetDepth(mJunc.Surface_Ele) }); Datas.Add(new JuncMesage { ItemName = "数据来源", ValueName = GetDataSource(mJunc.DataSource) }); Datas.Add(new JuncMesage { ItemName = "数据填报单位", ValueName = mJunc.ReportDept }); Datas.Add(new JuncMesage { ItemName = "数据填报时间", ValueName = Convert.ToString(mJunc.Record_Date) }); Datas.Add(new JuncMesage { ItemName = "管道是否暗接", ValueName = bool2str(mJunc.Junc_Darkjoint) }); Datas.Add(new JuncMesage { ItemName = "污水是否直排", ValueName = bool2str(mJunc.Sewage_Line) }); Datas.Add(new JuncMesage { ItemName = "井盖错误", ValueName = bool2str(mJunc.Junc_Error) }); Datas.Add(new JuncMesage { ItemName = "CCTV检测编号", ValueName = mJunc.CCTV_CheckCode }); Datas.Add(new JuncMesage { ItemName = "数据是否完整", ValueName = bool2str(mJunc.FullData) }); Datas.Add(new JuncMesage { ItemName = "数据缺失原因", ValueName = mJunc.LoseReson }); Datas.Add(new JuncMesage { ItemName = "A上游井口至管顶距离", ValueName = GetDepth(mJunc.Dis[0]) }); Datas.Add(new JuncMesage { ItemName = "A上游井口至管底距离", ValueName = GetDepth(mJunc.Dis[1]) }); Datas.Add(new JuncMesage { ItemName = "A下游井口至管顶距离", ValueName = GetDepth(mJunc.Dis[2]) }); Datas.Add(new JuncMesage { ItemName = "A下游井口至管底距离", ValueName = GetDepth(mJunc.Dis[3]) }); Datas.Add(new JuncMesage { ItemName = "B上游井口至管顶距离", ValueName = GetDepth(mJunc.Dis[4]) }); Datas.Add(new JuncMesage { ItemName = "B上游井口至管底距离", ValueName = GetDepth(mJunc.Dis[5]) }); Datas.Add(new JuncMesage { ItemName = "B下游井口至管顶距离", ValueName = GetDepth(mJunc.Dis[6]) }); Datas.Add(new JuncMesage { ItemName = "B下游井口至管底距离", ValueName = GetDepth(mJunc.Dis[7]) }); Datas.Add(new JuncMesage { ItemName = "备注", ValueName = mJuncext.Remark }); return Datas; }
static void Main(string[] args) { // CUser user = (CUser)(Assembly.Load(filepath).CreateInstance(filepath + ".DBClass." + "CUser")); // if (user != null) // { // System.Console.WriteLine(user.ToString()); // System.Console.ReadLine(); // } InsertCmd icmd = new InsertCmd(); LoadCmd lcmd = new LoadCmd(); SelectCmd scmd = new SelectCmd(); UpdateCmd ucmd = new UpdateCmd(); DeleteCmd dcmd = new DeleteCmd(); ClearCmd ccmd = new ClearCmd(); #region test TUser // UserRev userrev = new UserRev(); // CUser u = new CUser(); // u.UserName = "******"; // u.UserType = 1; // u.PassWord = "******"; // List<CUser> listuser = new List<CUser>(); // listuser.Add(u); // userrev.ListUser = listuser; // icmd.SetReceiver(userrev); // icmd.Execute(); // lcmd.SetReceiver(userrev); // lcmd.Execute(); // System.Console.WriteLine("Element number:{0}", userrev.ListUser.Count); // userrev.UserName = "******"; // scmd.SetReceiver(userrev); // scmd.Execute(); // System.Console.WriteLine("Element number:{0}", userrev.ListUser.Count); // userrev.ListUser.ElementAt(0).PassWord = "******"; // ucmd.SetReceiver(userrev); // ucmd.Execute(); // dcmd.SetReceiver(userrev); // dcmd.Execute(); // ccmd.SetReceiver(userrev); // ccmd.Execute(); #endregion #region test TSystemBase SystemRev sysrev = new SystemRev(); // CSystemBase sysbase = new CSystemBase(); // sysbase.SystemID = "2014722002"; // sysbase.SysName = "test system name"; // List<CSystemBase> list = new List<CSystemBase>(); // list.Add(sysbase); // sysrev.SysList = list; // icmd.SetReceiver(sysrev); // icmd.Execute(); // lcmd.SetReceiver(sysrev); // lcmd.Execute(); // System.Console.WriteLine(sysrev.SysList.Count); // // dcmd.SetReceiver(sysrev); // dcmd.Execute(); #endregion #region test PumpRev PumpRev prev = new PumpRev(); // CPumpStationInfo pump = new CPumpStationInfo(); // pump.PumpName = "testpum"; // List<CPumpStationInfo> list = new List<CPumpStationInfo>(); // list.Add(pump); // prev.ListPump = list; // icmd.SetReceiver(prev); // icmd.Execute(); // lcmd.SetReceiver(prev); // lcmd.Execute(); // System.Console.WriteLine(prev.ListPump.Count); // prev.PumpName = "testpum"; // scmd.SetReceiver(prev); // scmd.Execute(); // System.Console.WriteLine(prev.ListPump.Count); // prev.ListPump.ElementAt(0).PumpName = "Newname"; // ucmd.SetReceiver(prev); // ucmd.Execute(); // dcmd.SetReceiver(prev); // dcmd.Execute(); // ccmd.SetReceiver(prev); // ccmd.Execute(); #endregion #region test OutFallinfo OutFallRev orev = new OutFallRev(); // COutFallInfo outfall = new COutFallInfo(); // COutFallExtInfo outext = new COutFallExtInfo(); // List<COutFallInfo> listoutfall = new List<COutFallInfo>(); // List<COutFallExtInfo> listoutext = new List<COutFallExtInfo>(); // outfall.Category = 1; // outfall.SystemID = "2014722001"; // listoutfall.Add(outfall); // outext.OutFallName = "outfallname"; // listoutext.Add(outext); // orev.OutList = listoutfall; // orev.OutExtList = listoutext; // icmd.SetReceiver(orev); // icmd.Execute(); // lcmd.SetReceiver(orev); // lcmd.Execute(); // System.Console.WriteLine("OutList Number: {0},OutlistExt NUmber : {1}",orev.OutList.Count,orev.OutExtList.Count); // orev.OutExtList.ElementAt(0).OutFallName = "New Name"; // orev.OutList.ElementAt(0).ReportDept = "adasda"; // ucmd.SetReceiver(orev); // ucmd.Execute(); // dcmd.SetReceiver(orev); // dcmd.Execute(); #endregion #region test junction JuncRev jrev = new JuncRev(); //lcmd.SetReceiver(jrev); //lcmd.Execute(); //Console.WriteLine(jrev.ListJunc.Count); //CJuncInfo junc = new CJuncInfo(); //CJuncExtInfo junext = new CJuncExtInfo(); //List<CJuncInfo> listjunc = new List<CJuncInfo>(); //List<CJuncExtInfo> listjuncext = new List<CJuncExtInfo>(); //junc.Junc_Style = 1; //junc.X_Coor = 119.1232443; //junc.Y_Coor = 21.123023123; //junext.Lane_Way = "way name"; //listjuncext.Add(junext); //listjunc.Add(junc); //listjuncext.Add(junext); //jrev.ListJunc = listjunc; //icmd.SetReceiver(jrev); //icmd.Execute(); jrev.JuncName = "ShiN-W1 / LongQ-W1"; scmd.SetReceiver(jrev); scmd.Execute(); System.Console.WriteLine(jrev.ListJunc.Count); //jrev.ListJunc.ElementAt(0).SystemID = "2102323"; //jrev.ListJuncExt.ElementAt(0).Junc_Class = 2; //ucmd.SetReceiver(jrev); //ucmd.Execute(); //dcmd.SetReceiver(jrev); //dcmd.Execute(); //ccmd.SetReceiver(jrev); //ccmd.Execute(); #endregion #region test pipe PipeRev piperev = new PipeRev(); // lcmd.SetReceiver(piperev); // lcmd.Execute(); // System.Console.WriteLine(piperev.ListPipe.Count); // CPipeInfo pipe = new CPipeInfo(); // pipe.PipeName = "Y2-Y3"; // List<CPipeInfo> listpipe = new List<CPipeInfo>(); // listpipe.Add(pipe); // piperev.ListPipe = listpipe; // icmd.SetReceiver(piperev); // icmd.Execute(); //piperev.PipeName = "Y1-Y2"; //scmd.SetReceiver(piperev); //scmd.Execute(); //System.Console.WriteLine(piperev.ListPipe.Count); //System.Console.WriteLine(piperev.ListPipeExt.Count); //System.Console.WriteLine(piperev.ListUS.Count); //System.Console.WriteLine(piperev.ListLog.Count); //System.Console.WriteLine(piperev.ListVideo.Count); // ucmd.SetReceiver(piperev); // ucmd.Execute(); //piperev.ListLog.Clear(); //piperev.ListPipeExt.Clear(); //dcmd.SetReceiver(piperev); //dcmd.Execute(); #endregion System.Console.WriteLine("Done"); System.Console.ReadLine(); }
public bool DoSave() { ObservableCollection<JuncMesage> datas = (ObservableCollection<JuncMesage>)JUNCDG.DataContext; foreach (JuncMesage msg in datas) { try { ParseData(msg); } catch (Exception ex) { System.Console.WriteLine(ex.ToString()); string str = ""; if (ex is ExceptionProcess) { str += ((ExceptionProcess)ex).getReson() + "\n"; } MessageBox.Show(str + "设置数据格式错误:" + msg.ItemName + " " + msg.ValueName); return false; } } UpdateCmd cmd = new UpdateCmd(); JuncRev rev = new JuncRev(); rev.ListJunc = new List<CJuncInfo>(); rev.ListJuncExt = new List<CJuncExtInfo>(); rev.ListJunc.Add(mJunc); rev.ListJuncExt.Add(mJuncext); cmd.SetReceiver(rev); cmd.Execute(); return true; }
protected void DelDB(Cover c) { if (c == null) return; CJuncInfo info = c.juncInfo; DeleteCmd cmd = new DeleteCmd(); JuncRev rev = new JuncRev(); rev.ListJunc = new List<CJuncInfo>(); rev.ListJunc.Add(info); cmd.SetReceiver(rev); cmd.Execute(); }
private int GetJuncId(string name) { JuncRev jr = new JuncRev(); jr.JuncName = name; SelectCmd scmd = new SelectCmd(); scmd.SetReceiver(jr); scmd.Execute(); CJuncInfo ji; if (jr.ListJunc != null && jr.ListJunc.Count >= 0) ji = jr.ListJunc.ElementAt(0); else throw new ExceptionProcess("找不到对应检查井"); return ji.ID; }
private string GetJuncName(int id) { JuncRev jr = new JuncRev(); jr.ID = id; SelectCmd scmd = new SelectCmd(); scmd.SetReceiver(jr); scmd.Execute(); CJuncInfo ji; if (jr.ListJunc != null && jr.ListJunc.Count >= 0) ji = jr.ListJunc.ElementAt(0); else return ""; return ji.JuncName; }
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 bool SaverTodb(List<JuncSheetData> list) { if (list == null || list.Count <= 0) return false; QuickInsert qicm = new QuickInsert(); JuncRev rev = new JuncRev(); rev.ListJunc = new List<CJuncInfo>(); rev.ListJuncExt = new List<CJuncExtInfo>(); foreach (JuncSheetData data in list) { CJuncInfo info = new CJuncInfo(); CJuncExtInfo extinfo = new CJuncExtInfo(); extinfo.Lane_Way = data.RoadName; info.JuncName = data.JuncName; info.Junc_Category = GetCategory(data.JuncCategory); info.Junc_Type = GetType(data.JuncType); info.Y_Coor = data.Latitude; info.X_Coor = data.Longitude; info.Surface_Ele = data.Height; info.Junc_Style = GetStyle(data.JuncStyle); info.Depth = data.Depth; info.Junc_Darkjoint = data.JuncDarkjoint; info.Sewage_Line = data.SewageLine; info.Junc_Error = data.JuncError; info.CCTV_CheckCode = data.CCTV_CheckCode; info.DataSource = GetDataSource(data.DataSource); info.Record_Date = data.DataTime; info.ReportDept = data.RecordDept; info.ReportDate = data.RecordTime; for (int i = 0; i < 8;i++ ) { info.Dis[i] = data.Dis[i]; } info.FullData = data.DataFull; info.LoseReson = data.LoseReson; extinfo.Remark = data.Remark; rev.ListJunc.Add(info); rev.ListJuncExt.Add(extinfo); } qicm.SetReceiver(rev); qicm.Execute(); return true; }