ziliaoxiugai.aspx.cs

简易BBS源码,包括系统管理、论坛管理、用户可以看懂源码

using System;
using System.Collections;
using System.ComponentModel;
using System.Data.SqlClient;
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;
using System.IO;
namespace free.bbs
{
	/// <summary>
	/// Summary description for ziliaoxiugai.
	/// </summary>
	public partial class ziliaoxiugai : System.Web.UI.Page
	{
	   
		/// <summary>
		/// </summary>
       
		//		string mysql;
		SqlConnection mycon;
		SqlCommand mycom;
		string path;
		string upstr;
		protected System.Data.SqlClient.SqlDataReader reader;

		protected void Page_Load(object sender, System.EventArgs e)
		{
			try
			{
				yonghuming.Text=Request.Cookies["free_huiyuan"].Value.ToString();
				//				mysql="SELECT * FROM huiyuan WHERE yonghuming='"+Request.Cookies["free_huiyuan"].Value.ToString()+"'";
				
			}
			catch
			{
				Response.Redirect("error.aspx");
			}
			mycon=new SqlConnection(Session["str_connection"].ToString());
			if(!Page.IsPostBack)
			{
				bangding();
			}
		}
		private void bangding()
		{
			mycon.Open();
			string mysql="select * from huiyuan where yonghuming='"+yonghuming.Text+"'";
			mycom=new SqlCommand(mysql,mycon);
			reader=mycom.ExecuteReader();
			string str1="",str2="",str3="",str4="",str5="";
			reader.Read();
            //sheng
			try
			{
				for(int i=0;i<=d_sheng.Items.Count-1;i++)
				{
					if(d_sheng.Items[i].Value==reader["sheng"].ToString().Trim())
					{
						d_sheng.Items[i].Selected=true;
					}
				}
				
			}
			catch
			{
			}
			//touxian
			try
			{
				for(int i=0;i<=touxiang.Items.Count-1;i++)
				{
					if(touxiang.Items[i].Value==reader["touxian"].ToString().Trim())
					{
						touxiang.Items[i].Selected=true;
					}
				}
				
			}
			catch
			{
				touxiang.Items[0].Selected=true;
			}
            //zhye
			try
			{
				for(int i=0;i<=zhiye.Items.Count-1;i++)
				{
					if(zhiye.Items[i].Value==reader["touxian"].ToString().Trim())
					{
						zhiye.Items[i].Selected=true;
					}
				}
				
			}
			catch
			{
				zhiye.Items[0].Selected=true;
			}

			//zhye
			try
			{
				for(int i=0;i<=zhiye.Items.Count-1;i++)
				{
					if(zhiye.Items[i].Value==reader["zhiye"].ToString().Trim())
					{
						zhiye.Items[i].Selected=true;
					}
				}
				
			}
			catch
			{
				zhiye.Items[0].Selected=true;
			}

           //face
			try
			{
				for(int i=0;i<=face.Items.Count-1;i++)
				{
					if(face.Items[i].Value==reader["face"].ToString().Trim())
					{
						face.Items[i].Selected=true;
					}
				}
				
			}
			catch
			{
				face.Items[0].Selected=true;
			}


			try
			{
				if(reader["xingbie"].ToString().Trim()!="不祥")
				{
					if (reader["xingbie"].ToString().Trim()=="男")
						xingbie.Items[0].Selected=true;
					else if(reader["xingbie"].ToString().Trim()=="女")  
						d_sheng.Items[1].Selected=true;
				}
			}
			catch
			{
				xingbie.Items[0].Selected=false;
				xingbie.Items[1].Selected=false;
			}
			try
			{
				str1=reader["chushengriqi"].ToString().Trim();
				str2=reader["mimatishi"].ToString().Trim();
				str3=reader["mimadaan"].ToString().Trim();
				str4=reader["qianming"].ToString().Trim();
				str5=reader["qianming_pic"].ToString().Trim();
			}
			catch
			{
				
			}
			shengri.Text=str1;
			TextBox1.Text=str2;
			TextBox2.Text=str3;
			qianming.Text=htmldecode(str4).Replace("<br>","\r\n");
			//File1.Value=str5;
			
			reader.Close();
			mycon.Close();
		}




		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion

		protected void Button1_Click(object sender, System.EventArgs e)
		{
			mycon.Open();
			bool flag=true;
			string filename;
			
			if(File1.Value=="")
			{ 
				flag=false;
			}
			if(flag==true)
			{
				if (File1.PostedFile.ContentLength==0)
				{
					Response.Write("<script>alert('你没有选择要上载的文件或者上传的文件长度为0!')</script>");
				}
				else if(File1.PostedFile.ContentLength>50000)
				{
					Response.Write("<script>alert('你上载的文件或者上传的文件长度不能超过50K!')</script>");
					return;
				}
				else
				{
					filename=Path.GetFileName(File1.PostedFile.FileName);
					path=Server.MapPath("qianming_pic//");
					if( Directory.Exists(path)==false)
						Directory.CreateDirectory (path) ;
					path+=filename;
					if( File.Exists(path)==true)
						
					{
						Response.Write("<script>alert('该图片文件名已经存在')</script>");
						flag=false;
						return;
						
					}
					else
					{
						mycom=new SqlCommand("select qianming_pic from huiyuan where yonghuming='"+Request.Cookies["free_huiyuan"].Value.ToString()+"'",mycon);
						if(mycom.ExecuteScalar().ToString().Trim()!="./qianming_pic/moren.GIF")
						{
							string qinming=mycom.ExecuteScalar().ToString();							
							qinming=Server.MapPath(qinming);
							try 
							{
								File.Delete(qinming.Trim());
							}
							catch{};
						}
						
						File1.PostedFile.SaveAs(path);
						path="./qianming_pic/"+filename;
					}
				}
				
			}
			if(flag==true)
			{
				upstr="UPDATE huiyuan SET touxian='"+touxiang.SelectedValue+"',face='"+face.SelectedValue+"', chushengriqi=@chushengriqi,sheng='"+d_sheng.SelectedValue+"',xingbie='"+xingbie.SelectedValue+"',shi='"+d_shi.SelectedValue+"',zhiye='"+zhiye.SelectedValue+"',qianming=@qianming,qianming_pic='"+path+"', mimatishi=@wenti,mimadaan=@daan WHERE yonghuming='"+yonghuming.Text+"'";
			}
			else
				upstr="UPDATE huiyuan SET touxian='"+touxiang.SelectedValue+"',face='"+face.SelectedValue+"', chushengriqi=@chushengriqi,sheng='"+d_sheng.SelectedValue+"',xingbie='"+xingbie.SelectedValue+"',shi='"+d_shi.SelectedValue+"',zhiye='"+zhiye.SelectedValue+"',qianming=@qianming, mimatishi=@wenti,mimadaan=@daan WHERE yonghuming='"+yonghuming.Text+"'";


			
			mycom=new SqlCommand(upstr,mycon);
			mycom.Parameters.Add(new SqlParameter("@chushengriqi",SqlDbType.Char,8));
			mycom.Parameters["@chushengriqi"].Value=shengri.Text.Trim();
			mycom.Parameters.Add(new SqlParameter("@qianming",SqlDbType.NVarChar,256));
			mycom.Parameters["@qianming"].Value=htmlencode(qianming.Text.Trim());
			mycom.Parameters.Add(new SqlParameter("@wenti",SqlDbType.VarChar,50));
			mycom.Parameters["@wenti"].Value=TextBox1.Text.Trim();
			mycom.Parameters.Add(new SqlParameter("@daan",SqlDbType.VarChar,50));
			mycom.Parameters["@daan"].Value=TextBox2.Text.Trim();

			try
			{
				mycom.ExecuteNonQuery();
				Response.Write("<script>alert('恭喜：***资料修改成功！')</script>");
			}
			catch
			{
				Response.Write("<script>alert('错误：***资料修改失败！')</script>");
			}
			finally
			{
				mycon.Close();
			}
			bangding();
			
		}
		private string htmlencode(string str)
		{
			str=Server.HtmlEncode(str);
			str=str.Replace("\r\n","<br>");
			char ch;
			ch=(char)32;
			str=str.Replace(ch.ToString(),"");
			return str;
		}
		private string htmldecode(string str)
		{
			str=Server.HtmlDecode(str);
			str=str.Replace("\r\n","<br>");
			//			char ch;
			//			ch=(char)32;
			//			str=str.Replace(ch.ToString(),"");
			return str;
		}
		protected void d_sheng_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			switch (d_sheng.SelectedValue)
			{
				case "湖南":
					d_shi.Items.Clear();
					d_shi.Items.Add("长沙市");
					d_shi.Items.Add("张家界市");
					d_shi.Items.Add("常德市");
					d_shi.Items.Add("益阳市");
					d_shi.Items.Add("岳阳市");
					d_shi.Items.Add("株洲市");
					d_shi.Items.Add("湘潭市");
					d_shi.Items.Add("衡阳市");
					d_shi.Items.Add("郴州市");
					d_shi.Items.Add("永州市");
					d_shi.Items.Add("邵阳市");
					d_shi.Items.Add("怀化市");
					d_shi.Items.Add("娄底市");
					d_shi.Items.Add("湘西");
					d_shi.Items.Add("其他");
					break;
				case "西藏":
					d_shi.Items.Clear();
					d_shi.Items.Add("拉萨市");
					d_shi.Items.Add("那曲地区");
					d_shi.Items.Add("昌都地区");
					d_shi.Items.Add("林芝地区");
					d_shi.Items.Add("山南地区");
					d_shi.Items.Add("日喀则地区");
					d_shi.Items.Add("阿里地区");
					d_shi.Items.Add("其他");
					break;
				case "甘肃":
					d_shi.Items.Clear();
					d_shi.Items.Add("兰州市");
					d_shi.Items.Add("嘉峪关市 ");
					d_shi.Items.Add("金昌市");
					d_shi.Items.Add("白银市");
					d_shi.Items.Add("天水市");
					d_shi.Items.Add("酒泉市");
					d_shi.Items.Add("张掖市");
					d_shi.Items.Add("武威市");
					d_shi.Items.Add("庆阳市");
					d_shi.Items.Add("平凉市");
					d_shi.Items.Add("定西地区");
					d_shi.Items.Add("陇南地区");
					d_shi.Items.Add("临夏回族自治州");
					d_shi.Items.Add("甘南藏族自治州");
					d_shi.Items.Add("玉门市");
					d_shi.Items.Add("敦煌市");
					d_shi.Items.Add("其他");
					break;
				case "青海":
					d_shi.Items.Clear();
					d_shi.Items.Add("西宁市");
					d_shi.Items.Add("海东地区");
					d_shi.Items.Add("海北藏族自治州");
					d_shi.Items.Add("海南藏族自治州");
					d_shi.Items.Add("黄南藏族自治州");
					d_shi.Items.Add("果洛藏族自治州");
					d_shi.Items.Add("玉树藏族自治州");
					d_shi.Items.Add("海西蒙古族藏族自治州");
					d_shi.Items.Add("其他");
					break;
				case "内蒙古":
					d_shi.Items.Clear();
					d_shi.Items.Add("呼和浩特市");
					d_shi.Items.Add("包头市");
					d_shi.Items.Add("乌海市");
					d_shi.Items.Add("赤峰市");
					d_shi.Items.Add("呼伦贝尔");
					d_shi.Items.Add("兴安盟");
					d_shi.Items.Add("锡林郭勒盟");
					d_shi.Items.Add("乌兰察布盟");
					d_shi.Items.Add("巴彦淖尔盟");
					d_shi.Items.Add("阿拉善盟");
					d_shi.Items.Add("鄂尔多斯市");
					d_shi.Items.Add("通辽市");
					d_shi.Items.Add("其他");
					break;
				case "宁夏":
					d_shi.Items.Clear();
					d_shi.Items.Add("银川市");
					d_shi.Items.Add("石嘴山市");
					d_shi.Items.Add("吴忠市");
					d_shi.Items.Add("固原地区");
					d_shi.Items.Add("其他");
					break;
				case "四川":
					d_shi.Items.Clear();
					d_shi.Items.Add("成都市");
					d_shi.Items.Add("广元市");
					d_shi.Items.Add("绵阳市");
					d_shi.Items.Add("德阳市");
					d_shi.Items.Add("南充市");
					d_shi.Items.Add("广安市");
					d_shi.Items.Add("遂宁市");
					d_shi.Items.Add("内江市"); 
					d_shi.Items.Add("乐山市");
					d_shi.Items.Add("自贡市");
					d_shi.Items.Add("泸州市");
					d_shi.Items.Add("宜宾市");