private void BtnItemAdd_Click(object sender, RoutedEventArgs e)
{
FmsActionFormulaMain main = tvMain.SelectedItem as FmsActionFormulaMain;
if ((main == null) || (string.IsNullOrEmpty(main.PKNO)))
{
return;
}
//添加明细
dictBasic.Header = "动作配方明细信息 【新增】";
gbItem.IsCollapsed = false;
gbItem.Visibility = Visibility.Visible;
List <FmsActionFormulaDetail> details = gridItem.ItemsSource as List <FmsActionFormulaDetail>;
FmsActionFormulaDetail detail = new FmsActionFormulaDetail()
{
FORMULA_CODE = main.FORMULA_CODE,
PROCESS_INDEX = (details?.Count + 1) ?? 1,
USE_FLAG = 1,
};
gbItem.DataContext = detail;
}
private void BtnItemUse_Click(object sender, RoutedEventArgs e)
{
FmsActionFormulaMain main = tvMain.SelectedItem as FmsActionFormulaMain;
if ((main == null) || (string.IsNullOrEmpty(main.PKNO)))
{
return;
}
//可用明细
FmsActionFormulaDetail detail = gridItem.SelectedItem as FmsActionFormulaDetail;
if (detail == null)
{
return;
}
if (WPFMessageBox.ShowConfirm($"确定[{BtnItemUse.Content}]动作配方明细信息【{detail.FORMULA_DETAIL_NAME}】吗？", @"删除信息") == WPFMessageBoxResult.OK)
{
detail.USE_FLAG = (detail.USE_FLAG == 1) ? 0 : 1;
ws.UseService(s => s.UpdateFmsActionFormulaDetail(detail));
//可用成功.
List <FmsActionFormulaDetail> details =
ws.UseService(s => s.GetFmsActionFormulaDetails($"FORMULA_CODE = {main.FORMULA_CODE} AND USE_FLAG >= 0"))
.OrderBy(c => c.PROCESS_INDEX)
.ToList();
gridItem.ItemsSource = details;
BindHelper.SetDictDataBindingGridItem(gbItem, gridItem);
}
}
//删除主信息，已禁用
private void BtnMainDel_Click(object sender, RoutedEventArgs e)
{
FmsActionFormulaMain main = tvMain.SelectedItem as FmsActionFormulaMain;
if ((main == null) || (string.IsNullOrEmpty(main.PKNO)))
{
return;
}
if (WPFMessageBox.ShowConfirm($"确定要删除该主配方[{main.FORMULA_NAME}]吗？", "删除") != WPFMessageBoxResult.OK)
{
return;
}
main.LAST_UPDATE_DATE = DateTime.Now;
main.UPDATED_BY = CBaseData.LoginNO;
main.UPDATED_INTROD = "删除";
main.USE_FLAG = -1; //已删除
ws.UseService(s => s.UpdateFmsActionFormulaMain(main));
List <FmsActionFormulaDetail> details = gridItem.ItemsSource as List <FmsActionFormulaDetail>;
if (details != null)
{
foreach (var detail in details)
{
detail.USE_FLAG = -1; //已删除
ws.UseService(s => s.UpdateFmsActionFormulaDetail(detail));
}
}
GetMainData();
}
/// <summary>
/// 根据关键字段的值获取记录
/// </summary>
/// <param name="Id">关键字段的值</param>
/// <returns>符合查询条件的记录</returns>
public FmsActionFormulaMain GetFmsActionFormulaMainById(string Id)
{
using (IFmsActionFormulaMainBLL FmsActionFormulaMainBLL = BLLContainer.Resolve <IFmsActionFormulaMainBLL>())
{
FmsActionFormulaMain model = FmsActionFormulaMainBLL.GetFirstOrDefault(Id);
return(model);
}
}
private void btnOK_Click(object sender, RoutedEventArgs e)
{
FmsActionFormulaMain main = gbInfo.DataContext as FmsActionFormulaMain;
if (main == null)
{
return;
}
#region 检验
if (string.IsNullOrEmpty(main.FORMULA_CODE))
{
WPFMessageBox.ShowError("请输入动作配方编码", "保存");
return;
}
var check = ws.UseService(s =>
s.GetFmsActionFormulaMains(
$"USE_FLAG = 1 AND FORMULA_CODE = '{main.FORMULA_CODE}' AND PKNO <> '{main.PKNO}'"));
if (check.Any())
{
WPFMessageBox.ShowError($"输入动作配方编码已经存在不能{(string.IsNullOrEmpty(main.PKNO) ? "新增" : "修改")}该编码，请核实", "保存");
return;
}
#endregion
if (string.IsNullOrEmpty(main.PKNO)) //新增
{
main.PKNO = CBaseData.NewGuid();
main.CREATION_DATE = DateTime.Now;
main.CREATED_BY = CBaseData.LoginName;
main.LAST_UPDATE_DATE = DateTime.Now; //最后修改日期
ws.UseService(s => s.AddFmsActionFormulaMain(main));
}
else
{
main.UPDATED_BY = CBaseData.LoginName;
main.LAST_UPDATE_DATE = DateTime.Now;
ws.UseService(s => s.UpdateFmsActionFormulaMain(main));
}
if (!string.IsNullOrEmpty(formulaCode))
{
string sql =
$"UPDATE FMS_ACTION_FORMULA_DETAIL SET FORMULA_CODE = '{main.FORMULA_CODE}' WHERE FORMULA_CODE = '{formulaCode}'";
WcfClient <ISQLService> wsSQL = new WcfClient <ISQLService>();
wsSQL.UseService(s => s.ExecuteSql(sql));
}
Close();
}
/// <summary>
/// 修改
/// </summary>
/// <param name="mFmsActionFormulaMain">模型</param>
/// <returns>是否成功</returns>
public bool UpdateFmsActionFormulaMain(FmsActionFormulaMain mFmsActionFormulaMain)
{
if (mFmsActionFormulaMain == null)
{
return(false);
}
using (IFmsActionFormulaMainBLL FmsActionFormulaMainBLL = BLLContainer.Resolve <IFmsActionFormulaMainBLL>())
{
return(FmsActionFormulaMainBLL.Update(mFmsActionFormulaMain));
}
}
private void BtnItemSave_Click(object sender, RoutedEventArgs e)
{
FmsActionFormulaMain main = tvMain.SelectedItem as FmsActionFormulaMain;
if ((main == null) || (string.IsNullOrEmpty(main.PKNO)))
{
return;
}
FmsActionFormulaDetail detail = gbItem.DataContext as FmsActionFormulaDetail;
if (detail == null)
{
return;
}
#region 校验
if (string.IsNullOrEmpty(detail.FORMULA_CODE))
{
WPFMessageBox.ShowWarring("请选择配方主信息。", "保存");
return;
}
if (string.IsNullOrEmpty(detail.FORMULA_DETAIL_NAME))
{
WPFMessageBox.ShowWarring("请输入配方明细名称。", "保存");
return;
}
#endregion
if (string.IsNullOrEmpty(detail.PKNO)) //新增
{
detail.PKNO = CBaseData.NewGuid();
ws.UseService(s => s.AddFmsActionFormulaDetail(detail));
//重新刷新数据
List <FmsActionFormulaDetail> details =
ws.UseService(s => s.GetFmsActionFormulaDetails($"FORMULA_CODE = {main.FORMULA_CODE} AND USE_FLAG >= 0"))
.OrderBy(c => c.PROCESS_INDEX)
.ToList();
gridItem.ItemsSource = details;
}
else //修改
{
ws.UseService(s => s.UpdateFmsActionFormulaDetail(detail));
}
//提示保存成功
gbItem.IsCollapsed = true;
gbItem.Visibility = Visibility.Collapsed;
BindHelper.SetDictDataBindingGridItem(gbItem, gridItem);
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Id">关键字段</param>
/// <returns>是否成功</returns>
public bool DelFmsActionFormulaMain(string Id)
{
using (IFmsActionFormulaMainBLL FmsActionFormulaMainBLL = BLLContainer.Resolve <IFmsActionFormulaMainBLL>())
{
try
{
FmsActionFormulaMain item = FmsActionFormulaMainBLL.GetFirstOrDefault(Id);
return(FmsActionFormulaMainBLL.Delete(item));
}
catch { return(false); }
}
}
private void BtnMainMod_Click(object sender, RoutedEventArgs e)
{
FmsActionFormulaMain main = tvMain.SelectedItem as FmsActionFormulaMain;
if ((main == null) || (string.IsNullOrEmpty(main.PKNO)))
{
return;
}
ActionFomulaMain mainEdit = new ActionFomulaMain(main);
mainEdit.ShowDialog();
GetMainData();
}
private void BtnMainAdd_Click(object sender, RoutedEventArgs e)
{
FmsActionFormulaMain main = new FmsActionFormulaMain()
{
PKNO = "",
//COMPANY_CODE = "",
USE_FLAG = 1,
};
ActionFomulaMain mainEdit = new ActionFomulaMain(main);
mainEdit.ShowDialog();
GetMainData();
}
public ActionFomulaMain(FmsActionFormulaMain formulaMain)
{
InitializeComponent();
if (formulaMain == null)
{
formulaMain = new FmsActionFormulaMain()
{
PKNO = "",
USE_FLAG = 1,
};
}
formulaCode = formulaMain.FORMULA_CODE;
gbInfo.DataContext = formulaMain;
}
private void BtnItemCopy_Click(object sender, RoutedEventArgs e)
{
FmsActionFormulaMain m_MainInfo = tvMain.SelectedItem as FmsActionFormulaMain;
if ((m_MainInfo == null) || (string.IsNullOrEmpty(m_MainInfo.PKNO)))
{
return;
}
List <FmsActionFormulaDetail> details = ws.UseService(s => s.GetFmsActionFormulaDetails("FORMULA_CODE = " + m_MainInfo.FORMULA_CODE + ""));
List <FmsActionFormulaDetail> newFormulaDetails = new List <FmsActionFormulaDetail>();
List <FmsActionControl> newFmsActionControls = new List <FmsActionControl>();
FmsActionFormulaMain newFormulaMain = m_MainInfo;
newFormulaMain.PKNO = Guid.NewGuid().ToString("N");
newFormulaMain.FORMULA_NAME = "轮毂生产5（只下料，中间件检测）";
newFormulaMain.FORMULA_CODE = "轮毂生产5 new";
foreach (FmsActionFormulaDetail item in details)
{
FmsActionControl action = ws.UseService(s => s.GetFmsActionControlById(item.PROCESS_ACTION_PKNO));
FmsActionControl newActionControlaction = action;
#region 处理actionControl
newActionControlaction.PKNO = Guid.NewGuid().ToString("N");
newActionControlaction.START_CONDITION_TAG_PKNO = GetTagPkno(newActionControlaction.START_CONDITION_TAG_PKNO);
newActionControlaction.EXECUTE_PARAM1_TAG_PKNO = GetTagPkno(newActionControlaction.EXECUTE_PARAM1_TAG_PKNO);
newActionControlaction.EXECUTE_PARAM2_TAG_PKNO = GetTagPkno(newActionControlaction.EXECUTE_PARAM2_TAG_PKNO);
newActionControlaction.EXECUTE_TAG_PKNO = GetTagPkno(newActionControlaction.EXECUTE_TAG_PKNO);
newActionControlaction.FINISH_CONDITION_TAG_PKNO = GetTagPkno(newActionControlaction.FINISH_CONDITION_TAG_PKNO);
#endregion
FmsActionFormulaDetail newActionFormulaDetail = item;
newActionFormulaDetail.PKNO = Guid.NewGuid().ToString("N");
newActionFormulaDetail.FORMULA_CODE = newFormulaMain.FORMULA_CODE;
newActionFormulaDetail.PROCESS_ACTION_PKNO = newActionControlaction.PKNO;
newFormulaDetails.Add(newActionFormulaDetail);
newFmsActionControls.Add(newActionControlaction);
}
foreach (var variable2 in newFormulaDetails)
{
ws.UseService(s => s.AddFmsActionFormulaDetail(variable2));
}
ws.UseService(s => s.AddFmsActionFormulaMain(newFormulaMain));
foreach (var variable1 in newFmsActionControls)
{
ws.UseService(s => s.AddFmsActionControl(variable1));
}
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Ids">关键字段数组</param>
/// <returns>是否成功</returns>
public bool DelFmsActionFormulaMains(string[] Ids)
{
using (IFmsActionFormulaMainBLL FmsActionFormulaMainBLL = BLLContainer.Resolve <IFmsActionFormulaMainBLL>())
{
try
{
List <FmsActionFormulaMain> entitys = new List <FmsActionFormulaMain>();
foreach (string id in Ids)
{
FmsActionFormulaMain item = FmsActionFormulaMainBLL.GetFirstOrDefault(id);
entitys.Add(item);
}
return(FmsActionFormulaMainBLL.Delete(entitys));
}
catch { return(false); }
}
}
private void BtnItemMod_Click(object sender, RoutedEventArgs e)
{
FmsActionFormulaMain main = tvMain.SelectedItem as FmsActionFormulaMain;
if ((main == null) || (string.IsNullOrEmpty(main.PKNO)))
{
return;
}
if (gridItem.SelectedItem == null)
{
return;
}
//修改明细
dictBasic.Header = "动作配方明细信息 【修改】";
gbItem.IsCollapsed = false;
gbItem.Visibility = Visibility.Visible;
}
private void GridItem_SelectionChanged(object sender, GridSelectionChangedEventArgs e)
{
FmsActionFormulaMain main = tvMain.SelectedItem as FmsActionFormulaMain;
if ((main == null) || (string.IsNullOrEmpty(main.PKNO)))
{
return;
}
FmsActionFormulaDetail detail = gridItem.SelectedItem as FmsActionFormulaDetail;
if (detail == null)
{
return;
}
BtnItemUse.Content = (detail.USE_FLAG == 1) ? "禁用" : "启用";
}
private void GridItem_SelectionChanged(object sender, GridSelectionChangedEventArgs e)
{
FmsActionFormulaMain main = tvMain.SelectedItem as FmsActionFormulaMain;
if ((main == null) || (string.IsNullOrEmpty(main.PKNO)))
{
return;
}
FmsActionFormulaDetail detail = gridItem.SelectedItem as FmsActionFormulaDetail;
if (detail == null)
{
return;
}
BtnItemUse.Content = (detail.USE_FLAG == 1) ? "禁用" : "启用";
FmsActionControl action = ws.UseService(s => s.GetFmsActionControlById(detail.PROCESS_ACTION_PKNO));
if (action == null)
{
cmbCondition.SelectedValue = null;
tbConditionValue.Text = "";
cmbExecute.SelectedValue = null;
tbExecuteValue.Text = "";
cmbParam1.SelectedValue = null;
cmbParam2.SelectedValue = null;
cmbFinish.SelectedValue = null;
tbFinishValue.Text = "";
}
else
{
cmbCondition.SelectedValue = action.START_CONDITION_TAG_PKNO;
tbConditionValue.Text = action.START_CONDITION_VALUE;
cmbExecute.SelectedValue = action.EXECUTE_TAG_PKNO;
tbExecuteValue.Text = action.EXECUTE_WRITE_VALUE;
cmbParam1.SelectedValue = action.EXECUTE_PARAM1_TAG_PKNO;
cmbParam2.SelectedValue = action.EXECUTE_PARAM2_TAG_PKNO;
cmbFinish.SelectedValue = action.FINISH_CONDITION_TAG_PKNO;
tbFinishValue.Text = action.FINISH_CONDITION_VALUE;
}
}
private void tvMain_SelectedItemChanged(object sender, SelectedItemChangedEventArgs e)
{
FmsActionFormulaMain m_MainInfo = tvMain.SelectedItem as FmsActionFormulaMain;
if ((m_MainInfo == null) || (string.IsNullOrEmpty(m_MainInfo.PKNO)))
{
gridItem.ItemsSource = null;
return;
}
List <FmsActionFormulaDetail> mFormulaDetails =
ws.UseService(s => s.GetFmsActionFormulaDetails($"FORMULA_CODE = {m_MainInfo.FORMULA_CODE} AND USE_FLAG >= 0"))
.OrderBy(c => c.PROCESS_INDEX)
.ToList();
gridItem.ItemsSource = mFormulaDetails;
gbItem.IsCollapsed = true;
gbItem.Visibility = Visibility.Collapsed;
}
private void BtnItemSave_Click(object sender, RoutedEventArgs e)
{
FmsActionFormulaMain main = tvMain.SelectedItem as FmsActionFormulaMain;
if ((main == null) || (string.IsNullOrEmpty(main.PKNO)))
{
return;
}
FmsActionFormulaDetail detail = gbItem.DataContext as FmsActionFormulaDetail;
if (detail == null)
{
return;
}
#region 校验
if (string.IsNullOrEmpty(detail.FORMULA_CODE))
{
WPFMessageBox.ShowWarring("请选择配方主信息。", "保存");
return;
}
if (string.IsNullOrEmpty(detail.FORMULA_DETAIL_NAME))
{
WPFMessageBox.ShowWarring("请输入配方明细名称。", "保存");
return;
}
#endregion
if (string.IsNullOrEmpty(detail.PKNO)) //新增
{
detail.PKNO = CBaseData.NewGuid();
FmsActionControl action = new FmsActionControl()
{
PKNO = CBaseData.NewGuid(),
ACTION_NAME = detail.FORMULA_DETAIL_NAME,
ACTION_TYPE = detail.PROCESS_ACTION_TYPE.ToString(),
START_CONDITION_TAG_PKNO = string.IsNullOrEmpty(cmbCondition.Text)? "": cmbCondition.SelectedValue.ToString(),
START_CONDITION_VALUE = tbConditionValue.Text,
EXECUTE_TAG_PKNO = string.IsNullOrEmpty(cmbExecute.Text) ? "" : cmbExecute.SelectedValue.ToString(),
EXECUTE_WRITE_VALUE = tbExecuteValue.Text,
EXECUTE_PARAM1_TAG_PKNO = string.IsNullOrEmpty(cmbParam1.Text) ? "" : cmbParam1.SelectedValue.ToString(),
EXECUTE_PARAM2_TAG_PKNO = string.IsNullOrEmpty(cmbParam2.Text) ? "" : cmbParam2.SelectedValue.ToString(),
FINISH_CONDITION_TAG_PKNO = string.IsNullOrEmpty(cmbFinish.Text) ? "" : cmbFinish.SelectedValue.ToString(),
FINISH_CONDITION_VALUE = tbFinishValue.Text,
};
detail.PROCESS_ACTION_PKNO = action.PKNO;
ws.UseService(s => s.AddFmsActionControl(action));
ws.UseService(s => s.AddFmsActionFormulaDetail(detail));
//重新刷新数据
List <FmsActionFormulaDetail> details =
ws.UseService(s => s.GetFmsActionFormulaDetails($"FORMULA_CODE = {main.FORMULA_CODE} AND USE_FLAG >= 0"))
.OrderBy(c => c.PROCESS_INDEX)
.ToList();
gridItem.ItemsSource = details;
}
else //修改
{
FmsActionControl action = ws.UseService(s => s.GetFmsActionControlById(detail.PROCESS_ACTION_PKNO));
if (action == null)
{
action = new FmsActionControl()
{
PKNO = CBaseData.NewGuid(),
ACTION_NAME = detail.FORMULA_DETAIL_NAME,
ACTION_TYPE = detail.PROCESS_ACTION_TYPE.ToString(),
START_CONDITION_TAG_PKNO = string.IsNullOrEmpty(cmbCondition.Text) ? "" : cmbCondition.SelectedValue.ToString(),
START_CONDITION_VALUE = tbConditionValue.Text,
EXECUTE_TAG_PKNO = string.IsNullOrEmpty(cmbExecute.Text) ? "" : cmbExecute.SelectedValue.ToString(),
EXECUTE_WRITE_VALUE = tbExecuteValue.Text,
EXECUTE_PARAM1_TAG_PKNO = string.IsNullOrEmpty(cmbParam1.Text) ? "" : cmbParam1.SelectedValue.ToString(),
EXECUTE_PARAM2_TAG_PKNO = string.IsNullOrEmpty(cmbParam2.Text) ? "" : cmbParam2.SelectedValue.ToString(),
FINISH_CONDITION_TAG_PKNO = string.IsNullOrEmpty(cmbFinish.Text) ? "" : cmbFinish.SelectedValue.ToString(),
FINISH_CONDITION_VALUE = tbFinishValue.Text,
};
detail.PROCESS_ACTION_PKNO = action.PKNO;
ws.UseService(s => s.AddFmsActionControl(action));
}
else //修改控制
{
action.ACTION_NAME = detail.FORMULA_DETAIL_NAME;
action.ACTION_TYPE = detail.PROCESS_ACTION_TYPE.ToString();
action.START_CONDITION_TAG_PKNO = string.IsNullOrEmpty(cmbCondition.Text)
? ""
: cmbCondition.SelectedValue.ToString();
action.START_CONDITION_VALUE = tbConditionValue.Text;
action.EXECUTE_TAG_PKNO =
string.IsNullOrEmpty(cmbExecute.Text) ? "" : cmbExecute.SelectedValue.ToString();
action.EXECUTE_WRITE_VALUE = tbExecuteValue.Text;
action.EXECUTE_PARAM1_TAG_PKNO =
string.IsNullOrEmpty(cmbParam1.Text) ? "" : cmbParam1.SelectedValue.ToString();
action.EXECUTE_PARAM2_TAG_PKNO =
string.IsNullOrEmpty(cmbParam2.Text) ? "" : cmbParam2.SelectedValue.ToString();
action.FINISH_CONDITION_TAG_PKNO =
string.IsNullOrEmpty(cmbFinish.Text) ? "" : cmbFinish.SelectedValue.ToString();
action.FINISH_CONDITION_VALUE = tbFinishValue.Text;
ws.UseService(s => s.UpdateFmsActionControl(action));
}
ws.UseService(s => s.UpdateFmsActionFormulaDetail(detail));
}
//保存成功
gbItem.IsCollapsed = true;
gbItem.Visibility = Visibility.Collapsed;
BindHelper.SetDictDataBindingGridItem(gbItem, gridItem);
}
