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>"); } }