public void Load() { // 重新加载扩展日期 CustomerSchedulingDate = Service.GetContinuousDate(OrganizationSearchedItem.Id, SettleDate); // CustomerSchedulingDate = new CustomerSchedulingDateModel() { Date3 = DateTime.Now }; // 重新加载交期数据 //CustomerSchedulingDetailLists.Clear(); //Service.GetCustomerSchedulingDetailLists(OrganizationSearchedItem.Id, SettleDate, CustomerSchedulingSummarySelectedItem?.Label ?? "").ForEach(x => CustomerSchedulingDetailLists.Add(x)); // 重新加载主表格数据 CustomerSchedulingSummaryLists.Clear(); OrgLabelLists.Clear(); Service.GetCustomerSchedulingSummaryLists(OrganizationSearchedItem.Id, SettleDate).ForEach(x => { CustomerSchedulingSummaryLists.Add(x); if (SelectedIndex == -1) { OrgLabelLists.Add(new CustomerSchedulingOrgLabelModel { FItemId = x.FItemId, Label = x.Label, OrgCode = x.OrgCode, OrgId = x.OrgId, ProductionName = x.ProductionName, Value1 = null, Value2 = null, Value3 = null, Value4 = null, Value5 = null }); } }); //SelectedIndex = sd; }
private void InitCommand() { DataGridSaveCommand = new DelegateCommand((obj) => { if (OrganizationSearchedItem != null) { var data = CustomerSchedulingSummaryLists.Where(x => x.NeedSupplyQty > 0); if (data.Count() > 0) { StringBuilder stringBuilder = new StringBuilder(); foreach (var item in data) { stringBuilder.Append($",('{SettleDate}',{item.OrgId},{item.FItemId},'{item.Label}',{item.NeedSupplyQty})"); } string sql = $"delete from SJCustomerSchedulingSupply where OrgId={OrganizationSearchedItem.Id}; insert into SJCustomerSchedulingSupply(SupplyDate,OrgId,FItemId,Label,SupplyQty) values" + stringBuilder.ToString().Substring(1); if (Service.BatchInsert(sql)) { MessageBox.Show("保存成功"); } } else { MessageBox.Show("没有填写需补库存"); } } else { MessageBox.Show("请先选择客户"); } }); QueryCommand = new DelegateCommand((obj) => { if (OrganizationSearchedItem != null) { //sd = -1; Load(); } else { MessageBox.Show("请先选择客户"); } }); ManagementCommand = new DelegateCommand((obj) => { if (OrganizationSearchedItem != null) { CustomerSchedulingManagementView view = new CustomerSchedulingManagementView(OrganizationSearchedItem, OrgLabelLists); (view.DataContext as CustomerSchedulingManagementViewModel).WithParam(null, (type, outputEntity, isChanged) => { view.Close(); if (isChanged) { Load(); } }); view.ShowDialog(); } else { MessageBox.Show("请先选择客户"); } }); }