public LotBOM GetLotBBBom(string lotNumber)
{
LotBOM lotBOMBB = null;
using (LotQueryServiceClient client = new LotQueryServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
PageNo = 0,
PageSize = 1,
Where = string.Format("Key.LotNumber='{0}' AND MaterialCode like'130308%'", lotNumber)
};
MethodReturnResult <IList <LotBOM> > result = client.GetLotBOM(ref cfg);
if (result.Code <= 0 && result.Data != null && result.Data.Count > 0)
{
lotBOMBB = result.Data[0];
}
}
return(lotBOMBB);
}
public LotBOM GetLotCellMaterial(string lotNumber)
{
LotBOM lotBOMObj = null;
using (LotQueryServiceClient client = new LotQueryServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
PageNo = 0,
PageSize = 1,
//Where = string.Format("Key.LotNumber='{0}' AND Key.ItemNo=1", lotNumber)
Where = string.Format("Key.LotNumber='{0}' AND (MaterialCode Like '11%' OR MaterialCode LIKE '1803%' OR MaterialCode LIKE '2511%') ", lotNumber)
};
MethodReturnResult <IList <LotBOM> > result = client.GetLotBOM(ref cfg);
if (result.Code <= 0 && result.Data != null && result.Data.Count > 0)
{
lotBOMObj = result.Data[0];
}
}
return(lotBOMObj);
}
//
//POST: /WIP/LotQuery/GetLotMaterial
public async Task <ActionResult> GetLotMaterialWS(string lotNumber)
{
using (LotQueryServiceClient client = new LotQueryServiceClient())
{
await Task.Run(() =>
{
MethodReturnResult <Lot> result = client.Get(lotNumber);
if (result.Code == 0)
{
ViewBag.Lot = result.Data;
}
});
}
using (LotQueryServiceClient client = new LotQueryServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
Where = string.Format(@" Key.LotNumber='{0}'"
, lotNumber),
OrderBy = "Key.ItemNo"
};
MethodReturnResult <IList <LotBOM> > result = client.GetLotBOM(ref cfg);
if (result.Code == 0)
{
ViewBag.MaterialList = result.Data;
}
});
}
return(PartialView("_MaterialListPartial_ws"));
}
public Supplier GetLotBBMaterialSupplier(string lotNumber)
{
LotBOM lotBOMGlass = null;
using (LotQueryServiceClient client = new LotQueryServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
PageNo = 0,
PageSize = 1,
Where = string.Format("Key.LotNumber='{0}' AND MaterialCode like'130308%'", lotNumber)
};
MethodReturnResult <IList <LotBOM> > result = client.GetLotBOM(ref cfg);
if (result.Code <= 0 && result.Data != null && result.Data.Count > 0)
{
lotBOMGlass = result.Data[0];
}
}
Lot Lot = null;
using (LotQueryServiceClient client = new LotQueryServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
PageNo = 0,
PageSize = 1,
Where = string.Format("Key.LotNumber='{0}'", lotNumber)
};
MethodReturnResult <Lot> result = client.Get(lotNumber);
if (result.Code <= 0 && result.Data != null)
{
Lot = result.Data;
}
}
Supplier sBB = null;
using (SupplierServiceClient client = new SupplierServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
PageNo = 0,
PageSize = 1,
Where = string.Format(@"EXISTS (FROM LineStoreMaterialDetail as p
WHERE p.SupplierCode=self.Key
AND p.Key.MaterialLot='{0}'
AND p.Key.MaterialCode='{1}'
AND p.Key.LineStoreName='{2}'
AND p.Key.OrderNumber='{3}')"
, lotBOMGlass.Key.MaterialLot
, lotBOMGlass.MaterialCode
, lotBOMGlass.LineStoreName
, Lot.OrderNumber != null ? Lot.OrderNumber : string.Empty
)
};
MethodReturnResult <IList <Supplier> > rst = client.Get(ref cfg);
if (rst.Code <= 0 && rst.Data.Count > 0)
{
sBB = rst.Data[0];
}
return(sBB);
}
}