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="sender"></param> /// <param name="e"></param> private void DangAnDaiRefeshMDB_Click(object sender, RoutedEventArgs e) { string selectDir = FileUtils.SelectDir(); int a = 0; if (!MyUtils.Utils.IsStrNull(selectDir)) { MyAction myAction = new MyAction(new Action(() => { DirClass dirClass = new DirClass(selectDir); foreach (string dir in dirClass.Dirs) { DirClass dangAnDaiDir = new DirClass(dir); string path = dangAnDaiDir.FindFileAllSelectOne("权籍", FileSelectRelation.Contains); if (MyUtils.Utils.CheckFileExists(path)) { string[] array = System.IO.Path.GetFileName(dir).Split('('); string zdnum = array[0]; IList <QZB> qzbs = QZBCustom.DocToDaAnDaiQZB(path, zdnum); if (MyUtils.Utils.CheckListExists(qzbs)) { //删除以前的签章表 MDBUtils.DeleteBySql(model.QZ_BSMDBPath, "Delete From " + QZBCustom.QZBTableName + " Where BZDH ='" + zdnum + "'"); //保存现在的 MDBUtils.WriteData(model.QZ_BSMDBPath, QZBCustom.QZBTableName, qzbs); a++; } } } }) , "更新签章表"); CommHelper.FastTask(myAction); } }