/// <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;
}
}
