📄 zcb.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.Text.RegularExpressions;
using System.IO;
using System.Data.OleDb;
namespace djks
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.HtmlControls.HtmlForm Form1;
protected System.Web.UI.WebControls.Panel Panel1;
protected System.Web.UI.WebControls.DropDownList Drl_bkyy;
protected System.Web.UI.WebControls.RequiredFieldValidator Rv_pid;
protected System.Web.UI.WebControls.RegularExpressionValidator Rev_pid;
protected System.Web.UI.WebControls.TextBox txt_name;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
protected System.Web.UI.WebControls.DropDownList Drl_xb;
protected System.Web.UI.WebControls.TextBox txt_birthday;
protected System.Web.UI.WebControls.DropDownList Drl_mz;
protected System.Web.UI.WebControls.DropDownList Drl_zy;
protected System.Web.UI.WebControls.DropDownList Drl_whcd;
protected System.Web.UI.WebControls.DropDownList Drl_blcj;
protected System.Web.UI.WebControls.TextBox txt_ykh;
protected System.Web.UI.WebControls.CustomValidator CustomValidator1;
protected System.Web.UI.WebControls.TextBox Txt_lxdh;
protected System.Web.UI.WebControls.TextBox txt_lxdz;
protected System.Web.UI.WebControls.TextBox Txt_zdyxx;
protected System.Web.UI.HtmlControls.HtmlInputText txt_pid;
protected System.Web.UI.WebControls.Button btn_next1;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!this.IsPostBack)
{
string sql_system="select bm_purview from system";
DataTable dt=new DataTable();
dt=database.CreateDateSet(sql_system).Tables[0];
if(dt.Rows[0]["bm_purview"].ToString().ToLower()=="false")
{
Response.Redirect("alert.htm");
}
else
{
databind();
// hxyy_js.jsAlert(database.Count("select count(*) from bmk").ToString());
}
}
// create_bmkh() ;
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.btn_next1.Click += new System.EventHandler(this.btn_refer_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void databind() //报考语言下拉列表数据绑定
{
string Sql_JBYY="select JBYYDM,JBYY from JBYY where flag=true"; //报考语言查询语句
database.drpl_bind(Sql_JBYY,this.Drl_bkyy,"0"); //数据绑定函数调用
string Sql_MZ="select * from MZ"; //民族下拉列表数据绑定
database.drpl_bind(Sql_MZ,this.Drl_mz,"0");
string Sql_ZY="select * from ZY"; //职业下拉列表数据绑定
database.drpl_bind(Sql_ZY,Drl_zy,"30");
string Sql_WHCD="select * from WHCD"; //文化程度下拉列表数据绑定
database.drpl_bind(Sql_WHCD,Drl_whcd,"3");
string Sql_BLCJ="select * from BLCJ"; //保留成绩绑定
database.drpl_bind(Sql_BLCJ,this.Drl_blcj,"0");
}
private bool IsNumber(String strNumber) //判断输入的是否为数字
{
Regex objNotNumberPattern=new Regex("[^0-9.-]");
Regex objTwoDotPattern=new Regex("[0-9]*[.][0-9]*[.][0-9]*");
Regex objTwoMinusPattern=new Regex("[0-9]*[-][0-9]*[-][0-9]*");
String strValidRealPattern="^([-]|[.]|[-.]|[0-9])[0-9]*[.]*[0-9]+$";
String strValidIntegerPattern="^([-]|[0-9])[0-9]*$";
Regex objNumberPattern =new Regex("(" + strValidRealPattern +")|(" + strValidIntegerPattern + ")");
return !objNotNumberPattern.IsMatch(strNumber) &&
!objTwoDotPattern.IsMatch(strNumber) &&
!objTwoMinusPattern.IsMatch(strNumber) &&
objNumberPattern.IsMatch(strNumber);
}
private void CustomValidator1_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args) //原准考证号输入是否正确验证
{
string zkzh=args.Value;
// Response.Write("<script>alert('"+zkzh+"')</script>");
if(this.IsNumber(zkzh)||zkzh.Length>=16)
{
args.IsValid=true;
}
else
{
args.IsValid=false;
}
}
private string create_bmkh() //根据ID生成报名号
{
string bmh_return;
string temp_bmh="000001",sub_bmh;
// string sql="select count(*) as zrs from bmk ";
int number=database.Number()+1;
sub_bmh=number.ToString(); //取得所得总记录数转换为字符形
switch(sub_bmh.Length.ToString())
{
case "1":
temp_bmh="00000"+sub_bmh;
break;
case "2":
temp_bmh="0000"+sub_bmh;
break;
case "3":
temp_bmh="000"+sub_bmh;
break;
case "4":
temp_bmh="00"+sub_bmh;
break;
case "5":
temp_bmh="0"+sub_bmh;
break;
case "6":
temp_bmh=sub_bmh;
break;
}
bmh_return="410013"+this.Drl_bkyy.SelectedValue.ToString()+temp_bmh;
hxyy_js.jsAlert(bmh_return);
return bmh_return;
}
private void btn_refer_Click(object sender, System.EventArgs e) //提交
{
string xm,xb,csrq,mz,mz_text,sfzh,zy,zy_text,whcd,whcd_text,blcjzl,blcjzl_text;
string yzkzh,lxdh,lxdz,zdyxx;
string bkyy,bkyy_text;
string bmh;
int tem_xb,flag;
//获取所要更新的字段值
tem_xb=this.Drl_xb.SelectedIndex+1; //取得性别号
xb=tem_xb.ToString();
xm=this.txt_name.Text.Replace(" ","").ToString();
csrq=this.txt_birthday.Text.ToString();
mz=this.Drl_mz.SelectedValue;
mz_text=this.Drl_mz.SelectedItem.Text;
sfzh=txt_pid.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;
string strsel="select count(*) from bmk where XM='"+xm+"'and SFZH='"+sfzh+"'";
flag=database.Count(strsel);;
if(flag>0) //判断是否注册记录
{
hxyy_js.jsAlert("您已注册过,如若修改信息.请到修改信息页面");
}
else
{
bmh=create_bmkh(); //获取报名号
string strSql="insert into bmk (ZKZH,BMH,XM,XB,CSRQ,MZ,SFZH,ZY,WHCD,YZKZH,BLCJZL,LXDZ,LXDH,ZDYXX) values ('"+bmh+"','"+bmh+"','"+xm+"','"+xb+"','"+csrq+"','"+mz+"','"+sfzh+"','"+zy+"','"+whcd+"','"+yzkzh+"','"+blcjzl+"','"+lxdz+"','"+lxdh+"','"+zdyxx+"')"; //数据库插入信息
database.doSql(strSql); //注册语句执行
Response.Redirect("chakan.aspx?sfzh="+sfzh+"&xm="+xm);
// this.Panel1.Visible=false;
//
// this.pnl_player.Visible=true;
//// this.Image2.Visible=true;
}
}
// private void btn_upload_Click(object sender, System.EventArgs e)
// {
// Random random=new Random();
// try
// {
// if(this.photo.PostedFile.ContentLength.ToString()=="")
// {
// hxyy_js.jsAlert("上传的文件不存在");
// }
// else
// {
// photoname=bmh+".jpg";
// string ext=Path.GetExtension(photo.PostedFile.FileName);
// if(ext==".jpg")
// {
//
// photo.PostedFile.SaveAs(System.Web.HttpContext.Current.Server.MapPath("photo/")+photoname);
// this.Image2.ImageUrl="photo/"+photoname+"?"+random.Next(100).ToString();
//
// string strSql="update bmk set HAVEXP=1 where BMh='"+bmh+"'";
// database.doSql(strSql);
// havexp="1";
// }
// else
// {
// hxyy_js.jsAlert("上传文件应为(.jpg)格式,请重新上传");
// }
// }
// }
// catch
// {
// hxyy_js.jsAlert("图片上传中出错。为保证你的信息无误，请到相关部门查证！");
// }
// }
// private void lbt_update_Click(object sender, System.EventArgs e)
// {
// //按扭初始化
// this.Panel1.Visible=true;
//// this.Panel2.Visible=false;
// this.pnl_player.Visible=false;
//// this.btn_update.Visible=true;
//// this.btn_next1.Visible=false;
//
// }
// private void btn_update_Click(object sender, System.EventArgs e)
// {
// int tem_xb;
// string tem_bmh;
// //获取所要更新的字段值
// tem_xb=this.Drl_xb.SelectedIndex+1; //取得性别号
// xb=tem_xb.ToString();
// xm=this.txt_name.Text.Replace(" ","").ToString();
// csrq=this.txt_birthday.Text.ToString();
// mz=this.Drl_mz.SelectedValue;
// mz_text=this.Drl_mz.SelectedItem.Text;
// sfzh=txt_pid.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;
//
// //更换报名号
// tem_bmh=bmh;
// bmh="410013"+bkyy+bmh.Substring(8);
// string strSql="update bmk set 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+"' where BMH='"+tem_bmh+"'"; //更新语句 //数据库插入信息
// database.doSql(strSql); //注册语句执行
// try
// {
// if(havexp=="1")
// {
// if((tem_bmh+".jpg")!=(bmh+".jpg"))
// {
// if(File.Exists(Server.MapPath("photo/")+bmh+".jpg"))
// {
// File.Delete(Server.MapPath("photo/")+bmh+".jpg");
// }
// File.Move(Server.MapPath("photo/")+tem_bmh+".jpg",Server.MapPath("photo/")+bmh+".jpg");
// photoname=bmh+".jpg";
// }
// }
// }
// catch
// {
// hxyy_js.jsAlert("图片上传中出错。为保证你的信息无误，请到相关部门查证！");
// }
// this.Panel1.Visible=false;
//// this.Panel2.Visible=true;
//// this.Image2.Visible=true;
//// this.Image2.ImageUrl=Server.MapPath("photo/")+photoname;
// this.pnl_player.Visible=false;
//
// }
// private void btn_pre_Click(object sender, System.EventArgs e)
// {
// this.Panel1.Visible=true;
//// this.Panel2.Visible=false;
// this.pnl_player.Visible=false;
//// this.btn_update.Visible=true;
//// this.btn_next1.Visible=false;
// }
// private void btn_next2_Click(object sender, System.EventArgs e)
// {
//// Random random=new Random();
// this.pnl_player.Visible=true;
// this.Panel1.Visible=false;
//// this.Panel2.Visible=false;
//// this.img_player.Visible=true;
//// if(havexp=="1")
//// {
//// this.img_player.ImageUrl="photo/"+photoname+"?"+random.Next(100).ToString();
//// }
//// else
//// {
//// this.img_player.ImageUrl="images/nopho.jpg";
//// }
// }
// private void btn_pre_player_Click(object sender, System.EventArgs e)
// {
//// Random random=new Random();
// this.pnl_player.Visible=false;
// this.Panel1.Visible=false;
//// this.Panel2.Visible=true;
//// this.Image2.Visible=true;
//// this.Image2.ImageUrl="photo/"+photoname+"?"+random.Next(100).ToString();
// }
// private void btn_edit_Click(object sender, System.EventArgs e)
// {
// this.pnl_player.Visible=false;
// this.Panel1.Visible=true;
// }
// private void Button1_Click(object sender, System.EventArgs e)
// {
// int tem_xb,flag;
// //获取所要更新的字段值
// tem_xb=this.Drl_xb.SelectedIndex+1; //取得性别号
// xb=tem_xb.ToString();
// xm=this.txt_name.Text.Replace(" ","").ToString();
// csrq=this.txt_birthday.Text.ToString();
// mz=this.Drl_mz.SelectedValue;
// mz_text=this.Drl_mz.SelectedItem.Text;
// sfzh=txt_pid.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;
//
// string strsel="select * from bmk where XM='"+xm+"'and SFZH='"+sfzh+"'";
// DataSet ds=database.CreateDateSet(strsel);
// flag=ds.Tables[0].Rows.Count;
// if(flag>0) //判断是否注册记录
// {
// hxyy_js.jsAlert("您已注册过,如若修改信息.请到修改信息页面");
// }
// else
// {
// bmh=create_bmkh(); //获取报名号
// string strSql="insert into bmk (ZKZH,BMH,XM,XB,CSRQ,MZ,SFZH,ZY,WHCD,YZKZH,BLCJZL,LXDZ,LXDH,ZDYXX) values ('"+bmh+"','"+bmh+"','"+xm+"','"+xb+"','"+csrq+"','"+mz+"','"+sfzh+"','"+zy+"','"+whcd+"','"+yzkzh+"','"+blcjzl+"','"+lxdz+"','"+lxdh+"','"+zdyxx+"')"; //数据库插入信息
// database.doSql(strSql); //注册语句执行
//
//
// // this.Image2.Visible=true;
//
//
// }
//
// }
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -