protected void btnsave_Click(object sender, EventArgs e)
{
DALstudent_info dal = new DALstudent_info();
student_infoEntity student = new student_infoEntity();
student.StudentAddress = jg.Value;
student.StudentClass = Class.Value;
student.StudentDormitory = ss.Value;
student.StudentId = StudentId.Value;
student.StudentName = truename.Value;
student.StudentNation = nation.Value;
student.StudentPassword = L_pass.Value;
student.StudentQQ = QQ.Value;
student.StudentSex = Sex.Value;
student.StudentTelehpone = TEL.Value;
dal.Addstudent_info(student);
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('添加成功');</script>");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
student_infoEntity stu = new student_infoEntity();//实体对象
stu.StudentId = txtStuID.Text.Trim();
stu.StudentPassword = "******";
stu.StudentName = txtStuName.Text;
stu.StudentPhoto = imgUpLoad(fulStuPhoto);
if (rdlSexMale.Checked)
{
stu.StudentSex = "男";
}
if (rdlSexFemale.Checked)
{
stu.StudentSex = "女";
}
stu.StudentNation = txtStuNation.Text;
stu.StudentTelehpone = txtStuTelehpone.Text;
stu.StudentQQ = txtStuQQ.Text;
stu.StudentClass = txtStuClass.Text;
stu.StudentDormitory = txtStuDormitory.Text;
stu.StudentAddress = txtStuAddress.Text;
if (dal.Addstudent_info(stu) > 0)
{
this.Page.RegisterStartupScript("", "<script>alert('学生信息添加成功！')</script>");
Response.Redirect("StudentFind.aspx");
}
else
{
this.Page.RegisterStartupScript("", "<script>alert('学生信息添加失败！');</script>");
}
//if (dal.Addadmin_user(admin) > 0)//执行
//{
// this.Page.RegisterStartupScript("", "<script>alert('用户新增成功！')</script>");
// Response.Redirect("AdminList.aspx");
//}
//else
// this.Page.RegisterStartupScript("", "<script>alert('用户新增失败！');</script>");
}
/// <summary>
/// 导入Excel文件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnImport_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
int startPosition = FileUpload1.FileName.LastIndexOf("."); //获取后缀名的起始位置
string extName = FileUpload1.FileName.Substring(startPosition).ToLower(); //获取后缀名
if (startPosition >= 0)
{
if (extName.Equals(".xlsx") || extName.Equals(".xls"))
{
string path = Server.MapPath("./File/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string saveFile = path + DateTime.Now.ToString("yyyyMMddHHmmss") + extName;
FileUpload1.SaveAs(saveFile);//上传文件到指定位置
string str = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + saveFile + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1;'";
OleDbConnection oledbconn = new OleDbConnection(str);
//新建ole命令对象
oledbconn.Open();
///因为需要在运行的过程中，增加数据列，并对数据进行修正。
///所以，需要首先读入数据进入内存datatable中然后进行操作。
OleDbCommand commandSourceData = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbconn);
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = commandSourceData;
DataTable tb = new DataTable();
oleda.Fill(tb);
oledbconn.Close();
//数据规整部分。
int successNumber = 0;
int failureNumber = 0;
//数据处理
StringBuilder resultsb = new StringBuilder();
DALstudent_info dal = new DALstudent_info();
foreach (DataRow dr in tb.Rows)
{
try
{
//取值
string sNo = dr["sNo"].ToString().Trim();
string pwd = dr["pwd"].ToString().Trim();
string name = dr["name"].ToString().Trim();
string photo = dr["photo"].ToString().Trim();
string sex = dr["sex"].ToString().Trim();
string nation = dr["nation"].ToString().Trim();
string tel = dr["tel"].ToString().Trim();
string sQQ = dr["sQQ"].ToString().Trim();
string sClass = dr["sClass"].ToString().Trim();
string dormitory = dr["dormitory"].ToString().Trim();
string address = dr["address"].ToString().Trim();
student_infoEntity student = new student_infoEntity();
//赋值
student.StudentId = sNo;
student.StudentPassword = pwd;
student.StudentName = name;
student.StudentPhoto = photo;
student.StudentSex = sex;
student.StudentNation = nation;
student.StudentTelehpone = tel;
student.StudentQQ = sQQ;
student.StudentClass = sClass;
student.StudentDormitory = dormitory;
student.StudentAddress = address;
dal.Addstudent_info(student);//添加
successNumber++;
}
catch (Exception Error)
{
resultsb.Append(dr["sNo"].ToString().Trim());
resultsb.Append("导入失败；原因：");
resultsb.Append(Error.Message);
resultsb.Append("\r\n");
failureNumber++;
}
}//endforeach
//this.Page.RegisterStartupScript("", "<script>alert('" + successNumber + " 条信息成功导入！\r\n" + failureNumber + " 条信息无法导入！\r\n');</script>");
Response.Redirect("StudentFind.aspx");
//ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('" + successNumber + " 条信息成功导入！\r\n" + failureNumber + " 条信息无法导入！\r\n');</script>");
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('选定的文件不是合法的Excel文件！');</script>");
}
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('没有选定的要导入的文件！');</script>");
}
}