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