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