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("请先选择客户");
}
});
}
