//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");
}
