public IList <JSYD> GetJSYDByZJDDataSourceViewModel(ZJDDataSourceViewModel model) { ObservableCollection <ZJDXZDM> zjdXZDM = ZJDXZDMCustom.GetExcelToZJDXZDM(model.ZJDXZDMTablePath); ObservableCollection <JTCY> hzs = JTCYCustom.GetExcelToHZS(model.JTCYTablePath); //户主必须要先检查 zjdDao.ChecSFZ(hzs, model); ObservableCollection <JSYD> jsyds = JSYDCustom.GetExcelToJSYDS(model.JSYDTablePath); IWorkbook workbook = ExcelRead.ReadExcel(model.NFTablePath); ObservableCollection <NF> nfs = NFCustom.GetExcelToNFS(workbook.GetSheetAt(0)); ObservableCollection <Floor> floors = FloorCustom.GetExcelToFloors(workbook.GetSheetAt(1)); ObservableCollection <Zdinfo> zdinfos = ZdinfoCustom.GetMDBToZdinfos(model.ZdinfoMDBPath); Dictionary <string, JSYD> jsydDic = MyUtils.Utils.GetGroupDic("ZDNUM", jsyds); JSYDCustom.SetZdinfo(jsydDic, zdinfos); ObservableCollection <JSYD> gyrs = JSYDCustom.GetExcelToGYRS(model.JSYDTablePath); JSYDCustom.SetHZs(jsyds, gyrs, hzs); JSYDCustom.SetNF(jsydDic, nfs); JSYDCustom.SetFloor(jsydDic, floors); JSYDCustom.SetZJDXZDM(jsydDic, zjdXZDM); ObservableCollection <QZB> qzbs = QZBCustom.GetMDBToQZB(model.QZ_BSMDBPath); JSYDCustom.SetQZBs(jsyds, qzbs); ObservableCollection <JZXInfo> jzxs = JZXInfoCustom.GetMDBToJZX(model.QZ_BSMDBPath); JSYDCustom.SetJZXs(jsyds, jzxs); return(jsyds); }
/// <summary> /// 检查农房表、分层表 /// </summary> /// <param name="nfs"></param> /// <param name="floors"></param> /// <param name="cellIndex"></param> /// <returns></returns> private string CheckNF_Floor(IList <NF> nfs, IList <Floor> floors, int floorCellIndex) { NF nf = nfs[0]; Floor floor = floors[0]; StringBuilder sb = new StringBuilder(); //检查总层数 if (nf.ZCS != floor.ZCS) { CheckZJDWriteError(floor.Row, floorCellIndex, "农房表总层是:" + nf.ZCS); sb.Append("分层表总层数:" + floor.ZCS + "、农房表总层数:" + nf.ZCS); } //检查总面积 double floorJZMJ = FloorCustom.GetJZMJTotal(floors); if (nf.JZMJ != floorJZMJ) { CheckZJDWriteError(floor.Row, floorCellIndex, " 与农房表建筑总面积" + nf.JZMJ + "不一致:"); sb.Append("农房表总面积:" + nf.JZMJ + "、分层表建筑总面积:" + floorJZMJ); } if (sb.Length > 0) { sb.Insert(0, "农房表与分层表检查:"); return(sb.ToString()); } return(""); }