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();
}