PNL布局 增加 审核/禁用 API,修改API 添加 修改人和修改日期信息 PNL检验信息 添加 审核 API,修改API 添加 修改人和修改日期信息

chenhaozhe

2025-06-27 9d14f2b7d4899e17bc73d3b80643a40e09774bb3

 WebAPI/Controllers/生产管理/质量汇报单/Sc_QualityReportBillController.cs

@@ -1847,15 +1847,15 @@
            try
            {
                List<object> columnNameList = new List<object>();
                //鏌ョ湅鏉冮檺
                if (!DBUtility.ClsPub.Security_Log("Sc_QualityReportBill_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                ////鏌ョ湅鏉冮檺
                //if (!DBUtility.ClsPub.Security_Log("Sc_QualityReportBill_Query", 1, false, user))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                ReportWorkDemandPlanBill Report = JsonConvert.DeserializeObject<ReportWorkDemandPlanBill>(sWhere);
                ds = oCN.RunProcReturn($"exec h_p_Sc_StationOutBillMain  '{Report.HBeginDate}','{Report.HEndDate}','{Report.HNumber}','{Report.HName}','{Report.HProcName}','{Report.HEquipName}','{Report.HBactNo}'", "h_p_Sc_StationOutBillMain");

@@ -1902,15 +1902,15 @@
            try
            {
                List<object> columnNameList = new List<object>();
                //鏌ョ湅鏉冮檺
                if (!DBUtility.ClsPub.Security_Log("Sc_QualityReportBill_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                ////鏌ョ湅鏉冮檺
                //if (!DBUtility.ClsPub.Security_Log("Sc_QualityReportBill_Query", 1, false, user))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                ReportWorkDemandPlanBill1 Report = JsonConvert.DeserializeObject<ReportWorkDemandPlanBill1>(sWhere);
                ds = oCN.RunProcReturn($"exec h_p_Sc_StationOutBillMonth  '{Report.HYear}','{Report.HWorkCenter}','{Report.HName}', '{Report.HBeginDate}','{Report.HEndDate}'", "h_p_Sc_StationOutBillMonth");

@@ -1949,15 +1949,15 @@
            try
            {
                List<object> columnNameList = new List<object>();
                //鏌ョ湅鏉冮檺
                if (!DBUtility.ClsPub.Security_Log("Sc_QualityReportBill_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                ////鏌ョ湅鏉冮檺
                //if (!DBUtility.ClsPub.Security_Log("Sc_QualityReportBill_Query", 1, false, user))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                if (sWhere == null || sWhere.Equals(""))
                {
@@ -2005,15 +2005,15 @@
            try
            {
                List<object> columnNameList = new List<object>();
                //鏌ョ湅鏉冮檺
                if (!DBUtility.ClsPub.Security_Log("Sc_QualityReportBill_Query", 1, false, user))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                ////鏌ョ湅鏉冮檺
                //if (!DBUtility.ClsPub.Security_Log("Sc_QualityReportBill_Query", 1, false, user))
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "鏃犳煡鐪嬫潈闄愶紒";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}

                if (sWhere == null || sWhere.Equals(""))
                {