器具主档：编辑保存，报错修复

duhe

2025-10-13 8b4c556d97b7b84cdd2b19c4c5544b65add8b3bb

 WebAPI/Controllers/BaseSet/Gy_MaterialController.cs

@@ -317,6 +317,33 @@
        }
        #endregion

        #region 获取车间号
        [Route("Gy_Material/Get_HDepartment")]
        [HttpGet]
        public object Get_HDepartment()
        {
            try
            {
                DataSet oDs = new DataSet();
                //==========
                oDs = oCN.RunProcReturn("select top(20) HItemID , HName from Gy_Department", "Gy_Department");
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "获取成功！";
                objJsonResult.data = oDs.Tables[0];
                return objJsonResult; ;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除失败！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        /// <summary>
        /// 获取项目列表
        /// </summary>
@@ -2890,8 +2917,7 @@
                }
                //=========================================================

                //主表
                oCN.RunProc("UpDate Gy_MouldFileMain set  " +
                string sql = "UpDate Gy_MouldFileMain set  " +
                " HBillNo='" + HBillNo + "'" +  //固定赋值===============
                ",HDate='" + HDate + "'" +
                ",HYear='" + HYear.ToString() + "'" +
@@ -2944,10 +2970,13 @@
                ",HMadeSupID=" + HMadeSupID +
                ",HNowWHID=" + HNowWHID +
                ",HNowSPID=" + HNowSPID +
                ",HInitLife='" + HInitLife +
                ",HInitLife='" + HInitLife + "'" +
                ",HNextMainDate='" + HNextMainDate +
                "',HMouldUseStatus='" + HMouldUseStatus +
                "' where HInterID=" + HInterID.ToString());
                "' where HInterID=" + HInterID.ToString();

                //主表
                oCN.RunProc(sql);

                //修改子项目代码
                //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);