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
}
