/// <summary> /// 清空数据 /// </summary> private void FrmClear() { VehicleHead.SetVehicleText(""); TxtHphm.Text = null; TxtClxh.Text = null; TxtCjh.Text = null; TxtFdjh.Text = null; TxtHdkl.Text = null; TxtSjxm.Text = null; TxtLxdh.Text = null; TxtSjhm.Text = null; TxtClzt.Text = null; TxtClpp.Text = null; TxtHjhm.Text = null; uiDepartment1.DepertId = "";//.Reset(); CmbHpzl.Value = null; CmbHpzl.Value = null; CmbGPS.Value = null; CmbClzl.Value = null; DateField1.Text = null; TxtRyzk.Text = null; TimeStart.Clear(); TimeEnd.Clear(); TxtKkid.Clear(); }
/// <summary> ///清空数据 /// </summary> private void FrmClear() { //清空车牌号码 VehicleHead.SetVehicleText(""); txtPlateId.Text = ""; //号牌种类 cmbPlateType.Reset(); //违法时间 TxtPeccancyDate.Text = ""; //违法地点 cmbLocation.Reset(); //违法行为 cmbPeccancyType.Reset(); //速度与限速 TxtSpeed.Text = ""; TxtVehCsys.Text = TxtVehClpp.Text = TxtVehCzxm.Text = TxtVehYxqz.Text = TxtVehLxdh.Text = TxtVehClzt.Text = TxtVehSyxz.Text = TxtVehCllx.Text = txtQzsj.Text = txtTxld.Text = txtTxsd.Text = ""; }
/// <summary> ///绑定数据 /// </summary> /// <param name="index"></param> private void SetControlValue(int index) { FrmClear(); DataRow dr = GetRecInfo(index); DataTable dt = new DataTable();// tgsDataInfo.GetPassCarImageUrl(dr[0].ToString()); dt.Columns.Add("col0", typeof(string)); dt.Columns.Add("col1", typeof(string)); dt.Columns.Add("col2", typeof(string)); dt.Columns.Add("col3", typeof(string)); if (!string.IsNullOrEmpty(dr[23].ToString())) { dt.Rows.Add(dr[23].ToString(), "1", "1", dr[23].ToString()); } else { dt.Rows.Add("../Images/NoImage.png", "1", "1", "../Images/NoImage.png"); } if (!string.IsNullOrEmpty(dr[24].ToString())) { dt.Rows.Add(dr[24].ToString(), "2", "1", dr[24].ToString()); } else { dt.Rows.Add("../Images/NoImage.png", "2", "1", "../Images/NoImage.png"); } if (!string.IsNullOrEmpty(dr[25].ToString())) { dt.Rows.Add(dr[25].ToString(), "3", "1", dr[25].ToString()); } else { dt.Rows.Add("../Images/NoImage.png", "3", "1", "../Images/NoImage.png"); } //dt = dataCommon.ChangeDataTablePoliceIp(dt, "col0", "col3", ""); this.StoreImage.DataSource = dt; this.StoreImage.DataBind(); FirstSelection(dt); DataTable dt2 = tgsDataInfo.GetPeccancyInfo(" xh='" + dr[0].ToString() + "'", 0, 1); CurrentId.Value = dr[0].ToString(); if (dt2 != null && dt2.Rows.Count > 0) { string txzXinxi = dt2.Rows[0]["col1"].ToString() + dt2.Rows[0]["col3"].ToString(); DataTable dt3 = GetRedisData.GetData("Passport:" + txzXinxi);//得到车的通行证信息 DataTable dtTxz = null; if (dt3 != null) { dtTxz = MyNet.Atmcs.Uscmcp.Bll.Common.ChangColName(dt3); if (!string.IsNullOrEmpty(dtTxz.Rows[0]["col2"].ToString()) && !string.IsNullOrEmpty(dtTxz.Rows[0]["col3"].ToString())) { txtQzsj.Text = Convert.ToDateTime(dtTxz.Rows[0]["col2"].ToString()).ToString("yyyy-MM-dd") + "--" + Convert.ToDateTime(dtTxz.Rows[0]["col3"].ToString()).ToString("yyyy-MM-dd"); } else { txtQzsj.Text = ""; } if (!string.IsNullOrEmpty(dtTxz.Rows[0]["col5"].ToString())) { txtTxld.Text = dtTxz.Rows[0]["col5"].ToString(); } else { txtTxld.Text = ""; } if (!string.IsNullOrEmpty(dtTxz.Rows[0]["col4"].ToString())) { txtTxsd.Text = dtTxz.Rows[0]["col4"].ToString(); } else { txtTxsd.Text = ""; } lbTxzzt.Text = "取到通行证"; lbTxzzt.StyleSpec = "color:green;"; } else { lbTxzzt.Text = "无通行证"; lbTxzzt.StyleSpec = "color:red;"; } if (dt2.Rows[0]["col3"].ToString().Length < 7) { string Hphm = Session["plateHead"] as string; if (Hphm.Contains(",")) { string[] strs = Hphm.Split(','); Hphm = strs[0]; } else { } VehicleHead.SetVehicleText(Hphm.Substring(0, 1)); txtPlateId.Text = Hphm.Substring(1); } else { string Hphm = dt2.Rows[0]["col3"].ToString(); VehicleHead.SetVehicleText(Hphm.Substring(0, 1)); txtPlateId.Text = Hphm.Substring(1); } cmbPlateType.SelectedItem.Value = dt2.Rows[0]["col1"].ToString(); cmbPlateType.SelectedItem.Text = dt2.Rows[0]["col2"].ToString(); TxtPeccancyDate.Text = dt2.Rows[0]["col6"].ToString(); cmbPeccancyType.SelectedItem.Value = dt2.Rows[0]["col4"].ToString(); cmbLocation.SelectedItem.Value = dt2.Rows[0]["col7"].ToString(); TxtSpeed.Text = dt2.Rows[0]["col12"].ToString(); HidVehCsys.Value = dt2.Rows[0]["col42"].ToString(); TxtVehCsys.Text = dt2.Rows[0]["col43"].ToString(); TxtVehClpp.Text = dt2.Rows[0]["col39"].ToString(); TxtVehCzxm.Text = dt2.Rows[0]["col34"].ToString(); TxtVehYxqz.Text = dt2.Rows[0]["col46"].ToString(); TxtVehLxdh.Text = dt2.Rows[0]["col35"].ToString(); HidVehClzt.Value = dt2.Rows[0]["col44"].ToString(); TxtVehClzt.Text = dt2.Rows[0]["col45"].ToString(); HidVehSyxz.Value = dt2.Rows[0]["col51"].ToString(); TxtVehSyxz.Text = dt2.Rows[0]["col52"].ToString(); HidVehCllx.Value = dt2.Rows[0]["col40"].ToString(); TxtVehCllx.Text = dt2.Rows[0]["col41"].ToString(); string shbj = dt2.Rows[0]["col30"].ToString(); switch (shbj) { case "0": PanAmply.Title = "当前状态:<font color='#000000'> " + dt2.Rows[0]["col15"].ToString() + "</font>"; break; case "1": PanAmply.Title = "当前状态:<font color='#008000'> " + dt2.Rows[0]["col15"].ToString() + "</font>"; break; case "2": PanAmply.Title = "当前状态:<font color='#ff0000'> " + dt2.Rows[0]["col15"].ToString() + "</font>"; break; } } }
/// <summary> /// 获取选中车辆的信息 /// </summary> /// <param name="id"></param> private void select(string id) { try { DataTable da = serviceManager.GetVehicles(" AND ID='" + id + "'"); this.Hidden_id.Value = da.Rows[0]["col0"].ToString(); CmbHpzl.Value = da.Rows[0]["col18"].ToString(); string Hphm = da.Rows[0]["col1"].ToString(); if (!string.IsNullOrEmpty(Hphm)) { VehicleHead.SetVehicleText(Hphm.Substring(0, 1)); TxtHphm.Text = Hphm.Substring(1); } CmbClzl.Value = da.Rows[0]["col16"].ToString(); TxtClpp.Text = da.Rows[0]["col2"].ToString(); TxtClxh.Text = da.Rows[0]["col3"].ToString(); TxtCjh.Text = da.Rows[0]["col4"].ToString(); TxtFdjh.Text = da.Rows[0]["col5"].ToString(); TxtHdkl.Text = da.Rows[0]["col6"].ToString(); string[] lurutiem = (da.Rows[0]["col7"].ToString()).Split(' '); DateField1.Text = lurutiem[0].ToString(); TxtSjxm.Text = da.Rows[0]["col8"].ToString(); TxtLxdh.Text = da.Rows[0]["col10"].ToString(); CmbGPS.Value = da.Rows[0]["col11"].ToString(); TxtSjhm.Text = da.Rows[0]["col9"].ToString(); TxtRyzk.Text = da.Rows[0]["col14"].ToString(); TxtClzt.Text = da.Rows[0]["col13"].ToString(); TxtHjhm.Text = da.Rows[0]["col12"].ToString(); //uiDepartment.DepertName = da.Rows[0]["col16"].ToString(); uiDepartment1.DepertId = da.Rows[0]["col15"].ToString(); try { this.TimeStart.Text = (da.Rows[0]["col19"] == null ? "" : da.Rows[0]["col19"].ToString()); } catch { this.TimeStart.Text = ""; } try { this.TimeEnd.Text = (da.Rows[0]["col20"] == null ? "" : da.Rows[0]["col20"].ToString()); } catch { this.TimeEnd.Text = ""; } try { string kkids = (da.Rows[0]["col21"] == null ? "" : da.Rows[0]["col21"].ToString()); List <string> list = new List <string>(); DataTable dtStation = GetRedisData.GetData("Station:t_cfg_set_station"); foreach (string str in kkids.Split(',')) { list.Add(str); DataRow[] rowsStation = dtStation.Select(" station_id='" + str + "' ", "station_name asc"); if (rowsStation != null && rowsStation.Length > 0) { this.TxtKkid.Text += rowsStation[0]["station_name"].ToString() + "\r\n"; } } Session["stationlist"] = list; } catch { } } catch (Exception ex) { ILog.WriteErrorLog(ex); logManager.InsertLogError("ImportantManager.aspx-select", ex.Message + ";" + ex.StackTrace, "select has an exception"); } }