lgxx.aspx

来自「ASP.NET开发实战详解」· ASPX 代码 · 共 352 行 · 第 1/2 页

                       if CType(e.CommandSource,LinkButton).CommandName="Delete" then
                          cnn=new sqlconnection(configurationsettings.appsettings("connection"))
                          cnn.open()
                          sql="delete from fc_lg where code='" & 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:500px;dialogWidth:750px;unadorne:yes;help:no");
          location.reload();
       }

    </script>
</head>
<body leftmargin="5" topmargin="5" background="../images/1.jpg">
    <form runat="server">
       <asp:Image ID="Image2" runat="server" ImageUrl="../images/pic1.gif" />
       <asp:LinkButton ID="LinkButton1" Font-Bold="True" Font-Size="X-Small" runat="server" OnClick="LinkButton1_Click" CausesValidation="False">楼阁查询</asp:LinkButton>&nbsp;&nbsp;
       <asp:Image ID="Image1" runat="server" ImageUrl="../images/pic1.gif" />
       <asp:LinkButton ID="LinkButton2" runat="server" Font-Bold="True" Font-Size="X-Small" OnClick="LinkButton2_Click" CausesValidation="False">楼阁增加</asp:LinkButton>
       <hr />
       <asp:MultiView ID="MultiView1" runat="server" ActiveViewIndex="0">
         <asp:View ID="View1" runat="server">    
                <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%" OnPageIndexChanged="Grid1_PageIndexChanged" AllowSorting="True" AllowPaging="True" Font-Names="verdana" bordercolor="Black" cellpadding="2" font-name="verdana" font-size="8pt" headerstyle-backcolor="#F8FAFC" OnItemCommand="Grid1_Mod" AutoGenerateColumns="False" PageSize="10">
                                    <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 DataField="code" HeaderText="楼阁编号"></asp:BoundColumn>
                                        <asp:BoundColumn DataField="name" HeaderText="楼阁名称"></asp:BoundColumn>
                                        <asp:BoundColumn DataField="lpcode" HeaderText="所属楼盘"></asp:BoundColumn>
                                        <asp:BoundColumn DataField="gn" HeaderText="功能"></asp:BoundColumn>
                                        <asp:BoundColumn DataField="floors" HeaderText="层数"></asp:BoundColumn>
                                        <asp:BoundColumn DataField="symj" HeaderText="使用面积"></asp:BoundColumn>
                                        <asp:BoundColumn DataField="jzmj" HeaderText="建筑面积"></asp:BoundColumn>
                                        <asp:BoundColumn DataField="zx" HeaderText="装修标准"></asp:BoundColumn>
                                        <asp:BoundColumn DataField="type" HeaderText="结构类别"></asp:BoundColumn>
                                        <asp:BoundColumn DataField="wsdj" 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>
            </asp:View>
            <asp:View ID="View2" runat="server">
                <br />
                <table id="search" cellspacing="1" cellpadding="0" width="80%" align="center" border="0">
                    <tbody>
                        <tr class="tr4">
                            <td height="50" width="34%">
                                楼阁名称
                                <asp:TextBox class="input_text" id="name" runat="server" width="120"></asp:TextBox>
			    </td>
                            <td width="33%">
                                楼阁地址
                                <asp:TextBox class="input_text" id="addr" runat="server" width="120"></asp:TextBox>
                            </td>
                            <td>
                                层&nbsp;&nbsp;&nbsp;&nbsp;数
                                <asp:TextBox class="input_text" id="floors" runat="server" width="120"></asp:TextBox>
                            </td>
                        </tr>
                        <tr class="tr4">
                            <td height="50">
                                所属楼盘
                                <asp:DropDownList class="input_text" id="Sellp" runat="server" width="120"></asp:DropDownList>
                            </td>
                            <td>
                                功&nbsp;&nbsp;&nbsp;&nbsp;能
                                <asp:DropDownList class="input_text" id="Selgn" runat="server" width="120"></asp:DropDownList>
			    </td>
                            <td>
                                结构类别
                                <asp:DropDownList class="input_text" id="Seljg" runat="server" width="120"></asp:DropDownList>
			    </td>
                        </tr>
                        <tr class="tr4">
                            <td height="50">
                                实用面积
                                <asp:TextBox class="input_text" id="symj" runat="server" width="120"></asp:TextBox>
                            </td>
                            <td>
                                建筑面积
                                <asp:TextBox class="input_text" id="jzmj" runat="server" width="120"></asp:TextBox>
                            </td>
                            <td>
                                装修标准
				<asp:DropDownList class="input_text" id="Selzx" runat="server" width="120"></asp:DropDownList>
                            </td>
                        </tr>

                        <tr class="tr4">
                            <td height="50">
                                竣工日期
                                <asp:TextBox class="input_text" id="finish" runat="server" width="120"></asp:TextBox>
			    </td>
                            <td>
                                封顶日期
                                <asp:TextBox class="input_text" id="fddate" runat="server" width="120"></asp:TextBox>
                            </td>
                            <td>
                                完损等级
                                <asp:DropDownList class="input_text" id="Selws" runat="server" width="120"></asp:DropDownList>
			    </td>
                        </tr>
                        <tr class="tr4">
                            <td height="50">
                                建筑许可证
                                <asp:TextBox class="input_text" id="xkzh" runat="server" width="110"></asp:TextBox>
                            </td>
                            <td>
                                预售许可证
				<asp:TextBox class="input_text" id="ysxkz" runat="server" width="110"></asp:TextBox>
                            </td>
			    <td></td>	
                        </tr>
                        <tr class="tr4">
                            <td colspan="3" height="50">
                                备&nbsp;&nbsp;&nbsp;&nbsp;注
                                <asp:TextBox class="input_text" id="memo" runat="server" width="560"></asp:TextBox>
                            </td>
                        </tr>
                        <tr class="tr4">
                            <td valign="bottom" align="middle" colspan="3" height="70">
                                <asp:button class="input_button" id="SaveBtn" onclick="Save_Click" runat="server" text="保  存"></asp:button>
				&nbsp;&nbsp;&nbsp;&nbsp;
                                <asp:button class="input_button" id="ClearBtn" onclick="Clear_Click" runat="server" text="清  空"></asp:button>
                                <br />
                                <asp:RequiredFieldValidator id="Requiredfieldvalidator1" runat="server" ErrorMessage="*" ControlToValidate="name">楼阁名称不可为空</asp:RequiredFieldValidator>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </asp:View>
        </asp:MultiView>
    </form>
</body>
</html>