public string GetQCStatus(string qc) { QcmaininfoManager qmm = new QcmaininfoManager(); QcmaininfoModel qm = new QcmaininfoModel(); qm.QualityCode = tQC.Text.Trim(); QcmaininfoModelList qml = qmm.GetModelList(qm); if (qml.Count > 0) { return(qml[0].Status.ToLower()); } else { return(string.Empty); } }
public string QCTrasferToAX(string sQC) { try { if (sQC.Contains("E")) { return("The code is not internal, don't need to call AX"); } QccustomerlibraryManager cumanager = new QccustomerlibraryManager(); QcmaininfoManager qcMainManager = new QcmaininfoManager(); QcconstructiondtlManager qcConManager = new QcconstructiondtlManager(); QcyarndtlManager yarnManager = new QcyarndtlManager(); QcfinishdtlManager finishManager = new QcfinishdtlManager(); QcavailablewidthManager avaManager = new QcavailablewidthManager(); QcmaininfoModelList qcMainModelList = qcMainManager.GetModelList(new QcmaininfoModel() { QualityCode = sQC }); if (qcMainModelList.Count == 0) { return("没有找到该QC#数据"); } QcmaininfoModel qcMainModel = qcMainModelList[0]; if (qcMainModel.DyeMethod == "YD") { return("DyeMethod is YD,don't need to Call AX"); } if (qcMainModel.Status != "Approved") { return("The status is not Approved,don't need to Call AX"); } QcconstructiondtlModelList qcConstructionList = qcConManager.GetModelList(new QcconstructiondtlModel() { QualityCode = sQC }); QcyarndtlModelList qcYarnList = yarnManager.GetModelList(new QcyarndtlModel() { QualityCode = sQC }); QcfinishdtlModelList qcFinfishing = finishManager.GetModelList(new QcfinishdtlModel() { QualityCode = sQC }); QcavailablewidthModelList qcAvaWidthList = avaManager.GetModelList(new QcavailablewidthModel() { QualityCode = sQC }); QccustomerlibraryModelList customerList = cumanager.GetModelList(new QccustomerlibraryModel() { QualityCode = qcMainModel.QualityCode }); WebReference3.TEX_AxdInventTable data = new WebReference3.TEX_AxdInventTable(); //Customer List <WebReference3.TEX_AxdQCCustomerLibrary> customer = new List <TEX_AxdQCCustomerLibrary>(); for (int i = 0; i < customerList.Count; i++) { customer.Add(new TEX_AxdQCCustomerLibrary() { BrandId = customerList[i].Brand, CustBuyerId = customerList[i].BuyerId, CustMillComments = customerList[i].MillComments, CustQualityId = customerList[i].CustomerQualityId, CustSalesGroup = customerList[i].SalesGroup, CustSalesId = customerList[i].Sales, IsFirstOwnerStr = (customerList[i].IsFirstOwner == "Y" ? "Yes" : "No"), // IsFirstOwnerStr="YES", ItemId = customerList[i].QualityCode }); } if (customer.Count > 0) { data.CustomerLibrary = customer.ToArray(); } //Finish List <WebReference3.TEX_AxdQCFinishDetails> finish = new List <WebReference3.TEX_AxdQCFinishDetails>(); for (int i = 0; i < qcFinfishing.Count; i++) { finish.Add(new WebReference3.TEX_AxdQCFinishDetails() { FinishingCode = qcFinfishing[i].FinishingCode, ItemId = qcFinfishing[i].QualityCode }); } if (finish.Count > 0) { data.FinishDetails = finish.ToArray(); } //Yarn List <WebReference3.TEX_AxdQCYarnDetails> yarnD = new List <WebReference3.TEX_AxdQCYarnDetails>(); for (int i = 0; i < qcYarnList.Count; i++) { yarnD.Add(new TEX_AxdQCYarnDetails() { YarnRatio = qcYarnList[i].YarnRatio, ItemId = qcYarnList[i].QualityCode, YarnThreads = qcYarnList[i].Threads, YarnTypeId = qcYarnList[i].YarnType, YarnCountId = qcYarnList[i].YarnCount, YarnCompositionId = qcYarnList[i].YarnComponent, YarnDensity = qcYarnList[i].YarnDensity }); } if (yarnD.Count > 0) { data.YarnDetails = yarnD.ToArray(); } //Construction List <WebReference3.TEX_AxdQCConstructionDetails> ConList = new List <WebReference3.TEX_AxdQCConstructionDetails>(); for (int i = 0; i < qcConstructionList.Count; i++) { ConList.Add(new TEX_AxdQCConstructionDetails() { ConstructionId = qcConstructionList[i].Construction, ItemId = qcConstructionList[i].QualityCode }); } if (ConList.Count > 0) { data.ConstructionDetails = ConList.ToArray(); } //AvaWith if (qcAvaWidthList.Count > 0) { TEX_AxdQCAvailableWidth[] avaList = new TEX_AxdQCAvailableWidth[qcAvaWidthList.Count]; TEX_AxdQCAvailableWidth aw = null; for (int i = 0; i < qcAvaWidthList.Count; i++) { aw = new TEX_AxdQCAvailableWidth(); aw.ItemId = qcAvaWidthList[i].QualityCode; aw.Gauge = qcAvaWidthList[i].Gauge; aw.Diameter = qcAvaWidthList[i].Diameter; aw.TotalNeedles = qcAvaWidthList[i].TotalNeedles; aw.Width = qcAvaWidthList[i].Width; aw.MaxWidth = qcAvaWidthList[i].MaxWidth; avaList.SetValue(aw, i); } data.AvailableWidth = avaList; } /* * List<WebReference3.TEX_AxdQCAvailableWidth> avaList = new List<WebReference3.TEX_AxdQCAvailableWidth>(); * * for (int i = 0; i < qcAvaWidthList.Count; i++) * { * avaList.Add(new TEX_AxdQCAvailableWidth() * { * ItemId = qcAvaWidthList[i].QualityCode, * Gauge = qcAvaWidthList[i].Gauge, * Diameter = qcAvaWidthList[i].Diameter, * TotalNeedles = qcAvaWidthList[i].TotalNeedles, * Width = qcAvaWidthList[i].Width, * MaxWidth = qcAvaWidthList[i].MaxWidth * * }); * * } * if (avaList.Count > 0) * data.AvailableWidth = avaList.ToArray();*/ data.ItemId = qcMainModel.QualityCode; data.PatternId = qcMainModel.Pattern; data.DyeMethodId = qcMainModel.DyeMethod; data.GramWeightBeforeWash = qcMainModel.BfGmmm; data.GramWeightAfterWash = qcMainModel.AfGmmm; data.Shrinkage = qcMainModel.Shrinkage; data.InventStatus = TEX_InventStatus.Approved; data.ShrinkTestMethod = qcMainModel.ShrinkageTestingMethod; // data.IsGarmentWash = (qcMainModel.GmtWashing == "Y" ? NoYes.Yes : NoYes.No); data.IsGarmentWashStr = (qcMainModel.GmtWashing == "Y" ? "Yes" : "No"); data.IsGarmentWashStr = "Yes"; data.InventLayout = qcMainModel.Layout; data.Remark = qcMainModel.Remark; data.ApprovalDateTime = qcMainModel.ApproveDate; data.Approver = qcMainModel.Approver; data.InventSourcing = qcMainModel.Sourcing; data.MaterialGroup = qcMainModel.MaterialGroup; data.KnitAnalysisNum = qcMainModel.AnalysisNo; data.RefQualityCode = qcMainModel.RefQualityCode; data.TappingType = qcMainModel.TappingType; data.TappingMeasurement = qcMainModel.Measurement; data.YarnLength = qcMainModel.YarnLength; data.SpecialType = qcMainModel.SpecialType; WebReference3.portTypeClient qc = new WebReference3.portTypeClient(); if (qc.TransQCOp(data)) { return("Sucess"); } else { return("Fail"); } } catch (Exception ex) { return(ex.Message); } }