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.SqlClient;
namespace Education.student
{
/// <summary>
/// StuInfoEdit 的摘要说明。
/// </summary>
public class StuInfoEdit : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox8;
protected System.Web.UI.WebControls.TextBox TextBox9;
protected System.Web.UI.WebControls.DropDownList ddl_nation;
protected System.Web.UI.WebControls.TextBox TextBox11;
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 TextBox18;
protected System.Web.UI.WebControls.TextBox TextBox19;
protected System.Web.UI.WebControls.TextBox TextBox21;
protected System.Web.UI.WebControls.TextBox TextBox22;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.TextBox TextBox4;
protected System.Web.UI.WebControls.TextBox TextBox5;
protected System.Web.UI.WebControls.TextBox TextBox6;
protected System.Web.UI.WebControls.TextBox TextBox7;
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 TextBox31;
protected System.Web.UI.WebControls.TextBox TextBox29;
protected System.Web.UI.WebControls.TextBox TextBox32;
protected System.Web.UI.WebControls.TextBox TextBox34;
protected System.Web.UI.WebControls.DropDownList ddl_mentor;
protected System.Web.UI.WebControls.TextBox TextBox36;
protected System.Web.UI.WebControls.DropDownList ddl_plankind;
protected System.Web.UI.WebControls.DropDownList ddl_dir;
protected System.Web.UI.WebControls.TextBox TextBox37;
protected System.Web.UI.WebControls.HyperLink Hyperlink2;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Label Label1;
public SqlDataReader dr;
config conn=new config();
protected System.Web.UI.WebControls.LinkButton saveReturn;
protected System.Web.UI.WebControls.DropDownList ddl_sex;
protected System.Web.UI.WebControls.DropDownList ddl_selftype;
protected System.Web.UI.WebControls.DropDownList ddl_ifmarry;
protected System.Web.UI.WebControls.DropDownList ddl_ifforgin;
protected System.Web.UI.WebControls.DropDownList ddl_teachgrade;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.TextBox Textbox38;
protected System.Web.UI.WebControls.TextBox Textbox39;
protected System.Web.UI.WebControls.TextBox Textbox41;
protected System.Web.UI.WebControls.TextBox Textbox40;
protected System.Web.UI.WebControls.TextBox Textbox42;
protected System.Web.UI.WebControls.TextBox Textbox43;
protected System.Web.UI.HtmlControls.HtmlInputText txt_BirthDate;
protected System.Web.UI.HtmlControls.HtmlInputText txt_GetDate;
protected System.Web.UI.HtmlControls.HtmlInputText txt_JoinDate;
protected System.Web.UI.HtmlControls.HtmlInputText txt_inDate;
protected System.Web.UI.WebControls.DropDownList ddl_spec;
protected System.Web.UI.WebControls.DropDownList ddl_degree;
protected System.Web.UI.WebControls.TextBox txt_native;
protected System.Web.UI.WebControls.TextBox txt_HomeAdd;
protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
protected System.Web.UI.WebControls.CompareValidator CompareValidator2;
protected System.Web.UI.WebControls.CompareValidator CompareValidator3;
protected System.Web.UI.WebControls.CompareValidator CompareValidator4;
public string StuID;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
conn.Relogin_Page();
StuID=(string)Session["stuid"];
conn.Error_Page("select count(*) from t_student where StuID='"+StuID+
"' and CheckFlag='1'","你的基本信息已经被审核，无法自行修改！！");
if(!IsPostBack)
{
Get_Data();
}
}
public void Get_Data()
{
Bind_Data();
SqlCommand mycmd=new SqlCommand("select * from t_student where StuID=@StuID",conn.mycon);
SqlParameter param;
param=mycmd.Parameters.Add("@StuID",SqlDbType.Char,20);
param.Value=StuID;
mycmd.Connection.Open();
dr=mycmd.ExecuteReader();
if(dr.Read())
{
Label1.Text=dr.GetValue(0).ToString();
TextBox1.Text=dr.GetValue(1).ToString();
TextBox2.Text=dr.GetValue(4).ToString();
// string brith=dr.GetValue(13).ToString();
if (dr.GetValue(13).ToString()!="")
{
txt_BirthDate.Value=conn.Get_Date((DateTime)dr.GetValue(13));
}
TextBox4.Text=dr.GetValue(19).ToString();
ddl_sex.SelectedIndex=conn.Select_Index(ddl_sex,dr.GetValue(12).ToString());
// conn.JsIsNull(dr.GetValue(14).ToString(),Label1);
ddl_selftype.SelectedIndex=conn.Select_Index(ddl_selftype,dr.GetValue(14).ToString());
ddl_nation.SelectedIndex=conn.Select_Index(ddl_nation,dr.GetValue(15).ToString());
ddl_ifmarry.SelectedIndex=conn.Select_Index(ddl_ifmarry,dr.GetValue(16).ToString());
ddl_ifforgin.SelectedIndex=conn.Select_Index(ddl_ifforgin,dr.GetValue(17).ToString());
ddl_teachgrade.SelectedIndex=conn.Select_Index(ddl_teachgrade,dr.GetValue(18).ToString());
ddl_spec.SelectedIndex=conn.Select_Index(ddl_spec,dr.GetValue(6).ToString());
ddl_degree.SelectedIndex=conn.Select_Index(ddl_degree,dr["degree"].ToString());
ddl_plankind.SelectedIndex=conn.Select_Index(ddl_plankind,dr.GetValue(8).ToString());
ddl_mentor.SelectedIndex=conn.Select_Index(ddl_mentor,dr.GetValue(11).ToString());
TextBox5.Text=dr.GetValue(20).ToString();
TextBox6.Text=dr.GetValue(21).ToString();
TextBox7.Text=dr.GetValue(22).ToString();
TextBox8.Text=dr.GetValue(23).ToString();
TextBox9.Text=dr.GetValue(24).ToString();
if (dr.GetValue(25).ToString()!="")
{
txt_GetDate.Value=dr.GetValue(25).ToString();
}
TextBox11.Text=dr.GetValue(26).ToString();
// TextBox12.Text=dr.GetValue(26).ToString();
TextBox13.Text=dr.GetValue(27).ToString();
TextBox14.Text=dr.GetValue(28).ToString();
TextBox15.Text=dr.GetValue(29).ToString();
txt_native.Text=dr["nativeplace"].ToString();
txt_HomeAdd.Text=dr["HomeAdd"].ToString();
TextBox18.Text=dr.GetValue(32).ToString();
TextBox19.Text=dr.GetValue(33).ToString();
if (dr.GetValue(13).ToString()!="")
{
txt_JoinDate.Value=conn.Get_Date((DateTime)dr.GetValue(13));
}
TextBox21.Text=dr.GetValue(35).ToString();
TextBox22.Text=dr.GetValue(36).ToString();
TextBox23.Text=dr.GetValue(37).ToString();
TextBox24.Text=dr.GetValue(38).ToString();
TextBox25.Text=dr.GetValue(39).ToString();
TextBox26.Text=dr.GetValue(40).ToString();
TextBox27.Text=dr.GetValue(43).ToString();
TextBox28.Text=dr.GetValue(44).ToString();
TextBox29.Text=dr.GetValue(46).ToString();
TextBox31.Text=dr.GetValue(45).ToString();
TextBox32.Text=dr.GetValue(41).ToString();
TextBox34.Text=dr.GetValue(42).ToString();
if (dr.GetValue(5).ToString()!="")
{
txt_inDate.Value=conn.Get_Date((DateTime)dr.GetValue(5)).ToString();
}
TextBox36.Text=dr.GetValue(10).ToString();
Textbox38.Text=dr.GetValue(52).ToString();
Textbox39.Text=dr.GetValue(53).ToString();
Textbox40.Text=dr.GetValue(54).ToString();
Textbox41.Text=dr.GetValue(55).ToString();
Textbox42.Text=dr.GetValue(56).ToString();
Textbox43.Text=conn.Return_String(dr.GetValue(57).ToString());
TextBox37.Text=conn.Return_String(dr.GetValue(51).ToString());
string dirid=dr["DirID"].ToString();
dr.Close();
ddl_dir.DataSource=conn.Data_Source("select * from t_direction where SpecID='"+ddl_spec.SelectedValue.Trim()+"'"+
" and f_md='"+ddl_degree.SelectedValue.Trim()+"'");
ddl_dir.DataBind();
ddl_dir.SelectedIndex=conn.Select_Index(ddl_dir,dirid);
mycmd.Connection.Close();
}
}
public void Bind_Data()
{
ddl_selftype.DataSource=conn.Data_Source("select * from dm_selftype");
ddl_selftype.DataBind();
ddl_nation.DataSource=conn.Data_Source("select * from dm_nation");
ddl_nation.DataBind();
ddl_teachgrade.DataSource=conn.Teach_Grade();
ddl_teachgrade.DataBind();
ddl_spec.DataSource=conn.Data_Source("select * from t_specialty");
ddl_spec.DataBind();
ddl_plankind.DataSource=conn.Data_Source("select * from dm_plankind");
ddl_plankind.DataBind();
ddl_mentor.DataSource=conn.Data_Source("select * from t_m_mentor");// where SpecID='"+(string)Session["specid"]+"'");
ddl_mentor.DataBind();
}
public void ddlb_data(string mysql,DropDownList ddl_name)
{
ddl_name.DataSource=conn.Data_Source(mysql);
ddl_name.DataBind();
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.saveReturn.Click += new System.EventHandler(this.saveReturn_Click);
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void saveBtn_Click(object sender, System.EventArgs e)
{
Update_Student();
}
private void saveReturn_Click(object sender, System.EventArgs e)
{
Update_Student();
}
public void Update_Student()
{
// string mysql="Update t_student set StuName=@stuname where stuid='"+(string)Session["StuID"]+"'";
string a=Textbox42.Text.Trim();
string b=TextBox37.Text.Trim();
if(conn.CheckStringLength(a)>500)
{
Response.Write("<script>alert('工作经历请限定在250个汉字以内！');</script>");
}
else if(conn.CheckStringLength(b)>500)
{
Response.Write("<script>alert('备注请限定在250个汉字以内！');</script>");
}
else
{
string mysql="Update t_student set StuName=@stuname, EverName=@EverName,SpecID=@SpecID, Degree=@Degree,"+
"StuKind=@StuKind,"+
"DirID=@DirID,"+
"edulength=@edulength,"+
"MentorID=@MentorID,"+
"Sex=@Sex,"+
//"BirthDate=@BirthDate,"+
"SelfType=@SelfType,"+
"Nation=@Nation,"+
"IfMarry=@IfMarry,"+
"IfForgin=@IfForgin,"+
"TeachGrade=@TeachGrade,"+
"GetYear=@GetYear,"+
"College=@College,"+
"Department=@Department,"+
"Specialty=@Specialty,"+
"Years=@Years,"+
"DegreeName=@DegreeName,"+
"DegreeDate=@DegreeDate,"+
"Degcollege=@Degcollege,"+
"LastWork=@LastWork,"+
"salary=@salary,"+
"workyears=@workyears,"+
"nativePlace=@nativePlace,"+
"HomeAdd=@HomeAdd,"+
"Health=@Health,"+
"SelfCode=@SelfCode,"+
//"JoinTime=@JoinTime,"+
"JionPlace=@JionPlace,"+
"introducer=@introducer,"+
"workplace=@workplace,"+
"price=@price,"+
"punish=@punish,"+
"Address=@Address,"+
"E_mail=@E_mail,"+
"Homepage=@Homepage,"+
"postalcode=@postalcode,"+
"HomePhone=@HomePhone,"+
"SpecialSkill=@SpecialSkill,"+
"Log_notes=@Log_notes,"+
"polity=@polity,"+
"English=@English,"+
"Other1=@Other1,"+
"Other2=@Other2,"+
"ScoreNote=@ScoreNote,"+
"Experience=@Experience,"+
"Note=@Note";
SqlCommand mycmd=new SqlCommand();
mycmd.Connection=conn.mycon;
// mycmd.CommandType=CommandType.StoredProcedure;
SqlParameter param;
param=mycmd.Parameters.Add("@StuID",SqlDbType.Char,20);
param.Value=StuID;
param=mycmd.Parameters.Add("@StuName",SqlDbType.VarChar,30);
param.Value=TextBox1.Text.Trim();
param=mycmd.Parameters.Add("@EverName",SqlDbType.VarChar,30);
param.Value=TextBox2.Text.Trim();
param=mycmd.Parameters.Add("@Sex",SqlDbType.Char,1);
param.Value=ddl_sex.SelectedValue.ToString();
if(txt_BirthDate.Value.Trim()!="")
{
mysql+=",BirthDate=@BirthDate";
param=mycmd.Parameters.Add("@BirthDate",SqlDbType.DateTime);
param.Value=conn.Rtn_DateTime(txt_BirthDate.Value.Trim());
}
param=mycmd.Parameters.Add("@SelfType",SqlDbType.Char,10);
param.Value=ddl_selftype.SelectedValue.ToString();
param=mycmd.Parameters.Add("@Nation",SqlDbType.Char,2);
param.Value=ddl_nation.SelectedValue.ToString();
param=mycmd.Parameters.Add("@IfMarry",SqlDbType.Char,1);
param.Value=ddl_ifmarry.SelectedValue.ToString();
param=mycmd.Parameters.Add("@IfForgin",SqlDbType.Char,1);
param.Value=ddl_ifforgin.SelectedValue.ToString();
param=mycmd.Parameters.Add("@TeachGrade",SqlDbType.Char,2);
param.Value=ddl_teachgrade.SelectedValue.ToString();
param=mycmd.Parameters.Add("@GetYear",SqlDbType.Char,10);
param.Value=TextBox4.Text.Trim();
param=mycmd.Parameters.Add("@College",SqlDbType.VarChar,60);
param.Value=TextBox5.Text.Trim();
param=mycmd.Parameters.Add("@Department",SqlDbType.VarChar,60);
param.Value=TextBox6.Text.Trim();
param=mycmd.Parameters.Add("@Specialty",SqlDbType.VarChar,60);
param.Value=TextBox7.Text.Trim();
param=mycmd.Parameters.Add("@Years",SqlDbType.Decimal);
param.Value=conn.Rtn_Dec(TextBox8.Text.Trim());
param=mycmd.Parameters.Add("@DegreeName",SqlDbType.VarChar,60);
param.Value=TextBox9.Text.Trim();
param=mycmd.Parameters.Add("@DegreeDate",SqlDbType.Char,10);
param.Value=txt_GetDate.Value.Trim();
param=mycmd.Parameters.Add("@Degcollege",SqlDbType.VarChar,60);
param.Value=TextBox11.Text.Trim();
param=mycmd.Parameters.Add("@LastWork",SqlDbType.VarChar,60);
param.Value=TextBox13.Text.Trim();
param=mycmd.Parameters.Add("@salary",SqlDbType.Decimal);
param.Value=conn.Rtn_Dec(TextBox14.Text.Trim());
param=mycmd.Parameters.Add("@workyears",SqlDbType.Decimal);
param.Value=conn.Rtn_Dec(TextBox15.Text.Trim());
param=mycmd.Parameters.Add("@nativePlace",SqlDbType.VarChar,60);
param.Value=txt_native.Text.Trim();
param=mycmd.Parameters.Add("@HomeAdd",SqlDbType.VarChar,100);
param.Value=txt_HomeAdd.Text.Trim();
param=mycmd.Parameters.Add("@Health",SqlDbType.VarChar,100);
param.Value=TextBox18.Text.Trim();
param=mycmd.Parameters.Add("@SelfCode",SqlDbType.Char,18);
param.Value=TextBox19.Text.Trim();
if(txt_JoinDate.Value.Trim()!="")
{
mysql+=",JoinTime=@JoinTime";
param=mycmd.Parameters.Add("@JoinTime",SqlDbType.DateTime);
param.Value=conn.Rtn_DateTime(txt_JoinDate.Value.Trim());
}
param=mycmd.Parameters.Add("@JionPlace",SqlDbType.VarChar,60);
param.Value=TextBox21.Text.Trim();
param=mycmd.Parameters.Add("@introducer",SqlDbType.VarChar,30);
param.Value=TextBox22.Text.Trim();
param=mycmd.Parameters.Add("@workplace",SqlDbType.VarChar,60);
param.Value=TextBox23.Text.Trim();
param=mycmd.Parameters.Add("@price",SqlDbType.Text);
param.Value=TextBox24.Text.Trim();
param=mycmd.Parameters.Add("@punish",SqlDbType.Text);
param.Value=TextBox25.Text.Trim();
param=mycmd.Parameters.Add("@Address",SqlDbType.VarChar,60);
param.Value=TextBox26.Text.Trim();
param=mycmd.Parameters.Add("@postalcode",SqlDbType.Char,6);
param.Value=TextBox27.Text.Trim();
param=mycmd.Parameters.Add("@HomePhone",SqlDbType.VarChar,13);
param.Value=TextBox28.Text.Trim();
param=mycmd.Parameters.Add("@Log_notes",SqlDbType.VarChar,200);
param.Value=TextBox29.Text.Trim();
param=mycmd.Parameters.Add("@SpecialSkill",SqlDbType.VarChar,60);
param.Value=TextBox31.Text.Trim();
param=mycmd.Parameters.Add("@E_mail",SqlDbType.VarChar,60);
param.Value=TextBox32.Text.Trim();
param=mycmd.Parameters.Add("@Homepage",SqlDbType.VarChar,60);
param.Value=TextBox34.Text.Trim();
if(txt_inDate.Value.Trim()!="")
{
mysql+=",InDate=@InDate";
param=mycmd.Parameters.Add("@InDate",SqlDbType.DateTime);
param.Value=conn.Rtn_DateTime(txt_inDate.Value.Trim());
}
param=mycmd.Parameters.Add("@SpecID",SqlDbType.Char,10);
param.Value=ddl_spec.SelectedValue.ToString();
param=mycmd.Parameters.Add("@Degree",SqlDbType.Char,2);
param.Value=ddl_degree.SelectedValue.ToString();
param=mycmd.Parameters.Add("@StuKind",SqlDbType.Char,2);
param.Value=ddl_plankind.SelectedValue.ToString();
param=mycmd.Parameters.Add("@DirID",SqlDbType.VarChar,10);
param.Value=ddl_dir.SelectedValue.ToString();
param=mycmd.Parameters.Add("@edulength",SqlDbType.Decimal);
param.Value=conn.Rtn_Dec(TextBox36.Text.Trim());
param=mycmd.Parameters.Add("@mentorID",SqlDbType.VarChar,20);
param.Value=ddl_mentor.SelectedValue.ToString();
param=mycmd.Parameters.Add("@polity",SqlDbType.Decimal);
param.Value=conn.Rtn_Dec(Textbox38.Text.Trim());
param=mycmd.Parameters.Add("@English",SqlDbType.Decimal);
param.Value=conn.Rtn_Dec(Textbox39.Text.Trim());
param=mycmd.Parameters.Add("@Other1",SqlDbType.Decimal);
param.Value=conn.Rtn_Dec(Textbox40.Text.Trim());
param=mycmd.Parameters.Add("@Other2",SqlDbType.Decimal);
param.Value=conn.Rtn_Dec(Textbox41.Text.Trim());
param=mycmd.Parameters.Add("@ScoreNote",SqlDbType.VarChar,500);
param.Value=Textbox42.Text.Trim();
param=mycmd.Parameters.Add("@Experience",SqlDbType.VarChar,500);
param.Value=conn.FormatString(a);
param=mycmd.Parameters.Add("@note",SqlDbType.Text);
param.Value=conn.FormatString(b);
mysql+=" where StuID=@StuID";
mycmd.CommandText=mysql;
mycmd.Connection.Open();
// Label2.Text=mycmd.CommandText;
try
{
Label2.Visible=false;
mycmd.ExecuteNonQuery();
Response.Redirect("StudentInfo.aspx");
}
catch(Exception exp)
{
Label2.Visible=true;
Label2.Text=exp.ToString();
}
finally
{
mycmd.Connection.Close();
}
// Get_Data();
}
}
private void Button1_Click(object sender, System.EventArgs e)
{
Update_Student();
}
private void ddl_spec_SelectedIndexChanged(object sender, System.EventArgs e)
{
ddl_dir.DataSource=conn.Data_Source("select * from t_direction where SpecID='"+ddl_spec.SelectedValue.Trim()+"'"+
" and f_md='"+ddl_degree.SelectedValue.Trim()+"'");
ddl_dir.DataBind();
}
}
}
浙公网安备 33010602011771号