📄 stucontrol.ascx.cs
字号:
namespace webjiuye.collage
{
using System;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text.RegularExpressions;
/// <summary>
/// stucontrol 的摘要说明。
/// </summary>
public class panel2 : System.Web.UI.UserControl
{
protected System.Web.UI.WebControls.LinkButton stusearch;
protected System.Web.UI.WebControls.LinkButton stuadd;
protected System.Web.UI.WebControls.LinkButton stuchange;
protected System.Web.UI.WebControls.LinkButton dwsearch;
protected System.Web.UI.WebControls.LinkButton xsjy;
protected System.Web.UI.WebControls.LinkButton canpq;
protected System.Web.UI.WebControls.LinkButton pqdw;
protected System.Web.UI.WebControls.Panel stuinfoadd;
protected System.Web.UI.WebControls.Panel stuinfosearch;
protected System.Web.UI.WebControls.Button Button2;
protected System.Web.UI.WebControls.Button Button3;
protected System.Web.UI.WebControls.TextBox TextBox5;
protected System.Web.UI.WebControls.TextBox TextBox6;
protected System.Web.UI.WebControls.TextBox TextBox9;
protected System.Web.UI.WebControls.TextBox TextBox10;
protected System.Web.UI.WebControls.TextBox TextBox11;
protected System.Web.UI.WebControls.TextBox TextBox12;
protected System.Web.UI.WebControls.TextBox TextBox13;
protected System.Web.UI.WebControls.TextBox TextBox14;
protected System.Web.UI.WebControls.TextBox TextBox15;
protected System.Web.UI.WebControls.TextBox TextBox16;
protected System.Web.UI.WebControls.TextBox TextBox17;
protected System.Web.UI.WebControls.TextBox TextBox18;
protected System.Web.UI.WebControls.TextBox TextBox19;
protected System.Web.UI.WebControls.TextBox TextBox20;
protected System.Web.UI.WebControls.TextBox TextBox21;
protected System.Web.UI.WebControls.TextBox TextBox22;
protected System.Web.UI.WebControls.TextBox TextBox23;
protected System.Web.UI.WebControls.TextBox TextBox24;
protected System.Web.UI.WebControls.TextBox TextBox25;
protected System.Web.UI.WebControls.TextBox TextBox26;
protected System.Web.UI.WebControls.TextBox TextBox27;
protected System.Web.UI.WebControls.TextBox TextBox28;
protected System.Web.UI.WebControls.TextBox TextBox29;
protected System.Web.UI.WebControls.TextBox TextBox30;
protected System.Web.UI.WebControls.TextBox TextBox31;
protected System.Web.UI.WebControls.TextBox TextBox32;
protected System.Web.UI.WebControls.TextBox TextBox33;
protected System.Web.UI.WebControls.TextBox TextBox34;
protected System.Web.UI.WebControls.TextBox TextBox35;
protected System.Web.UI.WebControls.TextBox TextBox36;
protected System.Web.UI.WebControls.TextBox TextBox37;
protected System.Web.UI.WebControls.TextBox TextBox38;
protected System.Web.UI.WebControls.TextBox TextBox39;
protected System.Web.UI.WebControls.TextBox TextBox40;
protected System.Web.UI.WebControls.TextBox TextBox41;
protected System.Web.UI.WebControls.TextBox TextBox4;
protected System.Web.UI.WebControls.DropDownList mz;
protected System.Web.UI.WebControls.DropDownList zzmm;
protected System.Web.UI.WebControls.DropDownList pyfs;
protected System.Web.UI.WebControls.DropDownList zxwy;
protected System.Web.UI.WebControls.TextBox wyjb;
protected System.Web.UI.WebControls.DropDownList xb;
protected System.Web.UI.WebControls.DropDownList xl;
protected System.Web.UI.WebControls.DropDownList xz;
protected System.Web.UI.WebControls.DropDownList zy;
protected System.Web.UI.WebControls.DropDownList byqx;
protected System.Web.UI.WebControls.Button tijiao;
protected System.Web.UI.WebControls.TextBox xymc;
protected Zerosoft.Web.UI.WebControls.DatePicker DatePicker1;
protected Zerosoft.Web.UI.WebControls.DatePicker DatePicker2;
protected Zerosoft.Web.UI.WebControls.DatePicker DatePicker3;
protected System.Web.UI.WebControls.Button search;
protected CBDAspNet.WebControls.HTML.TextBox syszd;
protected System.Web.UI.WebControls.TextBox examinid;
protected System.Web.UI.WebControls.TextBox stuid;
protected System.Web.UI.WebControls.TextBox stuname;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器
/// 修改此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.stusearch.Click += new System.EventHandler(this.stusearch_Click);
this.stuadd.Click += new System.EventHandler(this.stuadd_Click);
this.search.Click += new System.EventHandler(this.search_Click);
this.mz.SelectedIndexChanged += new System.EventHandler(this.mz_SelectedIndexChanged);
this.tijiao.Click += new System.EventHandler(this.tijiao_Click);
this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
this.ID = "panel2";
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void stuadd_Click(object sender, System.EventArgs e)
{
this.stuinfoadd.Visible=true;
this.stuinfosearch.Visible=false;
listDB la=new listDB();
for(int m=0;m<la.listall("mzdm").Tables[0].Rows.Count;m++)
this.mz.Items.Add(la.listall("mzdm").Tables[0].Rows[m][0].ToString());
for(int m=0;m<la.listall("xldm").Tables[0].Rows.Count;m++)
this.xl.Items.Add(la.listall("xldm").Tables[0].Rows[m][0].ToString());
for(int m=0;m<la.listall("zzmmdm").Tables[0].Rows.Count;m++)
this.zzmm.Items.Add(la.listall("zzmmdm").Tables[0].Rows[m][0].ToString());
for(int m=0;m<la.listall("pyfsdm").Tables[0].Rows.Count;m++)
this.pyfs.Items.Add(la.listall("pyfsdm").Tables[0].Rows[m][0].ToString());
for(int m=0;m<la.listall("byqxdm").Tables[0].Rows.Count;m++)
this.byqx.Items.Add(la.listall("byqxdm").Tables[0].Rows[m][0].ToString());
for(int m=0;m<la.listall("zxwyyzdm").Tables[0].Rows.Count;m++)
this.zxwy.Items.Add(la.listall("zxwyyzdm").Tables[0].Rows[m][0].ToString());
this.xymc.Text=la.Selectxy(Session["xydm"].ToString()).Tables[0].Rows[0][0].ToString();
DataSet ds=new DataSet();
ds=la.listzy(this.xymc.Text.ToString());
conver cv=new conver();
for(int m=0;m<ds.Tables[0].Rows.Count;m++)
{
DataSet mc=new DataSet();
mc=cv.dm_mc("zydm",ds.Tables[0].Rows[m][0].ToString().Trim());
this.zy.Items.Add(mc.Tables[0].Rows[0][0].ToString());
}
}
private void stusearch_Click(object sender, System.EventArgs e)
{
this.stuinfoadd.Visible=false;
this.stuinfosearch.Visible=true;
this.DataGrid1.Visible=true;
conver cv=new conver();
//cv.dm_mc("xydm",Session["xydm"].ToString().Trim()).ToString();
studentsDB stu=new studentsDB();
DataSet ds=new DataSet();
ds=stu.displaystudents(cv.dm_mc("xydm",Session["xydm"].ToString().Trim()).ToString());
/*int itemNumber=ds.Tables[0].Rows.Count;
for(int i=0;i<itemNumber;1++)
{string flag;*/
this.DataGrid1.DataSource=ds;
this.DataGrid1.DataBind();
}
private void DatePicker1_DateChanged(object sender, System.EventArgs e)
{
}
private void mz_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
/*private void syszd_changed(object sender, System.EventArgs e)
{
//this.syszd.Dispose();
//Response.Write("<script>alert('学号、密码不能有为空！')</script>");
//if(this.syszd.Text.ToString().Trim()!="")
{
string str=System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
//string str="server=692406C4A799474;database=student;uid=sa;pwd=sa";
SqlConnection conn=new SqlConnection(str);
SqlDataAdapter myadapter=new SqlDataAdapter("szd_sel",conn);
myadapter.SelectCommand.CommandType=CommandType.StoredProcedure;
SqlParameter para = new SqlParameter("@dwszd",SqlDbType.NVarChar,36);
para.Value = this.syszd.Text.Trim();
myadapter.SelectCommand.Parameters.Add(para);
DataSet myDataSet = new DataSet();
myadapter.Fill(myDataSet,"dwszddm");
this.syszd.DataSource=myDataSet;
}
}*/
private void tijiao_Click(object sender, System.EventArgs e)
{
/*if(this.examinid.Text=="")
Response.Write("<script>alert('请输入考生号！')</script>");
if(this.stuid.Text=="")
Response.Write("<script>alert('请输入学号！')</script>");
if(this.stuname.Text=="")
Response.Write("<script>alert('请输入姓名！')</script>");*/
if(!Regex.IsMatch(examinid.Text,@"\d{13}"))
Response.Write("<script>alert('考生号输入有误！')</script>");
else
if(!Regex.IsMatch(stuid.Text,@"\d{10}"))
Response.Write("<script>alert('学号输入有误！')</script>");
else
if(this.stuname.Text=="")
Response.Write("<script>alert('请输入姓名！')</script>");
else
if(this.syszd.Text=="")
Response.Write("<script>alert('请输入后选择生源所在地！')</script>");
else
{
studentsDB stu=new studentsDB();
if(stu.stuid_check(this.stuid.Text.ToString()).Tables[0].Rows.Count!=0)
Response.Write("<script>alert('该学号已经存在，请核对！')</script>");
conver cv=new conver();
DataSet xbdm=new DataSet();
xbdm=cv.mc_dm("xbdm",this.xb.SelectedItem.ToString());
DataSet mzdm=new DataSet();
mzdm=cv.mc_dm("mzdm",this.mz.SelectedItem.ToString().Trim());
DataSet xldm=new DataSet();
xldm=cv.mc_dm("xldm",this.xl.SelectedItem.ToString());
DataSet zzmm=new DataSet();
zzmm=cv.mc_dm("zzmmdm", this.zzmm.SelectedItem.ToString());
DataSet syszd=new DataSet();
syszd=cv.mc_dm("dwszddm", this.syszd.Text.ToString());
DataSet pyfs=new DataSet();
pyfs=cv.mc_dm("pyfsdm", this.pyfs.SelectedItem.ToString());
DataSet byqx=new DataSet();
byqx=cv.mc_dm("byqxdm", this.byqx.SelectedItem.ToString());
DataSet zxwy=new DataSet();
zxwy=cv.mc_dm("zxwyyzdm", this.zxwy.SelectedItem.ToString());
DataSet zy=new DataSet();
zy=cv.mc_dm("zydm",this.zy.SelectedItem.ToString());
stu.UpdateStudents(this.stuid.Text.ToString(),this.stuname.Text.ToString(),this.examinid.Text.ToString(),xbdm.Tables[0].Rows[0][0].ToString(),"10056","120104",mzdm.Tables[0].Rows[0][0].ToString(),zzmm.Tables[0].Rows[0][0].ToString(),xldm.Tables[0].Rows[0][0].ToString(),pyfs.Tables[0].Rows[0][0].ToString(),zxwy.Tables[0].Rows[0][0].ToString(),syszd.Tables[0].Rows[0][0].ToString(),this.DatePicker1.SelectedDate.ToString(this.DatePicker1.DateFormat),this.DatePicker2.SelectedDate.ToString(this.DatePicker2.DateFormat),this.DatePicker3.SelectedDate.ToString(this.DatePicker3.DateFormat),this.xz.SelectedItem.ToString(),byqx.Tables[0].Rows[0][0].ToString(),this.TextBox9.Text.ToString(),zy.Tables[0].Rows[0][0].ToString(),this.wyjb.Text.ToString(),this.xymc.Text.ToString());
Response.Redirect("stuinfocontrol.aspx");
}
}
private void search_Click(object sender, System.EventArgs e)
{
this.syszd._DropDownList.Items.Clear();
if(this.syszd.Text.Trim()!="")
{
string str=System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
//string str="server=692406C4A799474;database=student;uid=sa;pwd=sa";
SqlConnection conn=new SqlConnection(str);
SqlDataAdapter myadapter=new SqlDataAdapter("szd_sel",conn);
myadapter.SelectCommand.CommandType=CommandType.StoredProcedure;
SqlParameter para = new SqlParameter("@dwszd",SqlDbType.NVarChar,36);
para.Value = this.syszd.Text.Trim();
myadapter.SelectCommand.Parameters.Add(para);
DataSet myDataSet = new DataSet();
myadapter.Fill(myDataSet,"dwszddm");
int i=0;
for(i=0;i<myDataSet.Tables[0].Rows.Count;i++)
this.syszd._DropDownList.Items.Add(myDataSet.Tables[0].Rows[i]["mc"].ToString());
}
}
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -