public string InitInfoOne(string allParam) { try { CustomerManager cm = new CustomerManager(); qcFinishList = new QcfinishdtlModelList(); qcMainList = new QcmaininfoModelList(); qcConstructionList = new QcconstructiondtlModelList(); qcFinishList = new QcfinishdtlModelList(); DataSet ds = cm.GetInfoFromKmis(allParam); DataTable dtMain = ds.Tables[0]; InitMain(ds.Tables[0]); InitConstruction(ds.Tables[1]); InitFinish(ds.Tables[2]); InitYarnInfo(ds.Tables[3]); InitCAttribute(); return(GetCmainInfo() + "<|>" + GetCConstruction() + "<|>" + GetCFinish() + "<|><|>" + qcMainList[0].YarnLength + "<|>" + qcMainList[0].Measurement + "<|>" + qcMainList[0].TappingType + "<|><|><|>" + "<|>" + qcMainList[0].QC_Ref_PPO + "<|>" + qcMainList[0].HF_Ref_PPO + "<|>" + qcMainList[0].QC_Ref_GP + "<|>" + qcMainList[0].HF_Ref_GP + "<|>" + qcMainList[0].RF_Remark); } catch (Exception ex) { return("error:" + ex.Message); } }
public string InitInfoAN(string analysisNO) { try { CustomerManager cm = new CustomerManager(); qcFinishList = new QcfinishdtlModelList(); qcMainList = new QcmaininfoModelList(); qcConstructionList = new QcconstructiondtlModelList(); DataSet ds = cm.GetInfoByAnalysisNo(analysisNO); if (ds.Tables[0].Rows.Count == 0) { return("0"); } InitMainOne(ds.Tables[0]); InitConstructionOne(ds.Tables[0]); InitYarnInfoOne(ds.Tables[1]); InitCAttribute(); qcFinishList = new QcfinishdtlModelList(); return(GetCmainInfo() + "<|>" + GetCConstruction() + "<|>" + GetCFinish()); } catch (Exception ex) { return("error:" + ex.Message); } }
public string InitInfoGkNo(string analysisNO) { try { CustomerManager cm = new CustomerManager(); qcFinishList = new QcfinishdtlModelList(); qcMainList = new QcmaininfoModelList(); qcConstructionList = new QcconstructiondtlModelList(); DataSet ds = cm.GetInfoByGKNo(analysisNO); if (ds.Tables[0].Rows.Count == 0) { return("0"); } InitMainByGkNo(ds.Tables[0]); InitConstructionByGkNo(ds.Tables[1]); InitYarnInfoByGkNo(ds.Tables[2]); InitFinish(ds.Tables[3]); InitCAttribute(); // qcFinishList = new QcfinishdtlModelList(); return(GetCmainInfo() + "<|>" + GetCConstruction() + "<|>" + GetCFinish() + "<|><|>" + qcMainList[0].YarnLength + "<|>" + qcMainList[0].Measurement + "<|>" + qcMainList[0].TappingType + "<|><|><|><|>" + qcMainList[0].TempComments); } catch (Exception ex) { return("error:" + ex.Message); } }
public void InitMainOne(DataTable dt) { QcmaininfoModel model = new QcmaininfoModel(); if (dt.Rows.Count == 0) { return; } qcMainList = new QcmaininfoModelList(); model.DyeMethod = dt.Rows[0]["Dye_Method"].ToString(); model.Pattern = dt.Rows[0]["Pattern"].ToString();; model.YarnLength = dt.Rows[0]["Yarn_Length"].ToString(); qcMainList.Add(model); }
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 void InitMain(DataTable dt) { QcmaininfoModel model = new QcmaininfoModel(); if (dt.Rows.Count == 0) { return; } qcMainList = new QcmaininfoModelList(); model.Pattern = dt.Rows[0]["Pattern"].ToString(); model.DyeMethod = dt.Rows[0]["Dye_Method"].ToString(); model.BfGmmm = dt.Rows[0]["BF_Gmmm"].ToString() == "" ? 0 : Int32.Parse(dt.Rows[0]["BF_Gmmm"].ToString()); model.AfGmmm = dt.Rows[0]["AF_Gmmm"].ToString() == "" ? 0 : Int32.Parse(dt.Rows[0]["AF_Gmmm"].ToString()); model.Shrinkage = dt.Rows[0]["Shrinkage"].ToString(); model.ShrinkageTestingMethod = dt.Rows[0]["Test_DryMode"].ToString(); model.GmtWashing = dt.Rows[0]["GMT_Washing"].ToString(); model.YarnLength = dt.Rows[0]["Yarn_Length"].ToString(); model.TappingType = dt.Rows[0]["Tapping_Type"].ToString(); model.Measurement = dt.Rows[0]["Measurement"].ToString(); qcMainList.Add(model); }
public void InitMainByGkNo(DataTable dt) { QcmaininfoModel model = new QcmaininfoModel(); if (dt.Rows.Count == 0) { return; } qcMainList = new QcmaininfoModelList(); model.DyeMethod = dt.Rows[0]["Dye_Method"].ToString(); model.Pattern = dt.Rows[0]["Pattern"].ToString();; model.YarnLength = dt.Rows[0]["YarnLength"].ToString(); model.ShrinkageTestingMethod = dt.Rows[0]["Test_DryMode"].ToString(); model.GmtWashing = dt.Rows[0]["GMT_Wash"].ToString(); model.Shrinkage = dt.Rows[0]["Shringkage"].ToString(); model.BfGmmm = dt.Rows[0]["DensityMin"].ToString() == "" ? 0 : (int)Convert.ToDecimal(dt.Rows[0]["DensityMin"]); model.AfGmmm = dt.Rows[0]["AfterWashKemm"].ToString() == "" ? 0 :(int)Convert.ToDecimal(dt.Rows[0]["AfterWashKemm"]); model.TappingType = dt.Rows[0]["TappingType"].ToString(); model.YarnLength = dt.Rows[0]["yarnLength"].ToString(); model.Measurement = dt.Rows[0]["Width"].ToString(); model.TempComments = dt.Rows[0]["GekComments"].ToString(); qcMainList.Add(model); }
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); } }