一叶。妖风

真四国无双
博客园 首页 新随笔 联系 订阅 管理
简单的插入数据并作一定判断
HTML代码
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
    <HEAD>
        <title>lanchudengji</title>
        <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">
        <style type="text/css">BODY { BACKGROUND-COLOR: #def3ff }
        </style>
    </HEAD>
    <body MS_POSITIONING="GridLayout">
        <form id="Form1" method="post" runat="server">
            <FONT face="宋体">
                <asp:label id="Label1" style="Z-INDEX: 101; LEFT: 168px; POSITION: absolute; TOP: 56px" runat="server"
                    Font-Size="Smaller" ForeColor="#004040">职工姓名：</asp:label><asp:label id="Label2" style="Z-INDEX: 102; LEFT: 168px; POSITION: absolute; TOP: 88px" runat="server"
                    Font-Size="Smaller" ForeColor="#004040">所属部门：</asp:label><asp:dropdownlist id="DropDownList1" style="Z-INDEX: 103; LEFT: 248px; POSITION: absolute; TOP: 88px"
                    tabIndex="2" runat="server"></asp:dropdownlist><asp:label id="Label3" style="Z-INDEX: 104; LEFT: 168px; POSITION: absolute; TOP: 120px" runat="server"
                    Font-Size="Smaller" ForeColor="#004040">揽储帐号：</asp:label><asp:textbox id="TextBox2" style="Z-INDEX: 105; LEFT: 248px; POSITION: absolute; TOP: 120px"
                    tabIndex="3" runat="server" BorderStyle="Groove" ToolTip="活期帐号应该为19位"></asp:textbox><asp:label id="Label4" style="Z-INDEX: 106; LEFT: 168px; POSITION: absolute; TOP: 152px" runat="server"
                    Font-Size="Smaller" ForeColor="#004040">揽储金额：</asp:label><asp:textbox id="TextBox3" style="Z-INDEX: 107; LEFT: 248px; POSITION: absolute; TOP: 152px"
                    tabIndex="4" runat="server" BorderStyle="Groove" ToolTip="金额为非零开头的正数"></asp:textbox><asp:label id="Label5" style="Z-INDEX: 108; LEFT: 168px; POSITION: absolute; TOP: 184px" runat="server"
                    Font-Size="Smaller" ForeColor="#004040">揽储类型：</asp:label><asp:dropdownlist id="DropDownList2" style="Z-INDEX: 109; LEFT: 248px; POSITION: absolute; TOP: 184px"
                    tabIndex="5" runat="server">
                    <asp:ListItem Value="活期">活期</asp:ListItem>
                </asp:dropdownlist><asp:label id="Label6" style="Z-INDEX: 110; LEFT: 168px; POSITION: absolute; TOP: 216px" runat="server"
                    Font-Size="Smaller" ForeColor="#004040">客户类型：</asp:label><asp:dropdownlist id="DropDownList3" style="Z-INDEX: 111; LEFT: 248px; POSITION: absolute; TOP: 216px"
                    tabIndex="6" runat="server" BorderStyle="Groove" Height="16px"></asp:dropdownlist><asp:label id="Label7" style="Z-INDEX: 112; LEFT: 168px; POSITION: absolute; TOP: 248px" runat="server"
                    Font-Size="Smaller" ForeColor="#004040" Height="8px">存入日期：</asp:label><asp:textbox id="TextBox4" style="Z-INDEX: 113; LEFT: 248px; POSITION: absolute; TOP: 248px"
                    tabIndex="7" runat="server" BorderStyle="Groove" ToolTip="格式：050101"></asp:textbox><asp:button id="Button1" style="Z-INDEX: 114; LEFT: 248px; POSITION: absolute; TOP: 288px" tabIndex="8"
                    runat="server" BorderStyle="Groove" Text="确 认"></asp:button><asp:requiredfieldvalidator id="RequiredFieldValidator1" style="Z-INDEX: 115; LEFT: 416px; POSITION: absolute; TOP: 120px"
                    runat="server" Font-Size="Smaller" ErrorMessage="请输入揽储帐号" ControlToValidate="TextBox2"></asp:requiredfieldvalidator><asp:requiredfieldvalidator id="RequiredFieldValidator2" style="Z-INDEX: 116; LEFT: 416px; POSITION: absolute; TOP: 152px"
                    runat="server" Font-Size="Smaller" ErrorMessage="请输入揽储金额" ControlToValidate="TextBox3"></asp:requiredfieldvalidator><asp:requiredfieldvalidator id="RequiredFieldValidator3" style="Z-INDEX: 117; LEFT: 416px; POSITION: absolute; TOP: 248px"
                    runat="server" Font-Size="Smaller" ErrorMessage="请输入日期" ControlToValidate="TextBox4"></asp:requiredfieldvalidator><asp:regularexpressionvalidator id="RegularExpressionValidator1" style="Z-INDEX: 118; LEFT: 416px; POSITION: absolute; TOP: 128px"
                    runat="server" Font-Size="Smaller" ToolTip="活期帐号应为18位数字" ErrorMessage="活期帐号应为18位数字" ControlToValidate="TextBox2" ValidationExpression="^\d{18}$"></asp:regularexpressionvalidator><asp:regularexpressionvalidator id="RegularExpressionValidator3" style="Z-INDEX: 119; LEFT: 416px; POSITION: absolute; TOP: 160px"
                    runat="server" Font-Size="Smaller" ErrorMessage="只能输入正数,可以带2位小数" ControlToValidate="TextBox3" ValidationExpression="^[0-9]+(.[0-9]{2})?$"></asp:regularexpressionvalidator><asp:regularexpressionvalidator id="RegularExpressionValidator2" style="Z-INDEX: 120; LEFT: 416px; POSITION: absolute; TOP: 248px"
                    runat="server" Font-Size="Smaller" ErrorMessage="时间格式应该为“年月日”（如050101）,并且月<=12,日<=31" ControlToValidate="TextBox4" ValidationExpression="^(\d{2})((0?[1-9])|(1[0-2]))((0?[1-9])|((1|2)[0-9])|30|31)$"></asp:regularexpressionvalidator>
                <asp:RegularExpressionValidator id="RegularExpressionValidator4" style="Z-INDEX: 121; LEFT: 416px; POSITION: absolute; TOP: 248px"
                    runat="server" Font-Size="Smaller" ErrorMessage="时间格式应该为“年月日”（如050101）,并且月<=12,日<=31" ControlToValidate="TextBox4"
                    ValidationExpression="\d{6}$"></asp:RegularExpressionValidator>
                <asp:TextBox id="TextBox5" style="Z-INDEX: 122; LEFT: 248px; POSITION: absolute; TOP: 24px" runat="server"
                    BorderStyle="Groove" AutoPostBack="True"></asp:TextBox>
                <asp:DropDownList id="DropDownList4" style="Z-INDEX: 123; LEFT: 248px; POSITION: absolute; TOP: 56px"
                    runat="server" tabIndex="1"></asp:DropDownList>
                <asp:Label id="Label8" style="Z-INDEX: 124; LEFT: 168px; POSITION: absolute; TOP: 24px" runat="server"
                    ForeColor="#004040" Font-Size="Smaller">职工编号：</asp:Label>
                <asp:Button id="Button2" style="Z-INDEX: 125; LEFT: 416px; POSITION: absolute; TOP: 24px" runat="server"
                    Text="Button"></asp:Button></FONT></form>
        <script language="javascript" for="document" event="onkeydown"> 

<!-- 

  if(event.keyCode==13 && event.srcElement.type!='button' && event.srcElement.type!='submit' && event.srcElement.type!='reset' && event.srcElement.type!='') 

     event.keyCode=9; 

--> 

        </script>
    </body>
</HTML>

后台代码

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace lanchuxitong
{
    /// <summary>
    /// lanchudengji 的摘要说明。
    /// </summary>
    public class huoqiluru : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.Label Label1;
        protected System.Web.UI.WebControls.TextBox TextBox1;
        protected System.Web.UI.WebControls.Label Label2;
        protected System.Web.UI.WebControls.DropDownList DropDownList1;
        protected System.Web.UI.WebControls.Label Label3;
        protected System.Web.UI.WebControls.Label Label4;
        protected System.Web.UI.WebControls.TextBox TextBox3;
        protected System.Web.UI.WebControls.Label Label5;
        protected System.Web.UI.WebControls.DropDownList DropDownList2;
        protected System.Web.UI.WebControls.Label Label6;
        protected System.Web.UI.WebControls.DropDownList DropDownList3;
        protected System.Web.UI.WebControls.TextBox TextBox4;
        protected System.Web.UI.WebControls.Button Button1;
        protected System.Data.SqlClient.SqlConnection sqlConnection1;
        protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
        protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
        protected System.Data.SqlClient.SqlCommand sqlInsertCommand1;
        protected System.Web.UI.WebControls.DropDownList DropDownList4;
        protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter2;
        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
        protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter3;
        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
        protected System.Data.SqlClient.SqlCommand sqlSelectCommand3;
        protected System.Data.SqlClient.SqlCommand sqlInsertCommand3;
        protected System.Data.SqlClient.SqlConnection sqlConnection2;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
        protected System.Web.UI.WebControls.TextBox TextBox2;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator3;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator4;
        protected System.Web.UI.WebControls.TextBox TextBox5;
        protected System.Web.UI.WebControls.Label Label8;
        protected System.Data.SqlClient.SqlCommand sqlSelectCommand2;
        protected System.Data.SqlClient.SqlCommand sqlInsertCommand2;
        protected System.Data.SqlClient.SqlConnection sqlConnection3;
        protected System.Web.UI.WebControls.Button Button2;
        protected System.Web.UI.WebControls.Label Label7;
    
        private void Page_Load(object sender, System.EventArgs e)
        {
            // 在此处放置用户代码以初始化页面
            if(HttpContext.Current.User.IsInRole("registrar")==false)
            {                
                Response.ClearContent();
                Response.ClearHeaders();
                Response.Write("您没有权限执行该操作！");                
                Response.Flush();
                Response.Close();
            }
            /*if(!this.IsPostBack)
            {
                TextBox5.Text=DateTime.Now.ToString("yyyy-MM-dd");
            }*/
            if(!this.IsPostBack)
            {
                zjmDataBind();
            }
        }

        Web 窗体设计器生成的代码

        private void sqlConnection1_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
        {
        
        }
        private void zjmDataBind()
        {
            DataSet dsLanChu = new DataSet();            

            sqlDataAdapter1.Fill(dsLanChu, "BuMen");
            
            DropDownList1.DataSource = dsLanChu.Tables["BuMen"]; 
            DropDownList1.DataTextField = "bumenmingcheng";
            DropDownList1.DataValueField = "bumenbianma";
            DropDownList1.DataBind();

            sqlDataAdapter2.Fill(dsLanChu, "ZhiGong");
            
            DropDownList4.DataSource = dsLanChu.Tables["ZhiGong"]; 
            DropDownList4.DataTextField = "zhigongxingming";
            DropDownList4.DataValueField = "zhigongbianma";
            DropDownList4.DataBind();

            sqlDataAdapter3.Fill(dsLanChu, "KeHu");
            
            DropDownList3.DataSource = dsLanChu.Tables["KeHu"]; 
            DropDownList3.DataTextField = "kehuleixing";
            DropDownList3.DataValueField = "bianma";
            DropDownList3.DataBind();
        }

        private void Button1_Click(object sender, System.EventArgs e)
        {
            sqlConnection1.Open();
            SqlCommand sqlcmd1 = new SqlCommand("select * from lanchudengji where chuhuzhanghao='"+ TextBox2.Text +"'", sqlConnection1);
            SqlDataReader sqlreader1 = sqlcmd1.ExecuteReader();

            if(sqlreader1.HasRows == false)
            {
                sqlreader1.Close();
                /*sqlreader2.Close();*/
                SqlCommand cmd1 = new SqlCommand("insert into lanchudengji (zhigongming,suoshubumen,chuhuzhanghao,lanchujine,lanchuleixing,dakehu,cunruriqi,lururiqi) values ('"+ DropDownList4.SelectedItem.Text +"','"+ DropDownList1.SelectedItem.Value +"','" + TextBox2.Text + "','"+ TextBox3.Text +"','"+ DropDownList2.SelectedItem.Text +"','"+ DropDownList3.SelectedItem.Text +"','"+ TextBox4.Text +"','"+ DateTime.Now.ToString("yyyy-MM-dd") +"')" , sqlConnection1);
                cmd1.ExecuteNonQuery();
                sqlConnection1.Close();
                Response.Write("<script language='javascript'>alert('增加成功');</script>");
            }
            else            
            {
                //Response.Write("<script language='javascript'>alert('该帐号已经由其他职工揽收');</script>");
                //}
                //回车键代替TAB键
                /*<script language="javascript">
    function keyDown()
    {
    var keycode=event.keyCode;
    if(keycode==13)
    event.keyCode=9;
    }
    document.onkeydown=keyDown;
        </script>*/
                sqlreader1.Close();
                SqlCommand sqlcmd2 = new SqlCommand("select zhigongming from lanchudengji where chuhuzhanghao='"+ TextBox2.Text +"'", sqlConnection1);
                SqlDataReader sqlreader2 = sqlcmd2.ExecuteReader();
                sqlreader2.Read();
                string strZiGongXingMing = sqlreader2.GetString(0);
                sqlreader2.Close();
            
                if(DropDownList4.SelectedItem.Text == strZiGongXingMing)
                {                    
                    SqlCommand cmd2 = new SqlCommand("insert into lanchudengji (zhigongming,suoshubumen,chuhuzhanghao,lanchujine,lanchuleixing,dakehu,cunruriqi,lururiqi) values ('"+ DropDownList4.SelectedItem.Text +"','"+ DropDownList1.SelectedItem.Value +"','" + TextBox2.Text + "','"+ TextBox3.Text +"','"+ DropDownList2.SelectedItem.Text +"','"+ DropDownList3.SelectedItem.Text +"','"+ TextBox4.Text +"','"+ DateTime.Now.ToString("yyyy-MM-dd") +"')" , sqlConnection1);
                    cmd2.ExecuteNonQuery();
                    sqlConnection1.Close();
                    Response.Write("<script language='javascript'>alert('增加成功');</script>");
                }
                else
                {
                    Response.Write("<script language='javascript'>alert('该帐号已经由其他职工揽收');</script>");
                }
            }
            

                TextBox2.Text="";
                TextBox3.Text="";
                TextBox4.Text="";
        }
        /*private void TextBox5_TextChanged(object sender, System.EventArgs e)
        
        {
            for(int i=0,i<=DropDownList4.Items.Count-1,i++)
            {
                 if(DropDownList4.Items[i].Value==TextBox5.Text)
                 {
                 DropDownList4.SelectedIndex=i;
                 }  
            }
        }*/
    }
}

posted on 2006-01-26 11:08  窜窜的自留地  阅读(389)  评论(0)  编辑  收藏  举报