public override dynamic GetSpecialModelFromCurrentID <T>(T ID) { Td_zydh obj = base.GetSpecialModelFromCurrentID(ID); if ((obj != null) && (obj.ID != 0)) { Td_zydh nowObj = GetOneRecordbyID <Td_zydh, T>(ID); obj.GxName = nowObj.Gx.Name; } return(obj); }
public override ActionResult WindowCommonShow(string PanelID, string ParentVariable, string ParentKey) { setParentVariable("UserControl", "WinZydhSimpleMore", "WinZydhSimpleMore_SelectKldmChange", null, "kldmTable"); SetHiddenValue(PanelID + "_cmbKldm_ParentVariable", ParentVar.DefaultVal); setParentVariable("UserControl", "WinZydhSimpleMore", "WinZydhSimpleMore_SelectZylbdmChange", null, "zylbdmTable"); SetHiddenValue(PanelID + "_cmbZylbdm_ParentVariable", ParentVar.DefaultVal); setParentVariable("UserControl", "WinZydhSimpleMore", "WinZydhSimpleMore_SelectXzdmChange", null, "xzdmTable"); SetHiddenValue(PanelID + "_cmbXzdm_ParentVariable", ParentVar.DefaultVal); GetParentVariable(ParentVariable); zydhTableDataListManage man = new zydhTableDataListManage(); man.InitSelection(ParentVar.transValue); Td_zydh model = man.GetSpecialModelFromCurrentID(man.sRowNowID); SetComboValue(PanelID + "_cmbKldm", model.Kldm.ToString(), true); SetComboValue(PanelID + "_cmbZylbdm", model.Zylbdm.ToString(), true); SetComboValue(PanelID + "_cmbXzdm", model.Xzdm.ToString(), true); var form = this.GetCmp <FormPanel>(PanelID + "_Form"); form.SetValues(model); return(this.Direct()); }
public List <ListCompareTable> InportOriginData(DataTable dt, int nNowYear, long lProvinceID, long lParentDepartmentID, long GxID) { List <ListCompareTable> listReturn = new List <ListCompareTable>(); if (dt != null) { List <Td_zydh_Origin> OriginModels = InportSomeRowsOriginTable <Td_zydh_Origin>(dt, nNowYear, lProvinceID); TableStatusManage statusManage = new TableStatusManage(); for (int i = 0; i < dt.Rows.Count; i++) { //先导入原始表 long lNowRelationID = Convert.ToInt64(OriginModels[i].RelationID); if (lNowRelationID != 0) //原始表中已经存在,直接取用 { ListCompareTable oneTable = new ListCompareTable(); oneTable.sOldID = dt.Rows[i]["ZYDH"].ToString(); oneTable.lNewID = OriginModels[i].RelationID; oneTable.lOriginID = OriginModels[i].ID; listReturn.Add(oneTable); } else { long lNewID = 0; Td_zydh obj = getOneMainRecord(lParentDepartmentID, OriginModels[i]); if (obj == null) //目前主表中不存在 { while (!statusManage.BeginUpdate <Td_zydh>()) { Random ra = new Random(); Thread.Sleep(ra.Next(100, 1000)); } obj = getOneMainRecord(lParentDepartmentID, OriginModels[i]); if (obj == null) //还是不存在 { Td_zydh model = new Td_zydh(); model.Name = GetOneStrValue(dt.Rows[i], "ZYMC"); model.Code = GetOneStrValue(dt.Rows[i], "ZYDH"); model.Remark = GetOneStrValue(dt.Rows[i], "BZ"); ListCompareTable oneCompare = GetCompareList(CCDM_list, GetOneStrValue(dt.Rows[i], "CCDM", CosDataBase.LONGINT_TYPE)); if (oneCompare != null) { model.CcdmOrigin = oneCompare.lOriginID; model.Ccdm = oneCompare.lNewID; } oneCompare = GetCompareList(KLDM_list, GetOneStrValue(dt.Rows[i], "KLDM", CosDataBase.LONGINT_TYPE)); if (oneCompare != null) { model.KldmOrigin = oneCompare.lOriginID; model.Kldm = oneCompare.lNewID; } string sXzdm = GetXzdm(dt.Rows[i]); oneCompare = GetCompareList(XZDM_list, sXzdm); if (oneCompare != null) { model.XzdmOrigin = oneCompare.lOriginID; model.Xzdm = oneCompare.lNewID; } oneCompare = GetCompareList(ZYLBDM_list, GetOneStrValue(dt.Rows[i], "ZYLBDM", CosDataBase.LONGINT_TYPE)); if (oneCompare != null) { model.ZylbdmOrigin = oneCompare.lOriginID; model.Zylbdm = oneCompare.lNewID; } model.Zkfx = GetOneStrValue(dt.Rows[i], "ZKFX"); model.Tjsxbz = GetOneStrValue(dt.Rows[i], "TJSXBZ"); model.Sfks = Convert.ToBoolean(GetOneStrValue(dt.Rows[i], "SFKZ", CosDataBase.BOOLEAN_TYPE)); model.Sfbz = Convert.ToInt32(GetOneStrValue(dt.Rows[i], "Sfbz", CosDataBase.INT_TYPE)); model.Bxdd = GetOneStrValue(dt.Rows[i], "BXDD"); model.Wyyz = GetOneStrValue(dt.Rows[i], "WYYZ"); model.ParentDepartmentID = lParentDepartmentID; model.GxID = GxID; model.JoinNames = model.Name; string[] EditColumns = { "Name", "Code", "Remark", "CcdmOrigin", "Ccdm", "KldmOrigin", "Kldm", "XzdmOrigin", "Xzdm", "ZylbdmOrigin", "Zylbdm", "Zkfx", "Tjsxbz", "Sfks","Sfbz","Bxdd", "Wyyz", "ParentDepartmentID", "GxID", "JoinNames" }; lNewID = SaveOneSimpleRecord(model, "zydhTable", EditColumns); statusManage.EndUpdate <Td_zydh>(); ListCompareTable oneTable = new ListCompareTable(); oneTable.sOldID = dt.Rows[i]["ZYDH"].ToString(); oneTable.lNewID = lNewID; oneTable.lOriginID = OriginModels[i].ID; listReturn.Add(oneTable); } else //目前主表中存在 { if (obj.DelFlag) { lNewID = obj.JoinID; } else { lNewID = obj.ID; } ListCompareTable oneTable = new ListCompareTable(); oneTable.sOldID = dt.Rows[i]["ZYDH"].ToString(); oneTable.lNewID = lNewID; oneTable.lOriginID = OriginModels[i].ID; listReturn.Add(oneTable); } } else //目前主表中存在 { if (obj.DelFlag) { lNewID = obj.JoinID; } else { lNewID = obj.ID; } ListCompareTable oneTable = new ListCompareTable(); oneTable.sOldID = dt.Rows[i]["ZYDH"].ToString(); oneTable.lNewID = lNewID; oneTable.lOriginID = OriginModels[i].ID; listReturn.Add(oneTable); } ////不管存在与否,都需修改原始表中相应的RelationID string[] EditColumn = { "RelationID" }; OriginModels[i].RelationID = lNewID; SaveOneRecord(OriginModels[i], EditColumn); } } } 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); }