/// <summary> /// 把64服务器上byjiang数据库中的教师同步到本地Base_Teacher表中 /// </summary> /// <returns></returns> public int SynochroTeacher() { SqlHelper2 sh2 = new SqlHelper2(); sh2.Open(); Synchro64DAL sy64 = new Synchro64DAL(sh2); DataTable dt = sy64.SyncTeacher(); SqlHelper sh = new SqlHelper(); sh.Open(); DeleteOldDAL dlt = new DeleteOldDAL(sh); dlt.DeleteBase_Teacher(); InsertNewDAL insertNewDAL = new InsertNewDAL(sh); int res = 0; foreach (DataRow row in dt.Rows) { TeacherModel model = new TeacherModel(); model.Term = row.Value("Term", ""); model.UserID = row.Value("UserID", ""); model.UserName = row.Value("UserName", ""); model.Gender = row.Value("Gender", ""); model.SchoolID = row.Value("SchoolID", ""); model.SchoolName = row.Value("SchoolName", ""); model.SubjectIDs = row.Value("SubjectIDs", ""); model.SubjectNames = row.Value("SubjectNames", ""); //model.TS = row.Value("TS", DateTime.Now); res = insertNewDAL.InsertTeacher(model); } sh2.Close(); sh.Close(); return(res); }