private void datagridContracts_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (datagridContracts.SelectedItem != null)
{
ProjectContracts projectContract = (ProjectContracts)datagridContracts.SelectedItem;
contractID = projectContract.ID;
buttonUpdate.IsEnabled = true;
buttonDelete.IsEnabled = true;
if (dataContext == null)
{
dataContext = new DataClassesProjectClassifyDataContext();
}
listboxContractType.SelectedItem = dataContext.ContractTypes.Single(ct => ct.TypeID.Equals(projectContract.TypeID));
textboxContractNo.Text = projectContract.ContractNo;
textboxProjectName.Text = projectContract.ProjectName;
textboxFirstParty.Text = projectContract.FirstParty;
textboxSecondParty.Text = projectContract.SecondParty;
textboxContractPeriod.Text = projectContract.ContractPeriod;
textboxPrincipal.Text = projectContract.Principal;
textboxSumMoney.Text = projectContract.SumMoney.ToString();
try
{
ContractDate.DisplayDate = (DateTime)projectContract.ContractDate;
ContractDate.SelectedDate = projectContract.ContractDate;
}
catch (Exception)
{ }
textboxNote.Text = projectContract.Note;
}
}
private void buttonSumbit_Click(object sender, RoutedEventArgs e)
{
if (listboxContractType.SelectedItem == null)
{
MessageBox.Show("请选择合同类型！", "错误");
return;
}
if (ContractDate.SelectedDate == null)
{
MessageBox.Show("请选择签订日期！", "错误");
return;
}
if (dataContext == null)
{
dataContext = new DataClassesProjectClassifyDataContext();
}
var pn = dataContext.ProjectContracts.Where(p => p.ContractNo.Trim().Equals(textboxContractNo.Text.Trim()) && p.ContractNo.Trim() != "");
if (pn.Count() > 0)
{
MessageBox.Show("合同编号重复，已经录入该合同？", "错误");
return;
}
ProjectContracts projectContract = new ProjectContracts();
projectContract.ProjectID = projectID;
projectContract.TypeID = ((ContractTypes)(listboxContractType.SelectedItem)).TypeID;
projectContract.ContractNo = textboxContractNo.Text;
try
{
projectContract.SumMoney = (Decimal)Double.Parse(textboxSumMoney.Text);
}
catch (FormatException)
{
MessageBox.Show("金额格式不对！", "错误");
return;
}
projectContract.ProjectName = textboxProjectName.Text.Trim();
projectContract.FirstParty = textboxFirstParty.Text.Trim();
projectContract.SecondParty = textboxSecondParty.Text.Trim();
projectContract.ContractPeriod = textboxContractPeriod.Text.Trim();
projectContract.Principal = textboxPrincipal.Text.Trim();
projectContract.ContractDate = ContractDate.SelectedDate;
projectContract.Note = textboxNote.Text;
dataContext.ProjectContracts.InsertOnSubmit(projectContract);
dataContext.SubmitChanges();
datagridContracts.DataContext = dataContext.ProjectContracts.Where(pc => pc.ProjectID.Equals(projectID));
listboxContractType.DisplayMemberPath = "ContractType";
listboxContractType.SelectedValuePath = "TypeID";
listboxContractType.DataContext = dataContext.ContractTypes;
listboxContractType.SelectedIndex = 0;
((MainWindow)(this.Owner)).DialogR = true;
}
