1

沈泽

2021-10-27 e35cf4e3900cf10deade1ef0e4c363876e650552

 WebAPI/Controllers/BaseSet/Gy_ClassTimePrjController.cs

@@ -132,7 +132,7 @@
                long HItemID = list[0].HItemID;
                string HNumber = list[0].HNumber;
                string HName = list[0].HName;
                long HParentID = list[0].HParentID; ;
                long hparentid = list[0].hparentid; ;
                long HDeptID = list[0].HDeptID; ;
                long HGroupID = list[0].HGroupID;
                bool HStopflag = list[0].HStopflag;
@@ -153,11 +153,11 @@
                oCN.RunProc("Insert into Gy_ClassTimePrj" +
                    " (HNumber,HName,HParentID" +
                    ",HStopflag,HRemark,HDeptID,HGroupID) " +
                    " Values('" + HNumber + "','" + HName + "'," + HParentID.ToString() +
                    " Values('" + HNumber + "','" + HName + "'," + hparentid.ToString() +
                    "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HDeptID.ToString() + "," + HGroupID.ToString() + ")"
                    , ref DBUtility.ClsPub.sExeReturnInfo);
                //修改上级为非末级代码
                oCN.RunProc("Update Gy_ClassTimePrj set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                oCN.RunProc("Update Gy_ClassTimePrj set HEndflag=0 where HItemID=" + hparentid, ref DBUtility.ClsPub.sExeReturnInfo);
                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
@@ -205,7 +205,7 @@
                long HItemID = list[0].HItemID;
                string HNumber = list[0].HNumber;
                string HName = list[0].HName;
                long HParentID = list[0].HParentID; ;
                long hparentid = list[0].hparentid; ;
                long HDeptID = list[0].HDeptID; ;
                long HGroupID = list[0].HGroupID;
                bool HStopflag = list[0].HStopflag;
@@ -246,11 +246,11 @@
                    oCN.RunProc("Insert into Gy_ClassTimePrj" +
                    " (HNumber,HName,HParentID" +
                    ",HStopflag,HRemark,HDeptID,HGroupID) " +
                    " Values('" + HNumber + "','" + HName + "'," + HParentID.ToString() +
                    " Values('" + HNumber + "','" + HName + "'," + hparentid.ToString() +
                    "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HDeptID.ToString() + "," + HGroupID.ToString() + ")"
                    , ref DBUtility.ClsPub.sExeReturnInfo);
                    //修改上级为非末级代码
                    oCN.RunProc("Update Gy_ClassTimePrj set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                    oCN.RunProc("Update Gy_ClassTimePrj set HEndflag=0 where HItemID=" + hparentid, ref DBUtility.ClsPub.sExeReturnInfo);
                    oCN.Commit();
                }
                else { 
@@ -260,7 +260,7 @@
                    oCN.RunProc("Update Gy_Warehouse set " +
                        " HNumber='" + HNumber + "'" +
                        ",HName='" + HName + "'" +
                        ",HParentID=" + HParentID.ToString() +
                        ",HParentID=" + hparentid.ToString() +
                        ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) +
                        ",HDeptID=" + HDeptID.ToString() +
                        ",HGroupID=" + HGroupID.ToString() +
@@ -268,7 +268,7 @@
                    //修改子项目代码
                    //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Warehouse,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo);
                    //将上级 为非末级
                    oCN.RunProc("Update Gy_ClassTimePrj set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                    oCN.RunProc("Update Gy_ClassTimePrj set HEndflag=0 where HItemID=" + hparentid, ref DBUtility.ClsPub.sExeReturnInfo);
                    //
                    oCN.Commit();
                }