/// <summary>
/// 根据关键字段的值获取记录
/// </summary>
/// <param name="Id">关键字段的值</param>
/// <returns>符合查询条件的记录</returns>
public RsRoutingItem GetRsRoutingItemById(string Id)
{
using (IRsRoutingItemBLL RsRoutingItemBLL = BLLContainer.Resolve <IRsRoutingItemBLL>())
{
RsRoutingItem model = RsRoutingItemBLL.GetFirstOrDefault(Id);
return(model);
}
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
//保存
RsRoutingHead m_RsRoutingHead = gbItem.DataContext as RsRoutingHead;
if (m_RsRoutingHead == null)
{
return;
}
if (string.IsNullOrEmpty(m_RsRoutingHead.PKNO)) //新增
{
m_RsRoutingHead.PKNO = Guid.NewGuid().ToString("N");
m_RsRoutingHead.CREATION_DATE = DateTime.Now;
m_RsRoutingHead.LAST_UPDATE_DATE = DateTime.Now; //最后修改日期
m_RsRoutingHead.CREATED_BY = CBaseData.LoginName;
//关系中间表RsRoutingItem插入信息
if (m_RsItemMaster != null)
{
RsRoutingItem m_RsRoutingItem = new RsRoutingItem();
m_RsRoutingItem.PKNO = Guid.NewGuid().ToString("N");
m_RsRoutingItem.ITEM_PKNO = m_RsItemMaster.PKNO;
m_RsRoutingItem.ROUTING_PKNO = m_RsRoutingHead.PKNO;
m_RsRoutingItem.CREATION_DATE = DateTime.Now;
m_RsRoutingItem.LAST_UPDATE_DATE = DateTime.Now; //最后修改日期
m_RsRoutingItem.CREATED_BY = CBaseData.LoginName;
ws.UseService(s => s.AddRsRoutingItem(m_RsRoutingItem));
}
ws.UseService(s => s.AddRsRoutingHead(m_RsRoutingHead));
}
else //修改
{
m_RsRoutingHead.LAST_UPDATE_DATE = DateTime.Now;
m_RsRoutingHead.UPDATED_BY = CBaseData.LoginName;
ws.UseService(s => s.UpdateRsRoutingHead(m_RsRoutingHead));
if (m_RsItemMaster != null)
{
RsRoutingItem m_RsRoutingItem = new RsRoutingItem();
m_RsRoutingItem.PKNO = Guid.NewGuid().ToString("N");
m_RsRoutingItem.ITEM_PKNO = m_RsItemMaster.PKNO;
m_RsRoutingItem.ROUTING_PKNO = m_RsRoutingHead.PKNO;
m_RsRoutingItem.CREATION_DATE = DateTime.Now;
m_RsRoutingItem.LAST_UPDATE_DATE = DateTime.Now; //最后修改日期
m_RsRoutingItem.CREATED_BY = CBaseData.LoginName;
ws.UseService(s => s.AddRsRoutingItem(m_RsRoutingItem));
}
}
Initialize(); //重新加载
gbItem.IsCollapsed = true;
gbItem.Visibility = Visibility.Collapsed;
BindHelper.SetDictDataBindingGridItem(gbItem, gridItem);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="mRsRoutingItem">模型</param>
/// <returns>是否成功</returns>
public bool UpdateRsRoutingItem(RsRoutingItem mRsRoutingItem)
{
if (mRsRoutingItem == null)
{
return(false);
}
using (IRsRoutingItemBLL RsRoutingItemBLL = BLLContainer.Resolve <IRsRoutingItemBLL>())
{
return(RsRoutingItemBLL.Update(mRsRoutingItem));
}
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Id">关键字段</param>
/// <returns>是否成功</returns>
public bool DelRsRoutingItem(string Id)
{
using (IRsRoutingItemBLL RsRoutingItemBLL = BLLContainer.Resolve <IRsRoutingItemBLL>())
{
try
{
RsRoutingItem item = RsRoutingItemBLL.GetFirstOrDefault(Id);
return(RsRoutingItemBLL.Delete(item));
}
catch { return(false); }
}
}
private void ListBoxEdit_SelectedIndexChanged(object sender, RoutedEventArgs e)
{
gridProcessInfo.ItemsSource = null;
ListBoxEdit lstbox = sender as ListBoxEdit;
if (lstbox.SelectedIndex == 0)
{
txt_name.Text = "16寸轮毂";
RsRoutingHead mRsRoutingHead = wsRSM.UseService(s => s.GetRsRoutingHeads("ROUTING_ABV = 16LG")).FirstOrDefault();
if (mRsRoutingHead != null)
{
getRouting(mRsRoutingHead.PKNO);
RsRoutingItem mRsRoutingItem = wsRSM.UseService(s => s.GetRsRoutingItems("ROUTING_PKNO = " + mRsRoutingHead.PKNO + "")).FirstOrDefault();
if (mRsRoutingItem != null)
{
mRoutingItem = mRsRoutingItem;
}
}
}
if (lstbox.SelectedIndex == 1)
{
txt_name.Text = "17寸轮毂";
RsRoutingHead mRsRoutingHead = wsRSM.UseService(s => s.GetRsRoutingHeads("ROUTING_ABV = 17LG")).FirstOrDefault();
if (mRsRoutingHead != null)
{
getRouting(mRsRoutingHead.PKNO);
RsRoutingItem mRsRoutingItem = wsRSM.UseService(s => s.GetRsRoutingItems("ROUTING_PKNO = " + mRsRoutingHead.PKNO + "")).FirstOrDefault();
if (mRsRoutingItem != null)
{
mRoutingItem = mRsRoutingItem;
}
}
}
if (lstbox.SelectedIndex == 2)
{
txt_name.Text = "18寸轮毂";
RsRoutingHead mRsRoutingHead = wsRSM.UseService(s => s.GetRsRoutingHeads("ROUTING_ABV = 18LG")).FirstOrDefault();
if (mRsRoutingHead != null)
{
getRouting(mRsRoutingHead.PKNO);
RsRoutingItem mRsRoutingItem = wsRSM.UseService(s => s.GetRsRoutingItems("ROUTING_PKNO = " + mRsRoutingHead.PKNO + "")).FirstOrDefault();
if (mRsRoutingItem != null)
{
mRoutingItem = mRsRoutingItem;
}
}
}
}
/// <summary>
/// 按照关键字段删除
/// </summary>
/// <param name="Ids">关键字段数组</param>
/// <returns>是否成功</returns>
public bool DelRsRoutingItems(string[] Ids)
{
using (IRsRoutingItemBLL RsRoutingItemBLL = BLLContainer.Resolve <IRsRoutingItemBLL>())
{
try
{
List <RsRoutingItem> entitys = new List <RsRoutingItem>();
foreach (string id in Ids)
{
RsRoutingItem item = RsRoutingItemBLL.GetFirstOrDefault(id);
entitys.Add(item);
}
return(RsRoutingItemBLL.Delete(entitys));
}
catch { return(false); }
}
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
//保存
RsItemMaster m_RsItemMaster = gbItem.DataContext as RsItemMaster;
if (m_RsItemMaster == null)
{
return;
}
if (string.IsNullOrEmpty(m_RsItemMaster.PKNO)) //新增
{
m_RsItemMaster.PKNO = Guid.NewGuid().ToString("N");
m_RsItemMaster.NORM_CLASS = ConvertNormEnum(comboNorm.Text);
m_RsItemMaster.CREATION_DATE = DateTime.Now;
m_RsItemMaster.CREATED_BY = CBaseData.LoginName;
m_RsItemMaster.LAST_UPDATE_DATE = DateTime.Now; //最后修改日期
ws.UseService(s => s.AddRsItemMaster(m_RsItemMaster));
//关系中间表RsRoutingItem插入信息
RsRoutingItem m_RsRoutingItem = new RsRoutingItem();
m_RsRoutingItem.PKNO = Guid.NewGuid().ToString("N");
m_RsRoutingItem.ITEM_PKNO = m_RsItemMaster.PKNO;
m_RsRoutingItem.CREATION_DATE = DateTime.Now;
m_RsRoutingItem.LAST_UPDATE_DATE = DateTime.Now; //最后修改日期
m_RsRoutingItem.CREATED_BY = CBaseData.LoginName;
RsRoutingHead m_RsRoutingHead = combo_routing.SelectedItem as RsRoutingHead;
if (m_RsRoutingHead != null)
{
m_RsRoutingItem.ROUTING_PKNO = m_RsRoutingHead.PKNO;
ws.UseService(s => s.AddRsRoutingItem(m_RsRoutingItem));
}
}
else //修改
{
m_RsItemMaster.NORM_CLASS = ConvertNormEnum(comboNorm.Text);
m_RsItemMaster.LAST_UPDATE_DATE = DateTime.Now;
m_RsItemMaster.UPDATED_BY = CBaseData.LoginName;
ws.UseService(s => s.UpdateRsItemMaster(m_RsItemMaster));
//关系中间表RsRoutingItem修改信息
List <RsRoutingItem> m_RsRoutingItems = ws.UseService(s => s.GetRsRoutingItems(" ITEM_PKNO = " + m_RsItemMaster.PKNO + ""));
if (m_RsRoutingItems.Count > 0)
{
RsRoutingHead m_RsRoutingHead = combo_routing.SelectedItem as RsRoutingHead;
if (m_RsRoutingHead != null)
{
m_RsRoutingItems[0].ROUTING_PKNO = m_RsRoutingHead.PKNO;
}
ws.UseService(s => s.UpdateRsRoutingItem(m_RsRoutingItems[0]));
}
else
{
//关系中间表RsRoutingItem插入信息
RsRoutingItem m_RsRoutingItem = new RsRoutingItem();
m_RsRoutingItem.PKNO = Guid.NewGuid().ToString("N");
m_RsRoutingItem.ITEM_PKNO = m_RsItemMaster.PKNO;
m_RsRoutingItem.CREATION_DATE = DateTime.Now;
m_RsRoutingItem.LAST_UPDATE_DATE = DateTime.Now; //最后修改日期
m_RsRoutingItem.CREATED_BY = CBaseData.LoginName;
RsRoutingHead m_RsRoutingHead = combo_routing.SelectedItem as RsRoutingHead;
if (m_RsRoutingHead != null)
{
m_RsRoutingItem.ROUTING_PKNO = m_RsRoutingHead.PKNO;
ws.UseService(s => s.AddRsRoutingItem(m_RsRoutingItem));
}
}
}
GetPage(); //重新加载
gbItem.IsCollapsed = true;
gbItem.Visibility = Visibility.Collapsed;
BindHelper.SetDictDataBindingGridItem(gbItem, gridItem);
}
