public static void DeletePoItembyPoItemId(int poItemId)
{
poitems item = poEntity.poitems.Where(i => i.PoItemsId == poItemId).First();
poEntity.poitems.DeleteObject(item);
poEntity.SaveChanges();
}
/// <summary>
/// 创建新的 poitems 对象。
/// </summary>
/// <param name="poItemsId">PoItemsId 属性的初始值。</param>
public static poitems Createpoitems(global::System.Int32 poItemsId)
{
poitems poitems = new poitems();
poitems.PoItemsId = poItemsId;
return(poitems);
}
public static void UpdatePoItem(poitems poItem)
{
poitems item = poEntity.poitems.Where(pitem => (pitem.poItemsId == poItem.poItemsId)).First();
item.partNo = poItem.partNo;
item.mfg = poItem.mfg;
item.dc = poItem.dc;
item.vendorIntPartNo = poItem.vendorIntPartNo;
item.coo = poItem.coo;
item.qty = poItem.qty;
item.qtyRecd = poItem.qtyRecd;
item.qtyCorrected = poItem.qtyCorrected;
item.qtyAccept = poItem.qtyAccept;
item.qtyRejected = poItem.qtyRejected;
item.qtyRTV = poItem.qtyRTV;
item.qcPending = poItem.qcPending;
item.currency = poItem.currency;
item.unitPrice = poItem.unitPrice;
item.dockDate = poItem.dockDate;
item.receiveDate = poItem.receiveDate;
item.stepCode = poItem.stepCode;
item.noteToVendor = poItem.noteToVendor;
poEntity.SaveChanges();
}
public static void UpdatePoItemState(int poItemId, int state)
{
poitems poItem = poEntity.poitems.First(item => item.poItemsId == poItemId);
poItem.poItemState = (sbyte)state;
poEntity.SaveChanges();
}
public static void DeletePoItembyPoItemId(int poItemId)
{
var items = poEntity.poitems.Where(i => (i.poItemsId == poItemId));
if (items.Count() == 0)
{
return;
}
poitems item = items.First();
poEntity.poitems.DeleteObject(item);
poEntity.SaveChanges();
}
/// <summary>
/// 创建新的 poitems 对象。
/// </summary>
/// <param name="poItemsId">poItemsId 属性的初始值。</param>
/// <param name="poId">poId 属性的初始值。</param>
/// <param name="soItemId">soItemId 属性的初始值。</param>
/// <param name="partNo">partNo 属性的初始值。</param>
/// <param name="mfg">mfg 属性的初始值。</param>
/// <param name="dc">dc 属性的初始值。</param>
/// <param name="qty">qty 属性的初始值。</param>
/// <param name="dockDate">dockDate 属性的初始值。</param>
/// <param name="salesAgent">salesAgent 属性的初始值。</param>
/// <param name="poItemState">poItemState 属性的初始值。</param>
public static poitems Createpoitems(global::System.Int32 poItemsId, global::System.Int32 poId, global::System.Int32 soItemId, global::System.String partNo, global::System.String mfg, global::System.String dc, global::System.Int32 qty, global::System.DateTime dockDate, global::System.SByte salesAgent, global::System.SByte poItemState)
{
poitems poitems = new poitems();
poitems.poItemsId = poItemsId;
poitems.poId = poId;
poitems.soItemId = soItemId;
poitems.partNo = partNo;
poitems.mfg = mfg;
poitems.dc = dc;
poitems.qty = qty;
poitems.dockDate = dockDate;
poitems.salesAgent = salesAgent;
poitems.poItemState = poItemState;
return(poitems);
}
public void FillTheTable(poitems poItem)
{
this.poItems = poItem;
poItemsControl1.FillTheItems(poItem,isNewCreatePo);
SetComboxItem();
if (!isNewCreatePo)
{
if (poItemStateList.GetPoStateAccordingToValue(poItem.poItemState).WhoCanUpdate().Contains(UserInfo.Job))
{
this.tscbOp.Enabled = true;
}
else
{
this.tscbOp.Enabled = false;
}
}
}
public static void UpDatePoItems(List <PoItemContentAndState> poItemStateList)
{
foreach (PoItemContentAndState pics in poItemStateList)
{
switch (pics.state)
{
case OrderItemsState.Normal:
break;
case OrderItemsState.New:
poEntity.poitems.AddObject(pics.poItem);
break;
case OrderItemsState.Modified:
poitems item = poEntity.poitems.Where(pitem => (pitem.PoItemsId == pics.poItem.PoItemsId)).First();
item = pics.poItem;
break;
}
}
poEntity.SaveChanges();
}
public void FillTheTable(poitems poItem)
{
poItemsControl1.FillTheItems(poItem);
}
/// <summary>
/// 创建新的 poitems 对象。
/// </summary>
/// <param name="poItemsId">PoItemsId 属性的初始值。</param>
public static poitems Createpoitems(global::System.Int32 poItemsId)
{
poitems poitems = new poitems();
poitems.PoItemsId = poItemsId;
return poitems;
}
/// <summary>
/// 用于向 poitems EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddTopoitems(poitems poitems)
{
base.AddObject("poitems", poitems);
}
public void FillTheItems(poitems item)
{
tbPartNo.Text = item.partNo;
tbMfg.Text = item.mfg;
tbDc.Text = item.dc;
tbVendorIntPartNo.Text = item.vendorIntPartNo;
tbOrg.Text = item.org;
tbQty.Text = item.qty.ToString();
tbQtyRevd.Text=item.qtyRecd.ToString();
tbQtyCorrected.Text=item.qtyCorrected.ToString();
tbQtyAccept.Text=item.qtyAccept.ToString();
tbQtyRejected.Text = item.qtyRejected.ToString();
tbQtyRtv.Text = item.qtyRTV.ToString();
tbQcPending.Text = item.qcPending.ToString();
cbCurrency.SelectedIndex =(int)item.currency;
tbUnitPrice.Text = item.unitPrice.ToString();
tbTotal.Text = (item.qtyAccept * item.unitPrice).ToString();
dateTimePicker1.Value = item.dueDate.Value;
if (item.receiveDate == null)
{
dateTimePicker2.Checked = false;
}
else
{
dateTimePicker2.Value = item.receiveDate.Value;
}
tbStepCode.Text = item.stepCode;
// tbSalesAgent.Text=
tbNoteToVendor.Text = item.noteToVendor;
}
public static void UpdatePoItem(poitems poItem)
{
poitems item = poEntity.poitems.Where(pitem => (pitem.poItemsId == poItem.poItemsId)).First();
item.partNo = poItem.partNo;
item.mfg = poItem.mfg;
item.dc = poItem.dc;
item.vendorIntPartNo = poItem.vendorIntPartNo;
item.coo = poItem.coo;
item.qty = poItem.qty;
item.qtyRecd = poItem.qtyRecd;
item.qtyCorrected = poItem.qtyCorrected;
item.qtyAccept = poItem.qtyAccept;
item.qtyRejected = poItem.qtyRejected;
item.qtyRTV = poItem.qtyRTV;
item.qcPending = poItem.qcPending;
item.currency = poItem.currency;
item.unitPrice = poItem.unitPrice;
item.dockDate = poItem.dockDate;
item.receiveDate = poItem.receiveDate;
item.stepCode = poItem.stepCode;
item.noteToVendor = poItem.noteToVendor;
poEntity.SaveChanges();
}
/// <summary>
/// 用于向 poitems EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddTopoitems(poitems poitems)
{
base.AddObject("poitems", poitems);
}
public void FillTheItems(poitems item,bool isNewCreatePo)
{
if (isNewCreatePo)
{
this.btFiles.Enabled = false;
}
this.poItemId = item.poItemsId;
tbPartNo.Text = item.partNo;
tbMfg.Text = item.mfg;
tbDc.Text = item.dc;
tbVendorIntPartNo.Text = item.vendorIntPartNo;
tbCoo.Text = item.coo;
if (UserInfo.Job == JobDescription.LogisticsManager || UserInfo.Job == JobDescription.Boss || UserInfo.Job == JobDescription.Admin)
{
tbCoo.ReadOnly = false;
}
else
{
tbCoo.ReadOnly = true;
}
tbQty.Text = item.qty.ToString();
tbQtyRevd.Text=item.qtyRecd.ToString();
tbQtyCorrected.Text=item.qtyCorrected.ToString();
tbQtyAccept.Text=item.qtyAccept.ToString();
tbQtyRejected.Text = item.qtyRejected.ToString();
tbQtyRtv.Text = item.qtyRTV.ToString();
tbQcPending.Text = item.qcPending.ToString();
cbCurrency.SelectedIndex =(int)item.currency;
tbUnitPrice.Text = item.unitPrice.ToString();
tbTotal.Text = (item.qty * item.unitPrice).ToString();
dateTimePicker1.Value = item.dockDate;
tbSalesAgent.Text = AllAccountInfo.GetNameAccordingToId(item.salesAgent);
if (item.receiveDate == null)
{
dateTimePicker2.Checked = false;
}
else
{
dateTimePicker2.Value = item.receiveDate.Value;
}
tbStepCode.Text = item.stepCode;
tbSalesAgent.Text = AllAccountInfo.GetNameAccordingToId(item.salesAgent);
tbNoteToVendor.Text = item.noteToVendor;
}
/// <summary>
/// 创建新的 poitems 对象。
/// </summary>
/// <param name="poItemsId">poItemsId 属性的初始值。</param>
/// <param name="poId">poId 属性的初始值。</param>
/// <param name="soItemId">soItemId 属性的初始值。</param>
/// <param name="partNo">partNo 属性的初始值。</param>
/// <param name="mfg">mfg 属性的初始值。</param>
/// <param name="dc">dc 属性的初始值。</param>
/// <param name="qty">qty 属性的初始值。</param>
/// <param name="dockDate">dockDate 属性的初始值。</param>
/// <param name="salesAgent">salesAgent 属性的初始值。</param>
/// <param name="poItemState">poItemState 属性的初始值。</param>
public static poitems Createpoitems(global::System.Int32 poItemsId, global::System.Int32 poId, global::System.Int32 soItemId, global::System.String partNo, global::System.String mfg, global::System.String dc, global::System.Int32 qty, global::System.DateTime dockDate, global::System.SByte salesAgent, global::System.SByte poItemState)
{
poitems poitems = new poitems();
poitems.poItemsId = poItemsId;
poitems.poId = poId;
poitems.soItemId = soItemId;
poitems.partNo = partNo;
poitems.mfg = mfg;
poitems.dc = dc;
poitems.qty = qty;
poitems.dockDate = dockDate;
poitems.salesAgent = salesAgent;
poitems.poItemState = poItemState;
return poitems;
}
