recoverpasswd.aspx.cs

勇敢者论坛全部源代码。 支持SQL2000/Access数据库

			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Birthday", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Birthday", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Email", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Email", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Enabled", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Enabled", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_HomePage", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "HomePage", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Last_Date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Last_Date", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Logon_Counter", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Logon_Counter", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Name", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Password", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Password", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Phone", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_QICQ", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "QICQ", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Reg_Date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Reg_Date", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_User_Grade", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "User_Grade", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_jifen", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "jifen", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_sex", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "sex", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_work_Name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "work_Name", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM Users WHERE (User_Name = @Original_User_Name) AND (Address = @Original_Address OR @Original_Address IS NULL AND Address IS NULL) AND (Birthday = @Original_Birthday OR @Original_Birthday IS NULL AND Birthday IS NULL) AND (Email = @Original_Email OR @Original_Email IS NULL AND Email IS NULL) AND (Enabled = @Original_Enabled OR @Original_Enabled IS NULL AND Enabled IS NULL) AND (HomePage = @Original_HomePage OR @Original_HomePage IS NULL AND HomePage IS NULL) AND (Last_Date = @Original_Last_Date OR @Original_Last_Date IS NULL AND Last_Date IS NULL) AND (Logon_Counter = @Original_Logon_Counter OR @Original_Logon_Counter IS NULL AND Logon_Counter IS NULL) AND (Name = @Original_Name OR @Original_Name IS NULL AND Name IS NULL) AND (PKID = @Original_PKID) AND (Password = @Original_Password OR @Original_Password IS NULL AND Password IS NULL) AND (Phone = @Original_Phone OR @Original_Phone IS NULL AND Phone IS NULL) AND (QICQ = @Original_QICQ OR @Original_QICQ IS NULL AND QICQ IS NULL) AND (Reg_Date = @Original_Reg_Date OR @Original_Reg_Date IS NULL AND Reg_Date IS NULL) AND (User_Grade = @Original_User_Grade OR @Original_User_Grade IS NULL AND User_Grade IS NULL) AND (jifen = @Original_jifen OR @Original_jifen IS NULL AND jifen IS NULL) AND (sex = @Original_sex OR @Original_sex IS NULL AND sex IS NULL) AND (work_Name = @Original_work_Name OR @Original_work_Name IS NULL AND work_Name IS NULL)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_User_Name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "User_Name", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Address", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Birthday", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Birthday", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Email", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Email", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Enabled", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Enabled", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_HomePage", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "HomePage", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Last_Date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Last_Date", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Logon_Counter", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Logon_Counter", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Name", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_PKID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PKID", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Password", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Password", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Phone", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_QICQ", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "QICQ", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Reg_Date", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Reg_Date", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_User_Grade", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "User_Grade", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_jifen", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "jifen", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_sex", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "sex", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_work_Name", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "work_Name", System.Data.DataRowVersion.Original, null));
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=KEKC;packet size=4096;user id=sa;data source=localhost;persist sec" +
				"urity info=True;initial catalog=doughty_cn;password=123";
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "Users", new System.Data.Common.DataColumnMapping[] {
																																																			   new System.Data.Common.DataColumnMapping("PKID", "PKID"),
																																																			   new System.Data.Common.DataColumnMapping("User_Name", "User_Name"),
																																																			   new System.Data.Common.DataColumnMapping("Password", "Password"),
																																																			   new System.Data.Common.DataColumnMapping("Name", "Name"),
																																																			   new System.Data.Common.DataColumnMapping("sex", "sex"),
																																																			   new System.Data.Common.DataColumnMapping("Email", "Email"),
																																																			   new System.Data.Common.DataColumnMapping("QICQ", "QICQ"),
																																																			   new System.Data.Common.DataColumnMapping("Address", "Address"),
																																																			   new System.Data.Common.DataColumnMapping("HomePage", "HomePage"),
																																																			   new System.Data.Common.DataColumnMapping("work_Name", "work_Name"),
																																																			   new System.Data.Common.DataColumnMapping("Phone", "Phone"),
																																																			   new System.Data.Common.DataColumnMapping("Birthday", "Birthday"),
																																																			   new System.Data.Common.DataColumnMapping("Memos", "Memos"),
																																																			   new System.Data.Common.DataColumnMapping("Reg_Date", "Reg_Date"),
																																																			   new System.Data.Common.DataColumnMapping("User_Grade", "User_Grade"),
																																																			   new System.Data.Common.DataColumnMapping("Last_Date", "Last_Date"),
																																																			   new System.Data.Common.DataColumnMapping("Logon_Counter", "Logon_Counter"),
																																																			   new System.Data.Common.DataColumnMapping("Enabled", "Enabled"),
																																																			   new System.Data.Common.DataColumnMapping("jifen", "jifen")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;

		}
		#endregion

		protected void Button1_Click(object sender, System.EventArgs e)
		{
			//this.sqlConnection1.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["DBConnection"];
			//this.sqlDataAdapter1.SelectCommand.Parameters["@User_Name"].Value=TB_Username.Text;
			//this.sqlDataAdapter1.SelectCommand.Connection.Open();
			//this.sqlDataAdapter1.SelectCommand.ExecuteNonQuery();
			//this.sqlDataAdapter1.Fill(this.dS_Users1);
			//dS_Users1.Tables[0].Select("" );
			//foreach( DataRow r in drs )
			//{
			bool Haved=false;
			try
			{
				try
				{
                    DataRow r = DBOperate.GetDataRow("SELECT PKID, User_Name, Password, Name, sex, Email, QICQ, Address, HomePage, work_Name, Phone, Birthday, Memos, Reg_Date, User_Grade, Last_Date, Logon_Counter, Enabled, jifen FROM Users WHERE (User_Name ='" + TB_Username.Text + "')", "Users", "DBConnection");
					if (TB_Username.Text == r["User_Name"].ToString())
					{
						try 
						{
							UserNotify usernotify = new UserNotify();
							if (usernotify.SendMail(r["Email"].ToString(),r["Name"].ToString()+" 你好："+"\n\n  您在 "+doughty_cn.inputcon.ConvertString.TitleName(this.Request.Url.ToString())
								+" 寻找的用户信息！\n  获得的注册信息：\n\n    用户名："+r["User_Name"].ToString()+"\n    口令："+r["Password"].ToString()
								+"\n\n\n\n                                  "+doughty_cn.inputcon.ConvertString.TitleName(this.Request.Url.ToString())
								+"\n                                  "+ DateTime.Now.ToString()))
							{
								Lbl_Msg.Text="已经发入你的邮箱："+r["Email"].ToString();
								Haved=true;
							}
							else
							{
								Lbl_Msg.Text="未提供此功能，请与管理员联系。"+System.Configuration.ConfigurationSettings.AppSettings["MailFrom"];
								return;
							}
						}
						catch
						{
							Lbl_Msg.Text ="错误：邮件发送失败，可能注册的邮箱非法！";
							return;
						}
					}
				}
				catch
				{
				}
			}
			finally
			{
				if (!Haved)
				{
					Lbl_Msg.Text="用户名不存在或注册邮箱有问题！";
				}
			}
		}
	}
}