private void InitCommand()
{
SyncBucketInfo = new DelegateCommand((obj) =>
{
int count = Service.SyncBucketInfo();
MessageBox.Show($"成功更新【{count}】条桶子名称");
});
ModifyCommand = new DelegateCommand((obj) =>
{
var cloneData = ObjectDeepCopyHelper <BucketModel, BucketModel> .Trans(BucketSelectedItem);
BucketModifyWindow view = new BucketModifyWindow();
(view.DataContext as BucketModifyViewModel).WithParam(cloneData, (type, outputEntity, IsChanged) =>
{
view.Close();
if (type == 1)
{
Service.BucketModify(outputEntity);
//if(IsChanged)
QueryBaseCommand.Execute(null);
}
});
view.ShowDialog();
});
QueryBaseCommand = new DelegateCommand((obj) =>
{
Lists.Clear();
Service.GetLists($" and FName like '%{BucketName}%'").ForEach(x => Lists.Add(x));
});
}
private void ModifyOilSampleFlowLog(object obj)
{
if (OilSampleFlowLogSelectedItem != null)
{
if (OilSampleFlowLogSelectedItem.TypeId == 1)
{
MessageBox.Show("快递单次数不允许修改");
return;
}
OilSampleFlowLogModifyView edit = new OilSampleFlowLogModifyView();
var cloneData = ObjectDeepCopyHelper <OilSampleFlowPrintLogModel, OilSampleFlowPrintLogModel> .Trans(OilSampleFlowLogSelectedItem);
(edit.DataContext as OilSampleFlowLogModifyViewModel).WithParam(cloneData, (type, entry) =>
{
edit.Close();
if (type == 1)
{
var r = _oilSampleService.UpdateOilSampleFlowLog(entry);
if (r)
{
OilSampleFlowLogSelectedItem.PrintedCount = entry.PrintedCount;
//重新加载明细
if (OilSampleFlowSelectedItem != null)
{
OilSampleEntries.Clear();
_oilSampleService.GetOilSampleEntries(OilSampleFlowSelectedItem.Id).ToList().ForEach(x => OilSampleEntries.Add(x));
}
}
}
});
edit.ShowDialog();
}
}
// public DelegateCommand SaveConfigurationCommand { get; set; }
private void InitCommand()
{
//SaveConfigurationCommand = new DelegateCommand((obj) =>
//{
// // 把界面数据同步到模板上
// CommonService.LoadIEnumerableToDatabase(DataGridLists, "SJDataGridColumnHeaderTemplate");
// // Insert或者Update数据
// _service.SaveColumnConfigurationInManagementView(_dataGridName, User.ID);
//});
MoveUpCommand = new DelegateCommand((obj) =>
{
var cloneData = ObjectDeepCopyHelper <DataGridColumnHeaderUserCustomModel, DataGridColumnHeaderUserCustomModel> .Trans(DataGridSelectedItem);
int index = DataGridLists.IndexOf(DataGridSelectedItem);
if (index == 0)
{
return;
}
int upOrder = DataGridLists.ElementAt(index - 1).ColumnOrder;
int currentOrder = DataGridSelectedItem.ColumnOrder;
cloneData.ColumnOrder = upOrder;
DataGridLists.ElementAt(index - 1).ColumnOrder = currentOrder;
DataGridLists.RemoveAt(index);
index--;
DataGridLists.Insert(index, cloneData);
DataGridSelectedItem = cloneData;
});
MoveDownCommand = new DelegateCommand((obj) =>
{
var cloneData = ObjectDeepCopyHelper <DataGridColumnHeaderUserCustomModel, DataGridColumnHeaderUserCustomModel> .Trans(DataGridSelectedItem);
int index = DataGridLists.IndexOf(DataGridSelectedItem);
if (index == DataGridLists.Count - 1)
{
return;
}
int downOrder = DataGridLists.ElementAt(index + 1).ColumnOrder;
int currentOrder = DataGridSelectedItem.ColumnOrder;
cloneData.ColumnOrder = downOrder;
DataGridLists.ElementAt(index + 1).ColumnOrder = currentOrder;
DataGridLists.RemoveAt(index);
index++;
DataGridLists.Insert(index, cloneData);
DataGridSelectedItem = cloneData;
});
}
private void ModifyOilSampleEntry(object obj)
{
if (OilSampleEntrySelectedItem != null)
{
OilSampleEntryModifyView edit = new OilSampleEntryModifyView();
var cloneData = ObjectDeepCopyHelper <OilSampleEntryModel, OilSampleEntryModel> .Trans(OilSampleEntrySelectedItem);
(edit.DataContext as OilSampleEntryModifyViewModel).WithParam(cloneData, (type, entry) =>
{
edit.Close();
if (type == 1)
{
OilSampleEntrySelectedItem.CurrencyPrintCount = entry.CurrencyPrintCount;
OilSampleEntrySelectedItem.WeightPerBucket = entry.WeightPerBucket;
OilSampleEntrySelectedItem.TotalWeight = entry.TotalWeight;
OilSampleEntrySelectedItem.PrintTotalCount = entry.PrintTotalCount;
OilSampleEntrySelectedItem.ProductionModel = entry.ProductionModel;
OilSampleEntrySelectedItem.ProductionName = entry.ProductionName;
}
});
edit.ShowDialog();
}
}
private void InitCommand()
{
QueryCommand = new DelegateCommand((obj) =>
{
CustomerSchedulingDetailLists.Clear();
Service.GetCustomerSchedulingDetailLists(Organization.Id, DateTime.Now.Date, Label).ForEach(x => CustomerSchedulingDetailLists.Add(x));
});
DataGridSaveCommand = new DelegateCommand((obj) =>
{
var data = OrgLabelLists.Where(x => x.Value1 > 0 || x.Value2 > 0 || x.Value3 > 0 || x.Value4 > 0 || x.Value5 > 0);
if (data.Count() > 0)
{
StringBuilder stringBuilder = new StringBuilder();
foreach (var item in data)
{
if (item.Value1 > 0)
{
stringBuilder.Append($",({item.OrgId},'{item.OrgCode}',{item.FItemId},'{item.Label}','{CustomerSchedulingDate.Date1}',{item.Value1},0)");
}
if (item.Value2 > 0)
{
stringBuilder.Append($",({item.OrgId},'{item.OrgCode}',{item.FItemId},'{item.Label}','{CustomerSchedulingDate.Date2}',{item.Value2},0)");
}
if (item.Value3 > 0)
{
stringBuilder.Append($",({item.OrgId},'{item.OrgCode}',{item.FItemId},'{item.Label}','{CustomerSchedulingDate.Date3}',{item.Value3},0)");
}
if (item.Value4 > 0)
{
stringBuilder.Append($",({item.OrgId},'{item.OrgCode}',{item.FItemId},'{item.Label}','{CustomerSchedulingDate.Date4}',{item.Value4},0)");
}
if (item.Value5 > 0)
{
stringBuilder.Append($",({item.OrgId},'{item.OrgCode}',{item.FItemId},'{item.Label}','{CustomerSchedulingDate.Date5}',{item.Value5},0)");
}
}
string sql = " insert into SJCustomerSchedulingDetail(OrgId,OrgCode,FItemId,Label,DeliveryDate,DeliveryQty,SEOutStockEntryUId)values" + stringBuilder.ToString().Substring(1);
if (Service.BatchInsert(sql))
{
IsChanged = true;
}
}
else
{
MessageBox.Show("没有填写正确的数据");
}
});
SelectionChangedCommand = new DelegateCommand((obj) =>
{
if (OrgLabelSelectedItem != null)
{
CustomerSchedulingDetailSelectedItem = null;
foreach (var item in CustomerSchedulingDetailLists)
{
if (item.Label == OrgLabelSelectedItem.Label && item.FItemId == OrgLabelSelectedItem.FItemId)
{
item.IsChangeBG = true;
}
else
{
item.IsChangeBG = false;
}
}
}
});
ModifyCommand = new DelegateCommand((obj) =>
{
if (CustomerSchedulingDetailSelectedItem != null)
{
CustomerSchedulingDetailCreateView view = new CustomerSchedulingDetailCreateView();
var cloneData = ObjectDeepCopyHelper <CustomerSchedulingDetailModel, CustomerSchedulingDetailModel> .Trans(CustomerSchedulingDetailSelectedItem);
(view.DataContext as CustomerSchedulingDetailCreateViewModel).WithParam(cloneData, (type, outputEntity) =>
{
view.Close();
if (type == 1)
{
if (Service.CustomerSchedulingDetailUpdate(outputEntity))
{
CustomerSchedulingDetailSelectedItem.DeliveryDate = outputEntity.DeliveryDate;
CustomerSchedulingDetailSelectedItem.DeliveryQty = outputEntity.DeliveryQty;
IsChanged = true;
}
}
});
view.ShowDialog();
}
else
{
MessageBox.Show("先选择交期数据行");
}
});
DeleteCommand = new DelegateCommand((obj) =>
{
if (CustomerSchedulingDetailSelectedItem != null)
{
if (MessageBox.Show($"确认删除数据 \n\r\t 客户：【 {Organization.SearchText} 】 \n\r\t 标签：【{CustomerSchedulingDetailSelectedItem.Label}】 \n\r\t 交货日期：【{CustomerSchedulingDetailSelectedItem.DeliveryDate:yyyy-MM-dd}】 \n\r\t 数量：【{CustomerSchedulingDetailSelectedItem.DeliveryQty}】", "温馨提示", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
if (Service.CustomerSchedulingDetailDelete(CustomerSchedulingDetailSelectedItem))
{
CustomerSchedulingDetailLists.Remove(CustomerSchedulingDetailSelectedItem);
IsChanged = true;
}
}
}
else
{
MessageBox.Show("先选择交期数据行");
}
});
}
private void InitCommand()
{
SaveCommand = new DelegateCommand((obj) =>
{
//验证数据是否异常
var r = CommonAdjustmentLists.GroupBy(x => new { x.TypeId, x.OrgId, x.Label }).Select(x => new { Rc = x.Count() });
if (!r.Any(x => x.Rc > 1))
{
// 将界面数据插入到后台
CommonService.LoadIEnumerableToDatabase2(CommonAdjustmentLists, "SJPrintCommonAdjustment", true);
// 将之前的后台数据删除
var ids = string.Join(",", CommonAdjustmentLists.Where(x => x.Id > 0).Select(x => x.Id));
if (!string.IsNullOrEmpty(ids))
{
LabelPrintService.DeletePrintCommonAdjustment(ids);
}
QueryBaseCommand.Execute(null);
}
else
{
MessageBox.Show("类型+客户+标签 必须唯一");
}
});
RemoveCommand = new DelegateCommand((obj) =>
{
if (PrintCommonAdjustmentSelectedItem != null)
{
int id = PrintCommonAdjustmentSelectedItem.Id;
CommonAdjustmentLists.Remove(PrintCommonAdjustmentSelectedItem);
if (id > 0)
{
LabelPrintService.DeletePrintCommonAdjustment(id);
}
}
});
CopyCommand = new DelegateCommand((obj) =>
{
var cloneData = PrintCommonAdjustmentSelectedItem == null ? new PrintCommonAdjustmentModel() : ObjectDeepCopyHelper <PrintCommonAdjustmentModel, PrintCommonAdjustmentModel> .Trans(PrintCommonAdjustmentSelectedItem);
cloneData.Id = 0;
CommonAdjustmentLists.Insert(0, cloneData);
});
QueryBaseCommand = new DelegateCommand((obj) =>
{
CommonAdjustmentLists.Clear();
LabelPrintService.GetLists(CommonService.GetSqlWhereString(QueryParameter)).ForEach(x => CommonAdjustmentLists.Add(x));
});
}
private void InitCommand()
{
QueryBaseCommand = new DelegateCommand((obj) =>
{
AmountRangeString = "";
SalesRebateRecentParameterLists.Clear();
SalesRebateService.GetSalesRebateOrgRecentParameterLists(CommonService.GetSqlWhereString(QueryParameter)).ForEach(x => SalesRebateRecentParameterLists.Add(x));
});
QueryCommand = new DelegateCommand((obj) =>
{
SalesRebateK3RecordParameterLists.Clear();
SalesRebateService.GetSalesRebateK3RecordParameterLists(CommonService.GetSqlWhereString(QueryParameter1)).ForEach(x => SalesRebateK3RecordParameterLists.Add(x));
});
DoubleClickModifyCommand = new DelegateCommand((obj) =>
{
if (SalesRebateRecentParameterSelectedItem != null)
{
IsChanged = true;
var cloneData = ObjectDeepCopyHelper <SalesRebateRecentParameterMainModel, SalesRebateRecentParameterMainModel> .Trans(SalesRebateRecentParameterSelectedItem);
SalesRebateRecentParameterModifyView view = new SalesRebateRecentParameterModifyView();
(view.DataContext as SalesRebateRecentParameterModifyViewModel).WithParam(cloneData, (type, outputEntity) =>
{
view.Close();
if (type == 1)
{
SalesRebateService.RecentParameterUpdate(outputEntity);
QueryBaseCommand.Execute(null);
}
});
view.ShowDialog();
}
});
RecentParameterClearCommand = new DelegateCommand((obj) =>
{
var selectedItems = (obj as DataGrid).SelectedItems;
if (selectedItems.Count > 0)
{
IsChanged = true;
StringBuilder stringBuilder = new StringBuilder();
foreach (SalesRebateRecentParameterMainModel item in selectedItems)
{
stringBuilder.Append($",'{item.Guid}'");
}
string guids = stringBuilder.ToString().Substring(1);
SalesRebateService.ClearRecentMainParameter(guids);
QueryBaseCommand.Execute(null);
}
else
{
MessageBox.Show("必须先选择一行或多行");
}
});
RecentParameterCopyCommand = new DelegateCommand((obj) =>
{
var selectedItems = (obj as DataGrid).SelectedItems;
if (selectedItems.Count == 2)
{
IsChanged = true;
var first = selectedItems[0] as SalesRebateRecentParameterMainModel;
var last = selectedItems[1] as SalesRebateRecentParameterMainModel;
if ((last.IsPassed && !first.IsPassed))
{
SalesRebateService.SalesRebateParameterCopy(first.Id, last.Id, first.Guid, last.Guid, 1);
QueryBaseCommand.Execute(null);
}
else if (!last.IsPassed && first.IsPassed)
{
SalesRebateService.SalesRebateParameterCopy(last.Id, first.Id, last.Guid, first.Guid, 1);
QueryBaseCommand.Execute(null);
}
else if (last.IsPassed && first.IsPassed)
{
MessageBox.Show("所选行的参数都已通过验证，请先选择一行【清空参数】");
}
else
{
MessageBox.Show("必须有一行参数是已通过验证,用来覆盖先选的");
}
}
else
{
MessageBox.Show("每次只能选择2行，【后选的行】参数 覆盖 【先选的行】");
}
});
K3RecordParameterCopyCommand = new DelegateCommand((obj) =>
{
var selectedItems = (obj as DataGrid).SelectedItems;
if (selectedItems.Count == 1)
{
if (!SalesRebateRecentParameterSelectedItem.IsPassed)
{
if (SalesRebateK3RecordParameterSelectedItem != null)
{
IsChanged = true;
SalesRebateService.SalesRebateParameterCopy(SalesRebateRecentParameterSelectedItem.Id, SalesRebateK3RecordParameterSelectedItem.Id, SalesRebateRecentParameterSelectedItem.Guid, SalesRebateK3RecordParameterSelectedItem.Guid, 2);
QueryBaseCommand.Execute(null);
}
else
{
MessageBox.Show("需要选择一行历史参数，【历史待选的行】参数 覆盖 【当前参数】");
}
}
else
{
MessageBox.Show("已通过验证的行参数不能被覆盖，请先【清空参数】");
}
}
else
{
MessageBox.Show("只能选择一行被复制的行，【历史待选的行】参数 覆盖 【当前参数】");
}
});
SelectionChangedCommand = new DelegateCommand((obj) =>
{
if (obj != null)
{
var model = obj as SalesRebateRecentParameterMainModel;
if (model.RebatePctType == 2)
{
var lists = SalesRebateAmountRangeService.GetSalesRebateAmountRangeRecentParameterLists(model.PGuid);
StringBuilder result = new StringBuilder();
foreach (var item in lists)
{
result.Append($"金额区间：{item.AmountLower}-{item.AmountUpper} 万元 比例：{item.SalesRebatePctValue}% \t\t");
}
AmountRangeString = result.ToString();
}
else
{
AmountRangeString = string.Empty;
}
}
});
}
private void InitCommand()
{
SaveCommand = new DelegateCommand((obj) =>
{
CommonService.LoadIEnumerableToDatabase(DataGridLists, "SJDataGridColumnHeaderTemplate");
// 修改后台数据
if (_service.BatchUpdate())
{
QueryCommand.Execute(null);
}
});
NewCommand = new DelegateCommand((obj) =>
{
DataGridColumnHeaderModel inputEntity = DataGridSelectedItem == null? new DataGridColumnHeaderModel {
MainMenuId = Menu.ID, ColumnOrder = 1000, ColumnWidth = 120
} : ObjectDeepCopyHelper <DataGridColumnHeaderModel, DataGridColumnHeaderModel> .Trans(DataGridSelectedItem);
inputEntity.ColumnOrder++;
DataGridColumnAddWindow view = new DataGridColumnAddWindow();
(view.DataContext as DataGridColumnAddViewModel).WithParam(inputEntity, (type, outputEntity) =>
{
view.Close();
if (type == 1)
{
if (_service.Insert(outputEntity))
{
QueryCommand.Execute(null);
}
}
});
view.ShowDialog();
});
MoveUpCommand = new DelegateCommand((obj) =>
{
var cloneData = ObjectDeepCopyHelper <DataGridColumnHeaderModel, DataGridColumnHeaderModel> .Trans(DataGridSelectedItem);
int index = DataGridLists.IndexOf(DataGridSelectedItem);
if (index == 0)
{
return;
}
int upOrder = DataGridLists.ElementAt(index - 1).ColumnOrder;
int currentOrder = DataGridSelectedItem.ColumnOrder;
cloneData.ColumnOrder = upOrder;
DataGridLists.ElementAt(index - 1).ColumnOrder = currentOrder;
DataGridLists.RemoveAt(index);
index--;
DataGridLists.Insert(index, cloneData);
DataGridSelectedItem = cloneData;
});
MoveDownCommand = new DelegateCommand((obj) =>
{
var cloneData = ObjectDeepCopyHelper <DataGridColumnHeaderModel, DataGridColumnHeaderModel> .Trans(DataGridSelectedItem);
int index = DataGridLists.IndexOf(DataGridSelectedItem);
if (index == DataGridLists.Count - 1)
{
return;
}
int downOrder = DataGridLists.ElementAt(index + 1).ColumnOrder;
int currentOrder = DataGridSelectedItem.ColumnOrder;
cloneData.ColumnOrder = downOrder;
DataGridLists.ElementAt(index + 1).ColumnOrder = currentOrder;
DataGridLists.RemoveAt(index);
index++;
DataGridLists.Insert(index, cloneData);
DataGridSelectedItem = cloneData;
});
QueryCommand = new DelegateCommand((obj) =>
{
DataGridLists.Clear();
_service.GetDataGridLists(CommonService.GetSqlWhereString(QueryParameter)).ForEach(x => DataGridLists.Add(x));
});
}
