public List <BMKTable> AddSomeNewStudents(DataTable dt, int nYear, long GxID, long lProvinceID) { List <BMKTable> listReturn = new List <BMKTable>(); List <T_bmk_Origin> listOrigin = new List <T_bmk_Origin>(); List <T_bmk> list = new List <T_bmk>(); foreach (DataRow dr in dt.Rows) { long lNewID = GetStudentID(dr["KSH"].ToString()); if (lNewID == 0) { BMKTable oneReturn = new BMKTable(); oneReturn.KSH = dr["KSH"].ToString(); if (oneReturn.KSH.Length > 4) { oneReturn.smallKSH = dr["KSH"].ToString().Substring(4); } listReturn.Add(oneReturn); T_bmk_Origin or = CreateNewModel(dr, nYear, GxID, lProvinceID); listOrigin.Add(or); list.Add(CopyOneBmk(or)); } else //如果存在的话就不要再加了。再加会影响其他的 { //BMKTable oneReturn = new BMKTable(); //oneReturn.KSH = dr["KSH"].ToString(); //if (oneReturn.KSH.Length > 4) // oneReturn.smallKSH = dr["KSH"].ToString().Substring(4); //oneReturn.ID = lNewID; //listReturn.Add(oneReturn); } } List <long> allOriginIDs = AddRecords(listOrigin); if ((allOriginIDs != null) && (allOriginIDs.Count > 0)) { for (int i = 0; i < list.Count; i++) { list[i].RelationID = allOriginIDs[i]; } } List <long> allIDs = AddRecords(list); if ((allIDs != null) && (allIDs.Count > 0)) { int j = 0; for (int i = 0; i < listReturn.Count; i++) { if (listReturn[i].ID == 0) { listReturn[i].ID = allIDs[j]; j++; } } } return(listReturn); }
/// <summary> /// 往报名库中增加一条记录 /// </summary> /// <param name="dr"></param> /// <returns></returns> public long AddNewStudent(DataRow dr, int nYear, long GxID, long lProvinceID) { long lNewID = 0, lOriginNewID = 0; if (!ExistStudent(dr["KSH"].ToString())) { T_bmk_Origin or = CreateNewModel(dr, nYear, GxID, lProvinceID); lOriginNewID = AddOneRecord(or); T_bmk bmk = CopyOneBmk(or); bmk.RelationID = lOriginNewID; lNewID = AddOneRecord(bmk); } return(lNewID); }
private string VerifyCore(T_bmk mo, out List <string> EditColumns) { string sVerifyResult = mo.VerifyResult; T_bmk_Origin oldMo = GetOneRecordbyID <T_bmk_Origin, long>(mo.RelationID); sVerifyResult = mo.VerifyResult; EditColumns = new List <string>(); sVerifyResult += VerifyOneStrResult("考生号", mo.Ksh, oldMo.Ksh, "Ksh", EditColumns); sVerifyResult += VerifyOneStrResult("准考证号", mo.Zkzh, oldMo.Zkzh, "Zkzh", EditColumns); sVerifyResult += VerifyOneSelResult <Td_xbdm>("性别", mo.Xbdm, oldMo.Xbdm, "Xbdm", EditColumns); sVerifyResult += VerifyOneDateResult("出生日期", mo.Csrq, oldMo.Csrq, "Csrq", EditColumns); sVerifyResult += VerifyOneSelResult <Td_xbdm>("政治面貌", mo.Zzmmdm, oldMo.Zzmmdm, "Zzmmdm", EditColumns); sVerifyResult += VerifyOneSelResult <Td_mzdm>("民族", mo.Mzdm, oldMo.Mzdm, "Mzdm", EditColumns); sVerifyResult += VerifyOneStrResult("会考考号", mo.Hkkh, oldMo.Hkkh, "Hkkh", EditColumns); sVerifyResult += VerifyOneStrResult("政审意见", mo.Zsyj, oldMo.Zsyj, "Zsyj", EditColumns); sVerifyResult += VerifyOneSelResult <Td_kslbdm>("考生类别", mo.Kslbdm, oldMo.Kslbdm, "Kslbdm", EditColumns); sVerifyResult += VerifyOneSelResult <Td_kslxdm>("考试类型", mo.Kslxdm, oldMo.Kslxdm, "Kslxdm", EditColumns); sVerifyResult += VerifyOneSelResult <Td_bylbdm>("毕业类别", mo.Bylbdm, oldMo.Bylbdm, "Bylbdm", EditColumns); sVerifyResult += VerifyOneSelResult <Td_wyyzdm>("外语语种", mo.Wyyzdm, oldMo.Wyyzdm, "Wyyzdm", EditColumns); sVerifyResult += VerifyOneSelResult <Td_dqdm>("地区", mo.Dqdm, oldMo.Dqdm, "Dqdm", EditColumns); sVerifyResult += VerifyOneSelResult <Td_zjlxdm>("证件类型", mo.Zjlxdm, oldMo.Zjlxdm, "Zjlxdm", EditColumns); sVerifyResult += VerifyOneStrResult("证件号码", mo.Zjhm, oldMo.Zjhm, "Zjhm", EditColumns); sVerifyResult += VerifyOneStrResult("学籍号", mo.Xjh, oldMo.Xjh, "Xjh", EditColumns); sVerifyResult += VerifyOneStrResult("通讯地址", mo.Txdz, oldMo.Txdz, "Txdz", EditColumns); sVerifyResult += VerifyOneStrResult("邮政编码", mo.Yzbm, oldMo.Yzbm, "Yzbm", EditColumns); sVerifyResult += VerifyOneStrResult("联系手机", mo.Lxsj, oldMo.Lxsj, "Lxsj", EditColumns); sVerifyResult += VerifyOneStrResult("联系电话", mo.Lxdh, oldMo.Lxdh, "Lxdh", EditColumns); sVerifyResult += VerifyOneStrResult("收件人", mo.Sjr, oldMo.Sjr, "Sjr", EditColumns); sVerifyResult += VerifyOneStrResult("考生特长", mo.Kstc, oldMo.Kstc, "Kstc", EditColumns); sVerifyResult += VerifyOneStrResult("考生奖惩", mo.Ksjlhcf, oldMo.Ksjlhcf, "Ksjlhcf", EditColumns); sVerifyResult += VerifyOneStrResult("思品意见", mo.Sxpdkhyj, oldMo.Sxpdkhyj, "Sxpdkhyj", EditColumns); sVerifyResult += VerifyOneSelResult <Td_hjlbdm>("户籍类别", mo.Hjlbdm, oldMo.Hjlbdm, "Hjlbdm", EditColumns); sVerifyResult += VerifyOneSelResult <Td_czlbdm>("残障类别", mo.Czlbdm, oldMo.Czlbdm, "Czlbdm", EditColumns); return(sVerifyResult); }
private T_bmk CopyOneBmk(T_bmk_Origin or) { T_bmk bmk = new T_bmk(); Type type = typeof(T_bmk_Origin); MemberInfo[] mifos = type.GetMembers(BindingFlags.Instance | BindingFlags.Public); foreach (MemberInfo m in mifos) { if ((m.MemberType == MemberTypes.Property) && !(m.ToString().Contains("List`1")) && !(m.ToString().Contains("Models"))) { var ob = or.GetType().GetProperty(m.Name); if (ob != null) { bmk.GetType().GetProperty(m.Name).SetValue(bmk, ob.GetValue(or, null)); } else { bmk.GetType().GetProperty(m.Name).SetValue(bmk, null); } } } return(bmk); }
private T_bmk_Origin CreateNewModel(DataRow dr, int nYear, long GxID, long lProvinceID) { T_bmk_Origin bmk_model = new T_bmk_Origin(); bmk_model.Ksh = GetOneStrValue(dr, "KSH"); bmk_model.Zkzh = GetOneStrValue(dr, "ZKZH"); bmk_model.Xm = GetOneStrValue(dr, "XM"); //bmk_model.Xb = GetNowXB(GetOneStrValue(dr, "XBDM")); bmk_model.Csrq = Convert.ToDateTime(GetOneStrValue(dr, "CSNY", CosDataBase.DATE_TYPE)); bmk_model.YearCode = nYear; bmk_model.GxID = GxID; bmk_model.ProvinceID = lProvinceID; ListCompareTable oneCompare = GetCompareList(ZZMMDM_list, GetOneStrValue(dr, "ZZMMDM")); if (oneCompare != null) { bmk_model.ZzmmdmOrigin = oneCompare.lOriginID; bmk_model.Zzmmdm = oneCompare.lNewID; } oneCompare = GetCompareList(MZDM_list, GetOneStrValue(dr, "MZDM")); if (oneCompare != null) { bmk_model.MzdmOrigin = oneCompare.lOriginID; bmk_model.Mzdm = oneCompare.lNewID; } oneCompare = GetCompareList(XBDM_list, GetOneStrValue(dr, "XBDM")); if (oneCompare != null) { bmk_model.XbdmOrigin = oneCompare.lOriginID; bmk_model.Xbdm = oneCompare.lNewID; } bmk_model.Hkkh = GetOneStrValue(dr, "HKKH"); bmk_model.Hkdj = GetOneStrValue(dr, "HKDJ"); oneCompare = GetCompareList(XTDWDM_list, GetOneStrValue(dr, "XTDW")); if (oneCompare != null) { bmk_model.XtdwdmOrigin = oneCompare.lOriginID; bmk_model.Xtdwdm = oneCompare.lNewID; } //bmk_model.Sfzh = GetOneStrValue(dr, "SFZH"); //bmk_model.Jtdz = GetOneStrValue(dr, "JTDZ"); bmk_model.Zsyj = GetOneStrValue(dr, "ZSYJ"); //bmk_model.Kldm = GetMainListID(KLDM_list, GetOneStrValue(dr, "KLDM")); bmk_model.KldmOrigin = GetOriginListID(KLDM_list, GetOneStrValue(dr, "KLDM")); oneCompare = GetCompareList(KSLBDM_list, GetOneStrValue(dr, "KSLBDM")); if (oneCompare != null) { bmk_model.KslbdmOrigin = oneCompare.lOriginID; bmk_model.Kslbdm = oneCompare.lNewID; } oneCompare = GetCompareList(KSLXDM_list, GetOneStrValue(dr, "KSLXDM")); if (oneCompare != null) { bmk_model.KslxdmOrigin = oneCompare.lOriginID; bmk_model.Kslxdm = oneCompare.lNewID; } oneCompare = GetCompareList(BYLBDM_list, GetOneStrValue(dr, "BYLBDM")); if (oneCompare != null) { bmk_model.BylbdmOrigin = oneCompare.lOriginID; bmk_model.Bylbdm = oneCompare.lNewID; } oneCompare = GetCompareList(BYXXDM_list, GetOneStrValue(dr, "BYXXDM")); if (oneCompare != null) { bmk_model.ByxxdmOrigin = oneCompare.lOriginID; bmk_model.Byxxdm = oneCompare.lNewID; } oneCompare = GetCompareList(WYYZDM_list, GetOneStrValue(dr, "WYYZDM")); if (oneCompare != null) { bmk_model.WyyzdmOrigin = oneCompare.lOriginID; bmk_model.Wyyzdm = oneCompare.lNewID; } bmk_model.Kstz = GetKstz(GetOneStrValue(dr, "KSTZ"), false); bmk_model.KstzOrigin = GetKstz(GetOneStrValue(dr, "KSTZ"), true); oneCompare = GetCompareList(DQDM_list, GetOneStrValue(dr, "DQDM")); if (oneCompare != null) { bmk_model.DqdmOrigin = oneCompare.lOriginID; bmk_model.Dqdm = oneCompare.lNewID; } oneCompare = GetCompareList(ZJLXDM_list, GetOneStrValue(dr, "ZJLXDM")); if (oneCompare != null) { bmk_model.ZjlxdmOrigin = oneCompare.lOriginID; bmk_model.Zjlxdm = oneCompare.lNewID; } bmk_model.Zjhm = GetOneStrValue(dr, "ZJHM"); bmk_model.Xjh = GetOneStrValue(dr, "XJH"); bmk_model.Wyks = GetOneStrValue(dr, "WYKS"); bmk_model.Wytl = GetOneStrValue(dr, "WYTl"); bmk_model.Txdz = GetOneStrValue(dr, "TXDZ"); bmk_model.Yzbm = GetOneStrValue(dr, "YZBM"); bmk_model.Lxsj = GetOneStrValue(dr, "LXSJ"); bmk_model.Lxdh = GetOneStrValue(dr, "LXDH"); bmk_model.Sjr = GetOneStrValue(dr, "SJR"); bmk_model.Kstc = GetOneStrValue(dr, "KSTC"); bmk_model.Ksjlhcf = GetOneStrValue(dr, "KSJLHCF"); bmk_model.Sxpdkhyj = GetOneStrValue(dr, "SXPDKHYJ"); bmk_model.Kszg = GetKszg(GetOneStrValue(dr, "KSZG"), false); bmk_model.KszgOrigin = GetKszg(GetOneStrValue(dr, "KSZG"), true); oneCompare = GetCompareList(HJLBDM_list, GetOneStrValue(dr, "HJLBDM")); if (oneCompare != null) { bmk_model.HjlbdmOrigin = oneCompare.lOriginID; bmk_model.Hjlbdm = oneCompare.lNewID; } oneCompare = GetCompareList(CZLBDM_list, GetOneStrValue(dr, "CZLBDM")); if (oneCompare != null) { bmk_model.CzlbdmOrigin = oneCompare.lOriginID; bmk_model.Czlbdm = oneCompare.lNewID; } //bmk_model.Tag = GetOneStrValue(dr, "TAG"); bmk_model.Xkkm = GetKmxx(GetOneStrValue(dr, "XKKM"), false); bmk_model.XkkmOrigin = GetKmxx(GetOneStrValue(dr, "XKKM"), true); bmk_model.Skkm = GetKmxx(GetOneStrValue(dr, "SKKM"), false); bmk_model.SkkmOrigin = GetKmxx(GetOneStrValue(dr, "SKKM"), true); return(bmk_model); }