private void DelBusiness() { try { switch (NavigatePath) { case ERealEstatePage.NaturalBuildingPage: NaturalBuilding naturalBuilding = Business.NaturalBuilding; NaturalBuildingDal naturalBuildingDal = new NaturalBuildingDal(); naturalBuildingDal.Del(naturalBuilding); break; case ERealEstatePage.LogicalBuildingPage: LogicalBuilding logicalBuilding = Business.LogicalBuilding; LogicalBuildingDal logicalBuildingDal = new LogicalBuildingDal(); logicalBuildingDal.Del(logicalBuilding); break; case ERealEstatePage.FloorPage: Floor floor = Business.Floor; FloorDal floorDal = new FloorDal(); floorDal.Del(floor); break; case ERealEstatePage.HouseholdPage: Household household = Business.Household; HouseholdDal householdDal = new HouseholdDal(); householdDal.Del(household); break; case ERealEstatePage.ObligeePage: Obligee obligee = Business.Obligee; ObligeeDal obligeeDal = new ObligeeDal(); obligeeDal.Del(obligee); break; case ERealEstatePage.MortgagePage: Mortgage mortgage = Business.Mortgage; MortgageDal mortgageDal = new MortgageDal(); mortgageDal.Del(mortgage); break; case ERealEstatePage.SequestrationPage: Sequestration sequestration = Business.Sequestration; SequestrationDal sequestrationDal = new SequestrationDal(); sequestrationDal.Del(sequestration); break; default: break; } BusinessNavCommand.Execute(NavigatePath); } catch (Exception ex) { ErrorDialogViewModel.getInstance().show(ex); return; } }
/// <summary> /// 删除项目 /// </summary> private void DelProject() { if (Project == null) { MessageBox.Show("请选择一个项目", "提示"); return; } try { if ("1".Equals(Project.Type)) // 楼盘表项目 { NaturalBuildingDal naturalBuildingDal = new NaturalBuildingDal(); LogicalBuildingDal logicalBuildingDal = new LogicalBuildingDal(); FloorDal floorDal = new FloorDal(); HouseholdDal householdDal = new HouseholdDal(); ObligeeDal obligeeDal = new ObligeeDal(); MortgageDal mortgageDal = new MortgageDal(); SequestrationDal sequestrationDal = new SequestrationDal(); naturalBuildingDal.DelBy(t => t.ProjectID == Project.ID); logicalBuildingDal.DelBy(t => t.ProjectID == Project.ID); floorDal.DelBy(t => t.ProjectID == Project.ID); householdDal.DelBy(t => t.ProjectID == Project.ID); obligeeDal.DelBy(t => t.ProjectID == Project.ID); mortgageDal.DelBy(t => t.ProjectID == Project.ID); sequestrationDal.DelBy(t => t.ProjectID == Project.ID); } else if ("2".Equals(Project.Type)) // 登记业务项目 { TransferDal transferDal = new TransferDal(); ApplicantDal applicantDal = new ApplicantDal(); transferDal.DelBy(t => t.ProjectID == Project.ID); applicantDal.DelBy(t => t.ProjectID == Project.ID); FileHelper.DelDir(Project); } projectDal.Del(Project); } catch (Exception ex) { ErrorDialogViewModel.getInstance().show(ex); return; } RefreshProjectList(); }
public ICollection <Sequestration> InitialSequestrations(Project project) { SequestrationDal sequestrationDal = new SequestrationDal(); return(sequestrationDal.GetListBy((t) => t.ProjectID == project.ID)); }
public void Ongo() { try { TaskInfoDialog = TaskInfoDialogViewModel.getInstance(); TaskMessage taskMessage = new TaskMessage(); taskMessage.Title = "导出项目:" + Project.ProjectName; taskMessage.Progress = 0.0; TaskInfoDialog.Messages.Insert(0, taskMessage); NaturalBuildingDal naturalBuildingDal = new NaturalBuildingDal(); LogicalBuildingDal logicalBuildingDal = new LogicalBuildingDal(); FloorDal floorDal = new FloorDal(); HouseholdDal householdDal = new HouseholdDal(); ObligeeDal obligeeDal = new ObligeeDal(); MortgageDal mortgageDal = new MortgageDal(); SequestrationDal sequestrationDal = new SequestrationDal(); Task task = new Task(() => { try { book.Project = Project; book.TaskMessage = taskMessage; book.NaturalBuildings = naturalBuildingDal.GetListBy(t => t.ProjectID == Project.ID); book.LogicalBuildings = logicalBuildingDal.GetListBy(t => t.ProjectID == Project.ID); book.Floors = floorDal.GetListBy(t => t.ProjectID == Project.ID); book.Households = householdDal.GetListBy(t => t.ProjectID == Project.ID); book.Obligees = obligeeDal.GetListBy(t => t.ProjectID == Project.ID); if ("2".Equals(Project.OwnershipType)) { book.Mortgages = mortgageDal.GetListBy(t => t.ProjectID == Project.ID); book.Sequestrations = sequestrationDal.GetListBy(t => t.ProjectID == Project.ID); } book.Open(TemplateFileName); book.Write(); //book.SaveAsExcel(SaveFileName); } catch (Exception ex) { ErrorMsg.Add(ex.Message); } ErrorMsg.AddRange(book.ErrorMsg); }); task.Start(); task.ContinueWith(t => { ThreadPool.QueueUserWorkItem(delegate { SynchronizationContext.SetSynchronizationContext(new System.Windows.Threading.DispatcherSynchronizationContext(System.Windows.Application.Current.Dispatcher)); SynchronizationContext.Current.Post(pl => { foreach (var error in ErrorMsg) { taskMessage.DetailMessages.Add(error); } if (ErrorMsg != null && ErrorMsg.Count > 0) { taskMessage.DetailMessages.Add("导出失败"); } else { string bufferPath = System.AppDomain.CurrentDomain.BaseDirectory + @"Buffer\" + Path.GetFileName(SaveFileName); try { book.SaveAsExcel(bufferPath); //// 压缩成报盘 //ZipHelper zipHelper = new ZipHelper(); //zipHelper.ZipFile(SaveFileName.Replace(".bpf", ".xls"), SaveFileName, 5, 500); //// 删除excel //File.Delete(SaveFileName.Replace(".bpf", ".xls")); if (Path.GetExtension(bufferPath) == ".xls") { File.Copy(bufferPath, SaveFileName, true); File.Delete(bufferPath); } else if (Path.GetExtension(bufferPath) == ".bpf") { File.Copy(bufferPath.Replace(".xls", ".bpf"), SaveFileName.Replace(".xls", ".bpf"), true); File.Delete(bufferPath.Replace(".xls", ".bpf")); } taskMessage.Progress = 100.00; taskMessage.DetailMessages.Add("导出成功"); } catch (Exception ex) { taskMessage.DetailMessages.Add(ex.Message + ex.StackTrace); } } }, null); }); }); } catch (Exception ex) { throw ex; } }