protected int _AddColumnHeader(Worksheet ws, string sSelItems, string sSelTypeIDs, long lGxID, int nStartYear, int nEndYear) { List <string> ss = new List <string>(sSelTypeIDs.Split(CosValue.SPLITOPERATOR2)); List <string> sss = ss.Distinct().ToList(); int num = 1; clsExcelApp.SetCellValue(ws, 3, num, "序号"); num++; foreach (string s in DynamicKeys) { if (sss.Contains(s)) { switch (s) { case "Department": clsExcelApp.SetCellValue(ws, 3, num, "院系"); num++; clsExcelApp.SetCellValue(ws, 3, num, "专业名称"); num++; //clsExcelApp.SetCellValue(ws, 3, num, "专业代码"); num++; break; case "pcdmTable": List <string> ItemIDs = new List <string>(sSelItems.Split(CosValue.SPLITOPERATOR2)); for (int i = 0; i < ss.Count; i++) { if (ss[i] == "pcdmTable") { pcdmTableManage man = new pcdmTableManage(); Td_pcdm model = man.GetOneRecordbyID <Td_pcdm, string>(ItemIDs[i]); if (model != null) { clsExcelApp.SetCellValue(ws, 3, num, model.Name); num++; } } } break; default: OriginTableManage tableMan = new OriginTableManage(); string sKeyWords = tableMan.GetKeyWords(s); clsExcelApp.SetCellValue(ws, 3, num, sKeyWords); num++; break; } } } return(num); }
public List <ListCompareTable> InportOriginData(DataTable dt, int nNowYear, long lProvinceID) { List <ListCompareTable> listReturn = new List <ListCompareTable>(); if (dt != null) { bool flag = false; OriginTableManage manOrigin = new OriginTableManage(); string[] mainColumns = { "ZYLBDM", "ZYLBMC" }; List <Td_zylbdm_Origin> OriginModels = manOrigin.InportSomeRowsOriginTable <Td_zylbdm_Origin>(dt, nNowYear, lProvinceID, mainColumns); for (int i = 0; i < OriginModels.Count; i++) { long lNowRelationID = OriginModels[i].RelationID; if (lNowRelationID == 0) //原始表中新加入的字段 { flag = true; Td_zylbdm zylbObj = IsExistType(OriginModels[i]); if (zylbObj == null) //如果在数据库中不存在,zylbdm表中需要增加该model { string OriginDM = OriginModels[i].DM; while (OriginDM.Length < 2) { OriginDM = "0" + OriginDM; } string sFirstCode = GetSubString(OriginDM, 0, 2); string sSecondCode = GetSubString(OriginDM, 2, 2); string sThirdCode = GetSubString(OriginDM, 4, 0); string sTypeName = OriginModels[i].MC; long lNewID = 0; Td_zylbdm model = new Td_zylbdm(); model.Code = OriginModels[i].DM; model.Name = sTypeName; model.JoinNames = model.Name; if (sSecondCode == "") //一级节点 { model.ParentIndex = -1; lNewID = SaveOneFirstTypeNode(model); } else if (sThirdCode == "") { lNewID = SaveOneSecondTypeNode(model, sFirstCode); } else { lNewID = SaveOneThirdTypeNode(model, sSecondCode, sFirstCode); } ListCompareTable oneTable = new ListCompareTable(); oneTable.sOldID = OriginModels[i].DM; oneTable.lNewID = lNewID; oneTable.lOriginID = OriginModels[i].ID; listReturn.Add(oneTable); //修改原始表中相应的RelationID OriginModels[i].RelationID = lNewID; } else { ListCompareTable oneTable = new ListCompareTable(); oneTable.sOldID = OriginModels[i].DM; if (zylbObj.DelFlag) { oneTable.lNewID = zylbObj.JoinID; OriginModels[i].RelationID = zylbObj.JoinID; } else { oneTable.lNewID = zylbObj.ID; OriginModels[i].RelationID = zylbObj.ID; } oneTable.lOriginID = OriginModels[i].ID; listReturn.Add(oneTable); } } else { ListCompareTable oneTable = new ListCompareTable(); oneTable.sOldID = OriginModels[i].DM; oneTable.lNewID = lNowRelationID; oneTable.lOriginID = OriginModels[i].ID; listReturn.Add(oneTable); } } if (flag) { SaveManyRecords(OriginModels); } } return(listReturn); }
public List <ListCompareTable> InportOriginData(DataTable dt, int nYear, long lProvinceID, string[] mainColumns) { DataTable datatable = ShrinkDataTable(dt, lProvinceID); //先把其他省份的去掉 System.Data.DataView dv = datatable.DefaultView; dv.Sort = "DQDM Asc"; DataTable dt2 = dv.ToTable(true); List <ListCompareTable> listReturn = new List <ListCompareTable>(); OriginTableManage man = new OriginTableManage(); List <Td_dqdm_Origin> OriginModels = man.InportSomeRowsOriginTable <Td_dqdm_Origin>(dt, nYear, lProvinceID, mainColumns); List <Td_dqdm> Models = GetAllLeafNodes <Td_dqdm>(lProvinceID); //TableStatusManage statusManage = new TableStatusManage(); 地区代码,认为每个省份的数据库无重复 bool flag = true; //记录有无修改 for (int i = 0; i < OriginModels.Count; i++) { long lNowRelationID = Convert.ToInt64(OriginModels[i].RelationID); if (lNowRelationID == 0) //原始表中新加入的字段 { flag = false; Td_dqdm dqObj = IsExistRegion(OriginModels[i], Models); if (dqObj == null) //如果区域在数据库中不存在,dqdm表中需要增加该区域 { string sFirstCode, sSecondCode, sThirdCode; if ((OriginModels[i].DM.Length >= 2) && (IsNumeric(OriginModels[i].DM))) { sFirstCode = OriginModels[i].DM.Substring(0, 2); } else { sFirstCode = "00"; } if ((OriginModels[i].DM.Length >= 4) && (IsNumeric(OriginModels[i].DM))) { sSecondCode = OriginModels[i].DM.Substring(2, 2); } else { sSecondCode = "00"; } if ((OriginModels[i].DM.Length >= 6) && (IsNumeric(OriginModels[i].DM))) { sThirdCode = OriginModels[i].DM.Substring(4, 2); } else { sThirdCode = "00"; } long lNewID = 0; Td_dqdm model = new Td_dqdm(); model.Code = OriginModels[i].DM; model.Name = OriginModels[i].MC; model.JoinNames = OriginModels[i].MC; if (sThirdCode == "00") //二级节点 (不可能增加一级节点) { model.TheOrder = Convert.ToInt16(sSecondCode); model.ParentIndex = lProvinceID; } else //三级节点 { string sParentCode = sFirstCode + sSecondCode + "00"; Td_dqdm nowCity = null; List <Td_dqdm> listHere = Models.Where(c => c.Code == sParentCode).ToList(); if ((listHere == null) || (listHere.Count == 0)) //二级节点不存在 { nowCity = new Td_dqdm(); nowCity.ParentIndex = lProvinceID; nowCity.Code = sParentCode; nowCity.TheOrder = Convert.ToInt16(sSecondCode); nowCity.Name = "市辖区/县"; AddOneTreeNode(nowCity); } else { nowCity = listHere[0]; } model.TheOrder = Convert.ToInt16(sThirdCode); model.ParentIndex = nowCity.ID; } lNewID = AddOneTreeNode(model); ListCompareTable oneTable = new ListCompareTable(); oneTable.sOldID = OriginModels[i].DM; oneTable.lNewID = lNewID; oneTable.lOriginID = OriginModels[i].ID; listReturn.Add(oneTable); OriginModels[i].RelationID = lNewID; } else { string sRegionName = OriginModels[i].MC; if (dqObj.Code == null) { dqObj.Code = OriginModels[i].DM; string[] EditColumn = { "Code" }; SaveOneRecord(dqObj, EditColumn); } if (sRegionName != dqObj.Name) { if (!dqObj.JoinNames.Split(CosValue.SPLITOPERATOR1).Contains(sRegionName)) { dqObj.JoinNames = dqObj.JoinNames + CosValue.SPLITOPERATOR1 + sRegionName; string[] EditColumn = { "JoinNames" }; SaveOneRecord(dqObj, EditColumn); } } ListCompareTable oneTable = new ListCompareTable(); oneTable.sOldID = OriginModels[i].DM; if (dqObj.DelFlag) { oneTable.lNewID = dqObj.JoinID; OriginModels[i].RelationID = dqObj.JoinID; } else { oneTable.lNewID = dqObj.ID; OriginModels[i].RelationID = dqObj.ID; } oneTable.lOriginID = OriginModels[i].ID; listReturn.Add(oneTable); } } else { ListCompareTable oneTable = new ListCompareTable(); oneTable.sOldID = OriginModels[i].DM; oneTable.lNewID = lNowRelationID; oneTable.lOriginID = OriginModels[i].ID; listReturn.Add(oneTable); } } if (!flag) { SaveManyRecords(OriginModels); } return(listReturn); }
//protected virtual int _DFSSetLine(int nItemPos, int nRowNumX, int nRowNumY, Worksheet ws, ArrayList ItemKeys, ArrayList arrItems, ArrayList arrNames, ArrayList arrValues, ArrayList arrSigns, object tempMan) //{ // return nRowNumX; //} protected virtual int DFSSetLine(int nItemPos, int nRowNumX, int nRowNumY, Worksheet ws, ArrayList ItemKeys, ArrayList arrItems, ArrayList arrNames, ArrayList arrValues, ArrayList arrSigns, long ReportTypeID) { dqdmTableManage dqMan = new dqdmTableManage(); OriginTableManage tableMan = new OriginTableManage(); for (int i = 0; i < ((ArrayList)arrItems[nItemPos]).Count; i++) { if (ItemKeys[nItemPos].ToString() == "pcdmTable") { continue; } ArrayList arrNowNames = new ArrayList(); ArrayList arrNowValues = new ArrayList(); ArrayList arrNowSigns = new ArrayList(); for (int j = 0; j < arrNames.Count; j++) { arrNowNames.Add(arrNames[j]); arrNowValues.Add(arrValues[j]); arrNowSigns.Add(arrSigns[j]); } long lNowID = Convert.ToInt64(((ArrayList)arrItems[nItemPos])[i]); int nRowNowNumY = nRowNumY; string sColumnValue = ""; switch (ItemKeys[nItemPos].ToString()) { case "Department": zydhTableManage zyMan = new zydhTableManage(); tblDepartmentInfo depart = GetOneRecordbyID <tblDepartmentInfo, long>(lNowID); if (depart.ZYIDs != null && depart.ZYIDs != "" && depart.ZYIDs != " ") { long[] ZyIDs = Array.ConvertAll(depart.ZYIDs.Split(CosValue.SPLITOPERATOR2), long.Parse); if (ZyIDs.Length > 0) { clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, depart.Name); nRowNowNumY++; int nRowNumXX = nRowNumX; switch (ReportTypeID) { case 1: //计划库 arrNowNames.Add("Zydh"); arrNowValues.Add(0); arrNowSigns.Add(SIGN.Equal); break; case 3: //批次,第一志愿 case 4: arrNowNames.Add("jhk.Zydh"); arrNowValues.Add(0); arrNowSigns.Add(SIGN.Equal); break; default: arrNowNames.Add("Lqzy"); arrNowValues.Add(0); arrNowSigns.Add(SIGN.Equal); break; } for (int j = 0; j < ZyIDs.Length; j++) { arrNowValues[arrNowValues.Count - 1] = ZyIDs[j]; Td_zydh zymodel = GetOneRecordbyID <Td_zydh, long>(ZyIDs[j]); int nRowNowNumYY = nRowNowNumY; if (zymodel != null) { clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumYY, zymodel.Name); nRowNowNumYY++; //clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumYY, zymodel.Code); nRowNowNumYY++; nRowNumX = _SetLineCore(nItemPos, nRowNumX, ws, ItemKeys, arrItems, arrNowNames, arrNowValues, arrNowSigns, nRowNowNumYY, ReportTypeID); } } clsExcelApp.UniteCells(ws, nRowNumXX, nRowNowNumY - 1, nRowNumX - 1, nRowNowNumY - 1); } } break; case "Province": if (ReportTypeID == 1) //因为jhk里直接有ProvinceID字段,否则前面要加bmk来找 { arrNowNames.Add("ProvinceID"); } else { arrNowNames.Add("bmk.ProvinceID"); } arrNowValues.Add(lNowID); arrNowSigns.Add(SIGN.Equal); string sProvinceName = dqMan.GetNowNamefromID(lNowID); clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, sProvinceName); //省份 nRowNowNumY++; nRowNumX = _SetLineCore(nItemPos, nRowNumX, ws, ItemKeys, arrItems, arrNowNames, arrNowValues, arrNowSigns, nRowNowNumY, ReportTypeID); break; default: string sNowTableName = ItemKeys[nItemPos].ToString().Replace("Table", ""); sNowTableName = "bmk." + sNowTableName.Substring(0, 1).ToUpper() + sNowTableName.Substring(1, sNowTableName.Length - 1); arrNowNames.Add(sNowTableName); arrNowValues.Add(lNowID); arrNowSigns.Add(SIGN.Equal); sColumnValue = tableMan.GetNowNamefromID(lNowID, ItemKeys[nItemPos].ToString()); clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, sColumnValue); nRowNowNumY++; nRowNumX = _SetLineCore(nItemPos, nRowNumX, ws, ItemKeys, arrItems, arrNowNames, arrNowValues, arrNowSigns, nRowNowNumY, ReportTypeID); break; } } return(nRowNumX); }
private void InportWhole(tblOriginDataPackageInfo model) { //首先要解压 ZipFileTask ziptask = new ZipFileTask(); if (model.FileType == "数据") { ziptask.ExtractZipFile(ConstAddressPath.ORIGINZIP_WEBPATH + model.NowAddress, ConstAddressPath.TEMP_WEBPATH + model.NowAddress); //解压完毕后,对每个dbf文件名进行处理(文件名长度不能超过8) string sRootPath = ConstAddressPath.TEMP_WEBPATH + model.NowAddress; RenameAllDBFFiles(sRootPath); OriginTableManage manOrigin = new OriginTableManage(); string[] sAllYearPath = Directory.GetFileSystemEntries(sRootPath); ArrayList arrAllThreads = new ArrayList(); foreach (string sYearPath in sAllYearPath) { //第一层目录应该是年份 //int nNowYear = Convert.ToInt32(sYearPath.Substring(sYearPath.LastIndexOf('\\') + 1)); string sNowYear = sYearPath.Substring(sYearPath.LastIndexOf('\\') + 1); int nNowYear = Convert.ToInt32(sNowYear.Substring(sNowYear.IndexOf("20"), 4)); //int nNowYear = Convert.ToInt32(System.Text.RegularExpressions.Regex.Replace(sNowYear, @"[^0-9]+","")); //第二层目录应该是省份名称 string[] sAllNowPath = Directory.GetFileSystemEntries(sYearPath); foreach (string sNowPath in sAllNowPath) { string sProvinceName = sNowPath.Substring(sNowPath.LastIndexOf('\\') + 1); dqdmTableManage dqdmMan = new dqdmTableManage(); long lProvinceID = dqdmMan.GetCurrentRegionbyName(sProvinceName); //InportOneWholePath(sNowPath, nNowYear, lProvinceID, model); oneThreadModel one = new oneThreadModel(); one.nNowYear = nNowYear; one.sNowPath = sNowPath; one.lProvinceID = lProvinceID; one.model = model; AllTableStatus.InitAllTableStatus(); //InportOneWholeThread(one); //非线程处理 Thread th = new Thread(InportOneWholeThread); //新线程 th.Start(one); arrAllThreads.Add(th); } } bool flag = false; while (!flag) { flag = true; int i = 0; while ((i < arrAllThreads.Count) && (flag)) { Thread s = (Thread)arrAllThreads[i]; if (s.ThreadState == System.Threading.ThreadState.Running) { flag = false; } i++; } if (!flag) { Thread.Sleep(60000); } } FileManager file = new FileManager(); file.DeleteFolder(sRootPath); } else if (model.FileType == "照片") { ziptask.ExtractZipFile(ConstAddressPath.ORIGINZIP_WEBPATH + model.NowAddress, ConstAddressPath.ORIGINSTUPIC_WEBPATH + model.GxID + "\\temp"); string sRootPath = ConstAddressPath.ORIGINSTUPIC_WEBPATH + model.GxID + "\\temp"; OriginTableManage manOrigin = new OriginTableManage(); string[] sAllYearPath = Directory.GetFileSystemEntries(sRootPath); ArrayList arrAllThreads = new ArrayList(); foreach (string sYearPath in sAllYearPath) { //第一层目录应该是年份,并获得其年份值 //int nNowYear = Convert.ToInt32(sYearPath.Substring(sYearPath.LastIndexOf('\\') + 1)); string sNowYear = sYearPath.Substring(sYearPath.LastIndexOf('\\') + 1); int nNowYear = -1; try { nNowYear = Convert.ToInt32(sNowYear.Substring(sNowYear.IndexOf("20"), 4)); } catch { nNowYear = DateTime.Now.Year; } //接下来需要递归获得各层目录下的照片文件目录 //将子目录下的文件移动到根目录下 FileManager fm = new FileManager(); List <string> filespath = fm.GetAllFiles(sYearPath); foreach (string filepath in filespath) { string sFileName = filepath.Substring(filepath.LastIndexOf('\\') + 1); string sDestinationName = Path.Combine(ConstAddressPath.ORIGINSTUPIC_WEBPATH + model.GxID, nNowYear.ToString(), sFileName); fm.MoveFile(filepath, sDestinationName); } } FileManager file = new FileManager(); file.DeleteFolder(sRootPath); } model.HandleFlag = "处理完成"; model.FinishDate = DateTime.Now; string[] EditColumn = { "HandleFlag", "FinishDate" }; SaveOneRecord(model, EditColumn); }
private void InportOneWholePath(string sNowPath, int nNowYear, long lProvinceID, tblOriginDataPackageInfo model) { string[] sAllNextPath = Directory.GetFileSystemEntries(sNowPath); int nn = 1; foreach (string sNextPath in sAllNextPath) { if (Directory.Exists(sNextPath)) { string ss = nn.ToString(); string sNewPath = sNextPath.Substring(0, sNextPath.LastIndexOf('\\') + 1) + ss; Directory.Move(sNextPath, sNewPath); nn++; InportOneWholePath(sNewPath, nNowYear, lProvinceID, model); } } string[] sNowFileNameSet = GetNowFileSet(); //打开连接 string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sNowPath + ";Extended Properties=dBASE IV;"; OleDbConnection con = new OleDbConnection(constr); con.Open(); //初始化相关的list List <ListCompareTable> BYLBDM_list = new List <ListCompareTable>(); List <ListCompareTable> CCDM_list = new List <ListCompareTable>(); List <ListCompareTable> CJXDM_list = new List <ListCompareTable>(); List <ListCompareTable> CZLBDM_list = new List <ListCompareTable>(); List <ListCompareTable> DQDM_list = new List <ListCompareTable>(); List <ListCompareTable> HJLBDM_list = new List <ListCompareTable>(); List <ListCompareTable> JHLBDM_list = new List <ListCompareTable>(); List <ListCompareTable> JHXZDM_list = new List <ListCompareTable>(); List <ListCompareTable> KLDM_list = new List <ListCompareTable>(); List <ListCompareTable> KMDM_list = new List <ListCompareTable>(); List <ListCompareTable> KSLBDM_list = new List <ListCompareTable>(); List <ListCompareTable> KSLXDM_list = new List <ListCompareTable>(); List <ListCompareTable> KSTZDM_list = new List <ListCompareTable>(); List <ListCompareTable> KSZGDM_list = new List <ListCompareTable>(); List <ListCompareTable> LQFSDM_list = new List <ListCompareTable>(); List <ListCompareTable> MZDM_list = new List <ListCompareTable>(); List <ListCompareTable> PCDM_list = new List <ListCompareTable>(); List <ListCompareTable> TDLXDM_list = new List <ListCompareTable>(); List <ListCompareTable> TDYYDM_list = new List <ListCompareTable>(); List <ListCompareTable> TJJLDM_list = new List <ListCompareTable>(); List <ListCompareTable> WYYZDM_list = new List <ListCompareTable>(); List <ListCompareTable> XTDWDM_list = new List <ListCompareTable>(); List <ListCompareTable> ZCDM_list = new List <ListCompareTable>(); List <ListCompareTable> XZDM_list = new List <ListCompareTable>(); List <ListCompareTable> ZJLXDM_list = new List <ListCompareTable>(); List <ListCompareTable> ZKLXDM_list = new List <ListCompareTable>(); List <ListCompareTable> ZYLBDM_list = new List <ListCompareTable>(); List <ListCompareTable> ZYTJLXDM_list = new List <ListCompareTable>(); List <ListCompareTable> ZYTZDM_list = new List <ListCompareTable>(); List <ListCompareTable> ZZMMDM_list = new List <ListCompareTable>(); List <ListCompareTable> BYXXDM_list = new List <ListCompareTable>(); List <ListCompareTable> XBDM_list = new List <ListCompareTable>(); List <ListCompareTable> TDDW_list = new List <ListCompareTable>(); List <ListCompareTable> ZYDH_list = new List <ListCompareTable>(); List <BMKTable> BMK_list = new List <BMKTable>(); List <T_jhk> JHK_list = new List <T_jhk>(); OriginTableManage man = new OriginTableManage(); dqdmTableManage dqdmMan = new dqdmTableManage(); //下面就是一个个表的导入了 string[] mainColumns = new string[2]; for (int i = 0; i < sNowFileNameSet.Length; i++) { string sNowFileName = sNowFileNameSet[i]; DataTable dt = GetDbfDataByODBC(GetPropertyFileName(sNowFileName), sNowPath, con); if ((dt != null) && (dt.Rows.Count > 0)) { //sw.Start(); switch (sNowFileName.ToLower()) { case "td_bylbdm.dbf": //毕业类别代码 mainColumns[0] = "BYLBDM"; mainColumns[1] = "BYLBMC"; BYLBDM_list = man.InportSimpleTableOriginData <Td_bylbdm, Td_bylbdm_Origin>(dt, nNowYear, lProvinceID, "bylbdmTable", mainColumns); break; case "td_ccdm.dbf": //层次代码 mainColumns[0] = "CCDM"; mainColumns[1] = "CCMC"; CCDM_list = man.InportSimpleTableOriginData <Td_ccdm, Td_ccdm_Origin>(dt, nNowYear, lProvinceID, "ccdmTable", mainColumns); break; case "td_cjxdm.dbf": //成绩项代码 mainColumns[0] = "CJXDM"; mainColumns[1] = "CJXMC"; CJXDM_list = man.InportSimpleTableOriginData <Td_cjxdm, Td_cjxdm_Origin>(dt, nNowYear, lProvinceID, "cjxdmTable", mainColumns); break; case "td_czlbdm.dbf": //残障类别代码 mainColumns[0] = "CZLBDM"; mainColumns[1] = "CZLBMC"; CZLBDM_list = man.InportSimpleTableOriginData <Td_czlbdm, Td_czlbdm_Origin>(dt, nNowYear, lProvinceID, "czlbdmTable", mainColumns); break; case "td_dqdm.dbf": //地区代码 mainColumns[0] = "DQDM"; mainColumns[1] = "DQMC"; DQDM_list = dqdmMan.InportOriginData(dt, nNowYear, lProvinceID, mainColumns); break; case "td_hjlbdm.dbf": //户籍类别代码 mainColumns[0] = "HJLBDM"; mainColumns[1] = "HJLBMC"; HJLBDM_list = man.InportSimpleTableOriginData <Td_hjlbdm, Td_hjlbdm_Origin>(dt, nNowYear, lProvinceID, "hjlbdmTable", mainColumns); break; case "td_jhlbdm.dbf": //计划类别代码 mainColumns[0] = "JHLBDM"; mainColumns[1] = "JHLBMC"; JHLBDM_list = man.InportSimpleTableOriginData <Td_jhlbdm, Td_jhlbdm_Origin>(dt, nNowYear, lProvinceID, "jhlbdmTable", mainColumns); break; case "td_jhxzdm.dbf": //计划性质代码 mainColumns[0] = "JHXZDM"; mainColumns[1] = "JHXZMC"; JHXZDM_list = man.InportSimpleTableOriginData <Td_jhxzdm, Td_jhxzdm_Origin>(dt, nNowYear, lProvinceID, "jhxzdmTable", mainColumns); break; case "td_kldm.dbf": //科类代码 mainColumns[0] = "KLDM"; mainColumns[1] = "KLMC"; KLDM_list = man.InportSimpleTableOriginData <Td_kldm, Td_kldm_Origin>(dt, nNowYear, lProvinceID, "kldmTable", mainColumns); break; case "td_kmdm.dbf": //科目代码 mainColumns[0] = "KMDM"; mainColumns[1] = "KMMC"; KMDM_list = man.InportSimpleTableOriginData <Td_kmdm, Td_kmdm_Origin>(dt, nNowYear, lProvinceID, "kmdmTable", mainColumns); break; case "td_kslbdm.dbf": //考生类别代码 mainColumns[0] = "KSLBDM"; mainColumns[1] = "KSLBMC"; KSLBDM_list = man.InportSimpleTableOriginData <Td_kslbdm, Td_kslbdm_Origin>(dt, nNowYear, lProvinceID, "kslbdmTable", mainColumns); break; case "td_kslxdm.dbf": //考试类型代码 mainColumns[0] = "KSLXDM"; mainColumns[1] = "KSLXMC"; KSLXDM_list = man.InportSimpleTableOriginData <Td_kslxdm, Td_kslxdm_Origin>(dt, nNowYear, lProvinceID, "kslxdmTable", mainColumns); break; case "td_zcdm.dbf": //政策代码(12有17无) mainColumns[0] = "ZCDM"; mainColumns[1] = "ZCMC"; string[] moreColumns1 = { "ZGF" }; int[] moreColumnTypes1 = { CosDataBase.FLOAT_TYPE }; KSTZDM_list = man.InportSimpleTableOriginData <Td_kstzdm, Td_kstzdm_Origin>(dt, nNowYear, lProvinceID, "kstzdmTable", mainColumns, moreColumns1, moreColumnTypes1); break; case "td_kstzdm.dbf": //考生特征代码(17有12无) mainColumns[0] = "KSTZDM"; mainColumns[1] = "KSTZMC"; string[] moreColumns2 = { "ZGFS" }; int[] moreColumnTypes2 = { CosDataBase.FLOAT_TYPE }; KSTZDM_list = man.InportSimpleTableOriginData <Td_kstzdm, Td_kstzdm_Origin>(dt, nNowYear, lProvinceID, "kstzdmTable", mainColumns, moreColumns2, moreColumnTypes2); break; case "td_kszgdm.dbf": //考生资格代码 mainColumns[0] = "KSZGDM"; mainColumns[1] = "KSZGMC"; KSZGDM_list = man.InportSimpleTableOriginData <Td_kszgdm, Td_kszgdm_Origin>(dt, nNowYear, lProvinceID, "kszgdmTable", mainColumns); break; case "td_lqlxdm.dbf": //录取类型代码(12) mainColumns[0] = "LQLXDM"; mainColumns[1] = "LQLXMC"; LQFSDM_list = man.InportSimpleTableOriginData <Td_lqfsdm, Td_lqfsdm_Origin>(dt, nNowYear, lProvinceID, "lqfsdmTable", mainColumns); break; case "td_lqfsdm.dbf": //录取方式代码(17) mainColumns[0] = "LQFSDM"; mainColumns[1] = "LQFSMC"; LQFSDM_list = man.InportSimpleTableOriginData <Td_lqfsdm, Td_lqfsdm_Origin>(dt, nNowYear, lProvinceID, "lqfsdmTable", mainColumns); break; case "td_mzdm.dbf": //民族代码 mainColumns[0] = "MZDM"; mainColumns[1] = "MZMC"; MZDM_list = man.InportSimpleTableOriginData <Td_mzdm, Td_mzdm_Origin>(dt, nNowYear, lProvinceID, "mzdmTable", mainColumns); break; case "td_pcdm.dbf": //批次代码 mainColumns[0] = "PCDM"; mainColumns[1] = "PCMC"; PCDM_list = man.InportSimpleTableOriginData <Td_pcdm, Td_pcdm_Origin>(dt, nNowYear, lProvinceID, "pcdmTable", mainColumns); break; case "td_tdlxdm.dbf": //投档类型代码 mainColumns[0] = "TDLXDM"; mainColumns[1] = "TDLXMC"; TDLXDM_list = man.InportSimpleTableOriginData <Td_tdlxdm, Td_tdlxdm_Origin>(dt, nNowYear, lProvinceID, "tdlxdmTable", mainColumns); break; case "td_tdyydm.dbf": //退档原因代码 mainColumns[0] = "TDYYDM"; mainColumns[1] = "TDYYMC"; TDYYDM_list = man.InportSimpleTableOriginData <Td_tdyydm, Td_tdyydm_Origin>(dt, nNowYear, lProvinceID, "tdyydmTable", mainColumns); break; case "td_tjjldm.dbf": //体检结论代码 mainColumns[0] = "TJJLDM"; mainColumns[1] = "TJJLMC"; TJJLDM_list = man.InportSimpleTableOriginData <Td_tjjldm, Td_tjjldm_Origin>(dt, nNowYear, lProvinceID, "tjjldmTable", mainColumns); break; case "td_wyyzdm.dbf": //外语语种代码 mainColumns[0] = "WYYZDM"; mainColumns[1] = "WYYZMC"; WYYZDM_list = man.InportSimpleTableOriginData <Td_wyyzdm, Td_wyyzdm_Origin>(dt, nNowYear, lProvinceID, "wyyzdmTable", mainColumns); break; case "td_xtdwdm.dbf": //系统单位代码 mainColumns[0] = "XTDWDM"; mainColumns[1] = "XTDWMC"; XTDWDM_list = man.InportSimpleTableOriginData <Td_xtdwdm, Td_xtdwdm_Origin>(dt, nNowYear, lProvinceID, "xtdwdmTable", mainColumns); break; case "td_xzdm.dbf": //学制代码 mainColumns[0] = "XZDM"; mainColumns[1] = "XZMC"; XZDM_list = man.InportSimpleTableOriginData <Td_xzdm, Td_xzdm_Origin>(dt, nNowYear, lProvinceID, "xzdmTable", mainColumns); break; case "td_zjlxdm.dbf": //证件类型代码 mainColumns[0] = "ZJLXDM"; mainColumns[1] = "ZJLXMC"; ZJLXDM_list = man.InportSimpleTableOriginData <Td_zjlxdm, Td_zjlxdm_Origin>(dt, nNowYear, lProvinceID, "zjlxdmTable", mainColumns); break; case "td_zklxdm.dbf": //招考类型代码 mainColumns[0] = "ZKLXDM"; mainColumns[1] = "ZKLXMC"; ZKLXDM_list = man.InportSimpleTableOriginData <Td_zklxdm, Td_zklxdm_Origin>(dt, nNowYear, lProvinceID, "zklxdmTable", mainColumns); break; case "td_zylbdm.dbf": //专业类别代码 这个表很重要,但是12没有,要从计划库中提取 ZYLBDM_list = (new zylbdmTableManage()).InportOriginData(dt, nNowYear, lProvinceID); break; case "td_zytjlxdm.dbf": //专业调剂类型代码 mainColumns[0] = "ZYTJLXDM"; mainColumns[1] = "ZYTJLXMC"; ZYTJLXDM_list = man.InportSimpleTableOriginData <Td_zytjlxdm, Td_zytjlxdm_Origin>(dt, nNowYear, lProvinceID, "zytjlxdmTable", mainColumns); break; case "td_zytzdm.dbf": //志愿特征代码 mainColumns[0] = "ZYTZDM"; mainColumns[1] = "ZYTZMC"; ZYTZDM_list = man.InportSimpleTableOriginData <Td_zytzdm, Td_zytzdm_Origin>(dt, nNowYear, lProvinceID, "zytzdmTable", mainColumns); break; case "td_zzmmdm.dbf": //政治面貌代码 mainColumns[0] = "ZZMMDM"; mainColumns[1] = "ZZMMMC"; ZZMMDM_list = man.InportSimpleTableOriginData <Td_zzmmdm, Td_zzmmdm_Origin>(dt, nNowYear, lProvinceID, "zzmmdmTable", mainColumns); break; case "td_xbdm.dbf": //性别代码 mainColumns[0] = "XBDM"; mainColumns[1] = "XBMC"; XBDM_list = man.InportSimpleTableOriginData <Td_xbdm, Td_xbdm_Origin>(dt, nNowYear, lProvinceID, "xbdmTable", mainColumns); break; case "td_byxxdm.dbf": BYXXDM_list = man.InportSimpleTableOriginData <Td_byxxdm, Td_byxxdm_Origin>(dt, nNowYear, lProvinceID, "byxxdmTable"); break; //毕业学校代码,这个表原始库中可能没有 case "t_tddw.dbf": tddwTableManage tddwMan = new tddwTableManage(); tddwMan.PCDM_list = PCDM_list; tddwMan.KLDM_list = KLDM_list; tddwMan.JHXZDM_list = JHXZDM_list; tddwMan.JHLBDM_list = JHLBDM_list; TDDW_list = tddwMan.InportOriginData(dt, nNowYear, lProvinceID, model.GxID); break; case "td_zydh.dbf": //2017有,2012没有。12的数据来自计划库 zydhTableManage zydhMan = new zydhTableManage(); zydhMan.CCDM_list = CCDM_list; zydhMan.KLDM_list = KLDM_list; zydhMan.XZDM_list = XZDM_list; zydhMan.ZYLBDM_list = ZYLBDM_list; zydhMan.TDDW_list = TDDW_list; ZYDH_list = zydhMan.InportOriginData(dt, nNowYear, lProvinceID, model.ParentDepartmentID, model.GxID); break; case "t_jhk.dbf": jhkTableManage jhkMan = new jhkTableManage(); jhkMan.PCDM_list = PCDM_list; jhkMan.KLDM_list = KLDM_list; jhkMan.JHXZDM_list = JHXZDM_list; jhkMan.JHLBDM_list = JHLBDM_list; jhkMan.TDDW_list = TDDW_list; jhkMan.ZYDH_list = ZYDH_list; jhkMan.ZKLXDM_list = ZKLXDM_list; jhkMan.ZYLBDM_list = ZYLBDM_list; jhkMan.XZDM_list = XZDM_list; List <ListCompareTable> old12ZYDH_list = new List <ListCompareTable>(); JHK_list = jhkMan.InportOriginData(dt, nNowYear, lProvinceID, model.ParentDepartmentID, model.GxID, out old12ZYDH_list); if ((old12ZYDH_list != null) && (old12ZYDH_list.Count > 0)) { ZYDH_list = old12ZYDH_list; } break; case "t_bmk.dbf": bmkTableManage bmkMan = new bmkTableManage(); bmkMan.BYLBDM_list = BYLBDM_list; bmkMan.CJXDM_list = CJXDM_list; bmkMan.CZLBDM_list = CZLBDM_list; bmkMan.DQDM_list = DQDM_list; bmkMan.HJLBDM_list = HJLBDM_list; bmkMan.KLDM_list = KLDM_list; bmkMan.KMDM_list = KMDM_list; bmkMan.KSLBDM_list = KSLBDM_list; bmkMan.KSLXDM_list = KSLXDM_list; bmkMan.KSTZDM_list = KSTZDM_list; bmkMan.KSZGDM_list = KSZGDM_list; bmkMan.MZDM_list = MZDM_list; bmkMan.WYYZDM_list = WYYZDM_list; bmkMan.ZJLXDM_list = ZJLXDM_list; bmkMan.XTDWDM_list = XTDWDM_list; bmkMan.ZZMMDM_list = ZZMMDM_list; bmkMan.BYXXDM_list = BYXXDM_list; bmkMan.XBDM_list = XBDM_list; BMK_list = bmkMan.InportOriginData(dt, con, sNowPath, nNowYear, lProvinceID, model.GxID); break; case "t_tdd.dbf": tddTableManage tddMan = new tddTableManage(); tddMan.BYLBDM_list = BYLBDM_list; tddMan.CCDM_list = CCDM_list; tddMan.CJXDM_list = CJXDM_list; tddMan.CZLBDM_list = CZLBDM_list; tddMan.DQDM_list = DQDM_list; tddMan.HJLBDM_list = HJLBDM_list; tddMan.JHLBDM_list = JHLBDM_list; tddMan.JHXZDM_list = JHXZDM_list; tddMan.KLDM_list = KLDM_list; tddMan.KMDM_list = KMDM_list; tddMan.KSLBDM_list = KSLBDM_list; tddMan.KSLXDM_list = KSLXDM_list; tddMan.KSTZDM_list = KSTZDM_list; tddMan.KSZGDM_list = KSZGDM_list; tddMan.LQFSDM_list = LQFSDM_list; tddMan.MZDM_list = MZDM_list; tddMan.PCDM_list = PCDM_list; tddMan.TDLXDM_list = TDLXDM_list; tddMan.TDYYDM_list = TDYYDM_list; tddMan.TJJLDM_list = TJJLDM_list; tddMan.WYYZDM_list = WYYZDM_list; tddMan.XTDWDM_list = XTDWDM_list; //tddMan.ZCDM_list = ZCDM_list; tddMan.XZDM_list = XZDM_list; tddMan.ZJLXDM_list = ZJLXDM_list; tddMan.ZKLXDM_list = ZKLXDM_list; tddMan.ZYLBDM_list = ZYLBDM_list; tddMan.ZYTJLXDM_list = ZYTJLXDM_list; tddMan.ZYTZDM_list = ZYTZDM_list; tddMan.ZZMMDM_list = ZZMMDM_list; tddMan.BYXXDM_list = BYXXDM_list; tddMan.XBDM_list = XBDM_list; tddMan.ZYDH_list = ZYDH_list; tddMan.TDDW_list = TDDW_list; tddMan.BMK_list = BMK_list; tddMan.JHK_list = JHK_list; BMK_list = tddMan.InportOriginData(dt, con, sNowPath, nNowYear, lProvinceID, model.GxID); break; case "t_zykmx.dbf": zykTableManage zykMan = new zykTableManage(); zykMan.PCDM_list = PCDM_list; zykMan.KLDM_list = KLDM_list; zykMan.JHXZDM_list = JHXZDM_list; zykMan.JHLBDM_list = JHLBDM_list; zykMan.TDDW_list = TDDW_list; zykMan.ZYDH_list = ZYDH_list; zykMan.BMK_list = BMK_list; zykMan.JHK_list = JHK_list; zykMan.InportOriginData(dt, nNowYear, lProvinceID); break; case "t_ksjl.dbf": ksjlTableManage ksjlMan = new ksjlTableManage(); ksjlMan.BMK_list = BMK_list; ksjlMan.InportOriginData(dt, nNowYear, lProvinceID); break; case "t_kshkcj.dbf": case "t_ksxkcj.dbf": ksxkcjTableManage ksxkcjMan = new ksxkcjTableManage(); ksxkcjMan.KMDM_list = KMDM_list; ksxkcjMan.CJXDM_list = CJXDM_list; ksxkcjMan.BMK_list = BMK_list; ksxkcjMan.InportOriginData(dt, nNowYear, lProvinceID); break; case "t_tjxx.dbf": tjxxTableManage tjxxMan = new tjxxTableManage(); tjxxMan.BMK_list = BMK_list; tjxxMan.InportOriginData(dt, nNowYear, lProvinceID); break; } //sw.Stop(); //TimeSpan ts2 = sw.Elapsed; } } con.Close(); }