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