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); }