private void LoadAlarmCamera()
{
SelectCameras sd = new SelectCameras();
DataSet ds = sd.QueryAlarm(Session["userid"].ToString(), Session["cityid"].ToString());
alarmCameraJS = DeviceOutput.GetCameraJSON(ds);
}
private void LoadAlarmCamera()
{
SelectCameras sd = new SelectCameras();
DataSet ds = sd.QueryAlarm(Session["userid"].ToString(), Session["cityid"].ToString());
alarmCameraJS = DeviceOutput.GetCameraJSON(ds);
}
private void LoadCameraInfo(string id)
{
SelectCameras sc = new SelectCameras();
Cameras c = sc.GetCamera(id);
if (c != null)
{
hdfCameraID.Value = c.Id.ToString();
LoadDvsInfo(c.Dvsid, c.Dvsport);
//
txtAssertNo.Text = c.Assertno;
txtCameraNo.Text = c.Caremano;
txtCustomerAddress.Text = c.Customeraddress;
txtCustomerName.Text = c.Customername;
txtHandleNo.Text = c.Handleno;
txtInfo.Text = c.Info;
txtInstalldate.Text = c.Installdate.ToShortDateString();
txtInstallPlace.Text = c.Installplace;
txtJunctionBoxNo.Text = c.Junctionboxno;
//txtLatitude.Text = c.Latitude.ToString();
txtLinkman.Text = c.Linkman;
txtLinkmanPhone.Text = c.Linkman_phone;
//txtLongitude.Text = c.Longitude.ToString();
txtSinglePlace.Text = c.Singleplace;
txtStorageTime.Text = c.Storagetime;
ddlBaudrate.SelectedValue = c.Baudrate;
ddlCameraKind.SelectedValue = c.Caremakind;
ddlCameraType.SelectedValue = c.Carematype;
ddlCodeAddr.SelectedValue = c.Codeaddr;
ddlCodeStream.SelectedValue = c.Codestream;
ddlControlProtocol.SelectedValue = c.Controlprotocol;
ddlCustomerType.SelectedValue = c.Customertype;
ddlDeviceLevel.SelectedValue = c.Devicelevel;
ddlDeviceManu.SelectedValue = c.Devicemanu;
ddlDevicePropertyRight.SelectedValue = c.Devicepropertyright;
ddlDeviceState.SelectedValue = c.Devicestate;
ddlDvsPort.SelectedValue = c.Dvsport;
ddlInstallMode.SelectedValue = c.Installmode;
ddlPaymentType.SelectedValue = c.Paymenttype;
ddlPowerType.SelectedValue = c.Powertype;
ddlPowerVoltage.SelectedValue = c.Powervoltage;
ddlStorageType.SelectedValue = c.Storagetype;
ddlSwitchinMode.SelectedValue = c.Switchinmode;
ddlSwitchinPlace.SelectedValue = c.Switchinplace;
//经纬度
SelectDeviceXy sdxy = new SelectDeviceXy();
Device_Info_xy xy = sdxy.SelectByID(c.Id);
if (xy != null)
{
txtLongitude.Text = xy.LONGITUDE.ToString();
txtLatitude.Text = xy.LATITUDE.ToString();
}
}
}
protected void gvwDvs_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string id = gvwDvs.DataKeys[e.RowIndex].Value.ToString();
//
SelectCameras sc = new SelectCameras();
IList<Cameras> c = sc.GetCameras(Session["userid"].ToString(), Session["cityid"].ToString(), id);
if (c.Count > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "失败", "<script>alert('不能删除，请先删除摄像头！')</script>");
return;
}
DvsManager dm = new DvsManager();
dm.DeleteDvs(id, Session["userid"].ToString());
Query();
}
protected void Page_Load(object sender, EventArgs e)
{
string key = Request.QueryString["root"];
StringBuilder sb = new StringBuilder();
sb.Append("[");
if (key != null && key != "" && key != "source")
{
//编码器
SelectDvs sd = new SelectDvs();
DataSet ds = sd.Query(Session["userid"].ToString(), Session["cityID"].ToString(), "0", "0", "0", "0", "0", key, "0", "0", "0",
"0", "", "", "", "", "", "", "");
if (ds.Tables[0].Rows.Count > 0)
{
int i = 0;
foreach (DataRow dataRow in ds.Tables[0].Rows)
{
if (i > 0)
{
sb.Append(",");
}
sb.Append("{\"text\": \"" + Convert.ToString(dataRow["Customername"]) + "<a target='right' href='ResEncoder.aspx?id=" + Convert.ToString(dataRow["id"]) + "'>编辑</a>\",\"hasChildren\": true}");
i++;
}
}
else
{
SelectCameras sc = new SelectCameras();
DataSet ds1 = sc.Query(key);
int i = 0;
foreach (DataRow dataRow in ds1.Tables[0].Rows)
{
if (i > 0)
{
sb.Append(",");
}
sb.Append("{\"text\": \"" + Convert.ToString(dataRow["dvsno"]) + "(" + Convert.ToString(dataRow["dvsport"]) + ")" + "<a target='right' href='ResCamera.aspx?id=" + Convert.ToString(dataRow["id"]) + "'>编辑</a>\"}");
i++;
}
}
}
sb.Append("]");
Response.ContentType = "application/json";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Write(sb.ToString());
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
string key = Request.QueryString["root"];
StringBuilder sb = new StringBuilder();
sb.Append("[");
if (key != null && key != "" && key != "source")
{
//编码器
SelectDvs sd = new SelectDvs();
DataSet ds = sd.Query(Session["userid"].ToString(), Session["cityID"].ToString(), "0", "0", "0", "0", "0", key, "0", "0", "0",
"0", "", "", "", "", "", "", "");
if (ds.Tables[0].Rows.Count > 0)
{
int i = 0;
foreach (DataRow dataRow in ds.Tables[0].Rows)
{
if (i > 0)
{
sb.Append(",");
}
sb.Append("{\"text\": \"" + Convert.ToString(dataRow["Customername"]) + "<a target='right' href='ResEncoder.aspx?id=" + Convert.ToString(dataRow["id"]) + "'>编辑</a>\",\"hasChildren\": true}");
i++;
}
}
else
{
SelectCameras sc = new SelectCameras();
DataSet ds1 = sc.Query(key);
int i = 0;
foreach (DataRow dataRow in ds1.Tables[0].Rows)
{
if (i > 0)
{
sb.Append(",");
}
sb.Append("{\"text\": \"" + Convert.ToString(dataRow["dvsno"]) + "(" + Convert.ToString(dataRow["dvsport"]) +")" + "<a target='right' href='ResCamera.aspx?id=" + Convert.ToString(dataRow["id"]) + "'>编辑</a>\"}");
i++;
}
}
}
sb.Append("]");
Response.ContentType = "application/json";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Write(sb.ToString());
Response.End();
}
protected void gvwDvs_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string id = gvwDvs.DataKeys[e.RowIndex].Value.ToString();
//
SelectCameras sc = new SelectCameras();
IList <Cameras> c = sc.GetCameras(Session["userid"].ToString(), Session["cityid"].ToString(), id);
if (c.Count > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "失败", "<script>alert('不能删除，请先删除摄像头！')</script>");
return;
}
DvsManager dm = new DvsManager();
dm.DeleteDvs(id, Session["userid"].ToString());
Query();
}
private DataSet DoQuery()
{
SelectCameras sd = new SelectCameras();
DataSet ds;
if (hdfFlag.Value == "0")
{
ds = sd.Query(Session["userid"].ToString(), Session["cityid"].ToString(), txtBasicCondition.Text);
}
else
{
ds = sd.Query(Session["userid"].ToString(), Session["cityid"].ToString(), txtCameraNo.Text.Trim(), txtDvsNo.Text.Trim(), hdfSuburb.Value, ddlCameraType.SelectedValue,
ddlCameraKind.SelectedValue, ddlDeviceManu.SelectedValue, ddlDevicePropertyRight.SelectedValue, ddlDeviceLevel.SelectedValue,
ddlDeviceState.SelectedValue, ddlPowerType.SelectedValue, ddlCustomerType.SelectedValue, txtCustomerName.Text.Trim(),
txtCustomerAddress.Text.Trim(), txtBegin.Text.Trim(), txtEnd.Text.Trim(), txtLanNo.Text.Trim(), txtIP.Text.Trim(), txtAssertNo.Text.Trim());
}
return(ds);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["id"] != null && Request["id"] != "")
{
SelectCameras sc = new SelectCameras();
Cameras c = sc.GetCamera(Request["id"].ToString());
if (c != null)
{
hlkBack.NavigateUrl = "ResEncoder.aspx?id=" + c.Dvsid.ToString();
hlkBack.Enabled = true;
CameraManager cm = new CameraManager();
cm.DeleteCamera(c.Id.ToString(), Session["userid"].ToString());
ltlInfo.Text = "摄像头删除成功！";
}
else
{
ltlInfo.Text = "摄像头不存在！";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["id"] != null && Request["id"] != "")
{
SelectCameras sc = new SelectCameras();
Cameras c = sc.GetCamera(Request["id"].ToString());
if (c != null)
{
hlkBack.NavigateUrl = "ResEncoder.aspx?id=" + c.Dvsid.ToString();
hlkBack.Enabled = true;
CameraManager cm = new CameraManager();
cm.DeleteCamera(c.Id.ToString(), Session["userid"].ToString());
ltlInfo.Text = "摄像头删除成功！";
}
else
{
ltlInfo.Text = "摄像头不存在！";
}
}
}
protected void TreeView1_TreeNodeExpanded(object sender, TreeNodeEventArgs e)
{
if (e.Node.Depth > 0)
{
if (e.Node.Depth == 1)
{
e.Node.ChildNodes.Clear();
SelectDvs sd = new SelectDvs();
DataSet ds = sd.Query(e.Node.Value);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dataRow in ds.Tables[0].Rows)
{
TreeNode tv = new TreeNode();
tv.Value = Convert.ToString(dataRow["id"]);
tv.Text = Convert.ToString(dataRow["Customername"]) + "<a target='right' href='ResEncoder.aspx?id=" + Convert.ToString(dataRow["id"]) + "'>编辑</a>";
TreeNode node = new TreeNode();
node.Text = "";
tv.ChildNodes.Add(node);
tv.Expanded = false;
e.Node.ChildNodes.Add(tv);
}
}
}
else if (e.Node.Depth == 2)
{
e.Node.ChildNodes.Clear();
SelectCameras sc = new SelectCameras();
DataSet ds1 = sc.Query(e.Node.Value);
foreach (DataRow dataRow in ds1.Tables[0].Rows)
{
TreeNode tv = new TreeNode();
tv.Text = Convert.ToString(dataRow["dvsno"]) + "(" + Convert.ToString(dataRow["dvsport"]) + ")" + "<a target='right' href='ResCamera.aspx?id=" + Convert.ToString(dataRow["id"]) + "'>编辑</a>";
e.Node.ChildNodes.Add(tv);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string key = Request.QueryString["key"];
string type = Request.QueryString["type"];
string result = "[]";
if (type == "1") //查询编码器
{
SelectDvs sd = new SelectDvs();
DataSet ds = sd.Query(Session["userid"].ToString(), Session["cityid"].ToString(), key);
result = DeviceOutput.GetDvsJSON(ds);
}
else if (type == "2") //查询摄像头
{
SelectCameras sc = new SelectCameras();
DataSet ds = sc.Query(Session["userid"].ToString(), Session["cityid"].ToString(), key);
result = DeviceOutput.GetCameraJSON(ds);
}
else if (type == "3") //
{
SelectDvs sd = new SelectDvs();
DataSet ds = sd.QueryNormal(Session["userid"].ToString(), Session["cityid"].ToString());
result = DeviceOutput.GetDvsJSON(ds);
}
else if (type == "4")
{
SelectCameras sc = new SelectCameras();
DataSet ds = sc.QueryNormal(Session["userid"].ToString(), Session["cityid"].ToString());
result = DeviceOutput.GetCameraJSON(ds);
}
Response.ContentType = "application/json";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Write("{\"a\":" + result + "}");
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
string key = Request.QueryString["key"];
string type = Request.QueryString["type"];
string result = "[]";
if (type == "1") //查询编码器
{
SelectDvs sd = new SelectDvs();
DataSet ds = sd.Query(Session["userid"].ToString(), Session["cityid"].ToString(), key);
result = DeviceOutput.GetDvsJSON(ds);
}
else if (type == "2") //查询摄像头
{
SelectCameras sc = new SelectCameras();
DataSet ds = sc.Query(Session["userid"].ToString(), Session["cityid"].ToString(), key);
result = DeviceOutput.GetCameraJSON(ds);
}
else if (type == "3") //
{
SelectDvs sd = new SelectDvs();
DataSet ds = sd.QueryNormal(Session["userid"].ToString(), Session["cityid"].ToString());
result = DeviceOutput.GetDvsJSON(ds);
}
else if (type == "4")
{
SelectCameras sc = new SelectCameras();
DataSet ds = sc.QueryNormal(Session["userid"].ToString(), Session["cityid"].ToString());
result = DeviceOutput.GetCameraJSON(ds);
}
Response.ContentType = "application/json";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Write("{\"a\":" + result + "}");
Response.End();
}
private void LoadDvsInfo(string dvsID, string port)
{
hlkNew.NavigateUrl = "ResCamera.aspx?dvsid=" + dvsID;
hlkBack.NavigateUrl = "ResEncoder.aspx?id=" + dvsID;
SelectDvs sd = new SelectDvs();
Dvs dvs = sd.GetDvs(dvsID);
if (dvs != null)
{
txtDvsID.Text = dvs.Dvsno;
txtBroadbandAccessNo.Text = dvs.Broadbandaccessno;
txtCustomerManager.Text = dvs.Customermanager;
txtCustomerManagerPhone.Text = dvs.Customermanager_phone;
txtLanNo.Text = dvs.Lanno;
txtIP.Text = dvs.Ip;
txtGateway.Text = dvs.Gateway;
txtSubnetMask.Text = dvs.Subnetmask;
txtDialupAccount.Text = dvs.Dialupaccount;
txtDialupPassword.Text = dvs.Dialuppassword;
hdfSuburbID.Value = dvs.Suburb;
SelectAreas sa = new SelectAreas();
Areas area =sa.GetArea(dvs.Suburb); //分局
if (area == null)
{
return;
}
txtSuburb.Text = area.Area_Name;
area = sa.GetParentAreas(area.ID.ToString()); //郊县
if (area == null)
{
return;
}
txtTown.Text = area.Area_Name;
//剩余的端口
SelectCameras sc = new SelectCameras();
IList<Cameras> list = sc.GetCameras(Session["userid"].ToString(), Session["cityid"].ToString(), dvsID);
int portNum = DataGlobal.ConvertToInt(dvs.Portnum);
for (int i = 1; i <= portNum; i++)
{
bool flag = false;
for (int j = 0; j < list.Count; j++)
{
if (list[j].Dvsport == i.ToString())
{
flag = true;
}
}
if (i.ToString() == port)
{
flag = false;
}
if (!flag)
{
ListItem ddlone = new ListItem(i.ToString(), i.ToString());
ddlDvsPort.Items.Add(ddlone);
}
}
if (Request["dvsport"] != null && Request["dvsport"] != "")
{
ddlDvsPort.SelectedValue = Request["dvsport"].ToString();
}
btnModify.Enabled = true;
hdfDvsID.Value = dvs.Id.ToString();
}
}
private void LoadCameraInfo(string id)
{
SelectCameras sc = new SelectCameras();
Cameras c = sc.GetCamera(id);
if (c != null)
{
hdfCameraID.Value = c.Id.ToString();
LoadDvsInfo(c.Dvsid, c.Dvsport);
//
txtAssertNo.Text = c.Assertno;
txtCameraNo.Text = c.Caremano;
txtCustomerAddress.Text = c.Customeraddress;
txtCustomerName.Text = c.Customername;
txtHandleNo.Text = c.Handleno;
txtInfo.Text = c.Info;
txtInstalldate.Text = c.Installdate.ToShortDateString();
txtInstallPlace.Text = c.Installplace;
txtJunctionBoxNo.Text = c.Junctionboxno;
//txtLatitude.Text = c.Latitude.ToString();
txtLinkman.Text = c.Linkman;
txtLinkmanPhone.Text = c.Linkman_phone;
//txtLongitude.Text = c.Longitude.ToString();
txtSinglePlace.Text = c.Singleplace;
txtStorageTime.Text = c.Storagetime;
ddlBaudrate.SelectedValue = c.Baudrate;
ddlCameraKind.SelectedValue = c.Caremakind;
ddlCameraType.SelectedValue = c.Carematype;
ddlCodeAddr.SelectedValue = c.Codeaddr;
ddlCodeStream.SelectedValue = c.Codestream;
ddlControlProtocol.SelectedValue = c.Controlprotocol;
ddlCustomerType.SelectedValue = c.Customertype;
ddlDeviceLevel.SelectedValue = c.Devicelevel;
ddlDeviceManu.SelectedValue = c.Devicemanu;
ddlDevicePropertyRight.SelectedValue = c.Devicepropertyright;
ddlDeviceState.SelectedValue = c.Devicestate;
ddlDvsPort.SelectedValue = c.Dvsport;
ddlInstallMode.SelectedValue = c.Installmode;
ddlPaymentType.SelectedValue = c.Paymenttype;
ddlPowerType.SelectedValue = c.Powertype;
ddlPowerVoltage.SelectedValue = c.Powervoltage;
ddlStorageType.SelectedValue = c.Storagetype;
ddlSwitchinMode.SelectedValue = c.Switchinmode;
ddlSwitchinPlace.SelectedValue = c.Switchinplace;
//经纬度
SelectDeviceXy sdxy = new SelectDeviceXy();
Device_Info_xy xy = sdxy.SelectByID(c.Id);
if (xy != null)
{
txtLongitude.Text = xy.LONGITUDE.ToString();
txtLatitude.Text = xy.LATITUDE.ToString();
}
}
}
private void LoadDvsInfo(string dvsID, string port)
{
hlkNew.NavigateUrl = "ResCamera.aspx?dvsid=" + dvsID;
hlkBack.NavigateUrl = "ResEncoder.aspx?id=" + dvsID;
SelectDvs sd = new SelectDvs();
Dvs dvs = sd.GetDvs(dvsID);
if (dvs != null)
{
txtDvsID.Text = dvs.Dvsno;
txtBroadbandAccessNo.Text = dvs.Broadbandaccessno;
txtCustomerManager.Text = dvs.Customermanager;
txtCustomerManagerPhone.Text = dvs.Customermanager_phone;
txtLanNo.Text = dvs.Lanno;
txtIP.Text = dvs.Ip;
txtGateway.Text = dvs.Gateway;
txtSubnetMask.Text = dvs.Subnetmask;
txtDialupAccount.Text = dvs.Dialupaccount;
txtDialupPassword.Text = dvs.Dialuppassword;
hdfSuburbID.Value = dvs.Suburb;
SelectAreas sa = new SelectAreas();
Areas area = sa.GetArea(dvs.Suburb); //分局
if (area == null)
{
return;
}
txtSuburb.Text = area.Area_Name;
area = sa.GetParentAreas(area.ID.ToString()); //郊县
if (area == null)
{
return;
}
txtTown.Text = area.Area_Name;
//剩余的端口
SelectCameras sc = new SelectCameras();
IList <Cameras> list = sc.GetCameras(Session["userid"].ToString(), Session["cityid"].ToString(), dvsID);
int portNum = DataGlobal.ConvertToInt(dvs.Portnum);
for (int i = 1; i <= portNum; i++)
{
bool flag = false;
for (int j = 0; j < list.Count; j++)
{
if (list[j].Dvsport == i.ToString())
{
flag = true;
}
}
if (i.ToString() == port)
{
flag = false;
}
if (!flag)
{
ListItem ddlone = new ListItem(i.ToString(), i.ToString());
ddlDvsPort.Items.Add(ddlone);
}
}
if (Request["dvsport"] != null && Request["dvsport"] != "")
{
ddlDvsPort.SelectedValue = Request["dvsport"].ToString();
}
btnModify.Enabled = true;
hdfDvsID.Value = dvs.Id.ToString();
}
}
protected void TreeView1_TreeNodeExpanded(object sender, TreeNodeEventArgs e)
{
if (e.Node.Depth > 0)
{
if (e.Node.Depth == 1)
{
e.Node.ChildNodes.Clear();
SelectDvs sd = new SelectDvs();
DataSet ds = sd.Query(e.Node.Value);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dataRow in ds.Tables[0].Rows)
{
TreeNode tv = new TreeNode();
tv.Value = Convert.ToString(dataRow["id"]);
tv.Text = Convert.ToString(dataRow["Customername"]) + "<a target='right' href='ResEncoder.aspx?id=" + Convert.ToString(dataRow["id"]) + "'>编辑</a>";
TreeNode node = new TreeNode();
node.Text = "";
tv.ChildNodes.Add(node);
tv.Expanded = false;
e.Node.ChildNodes.Add(tv);
}
}
}
else if (e.Node.Depth == 2)
{
e.Node.ChildNodes.Clear();
SelectCameras sc = new SelectCameras();
DataSet ds1 = sc.Query(e.Node.Value);
foreach (DataRow dataRow in ds1.Tables[0].Rows)
{
TreeNode tv = new TreeNode();
tv.Text = Convert.ToString(dataRow["dvsno"]) + "(" + Convert.ToString(dataRow["dvsport"]) + ")" + "<a target='right' href='ResCamera.aspx?id=" + Convert.ToString(dataRow["id"]) + "'>编辑</a>";
e.Node.ChildNodes.Add(tv);
}
}
}
}
private void LoadCameras()
{
StringBuilder sb = new StringBuilder();
sb.Append("<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"con_list\">");
sb.Append("<tr class=\"ti\">");
sb.Append("<td class=\"ti\">管道ID</td>");
sb.Append("<td class=\"ti\">删除</td>");
sb.Append("<td class=\"ti\">摄像头编号</td>");
sb.Append("<td class=\"ti\">摄像头类型</td>");
sb.Append("<td class=\"ti\">摄像头型号</td>");
sb.Append("<td class=\"ti\">生产厂家</td>");
sb.Append("<td class=\"ti\">产权</td>");
sb.Append("<td class=\"ti\">用户类型</td>");
sb.Append("<td class=\"ti\">用户名称</td>");
sb.Append("</tr>");
SelectCameras sc = new SelectCameras();
IList<Cameras> list = sc.GetCameras(Session["userid"].ToString(), Session["cityid"].ToString(), hdfDvsID.Value);
for (int i = 1; i <= mPortNum; i++)
{
bool flag = false;
sb.Append("<tr>");
sb.Append("<td class=\"t\">" + i.ToString() + "</td>");
for (int j = 0; j < list.Count; j++)
{
Cameras c = list[j];
if (c.Dvsport == i.ToString())
{
sb.Append("<td class=\"t\"><a href=\"DelCamera.aspx?id=" + c.Id.ToString() + "\"><img src=\"../Img/b/icon_del.gif\" /></a></td>");
sb.Append("<td class=\"t\"><a href=\"ResCamera.aspx?id=" + c.Id.ToString() + "\">" + c.Caremano + "</a></td>");
sb.Append("<td class=\"t\">" + c.Carematype + " </td>");
sb.Append("<td class=\"t\">" + c.Caremakind + " </td>");
sb.Append("<td class=\"t\">" + c.Devicemanu + " </td>");
sb.Append("<td class=\"t\">" + c.Devicepropertyright + " </td>");
sb.Append("<td class=\"t\">" + c.Customertype + " </td>");
sb.Append("<td class=\"t\">" + c.Customername + " </td>");
flag = true;
break;
}
}
if (!flag)
{
if (hdfDvsID.Value == "0")
{
sb.Append("<td class=\"t\"> </td>");
}
else
{
sb.Append("<td class=\"t\"><a href=\"ResCamera.aspx?dvsid=" + hdfDvsID.Value + "&dvsPort=" + i.ToString() + "\"><img src=\"../Img/b/icon_cons_add.gif\" /></a></td>");
}
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
}
sb.Append("</tr>");
}
sb.Append("</table>");
ltrCameras.Text = sb.ToString();
}
private void LoadCameras()
{
StringBuilder sb = new StringBuilder();
sb.Append("<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"con_list\">");
sb.Append("<tr class=\"ti\">");
sb.Append("<td class=\"ti\">管道ID</td>");
sb.Append("<td class=\"ti\">删除</td>");
sb.Append("<td class=\"ti\">摄像头编号</td>");
sb.Append("<td class=\"ti\">摄像头类型</td>");
sb.Append("<td class=\"ti\">摄像头型号</td>");
sb.Append("<td class=\"ti\">生产厂家</td>");
sb.Append("<td class=\"ti\">产权</td>");
sb.Append("<td class=\"ti\">用户类型</td>");
sb.Append("<td class=\"ti\">用户名称</td>");
sb.Append("</tr>");
SelectCameras sc = new SelectCameras();
IList <Cameras> list = sc.GetCameras(Session["userid"].ToString(), Session["cityid"].ToString(), hdfDvsID.Value);
for (int i = 1; i <= mPortNum; i++)
{
bool flag = false;
sb.Append("<tr>");
sb.Append("<td class=\"t\">" + i.ToString() + "</td>");
for (int j = 0; j < list.Count; j++)
{
Cameras c = list[j];
if (c.Dvsport == i.ToString())
{
sb.Append("<td class=\"t\"><a href=\"DelCamera.aspx?id=" + c.Id.ToString() + "\"><img src=\"../Img/b/icon_del.gif\" /></a></td>");
sb.Append("<td class=\"t\"><a href=\"ResCamera.aspx?id=" + c.Id.ToString() + "\">" + c.Caremano + "</a></td>");
sb.Append("<td class=\"t\">" + c.Carematype + " </td>");
sb.Append("<td class=\"t\">" + c.Caremakind + " </td>");
sb.Append("<td class=\"t\">" + c.Devicemanu + " </td>");
sb.Append("<td class=\"t\">" + c.Devicepropertyright + " </td>");
sb.Append("<td class=\"t\">" + c.Customertype + " </td>");
sb.Append("<td class=\"t\">" + c.Customername + " </td>");
flag = true;
break;
}
}
if (!flag)
{
if (hdfDvsID.Value == "0")
{
sb.Append("<td class=\"t\"> </td>");
}
else
{
sb.Append("<td class=\"t\"><a href=\"ResCamera.aspx?dvsid=" + hdfDvsID.Value + "&dvsPort=" + i.ToString() + "\"><img src=\"../Img/b/icon_cons_add.gif\" /></a></td>");
}
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
sb.Append("<td class=\"t\"> </td>");
}
sb.Append("</tr>");
}
sb.Append("</table>");
ltrCameras.Text = sb.ToString();
}
private DataSet DoQuery()
{
SelectCameras sd = new SelectCameras();
DataSet ds;
if (hdfFlag.Value == "0")
{
ds = sd.Query(Session["userid"].ToString(), Session["cityid"].ToString(), txtBasicCondition.Text);
}
else
{
ds = sd.Query(Session["userid"].ToString(), Session["cityid"].ToString(), txtCameraNo.Text.Trim(), txtDvsNo.Text.Trim(), hdfSuburb.Value, ddlCameraType.SelectedValue,
ddlCameraKind.SelectedValue, ddlDeviceManu.SelectedValue, ddlDevicePropertyRight.SelectedValue, ddlDeviceLevel.SelectedValue,
ddlDeviceState.SelectedValue, ddlPowerType.SelectedValue, ddlCustomerType.SelectedValue, txtCustomerName.Text.Trim(),
txtCustomerAddress.Text.Trim(), txtBegin.Text.Trim(), txtEnd.Text.Trim(), txtLanNo.Text.Trim(), txtIP.Text.Trim(), txtAssertNo.Text.Trim());
}
return ds;
}
