Ejemplo n.º 1
0
 protected void ButResetClick(object sender, DirectEventArgs e)
 {
     try
     {
         ButReset.Hidden   = true;
         ButAddgrid.Hidden = false;
         StoreInfo.RemoveAll();
         StoreInfo.DataBind();
         cmbMdlx.Clear();
         cbocllx.Clear();
         txtbdyy.Text    = "";
         start           = "";
         txtplate.Text   = "";
         txtbkr.Text     = ""; //布控人员
         txtlxdh.Text    = ""; //布控联系电话
         ChkLike.Checked = false;
         cboplate.SetVehicleText("");
         this.ResourceManager1.RegisterAfterClientInitScript("clearTime('');");
         RowSelectionModel sm = this.GridStation.SelectionModel.Primary as RowSelectionModel;
         sm.SelectedRows.Clear();
         sm.UpdateSelection();
         this.ResourceManager1.RegisterAfterClientInitScript(" BMAP.ClearCircle();BMAP.Clear();");
     }
     catch
     {
     }
 }
 /// <summary>
 /// 分页查询
 /// </summary>
 /// <param name="page"></param>
 /// <returns></returns>
 private void Query(int page)
 {
     try
     {
         SetDisbale(page);
         GridRoadManager.Title = GetLangStr("OneLisenceMulCar37", "当前") + (page + 1).ToString() + GetLangStr("OneLisenceMulCar38", "页,共") + totalpage.Value.ToString() + GetLangStr("OneLisenceMulCar39", "页");
         string _hphm;
         if (txtplate.Text != null && txtplate.Text != "")
         {
             _hphm = cboplate.VehicleText + txtplate.Value.ToString();
         }
         else
         {
             _hphm = "";
         }
         DataSet ds = bll.GetOneLisenceMulCarData(startdate, enddate, _hphm, page * 15, 15);
         dt_tp = bll.GetTpcl(startdate, enddate, _hphm);
         if (ds != null && ds.Tables[0].Rows.Count > 0)
         {
             StoreInfo.DataSource = ds.Tables[0];
             StoreInfo.DataBind();
             page = 0;
             hphm = ds.Tables[0].Rows[0]["hphm"].ToString();
             hpzl = ds.Tables[0].Rows[0]["hpzl"].ToString();
             RowSelectionModel sm = this.GridRoadManager.SelectionModel.Primary as RowSelectionModel;
             sm.SelectedRows.Clear();
             sm.SelectedRows.Add(new SelectedRow(0));
             sm.UpdateSelection();
             //showimg(1);
             SelectRow(hphm, hpzl);
         }
         else
         {
             this.Store1.DataSource = CreateTable();
             this.Store1.DataBind();
             StoreInfo.RemoveAll();
             StoreInfo.DataBind();
             this.lblCurpage.Text   = "1";
             this.lblAllpage.Text   = "0";
             this.lblRealcount.Text = "0";
             Notice(GetLangStr("OneLisenceMulCar31", "提示"), GetLangStr("OneLisenceMulCar36", "无套牌信息!"));
         }
     }
     catch (Exception ex)
     {
         ILog.WriteErrorLog(ex);
         logManager.InsertLogError("OneLisenceMulCar.aspx-Query", ex.Message + ";" + ex.StackTrace, "Query has an exception");
     }
 }
Ejemplo n.º 3
0
        public void ButQueryClick(object sender, DirectEventArgs e)
        {
            try
            {
                string departid = cbodepart.Value.ToString();
                string zqlx     = this.CmbCountType.Value.ToString();
                string rq       = "";
                switch (zqlx)
                {
                case "0":
                    //rq = string.Format("{0:D2}", int.Parse(CmbMonth.SelectedItem.Value));
                    rq = CmbYear.SelectedItem.Value + string.Format("{0:D2}", int.Parse(CmbMonth.SelectedItem.Value)) + string.Format("{0:D2}", int.Parse(CmbDay.SelectedItem.Value));
                    break;

                case "1":
                    rq = CmbYear.SelectedItem.Value + string.Format("{0:D2}", int.Parse(CmbMonth.SelectedItem.Value));
                    break;

                case "2":
                    rq = CmbWeek.SelectedItem.Value;
                    break;

                case "3":
                    rq = CmbYear.SelectedItem.Value;
                    break;
                }
                DataSet ds = bll.GetIllegalAnalyze(departid, zqlx, rq, cbonum.Value.ToString());
                this.ResourceManager1.RegisterAfterClientInitScript(" BMAP.ClearCircle();BMAP.ClearTempLine();BMAP.Clear();");
                if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    StoreInfo.DataSource = ds.Tables[0];
                    StoreInfo.DataBind();
                    addstation(ds);
                    dsquery = ds;
                }
                else
                {
                    dsquery = null;
                    StoreInfo.RemoveAll();
                    StoreInfo.DataBind();
                    Notice("提示", "无违法信息!");
                }
            }
            catch (Exception ex)
            {
                ILog.WriteErrorLog(ex);
                logManager.InsertLogError("CarIllegalQuery.aspx-ButQueryClick", ex.Message + ";" + ex.StackTrace, "ButQueryClick has an exception");
            }
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 查询布控
        /// </summary>
        /// <param name="data">坐标集合</param>
        public void QueryMarkArea(string data)
        {
            List <PointF> points    = new List <PointF>();
            object        pointList = JSONToObject <object>(data);
            Array         aPoint    = (Array)pointList;

            for (int i = 0; i < aPoint.Length; i++)
            {
                Dictionary <string, object> spoint = (Dictionary <string, object>)aPoint.GetValue(i);
                PointF PF = new PointF();
                foreach (KeyValuePair <string, object> kv in spoint)
                {
                    if (kv.Key == "lng")
                    {
                        PF.X = float.Parse(kv.Value.ToString());
                    }
                    else if (kv.Key == "lat")
                    {
                        PF.Y = float.Parse(kv.Value.ToString());
                    }
                }
                points.Add(PF);
            }
            PointF        center    = new PointF();
            PointF        maxCenter = new PointF();
            double        area      = 0;
            double        maxLength = 0;
            float         maxX      = 0;
            List <double> lengths   = new List <double>();
            int           s         = polyCentriod(points, points.Count, ref center, ref area);

            for (int i = 0; i < points.Count; i++)
            {
                double l = GetDistance(points[i].Y, points[i].X, center.Y, center.X);
                lengths.Add(l);
                if (l > maxLength)
                {
                    maxLength = l;
                    maxCenter = points[i];
                }
                if (points[i].X > maxX)
                {
                    maxX = points[i].X;
                }
            }
            double Maxl = Math.Sqrt(Math.Abs(maxCenter.X - center.X) * Math.Abs(maxCenter.X - center.X) + Math.Abs(maxCenter.Y - center.Y) * Math.Abs(maxCenter.Y - center.Y)) * 10000;

            string where1 = "sqrt(pow((x_values-" + center.X.ToString() + "),2)+pow((y_values-" + center.Y.ToString() + "),2))*10000 < " + Maxl.ToString();

            DataTable dt = bll.GetStation();
            DataTable dtOut;

            if (dt != null)
            {
                dtOut = dt.Copy();
            }
            else
            {
                return;
            }
            PointF    QueryPoint = new PointF();
            Hashtable hs         = new Hashtable();

            for (int n = dtOut.Rows.Count - 1; n >= 0; n--)
            {
                if (dtOut.Rows[n]["xpoint"].ToString() == "")
                {
                    dtOut.Rows[n].Delete();
                    dtOut.AcceptChanges();
                }
                else
                {
                    QueryPoint.X = float.Parse(dtOut.Rows[n]["xpoint"].ToString());
                    QueryPoint.Y = float.Parse(dtOut.Rows[n]["ypoint"].ToString());
                    if (!IsVisible(QueryPoint, points, maxX))
                    {
                        dtOut.Rows[n].Delete();
                        dtOut.AcceptChanges();
                    }
                }
            }
            StoreInfo.RemoveAll();
            if (dtGetName != null)
            {
                dtGetName = null;
            }
            dtGetName            = dtOut;
            StoreInfo.DataSource = dtOut;
            StoreInfo.DataBind();
            showstation(dtOut);
            //if (dtOut != null && dtOut.Rows.Count > 0)
            //{
            //    string js1 = "CKAll(" + dtOut.Rows.Count + ");";
            //    this.ResourceManager1.RegisterAfterClientInitScript(js1);
            //    RowSelectionModel sm = GridStation.SelectionModel.Primary as RowSelectionModel;
            //    List<string> listid = new List<string>();
            //    List<string> listName = new List<string>();
            //    foreach (SelectedRow row in sm.SelectedRows)
            //    {
            //        listid.Add(row.RecordID);
            //        DataRow[] rows = dtGetName.Select("STATION_ID=" + row.RecordID);
            //        listName.Add(rows[0]["STATION_NAME"].ToString());
            //    }
            //    Session["stationlist"] = listid;
            //    Session["stationlistname"] = listName;

            //}
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 查询布控
        /// </summary>
        /// <param name="data">坐标集合</param>
        public void QueryMarkArea(string data)
        {
            List <PointF> points    = new List <PointF>();
            object        pointList = JSONToObject <object>(data);
            Array         aPoint    = (Array)pointList;

            for (int i = 0; i < aPoint.Length; i++)
            {
                Dictionary <string, object> spoint = (Dictionary <string, object>)aPoint.GetValue(i);
                PointF PF = new PointF();
                foreach (KeyValuePair <string, object> kv in spoint)
                {
                    if (kv.Key == "lng")
                    {
                        PF.X = float.Parse(kv.Value.ToString());
                    }
                    else if (kv.Key == "lat")
                    {
                        PF.Y = float.Parse(kv.Value.ToString());
                    }
                }
                points.Add(PF);
            }
            PointF        center    = new PointF();
            PointF        maxCenter = new PointF();
            double        area      = 0;
            double        maxLength = 0;
            float         maxX      = 0;
            List <double> lengths   = new List <double>();
            int           s         = polyCentriod(points, points.Count, ref center, ref area);

            for (int i = 0; i < points.Count; i++)
            {
                double l = GetDistance(points[i].Y, points[i].X, center.Y, center.X);
                lengths.Add(l);
                if (l > maxLength)
                {
                    maxLength = l;
                    maxCenter = points[i];
                }
                if (points[i].X > maxX)
                {
                    maxX = points[i].X;
                }
            }
            double Maxl = Math.Sqrt(Math.Abs(maxCenter.X - center.X) * Math.Abs(maxCenter.X - center.X) + Math.Abs(maxCenter.Y - center.Y) * Math.Abs(maxCenter.Y - center.Y)) * 10000;

            string where1 = "sqrt(pow((x_values-" + center.X.ToString() + "),2)+pow((y_values-" + center.Y.ToString() + "),2))*10000 < " + Maxl.ToString();

            DataTable dt = bll.GetStation();
            DataTable dtOut;

            if (dt != null)
            {
                dtOut = dt.Copy();
            }
            else
            {
                return;
            }
            PointF    QueryPoint = new PointF();
            Hashtable hs         = new Hashtable();

            for (int n = dtOut.Rows.Count - 1; n >= 0; n--)
            {
                if (dtOut.Rows[n]["xpoint"].ToString() == "")
                {
                    dtOut.Rows[n].Delete();
                    dtOut.AcceptChanges();
                }
                else
                {
                    QueryPoint.X = float.Parse(dtOut.Rows[n]["xpoint"].ToString());
                    QueryPoint.Y = float.Parse(dtOut.Rows[n]["ypoint"].ToString());
                    if (!IsVisible(QueryPoint, points, maxX))
                    {
                        dtOut.Rows[n].Delete();
                        dtOut.AcceptChanges();
                    }
                }
            }
            StoreInfo.RemoveAll();
            StoreInfo.DataSource = dtOut;
            StoreInfo.DataBind();
            showstation(dtOut);
        }
Ejemplo n.º 6
0
 public void cleardata()
 {
     StoreInfo.RemoveAll();
     StoreInfo.DataBind();
 }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        /// <returns></returns>

        public void ButQueryClick(object sender, DirectEventArgs e)
        {
            string _hphm;

            if (txtplate.Text != null && txtplate.Text != "")
            {
                _hphm = cboplate.VehicleText + txtplate.Value.ToString();
            }
            else
            {
                _hphm = "";
            }
            int rows = bll.GetOneLisenceMulCarDataRows(startdate, enddate, _hphm);

            curpage.Value = 0;
            if (rows > 0)
            {
                totalpage.Value = rows / 15 + 1;
                Query(0);
            }
            else
            {
                this.Store1.DataSource = CreateTable();
                this.Store1.DataBind();
                StoreInfo.RemoveAll();
                StoreInfo.DataBind();
                this.lblCurpage.Text   = "1";
                this.lblAllpage.Text   = "0";
                this.lblRealcount.Text = "0";
                Notice(GetLangStr("OneLisenceMulCar31", "提示"), GetLangStr("OneLisenceMulCar36", "无套牌信息!"));
            }
            //try
            //{
            //    string _hphm;
            //    if (txtplate.Text != null && txtplate.Text != "")
            //        _hphm = cboplate.VehicleText + txtplate.Value.ToString();
            //    else
            //        _hphm = "";
            //    DataSet ds = bll.GetOneLisenceMulCarData(startdate, enddate, _hphm);
            //    dt_tp = bll.GetTpcl(startdate, enddate, _hphm);
            //    if (ds != null && ds.Tables[0].Rows.Count > 0)
            //    {
            //        StoreInfo.DataSource = ds.Tables[0];
            //        StoreInfo.DataBind();
            //        page = 0;
            //        hphm = ds.Tables[0].Rows[0]["hphm"].ToString();
            //        hpzl = ds.Tables[0].Rows[0]["hpzl"].ToString();
            //        RowSelectionModel sm = this.GridRoadManager.SelectionModel.Primary as RowSelectionModel;
            //        sm.SelectedRows.Clear();
            //        sm.SelectedRows.Add(new SelectedRow(0));
            //        sm.UpdateSelection();
            //        showimg();
            //        SelectRow(hphm, hpzl);
            //    }
            //    else
            //    {
            //        StoreInfo.RemoveAll();
            //        StoreInfo.DataBind();
            //        Notice("提示", "无套牌信息!");
            //    }
            //}
            //catch (Exception ex)
            //{
            //    ILog.WriteErrorLog(ex);
            //}
        }
Ejemplo n.º 8
0
        /// <summary>
        /// 查询方法
        /// </summary>
        /// <param name="start">开始时间</param>
        /// <param name="end">结束时间</param>
        /// <param name="cllx">车辆类型</param>
        /// <param name="hphm">号牌号码</param>
        /// <param name="gssj">更新时间</param>
        /// <param name="txkk">卡口</param>
        private void query(string start, string end, string cllx, string hphm, string gssj, string txkk, string clpp, string csys)
        {
            try
            {
                int    startrow = 0, len = 30, endrow = 29;
                string xml = "", rsxml = "";
                Dt_passcar.Clear();
                Dt_result.Clear();

                xml = getxml(startrow, endrow, start, end, cllx, hphm, gssj, txkk, clpp, csys);
                try
                {
                    rsxml = client.GetFollowPassCarInfo(xml);
                }
                catch (Exception ex)
                {
                    Notice(GetLangStr("CarQuery42", "提示"), GetLangStr("CarQuery50", "接口服务报错!"));
                    ILog.WriteErrorLog(ex.Message);
                }
                //rsxml = "<?xml version='1.0' encoding='UTF-8'?><Message><Version>1.0</Version><Type>RESPONSE</Type><Body><Return><CarList totalnum='1'><carinfo hphm='京A12345' hpzl ='02' txsl='1' csys='1'><passinfo><kkid>100000010765</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>201410021310</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>201410021312</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>201420011125</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>201420011133</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo></carinfo><carinfo hphm='京A12346' hpzl ='02' txsl='1' csys='1'><passinfo><kkid>100000010765</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>201410021310</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>201410021312</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo></carinfo><carinfo hphm='京A12347' hpzl ='02' txsl='1' csys='1'><passinfo><kkid>201410021310</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>201410021312</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>201420011125</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>201420011133</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo></carinfo></CarList></Return></Body></Message>";

                //rsxml = "<?xml version='1.0' encoding='UTF-8'?><Message><Version>1.0</Version><Type>RESPONSE</Type><Body><Return><CarList totalnum='1'><carinfo hphm='京A12345' hpzl ='02' txsl='1' csys='1'><passinfo><kkid>100000010859</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>3716230000000901</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>201409021069</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>401060000000</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>601051014300</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo></carinfo><carinfo hphm='京A12346' hpzl ='02' txsl='1' csys='1'><passinfo><kkid>601121003000</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>601151003000</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>601121006000</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo></carinfo><carinfo hphm='京A12347' hpzl ='02' txsl='1' csys='1'><passinfo><kkid>601121010000</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>601151003000</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>201420011125</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo><passinfo><kkid>601151003000</kkid><gwsj>2016-04-25 19:03:03 123</gwsj></passinfo></carinfo></CarList></Return></Body></Message>";
                //大数据查询接口
                if (rsxml != "" && getlenxml(rsxml) > 0)
                {
                    CXmlToDataTable(rsxml);
                    while (getlenxml(rsxml) > endrow)
                    {
                        startrow = startrow + len;
                        endrow   = endrow + len;
                        xml      = getxml(startrow, endrow, start, end, cllx, hphm, gssj, txkk, clpp, csys);
                        try
                        {
                            rsxml = client.GetFollowPassCarInfo(xml);
                        }
                        catch (Exception ex)
                        {
                            Notice(GetLangStr("CarQuery42", "提示"), GetLangStr("CarQuery50", "接口服务报错!"));
                            ILog.WriteErrorLog(ex.Message);
                        }
                        CXmlToDataTable(rsxml);
                    }
                }
                if (Dt_result != null && Dt_result.Rows.Count > 0)
                {
                    DataTable dtcopy = Dt_result.Copy();
                    DataRow[] drmain = dtcopy.Select("hphm='" + cboplate.VehicleText + txtplate.Text + "'");
                    if (drmain.Length > 0)
                    {
                        dtcopy.Rows.Remove(drmain[0]);
                    }
                    clearmap();
                    if (dtcopy == null || dtcopy.Rows.Count == 0)
                    {
                        StoreInfo.RemoveAll();
                        StoreInfo.DataBind();
                        Notice(GetLangStr("CarQuery42", "提示"), GetLangStr("CarQuery51", "无伴随车辆!"));
                    }
                    else
                    {
                        DataTable dtCopy = dtcopy.Copy();

                        System.Data.DataView dv = dtcopy.DefaultView;
                        dv.Sort = "txsl";
                        dtCopy  = dv.ToTable();
                        StoreInfo.DataSource = dtCopy;
                        StoreInfo.DataBind();
                        showline("#ff0000", cboplate.VehicleText + txtplate.Text);
                    }
                }
                else
                {
                    StoreInfo.RemoveAll();
                    StoreInfo.DataBind();
                    Notice(GetLangStr("CarQuery42", "提示"), GetLangStr("CarQuery52", "无数据!"));
                }
            }
            catch (Exception ex)
            {
                ILog.WriteErrorLog(ex.Message);
                logManager.InsertLogError("CarQuery.aspx-query", ex.Message + ";" + ex.StackTrace, "query has an exception");
            }
        }