1

duhe

2024-01-05 78691dba2745537162440a3c3a13a137e97491f8

 WebAPI/Controllers/BaseSet/Gy_CustomerController.cs

@@ -302,7 +302,7 @@
                    ",HSubsidyAccrualRating,HCreditRating,HMaxCreditRating" +
                    ",HCusTypeID,HCREATEORGID,HUSEORGID) " +
                    " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID +
                    ", " + HLevel + ",0,'" + HStopflag + "','" + HRemark + "'" +
                    ", " + HLevel + ",1,'" + HStopflag + "','" + HRemark + "'" +
                    ",'" + HShortName + "','" + HAddress + "','" + HLinkMan + "','" + HLinkPhone + "','" + HMobilePhone + "'" +
                    ",'" + HFax + "','" + HPostalCode + "','" + HEmail + "','" + HBank + "','" + HBankAccount + "'" +
                    ",'" + HTaxNum + "'," + HTaxRate + ",'" + HCountry + "','" + HCorMan + "','" + HEnglishName + "'" +
@@ -313,6 +313,22 @@
                    ", " + HCusTypeID + ","+ HCreateOrgID + ","+ HUseOrgID + ")");
                //修改上级为非末级代码
                oCN.RunProc("Update Gy_Customer set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);

                //保存后控制
                string sql = "select * from Gy_Customer where HNumber = '" + HNumber + "' and HName = '" + HName + "' and HUSEORGID = " + HUseOrgID;
                ds = oCN.RunProcReturn(sql, "Gy_Customer");
                HItemID = Int64.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString());
                ds = oCN.RunProcReturn("exec h_p_Gy_Customer_AfterSaveCtrl " + HItemID, "h_p_Gy_Customer_AfterSaveCtrl");
                if (ds.Tables[0].Rows[0]["HBack"].ToString() == "1")
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "Exception！" + ds.Tables[0].Rows[0]["HBackRemark"].ToString();
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
@@ -573,6 +589,21 @@
                //将上级 为非末级
                oCN.RunProc("Update Gy_Customer set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                //

                //保存后控制
                ds = oCN.RunProcReturn("exec h_p_Gy_Customer_AfterSaveCtrl " + HItemID, "h_p_Gy_Customer_AfterSaveCtrl");
                if (ds.Tables[0].Rows[0]["HBack"].ToString() == "1")
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "Exception！" + ds.Tables[0].Rows[0]["HBackRemark"].ToString();
                    objJsonResult.data = null;
                    return objJsonResult;
                }



                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;