Пример #1
0
        /// <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);
        }