1

duhe

2024-07-08 69f3ee1b7f46a7f680002d10e6b39cf8d664a4f4

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

@@ -465,13 +465,29 @@
        /// </summary>
        [Route("QC_CustomerAppealReport/QC_InspectionFormReport")]
        [HttpGet]
        public object QC_InspectionFormReport(string sWhere)
        public object QC_InspectionFormReport(string sWhere,string user)
        {
            try
            {
                List<object> columnNameList = new List<object>();
                if (sWhere == null || sWhere == "") {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "鏃犳煡璇㈡潯浠讹紒";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //ds = oCN.RunProcReturn("exec h_p_QC_InspectionFormReport '" + Year + "','" + DeptName + "'", "h_p_QC_InspectionFormReport");
                Dictionary<object, object>  dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere);


                string HBeginDate = dic["HBeginDate"].ToString();
                string HEndDate = dic["HEndDate"].ToString();
                int limit = int.Parse(dic["limit"].ToString());
                int HQCCheckItemID = int.Parse(dic["HQCCheckItemID"].ToString());
                int HMaterID = int.Parse(dic["HMaterID"].ToString());

                ds = oCN.RunProcReturn("exec h_p_QC_InspectionFormReport '" + HBeginDate + "','" + HEndDate + "'," + limit + "," + HQCCheckItemID + "," + HMaterID, "h_p_QC_InspectionFormReport");

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