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"); } }
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"); } }
/// <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; //} }
/// <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); }
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); //} }
/// <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"); } }