private void BtnDel_Click(object sender, RoutedEventArgs e)
{
RsRoutingDetail m_RsRoutingDetail = gbItemContent.DataContext as RsRoutingDetail;
if (m_RsRoutingDetail == null)
{
return;
}
RsRoutingTools routingTools = gridTools.SelectedItem as RsRoutingTools;
if (routingTools == null)
{
return;
}
if (
System.Windows.Forms.MessageBox.Show($"确定要删除工序所需要的刀具{routingTools.TOOLS_NC_CODE}", "删除",
MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
ws.UseService(s => s.DelRsRoutingTools(routingTools.PKNO));
gridTools.ItemsSource =
ws.UseService(s => s.GetRsRoutingToolss($"ROUTING_DETAIL_PKNO = '{m_RsRoutingDetail.PKNO}"));
}
/// <summary>
/// 根据关键字段的值获取记录
/// </summary>
/// <param name="Id">关键字段的值</param>
/// <returns>符合查询条件的记录</returns>
public RsRoutingTools GetRsRoutingToolsById(string Id)
{
using (IRsRoutingToolsBLL RsRoutingToolsBLL = BLLContainer.Resolve <IRsRoutingToolsBLL>())
{
RsRoutingTools model = RsRoutingToolsBLL.GetFirstOrDefault(Id);
return(model);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="mRsRoutingTools">模型</param>
/// <returns>是否成功</returns>
public bool UpdateRsRoutingTools(RsRoutingTools mRsRoutingTools)
{
if (mRsRoutingTools == null)
{
return(false);
}
using (IRsRoutingToolsBLL RsRoutingToolsBLL = BLLContainer.Resolve <IRsRoutingToolsBLL>())
{
return(RsRoutingToolsBLL.Update(mRsRoutingTools));
}
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Id">关键字段</param>
/// <returns>是否成功</returns>
public bool DelRsRoutingTools(string Id)
{
using (IRsRoutingToolsBLL RsRoutingToolsBLL = BLLContainer.Resolve <IRsRoutingToolsBLL>())
{
try
{
RsRoutingTools item = RsRoutingToolsBLL.GetFirstOrDefault(Id);
return(RsRoutingToolsBLL.Delete(item));
}
catch { return(false); }
}
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Ids">关键字段数组</param>
/// <returns>是否成功</returns>
public bool DelRsRoutingToolss(string[] Ids)
{
using (IRsRoutingToolsBLL RsRoutingToolsBLL = BLLContainer.Resolve <IRsRoutingToolsBLL>())
{
try
{
List <RsRoutingTools> entitys = new List <RsRoutingTools>();
foreach (string id in Ids)
{
RsRoutingTools item = RsRoutingToolsBLL.GetFirstOrDefault(id);
entitys.Add(item);
}
return(RsRoutingToolsBLL.Delete(entitys));
}
catch { return(false); }
}
}
private void gridItem_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
RsRoutingDetail m_RsRoutingDetail = gbItemContent.DataContext as RsRoutingDetail;
if (m_RsRoutingDetail == null)
{
return;
}
RsRoutingTools routingTools = gridTools.SelectedItem as RsRoutingTools;
if (routingTools == null)
{
return;
}
gridTools.IsEnabled = false;
dictToolsInfo.Visibility = Visibility.Visible;
dictToolsInfo.DataContext = routingTools;
}
private void BtnAdd_Click(object sender, RoutedEventArgs e)
{
RsRoutingDetail m_RsRoutingDetail = gbItemContent.DataContext as RsRoutingDetail;
if (m_RsRoutingDetail == null)
{
return;
}
gridTools.IsEnabled = false;
dictToolsInfo.Visibility = Visibility.Visible;
RsRoutingTools routingTools = new RsRoutingTools()
{
COMPANY_CODE = "",
ROUTING_DETAIL_PKNO = m_RsRoutingDetail.PKNO,
USE_FLAG = 1,
};
dictToolsInfo.DataContext = routingTools;
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
RsRoutingDetail m_RsRoutingDetail = gbItemContent.DataContext as RsRoutingDetail;
if (m_RsRoutingDetail == null)
{
return;
}
RsRoutingTools routingTools = dictToolsInfo.DataContext as RsRoutingTools;
if (routingTools == null)
{
return;
}
if (string.IsNullOrEmpty(routingTools.TOOLS_NC_CODE))
{
System.Windows.Forms.MessageBox.Show($"请输入NC程序对应的刀号", "保存", MessageBoxButtons.OK);
return;
}
if (string.IsNullOrEmpty(routingTools.TOOLS_TYPE_PKNO))
{
System.Windows.Forms.MessageBox.Show($"请选择刀具类型", "保存", MessageBoxButtons.OK);
return;
}
if (string.IsNullOrEmpty(routingTools.PKNO))
{
List <RsRoutingTools> sameToolsType =
ws.UseService(
s =>
s.GetRsRoutingToolss(
$"ROUTING_DETAIL_PKNO = '{m_RsRoutingDetail.PKNO}' AND TOOLS_TYPE_PKNO = '{routingTools.TOOLS_TYPE_PKNO} AND USE_FLAG = 1"));
if (sameToolsType.Count > 0)
{
System.Windows.Forms.MessageBox.Show($"该刀具类型{cmbToolsType.Text}已经存在不能再添加", "添加",
MessageBoxButtons.OK);
return;
}
List <RsRoutingTools> sameToolsType2 =
ws.UseService(
s =>
s.GetRsRoutingToolss(
$"ROUTING_DETAIL_PKNO = '{m_RsRoutingDetail.PKNO}' AND TOOLS_NC_CODE = '{routingTools.TOOLS_NC_CODE} AND USE_FLAG = 1"));
if (sameToolsType2.Count > 0)
{
System.Windows.Forms.MessageBox.Show($"该NC程序刀号{routingTools.TOOLS_NC_CODE}已经存在不能再添加", "添加",
MessageBoxButtons.OK);
return;
}
routingTools.PKNO = Guid.NewGuid().ToString("N");
routingTools.CREATED_BY = CBaseData.LoginName;
routingTools.CREATION_DATE = DateTime.Now;
routingTools.LAST_UPDATE_DATE = DateTime.Now; //最后修改日期
ws.UseService(s => s.AddRsRoutingTools(routingTools));
}
else
{
List <RsRoutingTools> sameToolsType =
ws.UseService(
s =>
s.GetRsRoutingToolss(
$"PKNO <> '{m_RsRoutingDetail.PKNO}' AND ROUTING_DETAIL_PKNO = '{m_RsRoutingDetail.PKNO}' AND TOOLS_TYPE_PKNO = '{routingTools.TOOLS_TYPE_PKNO} AND USE_FLAG = 1"));
if (sameToolsType.Count > 0)
{
System.Windows.Forms.MessageBox.Show($"该刀具类型{cmbToolsType.Text}已经存在不能修改为该类型", "修改",
MessageBoxButtons.OK);
return;
}
List <RsRoutingTools> sameToolsType2 =
ws.UseService(
s =>
s.GetRsRoutingToolss(
$"PKNO <> '{m_RsRoutingDetail.PKNO}' AND ROUTING_DETAIL_PKNO = '{m_RsRoutingDetail.PKNO}' AND TOOLS_NC_CODE = '{routingTools.TOOLS_NC_CODE} AND USE_FLAG = 1"));
if (sameToolsType2.Count > 0)
{
System.Windows.Forms.MessageBox.Show($"该NC程序刀号{routingTools.TOOLS_NC_CODE}已经存在不能再修改为该刀号", "修改",
MessageBoxButtons.OK);
return;
}
routingTools.UPDATED_BY = CBaseData.LoginName;
routingTools.LAST_UPDATE_DATE = DateTime.Now;
ws.UseService(s => s.UpdateRsRoutingTools(routingTools));
}
gridTools.IsEnabled = true;
dictToolsInfo.Visibility = Visibility.Collapsed;
gridTools.ItemsSource =
ws.UseService(s => s.GetRsRoutingToolss($"ROUTING_DETAIL_PKNO = '{m_RsRoutingDetail.PKNO}"));
}
