//protected override void SetLines(Worksheet ws, string sSelItems, string sSelTypeIDs, long lGxID, int nStartYear, int nEndYear)
//{
// ArrayList arrNames = new ArrayList(); ArrayList arrValues = new ArrayList(); ArrayList arrSigns = new ArrayList();
// arrNames.Add("bmk.DelFlag"); arrValues.Add(false); arrSigns.Add(SIGN.Equal);
// arrNames.Add("bmk.YearCode"); arrValues.Add(nStartYear); arrSigns.Add(SIGN.GreaterThanOrEqual);
// arrNames.Add("bmk.YearCode"); arrValues.Add(nEndYear); arrSigns.Add(SIGN.LessThanOrEqual);
// arrNames.Add("bmk.GxID"); arrValues.Add(lGxID); arrSigns.Add(SIGN.Equal);
// int nItemPos;
// int nRowNumX;
// int nRowNumY;
// ArrayList ItemKeys;
// ArrayList arrItems;
// SetLinesPre(ws, sSelItems, sSelTypeIDs, out nItemPos, out nRowNumX, out nRowNumY, out ItemKeys, out arrItems);
// var tempMan = new tddTableManage();
// _DFSSetLine(nItemPos, nRowNumX, nRowNumY, ws, ItemKeys, arrItems, arrNames, arrValues, arrSigns,tempMan);
//}
//protected override int _DFSSetLine(int nItemPos, int nRowNumX, int nRowNumY, Worksheet ws, ArrayList ItemKeys, ArrayList arrItems, ArrayList arrNames, ArrayList arrValues, ArrayList arrSigns,object tempMan)
//{
// return _DFSSetLine1(nItemPos, nRowNumX, nRowNumY, ws, ItemKeys, arrItems, arrNames, arrValues, arrSigns,tempMan);
//}
protected override int _SetLineCore(int nItemPos, int nRowNumX, Worksheet ws, ArrayList ItemKeys, ArrayList arrItems, ArrayList arrNowNames, ArrayList arrNowValues, ArrayList arrNowSigns, int nRowNowNumY, long ReportTypeID)
{
tddTableManage tddMan = new tddTableManage();
if (nItemPos == ItemKeys.Count - 1)
{
Expression <Func <T_tdd, bool> > where = GetAndLambdaExpression <T_tdd>(arrNowNames, arrNowValues, arrNowSigns);
int count = tddMan.GetRecordCount(where);
clsExcelApp.SetCellValue(ws, nRowNumX, 1, nRowNumX - 3); //序号
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, count); //录取人数
nRowNumX++;
if (nItemPos == 0)
{
nUnitRow1 = nRowNumX;
}
else if (nItemPos == 1)
{
nUnitRow2 = nRowNumX;
}
else if (nItemPos == 2)
{
nUnitRow3 = nRowNumX;
}
}
else
{
nRowNumX = DFSSetLine(nItemPos + 1, nRowNumX, nRowNowNumY, ws, ItemKeys, arrItems, arrNowNames, arrNowValues, arrNowSigns, ReportTypeID);
}
UnitCellCore(nItemPos, nRowNumX, ws, ItemKeys);
return(nRowNumX);
}
protected override int _SetLineCore(int nItemPos, int nRowNumX, Worksheet ws, ArrayList ItemKeys, ArrayList arrItems, ArrayList arrNowNames, ArrayList arrNowValues, ArrayList arrNowSigns, int nRowNowNumY, long ReportTypeID)
{
tddTableManage tddMan = new tddTableManage();
if (nItemPos == ItemKeys.Count - 1)
{
double maxScore = 0; // 最高分
double minScore = 0; // 最低分
double sumScore = 0; // 所有人的总分
double aveScore = 0; //平均分
Expression <Func <T_tdd, bool> > where = GetAndLambdaExpression <T_tdd>(arrNowNames, arrNowValues, arrNowSigns);
int count = tddMan.GetRecordCount(where);
List <T_tdd> list = tddMan.GetRecord(where);
clsExcelApp.SetCellValue(ws, nRowNumX, 1, nRowNumX - 3); //序号
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, count); //录取人数
if (list != null && list.Count > 0)
{
minScore = maxScore = list[0].Tzcj;
foreach (T_tdd l in list)
{
if (l.Tzcj < minScore)
{
minScore = l.Tzcj;
}
if (l.Tzcj > maxScore)
{
maxScore = l.Tzcj;
}
sumScore += l.Tzcj;
}
aveScore = sumScore / count;
}
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY + 1, maxScore); //最高分
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY + 2, minScore); //最低分
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY + 3, aveScore); //平均分
nRowNumX++;
if (nItemPos == 0)
{
nUnitRow1 = nRowNumX;
}
else if (nItemPos == 1)
{
nUnitRow2 = nRowNumX;
}
else if (nItemPos == 2)
{
nUnitRow3 = nRowNumX;
}
}
else
{
nRowNumX = DFSSetLine(nItemPos + 1, nRowNumX, nRowNowNumY, ws, ItemKeys, arrItems, arrNowNames, arrNowValues, arrNowSigns, ReportTypeID);
}
UnitCellCore(nItemPos, nRowNumX, ws, ItemKeys);
return(nRowNumX);
}
//protected override void SetLines(Worksheet ws, string sSelItems, string sSelTypeIDs, long lGxID, int nStartYear, int nEndYear)
//{
// ArrayList arrNames = new ArrayList(); ArrayList arrValues = new ArrayList(); ArrayList arrSigns = new ArrayList();
// arrNames.Add("bmk.DelFlag"); arrValues.Add(false); arrSigns.Add(SIGN.Equal);
// arrNames.Add("bmk.YearCode"); arrValues.Add(nStartYear); arrSigns.Add(SIGN.GreaterThanOrEqual);
// arrNames.Add("bmk.YearCode"); arrValues.Add(nEndYear); arrSigns.Add(SIGN.LessThanOrEqual);
// arrNames.Add("bmk.GxID"); arrValues.Add(lGxID); arrSigns.Add(SIGN.Equal);
// int nItemPos;
// int nRowNumX;
// int nRowNumY;
// ArrayList ItemKeys;
// ArrayList arrItems;
// SetLinesPre(ws, sSelItems, sSelTypeIDs, out nItemPos, out nRowNumX, out nRowNumY, out ItemKeys, out arrItems);
// var tempMan = new tddTableManage();
// _DFSSetLine(nItemPos, nRowNumX, nRowNumY, ws, ItemKeys, arrItems, arrNames, arrValues, arrSigns, tempMan);
//}
//protected override int _DFSSetLine(int nItemPos, int nRowNumX, int nRowNumY, Worksheet ws, ArrayList ItemKeys, ArrayList arrItems, ArrayList arrNames, ArrayList arrValues, ArrayList arrSigns, object tempMan)
//{
// return _DFSSetLine1(nItemPos, nRowNumX, nRowNumY, ws, ItemKeys, arrItems, arrNames, arrValues, arrSigns,tempMan);
//}
protected override int _SetLineCore(int nItemPos, int nRowNumX, Worksheet ws, ArrayList ItemKeys, ArrayList arrItems, ArrayList arrNowNames, ArrayList arrNowValues, ArrayList arrNowSigns, int nRowNowNumY, long ReportTypeID)
{
tddTableManage tddMan = new tddTableManage();
dqdmTableManage dqMan = new dqdmTableManage();
Expression <Func <T_tdd, bool> > where = GetAndLambdaExpression <T_tdd>(arrNowNames, arrNowValues, arrNowSigns);
List <T_tdd> listModels = tddMan.GetRecord(where);
string[] arr = new string[listModels.Count];
if (listModels.Count > 0)
{
for (int i = 0; i < listModels.Count; i++)
{
if (listModels[i].bmk.dq != null)
{
string cityCode = listModels[i].bmk.dq.Code.Substring(0, 4) + "00";//获得市的行政代码
arr[i] = cityCode;
}
}
var list = from a in arr
group a by a into G
orderby G.Key
select new
{
sCode = G.Key,
count = G.Count()
};
foreach (var l in list)
{
nRowNowNumY = 3;
string cityName = dqMan.GetNowNamefromCode(l.sCode);
clsExcelApp.SetCellValue(ws, nRowNumX, 1, nRowNumX - 3); //序号
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, cityName); nRowNowNumY++;
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, l.count);
nRowNumX++;
}
nRowNumX--;
}
else
{
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, "无"); nRowNowNumY++;
clsExcelApp.SetCellValue(ws, nRowNumX, nRowNowNumY, 0); nRowNowNumY++;
}
nRowNumX++;
clsExcelApp.UniteCells(ws, nUnitRow1, 2, nRowNumX - 1, 2);
//if (nItemPos == 0)
nUnitRow1 = nRowNumX;
//else if (nItemPos == 1)
// nUnitRow2 = nRowNumX;
//else if (nItemPos == 2)
// nUnitRow3 = nRowNumX;
//UnitCellCore(nItemPos, nRowNumX, ws, ItemKeys);
return(nRowNumX);
}
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();
}
