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 { } }
protected void btnAssign_Click(object sender, DirectEventArgs e) { string idList = ""; RowSelectionModel sm = gridList.SelectionModel.Primary as RowSelectionModel; foreach (SelectedRow row in sm.SelectedRows) { idList += row.RecordID + ","; } if (idList.Length > 1) { DataFactory dal = new DataFactory(); dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_OceanImport_Container_SP", new List <IFields>() { dal.CreateIFields() .Append("Option", "UpdateContainerListByMBL") .Append("oc_CtnrNo", txtContainer.Text.Trim().ToUpper()) .Append("oc_SealNo", txtSeal.Text.Trim().ToUpper()) .Append("oc_CtnrSize", CmbSize.Value) .Append("oc_SONo", txtSO.Text.Trim().ToUpper()) .Append("IDList", idList) }).Update(); sm.SelectedRows.Clear(); sm.UpdateSelection(); DataBinder(); txtContainer.Focus(true); } }
/// <summary> /// 播放 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> /// <returns></returns> protected void ButPlayClick(object sender, EventArgs e) { #region // switch (play) // { // case "播放": // play = "暂停"; // ButPlay.Text = "暂停"; // //playline(); // //mythread = new System.Threading.Thread(playline); // //mythread.Start(); // break; // case "暂停": // play = "继续"; // ButPlay.Text = "继续"; // break; // case "继续": // play = "暂停"; // ButPlay.Text = "暂停"; // break; // } #endregion 事件 RowSelectionModel sm = this.GridRoadManager.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.SelectedRows.Add(new SelectedRow(Dt_passcar.Rows[row]["gwsj"].ToString())); sm.UpdateSelection(); row++; Reset(); //playcar(); }
public void DoYesLimit() { try { RowSelectionModel sm = this.GridLane.SelectionModel.Primary as RowSelectionModel; string Id = sm.SelectedRow.RecordID; kkmcId = Id; Hashtable hs = new Hashtable(); hs.Add("id", Id); if (tgsPproperty.DeleteLaneInfo(hs) > 0) { DataRow[] dr = dtKkmc.Select("col0='" + kkmcId + "'"); if (dr.Length > 0) { kkmc = dr[0]["col2"].ToString(); } Notice(GetLangStr("TGSLimitSpeed36", "限速设置"), GetLangStr("TGSLimitSpeed31", "删除成功")); logManager.InsertLogRunning(uName, "删除:[" + kkmc + "]监测点", nowIp, "3"); GetLimitData(HideStation.Value as string); sm.ClearSelections(); sm.UpdateSelection(); } else { Notice(GetLangStr("TGSLimitSpeed19", GetLangStr("TGSLimitSpeed36", "限速设置")), GetLangStr("TGSLimitSpeed32", "删除失败")); } } catch (Exception ex) { ILog.WriteErrorLog(ex); logManager.InsertLogError("TGSLimitSpeed.aspx-DoYesLimit", ex.Message + ";" + ex.StackTrace, "DoYesLimit has an exception"); } }
public void DoYes() { try { RowSelectionModel sm = this.GridDeviceManager.SelectionModel.Primary as RowSelectionModel; sm.SelectedRow.ToBuilder(); string Id = sm.SelectedRow.RecordID; DataRow[] dt = dtname.Select("col0='" + Id + "'"); string jcname = dt[0]["col2"].ToString(); DataRow[] d1 = dtname.Select("col0='" + Id + "'"); string sssb = dt[0]["col14"].ToString(); if (deviceManager.DeleteCctvSetting(Id) > 0) { //LedDataBind(" 1=1 and service_ip='" + HideIpaddress.Value.ToString() + "'"); LedDataBind(" 1=1"); sm.ClearSelections(); sm.UpdateSelection(); logManager.InsertLogRunning(uName, "删除:[" + jcname + "]监测点;实时设备:[" + sssb + "]", nowIp, "3"); Notice(GetLangStr("CCTVStationManager49", "信息提示"), GetLangStr("CCTVStationManager78", "删除成功")); } } catch (Exception ex) { ILog.WriteErrorLog(ex); logManager.InsertLogError("CCTVStationManager.aspx-DoYes", ex.Message + ";" + ex.StackTrace, "DoYes has an exception"); } }
public void BanAddPerson() { RowSelectionModel sm = gpPer.SelectionModel.Primary as RowSelectionModel; if (sm.SelectedRows.Count > 0) { foreach (var r in sm.SelectedRows) { DBSCMDataContext db = new DBSCMDataContext(); var sw = db.Nswinput.First(p => p.Swpersonid == r.RecordID && p.Islearn == 1); Swexamine se = new Swexamine { Swid = sw.Id, Stime = dfInban.SelectedDate, Isfinish = 0, Result = " " }; db.Swexamine.InsertOnSubmit(se); sw.Islearn = 2; db.SubmitChanges(); } Ext.Msg.Alert("提示", "进班成功,共添加" + sm.SelectedRows.Count.ToString() + "人").Show(); SelectedStoreLoad(); sm.SelectedRows.Clear(); sm.UpdateSelection(); LearnStoreLoad(); btn_detail.Disabled = true; btnsw.Disabled = true; Button1.Disabled = true; } }
public void SelectRow(string xpoint, string ypoint, string hphm, string zjwj) { try { //zjwj = "http://192.168.1.249:8001/capture/2016/01/01/13/100000010762/100000010762_黄_鲁NA7506_20160101134049_2_01_0_0_0.JPG"; string HTML = "<div id=\"view\" class=\"car-location path-poup-content\" > " + "<a href=\"#\" class=\"items w-220px\">" + "<span class=\"car-brand\">" + GetLangStr("PathCarQuery36", " 当前车-") + hphm + "</span>" + "<span class=\"car-img path-poup-img\"><img src=\"" + zjwj + "\" onclick=\"zoom(this,false);\" ondblclick=\"OpenPicPage(this.src);\" class=\" move-scale-b\"></span>" + "</a>" + "</div>"; if (xpoint != "") { string js = "BMAP.openWindow('" + HTML + "','" + xpoint + "','" + ypoint + "');"; this.ResourceManager1.RegisterAfterClientInitScript(js); } } catch (Exception ex) { ILog.WriteErrorLog(ex.Message); logManager.InsertLogError("PathCarQuery.aspx-SelectRow", ex.Message + ";" + ex.StackTrace, "SelectRow has an exception"); } RowSelectionModel sm = this.GridRoadManager.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); }
/// <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 clxh, string hphm, string clpp, string csys, List <string> listkkid, int page) { try { int startrow = 0, len = 15, endrow = 15; startrow = startrow + len * page; endrow = endrow + len * page; string xml = "", rsxml = ""; Dt_passcar.Clear(); Dt_passcar = GetData(); string kkid = ""; foreach (string id in listkkid) { kkid += (kkid == "" ? "" : ",") + id; } xml = getxml(startrow, endrow, start, end, cllx, clxh, clpp, csys, hphm, kkid); try { rsxml = client.GetPassCarInfo(xml); } catch (Exception ex) { Notice("提示", "接口服务报错!"); ILog.WriteErrorLog(ex.Message); logManager.InsertLogError("CarStrandQuery.aspx-query", ex.Message + ";" + ex.StackTrace, "query has an exception"); } Dt_passcar.Clear(); Dt_passcar = GetData(); //大数据查询接口 if (rsxml != "" && getlenxml(rsxml) > 0) { CXmlToDataTable(rsxml); if (Dt_passcar != null && Dt_passcar.Rows.Count > 0) { this.StoreInfo.DataSource = Dt_passcar; this.StoreInfo.DataBind(); } labpage.Text = "共" + totalinfo + "条记录,当前" + (page + 1).ToString() + "页,共" + totalpage.Value.ToString() + "页"; } else { this.StoreInfo.RemoveAll(); this.StoreInfo.DataBind(); labpage.Text = "共0条记录,当前0页,共0页"; Notice("提示", "无数据!"); } RowSelectionModel sm = this.GridStation.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); } catch (Exception ex) { ILog.WriteErrorLog(ex.Message); logManager.InsertLogError("CarStrandQuery.aspx-query", ex.Message + ";" + ex.StackTrace, "query has an exception"); } }
public void SelectRow(string xpoint, string ypoint, string stationid, string stationname, string ljcs) { string HTML = ""; string head = "<div class=\"car-location OverCar-Location \">" + "<div class=\"items w-220px\">" + "<span class=\"car-brand text-center\">" + stationname + "[落脚" + ljcs + "次]" + "</span>" + "<section class=\"car-img write-bg\">" + " <div class=\"CarIllegal-list\">" + "<ul class=\"clearfix display-table\">" + //"<li class=\"font-10 fb table-cell w-20px\">序号</li>" + "<li class=\"font-10 fb table-cell w-100px\">时间</li>" + "<li class=\"font-10 fb table-cell w-60px\">方向</li>" + "<li class=\"font-10 fb table-cell w-20px\">落脚时长</li>" + "</ul>" + "<ul class=\"OverCar-data-list clearfix\">"; string content = ""; string end = "</ul></div></section></div></div>"; if (Dt_passcar != null) { DataRow[] drs = Dt_passcar.Select("kkid='" + stationid + "'"); int row = 0; foreach (DataRow dr in drs) { row++; content += " <li>" + " <span class=\"text-center font-10 table-cell w-20px\">" + row.ToString("D2") + "</span>" + " <span class=\"text-cente font-10 table-cell w-100px\">" + dr["kssj"] + "</span>" + " <span class=\"text-cente font-10 table-cell w-60px\">" + dr["fxmc"] + "</span>" + " <span class=\"text-cente font-10 table-cell w-20px\">" + dr["sc"] + "</span>" + "</li>"; } HTML = head + content + end; } else { return; } if (xpoint == "" || ypoint == "") { return; } string js = "BMAP.openWindow('" + HTML + "','" + xpoint + "','" + ypoint + "');"; this.ResourceManager1.RegisterAfterClientInitScript(js); js = "BMAP.GotoXY('" + xpoint + "','" + ypoint + "');"; this.ResourceManager1.RegisterAfterClientInitScript(js); this.ResourceManager1.RegisterAfterClientInitScript("isScroll()"); RowSelectionModel sm = this.GridStation.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); }
public void SelectRow(string hphm, string clpp, string csys, string hpzl, string clzt) { clearmap(); showline("#ff0000", cboplate.VehicleText + txtplate.Text); showline("#00ff00", hphm); //showwin(hphm); showwin(hphm, clpp, csys, hpzl, clzt); RowSelectionModel sm = this.GridRoadManager.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); }
/// <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 DoYes() { List <string> delIds = new List <string>(); try { RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; string ipaddress = Request.ServerVariables.Get("Remote_Addr").ToString(); foreach (SelectedRow row in sm.SelectedRows) { delIds.Add(row.RecordID); if (ipaddress.Length < 9) { ipaddress = "127.0.0.1"; } } if (tgsDataInfo.DeletePeccancyInfo(delIds) > 0) { string log = ""; DataTable dt = Session["datatable"] as DataTable; for (int i = 0; i < delIds.Count; i++) { DataRow[] rows = dt.Select("col0='" + delIds[i] + "'"); logManager.InsertLogRunning(UserLogin.GetUserName(), "违法删除成功:号牌种类[" + rows[0]["col2"].ToString() + "] ,号牌号码[" + rows[0]["col3"].ToString() + "] ,违法记录Id[" + rows[0]["col0"].ToString() + "] ,违法时间[" + rows[0]["col6"].ToString() + "] ,违法地点[" + rows[0]["col8"].ToString() + "] ,违法行为[" + rows[0]["col5"].ToString() + "]", ipaddress, "8", rows[0]["col3"].ToString(), rows[0]["col0"].ToString()); } Notice(GetLangStr("PeccancyQuery42", "信息提示"), GetLangStr("PeccancyQuery43", "删除成功")); string jd = Bll.Common.GetdatabyField(bl, "col8"); string hp = Bll.Common.GetdatabyField(bl, "col3"); string hl = Bll.Common.GetdatabyField(bl, "col2"); string xf = Bll.Common.GetdatabyField(bl, "col11"); // logManager.InsertLogRunning(uName, "违法删除:检测地点:[" + jd + "];号牌种类:[" + hl + "];号牌:[" + hp + "];行驶方向:[" + xf + "]", nowIp, "3"); GetData(); sm.ClearSelections(); sm.UpdateSelection(); } else { logManager.InsertLogRunning(UserLogin.GetUserName(), "违法删除失败", ipaddress, "6", "", ""); } } catch (Exception ex) { ILog.WriteErrorLog(ex); logManager.InsertLogError("PeccancyDelete.aspx-DoYes", ex.Message + ";" + ex.StackTrace, "DoYes has an exception"); } }
public void SelectNode(string station_id, string limitType) { try { HideStation.Value = station_id; GetLimitData(station_id); // SetLimitType(limitType); RowSelectionModel sm = this.GridLane.SelectionModel.Primary as RowSelectionModel; sm.ClearSelections(); sm.UpdateSelection(); } catch (Exception ex) { ILog.WriteErrorLog(ex); logManager.InsertLogError("TGSLimitSpeed.aspx-SelectNode", ex.Message + ";" + ex.StackTrace, "SelectNode has an exception"); } }
public void Banoutqueue() { RowSelectionModel sm = gpPer.SelectionModel.Primary as RowSelectionModel; if (sm.SelectedRows.Count > 0) { foreach (var r in sm.SelectedRows) { DBSCMDataContext db = new DBSCMDataContext(); var sw = db.Nswinput.First(p => p.Swpersonid == r.RecordID && p.Islearn == 1); sw.Islearn = 2; db.SubmitChanges(); } Ext.Msg.Alert("提示", "移除成功,共移除" + sm.SelectedRows.Count.ToString() + "人").Show(); SelectedStoreLoad(); sm.SelectedRows.Clear(); sm.UpdateSelection(); } }
public void setrow(string xh) { try { RowSelectionModel sm = this.GridRoadManager.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.SelectedRows.Add(new SelectedRow(int.Parse(xh))); sm.UpdateSelection(); foreach (SelectedRow row in sm.SelectedRows) { this.GridRoadManager.GetView().FocusRow(row.RowIndex); } } catch (Exception ex) { ILog.WriteErrorLog(ex.Message); logManager.InsertLogError("PathCarQuery.aspx-setrow", ex.Message + ";" + ex.StackTrace, "setrow has an exception"); } }
private void BaseStroeLoad() { var data = from m in dc.VMovefrequency where m.Maindept == SessionBox.GetUserSession().DeptNumber select new { FrequencyID = m.Frequencyid, DeptName = m.Deptname, PlaceName = m.Placename, PosName = m.Posname, Frequency = m.Frequency }; #region 直接linq查询-数据搜索速度慢,先改成上述视图 //var data = from m in dc.Movefrequency // from pos in dc.Position // from pl in dc.Place // from d in dc.Department // where m.Posid == pos.Posid && m.Placeid == pl.Placeid && m.Deptid == d.Deptnumber && m.Maindept==SessionBox.GetUserSession().DeptNumber // select new // { // FrequencyID = m.Frequencyid, // DeptName = d.Deptname, // PlaceName = pl.Placename, // PosName = pos.Posname, // Frequency = m.Frequency // }; #endregion Store1.DataSource = data; Store1.DataBind(); btn_update.Disabled = true; btn_delete.Disabled = true; RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); }
public void SelectRow(string xypoint, string hphm, string clpp, string csys, string hpzl, string clzt) { ShowLine(xypoint); strhphm = hphm; strhpzl = hpzl; DataRow[] drs = Dt_passcar.Select("hphm='" + hphm + "'"); DataTable dt = GetData(); foreach (DataRow dr in drs) { dt.Rows.Add(dr.ItemArray); } winhphm.Title = hphm; clppwin.Text = clpp; csyswin.Text = csys; hpzlwin.Text = (hpzl != "" ? gethpzl(hpzl) : ""); winhphm.Show(); wingcjl.Title = hphm + GetLangStr("FrequentOverCar45", "_过车记录"); wingcjl.Show(); if (dt != null && dt.Rows.Count > 0) { Storegcjl.DataSource = dt; Storegcjl.DataBind(); this.ResourceManager1.RegisterAfterClientInitScript("isScroll()"); } else { Storegcjl.RemoveAll(); Storegcjl.DataBind(); } RowSelectionModel sm1 = this.GridRoadManager.SelectionModel.Primary as RowSelectionModel; sm1.SelectedRows.Clear(); sm1.UpdateSelection(); }
private void storeload() { var data = from m in dc.VMoveplan from k in dc.Moveplan where m.Maindept == SessionBox.GetUserSession().DeptNumber&& m.Id == k.Id select new { m.Name, m.Placeid, m.Placename, m.Deptname, m.Posid, m.Posname, m.Id, m.Personid, m.Starttime, m.Endtime, m.Movestarttime, m.Movestate, Closeremarks = (k.Closeremarks == "录入隐患闭合" ? "" : k.Closeremarks) }; if (!df_begin.IsNull) { data = data.Where(p => p.Starttime >= df_begin.SelectedDate.Date); } if (!df_end.IsNull) { data = data.Where(p => p.Starttime <= df_end.SelectedDate.Date); } if (cbb_person.SelectedIndex > -1) { data = data.Where(p => p.Personid == cbb_person.SelectedItem.Value.Trim()); } if (cbb_place.SelectedIndex > -1) { data = data.Where(p => p.Placeid == Decimal.Parse(cbb_place.SelectedItem.Value.Trim())); } if (cbb_zhiwu.SelectedIndex > -1) { data = data.Where(p => p.Posid == Decimal.Parse(cbb_zhiwu.SelectedItem.Value.Trim())); } //var data = from a in dc.Moveplan // from b in dc.Person // from c in dc.Place // from d in dc.Department // from e in dc.Position // where a.Personid == b.Personnumber && a.Placeid == c.Placeid && b.Deptid == d.Deptnumber && b.Posid==e.Posid && // a.Maindept == SessionBox.GetUserSession().DeptNumber && a.Starttime >= start && a.Starttime <= end // select new // { // b.Name, // c.Placename, // d.Deptname, // e.Posname, // a.Id, // a.Personid, // a.Starttime, // a.Endtime, // a.Movestate // }; Store1.DataSource = data; Store1.DataBind(); btn_delete.Disabled = true; RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); }
private void storeload()//执行查询 { var data = from ct in dc.YChargetable from p in dc.Person from d in dc.Department from d1 in dc.Department where ct.Cperson == p.Personnumber && p.Deptid == d.Deptnumber && ct.Maindept == d1.Deptnumber //&& ct.Maindept == SessionBox.GetUserSession().DeptNumber orderby ct.Cdate descending select new { ct.Recordtime, ct.Cdate, ct.Cbanci, ct.Cperson, ct.Maindept, ct.Rperson, ct.Status, p.Name, d.Deptname, Maindeptname = d1.Deptname, ct.Id }; if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0")) { } else { //初始化模块权限 UserHandle.InitModule(this.PageTag); //如果拥有处理个人信息权限 if (UserHandle.ValidationHandle(PermissionTag.PersonalOnly)) { data = data.Where(p => p.Cperson == SessionBox.GetUserSession().PersonNumber); } else if (UserHandle.ValidationHandle(PermissionTag.Deptall)) { data = data.Where(p => p.Maindept == SessionBox.GetUserSession().DeptNumber); } else { data = data.Where(p => false); } } if (cbbDept.SelectedIndex > 0) { data = data.Where(p => p.Maindept == cbbDept.SelectedItem.Value); } if (cx_date.SelectedValue != null) { data = data.Where(p => p.Cdate == cx_date.SelectedDate); } if (cx_banci.SelectedIndex != -1) { data = data.Where(p => p.Cbanci == cx_banci.SelectedItem.Value); } Store1.DataSource = data; Store1.DataBind(); RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); btnPlan.Disabled = true; btnDel.Disabled = true; }
public void SelectRow(string xpoint, string ypoint, string stationid, string stationname) { try { 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; } DataTable dt = bll.GetIllegalDetail(zqlx, rq, stationid); string HTML = ""; string head = "<div class=\"car-location OverCar-Location \">" + "<div class=\"items w-220px\">" + //"<b class=\"tips-arrow\"></b>" + "<span class=\"car-brand text-center\" >" + stationname + "</span>" + "<section class=\"car-img write-bg\">" + " <div class=\"CarIllegal-list\">" + "<ul class=\"data-list-h clearfix \">" + "<li class=\"w-1 font-10 fb w-150px\">违法行为</li>" + "<li class=\"w-2 font-10 fb w-20px\">数量</li>" + //"<li class=\"w-2 font-10 fb\">正常</li>" + //"<li class=\"w-2 font-10 fb\">比率</li>" + "</ul>" + "<ul class=\"OverCar-data-list clearfix\">"; string content = ""; string end = "</ul></div></section></div></div>"; if (dt != null) { foreach (DataRow dr in dt.Rows) { content += " <li>" + " <span class=\"w-1 text-center font-10 w-150px\">" + dr["wfxwname"] + "</span>" + " <span class=\"w-2 font-10 w-20px\">" + dr["wfzs"] + "</span>" + //" <span class=\"w-2 font-10\">" + dr["zs"] + "</span>" + // " <span class=\"w-2 font-10\">" + dr["wfbl"] + "</span>" + "</li>"; } HTML = head + content + end; } else { return; } string js = "BMAP.openWindow('" + HTML + "','" + xpoint + "','" + ypoint + "');"; this.ResourceManager1.RegisterAfterClientInitScript(js); RowSelectionModel sm = this.GridRoadManager.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); } catch (Exception ex) { ILog.WriteErrorLog(ex); logManager.InsertLogError("CarIllegalQuery.aspx-SelectRow", ex.Message + ";" + ex.StackTrace, "SelectRow has an exception"); } }
private void storeload()//执行查询 { if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0")) { var data = from yh in dc.Getyhinput from d in dc.Department where yh.Unitid == d.Deptnumber orderby yh.Levelname, yh.Intime descending select new { YHPutinID = yh.Yhputinid, yh.Deptid, DeptName = yh.Deptname, PlaceName = yh.Placename, YHContent = yh.Yhcontent, Remarks = "", BanCi = yh.Banci, Name = yh.Name, PCTime = yh.Pctime, Zyid = yh.Typeid, YHType = yh.Typename, yh.Personid, Maindeptid = yh.Unitid, Maindeptname = d.Deptname, yh.Levelid, yh.Levelname, Status = yh.Status }; if (df_begin.SelectedDate <= df_end.SelectedDate && df_begin.SelectedValue != null) { data = data.Where(p => p.PCTime <= df_end.SelectedDate && p.PCTime >= df_begin.SelectedDate); } if (cbb_person.SelectedIndex > -1) { data = data.Where(p => p.Personid == cbb_person.SelectedItem.Value); } if (nf_ID.Text.Trim() != "") { data = data.Where(p => p.YHPutinID == decimal.Parse(nf_ID.Text.Trim())); } if (cbb_part.SelectedIndex > -1) { data = data.Where(p => p.Deptid == cbb_part.SelectedItem.Value.Trim()); } if (cbb_kind.SelectedIndex > -1) { data = data.Where(p => p.Zyid == decimal.Parse(cbb_kind.SelectedItem.Value.Trim())); } if (cbb_status.SelectedIndex > -1) { data = data.Where(p => p.Status == cbb_status.SelectedItem.Value.Trim()); } if (cbbUnit.SelectedIndex > -1) { data = data.Where(p => p.Maindeptid == cbbUnit.SelectedItem.Value); } Store1.DataSource = data; Store1.DataBind(); btn_detail.Disabled = true; RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); } else { //var data = GetSafeInfo.GetYHView(SessionBox.GetUserSession().DeptNumber, df_begin.SelectedDate, df_end.SelectedDate); var data = from yh in dc.Getyhinput from d in dc.Department orderby d.Deptname, yh.Levelname, yh.Status, yh.Intime descending where yh.Unitid == d.Deptnumber //yh.Unitid== SessionBox.GetUserSession().DeptName.Trim() && select new { YHPutinID = yh.Yhputinid, yh.Deptid, DeptName = yh.Deptname, PlaceName = yh.Placename, YHContent = yh.Yhcontent, Remarks = "", BanCi = yh.Banci, Name = yh.Name, PCTime = yh.Pctime, Zyid = yh.Typeid, YHType = yh.Typename, yh.Personid, Maindeptid = yh.Unitid, Maindeptname = d.Deptname, yh.Levelid, yh.Levelname, Status = yh.Status }; if (df_begin.SelectedDate <= df_end.SelectedDate && df_begin.SelectedValue != null) { data = data.Where(p => p.PCTime <= df_end.SelectedDate && p.PCTime >= df_begin.SelectedDate); } if (cbb_person.SelectedIndex > -1) { data = data.Where(p => p.Personid == cbb_person.SelectedItem.Value); } if (nf_ID.Text.Trim() != "") { data = data.Where(p => p.YHPutinID == decimal.Parse(nf_ID.Text.Trim())); } if (cbb_part.SelectedIndex > -1) { data = data.Where(p => p.Deptid == cbb_part.SelectedItem.Value.Trim()); } if (cbb_kind.SelectedIndex > -1) { data = data.Where(p => p.Zyid == decimal.Parse(cbb_kind.SelectedItem.Value.Trim())); } if (cbb_status.SelectedIndex > -1) { data = data.Where(p => p.Status == cbb_status.SelectedItem.Value.Trim()); } if (cbbUnit.SelectedIndex > -1) { data = data.Where(p => p.Maindeptid == cbbUnit.SelectedItem.Value); } Store1.DataSource = data; Store1.DataBind(); btn_detail.Disabled = true; RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); } }
/// <summary> /// 查询 /// </summary> /// <param name="page"></param> /// <returns></returns> private void query(int page) { try { ButAddgrid.Enabled = false; ButPlay.Hidden = true; rdgpsd.Hidden = true; ButPlay.Text = GetLangStr("PathCarQuery34", "播放"); play = GetLangStr("PathCarQuery34", "播放"); string hphm = cboplate.VehicleText + txtplate.Text; string cllx = cbocllx.Text; if (string.IsNullOrEmpty(startdate)) { startdate = start.InnerText; } if (string.IsNullOrEmpty(enddate)) { enddate = end.InnerText; } if (startdate == "" || hphm == "" || cllx == "") { Notice(GetLangStr("PathCarQuery37", "提示"), GetLangStr("PathCarQuery38", "轨迹查询条件不完整")); return; } int startrow = 0, len = 50, endrow = 50; startrow = startrow + len * page; endrow = endrow + len * page; string xml = getxml(startrow, len, hphm, startdate, enddate, cllx); string rsxml = ""; try { rsxml = client.GetPassCarInfo(xml); } catch (Exception ex) { Notice(GetLangStr("PathCarQuery37", "提示"), GetLangStr("PathCarQuery39", "接口服务报错!")); ILog.WriteErrorLog(ex.Message); } Dt_passcar.Clear(); Dt_passcar = GetData(); //大数据查询接口 if (rsxml != "" && getlenxml(rsxml) > 0) { CXmlToDataTable(rsxml, page); //while (getlenxml(rsxml) > endrow) //{ // startrow = startrow + len; // endrow = endrow + len; // xml = getxml(startrow, endrow, hphm, start, end, cllx); // rsxml = client.GetPassCarInfo(xml); // CXmlToDataTable(rsxml); //} if (Dt_passcar != null && Dt_passcar.Rows.Count > 0) { //System.Data.DataView dv = Dt_passcar.DefaultView; //dv.Sort = "gwsj desc"; //Dt_passcar = dv.ToTable(); this.StoreInfo.DataSource = Dt_passcar; this.StoreInfo.DataBind(); ShowStatoin(); ButPlay.Hidden = false; rdgpsd.Hidden = false; RowSelectionModel sm = this.GridRoadManager.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Add(new SelectedRow(0)); sm.UpdateSelection(); } labpage.Text = GetLangStr("PathCarQuery40", "当前") + (page + 1).ToString() + GetLangStr("PathCarQuery41", "页,共") + totalpage.Value.ToString() + GetLangStr("PathCarQuer42", "页(共") + totalinfo + GetLangStr("PathCarQuer43", "条)"); } else { this.StoreInfo.RemoveAll(); this.StoreInfo.DataBind(); string js = "BMAP.Clear();BMAP.ClearLine();"; this.ResourceManager1.RegisterAfterClientInitScript(js); Notice(GetLangStr("PathCarQuery37", "提示"), GetLangStr("PathCarQuery44", "无数据!")); } } catch (Exception ex) { ILog.WriteErrorLog(ex.Message); logManager.InsertLogError("PathCarQuery.aspx-query", ex.Message + ";" + ex.StackTrace, "query has an exception"); } }
private void storeload2()//执行查询 { if (!string.IsNullOrEmpty(txtZGR.Text.Trim())) { if (dateS.SelectedDate > dateE.SelectedDate) { Ext.Msg.Alert("提示", "日期选择有误!").Show(); return; } var data = from yh in dc.Nyhinput from yu in dc.Getyhandhazusing from d in dc.Department from pl in dc.Place from p in dc.Person from de in dc.Department from p2 in dc.Person from yr in dc.Nyinhuanrectification.DefaultIfEmpty() where yh.Yhid == yu.Yhid && yh.Deptid == d.Deptnumber && yh.Placeid == pl.Placeid && yu.Deptnumber == SessionBox.GetUserSession().DeptNumber && yh.Personid == p.Personnumber && yh.Maindeptid == de.Deptnumber && yh.Yhputinid == yr.Yhputinid && yr.Recpersonid == p2.Personnumber orderby yh.Intime descending select new { YHPutinID = yh.Yhputinid, Deptid = d.Deptnumber, DeptName = d.Deptname, pl.Placename, YHContent = yu.Yhcontent, yh.Remarks, BanCi = yh.Banci, yh.Personid, yh.Maindeptid, Maindeptname = de.Deptname, Name = p.Name, PCTime = yh.Pctime, yu.Levelid, yu.Levelname, Zyid = yu.Typeid, Zyname = yu.Typename, yh.Jctype, yh.Status, zgrId = yr.Recpersonid, zgr = p2.Name }; if (dateS.SelectedDate <= dateE.SelectedDate && dateS.SelectedValue != null) { data = data.Where(p => p.PCTime <= dateE.SelectedDate && p.PCTime >= dateS.SelectedDate); } if (txtPerson.Text.Trim() != "") { data = data.Where(p => p.Name.Contains(txtPerson.Text.Trim())); } if (cboDept.SelectedIndex > -1) { data = data.Where(p => p.Deptid == cboDept.SelectedItem.Value.Trim()); } if (cboStatus.SelectedIndex > -1) { data = data.Where(p => p.Status == cboStatus.SelectedItem.Value.Trim()); } if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("2") > -1) { data = data.Where(p => p.Maindeptid == SessionBox.GetUserSession().DeptNumber); } if (txtZGR.Text != "") { data = data.Where(p => p.zgr.Contains(txtZGR.Text)); } Store1.DataSource = data; Store1.DataBind(); btn_detail.Disabled = true; RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); } else { if (dateS.SelectedDate > dateE.SelectedDate) { Ext.Msg.Alert("提示", "日期选择有误!").Show(); return; } var data = from yh in dc.Nyhinput from yu in dc.Getyhandhazusing from d in dc.Department from pl in dc.Place from p in dc.Person from de in dc.Department where yh.Yhid == yu.Yhid && yh.Deptid == d.Deptnumber && yh.Placeid == pl.Placeid && yu.Deptnumber == SessionBox.GetUserSession().DeptNumber && yh.Personid == p.Personnumber && yh.Maindeptid == de.Deptnumber orderby yh.Intime descending select new { YHPutinID = yh.Yhputinid, Deptid = d.Deptnumber, DeptName = d.Deptname, pl.Placename, YHContent = yu.Yhcontent, yh.Remarks, BanCi = yh.Banci, yh.Personid, yh.Maindeptid, Maindeptname = de.Deptname, Name = p.Name, PCTime = yh.Pctime, yu.Levelid, yu.Levelname, Zyid = yu.Typeid, Zyname = yu.Typename, yh.Jctype, yh.Status }; if (dateS.SelectedDate <= dateE.SelectedDate && dateS.SelectedValue != null) { data = data.Where(p => p.PCTime <= dateE.SelectedDate && p.PCTime >= dateS.SelectedDate); } if (!string.IsNullOrEmpty(txtPerson.Text.Trim())) { data = data.Where(p => p.Name.Contains(txtPerson.Text.Trim())); } if (cboDept.SelectedIndex > -1) { data = data.Where(p => p.Deptid == cboDept.SelectedItem.Value.Trim()); } if (cboStatus.SelectedIndex > -1) { data = data.Where(p => p.Status == cboStatus.SelectedItem.Value.Trim()); } if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("2") > -1) { data = data.Where(p => p.Maindeptid == SessionBox.GetUserSession().DeptNumber); } Store1.DataSource = data; Store1.DataBind(); btn_detail.Disabled = true; RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); } }
private void storeload()//执行查询 { if (df_begin.SelectedDate > df_end.SelectedDate) { Ext.Msg.Alert("提示", "日期选择有误!").Show(); return; } var data = from yh in dc.Nyhinput from yu in dc.Getyhandhazusing from d in dc.Department from pl in dc.Place from p in dc.Person from de in dc.Department where yh.Yhid == yu.Yhid && yh.Deptid == d.Deptnumber && yh.Placeid == pl.Placeid && yu.Deptnumber == SessionBox.GetUserSession().DeptNumber && yh.Personid == p.Personnumber && yh.Maindeptid == de.Deptnumber orderby yh.Intime descending select new { YHPutinID = yh.Yhputinid, Deptid = d.Deptnumber, DeptName = d.Deptname, pl.Placename, YHContent = yu.Yhcontent, yh.Remarks, BanCi = yh.Banci, yh.Personid, yh.Maindeptid, Maindeptname = de.Deptname, Name = p.Name, PCTime = yh.Pctime, yu.Levelid, yu.Levelname, Zyid = yu.Typeid, Zyname = yu.Typename, yh.Jctype, yh.Status }; //var data = from yh in dc.Yhview // orderby yh.Maindeptname,yh.Levelname,yh.Status,yh.Intime descending // //where yh.Maindeptname.Trim() == SessionBox.GetUserSession().DeptName.Trim() // select new // { // YHPutinID = yh.Yhputinid, // yh.Deptid, // DeptName = yh.Deptname, // PlaceName = yh.Placename, // YHContent = yh.HBm, // Remarks ="", // BanCi = yh.Banci, // Name = yh.Personname, // PCTime = yh.Pctime, // yh.Zyid, // YHType = yh.Zyname, // yh.Personid, // yh.Maindeptid, // yh.Maindeptname, // yh.Levelid, // yh.Levelname, // Status = yh.Status // }; if (df_begin.SelectedDate <= df_end.SelectedDate && df_begin.SelectedValue != null) { data = data.Where(p => p.PCTime <= df_end.SelectedDate && p.PCTime >= df_begin.SelectedDate); } if (cbb_person.SelectedIndex > -1) { data = data.Where(p => p.Personid == cbb_person.SelectedItem.Value); } if (nf_ID.Text.Trim() != "") { data = data.Where(p => p.YHPutinID == decimal.Parse(nf_ID.Text.Trim())); } if (cbb_part.SelectedIndex > -1) { data = data.Where(p => p.Deptid == cbb_part.SelectedItem.Value.Trim()); } if (cbb_kind.SelectedIndex > -1) { data = data.Where(p => p.Zyid == decimal.Parse(cbb_kind.SelectedItem.Value.Trim())); } if (cbb_status.SelectedIndex > -1) { data = data.Where(p => p.Status == cbb_status.SelectedItem.Value.Trim()); } if (cbb_jctype.SelectedIndex > -1) { data = data.Where(p => p.Jctype == decimal.Parse(cbb_jctype.SelectedItem.Value)); } if (cbbBHstatus.SelectedIndex > -1) { data = data.Where(p => (p.Status == "现场整改" || p.Status == "复查通过") == (cbbBHstatus.SelectedItem.Value == "1")); } if (cbbUnit.SelectedIndex > -1) { data = data.Where(p => p.Maindeptid == cbbUnit.SelectedItem.Value); //if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1) //{ // data = data.Where(p => p.Levelname == "A"); //} } else if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("2") > -1) { data = data.Where(p => p.Maindeptid == SessionBox.GetUserSession().DeptNumber); } Store1.DataSource = data; Store1.DataBind(); btn_detail.Disabled = true; RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; sm.SelectedRows.Clear(); sm.UpdateSelection(); }