1

chenhaozhe

2025-06-20 55e832ca189624916a7a2e3e6cf24e513de9b1b4

 WebAPI/Controllers/BaseSet/Gy_TechnologyController.cs

@@ -247,6 +247,7 @@
                DateTime HMakeTime = list[0].HMakeTime;
                string HMakeEmp = list[0].HMakeEmp;


                if (!DBUtility.ClsPub.AllowNumber(HNumber))
                {
                    objJsonResult.code = "0";
@@ -323,7 +324,9 @@
                DateTime HMakeTime = list[0].HMakeTime;
                string HMakeEmp = list[0].HMakeEmp;
                long HUSEORGID = list[0].HUSEORGID;
                long HCREATEORGID = list[0].HCREATEORGID;
                long HCREATEORGID = list[0].HCREATEORGID; 
                long HUnitID = list[0].HUnitID;
                long HClassID = list[0].HClassID;

                //判断权限
                if (!ClsPub.Security_Log("Gy_TechnologyParameter_Edit", 1, false, msg3))
@@ -343,6 +346,8 @@
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                


                //if (oDept.HavSameNumber(HItemID, HNumber))
                //{
@@ -357,6 +362,8 @@
                if (HItemID == 0)
                {
                    oCN.BeginTran();



                    //保存前控制=========================================      
                    string sql1 = "exec h_p_Gy_TechnologyParameter_BeforeSaveCtrl " + HMakeEmp + ",'" + 1 + "'";
@@ -380,14 +387,25 @@
                        oCN.RollBack();
                        return objJsonResult;
                    }

                    string _sql = "select HItemID from Gy_TechnologyParameter where HNumber = N'" + HNumber + "'";
                    DataSet _ds = oCN.RunProcReturn(_sql, "Gy_TechnologyParameter");
                    if (_ds.Tables[0].Rows.Count > 0)
                    {
                        objJsonResult.code = "0";
                        objJsonResult.count = 0;
                        objJsonResult.Message = "保存失败: 工艺代码重复!";
                        objJsonResult.data = null;
                        return objJsonResult;
                    }
                    //================================================================================== 


                    oCN.RunProc("Insert into Gy_TechnologyParameter  " +
                         " (HNumber,HName,HHelpCode,HShortNumber,HParentID,HLevel" +
                         ",HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HMakeEmp,HUSEORGID,HCREATEORGID) " +
                         ",HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HMakeEmp,HUSEORGID,HCREATEORGID, HClassID, HUnitID) " +
                         " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "','" + HParentID.ToString() +
                         "','" + HLevel.ToString() + "','" + HEndFlag + "','" + HStopflag + "','" + HRemark + "','" + HUseFlag + "',getdate(),'" + HMakeEmp + "','" + HUSEORGID + "','" + HCREATEORGID + "')", ref DBUtility.ClsPub.sExeReturnInfo);
                         "','" + HLevel.ToString() + "','" + HEndFlag + "','" + HStopflag + "','" + HRemark + "','" + HUseFlag + "',getdate(),'" + HMakeEmp + "','" + HUSEORGID + "','" + HCREATEORGID + "','" + HClassID + "','" + HUnitID + "')", ref DBUtility.ClsPub.sExeReturnInfo);
                    // Convert.ToString(HEndFlag ? 1 : 0); Convert.ToString(HStopflag ? 1 : 0);HUseFlag
                    //修改上级为非末级代码
                    oCN.RunProc("Update Gy_TechnologyParameter set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
@@ -461,6 +479,9 @@
                        ",HUseFlag='" + HUseFlag + "'" +
                        ",HModifyTime= getdate()" +
                        ",HModifyEmp='" + HMakeEmp + "'" +
                         ",HClassID='" + HClassID + "'" +
                        ",HUnitID='" + HUnitID + "'" +
                        ",HUSEORGID='" + HUSEORGID + "'" +
                        ",HRemark='" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
                    //修改子项目代码
                    //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Warehouse,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);