1、工序委外接收单新增修改、审核、反审核功能。 2、修复工序流转卡保存未保存委外标记问题。

仲国强

2021-09-16 a7941316a0d4945eb2d35fa86ab983c0ec8e6534

 WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs

@@ -103,12 +103,12 @@
                //若MAINDI重复则重新获取
                oCN.BeginTran();
                //主表
                string sql = "Insert into  Xt_ORGANIZATIONS " +
                  " (HNumber,HName,HParentID" +
                   ",HStopflag" +
                string sql = "Insert into Xt_ORGANIZATIONS " +
                    " (HNumber,HName,HParentID" +
                   ",HStopflag,HMakeTime" +
                   ",HRemark) " +
                   " Values('" + HNumber + "','" + HName + "'," + HParentID.ToString() +
                   "," + HStopflag +
                   "," + HStopflag + "getdate()" +
                   ",'" + HRemark + "')";
                oCN.RunProc(sql, ref DBUtility.ClsPub.sExeReturnInfo);
                //修改上级为非末级代码
@@ -161,7 +161,7 @@
                long HItemID = list[0].HItemID;
                string HNumber = list[0].HNumber;
                string HName = list[0].HName;

                DateTime HMakeTime = list[0].HMakeTime;
                long HParentID = list[0].HParentID;

                string HRemark = list[0].HRemark;
@@ -201,14 +201,14 @@
                    oCN.BeginTran();
                    oCN.RunProc("Insert into Xt_ORGANIZATIONS " +
                    " (HNumber,HName,HParentID" +
                   ",HStopflag" +
                   ",HStopflag,HMakeTime" +
                   ",HRemark) " +
                   " Values('" + HNumber + "','" + HName + "'," + HParentID.ToString() +
                   "," + HStopflag +
                   "," + HStopflag + "getdate()"+
                   ",'" + HRemark + "')", ref DBUtility.ClsPub.sExeReturnInfo);

                    //修改上级为非末级代码
                    oCN.RunProc("Update Xt_ORGANIZATIONS set HStopflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                    //oCN.RunProc("Update Xt_ORGANIZATIONS set HStopflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                    oCN.Commit();
                }
                else
@@ -219,6 +219,7 @@
                               " HNumber='" + HNumber + "'" +
                                 ",HName='" + HName + "'" +
                                  ",HParentID=" + HParentID +
                                  ",HMakeTime=" + HMakeTime +
                                 ",HStopflag='" + HStopflag + "'" +
                                 ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
                    oCN.RunProc("Update Xt_ORGANIZATIONS set HStopflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);