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 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 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 AddModels(QcconstructiondtlModelList models, DbTransaction tran) { for (int i = 0; i < models.Count; i++) { this.AddModel(models[i], tran); } }
public void InitConstruction(DataTable dt) { qcConstructionList = new QcconstructiondtlModelList(); if (dt.Rows.Count == 0) { return; } for (int i = 0; i < dt.Rows.Count; i++) { QcconstructiondtlModel cm = new QcconstructiondtlModel(); cm.Construction = dt.Rows[i]["Construction"].ToString(); qcConstructionList.Add(cm); } }
public string InitInfo(string code) { // 把code转化为大写 by LYH 2014/2/25 code = code.ToUpper(); qcMainList = qcMainManager.GetModelList(new QcmaininfoModel() { QualityCode = code }); qcYarnList = qcYarnManager.GetModelList(new QcyarndtlModel() { QualityCode = code }); qcAvaList = qcAvaWidthManager.GetModelList(new QcavailablewidthModel() { QualityCode = code }); qcFinishList = qcFinishManager.GetModelList(new QcfinishdtlModel() { QualityCode = code }); qcCustomerList = qcCustomerManager.GetModelList(new QccustomerlibraryModel() { QualityCode = code }); qcConstructionList = qcConstructionManager.GetModelList(new QcconstructiondtlModel() { QualityCode = code }); InitCAttribute(); if (qcMainList.Count < 1) { return("No"); } string i = GetCmainInfo() + "<|>" + GetCConstruction() + "<|>" + GetCFinish() + "<|>" + GetCAvaWdith() + "<|>" + qcMainList[0].YarnLength + "<|>" + qcMainList[0].Measurement + "<|>" + qcMainList[0].TappingType + "<|>" + qcMainList[0].AnalysisNo + "<|>" + qcMainList[0].Sourcing + "<|>" + qcMainList[0].Status + "<|>" + qcMainList[0].MaterialGroup + "<|>" + qcMainList[0].Remark + "<|>" + qcMainList[0].GK_NO + "<|>" + qcMainList[0].QC_Ref_PPO + "<|>" + qcMainList[0].QC_Ref_GP + "<|>" + qcMainList[0].HF_Ref_PPO + "<|>" + qcMainList[0].HF_Ref_GP + "<|>" + qcMainList[0].RF_Remark; return(GetCmainInfo() + "<|>" + GetCConstruction() + "<|>" + GetCFinish() + "<|>" + GetCAvaWdith() + "<|>" + qcMainList[0].YarnLength + "<|>" + qcMainList[0].Measurement + "<|>" + qcMainList[0].TappingType + "<|>" + qcMainList[0].AnalysisNo + "<|>" + qcMainList[0].Sourcing + "<|>" + qcMainList[0].Status + "<|>" + qcMainList[0].MaterialGroup + "<|>" + qcMainList[0].Remark + "<|>" + qcMainList[0].GK_NO + "<|>" + qcMainList[0].QC_Ref_PPO + "<|>" + qcMainList[0].QC_Ref_GP + "<|>" + qcMainList[0].HF_Ref_PPO + "<|>" + qcMainList[0].HF_Ref_GP + "<|>" + qcMainList[0].RF_Remark); }
public QcconstructiondtlModelList GetModelListOne(QcconstructiondtlModel model) { QcconstructiondtlTable table = new QcconstructiondtlTable(); PbknitconstructionTable table1 = new PbknitconstructionTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table1, table1.Description).Join(table, table1.Construction == table.Construction); if (model.QualityCode != "") { sql.Where(table.QualityCode == model.QualityCode); } using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) { QcconstructiondtlModelList result = new QcconstructiondtlModelList(); while (sdr.Read()) { QcconstructiondtlModel m = new QcconstructiondtlModel(); m.Construction = sdr.GetString(table1.Description); result.Add(m); } return(result); } }
public QcconstructiondtlModelList GetModelList(QcconstructiondtlModel model) { QcconstructiondtlTable table = new QcconstructiondtlTable(); SelectSqlSection sql = DataAccess.DefaultDB.Select(table, table.AllColumns()); if (model.QualityCode != "") { sql.Where(table.QualityCode == model.QualityCode); } using (SafeDataReader sdr = new SafeDataReader(sql.ToDataReader())) { QcconstructiondtlModelList result = new QcconstructiondtlModelList(); while (sdr.Read()) { QcconstructiondtlModel m = new QcconstructiondtlModel(); m.Iden = sdr.GetInt32(table.Iden); m.QualityCode = sdr.GetString(table.QualityCode); m.Construction = sdr.GetString(table.Construction); result.Add(m); } return(result); } }
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); } }
public static DataTable DataTable() { string connString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; OracleConnection con = new OracleConnection(connString); con.Open(); string cmd = "SELECT * " + " FROM (SELECT ROWNUM as Items, E.* " + " FROM (SELECT DISTINCT A.* " + " FROM QCMainInfo A " + " LEFT JOIN QCConstructionDtl B " + " ON A.Quality_Code = B.Quality_Code " + " LEFT JOIN QCFinishDtl C " + " ON A.Quality_COde = C.Quality_Code " + " LEFT JOIN QCCustomerLibrary D " + " ON D.Quality_Code = A.Quality_Code " + " LEFT JOIN QCCustomerLibrary F " + " ON F.Quality_Code=A.Quality_Code " + " where 1=1 " + a + " order by A.Quality_Code asc ) E) "; using (OracleDataAdapter oleAdper = new OracleDataAdapter(cmd, con)) { DataTable result = new DataTable("table"); oleAdper.Fill(result); if (result.Rows.Count >= 100) { string cmds = @" select distinct A.quality_code,A.status, A.replace_by, A.repeat, L.ApprovedFromSPPO, L.ApprovedFromSPPO_Usage, to_char(S.descriptions) as construction , to_char(K.finishing_name) as Finishing,A.pattern, (N.DESCRIPTION) as DYE_METHOD , A.bf_gmmm, A.af_gmmm, A.shrinkage, A.shrinkage_testing_method, A.gmt_washing,to_char(J.customer_quality_id) as customer_quality_id, to_char(H.AvailableWidth) as AvailableWidth, A.remark,to_char(I.YarnInfo) as YarnInfo,A.layout, A.yarn_length, A.tapping_type ,(A.special_type ) as Heavy_Flat_Knit, to_char(J.mill_comments) as mill_comments,A.measurement, A.sourcing, A.create_date, A.material_group, A.analysis_no, A.ref_quality_code, A.creator, A.approve_date, A.approver, to_char(J.buyer_id) as buyer_id, to_char(J.brand) as Branks, A.gk_no, A.qc_ref_ppo, A.qc_ref_gp, A.hf_ref_ppo, A.hf_ref_gp,M.customercomment from QCMainInfo A left join QCConstructionDtl B on A.Quality_Code = B.Quality_Code left join QCFinishDtl C on A.Quality_COde = C.Quality_Code left join QCCustomerLibrary D on A.Quality_Code = D.Quality_Code left join QCCustomerLibrary F on A.Quality_Code = F.Quality_Code left join ( select * from ( select Quality_Code , wm_concat(to_char(description)) as descriptions from QCConstructionDtl G left join Pbknitconstruction S on S.construction=G.construction group by Quality_Code )) S on A.Quality_Code=S.Quality_Code -- left join QCConstructionDtl G on A.Quality_Code = G.Quality_Code -- left join Pbknitconstruction M on M.construction=G.construction left join PBKNITDYEMETHOD N on A.DYE_METHOD =N.DYE_METHOD left join (select * from (select quality_code, (wmsys.wm_concat(''||gauge||'G'||diameter||'Inch/'||total_needles||'N/'||width||'-'||max_width||'\' )) as AvailableWidth from qcavailablewidth where 1=1 group by quality_code) ) H on A.Quality_Code = H.Quality_Code left join (select * from ( select quality_code,( wmsys.wm_concat( ''||yarn_count||'X'||threads||''||b.DESCRIPTION||''||yarn_ratio||'% '||yarn_component||'' ))as YarnInfo from qcyarndtl a left join PBKNITYARNTYPE b on a.YARN_TYPE=b.YARN_TYPE where 1=1 group by quality_code) ) I on A.Quality_Code = I.Quality_Code left join (select * from (select quality_code , (wmsys.wm_concat(buyer_id)) as buyer_id , (wmsys.wm_concat(brand)) as brand, (wmsys.wm_concat(customer_quality_id)) as customer_quality_id,(wmsys.wm_concat(mill_comments) ) as mill_comments from QCCustomerLibrary where 1=1 group by quality_code)) J on A.Quality_Code=j.Quality_Code left join (select * from (select quality_code, (wmsys.wm_concat(z.finishing_name )) as finishing_name from QCFinishDtl y, pbknitfinish Z where y.finishing_code= z.finishing_code group by quality_code)) K on A.Quality_Code = K.Quality_Code left join ( select quality_code, ApprovedFromSPPO,ApprovedFromSPPO_Usage from ( --modify:gaofeng 2021/01/18 <2021-0001 QC System Enhancement from sales> --begin --select ROW_NUMBER() OVER(PARTITION BY quality_code ORDER BY approve_date desc) rn, --quality_code, ApprovedFromSPPO from (SELECT distinct qm.quality_code,( pi.ppo_no|| '('||pi.FABRIC_TYPE_CD ||')' ) as ApprovedFromSPPO ,QCC.approve_date --FROM ppo_hd ph,gen_customer c,ppo_qcmaininfo qc, ppo_item pi, fab_combo fc, ppo_qccomment qcc,ppo_item_combo pic,QCMainInfo qm --WHERE ph.ppo_no=pi.ppo_no and fc.fab_combo_id = qcc.fab_combo_id and qc.ppo_item_id=pi.ppo_item_id --and pi.ppo_item_id=pic.ppo_item_id and pi.quality_code=qm.quality_code and pic.fab_combo_id=fc.fab_combo_id --and qc.ppo_qc_id=qcc.ppo_qc_id and ph.customer_cd=c.customer_cd and QCC.STATUS='Approved' )s ) where rn=1 select ROW_NUMBER() OVER(PARTITION BY quality_code ORDER BY approve_date desc) rn, quality_code, ApprovedFromSPPO,ApprovedFromSPPO_Usage from ( SELECT distinct qm.quality_code, --( pi.ppo_no|| '('||pi.FABRIC_TYPE_CD ||')' ) as ApprovedFromSPPO , pi.ppo_no as ApprovedFromSPPO, pi.FABRIC_TYPE_CD as ApprovedFromSPPO_Usage, QCC.approve_date FROM ppo_hd ph,gen_customer c,ppo_qcmaininfo qc, ppo_item pi, fab_combo fc, ppo_qccomment qcc,ppo_item_combo pic,QCMainInfo qm WHERE ph.ppo_no=pi.ppo_no and fc.fab_combo_id = qcc.fab_combo_id and qc.ppo_item_id=pi.ppo_item_id and pi.ppo_item_id=pic.ppo_item_id and pi.quality_code=qm.quality_code and pic.fab_combo_id=fc.fab_combo_id and qc.ppo_qc_id=qcc.ppo_qc_id and ph.customer_cd=c.customer_cd and QCC.STATUS='Approved' )s ) where rn=1 --modify:gaofeng 2021/01/18 <2021-0001 QC System Enhancement from sales> --end ) L on A.Quality_Code = L.Quality_Code left join ( select * from (SELECT ROW_NUMBER() OVER(PARTITION BY pi.quality_code ORDER BY qcc.customer_comment ) rn, (qcc.customer_comment ) as customercomment ,pi.quality_code FROM ppo_hd ph,gen_customer c,ppo_qcmaininfo qc, ppo_item pi, fab_combo fc, ppo_qccomment qcc,ppo_item_combo pic,QCMainInfo qm WHERE ph.ppo_no=pi.ppo_no and fc.fab_combo_id = qcc.fab_combo_id and qc.ppo_item_id=pi.ppo_item_id and pi.ppo_item_id=pic.ppo_item_id and pi.quality_code=qm.quality_code and qm.Material_Group<>'Flat Knit Fabric' AND pic.fab_combo_id=fc.fab_combo_id and qc.ppo_qc_id=qcc.ppo_qc_id and ph.customer_cd=c.customer_cd )s WHERE rn = 1 ) M on A.Quality_Code = M.quality_code where 1=1 " + a + " order by A.Quality_Code asc "; using (OracleDataAdapter oleAdpers = new OracleDataAdapter(cmds, con)) { DataTable results = new DataTable("table"); oleAdpers.Fill(results); results.Columns["QUALITY_CODE"].ColumnName = "QualityCode"; results.Columns["STATUS"].ColumnName = "Status"; results.Columns["REPLACE_BY"].ColumnName = "ReplaceBy"; results.Columns["REPEAT"].ColumnName = "Repeat"; results.Columns["APPROVEDFROMSPPO"].ColumnName = "ApprovedFromSPPO"; //modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --begin results.Columns["APPROVEDFROMSPPO_USAGE"].ColumnName = "ApprovedFromSPPO_Usage"; //modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --end results.Columns["CONSTRUCTION"].ColumnName = "Construction"; results.Columns["FINISHING"].ColumnName = "Finishing"; results.Columns["PATTERN"].ColumnName = "Pattern"; results.Columns["DYE_METHOD"].ColumnName = "DyeMethod"; results.Columns["BF_GMMM"].ColumnName = "BfGmmm"; results.Columns["AF_GMMM"].ColumnName = "AfGmmm"; results.Columns["SHRINKAGE"].ColumnName = "Shrinkage"; results.Columns["SHRINKAGE_TESTING_METHOD"].ColumnName = "ShrinkageTestingMethod"; results.Columns["GMT_WASHING"].ColumnName = "GmtWashing"; results.Columns["CUSTOMER_QUALITY_ID"].ColumnName = "CustomerQualityId"; results.Columns["AVAILABLEWIDTH"].ColumnName = "Available Width"; results.Columns["REMARK"].ColumnName = "Available Width Remark"; results.Columns["YARNINFO"].ColumnName = "YarnInfo"; results.Columns["LAYOUT"].ColumnName = "Layout"; results.Columns["YARN_LENGTH"].ColumnName = "YarnLength"; results.Columns["TAPPING_TYPE"].ColumnName = "TappingType"; results.Columns["HEAVY_FLAT_KNIT"].ColumnName = "Heavy_Flat_Knit"; results.Columns["MILL_COMMENTS"].ColumnName = "MillComments"; results.Columns["MEASUREMENT"].ColumnName = "Measurement"; results.Columns["SOURCING"].ColumnName = "Sourcing"; results.Columns["CREATE_DATE"].ColumnName = "CreateDate"; results.Columns["MATERIAL_GROUP"].ColumnName = "MaterialGroup"; results.Columns["ANALYSIS_NO"].ColumnName = "AnalysisNo"; results.Columns["REF_QUALITY_CODE"].ColumnName = "RefQualityCode"; results.Columns["CREATOR"].ColumnName = "Creator"; results.Columns["APPROVE_DATE"].ColumnName = "ApproveDate"; results.Columns["APPROVER"].ColumnName = "Approver"; results.Columns["BUYER_ID"].ColumnName = "BuyerIds"; results.Columns["BRANKS"].ColumnName = "Branks"; results.Columns["GK_NO"].ColumnName = "GK_NO"; results.Columns["QC_REF_PPO"].ColumnName = "QC_Ref_PPO"; results.Columns["QC_REF_GP"].ColumnName = "QC_Ref_GP"; results.Columns["HF_REF_PPO"].ColumnName = "HF_Ref_PPO"; results.Columns["HF_REF_GP"].ColumnName = "HF_Ref_GP"; results.Columns["CUSTOMERCOMMENT"].ColumnName = "CustomerComment"; return(results); } } else { DataTable dtt = new DataTable(); dtt.Columns.Add("QualityCode", typeof(string)); dtt.Columns.Add("Status", typeof(string)); dtt.Columns.Add("ReplaceBy", typeof(string)); dtt.Columns.Add("Repeat", typeof(string)); dtt.Columns.Add("ApprovedFromSPPO", typeof(string)); //modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --begin dtt.Columns.Add("ApprovedFromSPPO_Usage", typeof(string)); //modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --end dtt.Columns.Add("Construction", typeof(string)); dtt.Columns.Add("Finishing", typeof(string)); dtt.Columns.Add("Pattern", typeof(string)); dtt.Columns.Add("DyeMethod", typeof(string)); dtt.Columns.Add("BfGmmm", typeof(string)); dtt.Columns.Add("AfGmmm", typeof(string)); dtt.Columns.Add("Shrinkage", typeof(string)); dtt.Columns.Add("ShrinkageTestingMethod", typeof(string)); dtt.Columns.Add("GmtWashing", typeof(string)); http://localhost:58826/Service References/ dtt.Columns.Add("CustomerQualityId", typeof(string)); dtt.Columns.Add("Available Width", typeof(string)); dtt.Columns.Add("Available Width Remark", typeof(string)); dtt.Columns.Add("YarnInfo", typeof(string)); dtt.Columns.Add("Layout", typeof(string)); dtt.Columns.Add("YarnLength", typeof(string)); dtt.Columns.Add("TappingType", typeof(string)); dtt.Columns.Add("Heavy_Flat_Knit", typeof(string)); dtt.Columns.Add("MillComments", typeof(string)); dtt.Columns.Add("Measurement", typeof(string)); dtt.Columns.Add("Sourcing", typeof(string)); dtt.Columns.Add("CreateDate", typeof(string)); dtt.Columns.Add("MaterialGroup", typeof(string)); dtt.Columns.Add("AnalysisNo", typeof(string)); dtt.Columns.Add("RefQualityCode", typeof(string)); dtt.Columns.Add("Creator", typeof(string)); dtt.Columns.Add("ApproveDate", typeof(string)); dtt.Columns.Add("Approver", typeof(string)); dtt.Columns.Add("BuyserIds", typeof(string)); dtt.Columns.Add("Branks", typeof(string)); dtt.Columns.Add("GK_NO", typeof(string)); dtt.Columns.Add("QC_Ref_PPO", typeof(string)); dtt.Columns.Add("QC_Ref_GP", typeof(string)); dtt.Columns.Add("HF_Ref_PPO", typeof(string)); dtt.Columns.Add("HF_Ref_GP", typeof(string)); dtt.Columns.Add("CustomerComment", typeof(string)); string connStrings = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; OracleConnection cons = new OracleConnection(connStrings); cons.Open(); string Sql1 = "SELECT * " + " FROM (SELECT ROWNUM as Items, E.* " + " FROM (SELECT DISTINCT A.* " + " FROM QCMainInfo A " + " LEFT JOIN QCConstructionDtl B " + " ON A.Quality_Code = B.Quality_Code " + " LEFT JOIN QCFinishDtl C " + " ON A.Quality_COde = C.Quality_Code " + " LEFT JOIN QCCustomerLibrary D " + " ON D.Quality_Code = A.Quality_Code " + " LEFT JOIN QCCustomerLibrary F " + " ON F.Quality_Code=A.Quality_Code " + " where 1=1 @Condition order by A.Quality_Code asc ) E) "; PbknityarntypeManager yarnManager = new PbknityarntypeManager();//kingzhang for support 709786 对于YarnInfo字符串中的Yarn_Type信息替换为pbKnitYarnType.description QcconstructiondtlManager qcm = new QcconstructiondtlManager(); QcfinishdtlManager qsm = new QcfinishdtlManager(); QccustomerlibraryManager qlm = new QccustomerlibraryManager(); QcconstructiondtlModelList qcml = new QcconstructiondtlModelList(); QcfinishdtlModelList qsml = new QcfinishdtlModelList(); QccustomerlibraryModelList qclm = new QccustomerlibraryModelList(); QcavailablewidthModelList qsaw = new QcavailablewidthModelList(); QcavailablewidthManager qcam = new QcavailablewidthManager(); QcyarndtlManager qym = new QcyarndtlManager(); QcyarndtlModelList qyml = new QcyarndtlModelList(); DataSet ds; CustomSqlSection css; DataTable dt; QcmaininfoTable table = new QcmaininfoTable(); Sql1 = Sql1.Replace("@Condition", a.ToString()); CustomSqlSection csql1 = DataAccess.DefaultDB.CustomSql(Sql1); using (SafeDataReader sdr = new SafeDataReader(csql1.ToDataReader())) { while (sdr.Read()) { QcmaininfoModel m = new QcmaininfoModel(); m.QualityCode = sdr.GetString(table.QualityCode); qcml = qcm.GetModelListOne(new QcconstructiondtlModel() { QualityCode = m.QualityCode }); for (int i = 0; i < qcml.Count; i++) { m.Construction = m.Construction + qcml[i].Construction + ";"; } qsml = qsm.GetModelListOne(new QcfinishdtlModel() { QualityCode = m.QualityCode }); for (int i = 0; i < qsml.Count; i++) { m.Finishing = m.Finishing + qsml[i].FinishingCode + ";"; } qclm = qlm.GetModelList(new QccustomerlibraryModel() { QualityCode = m.QualityCode }); for (int i = 0; i < qclm.Count; i++) { m.CustomerQualityId = m.CustomerQualityId + qclm[i].CustomerQualityId + ";"; m.BuyserIds = m.BuyserIds + qclm[i].BuyerId + ";"; m.Brank = m.Brank + qclm[i].Brand + ";"; m.MillComments = m.MillComments + qclm[i].MillComments + ";"; } qsaw = qcam.GetModelList(new QcavailablewidthModel() { QualityCode = m.QualityCode }); for (int i = 0; i < qsaw.Count; i++) { if (i != qsaw.Count - 1) { m.AvaWidth = m.AvaWidth + string.Format("{0}G{1}Inch/{2}N/{3}-{4}\"", qsaw[i].Gauge, qsaw[i].Diameter, qsaw[i].TotalNeedles, qsaw[i].Width, qsaw[i].MaxWidth) + "--"; } else { m.AvaWidth = m.AvaWidth + string.Format("{0}G{1}Inch/{2}N/{3}-{4}\"", qsaw[i].Gauge, qsaw[i].Diameter, qsaw[i].TotalNeedles, qsaw[i].Width, qsaw[i].MaxWidth); } } qyml = qym.GetModelList(new QcyarndtlModel() { QualityCode = m.QualityCode }); for (int i = 0; i < qyml.Count; i++) { PbknityarntypeModelList yarnModel = yarnManager.GetModelList(new PbknityarntypeModel() { YarnType = qyml[i].YarnType }); //kingzhang for support 709786 对于YarnInfo字符串中的Yarn_Type信息替换为pbKnitYarnType.description if (i != qyml.Count - 1) { m.YarnInfo = m.YarnInfo + string.Format("{0}X{1} {2} {3}% {4}", qyml[i].YarnCount, qyml[i].Threads, yarnModel.Count > 0 ? yarnModel[0].Description : qyml[i].YarnType, qyml[i].YarnRatio, qyml[i].YarnComponent) + "--"; } else { m.YarnInfo = m.YarnInfo + string.Format("{0}X{1} {2} {3}% {4}", qyml[i].YarnCount, qyml[i].Threads, yarnModel.Count > 0 ? yarnModel[0].Description : qyml[i].YarnType, qyml[i].YarnRatio, qyml[i].YarnComponent); } } //modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --begin css = DataAccess.DefaultDB.CustomSql(@" select ppo_no as PPO , FABRIC_TYPE_CD from (select ROW_NUMBER() OVER(PARTITION BY quality_code ORDER BY approve_date desc) rn, quality_code,ppo_no, FABRIC_TYPE_CD from (SELECT distinct qm.quality_code, pi.ppo_no ,pi.FABRIC_TYPE_CD ,QCC.approve_date FROM ppo_hd ph,gen_customer c,ppo_qcmaininfo qc, ppo_item pi, fab_combo fc, ppo_qccomment qcc,ppo_item_combo pic,QCMainInfo qm WHERE ph.ppo_no=pi.ppo_no and fc.fab_combo_id = qcc.fab_combo_id and qc.ppo_item_id=pi.ppo_item_id and pi.ppo_item_id=pic.ppo_item_id and pi.quality_code=qm.quality_code and pic.fab_combo_id=fc.fab_combo_id and qc.ppo_qc_id=qcc.ppo_qc_id and ph.customer_cd=c.customer_cd and QCC.STATUS='Approved' )s ) where rn=1 and quality_code=@QC "); //modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --end css.AddInputParameter("QC", DbType.String, m.QualityCode); ds = css.ToDataSet(); dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { //m.ApprovedFromSPPO = m.ApprovedFromSPPO + dt.Rows[i]["PPO"].ToString() + "(" + dt.Rows[i]["FABRIC_TYPE_CD"].ToString() + ");"; //modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --begin m.ApprovedFromSPPO = m.ApprovedFromSPPO + dt.Rows[i]["PPO"].ToString(); m.ApprovedFromSPPO_Usage = m.ApprovedFromSPPO_Usage + dt.Rows[i]["FABRIC_TYPE_CD"].ToString(); } ; //modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --end m.CreateDate = sdr.GetDateTime(table.CreateDate); m.Creator = sdr.GetString(table.Creator); m.ApproveDate = sdr.GetDateTime(table.ApproveDate); m.Approver = sdr.GetString(table.Approver); m.Status = sdr.GetString(table.Status); if (m.Status == "NEW") { m.Status = "New"; } m.Sourcing = sdr.GetString(table.Sourcing); m.MaterialGroup = sdr.GetString(table.MaterialGroup); m.AnalysisNo = sdr.GetString(table.AnalysisNo); m.RefQualityCode = sdr.GetString(table.RefQualityCode); m.Pattern = sdr.GetString(table.Pattern); m.DyeMethod = sdr.GetString(table.DyeMethod); m.ReplaceBy = sdr.GetString(table.ReplaceBy); m.Repeat = sdr.GetString(table.REPEAT); m.BfGmmm = sdr.GetInt32(table.BfGmmm); m.AfGmmm = sdr.GetInt32(table.AfGmmm); m.Shrinkage = sdr.GetString(table.Shrinkage); m.ShrinkageTestingMethod = sdr.GetString(table.ShrinkageTestingMethod); m.GmtWashing = sdr.GetString(table.GmtWashing); m.Layout = sdr.GetString(table.Layout); m.YarnLength = sdr.GetString(table.YarnLength); m.TappingType = sdr.GetString(table.TappingType); m.Measurement = sdr.GetString(table.Measurement); m.Remark = sdr.GetString(table.Remark); m.SpecialType = sdr.GetString(table.SpecialType); m.LastUpdateTime = sdr.GetDateTime(table.LastUpdateTime); m.LastUpdateBy = sdr.GetString(table.LastUpdateBy); m.GK_NO = sdr.GetString(table.GK_NO); m.QC_Ref_PPO = sdr.GetString(table.QC_Ref_PPO); m.HF_Ref_PPO = sdr.GetString(table.HF_Ref_PPO); m.QC_Ref_GP = sdr.GetString(table.QC_Ref_GP); m.HF_Ref_GP = sdr.GetString(table.HF_Ref_GP); m.CustomerComment = GetCustomerComment(m.QualityCode); dtt.Rows.Add(m.QualityCode, m.Status, m.ReplaceBy, m.Repeat, //modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --begin m.ApprovedFromSPPO, m.ApprovedFromSPPO_Usage, //modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --end m.Construction, m.Finishing, m.Pattern, m.DyeMethod, m.BfGmmm, m.AfGmmm, m.Shrinkage, m.ShrinkageTestingMethod, m.GmtWashing, m.CustomerQualityId, m.AvaWidth, m.Remark, m.YarnInfo, m.Layout, m.YarnLength, m.TappingType, m.SpecialType, m.MillComments, m.Measurement, m.Sourcing, m.CreateDate, m.MaterialGroup, m.AnalysisNo, m.RefQualityCode, m.Creator, m.ApproveDate, m.Approver, m.BuyserIds, m.Brank, m.GK_NO, m.QC_Ref_PPO, m.QC_Ref_GP, m.HF_Ref_PPO, m.HF_Ref_GP, m.CustomerComment ); } } return(dtt); } } }