/// <summary> /// 获取学校列表 /// </summary> /// <returns></returns> private void GetSchools() { try { string sqlstr = "SELECT [SchoolID],[SchoolNo],[SchoolName] ,[SchoolOrder] FROM [T_SM_School]"; DataSet ds = Query(sqlstr, Old_connectionString, null); foreach (DataRow dr in ds.Tables[0].Rows) { ClassModel.School sc = new ClassModel.School(); sc.No = dr["SchoolNo"].ToString(); sc.Name = dr["SchoolName"].ToString(); if (Progress != null) { Progress("正在导入校区:" + dr["SchoolName"].ToString() + "……"); } if (!SeatManage.Bll.T_SM_School.AddNewSchool(sc)) { throw new Exception("添加校区出错!"); } else { if (Progress != null) { Progress("校区:" + dr["SchoolName"].ToString() + "导入成功!"); } } schoolcount++; GetLibs(sc, dr["SchoolID"].ToString()); } } catch { throw; } }
private void GetLibs(ClassModel.School school, string schoolid) { try { string sqlstr = "SELECT [LibraryID],[LibraryNo],[LibraryName],[LibraryOrder],[SchoolID] FROM [T_SM_Library] WHERE [SchoolID]='" + schoolid + "'"; DataSet ds = Query(sqlstr, Old_connectionString, null); foreach (DataRow dr in ds.Tables[0].Rows) { ClassModel.LibraryInfo lib = new ClassModel.LibraryInfo(); lib.No = (libcount + 1).ToString("X2"); lib.Name = dr["LibraryName"].ToString(); lib.School = school; if (Progress != null) { Progress("正在导入图书馆:" + dr["LibraryName"].ToString() + "……"); } if (!SeatManage.Bll.T_SM_Library.AddNewLibrary(lib)) { throw new Exception("添加图书馆出错!"); } else { if (Progress != null) { Progress("图书馆:" + dr["LibraryName"].ToString() + "导入成功!"); } } libcount++; GetReadingRooms(lib, dr["LibraryID"].ToString()); } } catch { throw; } }