|  |  | 
 |  |  |         { | 
 |  |  |             try | 
 |  |  |             { | 
 |  |  |                 //查看权限 | 
 |  |  |                 if (!DBUtility.ClsPub.Security_Log("Gy_Group_Query", 1, false, user)) | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  |                     objJsonResult.Message = "无查看权限!"; | 
 |  |  |                     objJsonResult.data = null; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 ////查看权限 | 
 |  |  |                 //if (!DBUtility.ClsPub.Security_Log("Gy_Group_Query", 1, false, user)) | 
 |  |  |                 //{ | 
 |  |  |                 //    objJsonResult.code = "0"; | 
 |  |  |                 //    objJsonResult.count = 0; | 
 |  |  |                 //    objJsonResult.Message = "无查看权限!"; | 
 |  |  |                 //    objJsonResult.data = null; | 
 |  |  |                 //    return objJsonResult; | 
 |  |  |                 //} | 
 |  |  |                 if (sWhere == null || sWhere.Equals("")) | 
 |  |  |                 { | 
 |  |  |                     ds = oCN.RunProcReturn("select * from h_v_GroupList " + sWhere+ " order by 班组代码 ", "h_v_GroupList"); | 
 |  |  | 
 |  |  |                 var HBarCodeForBase = list[0].HBarCodeForBase; | 
 |  |  |                 var HDeptID = list[0].HDeptID; | 
 |  |  |                 long HProcID = list[0].HProcID; | 
 |  |  |                 int HUSEORGID = list[0].HUSEORGID; | 
 |  |  |                 var HDeptNumber = ""; | 
 |  |  |                 //var HEndFlag = 0; | 
 |  |  |                 long HLevel = 1; | 
 |  |  | 
 |  |  |                     oCN.RunProc("Insert into Gy_Group " + | 
 |  |  |                     " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + | 
 |  |  |                     ",HEmpQty,HDeptID,HDeptNumber,HProcID" + | 
 |  |  |                     ",HLevel,HEndFlag,HStopflag,HRemark,HBarCodeForBase) " + | 
 |  |  |                     ",HLevel,HEndFlag,HStopflag,HRemark,HBarCodeForBase,HUSEORGID) " + | 
 |  |  |                     " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + | 
 |  |  |                     "," + HEmpQty.ToString() + "," + HDeptID.ToString() + ",'" + HDeptNumber + "'," + HProcID.ToString() + | 
 |  |  |                     "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "','" + HBarCodeForBase + "')", ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |                     "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "','" + HBarCodeForBase + "',"+ HUSEORGID + ")", ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |                     //修改上级为非末级代码 | 
 |  |  |                     oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); | 
 |  |  |                     oCN.Commit(); |