private void Window_Loaded(object sender, RoutedEventArgs e)
{
dataContext = new DataClassesProjectClassifyDataContext();
Classifies.DisplayMemberPath = "FundClassify1";
Classifies.SelectedValuePath = "FundClassifyID";
Classifies.DataContext = dataContext.FundClassify;
}
private void ButtonPay_Click(object sender, RoutedEventArgs e)
{
if (dataContext == null)
{
dataContext = new DataClassesProjectClassifyDataContext();
}
try
{
Prizes prizes = new Prizes
{
//ProjectID = ProjectId,
Department = ((Department)ListBoxDepartment.SelectedItem).Name,
Name = ((Employee)ListBoxEmployee.SelectedItem).Name,
PrizeClassify = ((PrizeClassify)ListBoxPrizeClassify.SelectedItem).PrizeClassifyName,
AccountName = ((Employee)ListBoxEmployee.SelectedItem).AccountName,
AwardName = TextBoxAwardName.Text.Trim(),
Prize = Convert.ToDecimal(TextBoxPrize.Text.Trim()),
PayYear = TextBoxYear.Text.Trim()
};
dataContext.Prizes.InsertOnSubmit(prizes);
dataContext.SubmitChanges();
//DataGridPrizes.ItemsSource = dataContext.Prizes.Where(p => p.ProjectID.Equals(ProjectId));
}
catch (Exception)
{ }
}
private void buttonSubmit_Click(object sender, RoutedEventArgs e)
{
if (PatentClassifies.SelectedItem == null)
{
MessageBox.Show("请选择知识产权项类别！", "错误");
return;
}
if (PatentDate.SelectedDate == null)
{
MessageBox.Show("请选择颁布时间！", "错误");
return;
}
Patents patents = new Patents();
patents.ProjectID = projectID;
patents.PatentClassifyID = ((PatentClassify)PatentClassifies.SelectedItem).PatentClassifyID;
patents.PatentNo = PatentNo.Text.Trim();
patents.PatentName = PatentName.Text.Trim();
patents.PatendDepartment = PatentDepartment.Text.Trim();
patents.PatentDate = PatentDate.SelectedDate;
patents.Note = Note.Text.Trim();
dataContext = new DataClassesProjectClassifyDataContext();
dataContext.Patents.InsertOnSubmit(patents);
dataContext.SubmitChanges();
dataGridPatents.DataContext = dataContext.Patents.Where(p => p.ProjectID.Equals(projectID));
((MainWindow)(this.Owner)).DialogR = true;
}
private void ButtonRemove_Click(object sender, RoutedEventArgs e)
{
if (dataContext == null)
{
dataContext = new DataClassesProjectClassifyDataContext();
}
Prizes prizes = dataContext.Prizes.FirstOrDefault(p => p.ID.Equals(_currentPrizeID));
if (prizes != null)
{
var prizeses =
dataContext.Prizes.Where(
p =>
p.Name.Equals(prizes.Name) && p.AccountName.Equals(prizes.AccountName) &&
p.PayYear.Equals(prizes.PayYear) &&
p.Department.Equals(prizes.Department) && p.PrizeClassify.Equals(prizes.PrizeClassify) &&
p.Project.Equals(prizes.Project) && p.AwardName.Equals(prizes.AwardName));
try
{
foreach (var pr in prizeses)
{
dataContext.Prizes.DeleteOnSubmit(pr);
dataContext.SubmitChanges();
}
FreshData();
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
dataContext = new DataClassesProjectClassifyDataContext();
TeamDepartment.DisplayMemberPath = "Department";
TeamDepartment.SelectedValuePath = "Id";
TeamDepartment.DataContext = dataContext.TeamDepartments.Where(t => t.ProjectID.Equals(projectID));
}
private void MainForm_Loaded(object sender, RoutedEventArgs e)
{
dataContext = new DataClassesProjectClassifyDataContext();
MainTreeView.DataContext = dataContext.ProjectClassify;
LinkProject = new List <int>();
//var query = dataContext.ProjectBase.Where(p => p.ProjectName.)
}
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 UpdateProjectBase()
{
isCreateOrUpdateProject = true;
if (ProjectID == 0)
{
MessageBox.Show("请选择项目！", "错误");
return;
}
dataContext = new DataClassesProjectClassifyDataContext();
var pb = dataContext.ProjectBase.Single(p => p.ProjectId.Equals(ProjectID));
var newProjectBase = new NewProjectBase();
newProjectBase.Owner = this;
newProjectBase.IsCreate = false;
if (pb.ParentID != null)
{
newProjectBase.ParentID = (int)pb.ParentID;
}
newProjectBase.ProjectID = ProjectID;
newProjectBase.ShowDialog();
if (DialogR)
{
dataContext = new DataClassesProjectClassifyDataContext();
//dataContext.Refresh(System.Data.Linq.RefreshMode.KeepChanges, dataContext.ProjectBase);
MainTreeView.DataContext = dataContext.ProjectClassify;
WindowDataBind();
BuildLinkProjectList(ProjectID);
SetTreeViewFocus();
DialogR = false;
}
}
private void NewProjectBaseWindow_Loaded(object sender, RoutedEventArgs e)
{
dataContent = new DataClassesProjectClassifyDataContext();
string title = "";
if (isCreate)
{
if (!isSubProject)
{
ProjectClassify projectClassify = dataContent.ProjectClassify.Single(pc => pc.ClassifyId.Equals(projectClassifyID));
title = "新建“" + projectClassify.ProjectClassify1 + "”类别项目";
}
else
{
ProjectBase projectBase = dataContent.ProjectBase.Single(pb => pb.ProjectId.Equals(parentID));
title = "新建项目“" + projectBase.ProjectName + "”的子项目";
}
}
else
{
ProjectBase projectBase = dataContent.ProjectBase.Single(pb => pb.ProjectId.Equals(projectID));
title = projectBase.ProjectName + "——修改项目基本信息";
}
this.Title = title;
}
private void ButtonImport_Click(object sender, RoutedEventArgs e)
{
dataContext = new DataClassesProjectClassifyDataContext();
try
{
_wb = new XLWorkbook(_filename);
if (!GetYear())
{
MessageBox.Show("标题行中没有包含 年度 描述，或者报表为空！", "错误");
return;
}
if (!GetDeclareDepartment())
{
MessageBox.Show("标题行中没有包含 申报部门 描述，或者报表为空！", "错误");
return;
}
GetPrizeClassifies();
GetProjects();
GetPrizeCategories();
ReadData();
MessageBox.Show("导入数据成功！");
}
catch (Exception error)
{
MessageBox.Show("导入数据失败！\n" + error.Message, "错误");
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
dataContext = new DataClassesProjectClassifyDataContext();
Workers.DisplayMemberPath = "WorkerName";
Workers.SelectedValuePath = "Id";
Workers.DataContext = dataContext.TeamWorkers.Where(t => t.ProjectID.Equals(projectID));
}
private void buttonSubmit_Click(object sender, RoutedEventArgs e)
{
if (RateClassifys.SelectedItem == null)
{
MessageBox.Show("请选择鉴定结论！", "错误");
return;
}
if (RateDate.SelectedDate == null)
{
MessageBox.Show("请选择日期！", "错误");
return;
}
RateResults rateResults = new RateResults();
rateResults.ProjectID = projectID;
rateResults.RateDepartment = RateDepartment.Text.Trim();
rateResults.RateClassifyID = ((RateClassify)(RateClassifys.SelectedItem)).RateClassifyId;
rateResults.RateDate = RateDate.SelectedDate;
rateResults.Note = Note.Text.Trim();
dataContent = new DataClassesProjectClassifyDataContext();
dataContent.RateResults.InsertOnSubmit(rateResults);
dataContent.SubmitChanges();
dataGridRate.DataContext = dataContent.RateResults.Where(r => r.ProjectID.Equals(projectID));
((MainWindow)(this.Owner)).DialogR = true;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
dataContent = new DataClassesProjectClassifyDataContext();
dataGridResults.DataContext = dataContent.Results.Where(r => r.ProjectID.Equals(projectID));
ProjectBase projectBase = dataContent.ProjectBase.Single(p => p.ProjectId.Equals(projectID));
this.Title = projectBase.ProjectName + "——成果登记管理";
}
private void NewProjectBase()
{
isCreateOrUpdateProject = true;
if (ProjectID != 0)
{
var projectBase = dataContext.ProjectBase.Single(p => p.ProjectId.Equals(ProjectID));
if (MessageBox.Show("新建 " + projectBase.ProjectName + " 下的子项目？", "温馨提示", MessageBoxButton.OKCancel) ==
MessageBoxResult.OK)
{
var newProjectBase = new NewProjectBase();
newProjectBase.Owner = this;
newProjectBase.IsCreate = true;
newProjectBase.IsSubProject = true;
newProjectBase.ParentID = ProjectID;
newProjectBase.ShowDialog();
if (DialogR)
{
dataContext = new DataClassesProjectClassifyDataContext();
dataContext.Refresh(RefreshMode.OverwriteCurrentValues, dataContext);
MainTreeView.DataContext = dataContext.ProjectClassify;
WindowDataBind();
var pr = dataContext.ProjectBase.OrderByDescending(p => p.ProjectId).FirstOrDefault();
ProjectID = pr.ProjectId;
BuildLinkProjectList(ProjectID);
while (pr.ParentID != null)
{
pr = dataContext.ProjectBase.Single(p => p.ProjectId.Equals(pr.ParentID));
}
projectClassifyID = (int)pr.ProjectClassifyID;
SetTreeViewFocus();
DialogR = false;
}
}
}
else
{
var newProjectBase = new NewProjectBase();
newProjectBase.Owner = this;
newProjectBase.IsCreate = true;
newProjectBase.IsSubProject = false;
newProjectBase.ProjectClassifyID = projectClassifyID;
newProjectBase.ShowDialog();
if (DialogR)
{
dataContext = new DataClassesProjectClassifyDataContext();
// dataContext.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, dataContext.ProjectBase);
//List<ProjectBase> lProjectBase = dataContext.ProjectBase.ToList<ProjectBase>();
MainTreeView.DataContext = dataContext.ProjectClassify;
WindowDataBind();
var pr = dataContext.ProjectBase.OrderByDescending(p => p.ProjectId).FirstOrDefault();
ProjectID = pr.ProjectId;
BuildLinkProjectList(ProjectID);
projectClassifyID = (int)pr.ProjectClassifyID;
SetTreeViewFocus();
DialogR = false;
}
}
}
private void buttonUpdate_Click(object sender, RoutedEventArgs e)
{
if (contractID == 0)
{
MessageBox.Show("请选择合同项！", "错误");
return;
}
if (listboxContractType.SelectedItem == null)
{
MessageBox.Show("请选择合同类型！", "错误");
return;
}
if (ContractDate.SelectedDate == null)
{
MessageBox.Show("请选择签订日期！", "错误");
return;
}
if (dataContext == null)
{
dataContext = new DataClassesProjectClassifyDataContext();
}
int cid = ((ProjectContracts)(datagridContracts.SelectedItem)).ID;
var pn = dataContext.ProjectContracts.Where(p => p.ContractNo.Trim().Equals(textboxContractNo.Text.Trim()) && p.ContractNo.Trim() != "" && p.ID != cid);
if (pn.Any())
{
MessageBox.Show("合同编号重复！", "错误");
return;
}
var projectContract = dataContext.ProjectContracts.Single(pc => pc.ID.Equals(contractID));
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.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;
}
/// <summary>
/// 搜索
/// </summary>
private void buttonSearch_Click()
{
if (String.IsNullOrEmpty(searchTextBox.Text))
{
dataContext = new DataClassesProjectClassifyDataContext();
MainTreeView.DataContext = dataContext.ProjectClassify;
WindowDataBind();
return;
}
var searchPredicate = PredicateExtensions.True <ProjectBase>();
searchText = new List <string>();
searchText = System.Text.RegularExpressions.Regex.Split(searchTextBox.Text, @"[' ']+").ToList <String>();
//foreach (string str in searchText)
//{
// searchPredicate = searchPredicate.Or(p => p.ProjectName.Contains(str));
//}
//var pb = dataContext.ProjectBase.Where(searchPredicate);
var pb = from c in dataContext.ProjectBase select c;
foreach (string str in searchText)
{
pb = pb.Where(c => c.ProjectName.Contains(str));
List <ProjectBase> list = pb.ToList();
}
//创建符合条件的项目的所有关联项目的项目树ProjectID列表
LinkProjectForSearch = new List <int>();
LinkProjectClassify = new List <int>();
foreach (ProjectBase p in pb)
{
var pp = p;
if (!LinkProjectForSearch.Contains(pp.ProjectId))
{
LinkProjectForSearch.Add(pp.ProjectId);
while (pp.ParentID != null)
{
pp = dataContext.ProjectBase.Single(ppb => ppb.ProjectId.Equals(pp.ParentID));
if (!LinkProjectForSearch.Contains(pp.ProjectId))
{
LinkProjectForSearch.Add(pp.ProjectId);
}
}
}
if (!LinkProjectClassify.Contains((int)pp.ProjectClassifyID))
{
LinkProjectClassify.Add((int)pp.ProjectClassifyID);
}
}
dataContext = new DataClassesProjectClassifyDataContext();
MainTreeView.DataContext = dataContext.ProjectClassify;
buildSearchTreeProjectClassify();
if (LinkProjectForSearch.Count > 0)
{
projectID = LinkProjectForSearch[0];
WindowDataBind();
}
}
private void ButtonShift_Click(object sender, RoutedEventArgs e)
{
if (FundClassifys.SelectedItem == null)
{
return;
}
var fundClassify = (FundClassify)FundClassifys.SelectedItem;
if ((fundClassify.FundClassify1 != "到账") && (fundClassify.FundClassify1 != "支付外协"))
{
return;
}
if (dataGridFund.SelectedItem == null)
{
return;
}
if (string.IsNullOrWhiteSpace(textBoxContractNo.Text))
{
MessageBox.Show("请输入合同编号！", "错误");
return;
}
if (dataContent == null)
{
dataContent = new DataClassesProjectClassifyDataContext();
}
try
{
var funds = (Funds)dataGridFund.SelectedItem;
var contract = dataContent.ProjectContracts.FirstOrDefault(c => c.ContractNo.Equals(funds.ContractNo));
if (contract == null)
{
return;
}
var contractFunds = new ContractFunds
{
ContractNo = funds.ContractNo,
ContractID = contract.ID,
FundClassifyID = funds.FundClassifyID,
Date = funds.Date,
Handled = funds.Handled,
Money = funds.Money,
Source = funds.Source,
SubPrincipal = funds.SubPrincipal
};
dataContent.ContractFunds.InsertOnSubmit(contractFunds);
dataContent.Funds.DeleteOnSubmit(funds);
dataContent.SubmitChanges();
dataContent = new DataClassesProjectClassifyDataContext();
dataGridFund.DataContext =
dataContent.Funds.Where(f => f.ProjectID.Equals(ProjectID)).OrderBy(f => f.Date);
SetTotalMoney();
}
catch (Exception)
{
throw;
}
}
private void RefreshData()
{
if (DialogR)
{
dataContext = new DataClassesProjectClassifyDataContext();
WindowDataBind();
DialogR = false;
}
}
private void buttonCancel_Loaded(object sender, RoutedEventArgs e)
{
if (!IsCreate)
{
dataContent = new DataClassesProjectClassifyDataContext();
ProjectBase projectBase = dataContent.ProjectBase.Single(p => p.ProjectId.Equals(ProjectID));
ProjectNo.Text = projectBase.ProjectNo;
ContractNo.Text = projectBase.ContractNo;
FirstParty.Text = projectBase.FirstParty;
SecondParty.Text = projectBase.SecondParty;
SetupYear.Text = projectBase.SetupYear;
IsMainSearch.IsChecked = projectBase.IsMainResearch;
ProjectName.Text = projectBase.ProjectName;
if (projectBase.StartDate != null)
{
StartDate.Text = ((DateTime)(projectBase.StartDate)).ToShortDateString();
}
if (projectBase.PlanFinishDate != null)
{
PlanFinishDate.Text = ((DateTime)(projectBase.PlanFinishDate)).ToShortDateString();
}
if (projectBase.FinishDate != null)
{
FinishDate.Text = ((DateTime)(projectBase.FinishDate)).ToShortDateString();
}
Principal.Text = projectBase.Principal;
SumMoney.Text = projectBase.SumMoney.ToString();
Ministry.Text = projectBase.Ministry.ToString();
Transportation.Text = projectBase.Transportation.ToString();
Science.Text = projectBase.Science.ToString();
SupportEngineering.Text = projectBase.SupportEngineering.ToString();
Other.Text = projectBase.Other.ToString();
AuthrizeMoney.Text = projectBase.AuthorizeMoney.ToString();
AnchoredDepartment.Text = projectBase.AnchoredDepartment;
if (projectBase.IsKnot == "验收")
{
IsKnot1.IsChecked = true;
}
if (projectBase.IsKnot == "鉴定")
{
IsKnot2.IsChecked = true;
}
if (projectBase.IsKnot == "尚未结题")
{
IsKnot3.IsChecked = true;
}
if (projectBase.IsKnot == "结清")
{
IsKnot5.IsChecked = true;
}
IsFiled.IsChecked = projectBase.IsFiled;
Note.Text = projectBase.Note;
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
dataContent = new DataClassesProjectClassifyDataContext();
RateClassifys.DisplayMemberPath = "RateClassify1";
RateClassifys.SelectedValuePath = "RateClassifyID";
RateClassifys.DataContext = dataContent.RateClassify;
dataGridRate.DataContext = dataContent.RateResults.Where(r => r.ProjectID.Equals(projectID));
ProjectBase projectBase = dataContent.ProjectBase.Single(pb => pb.ProjectId.Equals(projectID));
this.Title = projectBase.ProjectName + "——鉴定管理";
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
dataContext = new DataClassesProjectClassifyDataContext();
PatentClassifies.DisplayMemberPath = "PatentClassify1";
PatentClassifies.SelectedValuePath = "PatentClassifyID";
PatentClassifies.DataContext = dataContext.PatentClassify;
dataGridPatents.DataContext = dataContext.Patents.Where(p => p.ProjectID.Equals(projectID));
ProjectBase projectBase = dataContext.ProjectBase.Single(p => p.ProjectId.Equals(projectID));
this.Title = projectBase.ProjectName + "——知识产权管理";
}
/// <summary>
/// 计算总费用
/// </summary>
private void SetTotalMoney()
{
if (dataContent == null)
{
dataContent = new DataClassesProjectClassifyDataContext();
}
totalInComing = 0;
var fundsInComing =
dataContent.Funds.Where(f => f.ProjectID.Equals(ProjectID) && (f.FundClassify.FundClassify1 == "到账"));
foreach (var funds in fundsInComing)
{
if (funds.Money != null)
{
totalInComing += (decimal)funds.Money;
}
}
var contractComing =
dataContent.ContractFunds.Where(
f => f.ProjectContracts.ProjectID.Equals(ProjectID) && (f.FundClassify.FundClassify1 == "到账"));
foreach (var contractFunds in contractComing)
{
if (contractFunds.Money != null)
{
totalInComing += (decimal)contractFunds.Money;
}
}
totalPayfor = 0;
var fundsPayfor =
dataContent.Funds.Where(f => f.ProjectID.Equals(ProjectID) && (f.FundClassify.FundClassify1 != "到账"));
foreach (var funds in fundsPayfor)
{
if (funds.Money != null)
{
totalPayfor += (decimal)funds.Money;
}
}
var contractPayfor =
dataContent.ContractFunds.Where(
f => f.ProjectContracts.ProjectID.Equals(ProjectID) && (f.FundClassify.FundClassify1 != "到账"));
foreach (var funds in contractPayfor)
{
if (funds.Money != null)
{
totalPayfor += (decimal)funds.Money;
}
}
textBlockTotal.Text = "收入总计：" + $"{totalInComing:N2}" + "万元，支出总计：" +
$"{totalPayfor:N2}" + "万元";
}
private void buttonSubmit_Click(object sender, RoutedEventArgs e)
{
if (FundClassifys.SelectedItem == null)
{
MessageBox.Show("请选择经费类型！", "错误");
return;
}
var fundClassify = (FundClassify)FundClassifys.SelectedItem;
if ((fundClassify.FundClassify1 == "课题组报支") || (fundClassify.FundClassify1 == "管理费"))
{
MessageBox.Show("经费类型属于项目经费，请到项目经费管理模块处理！", "错误");
return;
}
if (FundDate.SelectedDate == null)
{
MessageBox.Show("请选择日期！", "错误");
return;
}
if (contractID <= 0)
{
MessageBox.Show("请选择合同！", "错误");
return;
}
var funds = new ContractFunds();
funds.ContractID = contractID;
if (!string.IsNullOrWhiteSpace(textBoxContractNo.Text))
{
funds.ContractNo = textBoxContractNo.Text.Trim();
}
funds.Source = FundSource.Text;
funds.FundClassifyID = ((FundClassify)FundClassifys.SelectedItem).FandClassifyId;
try
{
funds.Money = (decimal)double.Parse(Money.Text);
}
catch (FormatException)
{
MessageBox.Show("金额格式不对！", "错误");
return;
}
funds.Date = FundDate.SelectedDate;
funds.Handled = Handled.Text.Trim();
funds.SubPrincipal = SubPrincipal.Text.Trim();
dataContent = new DataClassesProjectClassifyDataContext();
dataContent.ContractFunds.InsertOnSubmit(funds);
dataContent.SubmitChanges();
dataGridFund.DataContext = dataContent.Funds.Where(f => f.ProjectID.Equals(ProjectID)).OrderBy(f => f.Date);
((MainWindow)Owner).DialogR = true;
SetTotalMoney();
}
private void ButtonShift_Click(object sender, RoutedEventArgs e)
{
if (FundClassifys.SelectedItem == null)
{
return;
}
var fundClassify = (FundClassify)FundClassifys.SelectedItem;
if ((fundClassify.FundClassify1 != "课题组报支") && (fundClassify.FundClassify1 != "管理费"))
{
return;
}
if (dataGridFund.SelectedItem == null)
{
return;
}
if (dataContent == null)
{
dataContent = new DataClassesProjectClassifyDataContext();
}
try
{
var contractFunds = (ContractFunds)dataGridFund.SelectedItem;
var contract = dataContent.ProjectContracts.FirstOrDefault(c => c.ContractNo.Equals(contractFunds.ContractNo));
if (contract == null)
{
return;
}
var funds = new Funds
{
ContractNo = contractFunds.ContractNo,
FundClassifyID = contractFunds.FundClassifyID,
Date = contractFunds.Date,
Handled = contractFunds.Handled,
Money = contractFunds.Money,
Source = contractFunds.Source,
SubPrincipal = contractFunds.SubPrincipal
};
dataContent.Funds.InsertOnSubmit(funds);
dataContent.ContractFunds.DeleteOnSubmit(contractFunds);
dataContent.SubmitChanges();
dataContent = new DataClassesProjectClassifyDataContext();
dataGridFund.DataContext =
dataContent.ContractFunds.Where(f => f.ProjectContracts.ProjectID.Equals(ProjectID)).OrderBy(f => f.Date);
SetTotalMoney();
}
catch (Exception)
{
throw;
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
dataContext = new DataClassesProjectClassifyDataContext();
RewardClasses.DisplayMemberPath = "RewardClass1";
RewardClasses.SelectedValuePath = "RewradClassID";
RewardClasses.DataContext = dataContext.RewardClass;
RewardClassifies.DisplayMemberPath = "RewardClassify1";
RewardClassifies.SelectedValuePath = "RewardClassifyID";
RewardClassifies.DataContext = dataContext.RewardClassify;
dataGridRewards.DataContext = dataContext.Reward.Where(r => r.ProjectID.Equals(projectID));
ProjectBase projectBase = dataContext.ProjectBase.Single(pb => pb.ProjectId.Equals(projectID));
this.Title = projectBase.ProjectName + "——获奖记录管理";
}
private void ButtonRemove_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("确定删除该项奖金？", "温馨提示", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
if (dataContext == null)
{
dataContext = new DataClassesProjectClassifyDataContext();
}
dataContext.Prizes.DeleteOnSubmit((Prizes)DataGridPrizes.SelectedItem);
dataContext.SubmitChanges();
//DataGridPrizes.ItemsSource = dataContext.Prizes.Where(p => p.ProjectID.Equals(ProjectId));
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
dataContext = new DataClassesProjectClassifyDataContext();
listboxContractType.DisplayMemberPath = "ContractType";
listboxContractType.SelectedValuePath = "TypeID";
listboxContractType.DataContext = dataContext.ContractTypes;
listboxContractType.SelectedIndex = 0;
var p = dataContext.ProjectBase.Single(pb => pb.ProjectId.Equals(projectID));
this.Title = p.ProjectName + "——合同管理";
projectName = p.ProjectName;
textboxProjectName.Text = projectName;
textboxSecondParty.Text = "湖南省交通规划勘察设计院";
datagridContracts.DataContext = dataContext.ProjectContracts.Where(pc => pc.ProjectID.Equals(projectID));
}
private void buttonSubmit_Click(object sender, RoutedEventArgs e)
{
if (RewardClasses.SelectedItem == null)
{
MessageBox.Show("请选择奖项级别！", "错误");
return;
}
if (RewardClassifies.SelectedItem == null)
{
MessageBox.Show("请选择奖项等别！", "错误");
return;
}
//if(RewardDate.SelectedDate == null)
//{
// MessageBox.Show("请选择授奖日期！", "错误");
// return;
//}
if (String.IsNullOrEmpty(RewardDepartment.Text))
{
MessageBox.Show("请填写授奖机构！", "错误");
return;
}
if (String.IsNullOrEmpty(RewardName.Text))
{
MessageBox.Show("请填写奖项名称！", "错误");
return;
}
dataContext = new DataClassesProjectClassifyDataContext();
Reward rw = new Reward();
rw.ProjectID = projectID;
rw.RewardClassID = ((RewardClass)RewardClasses.SelectedItem).RewardClassId;
rw.RewardClassifyID = ((RewardClassify)RewardClassifies.SelectedItem).RewardClassifyID;
rw.RewardName = RewardName.Text.Trim();
rw.ReawardYear = RewardYear.Text.Trim();
if (RewardDate.SelectedDate != null)
{
rw.RewardDate = RewardDate.SelectedDate;
}
rw.RewardDepartment = RewardDepartment.Text.Trim();
rw.Department = Department.Text.Trim();
rw.Workers = Workers.Text.Trim();
rw.Note = Note.Text.Trim();
dataContext.Reward.InsertOnSubmit(rw);
dataContext.SubmitChanges();
dataGridRewards.DataContext = dataContext.Reward.Where(r => r.ProjectID.Equals(projectID));
((MainWindow)(this.Owner)).DialogR = true;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
dataContent = new DataClassesProjectClassifyDataContext();
FundClassifys.DisplayMemberPath = "FundClassify1";
FundClassifys.SelectedValuePath = "FundClassifyID";
FundClassifys.DataContext = dataContent.FundClassify;
dataGridFund.DataContext = dataContent.Funds.Where(f => f.ProjectID.Equals(ProjectID)).OrderBy(f => f.Date);
datagridContractIn.DataContext =
dataContent.ProjectContracts.Where(pc => pc.ProjectID.Equals(ProjectID) && pc.TypeID.Equals(1));
datagridContractPay.DataContext =
dataContent.ProjectContracts.Where(pc => pc.ProjectID.Equals(ProjectID) && pc.TypeID.Equals(2));
var projectBase = dataContent.ProjectBase.Single(pb => pb.ProjectId.Equals(ProjectID));
Title = projectBase.ProjectName + "——经费管理";
textSumMoney.Text = "合同总额：" + projectBase.SumMoney + "万元";
SetTotalMoney();
}
private void buttonAdd_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(Worker.Text))
{
MessageBox.Show("请输入团队成员姓名！", "错误");
return;
}
dataContext = new DataClassesProjectClassifyDataContext();
TeamWorkers teamWorkers = new TeamWorkers();
teamWorkers.ProjectID = projectID;
teamWorkers.WorkerName = Worker.Text;
dataContext.TeamWorkers.InsertOnSubmit(teamWorkers);
dataContext.SubmitChanges();
Workers.DataContext = dataContext.TeamWorkers.Where(t => t.ProjectID.Equals(projectID));
((MainWindow)(this.Owner)).DialogR = true;
}
