?? car_shenqing.aspx.cs
字號:
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 car1
{
/// <summary>
/// car_shenqing 的摘要說明。
/// </summary>
public class car_shenqing : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.TextBox TextBox3;
protected System.Web.UI.WebControls.TextBox TextBox4;
protected System.Web.UI.WebControls.TextBox TextBox5;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.TextBox TextBox6;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
protected System.Web.UI.WebControls.Label Label2;
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
string S_part=Session["S_part"].ToString();
string S_name=Session["S_username"].ToString();
string S_id=Request["id"].ToString();
string SqlConn=System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
SqlConnection Conn=new SqlConnection(SqlConn);
Conn.Open();
string SqlStr1="select car_code,car_type from car where id='"+S_id+"'";
SqlCommand Comm1=new SqlCommand(SqlStr1,Conn);
SqlDataReader read1=Comm1.ExecuteReader();
if(read1.Read())
{
this.Label3.Text=read1["car_code"].ToString();
this.Label4.Text=read1["car_type"].ToString();
}
read1.Close();
Conn.Close();
this.Label1.Text=S_part;
this.Label2.Text=S_name;
}// 在此處放置用戶代碼以初始化頁面
}
#region Web 窗體設計器生成的代碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Button1_Click(object sender, System.EventArgs e)
{
string SqlConn=System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
SqlConnection Conn=new SqlConnection(SqlConn);
Conn.Open();
string SqlStr2="insert into shenqing(car_code,car_type,car_xingcheng,car_zuowei,car_start,car_end,car_cause,car_user,car_part,car_mobile) values('"+this.Label3.Text+"','"+this.Label4.Text+"','"+this.TextBox1.Text+"','"+this.TextBox4.Text+"','"+this.TextBox3.Text+"','"+this.TextBox2.Text+"','"+this.TextBox5.Text+"','"+this.Label2.Text+"','"+this.Label1.Text+"','"+this.TextBox6.Text+"')";
SqlCommand Comm2=new SqlCommand(SqlStr2,Conn);
Comm2.ExecuteReader();
Response.Write("<script language='javascript'>alert('您的申請已經提交成功,我們將在24小時之內以短信的形式通知您申請用車的結果,請注意查收。謝謝!');</script>");
this.TextBox1.Text="";
this.TextBox2.Text="";
this.TextBox3.Text="";
this.TextBox4.Text="";
this.TextBox5.Text="";
this.TextBox6.Text="";
Response.Write("<script language='javascript'>window.close();</script>");
Conn.Close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -