📄 sankeruzhu.aspx
字号:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<HTML>
<HEAD>
<title>WebForm1</title>
<META http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ Page Language="c#" CodeBehind="sankeruzhu.aspx.cs" AutoEventWireup="false" Inherits="software.sankeruzhu" %>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
<script runat="server">
private void submit_button2(object sender, System.EventArgs e)
{
Response.Redirect("WebForm2.aspx");
}
void Button_Click(Object sender, EventArgs e) {
SqlConnection Conn;
Conn=new SqlConnection("server=HWADEE-1G30;database=HTserverData;uid=sa;pwd=''");
Conn.Open();
SqlCommand Comm=new SqlCommand("select RoomNum from RmStatus where RoomSta ='空闲'",Conn);
SqlDataReader dr=Comm.ExecuteReader();
dg.DataSource=dr;
dg.DataBind();
Conn.Close();
}
void Button_Click1(Object sender, EventArgs e) {
SqlConnection Conn;
Conn=new SqlConnection("server=HWADEE-1G30;database=HTserverData;uid=sa;pwd=''");
Conn.Open();
SqlCommand Comm=new SqlCommand("update RmStatus set RoomSta='占用' where RoomNum='"+fangjian.Text+"'",Conn);
SqlDataReader dr=Comm.ExecuteReader();
dg.DataSource=dr;
dg.DataBind();
Conn.Close();
}
void Button_Click2(Object sender, EventArgs e) {
SqlConnection Conn;
Conn=new SqlConnection("server=HWADEE-1G30;database=HTserverData;uid=sa;pwd=''");
Conn.Open();
string downlist1=a.SelectedItem.Value;
SqlCommand Comm=new SqlCommand("insert into CustData(CustName,CustID,RoomNum,CustIC,CustDate,PreM,CustSex) values('"+xingming.Text+"','"+shenfen.Text+"','"+fanghao.Text+"','"+ic.Text+"','"+shijian.Text+"','"+yajin.Text+"','"+downlist1+"')" ,Conn);
try {
Comm.ExecuteNonQuery();
Message.Text="添加成功!";
Message.Style["color"]="red";
}
catch (SqlException) {
Message.Text="添加失败!";
Message.Style["color"]="blue";
}
Conn.Close();
}
</script>
</HEAD>
<body text="#ffffff" bgColor="#339933" MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT size="5">
<DIV style="DISPLAY: inline; Z-INDEX: 101; LEFT: 48px; WIDTH: 312px; POSITION: absolute; TOP: 40px; HEIGHT: 54px"
ms_positioning="FlowLayout">
<P><STRONG><FONT face="宋体"> </FONT><FONT face="楷体_GB2312">无双酒店散客入住系统</FONT></STRONG></P>
</DIV>
<asp:button id="Button2" style="Z-INDEX: 126; LEFT: 512px; POSITION: absolute; TOP: 488px" onclick="submit_button2"
runat="server" Text="返回" Height="30px" Width="70px"></asp:button><asp:datagrid id="dg" style="Z-INDEX: 113; LEFT: 440px; POSITION: absolute; TOP: 96px" runat="server"
Height="202px" Width="144px"></asp:datagrid>
<DIV style="DISPLAY: inline; Z-INDEX: 102; LEFT: 48px; WIDTH: 80px; POSITION: absolute; TOP: 160px; HEIGHT: 24px"
ms_positioning="FlowLayout"><FONT face="楷体_GB2312" size="4">房间号：</FONT></DIV>
<DIV style="DISPLAY: inline; Z-INDEX: 103; LEFT: 48px; WIDTH: 112px; POSITION: absolute; TOP: 208px; HEIGHT: 32px"
ms_positioning="FlowLayout"><FONT face="楷体_GB2312">客户资料</FONT></DIV>
<DIV style="DISPLAY: inline; Z-INDEX: 104; LEFT: 48px; WIDTH: 70px; POSITION: absolute; TOP: 256px; HEIGHT: 15px"
ms_positioning="FlowLayout"><FONT face="楷体_GB2312" size="4">姓名：</FONT></DIV>
<DIV style="DISPLAY: inline; Z-INDEX: 105; LEFT: 48px; WIDTH: 70px; POSITION: absolute; TOP: 288px; HEIGHT: 15px"
ms_positioning="FlowLayout"><FONT face="楷体_GB2312" size="4">性别：</FONT></DIV>
<DIV style="DISPLAY: inline; Z-INDEX: 106; LEFT: 48px; WIDTH: 96px; POSITION: absolute; TOP: 320px; HEIGHT: 24px"
ms_positioning="FlowLayout"><FONT face="楷体_GB2312" size="4">身份证号：</FONT></DIV>
<DIV style="DISPLAY: inline; Z-INDEX: 107; LEFT: 48px; WIDTH: 96px; POSITION: absolute; TOP: 352px; HEIGHT: 24px"
ms_positioning="FlowLayout"><FONT face="楷体_GB2312" size="4">房间号：</FONT></DIV>
<DIV style="DISPLAY: inline; Z-INDEX: 108; LEFT: 48px; WIDTH: 88px; POSITION: absolute; TOP: 384px; HEIGHT: 23px"
ms_positioning="FlowLayout"><FONT face="楷体_GB2312" size="4">IC卡号：</FONT></DIV>
<DIV style="DISPLAY: inline; Z-INDEX: 109; LEFT: 48px; WIDTH: 104px; POSITION: absolute; TOP: 416px; HEIGHT: 20px"
ms_positioning="FlowLayout"><FONT face="楷体_GB2312" size="4">入住时间</FONT>：</DIV>
<DIV style="DISPLAY: inline; Z-INDEX: 110; LEFT: 48px; WIDTH: 96px; POSITION: absolute; TOP: 448px; HEIGHT: 14px"
ms_positioning="FlowLayout"><FONT face="楷体_GB2312" size="4">预交押金：</FONT></DIV>
<DIV style="DISPLAY: inline; Z-INDEX: 111; LEFT: 288px; WIDTH: 32px; POSITION: absolute; TOP: 448px; HEIGHT: 21px"
ms_positioning="FlowLayout"><FONT face="楷体_GB2312" size="4">元</FONT></DIV>
<asp:button id="name" style="Z-INDEX: 112; LEFT: 48px; POSITION: absolute; TOP: 112px" onclick="Button_Click"
Text="客房查询" Height="32px" Runat="server"></asp:button><asp:button id="Button1" style="Z-INDEX: 114; LEFT: 336px; POSITION: absolute; TOP: 160px" onclick="Button_Click1"
runat="server" Text="确定"></asp:button><asp:textbox id="fangjian" style="Z-INDEX: 115; LEFT: 152px; POSITION: absolute; TOP: 160px"
runat="server" Height="26px" Width="136px"></asp:textbox><asp:textbox id="xingming" style="Z-INDEX: 116; LEFT: 152px; POSITION: absolute; TOP: 256px"
runat="server"></asp:textbox><asp:textbox id="shenfen" style="Z-INDEX: 117; LEFT: 152px; POSITION: absolute; TOP: 320px" runat="server"></asp:textbox><asp:textbox id="fanghao" style="Z-INDEX: 118; LEFT: 152px; POSITION: absolute; TOP: 352px" runat="server"></asp:textbox><asp:textbox id="ic" style="Z-INDEX: 119; LEFT: 152px; POSITION: absolute; TOP: 384px" runat="server"></asp:textbox><asp:textbox id="shijian" style="Z-INDEX: 120; LEFT: 152px; POSITION: absolute; TOP: 416px" runat="server"></asp:textbox><asp:textbox id="yajin" style="Z-INDEX: 121; LEFT: 152px; POSITION: absolute; TOP: 448px" runat="server"
Width="128px"></asp:textbox><asp:button id="tijiao" style="Z-INDEX: 122; LEFT: 232px; POSITION: absolute; TOP: 496px" onclick="Button_Click2"
runat="server" Text="提交"></asp:button><asp:label id="Message" style="Z-INDEX: 123; LEFT: 408px; POSITION: absolute; TOP: 400px" runat="server"></asp:label><asp:dropdownlist id="a" style="Z-INDEX: 124; LEFT: 152px; POSITION: absolute; TOP: 288px" runat="server"
Height="24px" Width="56px">
<asp:ListItem Value="男">男</asp:ListItem>
<asp:ListItem Value="女">女</asp:ListItem>
</asp:dropdownlist></FONT></form>
</body>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -