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;
        }
Beispiel #2
0
        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;
        }
Beispiel #4
0
        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();
        }
Beispiel #5
0
 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;
 }
Beispiel #6
0
 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;
 }
Beispiel #7
0
        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;
        }
Beispiel #8
0
        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;
        }