public void InportOriginData(DataTable dt, int nYear, long lProvinceID)
{
if (dt != null)
{
List <T_zyk> listAdd = new List <T_zyk>();
bmkTableManage bmkMan = new bmkTableManage();
foreach (DataRow dr in dt.Rows)
{
//long lbmkID = bmkMan.GetbmkID(dr["KSH"].ToString());
long lbmkID = GetBMKIDFromList(BMK_list, dr["KSH"].ToString());
if (lbmkID != 0)
{
//首先找到计划库对应的字段
long lPcdm = GetOriginListID(PCDM_list, GetOneStrValue(dr, "PCDM", CosDataBase.LONGINT_TYPE));
long lKldm = GetOriginListID(KLDM_list, GetOneStrValue(dr, "KLDM", CosDataBase.LONGINT_TYPE));
long lJhxzdm = GetOriginListID(JHXZDM_list, GetOneStrValue(dr, "JHXZDM", CosDataBase.LONGINT_TYPE));
long lJhlbdm = GetOriginListID(JHLBDM_list, GetOneStrValue(dr, "JHLBDM", CosDataBase.LONGINT_TYPE));
long lTddwdm = GetOriginListID(TDDW_list, GetOneStrValue(dr, "TDDWDM", CosDataBase.LONGINT_TYPE));
long lZydh = GetOriginListID(ZYDH_list, GetOneStrValue(dr, "ZYDH", CosDataBase.LONGINT_TYPE));
//Expression<Func<T_jhk, bool>> where = (c => c.ZydhOrigin == lZydh && c.TddwdmOrigin == lTddwdm);
//List<T_jhk> list = GetRecord(where);
List <T_jhk> list = JHK_list.Where(c => c.ZydhOrigin == lZydh && c.TddwdmOrigin == lTddwdm).ToList();
if ((list != null) && (list.Count > 0))
{
long lJhkID = list[0].ID;
//Expression<Func<T_zyk, bool>> where1 = (c => c.RelationID1 == lbmkID && c.RelationID2 == lJhkID);
//List<T_zyk> list1 = GetRecord(where1);
//if ((list1 == null) || (list1.Count == 0))
//{
T_zyk model = new T_zyk();
model.RelationID1 = lbmkID;
model.RelationID2 = lJhkID;
model.PcdmOrigin = lPcdm;
model.KldmOrigin = lKldm;
model.JhxzdmOrigin = lJhxzdm;
model.JhlbdmOrigin = lJhlbdm;
model.TddwdmOrigin = lTddwdm;
model.ZydhOrigin = lZydh;
model.Zyxh = Convert.ToInt16(GetOneStrValue(dr, "ZYXH", CosDataBase.SMALLINT_TYPE));
listAdd.Add(model);
//AddOneRecord(model);
//}
}
}
}
AddRecords(listAdd);
}
}
/// <summary>
/// 增加记录
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public void AddNewCj(DataTable dt, bool IsOldData)
{
List <T_ksxkcj> listAdd = new List <T_ksxkcj>();
foreach (DataRow dr in dt.Rows)
{
double dDdcj = Convert.ToDouble(GetOneStrValue(dr, "DDCJ", CosDataBase.FLOAT_TYPE));
if (dDdcj > 0)
{
bmkTableManage bmkMan = new bmkTableManage();
//long lbmkID = bmkMan.GetbmkID(dr["KSH"].ToString());
long lbmkID = GetBMKIDFromList(BMK_list, dr["KSH"].ToString());
if (lbmkID != 0)
{
long kmdmOrigin = GetOriginListID(KMDM_list, GetOneStrValue(dr, "KMDM", CosDataBase.LONGINT_TYPE));
long cjxdmOrigin = GetOriginListID(CJXDM_list, GetOneStrValue(dr, "CJXDM", CosDataBase.LONGINT_TYPE));
short cjlx = 1;
if (!IsOldData)
{
cjlx = Convert.ToInt16(GetOneStrValue(dr, "CJLX", CosDataBase.SMALLINT_TYPE));
}
//Expression<Func<T_ksxkcj, bool>> where = (c => c.RelationID == lbmkID && c.KmdmOrigin == kmdmOrigin && c.CjxdmOrigin == cjxdmOrigin && c.Cjlx == cjlx);
//List<T_ksxkcj> list = GetRecord(where);
//if ((list == null) || (list.Count == 0))
//{
T_ksxkcj ksxkcj_model = new T_ksxkcj();
ksxkcj_model.RelationID = lbmkID;
ksxkcj_model.Xkbmh = GetOneStrValue(dr, "XKBMH");
ksxkcj_model.Kmdm = GetMainListID(KMDM_list, GetOneStrValue(dr, "KMDM", CosDataBase.LONGINT_TYPE));
ksxkcj_model.KmdmOrigin = kmdmOrigin;
ksxkcj_model.Cjxdm = GetMainListID(CJXDM_list, GetOneStrValue(dr, "CJXDM", CosDataBase.LONGINT_TYPE));
ksxkcj_model.CjxdmOrigin = cjxdmOrigin;
ksxkcj_model.Cjlx = cjlx;
ksxkcj_model.Ksny = Convert.ToDateTime(GetOneStrValue(dr, "KSNY", CosDataBase.DATETIME_TYPE));
ksxkcj_model.Ddcj = dDdcj;
ksxkcj_model.Djff = Convert.ToDouble(GetOneStrValue(dr, "DJFF", CosDataBase.FLOAT_TYPE));
listAdd.Add(ksxkcj_model);
//}
}
}
}
AddRecords(listAdd);
}
public void InportOriginData(DataTable dt, int nYear, long lProvinceID)
{
bmkTableManage bmkMan = new bmkTableManage();
List <T_ksjl> listAdd = new List <T_ksjl>();
try
{
foreach (DataRow dr in dt.Rows)
{
//long lbmkID = bmkMan.GetbmkID(dr["KSH"].ToString());
long lbmkID = GetBMKIDFromList(BMK_list, dr["KSH"].ToString());
if (lbmkID != 0)
{
DateTime qsrq = Convert.ToDateTime(GetOneStrValue(dr, "QSRQ", CosDataBase.DATETIME_TYPE));
DateTime zjrq = Convert.ToDateTime(GetOneStrValue(dr, "ZJRQ", CosDataBase.DATETIME_TYPE));
//Expression<Func<T_ksjl, bool>> where = (c => c.RelationID == lbmkID && c.Qsrq == qsrq && c.Zjrq == zjrq);
//List<T_ksjl> list = GetRecord(where);
//if ((list == null) || (list.Count == 0))
//{
T_ksjl ksjl_model = new T_ksjl();
ksjl_model.RelationID = lbmkID;
ksjl_model.Qsrq = qsrq;
ksjl_model.Zjrq = zjrq;
ksjl_model.Jl = GetOneStrValue(dr, "JL");
ksjl_model.Rhzw = GetOneStrValue(dr, "RHZW");
ksjl_model.Zmr = GetOneStrValue(dr, "ZMR");
listAdd.Add(ksjl_model);
//AddOneRecord(ksjl_model);
//}
}
}
AddRecords(listAdd);
}
catch (Exception e)
{
}
}
public void InportOriginData(DataTable dt, int nYear, long lProvinceID)
{
bmkTableManage bmkMan = new bmkTableManage();
List <T_tjxx> listAdd = new List <T_tjxx>();
foreach (DataRow dr in dt.Rows)
{
//long lbmkID = bmkMan.GetbmkID(dr["KSH"].ToString());
long lbmkID = GetBMKIDFromList(BMK_list, dr["KSH"].ToString());
if (lbmkID != 0)
{
//Expression<Func<T_tjxx, bool>> where = (c => c.RelationID == lbmkID && c.DelFlag == false);
//List<T_tjxx> list = GetRecord(where);
//if ((list == null) || (list.Count == 0)) //一条报名库记录对应一条投档单记录
//{
T_tjxx tjxx_model = new T_tjxx();
tjxx_model.RelationID = lbmkID;
tjxx_model.Tjxh = GetOneStrValue(dr, "TJXH");
tjxx_model.Jwbsbz = GetNormalStr(NormalStr1, "JWBSBZ", dr);
tjxx_model.Jwbs = GetOneStrValue(dr, "JWBS");
tjxx_model.Yk_lysly = Convert.ToDouble(GetOneStrValue(dr, "YK_LYSLY", CosDataBase.FLOAT_TYPE));
tjxx_model.Yk_lyslz = Convert.ToDouble(GetOneStrValue(dr, "YK_LYSLZ", CosDataBase.FLOAT_TYPE));
tjxx_model.Yk_jzsly = Convert.ToDouble(GetOneStrValue(dr, "YK_JZSLY", CosDataBase.FLOAT_TYPE));
tjxx_model.Yk_jzslz = Convert.ToDouble(GetOneStrValue(dr, "YK_JZSLZ", CosDataBase.FLOAT_TYPE));
tjxx_model.Yk_jzdsy = Convert.ToDouble(GetOneStrValue(dr, "YK_JZDSY", CosDataBase.FLOAT_TYPE));
tjxx_model.Yk_jzdsz = Convert.ToDouble(GetOneStrValue(dr, "YK_JZDSZ", CosDataBase.FLOAT_TYPE));
tjxx_model.Yk_sjjc = GetNormalStr(NormalStr2, "YK_SJJC", dr);
tjxx_model.Yk_sjjct = GetNormalStr(NormalStr3, "YK_SJJCT", dr);
tjxx_model.Yk_sjds1 = GetNormalStr(NormalStr4, "YK_SJDS1", dr);
tjxx_model.Yk_sjds2 = GetNormalStr(NormalStr4, "YK_SJDS2", dr);
tjxx_model.Yk_sjds3 = GetNormalStr(NormalStr4, "YK_SJDS3", dr);
tjxx_model.Yk_sjds4 = GetNormalStr(NormalStr4, "YK_SJDS4", dr);
tjxx_model.Yk_sjds5 = GetNormalStr(NormalStr4, "YK_SJDS5", dr);
tjxx_model.Yk_ysyj = GetNormalStr(NormalStr5, "YK_YSYJ", dr);
tjxx_model.Yk_yb = GetOneStrValue(dr, "YK_YB");
tjxx_model.Nk_xyssy = Convert.ToDouble(GetOneStrValue(dr, "NK_XYSSY", CosDataBase.FLOAT_TYPE));
tjxx_model.Nk_xyszy = Convert.ToDouble(GetOneStrValue(dr, "NK_XYSZY", CosDataBase.FLOAT_TYPE));
tjxx_model.Nk_fyqk = GetNormalStr(NormalStr6, "NK_FYQK", dr);
tjxx_model.Nk_xzjxg = GetNormalStr(NormalStr2, "NK_XZJXG", dr);
tjxx_model.Nk_hxxt = GetNormalStr(NormalStr2, "NK_HXXT", dr);
tjxx_model.Nk_sjxt = GetNormalStr(NormalStr2, "NK_SJXT", dr);
tjxx_model.Nk_g = Convert.ToDouble(GetOneStrValue(dr, "NK_G", CosDataBase.FLOAT_TYPE));
tjxx_model.Nk_gxz = GetNormalStr(NormalStr2, "NK_GXZ", dr);
tjxx_model.Nk_p = Convert.ToDouble(GetOneStrValue(dr, "NK_P", CosDataBase.FLOAT_TYPE));
tjxx_model.Nk_pxz = GetNormalStr(NormalStr2, "NK_PXZ", dr);
tjxx_model.Nk_ysyj = GetNormalStr(NormalStr5, "NK_YSYJ", dr);
tjxx_model.Nk_qt = GetOneStrValue(dr, "NK_QT");
tjxx_model.Wk_sg = Convert.ToDouble(GetOneStrValue(dr, "WK_SG", CosDataBase.FLOAT_TYPE));
tjxx_model.Wk_tz = Convert.ToDouble(GetOneStrValue(dr, "WK_TZ", CosDataBase.FLOAT_TYPE));
tjxx_model.Wk_pf = GetNormalStr(NormalStr2, "WK_PF", dr);
tjxx_model.Wk_mb = GetNormalStr(NormalStr2, "WK_MB", dr);
tjxx_model.Wk_jb = GetNormalStr(NormalStr2, "WK_JB", dr);
tjxx_model.Wk_jz = GetNormalStr(NormalStr2, "WK_JZ", dr);
tjxx_model.Wk_sz = GetNormalStr(NormalStr2, "WK_SZ", dr);
tjxx_model.Wk_gj = GetNormalStr(NormalStr2, "WK_GJ", dr);
tjxx_model.Wk_ysyj = GetNormalStr(NormalStr5, "WK_YSYJ", dr);
tjxx_model.Wk_qt = GetOneStrValue(dr, "WK_QT");
tjxx_model.Eb_zetl = Convert.ToDouble(GetOneStrValue(dr, "EB_ZETL", CosDataBase.FLOAT_TYPE));
tjxx_model.Eb_yetl = Convert.ToDouble(GetOneStrValue(dr, "EB_YETL", CosDataBase.FLOAT_TYPE));
tjxx_model.Eb_xj = GetNormalStr(NormalStr7, "EB_XJ", dr);
tjxx_model.Eb_ysyj = GetNormalStr(NormalStr5, "EB_YSYJ", dr);
tjxx_model.Eb_ebyh = GetOneStrValue(dr, "EB_EBYH");
tjxx_model.Kq_ce = GetNormalStr(NormalStr2, "KQ_CE", dr);
tjxx_model.Kq_sfkc = GetNormalStr(NormalStr8, "KQ_SFKC", dr);
tjxx_model.Kq_yc = GetNormalStr(NormalStr2, "KQ_YC", dr);
tjxx_model.Kq_ysyj = GetNormalStr(NormalStr5, "KQ_YSYJ", dr);
tjxx_model.Xt = GetNormalStr(NormalStr2, "XT", dr);
tjxx_model.Xt_ysyj = GetNormalStr(NormalStr5, "XT_YSYJ", dr);
tjxx_model.Xt_qt = GetOneStrValue(dr, "XT_QT");
tjxx_model.Gg_zam = GetNormalStr(NormalStr2, "GG_ZAM", dr);
tjxx_model.Gg_ygky = GetNormalStr(NormalStr2, "GG_YGKY", dr);
tjxx_model.Gg_ysyj = GetNormalStr(NormalStr5, "GG_YSYJ", dr);
tjxx_model.Gg_qt = GetOneStrValue(dr, "GG_QT");
tjxx_model.Zysxdm1 = GetOneStrValue(dr, "ZYSXDM1");
tjxx_model.Zysxdm2 = GetOneStrValue(dr, "ZYSXDM2");
tjxx_model.Zysxdm3 = GetOneStrValue(dr, "ZYSXDM3");
tjxx_model.Zysxdm4 = GetOneStrValue(dr, "ZYSXDM4");
tjxx_model.Zysxdm5 = GetOneStrValue(dr, "ZYSXDM5");
tjxx_model.Zysxdm6 = GetOneStrValue(dr, "ZYSXDM6");
//tjxx_model.Tjjldm = NormalStr5[Convert.ToInt16(GetOneStrValue(dr, "TJJLDM", CosDataBase.INT_TYPE))];
tjxx_model.Remark = GetOneStrValue(dr, "BZ");
listAdd.Add(tjxx_model);
//AddOneRecord(tjxx_model);
//}
}
}
AddRecords(listAdd);
}
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();
}
public List <BMKTable> InportOriginData(DataTable dt, OleDbConnection con, string sNowPath, int nYear, long lProvinceID, long GxID)
{
bool IsOldData = VeiryOldData(dt); //检查是不是12库
bmkTableManage bmkMan = new bmkTableManage();
if (IsOldData)
{
dt.Columns["ZXDM"].ColumnName = "BYXXDM"; //和17表保持一致，改名
dt.Columns["ZXMC"].ColumnName = "BYXXMC";
dt.Columns["TDDW"].ColumnName = "TDDWDM";
dt.Columns["SFZH"].ColumnName = "ZJHM"; //身份证号->证件号码
dt.Columns["JTDZ"].ColumnName = "TXDZ"; //家庭地址->通讯地址
dt.Columns["YXDRCJ"].ColumnName = "YXDYCJ"; //院校导入成绩->院校定义成绩
dt.Columns["LQFS"].ColumnName = "LQLXDM"; //录取方式->录取类型代码
dt.Columns["BH"].ColumnName = "TDDBH"; //编号->投档单编号
bmkMan.InitAllFoundDataList(con, sNowPath, dt, nYear, lProvinceID);
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.XBDM_list = XBDM_list;
//bmkMan.BYXXDM_list = BYXXDM_list;
BMK_list = bmkMan.AddSomeNewStudents(dt, nYear, GxID, lProvinceID);
}
List <T_tdd> tddList = new List <T_tdd>();
foreach (DataRow dr in dt.Rows)
{
long lbmkID = GetBMKIDFromList(BMK_list, dr["KSH"].ToString());
if (lbmkID != 0)
{
//Expression<Func<T_tdd, bool>> where = (c => c.RelationID == lbmkID && c.DelFlag == false);
//long lID = ExistOneRecord(where);
//List<T_tdd> list = GetRecord(where);
//if ((list == null) || (list.Count == 0)) //一条报名库记录对应一条投档单记录
//if (lID == 0)
{
T_tdd tdd_model = new T_tdd();
tdd_model.RelationID = lbmkID;
tdd_model.Ljzyh = GetOneStrValue(dr, "LJZYH");
tdd_model.TddwOrigin = GetOriginListID(TDDW_list, GetOneStrValue(dr, "TDDWDM"));
tdd_model.PcdmOrigin = GetOriginListID(PCDM_list, GetOneStrValue(dr, "PCDM"));
tdd_model.KldmOrigin = GetOriginListID(KLDM_list, GetOneStrValue(dr, "KLDM"));
tdd_model.JhxzdmOrigin = GetOriginListID(JHXZDM_list, GetOneStrValue(dr, "JHXZDM"));
tdd_model.JhlbdmOrigin = GetOriginListID(JHLBDM_list, GetOneStrValue(dr, "JHLBDM"));
ListCompareTable oneCompare = GetCompareList(TDLXDM_list, GetOneStrValue(dr, "TDLXDM"));
if (oneCompare != null)
{
tdd_model.TdlxdmOrigin = oneCompare.lOriginID;
tdd_model.Tdlxdm = oneCompare.lNewID;
}
tdd_model.Tdsj = Convert.ToDateTime(GetOneStrValue(dr, "TDSJ", CosDataBase.DATETIME_TYPE));
tdd_model.Cj = Convert.ToDouble(GetOneStrValue(dr, "CJ", CosDataBase.FLOAT_TYPE));
tdd_model.Tzcj = Convert.ToDouble(GetOneStrValue(dr, "TZCJ", CosDataBase.FLOAT_TYPE));
tdd_model.Tdcj = Convert.ToDouble(GetOneStrValue(dr, "TDCJ", CosDataBase.FLOAT_TYPE));
tdd_model.Zgf = Convert.ToDouble(GetOneStrValue(dr, "ZGF", CosDataBase.FLOAT_TYPE));
tdd_model.Yxdycj = Convert.ToDouble(GetOneStrValue(dr, "YXDYCJ", CosDataBase.FLOAT_TYPE));
tdd_model.Zyytjzcj = Convert.ToDouble(GetOneStrValue(dr, "ZYYTJZCJ", CosDataBase.FLOAT_TYPE));
tdd_model.Zyytfjcj = Convert.ToDouble(GetOneStrValue(dr, "ZYYTFJCJ", CosDataBase.FLOAT_TYPE));
tdd_model.Ytzy = GetMainListID(ZYDH_list, GetOneStrValue(dr, "YTZY"));
tdd_model.Lqzy = GetMainListID(ZYDH_list, GetOneStrValue(dr, "LQZY"));
tdd_model.Lqsj = Convert.ToDateTime(GetOneStrValue(dr, "LQSJ", CosDataBase.DATE_TYPE));
oneCompare = GetCompareList(TDYYDM_list, GetOneStrValue(dr, "TDYYDM"));
if (oneCompare != null)
{
tdd_model.TdyydmOrigin = oneCompare.lOriginID;
tdd_model.Tdyydm = oneCompare.lNewID;
}
tdd_model.Zyhg = Convert.ToBoolean(GetOneStrValue(dr, "ZYHG", CosDataBase.BOOLEAN_TYPE));
tdd_model.Tjhg = Convert.ToBoolean(GetOneStrValue(dr, "TJHG", CosDataBase.BOOLEAN_TYPE));
tdd_model.Xkkmhg = Convert.ToBoolean(GetOneStrValue(dr, "XKKMHG", CosDataBase.BOOLEAN_TYPE));
tdd_model.Skkmhg = Convert.ToBoolean(GetOneStrValue(dr, "SKKMHG", CosDataBase.BOOLEAN_TYPE));
tdd_model.Lqxh = GetOneStrValue(dr, "LQXH");
tdd_model.Tddbh = GetOneStrValue(dr, "TDDBH");
tdd_model.Xzbh = GetOneStrValue(dr, "XZBH");
tdd_model.Tddzt = GetOneStrValue(dr, "TDDZT");
tdd_model.Sdbz = GetOneStrValue(dr, "SDBZ");
tdd_model.Remark = GetOneStrValue(dr, "BZ");
oneCompare = GetCompareList(ZYTZDM_list, GetOneStrValue(dr, "ZYTZDM"));
if (oneCompare != null)
{
tdd_model.ZytzOrigin = oneCompare.lOriginID;
tdd_model.Zytz = oneCompare.lNewID;
}
tdd_model.Zycj = Convert.ToDouble(GetOneStrValue(dr, "ZYCJ", CosDataBase.FLOAT_TYPE));
tdd_model.Zycjtfpw = Convert.ToInt16(GetOneStrValue(dr, "ZYCJTFPW", CosDataBase.INT_TYPE));
oneCompare = GetCompareList(ZYTJLXDM_list, GetOneStrValue(dr, "ZYTJLXDM"));
if (oneCompare != null)
{
tdd_model.ZytjlxdmOrigin = oneCompare.lOriginID;
tdd_model.Zytjlxdm = oneCompare.lNewID;
}
tdd_model.Kslsczbz = GetOneStrValue(dr, "KSLSCZBZ");
oneCompare = GetCompareList(LQFSDM_list, GetOneStrValue(dr, "LQLXDM"));
if (oneCompare != null)
{
tdd_model.LqfsOrigin = oneCompare.lOriginID;
tdd_model.Lqfs = oneCompare.lNewID;
}
tdd_model.Kszt = GetOneStrValue(dr, "KSZT");
tdd_model.Zyzytj = Convert.ToBoolean(GetOneStrValue(dr, "ZYZYTJ", CosDataBase.BOOLEAN_TYPE));
tdd_model.Dxtj = Convert.ToBoolean(GetOneStrValue(dr, "DXTJ", CosDataBase.BOOLEAN_TYPE));
tdd_model.Zytjfc = Convert.ToBoolean(GetOneStrValue(dr, "Zytjfc", CosDataBase.BOOLEAN_TYPE));
tdd_model.TjjldmOrigin = GetOriginListID(TJJLDM_list, GetOneStrValue(dr, "TJJLDM"));
tddList.Add(tdd_model);
}
}
}
AddRecords(tddList);
if (IsOldData)
{
//下面处理高考成绩(12库）
InportGkcj(dt, BMK_list, CJXDM_list);
//下面处理志愿信息（12库）
InportZyk(dt, BMK_list);
}
return(BMK_list);
}
