WPF_数据回填

 下面给大家写一个回填数据的方法，回填时每一个软件都有的操作，具体的回填方法如下：

首先查询出要回填的数据，还有查询出表格信息，查询代码如下：

private void SelectAccount() {

            dgJiessaun.ItemsSource = (from dbAccount in myModel.Account

                                      join dbPurchase in myModel.Purchase on dbAccount.PurchaseID equals dbPurchase.PurchaseID

                                      join dbPay in myModel.Pay on dbAccount.PayID equals dbPay.PayID

                                      join dbCommodity in myModel.Commodity on dbPurchase.CommodityID equals dbCommodity.CommodityID

                                      join dbSolicitor in myModel.Solicitor on dbAccount.SolicitorID equals dbSolicitor.SolicitorID

                                      join dbMonograph in myModel.Monograph on dbAccount.MonographID equals dbMonograph.MonographID

                                      join dbUnit in myModel.Unit on dbCommodity.UnitID equals dbUnit.UnitID

                                      select new AccountEntity {

                                          AccountID = dbAccount.AccountID,

                                          PurchaseID = dbAccount.PurchaseID,

                                          PayID = dbAccount.PayID,

                                          CommodityID = dbPurchase.CommodityID,

                                          SolicitorID = dbAccount.SolicitorID,

                                          MonographID = dbAccount.MonographID,

                                          Time = dbAccount.Time,

                                          Remark = dbAccount.Remark,

                                          AccountCode = dbAccount.AccountCode,

                                          Money = dbAccount.Money,

                                          MonographName = dbMonograph.MonographName,

                                          SolicitorName = dbSolicitor.SolicitorName,

                                          PayName = dbPay.PayName,

                                          UnitName = dbUnit.UnitName,

                                          BarCode = dbCommodity.BarCode,

                                          StoreCode = dbCommodity.StoreCode,

                                          ChargePrice = dbCommodity.ChargePrice,

                                          CommodityName = dbCommodity.CommodityName,

                                          GuiGe = dbCommodity.GuiGe,

                                          Guarantee = dbCommodity.Guarantee,//保质期

                                          Habitat = dbCommodity.BarCode,//产地

                                          Count = dbCommodity.Count,

                                          Code = dbPurchase.Code,

                                      }).ToList();

        }

查询出全部数据之后，我们在执行点击回填的方法，回填的方法有很多，下面是一种罪简单的回填方法，实现的代码如下所示。

        private void DgCommod_MouseDoubleClick(object sender, MouseButtonEventArgs e) {

            AccountEntity myAccountEntity = dgJiessaun.SelectedValue as AccountEntity;

            tbRemark.Text = myAccountEntity.Remark;

            tbCode.Text = myAccountEntity.Code;

            tbAccountCode.Text = myAccountEntity.AccountCode;

            tbMoney.Text = myAccountEntity.Money;

            tbMonographName.Text = myAccountEntity.MonographName;

            tbSolicitorName.Text = myAccountEntity.SolicitorName;

            tbPayName.Text = myAccountEntity.PayName;

            DateTime d = Convert.ToDateTime(myAccountEntity.Time);

            tbTime.Text = d.ToString();

        }

回填的结果如下图所示：