设备点检计划单、编辑点检计划+设备点检记录单、编辑点检记录

zzr99

2021-09-10 7c62758d881d383f55dbceb463bf87117438343c

 WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs

@@ -105,10 +105,10 @@
                //主表
                string sql = "Insert into  Xt_ORGANIZATIONS " +
                  " (HNumber,HName,HParentID" +
                   ",HStopflag" +
                   ",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);