baoming.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.OleDb;
using System.Data.Odbc;

namespace BBK
{
	/// <summary>
	/// baoming 的摘要说明。
	/// </summary>
	public partial class baoming : System.Web.UI.Page
	{
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if( Session["userid"]=="")
			{
				Page.Response.Redirect("bbklogin.aspx");

			}

			if(!Page.IsPostBack)
			{
				if(Session["idcard"]=="")
				{
					Button2.Attributes.Add("onclick", "javascript:return confirm('您确认您的信息填写无误吗?');");	
					bindyear();
					bindmonth();
					bindday();			
					bind(Ddlzymch,"专业名称");//专业名称
					bind(Ddlwgy,"外国语");//外国语
					bind(Ddlywk1,"业务课一");//业务课一	
					bind(Ddlywk2,"业务课二");//业务课二	
					Textdwdm.Text="10216";
					Textdwmc.Text="燕山大学";
				}
				else
				{
					Button2.Attributes.Add("onclick", "javascript:return confirm('您确认您的信息填写无误吗?');");	
					bindyear();
					bindmonth();
					bindday();			
					bind(Ddlzymch,"专业名称");//专业名称
					bind(Ddlwgy,"外国语");//外国语
					bind(Ddlywk1,"业务课一");//业务课一	
					bind(Ddlywk2,"业务课二");//业务课二	
					//
					
					int n =0;
					string dbname=Server.MapPath("database/bbk.mdb");
					string 	strcon= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+dbname;
					OleDbConnection olecon=new OleDbConnection(strcon);		
					string sql="select * from 10216bbk where sfzh='"+Convert.ToString( Session["idcard"])+"'";
					OleDbCommand olecom=new OleDbCommand(sql,olecon);
					olecon.Open();
					OleDbDataReader reader=olecom.ExecuteReader ();      
					reader.Read ();
					if (reader.HasRows ==true)
					{
						
						//
						Textdwdm.Text="10216";
						Textdwmc.Text="燕山大学";
						Textxm.Text=reader["xm"].ToString();
						Textxmpy.Text=reader["xmpy"].ToString();
						Textsfzh.Text=reader["sfzh"].ToString();
						Ddlbiryear.SelectedItem.Text=reader["csrq"].ToString().Trim().Substring(0,4);
						Ddlbirmonth.SelectedValue=Convert.ToInt32(reader["csrq"].ToString().Trim().Substring(4,2)).ToString();
						Ddlbirday.SelectedValue=Convert.ToInt32(reader["csrq"].ToString().Trim().Substring(6,2)).ToString();
						Ddlmz.SelectedIndex=Convert.ToInt32(reader["mzm"].ToString().Trim());
						Ddlxbm.SelectedIndex=Convert.ToInt32(reader["xbm"].ToString().Trim());
						Ddlhf.SelectedValue=reader["hfm"].ToString().Trim();
						Ddlzhzhmm.SelectedValue=reader["zzmmm"].ToString().Trim();
						Ddlzhxw.SelectedValue=reader["xwm"].ToString().Trim();
						Ddlxwfs.SelectedValue=reader["xwfsm"].ToString().Trim();
						Textxwdwm.Text=reader["xwdwm"].ToString();
						Textxwdwmc.Text=reader["xwdwmc"].ToString();
						Ddleduyear.SelectedValue=reader["xwnd"].ToString().Trim().Substring(0,4);
						Ddledumonth.SelectedValue=Convert.ToInt32(reader["xwnd"].ToString().Trim().Substring(4,2)).ToString();
						Ddlksly.SelectedValue=reader["kslym"].ToString();
						Ddlkszssm.SelectedValue=reader["hkszssm"].ToString();
						if(reader["xyjrm"].ToString()=="")
						{
							RadioButtonList1.SelectedValue="否";
						}
						else
						{
							RadioButtonList1.SelectedValue="是";
						}
						Textksdw.Text=reader["ksdw"].ToString();
						if(reader["dwszssm"].ToString()=="")
						{
							Ddldwszssm.SelectedValue="";
						}
						else
						{
						Ddldwszssm.SelectedValue=reader["dwszssm"].ToString();
						}
						Textksdwdz.Text=reader["ksdwdz"].ToString();
						Textksdwyb.Text=reader["ksdwyb"].ToString();
						Texttxdz.Text=reader["txdz"].ToString();
						Textyzbm.Text=reader["yzbm"].ToString();
						Textlxdh.Text=reader["lxdh"].ToString();
						Textdzxx.Text=reader["dzxx"].ToString();
						Ddlzymch.SelectedValue=reader["zydm"].ToString();
						Ddlksfs.SelectedValue=reader["ksfsm"].ToString();
						Ddlbklb.SelectedValue=reader["bklbm"].ToString();
						Textbkbdxm.Text=reader["bkbdxm"].ToString();
						Ddlbdsx.SelectedValue=reader["bdsx"].ToString();
						Ddlwgy.SelectedValue=reader["wgym"].ToString();
						Ddlywk1.SelectedValue=reader["ywk1m"].ToString();
						Ddlywk2.SelectedValue=reader["ywk2m"].ToString();
						Textbzh.Text=reader["byxx"].ToString();
					}
				}
			}
		}

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

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{

		}
		private void bindyear()
		{
			for(int i=1930;i<2007;i++)
			{
				Ddlbiryear.Items.Add(i.ToString());
				Ddleduyear.Items.Add(i.ToString());
			}
			Ddlbiryear.SelectedIndex =50;
			Ddleduyear.SelectedIndex =70;
		}
		private void bindmonth()
		{
			for(int i=1;i<13;i++)
			{
				Ddlbirmonth.Items.Add(i.ToString());
				Ddledumonth.Items.Add(i.ToString());
				
			}
		}
		private void bindday()
		{
			for(int i=1;i<32;i++)
			{
				Ddlbirday.Items.Add(i.ToString());				
			}
		}
		//根据绑定类型,和ddl 绑定
		private void bind(DropDownList droplist, string bdlx)
		{
			DataSet ds=new DataSet();
			string dbname=Server.MapPath("database/bbk.mdb");
			string 	strcon= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+dbname;
			OleDbConnection olecon=new OleDbConnection(strcon);				
			//string sql="select BH,MC= case when BH is null or BH='' then MC else '('+BH+')'+MC end  from xx where LX='"+bdlx+"'";
			string sql="select BH,  MC  from xx where LX='"+bdlx+"'";

			OleDbDataAdapter da=new OleDbDataAdapter(sql,olecon);
			da.Fill(ds,"xzlx");
			droplist.DataSource=ds.Tables["xzlx"].DefaultView;
			droplist.DataTextField="MC";
			droplist.DataValueField="BH";
			droplist.DataBind();		
		}

		protected void Button2_Click(object sender, System.EventArgs e)
		{
			if( Session["userid"]=="")
			{
				Page.Response.Redirect("bbklogin.aspx");

			}
			
			if(Page.IsValid)
			{
				//修改
				if(Session["idcard"]=="")
				{
					string zym="";
					string[] zyms={"1","2"};
					string dbname=Server.MapPath("database/bbk.mdb");
					string 	strcon= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+dbname;
				
					string 	strcon1= @"Driver={Microsoft Access Driver (*.mdb)};Dbq="+ dbname +";Uid=Admin;Pwd=";

					OleDbConnection olecon=new OleDbConnection(strcon);	
					OdbcConnection olecon1=new OdbcConnection(strcon1);	

					string chshrq=Ddlbiryear.SelectedItem.ToString()+Ddlbirmonth.SelectedItem.ToString()+Ddlbirday.SelectedItem.ToString();
					string sqlpre,sqlnext,sql;
					sqlpre="insert into 10216bbk ( dwdm,dwmc,xm,sfzh,xwdwm,xwdwmc,bkbdxm";
					sqlnext=") values ( '"+Textdwdm.Text+"','"+Textdwmc.Text+"','"+Textxm.Text+"','"+Textsfzh.Text+"','"+Textxwdwm.Text+"','"+Textxwdwmc.Text+"','"+Textbkbdxm.Text+"'";//添加文本框的必填项
					//根据可选项不为空的输入
					if(Textxmpy.Text!="")
					{//姓名拼音
						sqlpre+=",xmpy";
						sqlnext+=",'"+Textxmpy.Text+"'";
					}
					if(Textksdw.Text!="")
					{//考生人事档案所在单位
						sqlpre+=",ksdw";
						sqlnext+=",'"+Textksdw.Text+"'";
					}
					if(Ddldwszssm.SelectedValue.ToString()!="")			
					{//考生人事档案单位所在地省市代码 
						sqlpre+=",dwszssm";
						sqlnext+=",'"+Ddldwszssm.SelectedValue.ToString()+"'";
					}
					if(Textksdwdz.Text!="")
					{//考生人事档案单位通讯地址
						sqlpre+=",ksdwdz";
						sqlnext+=",'"+Textksdwdz.Text+"'";
					}
					if(Textksdwyb.Text!="")
					{//考生人事档案单位通讯地址邮政编码 
						sqlpre+=",ksdwyb";
						sqlnext+=",'"+Textksdwyb.Text+"'";
					}
					if(Texttxdz.Text!="")
					{//考生通讯地址 
						sqlpre+=",txdz";
						sqlnext+=",'"+Texttxdz.Text+"'";
					}
					if(Textyzbm.Text!="")
					{//考生通讯地址邮政编码
						sqlpre+=",yzbm";
						sqlnext+=",'"+Textyzbm.Text+"'";
					}
					if(Textlxdh.Text!="")
					{//考生联系电话 
						sqlpre+=",lxdh";
						sqlnext+=",'"+Textlxdh.Text+"'";
					}
					if(Textdzxx.Text!="")
					{//考生电子邮箱 
						sqlpre+=",dzxx";
						sqlnext+=",'"+Textdzxx.Text+"'";
					}
					if(Textbzh.Text!="")
					{//备用信息 
						sqlpre+=",byxx";
						sqlnext+=",'"+Textbzh.Text+"'";
					}
					if(RadioButtonList1.SelectedItem.Text.ToString()=="是")
					{
						sqlpre+=",xyjrm";
						sqlnext+=",'1'";
					}

					//插入生日
					string birthday=Ddlbiryear.SelectedItem.Text.ToString();
					if(Ddlbirmonth.SelectedItem.Text.ToString().Length==1)
						birthday+="0";//若为个位数中间加一个'0'
					birthday+=Ddlbirmonth.SelectedItem.Text.ToString();
					if(Ddlbirday.SelectedItem.Text.ToString().Length==1)
						birthday+="0";//若为个位数中间加一个'0'
					birthday+=Ddlbirday.SelectedItem.Text.ToString();
					sqlpre+=",csrq";
					sqlnext+=",'"+birthday+"'";
					//最后学位年月
					string xwday=Ddleduyear.SelectedItem.Text.ToString();
					if(Ddledumonth.SelectedItem.Text.ToString().Length==1)
						xwday+="0";//若为个位数中间加一个'0'
					xwday+=Ddledumonth.SelectedItem.Text.ToString();				
					sqlpre+=",xwnd";
					sqlnext+=",'"+xwday+"'";
					//判断下拉列表是否都选择了;
					if(Ddlmz.SelectedValue.ToString()=="")
					{
						Response.Write("<script language=javascript>alert('民族不能为空！！')</script>");
					}
					else
					{
						sqlpre+=",mzm";
						sqlnext+=",'"+Ddlmz.SelectedValue.ToString()+"'";					
						if(Ddlxbm.SelectedValue.ToString()=="")
						{
							Response.Write("<script language=javascript>alert('请输入性别！！')</script>");
						}
						else
						{
							sqlpre+=",xbm";
							sqlnext+=",'"+Ddlxbm.SelectedValue.ToString()+"'";					
							if(Ddlhf.SelectedValue.ToString()=="")
							{
								Response.Write("<script language=javascript>alert('请输入婚否！！')</script>");
							}
							else
							{
								sqlpre+=",hfm";
								sqlnext+=",'"+Ddlhf.SelectedValue.ToString()+"'";					
								if(Ddlzhzhmm.SelectedValue.ToString()=="")
								{
									Response.Write("<script language=javascript>alert('请输入政治面貌！！')</script>");
								}
								else
								{
									sqlpre+=",zzmmm";
									sqlnext+=",'"+Ddlzhzhmm.SelectedValue.ToString()+"'";					
									if(Ddlzhxw.SelectedValue.ToString()=="")
									{
										Response.Write("<script language=javascript>alert('请输入最后学位！！')</script>");
									}
									else
									{
										sqlpre+=",xwm";
										sqlnext+=",'"+Ddlzhxw.SelectedValue.ToString()+"'";					
										if(Ddlxwfs.SelectedValue.ToString()=="")
										{
											Response.Write("<script language=javascript>alert('请输入最后学位方式！！')</script>");
										}
										else
										{
											sqlpre+=",xwfsm";
											sqlnext+=",'"+Ddlxwfs.SelectedValue.ToString()+"'";					
											if(Ddlksly.SelectedValue.ToString()=="")
											{
												Response.Write("<script language=javascript>alert('请输入考生来源！！')</script>");
											}
											else
											{
												sqlpre+=",kslym";
												sqlnext+=",'"+Ddlksly.SelectedValue.ToString()+"'";	
												if(Ddlkszssm.SelectedValue.ToString()=="")
												{
													Response.Write("<script language=javascript>alert('请输入户口所在地！！')</script>");
												}
												else
												{
													sqlpre+=",hkszssm";
													sqlnext+=",'"+Ddlkszssm.SelectedValue.ToString()+"'";	
											
													if(Ddlbdsx.SelectedValue.ToString()=="")
													{
														Response.Write("<script language=javascript>alert('请输入博士生导师属性！！')</script>");
													}
													else
													{
														sqlpre+=",bdsx";
														sqlnext+=",'"+Ddlbdsx.SelectedValue.ToString()+"'";					
														if(Ddlzymch.SelectedValue.ToString()=="")
														{
															Response.Write("<script language=javascript>alert('请输入专业名称！！')</script>");
														}
														else
														{
															zym=Ddlzymch.SelectedItem.Text.ToString();
															zyms=zym.Split(')');
															sqlpre+=",zymc,zydm";
															sqlnext+=",'"+zyms[1]+"','"+Ddlzymch.SelectedValue.ToString()+"'";				
															if(Ddlksfs.SelectedValue.ToString()=="")
															{
																Response.Write("<script language=javascript>alert('请输入考试方式！！')</script>");
															}
															else
															{	
																sqlpre+=",ksfsm";
																sqlnext+=",'"+Ddlksfs.SelectedValue.ToString()+"'";					
																if(Ddlbklb.SelectedValue.ToString()=="")
																{
																	Response.Write("<script language=javascript>alert('请输入报考类别！！')</script>");
																}
																else
																{
																	sqlpre+=",bklbm";
																	sqlnext+=",'"+Ddlbklb.SelectedValue.ToString()+"'";					
																	if(Ddlwgy.SelectedValue.ToString()=="")
																	{
																		Response.Write("<script language=javascript>alert('请输入外国语名称！！')</script>");
																	}
																	else
																	{
																		zym=Ddlwgy.SelectedItem.Text.ToString();
																		zyms=zym.Split(')');
																		sqlpre+=",wgymc,wgym";