📄 zhcy.aspx
字号:
<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="system.data" %>
<%@ import Namespace="system.data.sqlclient" %>
<script runat="server">
dim Cnn as sqlconnection
dim cmd as sqlcommand
Sub Page_Load(Sender As Object, E As EventArgs)
If Not IsPostBack Then
If Session("curruser") = "" Then
Response.Redirect("../index.aspx")
End If
BindGrid()
End If
End Sub
Sub BindGrid()
dim dataR as sqldatareader
dim dtcmd as sqldataadapter
dim dt as new datatable
dim MaxPage as integer '计算最大页数
dim str2 as string
dim Str1 as string
dim dystr as string=dy.text
dim i as integer
dim sumrecord as integer
cnn=new sqlconnection(configurationsettings.appsettings("connection"))
str1="select count(*) as nums from zh_members a where cellcode in (select code from fc_cell where name='" & trim(dystr) & "')"
cmd=new sqlcommand(str1,cnn)
cnn.open()
datar=cmd.executereader()
if datar.read() then
if datar("nums").tostring()="0" then
msg.text=""
else
msg.text="合计：记录数 " & datar("nums").tostring()
end if
end if
datar.close()
str1="select * from zh_members where cellcode in (select code from fc_cell where name='" & trim(dystr) & "') order by id"
dtcmd=new sqldataadapter(str1,cnn)
dtcmd.fill(dt)
if (dt.defaultview.count mod datagrid1.pagesize)>0 then
maxpage=dt.defaultview.count \datagrid1.pagesize+1
else
maxpage=dt.defaultview.count \datagrid1.pagesize
end if
do while datagrid1.currentpageindex>0
if maxpage<datagrid1.currentpageindex+1 then
datagrid1.currentpageindex=datagrid1.currentpageindex-1
else
exit do
end if
loop
datagrid1.datasource=dt
datagrid1.databind()
sumrecord=datagrid1.Items.count
for i=0 to sumrecord-1
dim LinkButton=Datagrid1.Items(i).Cells(8).Controls(0)
LinkButton.Attributes.Add("onclick","javascript:openwin('zhcy_mod.aspx?tag=mod&id=" & Datagrid1.Items(i).Cells(0).text & "')")
next
cnn.close()
End Sub
Sub Sure_Click(Sender As Object, E As EventArgs)
AddBtn.Attributes.Add("onclick","javascript:openwin('zhcy_mod.aspx?tag=add&id=" & dy.text & "')")
addbtn.enabled="true"
bindgrid()
end sub
Sub Grid1_Mod(Sender as object,E as DataGridCommandEventArgs)
dim codestr as string=E.Item.Cells(0).Text
dim sql as string
dim url as string
if CType(e.CommandSource,LinkButton).CommandName="Delete" then
cnn=new sqlconnection(configurationsettings.appsettings("connection"))
cnn.open()
sql="delete from zh_members where id=" & codestr
cmd=new sqlcommand(sql,cnn)
cmd.executeNonQuery
cnn.close()
bindgrid()
end if
End Sub
Sub Grid1_PageIndexChanged(Sender As Object, E As DataGridPageChangedEventArgs)
datagrid1.CurrentPageIndex = e.NewPageIndex
BindGrid()
End Sub
Function GetAlertInfo(byval str1 as string) as String
dim Str2 as String
str2="<script language='javascript'>alert('" & str1 & "')<"
str2+="/"
str2+="script>"
return trim(str2)
End Function
</script>
<html>
<head>
<title>住户成员</title>
<link href="../Main.css" type="text/css" rel="stylesheet" />
<script language="javascript">
function openwin(src)
{
var vDialog=null;
vDialog=showModalDialog(src,window,"status:no;resizable:off;dialogHeight:450px;dialogWidth:700px;unadorne:yes;help:no");
location.reload();
}
</script>
</head>
<body leftmargin="0" background="../images/1.jpg" topmargin="0">
<form runat="server">
<br />
<table id="search" cellspacing="1" cellpadding="0" width="95%" align="center" border="0">
<tbody>
<tr class="tr4">
<td width="34%" height="30">
单元名称
<asp:TextBox class="input_text" id="dy" runat="server" width="130"></asp:TextBox>
</td>
<td>
<asp:button class="input_button" id="SureBtn" onclick="Sure_Click" runat="server" text="确 定"></asp:button>
</td>
</tr>
<tr class="tr4">
<td colspan="2">
<hr />
</td>
</tr>
</tbody>
</table>
<table class="" id="search" cellspacing="1" cellpadding="0" width="95%" align="center" border="0">
<tbody>
<tr class="tr2">
<td style="PADDING-LEFT: 5px" height="25">
<asp:Label id="Msg" runat="server" forecolor="red"></asp:Label></td>
</tr>
<tr>
<td style="PADDING-LEFT: 5px" height="25">
<asp:DataGrid id="DataGrid1" runat="server" width="100%" AutoGenerateColumns="False" OnItemCommand="Grid1_Mod" headerstyle-backcolor="#F8FAFC" font-size="8pt" font-name="verdana" cellpadding="2" bordercolor="Black" Font-Names="verdana" AllowPaging="True" AllowSorting="True" OnPageIndexChanged="Grid1_PageIndexChanged">
<HeaderStyle font-bold="True" horizontalalign="Center" verticalalign="Middle" backcolor="#F8FAFC"></HeaderStyle>
<PagerStyle nextpagetext="下一页" font-names="宋体" font-bold="True" prevpagetext="上一页" horizontalalign="Right" forecolor="Blue" mode="NumericPages"></PagerStyle>
<EditItemStyle backcolor="#E9F0F8"></EditItemStyle>
<Columns>
<asp:BoundColumn Visible="False" DataField="id" HeaderText="成员编号"></asp:BoundColumn>
<asp:BoundColumn DataField="name" HeaderText="成员姓名"></asp:BoundColumn>
<asp:BoundColumn DataField="birdate" HeaderText="出生日期" DataFormatString="{0:yyyy-MM-dd}"></asp:BoundColumn>
<asp:BoundColumn DataField="sex" HeaderText="性别"></asp:BoundColumn>
<asp:BoundColumn DataField="ration" HeaderText="与户主关系"></asp:BoundColumn>
<asp:BoundColumn DataField="zjlx" HeaderText="证件类型"></asp:BoundColumn>
<asp:BoundColumn DataField="zjhm" HeaderText="证件号码"></asp:BoundColumn>
<asp:BoundColumn DataField="memo" HeaderText="备注"></asp:BoundColumn>
<asp:ButtonColumn Text="修改" HeaderText="修改" CommandName="modiinfo"></asp:ButtonColumn>
<asp:ButtonColumn Text="删除" HeaderText="删除" CommandName="Delete"></asp:ButtonColumn>
</Columns>
</asp:DataGrid>
</td>
</tr>
</tbody>
</table>
<p align="center">
<asp:button class="input_button" id="AddBtn" runat="server" text="新增成员" enabled="false"></asp:button>
</p>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -