新增缓存列表编辑功能调用方法

yxj

2023-06-27 d84c1704ee8cbabe8e3d8cfd7f29ca81a9b9f1e5

 DAL/基础资料/公用基础资料/ClsGy_Unit_Ctl.cs

@@ -18,14 +18,14 @@
            try
            {
                oCn.BeginTran();
                oCn.RunProc("Insert into " + MvarItemKey + " " +
                oCn.RunProc("Insert into Gy_Unit" +
                    " (HNumber,HName,HHelpCode,HShortNumber,HParentID" +
                    ",HLevel,HEndFlag,HStopflag,HRemark,HRate,HStandard) " +
                    ",HLevel,HEndFlag,HStopflag,HRemark,HRate,HStandard,HUSEORGID) " +
                    " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() +
                    "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark +
                    "'," + oModel.HRate.ToString() + "," + DBUtility.ClsPub.BoolToString(oModel.HStandard) + ")", ref DBUtility.ClsPub.sExeReturnInfo);
                    "'," + oModel.HRate.ToString() + "," + DBUtility.ClsPub.BoolToString(oModel.HStandard) + "," + oModel.HUSEORGID + ")", ref DBUtility.ClsPub.sExeReturnInfo);
                //淇敼涓婄骇涓洪潪鏈骇浠ｇ爜
                oCn.RunProc("Update " + MvarItemKey + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.RunProc("Update Gy_Unit" + " set HEndflag=0 where HItemID=" + oModel.HParentID, ref DBUtility.ClsPub.sExeReturnInfo);
                oCn.Commit();
                return true;
            }