| | |
| | | long HItemID = list[0].HItemID; |
| | | string HNumber = list[0].HNumber; |
| | | string HName = list[0].HName; |
| | | string HShortNumber = list[0].HShortNumber; |
| | | string HDeptNumber = list[0].HDeptNumber; |
| | | long HParentID = list[0].HParentID; |
| | | string HHelpCode = list[0].HHelpCode; |
| | | string HRemark = list[0].HRemark; |
| | | bool HStopflag = list[0].HStopflag; |
| | | bool HEndFlag = list[0].HStopflag; |
| | | string HUseFlag = list[0].HUseFlag; |
| | | var HQty = list[0].HQty; |
| | | var HBarCodeForBase = list[0].HBarCodeForBase; |
| | | var HDayMoney = list[0].HDayMoney; |
| | | var HDeptID = list[0].HDeptID; |
| | | var HProcID = list[0].HProcID; |
| | | var HLevel = list[0].HLevel; |
| | | var HWorkTimes = list[0].HWorkTimes; |
| | | int HUSEORGID = list[0].HUSEORGID; |
| | | string HMaker = msg2; |
| | | |
| | | //判断权限 |
| | | if (!ClsPub.Security_Log("Gy_WorkCenter_Edit", 1, false, msg2)) |
| | | //末级标志 |
| | | bool HEndFlag = true; |
| | | //得到短代码 |
| | | string HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber); |
| | | if (HShortNumber.Trim() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没有找到该功能模块!"; |
| | | objJsonResult.data = null; |
| | | objJsonResult.Message = "保存失败!短代码为空!"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | //等级 |
| | | int HLevel = DBUtility.ClsPub.GetLevel(HNumber); |
| | | |
| | | //检查父级是否存在 |
| | | long HParentID = 0; |
| | | string sParent = DBUtility.ClsPub.GetParentCode(HNumber); |
| | | if (sParent.Trim() == "") |
| | | { |
| | | HParentID = 0; |
| | | } |
| | | else |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Gy_WorkCenter where HNumber='" + sParent + "' and HStopFlag=0 ", "Gy_WorkCenter"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | HParentID = long.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString()); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "保存失败!上级代码不存在或被禁用!"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | //if (!DBUtility.ClsPub.AllowNumber(HNumber)) |
| | | //{ |
| | |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HDeptNumber,HWorkTimes,HQty" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase" + |
| | | ",HProcID,HDayMoney,HUSEORGID) " + |
| | | ",HProcID,HDayMoney,HUSEORGID,HMaker,HMakeTime) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + |
| | | ",'" + HDeptNumber + "'," + HWorkTimes + "," + HQty + |
| | | "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + |
| | | ",'" + HRemark + "'," + HDeptID + ",'" + HBarCodeForBase + "'," + HProcID + "," + HDayMoney + ","+ HUSEORGID + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | ",'" + HRemark + "'," + HDeptID + ",'" + HBarCodeForBase + "'," + HProcID + "," + HDayMoney + ","+ HUSEORGID + "" + |
| | | ",'"+ HMaker + "',getdate())", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //修改上级为非末级代码 |
| | | oCN.RunProc("Update Gy_WorkCenter set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | |
| | | ",HParentID=" + HParentID + |
| | | ",HStopflag='" + HStopflag + "'" + |
| | | ",HRemark= '" + HRemark + "'" + |
| | | ",HUpDater= '" + HMaker + "'" + |
| | | ",HUpDateDate= getdate()" + |
| | | ",HDeptID=" + HDeptID + |
| | | ",HLevel=" + HLevel + |
| | | ",HQty=" + HQty + |
| | | ",HWorkTimes=" + HWorkTimes + |
| | | ",HBarCodeForBase='" + HBarCodeForBase + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |