/// <summary>
/// 初始化投档单基础信息
/// </summary>
/// <param name="PanelID"></param>
/// <param name="ID"></param>
private void InitTddData(string PanelID, long ID)
{
setParentVariable("UserControl", "WinStudentMore", "WinStudentMore_SelectTdlxdmChange", null, "tdlxdmTable");
SetHiddenValue(PanelID + "_cmbTdlxdm_ParentVariable", ParentVar.DefaultVal);
setParentVariable("UserControl", "WinStudentMore", "WinStudentMore_SelectZytzdmChange", null, "zytzdmTable");
SetHiddenValue(PanelID + "_cmbZytzdm_ParentVariable", ParentVar.DefaultVal);
setParentVariable("UserControl", "WinStudentMore", "WinStudentMore_SelectLqfsdmChange", null, "lqfsdmTable");
SetHiddenValue(PanelID + "_cmbLqfsdm_ParentVariable", ParentVar.DefaultVal);
setParentVariable("UserControl", "WinStudentMore", "WinStudentMore_SelectTdyydmChange", null, "tdyydmTable");
SetHiddenValue(PanelID + "_cmbTdyydm_ParentVariable", ParentVar.DefaultVal);
tddTableManage tddMan = new tddTableManage();
T_tdd tddModel = tddMan.GetOneRecordbyRelationID(ID);
var form2 = this.GetCmp <FormPanel>(PanelID + "_Form2");
form2.SetValues(tddModel);
if (tddModel.Tdlxdm == 0)
{
SetComboValue(PanelID + "_cmbTdlxdm", "0", true);
}
else
{
SetComboValue(PanelID + "_cmbTdlxdm", tddModel.Tdlxdm.ToString(), true);
}
if (tddModel.Zytz == 0)
{
SetComboValue(PanelID + "_cmbZytzdm", "0", true);
}
else
{
SetComboValue(PanelID + "_cmbZytzdm", tddModel.Zytz.ToString(), true);
}
if (tddModel.Lqfs == 0)
{
SetComboValue(PanelID + "_cmbLqfsdm", "0", true);
}
else
{
SetComboValue(PanelID + "_cmbLqfsdm", tddModel.Lqfs.ToString(), true);
}
if (tddModel.Tdyydm == 0)
{
SetComboValue(PanelID + "_cmbTdyydm", "0", true);
}
else
{
SetComboValue(PanelID + "_cmbTdyydm", tddModel.Tdyydm.ToString(), true);
}
}
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);
}
