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