// SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConSettings"]); SqlConnection con =Tools.ToolCon.CreateCon(); SqlCommand cmd = new SqlCommand(sqlstr,con); con.Open(); int cout =Convert.ToInt32(cmd.ExecuteScalar()); con.Close();
{
lblMsg.Text ="";
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack)
{
// Rf2.Visible =false;
// cutm1.Visible =false;
// Rpres1.Visible =false;
// Rpre2.Visible =false;
// Rf1.Visible =false;
//绑定城市
this.BindToddl();
//绑定打折机票
this.BindToDtl(); txtDstar.Value= System.DateTime.Today.ToShortDateString(); //开始日期
txtDDest.Value=System.DateTime.Today.ToShortDateString(); //终止日期
}
// txtDstar.Attributes.Add("onmouseover","return calendar()");
//创建数据库连接
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.btnLogin.Click += new System.EventHandler(this.Page_Load);
this.btnAgin.Click += new System.EventHandler(this.Btn_Click);
this.BtnImg.Click += new System.Web.UI.ImageClickEventHandler(this.BtnImg_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion
//绑定城市数据
private void BindToddl()
{
// SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConSettings"]);
SqlConnection con =Tools.ToolCon.CreateCon();
string sqlstr = "select DISTINCT * from aircity";
try
{
SqlCommand cmd = new SqlCommand(sqlstr,con);
con.Open();
SqlDataReader sdr =cmd.ExecuteReader();
//起点
ddlStar.DataSource = sdr;
ddlStar.DataTextField ="CityT";
ddlStar.DataValueField ="CityD";
ddlStar.DataBind();
//使在下拉框中的城市面上西安被选中
ddlStar.Items.FindByText("西安").Selected = true;
sdr.Close(); //终点
SqlDataReader sdr1 = cmd.ExecuteReader();
ddlDest.DataSource =sdr1;
ddlDest.DataTextField ="CityT";
ddlDest.DataValueField ="CityD";
ddlDest.DataBind();
ddlDest.Items.FindByText("北京").Selected =true;
sdr1.Close();
}
finally
{
con.Close();
}
}
//用户登录验证
private bool CstLogin(string name,string pwd)
{
string sqlstr ="select UID from Customers where Name='"+name+"'";
sqlstr +=" and Pwd ='"+pwd+"'";
// SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConSettings"]);
SqlConnection con =Tools.ToolCon.CreateCon();
SqlCommand cmd = new SqlCommand(sqlstr,con);
con.Open();
int cout =Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
if(cout > 0)
{
return true;
}
else
{
return false;
} }
//验证用户名
private bool CheckName()
{
string nameFomat=@"(.{2,20}$)";
return Regex.IsMatch(txtName.Value,nameFomat);
}
//验证密码
private bool CheckPwd()
{
string pwdFomat =@"([a-zA-Z0-9]{6,20}$)";
return Regex.IsMatch(txtPwd.Value,pwdFomat);
}
//重置方法
private void Btn_Click(object sender, System.EventArgs e)
{
string msg ;
string strWho = ((LinkButton)sender).CommandName;
switch(strWho)
{
case "btnLogin":
{
if(txtName.Value=="" || txtPwd.Value=="")
{
Page.RegisterStartupScript("alert","<script>alert(\"用户名和密码不能为空！\")</script>");
// btnLogin.Attributes.Clear();
// btnLogin.Attributes.Add("onclick","return alert('请输入用户名！')");
}
else
{
if(!CheckName())
{
msg ="请输入有效用户名!";
this.Alert(msg);
//btnLogin.Attributes.Clear();
//btnLogin.Attributes.Add("onclick","return alert('请输入有效用户名！')");
}
else
{
if(!CheckPwd())
{
msg ="请输入有效密码!";
this.Alert(msg);
// btnLogin.Attributes.Clear();
// btnLogin.Attributes.Add("onclick","return alert('请输入有效密码！')");
}
else
{
if(!CstLogin(txtName.Value,txtPwd.Value))
{
msg ="登录失败，请检查您的用户名和密码!";
this.Alert(msg);
// btnLogin.Attributes.Clear();
// btnLogin.Attributes.Add("onclick","return alert('登录失败，请检查您的用户名和密码！')");
}
else
{
// btnLogin.Attributes.Clear();
Response.Redirect("active_kg.aspx");
}
}
}
}
}
break;
case "btnAgin":
{
txtName.Value="";
txtPwd.Value ="";
}
break;
}
}
// private void btnAgin_Click(object sender, System.EventArgs e)
// {
//// Rf2.Visible =false;
//// cutm1.Visible =false;
//// Rpres1.Visible =false;
//// Rpre2.Visible =false;
//// Rf1.Visible =false;
// txtName.Value="";
// txtPwd.Value="";
//
// }
//登录方法
// private void btnLogin_Click(object sender, System.EventArgs e)
// {
// if(txtName.Value=="")
// {
// btnLogin.Attributes.Add("onclick","return alert('请输入用户名')");
// }
//// if(Page.IsValid)
//// {
//// Response.Redirect("active_kg.aspx");
//// }
// }
private void CustomValidator1_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
{
if(this.CstLogin(txtName.Value,args.Value))
{
args.IsValid =true;
}
else
{
// Rf2.Visible =false;
args.IsValid =false;
}
}
private void BindToDtl()
{
// SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConSettings"]);
SqlConnection con = Tools.ToolCon.CreateCon();
string sqlstr ="select top 6 * ,Airline.AiTxt as AATxt from AirDis, AirLine where AirLine.AiName =AirDis.AiName ";//order by AiNum DESC
SqlDataAdapter dpt = new SqlDataAdapter(sqlstr,con);
DataSet ds=new DataSet();
dpt.Fill(ds);
dtlDis.DataSource =ds;
dtlDis.DataBind();
} private void BtnImg_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string dFrom;
string dTo;
string dDate;
string uid; uid="wealcomm";
dFrom = ddlStar.SelectedValue.ToString();
dTo =ddlStar.SelectedValue.ToString();
dDate = txtDstar.Value.ToString(); Response.Redirect("http://168.et111.com/Seach.asp?Uid='"+uid+"'&T1='"+dFrom+"'&T2='"+dTo+"'&D1='"+dDate+"'");
}
public void Alert(string message)
{
string msg = message.Replace("\n", "\\n");
msg = message.Replace("\"", "'"); StringBuilder sb = new StringBuilder(50); sb.Append(@"<script language='javascript'>"); sb.Append(@"alert( """ + msg + @""" );"); sb.Append(@"</script>"); lblMsg.Text =sb.ToString();
}
}