From 2cd22bf33a21e534357c683e8f149f66a0ba5c7b Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期五, 02 八月 2024 15:08:30 +0800 Subject: [PATCH] 首检+巡检+工序检,测试并完善增加,最大/最小/平均/检验记录的值保存,上料防错保存方法中,注释掉给流转卡赋空值,增加 制程绩效趋势图(合格率) 查询 --- WebAPI/Controllers/品质管理/质量报表/QC_QualityReportsController.cs | 47 +++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 47 insertions(+), 0 deletions(-) diff --git "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityReportsController.cs" "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityReportsController.cs" index a860d62..984b459 100644 --- "a/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityReportsController.cs" +++ "b/WebAPI/Controllers/\345\223\201\350\264\250\347\256\241\347\220\206/\350\264\250\351\207\217\346\212\245\350\241\250/QC_QualityReportsController.cs" @@ -931,5 +931,52 @@ } } #endregion + + + #region 璐ㄩ噺妯″潡 鍒剁▼缁╂晥瓒嬪娍鍥�(鍚堟牸鐜�) 鏌ヨ + + [Route("QC_CustomerAppealReport/getQC_ProcessPerformancePass")] + [HttpGet] + public object getQC_ProcessPerformancePass(string sWhere, string user) + { + try + { + List<object> columnNameList = new List<object>(); + if (sWhere == null || sWhere.Equals("")) + { + ds = oCN.RunProcReturn("select * from h_v_QC_ProcessPerformancePassList order by 鏈堜唤 desc", "h_v_QC_ProcessPerformancePassList"); + } + else + { + string sql1 = "select * from h_v_QC_ProcessPerformancePassList where 1 = 1 "; + string sql = sql1 + sWhere + " order by 鏈堜唤 "; + ds = oCN.RunProcReturn(sql, "h_v_QC_ProcessPerformancePassList"); + } + + //娣诲姞鍒楀悕 + foreach (DataColumn col in ds.Tables[0].Columns) + { + Type dataType = col.DataType; + string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; + columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕 + } + + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + objJsonResult.list = columnNameList; + return objJsonResult; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } -- Gitblit v1.9.1