生产领料单：反审核时反写库存数据

duhe

2025-03-19 bdddd7b94a6d437b693a9b43bd9a4a0b220b4818

 WebAPI/Controllers/MateOutController.cs

@@ -2267,7 +2267,7 @@
        /// </summary>
        [Route("Sc_BadReasonReport/list")]
        [HttpGet]
        public object list(string sWhere, string user)
        public object list(string sWhere, string user,string HGroupID)
        {
            try
            {
@@ -2291,7 +2291,7 @@
                }
                else
                {
                    ds = oCN.RunProcReturn("exec h_p_Sc_BadReasonReport '" + sWhere + "'", "h_p_Sc_BadReasonReport");
                    ds = oCN.RunProcReturn("exec h_p_Sc_BadReasonReport '" + sWhere + "','" + HGroupID + "'", "h_p_Sc_BadReasonReport");
                }

                //添加列名
@@ -2726,6 +2726,38 @@
        }
        #endregion

        #region  工厂日历批改上班工时
        [Route("Gy_PlanShifts/BulkWorkTime")]
        [HttpGet]
        public object BulkWorkTime(string HSourceNumber1, string HSourceNumber2, string HBeginDate, string HEndDate,string HWorkTime)
        {
            try
            {               
                oCN.BeginTran();

                string sql = $"update a set HOverTimes = {HWorkTime} from Gy_PlanShifts a left join Gy_Source b on a.HSourceID = b.HItemID where b.HNumber between '{HSourceNumber1}' and '{HSourceNumber2}' and CONVERT(varchar(120),a.HDate,23) between CONVERT(varchar(120),'{HBeginDate}',23) and CONVERT(varchar(120),'{HEndDate}',23)";

                //执行更新上班工时语句
                oCN.RunProc(sql);

                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "批改成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }        
        #endregion

        #region  制成率明细报表
        [Route("MaterOutEntryReport/Sc_ProductedRateReport")]