private void GetReadingRooms(ClassModel.LibraryInfo libinfo, string libid) { try { string sqlstr = "SELECT [ReadingRoomID],[ReadingRoomNo],[ReadingRoomName],[ReadingRoomOrder],[LibraryID],[ReadingSetting],[RoomSeat] FROM [T_SM_ReadingRoom] WHERE [LibraryID]='" + libid + "'"; DataSet ds = Query(sqlstr, Old_connectionString, null); foreach (DataRow dr in ds.Tables[0].Rows) { ClassModel.ReadingRoomInfo room = new ClassModel.ReadingRoomInfo(); room.Libaray = libinfo; room.Name = dr["ReadingRoomName"].ToString(); ClassModel.SeatLayout sl = ClassModel.SeatLayout.GetSeatLayout(dr["RoomSeat"].ToString()); sl.RoomNo = sl.Seats.Keys.ElementAt(0).Substring(0, 6); room.No = sl.RoomNo; room.SeatList = sl; room.Setting = new ClassModel.ReadingRoomSetting(); if (Progress != null) { Progress("正在导入阅览室:" + dr["ReadingRoomName"].ToString() + "……"); } if (!SeatManage.Bll.T_SM_ReadingRoom.AddNewReadingRoom(room)) { throw new Exception("添加阅览室失败!"); } else { if (Progress != null) { Progress("阅览室:" + dr["ReadingRoomName"].ToString() + "导入成功!"); } } roomcount++; if (SeatManage.Bll.T_SM_ReadingRoom.UpdateSeatLayout(room.SeatList) == SeatManage.EnumType.HandleResult.Failed) { throw new Exception("添加座位失败!"); } else { if (Progress != null) { Progress("阅览室:" + dr["ReadingRoomName"].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; } }