2018-12-27添加多个手机号码VoiceAlarmSett
2018-12-27 本文已影响0人
1f658716b568
aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="VoicePhoneSettings.aspx.cs" Inherits="THMS.page.SuperOption.VoicePhoneSettings"
EnableEventValidation="false"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>语音电话设置</title>
<link href="../../CommonNew/css/main.css" rel="stylesheet" type="text/css"></link>
<link href="../../CommonNew/css/animate.min.css" rel="stylesheet" type="text/css">
</link>
<script src="../../CommonNew/js/select-widget-min.js" type="text/javascript"></script>
<script src="../../CommonNew/js/jquery-ui.min.js" type="text/javascript"></script>
<script src="../../CommonNew/js/laydate.js" type="text/javascript"></script>
<script src="../../CommonNew/js/tab.js" type="text/javascript"></script>
<script src="../../Common/jquery-easyui-1.3.1/jquery-1.8.0.min.js" type="text/javascript"></script>
<link href="../../Common/jquery-easyui-1.5/themes/default/easyui.css" rel="stylesheet"
type="text/css" />
<link href="../../Common/jquery-easyui-1.5/themes/icon.css" rel="stylesheet" type="text/css" />
<script src="../../Common/jquery-easyui-1.5/jquery.easyui.min.js" type="text/javascript"></script>
<style type="text/css">
.ItemStyleNoDisplay
{
display: none;
}
</style>
<script type="text/javascript" language="javascript">
var PageSize = 100;
$(function () {
Query(1);
});
function Query(PageIndex) {
var NodeNO = $("#QueryNodeNO").val();
var NodeName = $("#QueryNodeName").val();
var EquipNO = $("#QueryEquipNO").val();
var EquipName = $("#QueryEquipName").val();
var NodeVoiceAlarmTel = $("#NodeVoiceAlarmTel").val();
var CompanyName = $("#CompanyName").val();
var HasItSet = $('#HasItSet').val();
$.ajax(
{
type: 'POST',
url: 'VoicePhoneSettings.aspx',
dataType: 'text',
data: { Action: 'Query', NodeNO: NodeNO, NodeName: NodeName, EquipNO: EquipNO, EquipName: EquipName, NodeVoiceAlarmTel: NodeVoiceAlarmTel,
CompanyName: CompanyName, HasItSet: HasItSet, PageSize: PageSize, PageIndex: PageIndex
},
cache: false,
beforeSend: function ShowdivShowChangeQueryInfo() { $(".divShowRoleInfo").show() },
success: function (strs) {
if (strs != "Empty") {
var str = strs.split("|");
if (str[1] == "0") {
document.getElementById("NodePageNation").style.display = "none";
}
else {
document.getElementById("<%=lblPageCount.ClientID %>").innerHTML = str[1];
document.getElementById("<%=lblPageIndex.ClientID %>").innerHTML = PageIndex;
document.getElementById("NodePageNation").style.display = "block";
}
if (str[1] == "1") {
$("#NodePageNation").hide();
$("#ShowInfo").html(str[0]);
}
else if (str[1] == "0") {
$("#NodePageNation").hide();
$("#ShowInfo").html("<div style='text-align:center'>没有匹配的数据</div>");
}
else {
$("#ShowInfo").html(str[0]);
$("#NodePageNation").show();
}
}
else {
$("#NodePageNation").hide();
$("#ShowInfo").html("<div style='text-align:center'>没有匹配的数据</div>");
}
},
complete: function HidedivShowChangeQueryInfo() { $(".divShowRoleInfo").hide() }
});
}
function write(obj) {
var obj2;
obj2 = obj.id;
var node = obj2.split("_Revisebtn");
var NodeISAlarmForSMS = $("#" + node[0] + "_lbNodeISAlarmForSMS").html();
var NodeOneLevelIsOpen = $("#" + node[0] + "_lbNodeOneLevelIsOpen").html();
var NodeTwoLevelIsOpen = $("#" + node[0] + "_lbNodeTwoLevelIsOpen").html();
if (NodeISAlarmForSMS != "是") {
$('#txtNodeAlarmTel').unbind("click");
$("#txtNodeAlarmTel").click(function () {
$('#AddAlarmPhoneNumDiv').dialog('close');
alert("报警未开启,无法添加号码!");
});
} else { }
if (NodeOneLevelIsOpen != "是") {
$('#txtNode_OneLevelSMSTel').unbind("click");
$("#txtNode_OneLevelSMSTel").click(function () {
$('#AddAlarmPhoneNumDiv').dialog('close');
alert("预警未开启,无法添加号码!");
});
} else { }
if (NodeTwoLevelIsOpen != "是") {
$('#txtNode_TwoLevelSMSTel').unbind("click");
$("#txtNode_TwoLevelSMSTel").click(function () {
$('#AddAlarmPhoneNumDiv').dialog('close');
alert("严重报警未开启,无法添加号码!");
});
} else { }
}
//设置语音电话
function Alter(obj) {
write(obj);
// debugger;
var obj2;
obj2 = obj.id;
var node = obj2.split("_Revisebtn");
var NodeNo = $("#" + node[0] + "_lbNodeNo").html();
var NodeName = $("#" + node[0] + "_lbNodeName").html();
var EquipNo = $("#" + node[0] + "_lbEquipNo").html();
var NodeISAlarmForSMS = $("#" + node[0] + "_lbNodeISAlarmForSMS").html();
var NodeVoiceAlarmTel = $("#" + node[0] + "_lbNodeVoiceAlarmTel").html();
var NodeOneLevelIsOpen = $("#" + node[0] + "_lbNodeOneLevelIsOpen").html();
var NodeOneLevelVoiceTel = $("#" + node[0] + "_lbNodeOneLevelVoiceTel").html();
var NodeTwoLevelIsOpen = $("#" + node[0] + "_lbNodeTwoLevelIsOpen").html();
var NodeTwoLevelVoiceTel = $("#" + node[0] + "_lbNodeTwoLevelVoiceTel").html();
document.getElementById("<%=lbNodeNO.ClientID %>").innerHTML = NodeNo;
document.getElementById("<%=lblNodeName.ClientID %>").innerHTML = NodeName;
document.getElementById("<%=lblEquipNo.ClientID %>").innerHTML = EquipNo;
document.getElementById("<%=lblNodeISAlarmForSMS.ClientID %>").innerHTML = NodeISAlarmForSMS;
document.getElementById("<%=lblNodeOneLevelIsOpen.ClientID %>").innerHTML = NodeOneLevelIsOpen;
document.getElementById("<%=lblNodeTwoLevelIsOpen.ClientID %>").innerHTML = NodeTwoLevelIsOpen;
;
$("#txtNodeVoiceAlarmTel").val(NodeVoiceAlarmTel);
$("#txtNodeOneLevelVoiceTel").val(NodeOneLevelVoiceTel);
$("#txtNodeTwoLevelVoiceTel").val(NodeTwoLevelVoiceTel);
var scrollY = document.documentElement.scrollTop || document.body.scrollTop; // 获取鼠标滚动高度
$("#MaintenanceDialog").dialog({
top: scrollY
});
$('#MaintenanceDialog').dialog('open');
}
//保存修改
function UpdateOrSaveTheMaintenance() {
// debugger;
var NodeNo = document.getElementById("<%=lbNodeNO.ClientID %>").innerHTML;
var NodeVoiceAlarmTel = $("#txtNodeVoiceAlarmTel").val();
var NodeOneLevelVoiceTel = $("#txtNodeOneLevelVoiceTel").val();
var NodeTwoLevelVoiceTel = $("#txtNodeTwoLevelVoiceTel").val();
// alert(BelEquipNO);
$.ajax(
{
type: 'POST',
url: 'VoicePhoneSettings.aspx',
dataType: 'text',
data: { Action: 'Update', NodeNo: NodeNo, NodeVoiceAlarmTel: NodeVoiceAlarmTel,
NodeOneLevelVoiceTel: NodeOneLevelVoiceTel,
NodeTwoLevelVoiceTel: NodeTwoLevelVoiceTel
},
cache: false,
success: function (strs) {
alert(strs);
$('#MaintenanceDialog').dialog('close');
var PageIndex = document.getElementById("<%=lblPageIndex.ClientID %>").innerHTML; //显示当前页
Query(PageIndex);
}
});
}
function PageNation(Type) { //网关分页
var PageIndex = document.getElementById("<%=lblPageIndex.ClientID %>").innerHTML; //显示当前页
var PageCount = document.getElementById("<%=lblPageCount.ClientID %>").innerHTML; //显示所有页
if (Type == "Next") {
PageIndex++;
document.getElementById("<%=lblPageIndex.ClientID %>").innerHTML = PageIndex;
}
else if (Type == "Last") {
PageIndex--;
document.getElementById("<%=lblPageIndex.ClientID %>").innerHTML = PageIndex;
}
else if (Type == "First") {
PageIndex = 1;
document.getElementById("<%=lblPageIndex.ClientID %>").innerHTML = PageIndex;
}
else if (Type == "End") {
PageIndex = PageCount;
document.getElementById("<%=lblPageIndex.ClientID %>").innerHTML = PageIndex;
}
else if (Type == "Search") {
PageIndex = document.getElementById("<%=txtNewPageIndex.ClientID %>").value;
document.getElementById("<%=lblPageIndex.ClientID %>").innerHTML = PageIndex;
}
if (parseInt(PageIndex) < 1) {
document.getElementById("<%=lblPageIndex.ClientID %>").innerHTML = 1;
return;
}
else if (parseInt(PageIndex) > parseInt(PageCount)) {
document.getElementById("<%=lblPageIndex.ClientID %>").innerHTML = PageCount;
return;
}
$.ajax(
{
type: 'POST',
url: 'VoicePhoneSettings.aspx',
dataType: 'text',
data: { Action: "NodePageNation", PageIndex: PageIndex, PageSize: PageSize },
cache: false,
success: function (strs) {
if (strs != "Empty") {
$("#ShowInfo").html(strs);
} else {
$("#NodePageNation").hide();
$("#ShowInfo").html("<div style='text-align:center'>没有匹配的数据</div>");
}
}
});
}
function deletedNumRows(obj) {
var ele = document.getElementById("TableTr" + obj); //给每一行设置一个ID
ele.style.display = "none";
$("#txtAddNum" + obj + "").val("");
}
function AddNewRows() {
var tb = document.getElementById('AddNumTable');
var rowNum = tb.rows.length;
$("#AddNumTable").append("<tr class=\"wg_wh_bd\" id=\"TableTr" + (parseInt(rowNum) + 1) + "\"><td class=\"xianc\" align=\"right\"><div class=\"t1\">添加手机号:</div><div class=\"t3\"><input id=\"txtAddNum" + (parseInt(rowNum) + 1) + "\" type=\"text\" /></div><div class=\"t4\"><a onclick=\"deletedNumRows('" + (parseInt(rowNum) + 1) + "');return false;\" class=\"bt_del fl\" href=\"#\"></a></div></td></tr>");
}
var TheAlarmNum;
function AddAlarmPhoneNum(num) {
TheAlarmNum = num;
var tb = document.getElementById('AddNumTable'); //清空table
var rowNum = tb.rows.length;
for (i = 0; i < rowNum; i++) {
tb.deleteRow(i);
rowNum = rowNum - 1;
i = i - 1;
}
var OldNum;
if (num == '0') {
OldNum = $("#txtNodeVoiceAlarmTel").val();
}
else if (num == '1') {
OldNum = $("#txtNodeOneLevelVoiceTel").val();
}
else if (num == '2') {
OldNum = $("#txtNodeTwoLevelVoiceTel").val();
}
if (OldNum == "" || OldNum == undefined) {
$("#AddNumTable").append("<tr class=\"wg_wh_bd\" id=\"TableTr1\"><td class=\"xianc\" align=\"right\"><div class=\"t1\">添加手机号:</div><div class=\"t3\"><input id=\"txtAddNum1\" type=\"text\" /></div><div class=\"t4\"><a onclick=\"deletedNumRows('1');return false;\" href=\"#\" class=\"bt_del fl\"></a></div></td></tr>");
}
else {
var TheNum = OldNum.split(',');
var i;
for (i = 1; i < TheNum.length + 1; i++) {
var labelID = "lbNum" + "" + i + "";
$("#AddNumTable").append("<tr class=\"wg_wh_bd\" id=\"TableTr" + i + "\"><td class=\"xianc\" align=\"right\"><div class=\"t1\">添加手机号:</div><div class=\"t3\"><input id=\'txtAddNum" + i + "\' type=\"text\" value='" + TheNum[i - 1] + "' /></div><div class=\"t4\"><a onclick=\"deletedNumRows(" + i + ");return false;\" href=\"#\" class=\"bt_del fl\"></a></div></td></tr>");
}
$("#AddNumTable").append("<tr class=\"wg_wh_bd\" id=\"TableTr" + i + "\"><td class=\"xianc\" align=\"right\"><div class=\"t1\">添加手机号:</div><div class=\"t3\"><input id=\'txtAddNum" + i + "\' type=\"text\" /></div><div class=\"t4\"><a onclick=\"deletedNumRows(" + i + ");return false;\" href=\"#\" class=\"bt_del fl\"></a></div></td></tr>");
}
var scrollY = document.documentElement.scrollTop || document.body.scrollTop; // 获取鼠标滚动高度
$("#AddAlarmPhoneNumDiv").dialog({
top: scrollY + 100
});
$('#AddAlarmPhoneNumDiv').dialog('open');
}
function AddAlarmPhoneNumCancel() {
$('#AddAlarmPhoneNumDiv').dialog('close');
}
function IsPhoneNum(num) {
var reNum = /^0?1[3|4|5|7|8][0-9]\d{8}$/;
return (reNum.test(num));
}
function AddAlarmPhoneNumbtn() {
var tb = document.getElementById('AddNumTable');
var rowNum = tb.rows.length;
var TheNum = '';
var alarm = 0;
for (var i = 1; i < rowNum + 1; i++) {
var Num = $("#txtAddNum" + i + "").val();
if (Num != "" && (!IsPhoneNum(Num))) {
alarm = '1';
}
else if (Num != "" && (TheNum.indexOf(Num) > -1)) {
alarm = '1';
}
else {
if (Num != "")
TheNum = TheNum + Num + ',';
}
}
if (alarm == '1') {
alert("请检查手机号");
}
else {
TheNum = TheNum.substring(0, TheNum.length - 1);
if (TheAlarmNum == '0') {
$("#txtNodeVoiceAlarmTel").val(TheNum);
}
else if (TheAlarmNum == '1') {
$("#txtNodeOneLevelVoiceTel").val(TheNum);
}
else if (TheAlarmNum == '2') {
$("#txtNodeTwoLevelVoiceTel").val(TheNum);
}
$('#AddAlarmPhoneNumDiv').dialog('close');
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
</div>
<div class="nbg_title2">
<span>语音电话设置</span>
</div>
<div class="search_dtj v_middle">
<div class="left">
<div class="t1">
<div class="txt">
传感器名称:</div>
<div class="input">
<input type="text" class="bd" id="QueryNodeName" name="QueryNodeName" />
</div>
</div>
<div class="t1">
<div class="txt">
网关名称:</div>
<div class="input">
<input type="text" class="bd" id="QueryEquipName" name="QueryEquipName" />
</div>
</div>
<div class="t1">
<div class="txt">
语音报警电话:</div>
<div class="input">
<input type="text" class="bd" id="NodeVoiceAlarmTel" name="NodeVoiceAlarmTel" />
</div>
</div>
<div class="t1">
<div class="txt">
所属单位:</div>
<div class="input">
<input type="text" class="bd" id="CompanyName" name="CompanyName" />
</div>
</div>
</div>
<div class="right">
<div class="t1">
<div class="txt">
传感器编号:</div>
<div class="input">
<input type="text" class="bd" id="QueryNodeNO" name="QueryNodeNO" />
</div>
</div>
<div class="t1">
<div class="txt">
网关编号:</div>
<div class="input">
<input type="text" class="bd" id="QueryEquipNO" name="QueryEquipNO" />
</div>
</div>
<div class="t1">
<div class="txt">
是否已设置:</div>
<div class="input">
<select name="HasItSet" id="HasItSet" style="border: 1px solid #d7e0ea; width: 242px;
border-radius: 5px; height: 40px; line-height: 40px; padding-left: 15px;" runat="server">
<option value="">---请选择---</option>
<option value="1">---是---</option>
<option value="0">---否---</option>
</select>
</div>
</div>
<div class="t1 mt10">
<div class="txt">
</div>
<div class="input">
<asp:Button ID="btnQuery" runat="server" Text="查 询" CssClass="duo_s_btn" OnClientClick="Query(1);return false" />
</div>
</div>
</div>
</div>
<%-- 主界面--%>
<div class="shop_content">
<div class="zkcurve_list">
<div>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:GridView ID="VoicePhoneGDV" runat="server" Width="100%" AllowSorting="True" AutoGenerateColumns="False"
AllowPaging="true" GridLines="None" PageSize="100">
<HeaderStyle Wrap="False" BorderColor="#D7E0EA" Height="40px" ForeColor="#36AEEA">
</HeaderStyle>
<Columns>
<asp:TemplateField HeaderText="序号" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<asp:Label ID="lbID" runat="server" Text='<%# this.VoicePhoneGDV.PageIndex * this.VoicePhoneGDV.PageSize + this.VoicePhoneGDV.Rows.Count + 1%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="传感器编号" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<asp:Label ID="lbNodeNo" runat="server" Text='<%# Bind("Node_No")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="传感器名称" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<asp:Label ID="lbNodeName" runat="server" Text='<%# Bind("Node_Name")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="所属网关SN" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<asp:Label ID="lbEquipNo" runat="server" Text='<%# Bind("Equip_No")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="所属网关名称" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<asp:Label ID="lbEquipName" runat="server" Text='<%# Bind("Equip_Name")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="报警是否开启" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<asp:Label ID="lbNodeISAlarmForSMS" runat="server" Text='<%#Eval("Node_ISAlarmForSMS").ToString()=="1"?"是":
(Eval("Node_ISAlarmForSMS").ToString()=="0"?"否":"不确定")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<%--Eval("Node_ISAlarmForSMS").ToString()=="1"?"是":
(Eval("Node_ISAlarmForSMS").ToString()=="0"?"否":"不确定"--%>
<%--Bind("Node_TwoLevelIsOpen")--%>
<asp:TemplateField HeaderText="报警电话号码" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<%--Bind("Node_VoiceAlarmTel")--%>
<asp:Label ID="label" runat="server" Text='<%#Eval("Node_VoiceAlarmTel").ToString().Length>14?
Eval("Node_VoiceAlarmTel").ToString().Substring(0,14)+" ... ":Eval("Node_VoiceAlarmTel").ToString()%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="报警电话号码" InsertVisible="False" HeaderStyle-Wrap="false">
<HeaderStyle CssClass="ItemStyleNoDisplay" />
<ItemStyle CssClass="ItemStyleNoDisplay" />
<ItemTemplate>
<%--Bind("Node_VoiceAlarmTel")--%>
<asp:Label ID="lbNodeVoiceAlarmTel" runat="server" Text='<%#Bind("Node_VoiceAlarmTel")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="预警是否开启" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<asp:Label ID="lbNodeOneLevelIsOpen" runat="server" Text='<%#Eval("Node_OneLevelIsOpen").ToString()=="1"?"是":
(Eval("Node_OneLevelIsOpen").ToString()=="0"?"否":"不确定")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="预警电话号码" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<%--Bind("Node_OneLevelVoiceTel")--%>
<asp:Label ID="label3" runat="server" Text='<%#Eval("Node_OneLevelVoiceTel").ToString().Length>14?
Eval("Node_OneLevelVoiceTel").ToString().Substring(0,14)+" ... ":Eval("Node_OneLevelVoiceTel").ToString()%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="预警电话号码" InsertVisible="False" HeaderStyle-Wrap="false">
<HeaderStyle CssClass="ItemStyleNoDisplay" />
<ItemStyle CssClass="ItemStyleNoDisplay" />
<ItemTemplate>
<asp:Label ID="lbNodeOneLevelVoiceTel" runat="server" Text='<%#Bind("Node_OneLevelVoiceTel")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="严重报警是否开启" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<asp:Label ID="lbNodeTwoLevelIsOpen" runat="server" Text='<%#Eval("Node_TwoLevelIsOpen").ToString()=="1"?"是":
(Eval("Node_TwoLevelIsOpen").ToString()=="0"?"否":"不确定")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="严重报警电话号码" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<%--Bind("Node_TwoLevelVoiceTel")--%>
<asp:Label ID="lab" runat="server" Text='<%#Eval("Node_TwoLevelVoiceTel").ToString().Length>14?
Eval("Node_TwoLevelVoiceTel").ToString().Substring(0,14)+" ... ":Eval("Node_TwoLevelVoiceTel").ToString()%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="严重报警电话号码" InsertVisible="False" HeaderStyle-Wrap="false">
<HeaderStyle CssClass="ItemStyleNoDisplay" />
<ItemStyle CssClass="ItemStyleNoDisplay" />
<ItemTemplate>
<asp:Label ID="lbNodeTwoLevelVoiceTel" runat="server" Text='<%#Bind("Node_TwoLevelVoiceTel")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="修改" InsertVisible="False" HeaderStyle-Wrap="false">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="false" />
<ItemTemplate>
<asp:LinkButton ID="Revisebtn" runat="server" CssClass="bt_mod" OnClientClick='Alter(this);return false;'
Font-Size="12px" ToolTip='<%# Bind("Node_No")%>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<div id="EquipPageNation">
</div>
</ContentTemplate>
</asp:UpdatePanel>
</div>
<div id="ShowInfo">
<div class="divShowRoleInfo" style="width: 200px; margin-left: 10px; display: none;">
<img src="../../Common/Image/loading.gif" /><span style="margin-left: 10px;">正在加载数据......</span>
</div>
</div>
<div id="NodePageNation" style="display:none">
<table width="100%" class='Grid_General'>
<tr>
<td align="center">
第
<asp:Label ID="lblPageIndex" runat="server" />
页/ 共
<asp:Label ID="lblPageCount" runat="server" />
页
<asp:LinkButton ID="btn_First" runat="server" CausesValidation="False" CommandArgument="First"
CommandName="Page" Text="首页" OnClientClick="PageNation('First');return false;" />
<asp:LinkButton ID="btn_Prev" runat="server" CausesValidation="False" CommandArgument="Prev"
CommandName="Page" Text="上一页" OnClientClick="PageNation('Last');return false;" />
<asp:LinkButton ID="btn_Next" runat="server" CausesValidation="False" CommandArgument="Next"
CommandName="Page" Text="下一页" OnClientClick="PageNation('Next');return false;" />
<asp:LinkButton ID="btn_Last" runat="server" CausesValidation="False" CommandArgument="Last"
CommandName="Page" Text="尾页" OnClientClick="PageNation('End');return false;" />
<asp:TextBox ID="txtNewPageIndex" runat="server" Width="20px" />
<asp:LinkButton ID="btn_Go" runat="server" CausesValidation="False" CommandArgument="-1"
CommandName="Page" Text="GO" OnClientClick="PageNation('Search');return false;" />
</td>
</tr>
</table>
</div>
</div>
</div>
<%--弹出--%>
<div id="MaintenanceDialog" class="easyui-dialog" style="width: 630px; height: auto; display:none"
data-options="modal:true,closed:true,iconCls:'icon-save',border:'thin',title:'语音报警电话设置'">
<div id="MaintenanceShow">
<div class="popall" id="add_jd">
<div class="cont" style="width: 80%; min-width: 600px; margin: auto;">
<div class="bd">
<div class="wg_wh_bd">
<div class="xianmuvoice">
<div class="t1">
传感器编号:</div>
<div class="t2">
<asp:Label ID="lbNodeNO" runat="server" Text="Label"></asp:Label>
</div>
</div>
<div class="xianmuvoice">
<div class="t1">
传感器名称:</div>
<div class="t2">
<asp:Label ID="lblNodeName" runat="server" Text="Label"></asp:Label>
</div>
</div>
<div class="xianmuvoice">
<div class="t1">
所属网关SN:</div>
<div class="t2">
<asp:Label ID="lblEquipNo" runat="server" Text="Label"></asp:Label>
</div>
</div>
</div>
<div class="wg_wh_bd">
<div class="xianmuvo">
<div class="t1">
报警是否开启:</div>
<div class="t2">
<asp:Label ID="lblNodeISAlarmForSMS" runat="server" Text="Label"></asp:Label>
<%--<input id="txtNodeISAlarmForSMS" runat="server" type="text" />--%>
</div>
</div>
<div class="xianmuvo">
<div class="t1">
报警电话号码:</div>
<div class="t2">
<input id="txtNodeVoiceAlarmTel" disabled runat="server" type="text" />
</div>
<div class="t4">
<asp:ImageButton ID="txtNodeAlarmTel" ImageUrl="../../Common/Image/u186.png" Width="25px"
OnClientClick="AddAlarmPhoneNum('0');return false;" runat="server" /></div>
</div>
</div>
<div class="wg_wh_bd">
<div class="xianmuvo">
<div class="t1">
预警是否开启:</div>
<div class="t2">
<asp:Label ID="lblNodeOneLevelIsOpen" runat="server" Text="Label"></asp:Label>
<%--<input id="txtNodeOneLevelIsOpen" runat="server" type="text" />--%>
</div>
</div>
<div class="xianmuvo">
<div class="t1">
预警电话号码:</div>
<div class="t2">
<input id="txtNodeOneLevelVoiceTel" disabled runat="server" type="text" />
</div>
<div class="t4">
<asp:ImageButton ID="txtNode_OneLevelSMSTel" ImageUrl="../../Common/Image/u186.png" Width="25px"
OnClientClick="AddAlarmPhoneNum('1');return false;" runat="server" /></div>
</div>
</div>
<div class="wg_wh_bd">
<div class="xianmuvo">
<div class="t1">
严重报警是否开启:</div>
<div class="t2">
<asp:Label ID="lblNodeTwoLevelIsOpen" runat="server" Text="Label"></asp:Label>
<%--<input id="txtNodeTwoLevelIsOpen" runat="server" type="text" />--%>
</div>
</div>
<div class="xianmuvo">
<div class="t1">
严重报警电话号码:</div>
<div class="t2">
<input id="txtNodeTwoLevelVoiceTel" disabled runat="server" type="text" />
</div>
<div class="t4">
<asp:ImageButton ID="txtNode_TwoLevelSMSTel" ImageUrl="../../Common/Image/u186.png" Width="25px"
OnClientClick="AddAlarmPhoneNum('2');return false;" runat="server" /></div>
</div>
</div>
<div class="add_qybd">
<div class="btncc">
<input type="button" value="取消" class="qx" onclick="$('#MaintenanceDialog').dialog('close');return false" />
<input type="button" value="保存" class="bc" onclick="UpdateOrSaveTheMaintenance();return false;" />
<a id="divNodeShowSaving" style="width: 20px; display: none;">
<img src="../../Common/Image/loading.gif" /><span style="margin-left: 10px;"></span>
</a><a id="divNodeShowSaveOK" style="width: 40px; display: none;">
<asp:Label ID="theSaveStateMessage" runat="server" Text="Label"></asp:Label>
</a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<%--添加报警电话--%>
<div id="AddAlarmPhoneNumDiv" class="easyui-dialog" title="添加报警电话号码" style="text-align: center;
width: 500px; height: auto; display: none" closed="true" data-options="modal:true,closed:true,iconCls:'icon-save',border:'thin'">
<div class="shop_content">
<table id="AddNumTable" style="width: 95%">
<tr>
<td>
</td>
</tr>
</table>
<div align="center">
<a onclick="AddNewRows();return false;" href="#">
<img src="../../Common/Image/u186.png" width="20px" /></a></div>
</div>
<div style="width: 99%;">
<div class="add_qybd" style="margin-left: 50px">
<div class="btncc">
<input id="btnNumAdd" type="button" value="添加" class="qx" onclick="AddAlarmPhoneNumbtn();return false;" />
<input id="btnNumCancer" type="button" value="取消" class="bc" onclick="AddAlarmPhoneNumCancel();return false;" />
</div>
</div>
</div>
</div>
</form>
</body>
</html>
CS后台
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BLL;
using System.Data;
using System.Text;
using BasicItem;
namespace THMS.page.SuperOption
{
public partial class VoicePhoneSettings : MyBasePage
{
BLL.VoicePhoneSettings.VoicePhoneSettingsBLL QueryNodeInfo = new BLL.VoicePhoneSettings.VoicePhoneSettingsBLL();
public override void VerifyRenderingInServerForm(Control control)
{
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["Action"] != null)
{
string returnMsg = string.Empty;
StringBuilder returngvwMsg = new StringBuilder();
switch (Request["Action"])
{
case "Query":
returnMsg = Query(
Request["NodeNO"].ToString(),
Request["NodeName"].ToString(),
Request["EquipNO"].ToString(),
Request["EquipName"].ToString(),
Request["NodeVoiceAlarmTel"].ToString(),
Request["CompanyName"].ToString(),
Request["HasItSet"].ToString(), Int16.Parse(Request["PageSize"].ToString()), Int16.Parse(Request["PageIndex"].ToString()));
Response.Write(returnMsg);
break;
case "Update":
returnMsg = Update(
Request["NodeNo"].ToString(),
Request["NodeVoiceAlarmTel"].ToString(),
Request["NodeOneLevelVoiceTel"].ToString(),
Request["NodeTwoLevelVoiceTel"].ToString());
Response.Write(returnMsg);
break;
case "NodePageNation":
returnMsg = GridviewPagenation(Convert.ToInt32(Request["PageIndex"].ToString()), Convert.ToInt32(Request["PageSize"].ToString()));
Response.Write(returnMsg);
break;
}
Response.ContentType = "text/xml";
Response.Expires = 0;
Response.Flush();
Response.End();
}
}
protected string Query(string NodeNO, string NodeName, string EquipNO, string EquipName, string NodeVoiceAlarmTel, string CompanyName, string HasItSet, int PageSize, int PageIndex)
{
DataTable NodeInfods = new DataTable();
NodeInfods = QueryNodeInfo.QueryNodeInfo(NodeNO, NodeName, EquipNO, EquipName,NodeVoiceAlarmTel, CompanyName, HasItSet);
CacheDataHelper.AddCacheData(Request.Cookies["ASP.NET_SessionId"].Value, System.IO.Path.GetFileName(Request.Path).ToString() + "NodeInfods", NodeInfods);
if (NodeInfods == null || NodeInfods.Rows.Count < 1)
return "Empty";
int PageNum = NodeInfods.Rows.Count;//所有行数
DataTable ds = new DataTable();
ds = NodeInfods.Clone();
DataRow[] dr = NodeInfods.Select();
int AllPageNum = PageNum / PageSize + (PageNum % PageSize > 0 ? 1 : 0);
if (AllPageNum > 0)
{
if (PageIndex != AllPageNum)
{
for (int i = (PageIndex - 1) * 10, j = 0; i < (PageIndex - 1) * 10 + PageSize; i++, j++)
{
ds.Rows.Add(NodeInfods.Rows[i].ItemArray);
}
}
else
{
for (int i = (PageIndex - 1) * 10, j = 0; i < PageNum; i++, j++)
{
ds.Rows.Add(NodeInfods.Rows[i].ItemArray);
}
}
}
this.VoicePhoneGDV.DataSource = null;
this.VoicePhoneGDV.DataSource = ds;
this.VoicePhoneGDV.DataBind();
return PagingMethod.RenderGridView(VoicePhoneGDV) + "|" + AllPageNum.ToString();
}
protected string Update(string NodeNo, string NodeVoiceAlarmTel,
string NodeOneLevelVoiceTel,
string NodeTwoLevelVoiceTel)
{
return QueryNodeInfo.UpdateEdit(NodeNo, NodeVoiceAlarmTel,
NodeOneLevelVoiceTel, NodeTwoLevelVoiceTel) ? "设置成功" : "设置失败";
}
protected string GridviewPagenation(int PageIndex, int PageSize) //分页
{
DataTable dt = new DataTable();
DataTable NodeInfods = CacheDataHelper.GetDataTable(Request.Cookies["ASP.NET_SessionId"].Value, System.IO.Path.GetFileName(Request.Path).ToString() + "NodeInfods");
if (NodeInfods == null)
return "Empty";
dt = NodeInfods.Clone();
DataRow[] dr = NodeInfods.Select();
int GridAllItem = NodeInfods.Rows.Count;//所有行数
int AllPageNum = GridAllItem / PageSize + (GridAllItem % PageSize > 0 ? 1 : 0);
if (AllPageNum > 0)
{
if (PageIndex != AllPageNum)
{
for (int i = (PageIndex - 1) * PageSize, j = 0; i < (PageIndex - 1) * PageSize + PageSize; i++, j++)
{
dt.Rows.Add(NodeInfods.Rows[i].ItemArray);
}
}
else
{
for (int i = (PageIndex - 1) * PageSize, j = 0; i < GridAllItem; i++, j++)
{
dt.Rows.Add(NodeInfods.Rows[i].ItemArray);
}
}
}
this.VoicePhoneGDV.DataSource = null;
this.VoicePhoneGDV.DataSource = dt;
this.VoicePhoneGDV.DataBind();
return PagingMethod.RenderGridView(VoicePhoneGDV);
}
}
}
BLL
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DBUtility;
using System.Data;
using MenuUtility;
using Entities;
using DAL;
using BasicItem;
namespace BLL.VoicePhoneSettings
{
public class VoicePhoneSettingsBLL
{
public DataTable QueryNodeInfo(string NodeNO, string NodeName, string EquipNO, string EquipName, string NodeVoiceAlarmTel,string CompanyName,string HasItSet)
{
VoicePhoneSettingsDAL VoicePhoneDAL = new VoicePhoneSettingsDAL();
User_Info user = LoginHandler.CurrentUser;
if (user.Company_ID == 0)
{
return VoicePhoneDAL.QueryNodeInfoOfSensorSettings(user.User_ID.ToString(), "0", NodeNO, NodeName, EquipNO, EquipName, NodeVoiceAlarmTel, CompanyName, HasItSet);
}
else
{
return VoicePhoneDAL.QueryNodeInfoOfSensorSettings(user.User_ID.ToString(), Role_InfoDAL.GetAllEneterIdsByCompanyID(user.Company_ID.ToString()), NodeNO, NodeName, EquipNO, EquipName, NodeVoiceAlarmTel, CompanyName, HasItSet);
}
}
//修改
public bool UpdateEdit(string NodeNo, string NodeVoiceAlarmTel,
string NodeOneLevelVoiceTel,
string NodeTwoLevelVoiceTel)
{
VoicePhoneSettingsDAL VoicePhoneDAL = new VoicePhoneSettingsDAL();
return VoicePhoneDAL.UpdateEdit(NodeNo, NodeVoiceAlarmTel,
NodeOneLevelVoiceTel, NodeTwoLevelVoiceTel);
}
}
}
DAL
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DBUtility;
using System.Data;
using System.Data.SqlClient;
using BasicItem;
namespace DAL
{
public class VoicePhoneSettingsDAL
{
public bool UpdateEdit(string NodeNo, string NodeVoiceAlarmTel,
string NodeOneLevelVoiceTel,
string NodeTwoLevelVoiceTel)
{
string sql = "update Node_Info set Node_VoiceAlarmTel='" + NodeVoiceAlarmTel + "', Node_OneLevelVoiceTel='" + NodeOneLevelVoiceTel + "',Node_TwoLevelVoiceTel='" + NodeTwoLevelVoiceTel + "' where Node_No='" + NodeNo + "'";
return DBCommon.ExecuteNonQuery(sql);
}
public DataTable QueryNodeInfoOfSensorSettings(string strUserId, string strNodeIDs, string NodeNO, string NodeName, string EquipNO, string EquipName,string NodeVoiceAlarmTel,string CompanyName,string HasItSet)
{
try
{
StringBuilder sb = new StringBuilder();
sb.Append(" select a.Node_No,a.Node_Name,b.Equip_No,b.Equip_Name,a.Node_ISAlarmForSMS,a.Node_VoiceAlarmTel,a.Node_OneLevelIsOpen,a.Node_OneLevelVoiceTel,a.Node_TwoLevelIsOpen,a.Node_TwoLevelVoiceTel");
sb.Append(" from Node_Info a left join Equip_Info b on a.Node_EquipID=b.Equip_ID left join Company_Info c on b.Equip_CompanyID=c.Company_ID ");
sb.Append(" where 1=1 ");
if (NodeName != "")
sb.Append(" and a.Node_Name like '%" + NodeName + "%'");
if (NodeNO != "")
sb.Append(" and a.Node_No like '%" + NodeNO + "%'");
if (EquipName != "")
sb.Append(" and b.Equip_Name like '%" + EquipName + "%'");
if (EquipNO != "")
sb.Append(" and b.Equip_No like '%" + EquipNO + "%'");
if (NodeVoiceAlarmTel != "")
sb.Append(" and a.Node_VoiceAlarmTel like '%" + NodeVoiceAlarmTel + "%'");
if (HasItSet != "")
sb.Append(" and a.Node_ISAlarmForSMS like '%" + HasItSet + "%'");
if (CompanyName != "")
sb.Append(" and c.Company_Name like '%" + CompanyName + "%'");
if (Role_InfoDAL.ExitSupper(strUserId))
{
}
else if (Role_InfoDAL.ExitBusiness(strUserId) || Role_InfoDAL.ExitMaintenance(strUserId))
{
//string strUserIDsandCompanyIDs = User_InfoDAL.GetUserIDAndCompanyIDForBOMByUserID(strUserId);
//if (strUserIDsandCompanyIDs != "")
//{
// string[] UserIDandCompanyIDs = strUserIDsandCompanyIDs.Split('|');
// sb.Append(" and a.Company_ID in ('" + UserIDandCompanyIDs[1] + "') ");
//}
//else return null;
}
else
{
if (strNodeIDs == "0")
{
DataTable ds = new DataTable();
return ds;
}
else
{
sb.Append(" and b.Equip_CompanyID in ('" + strNodeIDs + "')");
}
}
sb.Append(" order by b.Equip_No desc");
return DBCommon.GetDataTable(sb.ToString());
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message);
}
}
}
}