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("");
}
