public int UpdateByTime() { SqlHelper sh = new SqlHelper(); sh.Open(); DeleteOldDAL dlt = new DeleteOldDAL(sh); InsertNewDAL ins = new InsertNewDAL(sh); try { // 把本地的中间结果数据表进行更新(先清空后插入) dlt.DeleteUserUse(); ins.InsertUesr_Use(); dlt.DeleteSubject_Use(); ins.InsertSubject_Use(); dlt.DeleteResource_UseTotal(); ins.InsertResource_UseTotal(); } catch (Exception ex) { return(0); //更新数据失败 } return(1); //跟新数据成功 }
/// <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); }
/// <summary> /// 把资源库存储过程的结果插入本地表Transer_Resource3中 /// </summary> /// <returns></returns> public int GetResListByTime() { SqlHelper1 sh = new SqlHelper1(); sh.Open(); Resource_GetResListDAL dal = new Resource_GetResListDAL(sh); SqlHelper db = new SqlHelper(); db.Open(); Transer_Resource2DAL trdal = new Transer_Resource2DAL(db); DeleteOldDAL dod = new DeleteOldDAL(db); dod.DeleteResList(); int pageIndex = 1; int size = 5001; int res = 0; try { while (size >= 5000) { DataTable dt = dal.GetResListByTime(pageIndex); size = dt.Rows.Count; foreach (DataRow row in dt.Rows) { Transer_Resource2Model model = new Transer_Resource2Model(); model._RESOURCE_ID = row.Value("RESOURCE_ID", ""); model._RESOURCE_NAME = row.Value("RESOURCE_NAME", ""); model._RESOURCE_TYPE = row.Value("RESOURCE_TYPE", 0.00M); model._RESOURCE_LEVEL = row.Value("RESOURCE_LEVEL", ""); model._STORE_DATE = row.Value("STORE_DATE", DateTime.Now); model._THEME_CODE = row.Value("THEME_CODE", ""); model._THEME_TEXT = row.Value("THEME_TEXT", ""); model._IMPOR_KN_CODE = row.Value("IMPOR_KN_CODE", ""); model._IMPOR_KN_TEXT = row.Value("IMPOR_KN_TEXT", ""); model._MAIN_KN_CODE = row.Value("MAIN_KN_CODE", ""); model._MAIN_KN_TEXT = row.Value("MAIN_KN_TEXT", ""); model._UNIT_NUM = row.Value("UNIT_NUM", 0.00M); model._RESOURCE_SIZE = row.Value("RESOURCE_SIZE", 0.00M); model._ABANDON_NUM = row.Value("ABANDON_NUM", ""); model._APPLY_TOTAL_TIME = row.Value("APPLY_TOTAL_TIME", 0.00M); model._ABANDON_RATE = row.Value("ABANDON_RATE", ""); model._DOWNLOAD_NUM = row.Value("DOWNLOAD_NUM", ""); model._SOURCE_LIBRARY = row.Value("SOURCE_LIBRARY", ""); model._RESOURCE_CLASS = row.Value("RESOURCE_CLASS", ""); model._MD5_CODE = row.Value("MD5_CODE", ""); model._INSTITU_UNIT = row.Value("INSTITU_UNIT", ""); model._RES_LENGTH = row.Value("RES_LENGTH", 0.00M); model._DURATION_LENGTH = row.Value("DURATION_LENGTH", 0.00M); model._FILE_PATH = row.Value("FILE_PATH", ""); model._FILE_CONTENT = row.Value("FILE_CONTENT", ""); model._IS_EXSIT_MEDIA = row.Value("IS_EXSIT_MEDIA", 0.00M); model._DOWNLOAD_FLAG = row.Value("DOWNLOAD_FLAG", 0.00M); model._SEQUENCE = row.Value("SEQUENCE", 0.00M); model._HEAT_NUM = row.Value("HEAT_NUM", 0.00M); model._SUBJECT_CODE = row.Value("SUBJECT_CODE", ""); res += trdal.AddResListByTime(model); } pageIndex++; } } catch (Exception ex) { return(-1); //内部报错 //日志 } db.Close(); return(res); }