//从Title面板中获取TitleInformation类信息 private void getTitleInformation() { this.titleInformation = new TitleInformation(); this.titleInformation.Xxmc = xxxxbox.Text.Trim(); //获取学校名称 this.titleInformation.Xymc = xyxxbox.Text.Trim(); //获取学院名称 this.titleInformation.Zymc = zyxxbox.Text.Trim(); //获取专业名称 this.titleInformation.Bjmc = bjxxbox.Text.Trim(); //获取班级名称 this.titleInformation.Tbrmc = tbrxxbox.Text.Trim(); //获取填表人名称 this.titleInformation.Lxdh = lxdhbox.Text.Trim(); //联获取系方式 this.titleInformation.Tbrq = tbrqbox.Value; //获取填表日期 }
//从指定文件中读出学生数据 private bool openFile(string fileName) { bool result = false; try { DataSet myds = new DataSet(); //获取全部数据 String pOledbCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties=Excel 8.0;"; OleDbConnection oledbCon = new OleDbConnection(pOledbCon); //创建Oledb数据库连接对象 string pExcelSql = ""; //记录要执行的Excel查询语句 OleDbDataAdapter oledba = null; //创建Oledb数据桥连接器对象 string sheetName = "Sheet1"; pExcelSql = String.Format("select * from [{0}$]", sheetName); //可以考虑修改为可配置 oledba = new OleDbDataAdapter(pExcelSql, pOledbCon); oledba.Fill(myds, sheetName); if (myds.Tables[0].Rows.Count > 4) { ///初始化title信息 DataRow r0 = myds.Tables[0].Rows[0]; string title1 = Convert.ToString(r0[0]); title1 = title1.Trim(); if (!title1.Equals("人员基本信息表")) { string[] titles = title1.Split(' '); this.titleInformation = new TitleInformation(); this.titleInformation.Xxmc = titles[0]; this.titleInformation.Xymc = titles[1]; this.titleInformation.Zymc = string.IsNullOrEmpty(titles[2]) ? titles[2] : titles[2].Replace("人员基本信息表", ""); } DataRow r1 = myds.Tables[0].Rows[1]; string bjmcTemp = Convert.ToString(r1[1]); if (!string.IsNullOrEmpty(bjmcTemp)) { this.titleInformation.Bjmc = bjmcTemp; } string tbrmcTemp = Convert.ToString(r1[4]); if (!string.IsNullOrEmpty(tbrmcTemp)) { this.titleInformation.Tbrmc = tbrmcTemp; } string lxdhTemp = Convert.ToString(r1[7]); if (!string.IsNullOrEmpty(lxdhTemp)) { this.titleInformation.Lxdh = lxdhTemp; } DateTime dt = Convert.ToDateTime(r1[10]); if (dt != null) { this.titleInformation.Tbrq = dt; } this.setTitleInformation();//设置title信息 ///初始化title信息 /// for (int i = 3; i < myds.Tables[0].Rows.Count; i++) { DataRow r = myds.Tables[0].Rows[i]; StudentInfo stu = new StudentInfo(); stu.Bh = BhCount;//获取学生临时编号 stu.Xm = Convert.ToString(r[0]); stu.Zjhm = Convert.ToString(r[1]); stu.Xb = Convert.ToString(r[2]); stu.Mz = Convert.ToString(r[3]); stu.Whcd = Convert.ToString(r[4]); stu.Zzmm = Convert.ToString(r[5]); stu.Zjxy = Convert.ToString(r[6]); stu.Hjdxzqh = Convert.ToString(r[7]); stu.Hjdxz = Convert.ToString(r[8]); stu.Hkxz = Convert.ToString(r[9]); stu.Bzxx = Convert.ToString(r[10]); if (!stu.CheckAllEmpty()) { this.StuList.Add(stu);//添加学生信息 } } } checkTool.checkAndSetStuList(this.StuList); //检测学生列表并置空错误项 result = true; //标记正常处理完成 } catch (Exception e) { Console.WriteLine(e.Message); result = false; } return(result); }