xg.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.IO;

namespace djks
{
	/// <summary>
	/// xg 的摘要说明。
	/// </summary>
	public class xg : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox Txt_zdyxx;
		protected System.Web.UI.WebControls.TextBox txt_lxdz;
		protected System.Web.UI.WebControls.TextBox Txt_lxdh;
		protected System.Web.UI.WebControls.CustomValidator CustomValidator1;
		protected System.Web.UI.WebControls.TextBox txt_ykh;
		protected System.Web.UI.WebControls.DropDownList Drl_blcj;
		protected System.Web.UI.WebControls.DropDownList Drl_whcd;
		protected System.Web.UI.WebControls.DropDownList Drl_zy;
		protected System.Web.UI.WebControls.DropDownList Drl_mz;
		protected System.Web.UI.WebControls.TextBox txt_birthday;
		protected System.Web.UI.WebControls.DropDownList Drl_xb;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator3;
		protected System.Web.UI.WebControls.TextBox txt_xm;
		protected System.Web.UI.WebControls.RegularExpressionValidator Rev_pid;
		protected System.Web.UI.WebControls.DropDownList Drl_bkyy;
		protected System.Web.UI.WebControls.Panel panl2;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		protected System.Web.UI.HtmlControls.HtmlInputText txt_sfzh;
	    private static string id ,old_bmh,bmh,havexp="0";
		protected System.Web.UI.WebControls.Button btn_refer;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!this.IsPostBack)
			{
				if(Request.QueryString["sfzh"]!=null&&Request.QueryString["xm"]!=null)
				{
					this.txt_xm.Text=Request.QueryString["xm"].ToString();
					this.txt_sfzh.Value=Request.QueryString["sfzh"].ToString();
					this.drplbind(this.txt_xm.Text,this.txt_sfzh.Value);
				}
				else
				{
					Response.Redirect("xgbmxx.aspx");
				}
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btn_refer.Click += new System.EventHandler(this.btn_refer_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
		private void drplbind(string xm,string sfzh)
		{
			DataTable dt=new DataTable();
//			string pid=this.txt_pid.Text.ToString();
//			string name=this.txt_name.Text.ToString().Replace(" ","");
			string strSql="select * from bmk where XM='"+xm+"'and SFZH='"+sfzh+"'";  //查询语句
			DataSet ds=new DataSet();
			ds=database.CreateDateSet(strSql);
			dt=ds.Tables[0];
			string Sql_JBYY="select JBYYDM,JBYY from JBYY"; //报考语言查询语句
			string jbyy;		
			old_bmh=dt.Rows[0]["BMH"].ToString();
			bmh=old_bmh;
			jbyy=old_bmh.Substring(6,2); 			
			database.drpl_bind(Sql_JBYY,this.Drl_bkyy,jbyy);             //数据绑定函数调用			
			
			string Sql_MZ="select * from MZ";     //民族下拉列表数据绑定
			database.drpl_bind(Sql_MZ,this.Drl_mz,dt.Rows[0]["MZ"].ToString()); 
			
			string Sql_ZY="select * from ZY";     //职业下拉列表数据绑定
			database.drpl_bind(Sql_ZY,Drl_zy,dt.Rows[0]["ZY"].ToString());

			string Sql_WHCD="select * from WHCD";    //文化程度下拉列表数据绑定
			database.drpl_bind(Sql_WHCD,Drl_whcd,dt.Rows[0]["WHCD"].ToString());

			string Sql_BLCJ="select * from BLCJ";    //保留成绩绑定
			database.drpl_bind(Sql_BLCJ,this.Drl_blcj,dt.Rows[0]["BLCJZL"].ToString());
　　　　　　
			if(dt.Rows[0]["XB"].ToString()=="2")
			{
				this.Drl_xb.SelectedValue="女";
			}
			txt_xm.Text=dt.Rows[0]["XM"].ToString();			
			this.txt_sfzh.Value=dt.Rows[0]["SFZH"].ToString();			
			txt_birthday.Text=dt.Rows[0]["CSRQ"].ToString();
			Txt_lxdh.Text=dt.Rows[0]["LXDH"].ToString();
			txt_lxdz.Text=dt.Rows[0]["LXDZ"].ToString();
			txt_ykh.Text=dt.Rows[0]["YZKZH"].ToString();
			Txt_zdyxx.Text=dt.Rows[0]["ZDYXX"].ToString();
			havexp=dt.Rows[0]["HAVEXP"].ToString();
			id=dt.Rows[0]["id"].ToString();
//			photoname=old_bmh+".jpg";
			//			if(havexp=="1")
			//			{
			//				this.Image1.ImageUrl="photo/"+old_bmh+".jpg";
			//				photoname=old_bmh+".jpg";
			//			}
			//			else
			//			{
			//				this.Image1.ImageUrl="images/photo.gif";
			//			}
		}

		private void btn_refer_Click(object sender, System.EventArgs e)
		{
			string xm,xb,csrq,mz,sfzh,zy,whcd,blcjzl;
		    string yzkzh,lxdh,lxdz,zdyxx;
		    string bkyy;
			
			Random random=new Random();
			string bmh_tem;                               //报名号生成
			string xb_tem;
			hxyy_js.jsAlert(bmh);
			bmh_tem=bmh.Substring(8);			         //取得报名序号
			bmh="410013"+this.Drl_bkyy.SelectedValue+bmh_tem;     //生成新的报名号
			xm=this.txt_xm.Text.Replace(" ","").ToString();
			csrq=this.txt_birthday.Text.ToString();
			mz=this.Drl_mz.SelectedValue;
//			mz_text=this.Drl_mz.SelectedItem.Text;
			sfzh=this.txt_sfzh.Value.ToString();
			zy=this.Drl_zy.SelectedValue;
//			zy_text=this.Drl_zy.SelectedItem.Text;
			whcd=this.Drl_whcd.SelectedValue;
//			whcd_text=this.Drl_whcd.SelectedItem.Text;
			yzkzh=this.txt_ykh.Text;
			blcjzl=this.Drl_blcj.SelectedValue;
//			blcjzl_text=this.Drl_blcj.SelectedItem.Text;;
			lxdz=this.txt_lxdz.Text;
			lxdh=this.Txt_lxdh.Text;
			zdyxx=this.Txt_zdyxx.Text;
			bkyy=this.Drl_bkyy.SelectedValue;
//			bkyy_text=this.Drl_bkyy.SelectedItem.Text;
			xb_tem=this.Drl_xb.SelectedValue.ToString();
			if(xb_tem=="男")
			{
				xb="1";
			}
			else
			{
				xb="2";
			}
			
			string strSql="update bmk set ZKZH='"+bmh+"',BMH='"+bmh+"',XM='"+xm+"',SFZH='"+sfzh+"',XB='"+xb+"',CSRQ='"+csrq+"',MZ='"+mz+"',ZY='"+zy+"',WHCD='"+whcd+"',YZKZH='"+yzkzh+"',BLCJZL='"+blcjzl+"',LXDZ='"+lxdz+"',LXDH='"+lxdh+"',ZDYXX='"+zdyxx+"',HAVEXP="+havexp+" where id="+id;   //更新语句
			bool flag=database.doSql(strSql);			
			if(!flag)
			{
				hxyy_js.jsAlert("操作失败");
			}
			if(havexp=="1")
			{
				//				this.Image1.ImageUrl="photo/"+old_bmh+".jpg"+"?"+random.Next(100).ToString();
				//				photoname=old_bmh+".jpg";
							
					
				if(old_bmh!=bmh)      //判断是否更改了报考语言，如果不相同，则修改原照片名字；
				{
					try
					{	
						if(File.Exists(Server.MapPath("photo/")+bmh+".jpg"))    //判断是否存在与新报名号相同的照片，若存在则删除
						{
							File.Delete(Server.MapPath("photo/")+bmh+".jpg");
						}
						File.Move(Server.MapPath("photo/")+old_bmh+".jpg",Server.MapPath("photo/")+bmh+".jpg");      //修改照片名。
									
					}
					catch
					{
						hxyy_js.jsAlert("由于报考语言修改而导致照片在修改中出错，为保证你的信息无误，请到相关部门查证！");
					}
					
//					this.Image1.ImageUrl="photo/"+bmh+".jpg"+"?"+random.Next(100).ToString();				
				}
				
			}
			Response.Redirect("chakan.aspx?sfzh="+sfzh+"&xm="+xm);
//			else
//			{
//				this.Image1.ImageUrl="images/nopho.jpg";
//			}
//			old_bmh=bmh;

		}

		
	}
}