📄 baoming.aspx.cs
字号:
sqlnext+=",'"+zyms[1]+"','"+Ddlwgy.SelectedValue.ToString()+"'";
if(Ddlywk1.SelectedValue.ToString()=="")
{
Response.Write("<script language=javascript>alert('请输入业务课一！！')</script>");
}
else
{
zym=Ddlywk1.SelectedItem.Text.ToString();
zyms=zym.Split(')');
sqlpre+=",ywk1mc,ywk1m";
sqlnext+=",'"+zyms[1]+"','"+Ddlywk1.SelectedValue.ToString()+"'";
if(Ddlywk2.SelectedValue.ToString()=="")
{
Response.Write("<script language=javascript>alert('请输入业务课二！！')</script>");
}
else
{
zym=Ddlywk2.SelectedItem.Text.ToString();
zyms=zym.Split(')');
sqlpre+=",ywk2mc,ywk2m";
sqlnext+=",'"+zyms[1]+"','"+Ddlywk2.SelectedValue.ToString()+"'";
//生成考生编号
string sbh="";//考生编号
string sksbh="1021661";//考生编号固定部分
string szydm=Ddlzymch.SelectedValue.ToString();//专业代码
string szybh="";
string sqldh="select SX from xx where BH='"+szydm+"'";//查询专业代号
OleDbCommand olecom1=new OleDbCommand(sqldh,olecon);
olecon.Open();
olecon1.Open();
OleDbDataReader olereader=olecom1.ExecuteReader();
if(olereader.Read())
{
szybh=olereader["SX"].ToString().Trim();
}
olereader.Close();
sqldh="select max(ksbh) as ksbh from 10216bbk where ksbh like '"+"1021661"+szybh+"%"+"'";//找出现有编号的最大编号
olecom1=new OleDbCommand(sqldh,olecon);
olereader=olecom1.ExecuteReader();
if(olereader.Read())
{
sbh=olereader["ksbh"].ToString();
if(sbh=="")//若是第一个则为空,生成第一个编号
sbh=sksbh+szybh+"000000";
}
else
{
sbh=sksbh+szybh+"000000";
}
olereader.Close();
olecom1.Dispose();
double i=System.Int64.Parse(sbh);
i++;
sbh=i.ToString();
sqlpre+=",ksbh";
sqlnext+=",'"+sbh+"'";
sql=sqlpre+sqlnext+")";
//OleDbCommand olecom=new OleDbCommand(sql,olecon);
OdbcCommand olecom=new OdbcCommand(sql,olecon1);
olecom.ExecuteNonQuery();
//添加到用户表
sql="update u set IdCard='"+Textsfzh.Text+"' where UserID='"+Session["userid"]+"'";
olecom.CommandText=sql;
olecom.ExecuteNonQuery();
olecon.Close();
Session["userid"]="";//晴空记录
Response.Redirect("success1.aspx");
}
}
}
}
}
}
}
}
}
}
}
}
}
}
//xiugi
}
//xiugai
}
else
{
OleDbConnection conn ; //声明一个OledbConnection对象
conn=new OleDbConnection(); //建立一个oledbConnection对象
//设定连接字符串ConnectionString
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + Server.MapPath("database/bbk.mdb");
conn.Open();
//建立Command对象，并且指定SQL语句
OleDbCommand cd ;
string SQLStr ;
//执行更新SQL指令
SQLStr="delete from 10216bbk where [sfzh]='" +Session["idcard"] + "'";
cd=new OleDbCommand(SQLStr,conn);
cd.ExecuteNonQuery();
//修改
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";
sqlnext+=",'"+zyms[1]+"','"+Ddlwgy.SelectedValue.ToString()+"'";
if(Ddlywk1.SelectedValue.ToString()=="")
{
Response.Write("<script language=javascript>alert('请输入业务课一！！')</script>");
}
else
{
zym=Ddlywk1.SelectedItem.Text.ToString();
zyms=zym.Split(')');
sqlpre+=",ywk1mc,ywk1m";
sqlnext+=",'"+zyms[1]+"','"+Ddlywk1.SelectedValue.ToString()+"'";
if(Ddlywk2.SelectedValue.ToString()=="")
{
Response.Write("<script language=javascript>alert('请输入业务课二！！')</script>");
}
else
{
zym=Ddlywk2.SelectedItem.Text.ToString();
zyms=zym.Split(')');
sqlpre+=",ywk2mc,ywk2m";
sqlnext+=",'"+zyms[1]+"','"+Ddlywk2.SelectedValue.ToString()+"'";
//生成考生编号
string sbh="";//考生编号
string sksbh="1021661";//考生编号固定部分
string szydm=Ddlzymch.SelectedValue.ToString();//专业代码
string szybh="";
string sqldh="select SX from xx where BH='"+szydm+"'";//查询专业代号
OleDbCommand olecom1=new OleDbCommand(sqldh,olecon);
olecon.Open();
olecon1.Open();
OleDbDataReader olereader=olecom1.ExecuteReader();
if(olereader.Read())
{
szybh=olereader["SX"].ToString().Trim();
}
olereader.Close();
sqldh="select max(ksbh) as ksbh from 10216bbk where ksbh like '"+"1021661"+szybh+"%"+"'";//找出现有编号的最大编号
olecom1=new OleDbCommand(sqldh,olecon);
olereader=olecom1.ExecuteReader();
if(olereader.Read())
{
sbh=olereader["ksbh"].ToString();
if(sbh=="")//若是第一个则为空,生成第一个编号
sbh=sksbh+szybh+"000000";
}
else
{
sbh=sksbh+szybh+"000000";
}
olereader.Close();
olecom1.Dispose();
double i=System.Int64.Parse(sbh);
i++;
sbh=i.ToString();
sqlpre+=",ksbh";
sqlnext+=",'"+sbh+"'";
sql=sqlpre+sqlnext+")";
//OleDbCommand olecom=new OleDbCommand(sql,olecon);
OdbcCommand olecom=new OdbcCommand(sql,olecon1);
olecom.ExecuteNonQuery();
Session["userid"]="";//晴空记录
Session["idcard"]="";
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
//修改
Response.Write("<p>更新成功!<P>");
conn.Close();
Response.Write("<script language=javascript>alert('请输入考试方式！！')</script>");
}
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -