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