执行新增

新增的代码如下：

  /// <summary>

  /// 保存按钮

  /// </summary>

  /// <param name="sender"></param>

  /// <param name="e"></param>

   private void btn_Save_Click(object sender, RoutedEventArgs e)

   {

         try

         {

              if (Convert.ToInt32(AreaName.SelectedValue) != 0 && Convert.ToInt32(TypeName.SelectedValue) != 0 && Convert.ToInt32(PayName.SelectedValue) != 0

                    && SuppliersCode.Text.Trim() != String.Empty && Site.Text.Trim() != String.Empty && SuppliersName.Text.Trim() != String.Empty

                    && Number.Text.Trim() != String.Empty && Person.Text.Trim() != String.Empty && Phone.Text.Trim() != String.Empty)

                {

                    //新增供应商信息表

                    Suppliers tbSuppliers = new Suppliers();

                    Account tbAccount = new Account();

                    OpenBank tbOPenBank = new OpenBank();

                    tbAccount.MonthlyDate = MonthlyDate.Text.Trim();

                    tbAccount.SettlementCycle = SettlementCycle.Text.Trim();

                    tbAccount.PayID = Convert.ToInt32(PayName.SelectedValue);

                    myModel.Account.Add(tbAccount);

                    tbOPenBank.Number = Number.Text.Trim();

                    tbOPenBank.RegistrationNumber = RegistrationNumber.Text.Trim();

                    tbOPenBank.BankName = BankName.Text.Trim();

                    myModel.OpenBank.Add(tbOPenBank);

                    if (myModel.SaveChanges() > 0)

                    {

                        tbSuppliers.AccountID = Convert.ToInt32(tbAccount.AccountID);

                        tbSuppliers.OpenBankID = Convert.ToInt32(tbOPenBank.OpenBankID);

                        tbSuppliers.SuppliersCode = SuppliersCode.Text.Trim();

                        tbSuppliers.SuppliersName = SuppliersName.Text.Trim();

                        tbSuppliers.Phone = Phone.Text.Trim();

                        tbSuppliers.Fax = Fax.Text.Trim();

                        tbSuppliers.Person = Person.Text.Trim();

                        tbSuppliers.Post = Post.Text.Trim();

                        tbSuppliers.Mail = Mail.Text.Trim();

                        tbSuppliers.Site = Site.Text.Trim();

                        tbSuppliers.Remark = Remark.Text.Trim();

                        tbSuppliers.AreaID = Convert.ToInt32(AreaName.SelectedValue);

                        tbSuppliers.TypeID = Convert.ToInt32(TypeName.SelectedValue);

                        myModel.Suppliers.Add(tbSuppliers);

                        if (myModel.SaveChanges()>0)

                        {

                            MessageBoxResult dr = MessageBox.Show("供应商信息新增成功！", "提示,", MessageBoxButton.OK, MessageBoxImage.Information);

                            if (dr == MessageBoxResult.OK)

                            {

                                //清空页面

                                EmptyControls();

                                //刷新表格数据

                                Merchandise mer = new Merchandise();

                                this.Close();

                            }

                        }

                        else

                        {

                            MessageBox.Show("供应商信息新增是失败！", "提示,", MessageBoxButton.OK, MessageBoxImage.Information);

                        }

                    }

                }

                else

                {

                    MessageBox.Show("请把信息填写完整！", "提示,", MessageBoxButton.OK, MessageBoxImage.Information);

                }

            }

            catch (Exception)

            {

                throw;

            }

        }