public ActionResult DeleteMaterialInData(int MaterialInId) { MaterialIn newFitCat = db.MaterialIns.Where(a => a.MaterialInId.Equals(MaterialInId)).FirstOrDefault(); if (newFitCat != null) { db.Entry(newFitCat).State = EntityState.Deleted; db.SaveChanges(); ModelState.Clear(); return(Json(new { success = true, message = "Data Delete" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { error = true, message = "Unsuccessfull" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult MaterialInDataEditView(int MaterialInId) { GetMaterialInPurchaserList(); MaterialInModel model = new MaterialInModel(); MaterialIn newFitCat = db.MaterialIns.Where(a => a.MaterialInId.Equals(MaterialInId)).FirstOrDefault(); if (newFitCat != null) { model.MatInPurchaserId = newFitCat.MatInPurchaserId; model.PurchaseItem = newFitCat.PurchaseItem; model.Quantity = newFitCat.Quantity; model.Rate = newFitCat.Rate; model.Quality = newFitCat.Quality; model.Size = newFitCat.Size; model.Cartridge = newFitCat.Cartridge; } return(View("MaterialInDataSetup", model)); }
public static Transformer ConvertMaterialInToTransformer(MaterialIn materialIn) { if (materialIn == null) { return(null); } Transformer transformer = new Transformer(); transformer.Operation = materialIn.Operation.HasValue ? materialIn.Operation.Value : 0; transformer.ItemCode = materialIn.RawMaterial.Code; transformer.ItemDescription = materialIn.RawMaterial.Description; transformer.UomCode = materialIn.RawMaterial.Uom.Code; transformer.UnitCount = materialIn.RawMaterial.UnitCount; transformer.Qty = 0M; transformer.CurrentQty = 0M; transformer.LocationCode = materialIn.Location == null ? string.Empty : materialIn.Location.Code; return(transformer); }
public ActionResult MaterialInDataSetup(MaterialInModel model) { System.Random random = new System.Random(); MaterialIn materialInData = db.MaterialIns.Where(a => a.MaterialInId.Equals(model.MaterialInId)).FirstOrDefault(); if (materialInData == null) { MaterialIn newMaterialInDataadd = new MaterialIn(); newMaterialInDataadd.MaterialInNo = "MatNo_" + random.Next(); newMaterialInDataadd.MatInPurchaserId = model.MatInPurchaserId; newMaterialInDataadd.PurchaseItem = model.PurchaseItem; newMaterialInDataadd.Quantity = model.Quantity; newMaterialInDataadd.Rate = model.Rate; newMaterialInDataadd.IsDebit = true; newMaterialInDataadd.IsCredit = false; newMaterialInDataadd.Quality = model.Quality; newMaterialInDataadd.Size = model.Size; newMaterialInDataadd.Cartridge = model.Cartridge; newMaterialInDataadd.CreateDate = DateTime.Now; newMaterialInDataadd.IsActive = true; db.MaterialIns.Add(newMaterialInDataadd); db.SaveChanges(); ModelState.Clear(); model = null; this.AddNotification("Thats great! Successfully Saved.", NotificationType.SUCCESS); } else { materialInData.MatInPurchaserId = model.MatInPurchaserId; materialInData.PurchaseItem = model.PurchaseItem; materialInData.Quantity = model.Quantity; materialInData.Rate = model.Rate; materialInData.Quality = model.Quality; materialInData.Size = model.Size; materialInData.Cartridge = model.Cartridge; db.SaveChanges(); model = null; this.AddNotification("Thats great! Successfully Edited.", NotificationType.SUCCESS); } return(RedirectToAction("MaterialInDataList")); }
private IList <MaterialIn> GetMaterialInList() { IList <MaterialIn> materialInList = new List <MaterialIn>(); for (int i = 0; i < this.GV_List.Rows.Count; i++) { GridViewRow row = this.GV_List.Rows[i]; string itemCode = ((Label)row.FindControl("lblItemCode")).Text.Trim(); Label lblOperation = (Label)row.FindControl("lblOperation"); int? operation = null; if (lblOperation.Text.Trim() != string.Empty) { operation = int.Parse(lblOperation.Text.Trim()); } Label lblLocation = (Label)row.FindControl("lblLocation"); TextBox tbQty = (TextBox)row.FindControl("tbQty"); decimal qty = tbQty.Text.Trim() == string.Empty ? 0 : decimal.Parse(tbQty.Text.Trim()); MaterialIn materialIn = new MaterialIn(); materialIn.RawMaterial = TheItemMgr.LoadItem(itemCode); materialIn.Operation = operation; materialIn.Qty = qty; if (lblLocation.Text.Trim() != string.Empty) { materialIn.Location = TheLocationMgr.LoadLocation(lblLocation.Text.Trim()); } if (materialIn.Qty != 0) { materialInList.Add(materialIn); } } return(materialInList); }
public IList <MaterialIn> ConvertTransformersToMaterialIns(List <Transformer> transformerList) { IList <MaterialIn> materialInList = new List <MaterialIn>(); if (transformerList != null) { foreach (Transformer transformer in transformerList) { //如果是扫描Hu的 if (transformer.TransformerDetails != null && transformer.TransformerDetails.Count > 0) { foreach (TransformerDetail transformerDetail in transformer.TransformerDetails) { MaterialIn materialIn = new MaterialIn(); materialIn.HuId = transformerDetail.HuId; materialIn.RawMaterial = itemMgr.LoadItem(transformerDetail.ItemCode); materialIn.Location = locationMgr.LoadLocation(transformerDetail.LocationCode); materialIn.LotNo = transformerDetail.LotNo; materialIn.Operation = transformerDetail.Operation; materialIn.Qty = transformerDetail.CurrentQty; materialInList.Add(materialIn); } } //如果是直接输入数量的 else { MaterialIn materialIn = new MaterialIn(); materialIn.RawMaterial = itemMgr.LoadItem(transformer.ItemCode); materialIn.Location = locationMgr.LoadLocation(transformer.LocationCode); materialIn.Operation = transformer.Operation; materialIn.Qty = transformer.CurrentQty; materialInList.Add(materialIn); } } } return(materialInList); }
public void InitPageParameter() { #region 已投料 IList <ProductLineInProcessLocationDetail> productLineIpList = new List <ProductLineInProcessLocationDetail>(); if (tbProductLine.Text.Trim() != string.Empty) { productLineIpList = TheProductLineInProcessLocationDetailMgr.GetProductLineInProcessLocationDetail(this.tbProductLine.Text.Trim(), BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE); } this.GV_List_Feeded.DataSource = productLineIpList; this.GV_List_Feeded.DataBind(); #endregion #region 新投料 //todo 根据flow得到Material的list IList <BomDetail> bomDetailList = new List <BomDetail>(); IList <MaterialIn> materialInList = new List <MaterialIn>(); if (this.tbProductLine.Text.Trim() != string.Empty) { bomDetailList = TheFlowMgr.GetBatchFeedBomDetail(this.tbProductLine.Text.Trim()); } //暂时放在页面,后面再抽出来 Flow flow = TheFlowMgr.LoadFlow(this.tbProductLine.Text.Trim(), true); if (bomDetailList != null && bomDetailList.Count > 0) { foreach (BomDetail bomDetail in bomDetailList) { MaterialIn materialIn = new MaterialIn(); materialIn.Location = bomDetail.Location; materialIn.Operation = bomDetail.Operation; materialIn.RawMaterial = bomDetail.Item; //来源库位查找逻辑BomDetail-->RoutingDetail-->FlowDetail-->Flow Location bomLocFrom = bomDetail.Location; if (flow.Routing != null) { //在Routing上查找,并检验Routing上的工序和BOM上的是否匹配 RoutingDetail routingDetail = TheRoutingDetailMgr.LoadRoutingDetail(flow.Routing, bomDetail.Operation, bomDetail.Reference); if (routingDetail != null) { if (bomLocFrom == null) { bomLocFrom = routingDetail.Location; } } } if (bomLocFrom == null) { bomLocFrom = bomDetail.DefaultLocation; } materialIn.Location = bomLocFrom; bool isInclude = false; foreach (MaterialIn m in materialInList) { if (m.Location.Code == materialIn.Location.Code && m.Operation == materialIn.Operation && m.RawMaterial.Code == materialIn.RawMaterial.Code) { isInclude = true; } } if (!isInclude) { materialInList.Add(materialIn); } } } this.GV_List.DataSource = materialInList; this.GV_List.DataBind(); #endregion }