各工序趋势图后端查询

zrg

2024-08-30 52fdbb3d0c065abc0bba434188c98affed024e76

各工序趋势图后端查询

 WebAPI/Controllers/品质管理/质量报表/QC_QualityReportsController.cs

@@ -640,17 +640,17 @@
        {
            try
            {
                List<object> columnNameList = new List<object>();              
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Sc_StationOutBillQuery_HProc order by 鏃ユ湡 desc", "h_v_Sc_StationOutBillQuery_HProc");
                }
                else
                {
                    string sql1 = "select * from h_v_Sc_StationOutBillQuery_HProc where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by 鏃ユ湡 ";
                    ds = oCN.RunProcReturn(sql, "h_v_Sc_StationOutBillQuery_HProc");
                }
                List<object> columnNameList = new List<object>();
                Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere);

                string HYear = dic["HYear"].ToString();
                string HMonth = dic["HMonth"].ToString();
                string HDivisionName = dic["HDivisionName"].ToString();
                string HProcName = dic["HProcName"].ToString();
                string HMaterName = dic["HMaterName"].ToString();
                
                ds = oCN.RunProcReturn("exec h_p_Sc_StationOutBillQuery_HProc '" + HYear + "','" + HMonth + "','" + HDivisionName + "','" + HProcName + "','" + HMaterName + "'", "h_p_SB_EquipICMOTechParamBillList");


                //娣诲姞鍒楀悕
                foreach (DataColumn col in ds.Tables[0].Columns)