WPF结婚登记系统数据回填

就好比如我现在做的结婚登记系统里面的离婚登记

我们有把保存好的数据回填在其他页面我们应该怎么做，那么我们就要获取数据里面的离婚ID，我们有在外面写一个自定义空的值：int DivorceRegistration。然后在保存的时候给自定义空的值赋值：DivorceRegistration=myCancellationMarriageRegistration.DivorceRegistrationID;，获取到ID的值我们跳转页面的时候给它带上

DivorceRegistrationShenCha myReviewProcessing = new DivorceRegistrationShenCha(DivorceRegistration);

myReviewProcessing.ShowDialog();//弹出窗口

然后在跳转页面的外面在就一个自定义空的值：int bb;然后在这里给它赋值。

然后查询全部数据再给它进行过滤。利用Where进行过滤。

查询全部数据代码如下

private void Window_Loadeds(object sender, RoutedEventArgs e)

        {

            var listAchievement = (from dbDivorceRegistration in myMode.PW_DivorceRegistration

                                   join dbRegister in myMode.PW_Register on dbDivorceRegistration.RegisterID equals dbRegister.RegisterID

                                   join dbDivorceReview in myMode.PW_DivorceReview on dbDivorceRegistration.DivorceReviewID equals dbDivorceReview.DivorceReviewID

                                   join dbReasonsDivorce in myMode.BS_ReasonsDivorce on dbDivorceRegistration.ReasonsDivorceID equals dbReasonsDivorce.ReasonsDivorceID

                                   join dbPerson in myMode.PW_Person on dbRegister.PersonID equals dbPerson.PersonID

                                   join dbManPerson in myMode.PW__ManPerson on dbPerson.ManPersonID equals dbManPerson.ManPersonID

                                   join dbFemalePerson in myMode.PW__FemalePerson on dbPerson.FemalePersonID equals dbFemalePerson.FemalePersonID

                                   join dbNationality in myMode.BS_Nationality on dbManPerson.NationalityID equals dbNationality.NationalityID

                                   join dbNational in myMode.BS_National on dbManPerson.NationalID equals dbNational.NationalID

                                   join dbOccupational in myMode.BS_Occupational on dbManPerson.OccupationalID equals dbOccupational.OccupationalID

                                   join dbEducation in myMode.BS_Education on dbManPerson.EducationID equals dbEducation.EducationID

                                   join dbNationalitys in myMode.BS_Nationality on dbFemalePerson.NationalityID equals dbNationalitys.NationalityID

                                   join dbNationals in myMode.BS_National on dbFemalePerson.NationalID equals dbNationals.NationalID

                                   join dbOccupationals in myMode.BS_Occupational on dbFemalePerson.OccupationalID equals dbOccupationals.OccupationalID

                                   join dbEducations in myMode.BS_Education on dbFemalePerson.EducationID equals dbEducations.EducationID

                                   where dbRegister.RegisterID == aa || dbDivorceRegistration.DivorceRegistrationID ==bb

                                   select new Entitys

                                   {

                                       DivorceRegistrationID =dbDivorceRegistration.DivorceRegistrationID,

                                       DateRegistration = dbDivorceRegistration.DateRegistration,

                                       DivorceCardSize = dbDivorceRegistration.DivorceCardSize,

                                       DivorceReviewID = dbDivorceRegistration.DivorceReviewID,

                                       ReasonsDivorceID= dbDivorceRegistration.ReasonsDivorceID,

                                       ReasonsDivorceMC=dbReasonsDivorce.ReasonsDivorceMC,

                                       ReviewComments = dbDivorceReview.ReviewComments,

                                       BoyPrintedNumber = dbDivorceReview.BoyPrintedNumber,

                                       GirlPrintedNumber = dbDivorceReview.GirlPrintedNumber,

                                       Note = dbDivorceReview.Note,

                                       RegisterID = dbRegister.RegisterID,

                                       PersonID = dbRegister.PersonID,

                                       ManPersonID = dbPerson.ManPersonID,

                                       FemalePersonID = dbPerson.FemalePersonID,

                                       ManPersonName = dbManPerson.ManPersonName,

                                       ManCertificateNumber = dbManPerson.ManCertificateNumber,

                                       ManDateBirth = dbManPerson.ManDateBirth.ToString(),

                                       ManDocumentMaterial = dbManPerson.ManDocumentMaterial,

                                       NationalityID = dbManPerson.NationalityID,

                                       NationalID = dbManPerson.NationalID,

                                       OccupationalID = dbManPerson.OccupationalID,

                                       EducationID = dbManPerson.EducationID,

                                       NationalityMC = dbNationality.NationalityMC,

                                       NationalMC = dbNational.NationalMC,

                                       OccupationalMC = dbOccupational.OccupationalMC,

                                       EducationMC = dbEducation.EducationMC,

                                       FemalePersonName = dbFemalePerson.FemalePersonName,

                                       FemaleDateBirth = dbFemalePerson.FemaleDateBirth.ToString(),

                                       FemaleCertificateNumber = dbFemalePerson.FemaleCertificateNumber,

                                       FemaleDocumentMaterial = dbFemalePerson.FemaleDocumentMaterial,

                                       NationalitysID = dbFemalePerson.NationalityID,

                                       NationalsID = dbFemalePerson.NationalID,

                                       OccupationalsID = dbFemalePerson.OccupationalID,

                                       EducationsID = dbFemalePerson.EducationID,

                                       NationalitysMC = dbNationalitys.NationalityMC,

                                       NationalsMC = dbNationals.NationalMC,

                                       OccupationalsMC = dbOccupationals.OccupationalMC,

                                       EducationsMC = dbEducations.EducationMC,

                                   }).FirstOrDefault();

            //数据回填

            MaletxtName.Text = listAchievement.ManPersonName;

            MaletxtBirth.Text = listAchievement.ManDateBirth;

            MaletxtNumber.Text = listAchievement.ManCertificateNumber;

            MalecboNationality.Text = listAchievement.NationalityMC;

            MaletxtNational.Text = listAchievement.NationalMC;

            MaletxtProfessional.Text = listAchievement.OccupationalMC;

            MaletxtEducation.Text = listAchievement.EducationMC;

            MaletxtStatus.Text = listAchievement.ReasonsDivorceMC;

            MaletxtMaterials.Text = listAchievement.ManDocumentMaterial;

            MaletxtNames.Text = listAchievement.ReviewComments;

            txt_Time.Text = listAchievement.DateRegistration;

            ManMarriageLicense.Text = listAchievement.BoyPrintedNumber;

 

            FemaletxtName.Text = listAchievement.FemalePersonName;

            FemaletxtBirth.Text = listAchievement.FemaleDateBirth;

            FemaletxtNumber.Text = listAchievement.FemaleCertificateNumber;

            FemalecboNationality.Text = listAchievement.NationalitysMC;

 

            FemaletxtNational.Text = listAchievement.NationalsMC;

            FemaletxtProfessional.Text = listAchievement.OccupationalsMC;

            FemaletxtEducation.Text = listAchievement.EducationsMC;

            FemaleMarriageLicenses.Text = listAchievement.GirlPrintedNumber;

            FemaletxtAddress.Text = listAchievement.FemaleDocumentMaterial;

 

            JieHunZhengZiHao.Text = listAchievement.DivorceCardSize;

        }

结果如下：