//private void cmbSupplier_SelectedIndexChanged(object sender, EventArgs e) //{ // if (isLoading == true) // return; // if (cmbSupplier.SelectedIndex < 0) // return; // //显示供应商的第一个联系人 // DaSupplierContact mDaSupplierContact; // ICollection<DaSupplierContact> mDaSupplierContacts = ((DaSupplier)DaSupplierBindingSource[cmbSupplier.SelectedIndex]).DaSupplierContacts; // if (mDaSupplierContacts.Count() < 1) // { // return; // } // mDaSupplierContact = mDaSupplierContacts.Take(1).SingleOrDefault(); // txtLinkMan.Text = mDaSupplierContact.VcName; // txtTel.Text = mDaSupplierContact.VcTel; // txtFax.Text = mDaSupplierContact.VcFax; // txtMobile.Text = mDaSupplierContact.VcMobile; // mDaPurchaseContract.VcLinkMan = mDaSupplierContact.VcName; // mDaPurchaseContract.VcTel = mDaSupplierContact.VcTel; // mDaPurchaseContract.VcFax = mDaSupplierContact.VcFax; // mDaPurchaseContract.VcMobile = mDaSupplierContact.VcMobile; //} private void btnSupplier_Click(object sender, EventArgs e) { if (goodsTable.Rows.Count > 0) { MessageBox.Show(@"更换供应商需先清除采购物品!"); return; } using (var mForm = new 择供应商()) { if (mForm.ShowDialog() == DialogResult.OK) { //选择供应商 mDaSupplierId = mForm.mDaSupplierID[0]; var singleOrDefault = myEntity.DaSuppliers.SingleOrDefault(d => d.IntID == mDaSupplierId); if (singleOrDefault != null) { txtSupplier.Text = singleOrDefault.VcName; DaSupplierContact dsc = singleOrDefault.DaSupplierContacts.SingleOrDefault(); if (dsc != null) { txtLinkMan.Text = dsc.VcName; mDaPurchaseContract.VcLinkMan = dsc.VcName; txtMobile.Text = dsc.VcMobile; mDaPurchaseContract.VcMobile = dsc.VcMobile; txtTel.Text = dsc.VcTel; mDaPurchaseContract.VcTel = dsc.VcTel; txtFax.Text = dsc.VcFax; mDaPurchaseContract.VcFax = dsc.VcFax; } } } } }
private void dgvDaSuppContact_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } if (e.ColumnIndex == dsc删除.Index) { //删除 DaSupplierContact mDaSupplierContact = (DaSupplierContact)DaSuppContactBindingSource[e.RowIndex]; if (MessageBox.Show("是否确认删除" + mDaSupplierContact.VcName, "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK) { return; } myEntity.DaSupplierContacts.Remove(mDaSupplierContact); int ret = myEntity.SaveChanges(); if (ret > 0) { InitDaSupplierContact(); MessageBox.Show("删除成功"); } else { MessageBox.Show("删除失败"); } } if (e.ColumnIndex == dsc修改.Index) { //修改 using (供应商联系人编辑 mForm = new 供应商联系人编辑()) { mForm.DaContactID = ((DaSupplierContact)DaSuppContactBindingSource[e.RowIndex]).IntID; if (mForm.ShowDialog() == DialogResult.OK) { InitDaSupplierContact(); } } } }
private void InitData() { if (myEntity == null) { myEntity = new MYDBEntities2(); } if (DaContactID > 0) { //修改 mDaSuppContact = myEntity.DaSupplierContacts.Where(d => d.IntID == DaContactID).SingleOrDefault(); DaSupplierID = mDaSuppContact.IntSupplierID; } else { //增加 mDaSuppContact = new DaSupplierContact() { IntSupplierID = DaSupplierID, IntEmpNum = Classes.PubClass.UserId }; DaSupplier daSupplier = myEntity.DaSuppliers.SingleOrDefault(d => d.IntID == DaSupplierID); if (daSupplier != null) { mDaSuppContact.VcTel = daSupplier.VcTel; mDaSuppContact.VcFax = daSupplier.VcFax; } } bindingSourceDaSuppContact.DataSource = mDaSuppContact; txtName.Text = myEntity.DaSuppliers.Where(d => d.IntID == DaSupplierID).SingleOrDefault().VcName; txtContactName.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcName"); txtPost.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcPost"); txtTel.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcTel"); txtFax.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcFax"); txtMobile.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcMobile"); txtQQ.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcQQ"); txtEmail.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcEmail"); txtRemark.DataBindings.Add("Text", bindingSourceDaSuppContact, "VcRemark"); }