public override bool Equals(object obj) { ItemPackage another = obj as ItemPackage; if (another == null) { return(false); } else { return(this.Id == another.Id); } }
public void UpdateFlowDetail(FlowDetail flowDetail) { IList<ItemPackage> itemPackageList = genericMgr.FindAll<ItemPackage>("from ItemPackage as i where i.Item = ? and i.UnitCount = ?", new object[] { flowDetail.Item, flowDetail.UnitCount }); if (itemPackageList == null || itemPackageList.Count == 0) { ItemPackage itemPackage = new ItemPackage(); itemPackage.Item = flowDetail.Item; itemPackage.UnitCount = flowDetail.UnitCount; itemPackage.Description = string.IsNullOrEmpty(flowDetail.UnitCountDescription) ? string.Empty : flowDetail.UnitCountDescription; genericMgr.CreateWithTrim(itemPackage); } genericMgr.UpdateWithTrim(flowDetail); }
public ActionResult _ItemPackageComboBox(string controlName, string controlId, string selectedValue, string item) { ViewBag.ControlName = controlName; ViewBag.ControlId = controlId; IList<ItemPackage> itemPackageList = new List<ItemPackage>(); if (!string.IsNullOrEmpty(item)) { itemPackageList = base.genericMgr.FindAll<ItemPackage>("select i from ItemPackage as i where i.Item=?", item, firstRow, maxRow); } else if (selectedValue != null && selectedValue.Trim() != string.Empty) { itemPackageList = base.genericMgr.FindAll<ItemPackage>(selectEqItemPackageStatement, selectedValue, firstRow, maxRow); } if (!string.IsNullOrEmpty(selectedValue)) { if (itemPackageList.Count < 1) { ItemPackage itemPackage = new ItemPackage(); itemPackage.Item = item; itemPackage.IsDefault = false; itemPackage.UnitCount = decimal.Parse(selectedValue); itemPackage.Description = selectedValue; itemPackageList.Add(itemPackage); } } return PartialView(new SelectList(itemPackageList, "UnitCount", "UnitCount", selectedValue)); }
public ActionResult _ItemPackageDropDownList(string controlName, string controlId, string selectedValue, bool? includeBlankOption, string blankOptionDescription, string blankOptionValue, string itemCode) { ViewBag.ControlName = controlName; ViewBag.ControlId = controlId; //ViewBag.SelectedValue = selectedValue; IList<ItemPackage> itemPackageList = base.genericMgr.FindAll<ItemPackage>("from ItemPackage as i where i.Item=?", itemCode); if (itemPackageList == null) { itemPackageList = new List<ItemPackage>(); } if (includeBlankOption.HasValue && includeBlankOption.Value) { ItemPackage blankItemPackage = new ItemPackage(); blankItemPackage.UnitCount = Convert.ToDecimal(blankOptionValue); blankItemPackage.UnitCount = Convert.ToDecimal(blankOptionDescription); itemPackageList.Insert(0, blankItemPackage); } return PartialView(new SelectList(itemPackageList, "UnitCount", "UnitCount", selectedValue)); }
public void UpdateItem(Item item) { string hql = "from ItemPackage where Item = ? and UnitCount = ?"; IList<ItemPackage> itemPackageList = genericMgr.FindAll<ItemPackage>(hql, new object[] { item.Code, item.UnitCount }); if (itemPackageList != null && itemPackageList.Count > 0) { ItemPackage itemPackage = itemPackageList[0]; if (!itemPackage.IsDefault) { itemPackage.IsDefault = true; genericMgr.Update(itemPackage); } } else { #region 原默认包装至False hql = "from ItemPackage as i where i.Item = ? and i.IsDefault= ?"; IList<ItemPackage> defualtItemPackageList = genericMgr.FindAll<ItemPackage>(hql, new object[] { item.Code, true }); for (int i = 0; i < defualtItemPackageList.Count; i++) { defualtItemPackageList[i].IsDefault = false; this.genericMgr.Update(defualtItemPackageList[i]); } #endregion #region 没有找到包装,新增包装 ItemPackage itemPackage = new ItemPackage(); itemPackage.Item = item.Code; itemPackage.IsDefault = true; itemPackage.UnitCount = item.UnitCount; itemPackage.Description = string.Empty; this.genericMgr.Create(itemPackage); #endregion } genericMgr.Update(item); }
public void CreateItem(Item item) { ItemPackage itemPackage = new ItemPackage(); itemPackage.Item = item.Code; itemPackage.IsDefault = true; itemPackage.UnitCount = item.UnitCount; itemPackage.Description = string.Empty; genericMgr.Create(item); genericMgr.Create(itemPackage); }
public void UpdateFlowDetail(FlowDetail flowDetail) { #region 零件标准包装 var dbFlowDetail = this.genericMgr.FindById<FlowDetail>(flowDetail.Id); this.genericMgr.CleanSession(); var flow = genericMgr.FindById<FlowMaster>(flowDetail.Flow); var locFrom = string.IsNullOrWhiteSpace(flowDetail.LocationFrom) ? flow.LocationFrom : flowDetail.LocationFrom; var locTo = string.IsNullOrWhiteSpace(flowDetail.LocationTo) ? flow.LocationTo : flowDetail.LocationTo; if (dbFlowDetail.Item != flowDetail.Item || dbFlowDetail.UnitCount != flowDetail.UnitCount || dbFlowDetail.UnitCountDescription != flowDetail.UnitCountDescription) { if (!string.IsNullOrWhiteSpace(locFrom)) { UpdateItemStandardPackByType(flowDetail, locFrom, "O"); } if (!string.IsNullOrWhiteSpace(locTo)) { UpdateItemStandardPackByType(flowDetail, locTo, "I"); } } else if (dbFlowDetail.LocationFrom != flowDetail.LocationFrom) { if (!string.IsNullOrWhiteSpace(locFrom)) { UpdateItemStandardPackByType(flowDetail, locFrom, "O"); } } else if (dbFlowDetail.LocationTo != flowDetail.LocationTo) { if (!string.IsNullOrWhiteSpace(locTo)) { UpdateItemStandardPackByType(flowDetail, locTo, "I"); } } #endregion IList<ItemPackage> itemPackageList = genericMgr.FindAll<ItemPackage>("from ItemPackage as i where i.Item = ? and i.UnitCount = ?", new object[] { flowDetail.Item, flowDetail.UnitCount }); if (itemPackageList == null || itemPackageList.Count == 0) { ItemPackage itemPackage = new ItemPackage(); itemPackage.Item = flowDetail.Item; itemPackage.UnitCount = flowDetail.UnitCount; itemPackage.Description = string.IsNullOrEmpty(flowDetail.UnitCountDescription) ? string.Empty : flowDetail.UnitCountDescription; genericMgr.Create(itemPackage); } genericMgr.Update(flowDetail); }
public void CreateFlowDetail(FlowDetail flowDetail) { IList<ItemPackage> itemPackageList = genericMgr.FindAll<ItemPackage>("from ItemPackage as i where i.Item = ? and i.UnitCount = ?", new object[] { flowDetail.Item, flowDetail.UnitCount }); if (itemPackageList == null || itemPackageList.Count == 0) { ItemPackage itemPackage = new ItemPackage(); itemPackage.Item = flowDetail.Item; itemPackage.UnitCount = flowDetail.UnitCount; itemPackage.Description = string.IsNullOrEmpty(flowDetail.UnitCountDescription) ? string.Empty : flowDetail.UnitCountDescription; genericMgr.Create(itemPackage); } genericMgr.Create(flowDetail); #region 更新计划协议历史数据,按照路线更新 FlowMaster flow = genericMgr.FindById<FlowMaster>(flowDetail.Flow); ////允许新建的明细肯定是唯一有效的 //IList<FlowDetail> flowDetailList = this.genericMgr.FindAll<FlowDetail>("select fd from FlowDetail as fd where fd.Item='" + flowDetail.Item + "' and IsActive <> 0 and exists (select 1 from FlowMaster as fm where fm.Code=fd.Flow and fm.PartyFrom='" + flow.PartyFrom + "' and fm.IsActive = 1)"); //if (flowDetailList.Count == 1) //{ // Location location = flowDetail.IsActive ? genericMgr.FindById<Location>(flow.LocationTo) : null; // Party partyTo = flowDetail.IsActive ? genericMgr.FindById<Party>(flow.PartyTo) : null; // Address address = flowDetail.IsActive ? genericMgr.FindById<Address>(flow.ShipTo) : null; // string updateMstr = "Update Ord_OrderMstr_8 set Flow = ?,FlowDesc = ?,PartyTo = ?,PartyToNm = ?,ShipTo = ?,ShipToAddr = ?,LocTo = ?,LocToNm = ? where PartyFrom = ? and exists (select 1 from Ord_OrderDet_8 as d where d.Item = ? and Ord_OrderMstr_8.OrderNo=d.OrderNo)"; // genericMgr.FindAllWithNativeSql(updateMstr, new object[] { flow.Code, flow.Description, flow.PartyTo, partyTo.Name, flow.ShipTo, address.AddressContent, flow.LocationTo, location.Name, flow.PartyFrom, flowDetail.Item }); // string updateStr = "Update Ord_OrderDet_8 set LocTo = ?,LocToNm = ?,UC = ? where Item = ? and exists (select 1 from Ord_OrderMstr_8 as o where o.PartyFrom = ? and Ord_OrderDet_8.OrderNo=o.OrderNo)"; // genericMgr.FindAllWithNativeSql(updateStr, new object[] { flow.LocationTo, location.Name, flowDetail.UnitCount, flowDetail.Item, flow.PartyFrom }); //} #endregion #region 将数据插入零件标准包装中间表 //采购路线只有入库包装,移库路线才有出库/入库包装 if (flow.Type == CodeMaster.OrderType.Transfer || flow.Type == CodeMaster.OrderType.Distribution || flow.Type == CodeMaster.OrderType.SubContractTransfer) { string locationFrom = string.IsNullOrWhiteSpace(flowDetail.LocationFrom) ? flow.LocationFrom : flowDetail.LocationFrom; if (string.IsNullOrWhiteSpace(locationFrom)) { var locTo = this.genericMgr.FindById<Location>(locationFrom); CreateItemStandardPackByType(flowDetail, locTo, "I"); } } if (flow.Type == CodeMaster.OrderType.Transfer || flow.Type == CodeMaster.OrderType.SubContractTransfer || flow.Type == CodeMaster.OrderType.SubContract || flow.Type == CodeMaster.OrderType.CustomerGoods || flow.Type == CodeMaster.OrderType.Procurement) { string locationTo = string.IsNullOrWhiteSpace(flowDetail.LocationTo) ? flow.LocationTo : flowDetail.LocationTo; if (string.IsNullOrWhiteSpace(locationTo)) { var locTo = this.genericMgr.FindById<Location>(locationTo); CreateItemStandardPackByType(flowDetail, locTo, "I"); } } #endregion }
public void CreateItem(Item item) { ItemPackage itemPackage = new ItemPackage(); itemPackage.Item = item.Code; itemPackage.IsDefault = true; itemPackage.UnitCount = item.UnitCount; itemPackage.Description = string.Empty; genericMgr.Create(item); genericMgr.Create(itemPackage); this.ResetItemCache(); GetCacheAllItem(); //if (!cachedAllItem.ContainsKey(item.Code)) //{ // cachedAllItem.Add(item.Code, item); //} }
public ActionResult ItemPackageNew(ItemPackage itemPackage) { if (ModelState.IsValid) { if (this.genericMgr.FindAll<long>(itemPackageDuiplicateVerifyStatement, new object[] { itemPackage.Id })[0] > 0) { SaveErrorMessage(Resources.SYS.ErrorMessage.Errors_Existing_Code, itemPackage.Id.ToString()); } else if (this.genericMgr.FindAll<long>(itemAndUnitCountIsExistStatement, new object[] { itemPackage.Item, itemPackage.UnitCount })[0] > 0) { SaveErrorMessage(Resources.MD.ItemPackage.ItemPackageErrors_Existing_ItemAndUnitCount); } else if (itemPackage.UnitCount <= 0) { SaveErrorMessage(Resources.EXT.ControllerLan.Con_UnitcountQuantityMustGreater); } else { if (itemPackage.Description == null) { itemPackage.Description = string.Empty; } this.genericMgr.CreateWithTrim(itemPackage); SaveSuccessMessage(Resources.MD.ItemPackage.ItemPackage_Added); return RedirectToAction("ItemPackage/" + itemPackage.Item); } } return PartialView(itemPackage); }
public ActionResult ItemPackageNew(string id) { ItemPackage itemPackage = new ItemPackage(); itemPackage.Item = id; return PartialView(itemPackage); }
public ActionResult ItemPackageNew(ItemPackage itemPackage) { if (ModelState.IsValid) { if (base.genericMgr.FindAll<long>(itemPackageDuiplicateVerifyStatement, new object[] { itemPackage.Id })[0] > 0) { SaveErrorMessage(Resources.ErrorMessage.Errors_Existing_Code, itemPackage.Id.ToString()); } else if (base.genericMgr.FindAll<long>(itemAndUnitCountIsExistStatement, new object[] { itemPackage.Item, itemPackage.UnitCount })[0] > 0) { SaveErrorMessage(Resources.MD.ItemPackage.ItemPackageErrors_Existing_ItemAndUnitCount); } else if (itemPackage.UnitCount <= 0) { SaveErrorMessage("包装数必须大于0"); } else { if (itemPackage.Description == null) { itemPackage.Description = string.Empty; } base.genericMgr.Create(itemPackage); SaveSuccessMessage(Resources.MD.ItemPackage.ItemPackage_Added); return RedirectToAction("ItemPackage/" + itemPackage.Item); } } return PartialView(itemPackage); }