末件检验单优化

wtt

2025-10-31 53868f5fa77292e861cf63d1536b1e2697019a1f

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

@@ -293,13 +293,19 @@
        /// </summary>
        [Route("QC_Report/QualityTraceability1")]
        [HttpGet]
        public object QualityTraceability1(string HICMOBillNo, string HType)
        public object QualityTraceability1(string sWhere, string HType)
        {
            try
            {
                List<object> columnNameList = new List<object>();

                ds = oCN.RunProcReturn("exec h_p_Sc_QueryQualityByICMOBill '" + HType + "','" + HICMOBillNo + "'", "h_p_Sc_QueryQualityByICMOBill");
                Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere);

                string HICMOInterID = dic["HICMOInterID"].ToString();
                string HICMOEntryID = dic["HICMOEntryID"].ToString();
                string HICMOBillNo = dic["HICMOBillNo"].ToString();

                ds = oCN.RunProcReturn("exec h_p_Sc_QueryQualityByICMOBill '" + HType + "','" + HICMOBillNo + "','"+ HICMOInterID + "','"+ HICMOEntryID + "'", "h_p_Sc_QueryQualityByICMOBill");
               

                //娣诲姞鍒楀悕
@@ -336,13 +342,20 @@
        /// </summary>
        [Route("QC_Report/QualityTraceability2")]
        [HttpGet]
        public object QualityTraceability2(string HICMOBillNo, string HType)
        public object QualityTraceability2(string sWhere, string HType)
        {
            try
            {
                List<object> columnNameList = new List<object>();

                ds = oCN.RunProcReturn("exec h_p_Sc_QueryQualityByICMOBill '" + HType + "','" + HICMOBillNo + "'", "h_p_Sc_QueryQualityByICMOBill");
                Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere);

                string HICMOInterID = dic["HICMOInterID"].ToString();
                string HICMOEntryID = dic["HICMOEntryID"].ToString();
                string HICMOBillNo = dic["HICMOBillNo"].ToString();

                ds = oCN.RunProcReturn("exec h_p_Sc_QueryQualityByICMOBill '" + HType + "','" + HICMOBillNo + "','" + HICMOInterID + "','" + HICMOEntryID + "'", "h_p_Sc_QueryQualityByICMOBill");



                //娣诲姞鍒楀悕
@@ -379,13 +392,18 @@
        /// </summary>
        [Route("QC_Report/QualityTraceability3")]
        [HttpGet]
        public object QualityTraceability3(string HICMOBillNo, string HType)
        public object QualityTraceability3(string sWhere, string HType)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere);

                ds = oCN.RunProcReturn("exec h_p_Sc_QueryQualityByICMOBill '" + HType + "','" + HICMOBillNo + "'", "h_p_Sc_QueryQualityByICMOBill");
                string HICMOInterID = dic["HICMOInterID"].ToString();
                string HICMOEntryID = dic["HICMOEntryID"].ToString();
                string HICMOBillNo = dic["HICMOBillNo"].ToString();

                ds = oCN.RunProcReturn("exec h_p_Sc_QueryQualityByICMOBill '" + HType + "','" + HICMOBillNo + "','" + HICMOInterID + "','" + HICMOEntryID + "'", "h_p_Sc_QueryQualityByICMOBill");


                //娣诲姞鍒楀悕
@@ -422,13 +440,20 @@
        /// </summary>
        [Route("QC_Report/QualityTraceability4")]
        [HttpGet]
        public object QualityTraceability4(string HICMOBillNo, string HType)
        public object QualityTraceability4(string sWhere, string HType)
        {
            try
            {
                List<object> columnNameList = new List<object>();

                ds = oCN.RunProcReturn("exec h_p_Sc_QueryQualityByICMOBill '" + HType + "','" + HICMOBillNo + "'", "h_p_Sc_QueryQualityByICMOBill");
                Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere);

                string HICMOInterID = dic["HICMOInterID"].ToString();
                string HICMOEntryID = dic["HICMOEntryID"].ToString();
                string HICMOBillNo = dic["HICMOBillNo"].ToString();

                ds = oCN.RunProcReturn("exec h_p_Sc_QueryQualityByICMOBill '" + HType + "','" + HICMOBillNo + "','" + HICMOInterID + "','" + HICMOEntryID + "'", "h_p_Sc_QueryQualityByICMOBill");



                //娣诲姞鍒楀悕
@@ -465,13 +490,19 @@
        /// </summary>
        [Route("QC_Report/QualityTraceability5")]
        [HttpGet]
        public object QualityTraceability5(string HICMOBillNo, string HType)
        public object QualityTraceability5(string sWhere, string HType)
        {
            try
            {
                List<object> columnNameList = new List<object>();

                ds = oCN.RunProcReturn("exec h_p_Sc_QueryQualityByICMOBill '" + HType + "','" + HICMOBillNo + "'", "h_p_Sc_QueryQualityByICMOBill");
                Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere);

                string HICMOInterID = dic["HICMOInterID"].ToString();
                string HICMOEntryID = dic["HICMOEntryID"].ToString();
                string HICMOBillNo = dic["HICMOBillNo"].ToString();

                ds = oCN.RunProcReturn("exec h_p_Sc_QueryQualityByICMOBill '" + HType + "','" + HICMOBillNo + "','" + HICMOInterID + "','" + HICMOEntryID + "'", "h_p_Sc_QueryQualityByICMOBill");


                //娣诲姞鍒楀悕