|  |  | 
 |  |  |         /// </summary> | 
 |  |  |         [Route("Gy_Group/list")] | 
 |  |  |         [HttpGet] | 
 |  |  |         public object list(string sWhere) | 
 |  |  |         public object list(string sWhere,string user) | 
 |  |  |         { | 
 |  |  |             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 (sWhere == null || sWhere.Equals("")) | 
 |  |  |                 { | 
 |  |  |                     ds = oCN.RunProcReturn("select * from h_v_GroupList " + sWhere, "h_v_GroupList"); | 
 |  |  |                     ds = oCN.RunProcReturn("select * from h_v_GroupList " + sWhere+ " order by 班组代码 ", "h_v_GroupList"); | 
 |  |  |                 } | 
 |  |  |                 else | 
 |  |  |                 { | 
 |  |  |                     string sql1 = "select * from h_v_GroupList where 1 = 1 "; | 
 |  |  |                     string sql = sql1 + sWhere; | 
 |  |  |                     string sql = sql1 + sWhere+ " order by 班组代码 "; | 
 |  |  |                     ds = oCN.RunProcReturn(sql, "h_v_GroupList"); | 
 |  |  |                 } | 
 |  |  |                 if (ds == null || ds.Tables[0].Rows.Count == 0) | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  |                     objJsonResult.Message = "false!"; | 
 |  |  |                     objJsonResult.data = null; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |                 else | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "1"; | 
 |  |  |                     objJsonResult.count = 1; | 
 |  |  |                     objJsonResult.Message = "Sucess!"; | 
 |  |  |                     objJsonResult.data = ds.Tables[0]; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 //if (ds.Tables[0].Rows.Count != 0 || ds != null) | 
 |  |  |                 //{ | 
 |  |  |                 objJsonResult.code = "1"; | 
 |  |  |                 objJsonResult.count = 1; | 
 |  |  |                 objJsonResult.Message = "Sucess!"; | 
 |  |  |                 objJsonResult.data = ds.Tables[0]; | 
 |  |  |                 return objJsonResult; | 
 |  |  |                 //} | 
 |  |  |                 //else | 
 |  |  |                 //{ | 
 |  |  |                 //objJsonResult.code = "0"; | 
 |  |  |                 //objJsonResult.count = 0; | 
 |  |  |                 //objJsonResult.Message = "无数据"; | 
 |  |  |                 //objJsonResult.data = null; | 
 |  |  |                 //return objJsonResult; | 
 |  |  |                 //} | 
 |  |  |             } | 
 |  |  |             catch (Exception e) | 
 |  |  |             { | 
 |  |  | 
 |  |  |             { | 
 |  |  |                 var _value = oMain["oMain"].ToString(); | 
 |  |  |                 string msg1 = _value.ToString(); | 
 |  |  |                 string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); | 
 |  |  |                 string msg2 = sArray[0].ToString(); | 
 |  |  |                 string msg3 = sArray[1].ToString(); | 
 |  |  |                 string msg4 = sArray[2].ToString(); | 
 |  |  |                 string msg5 = sArray[3].ToString(); | 
 |  |  |  | 
 |  |  |                 //判断权限 | 
 |  |  |                 if (!ClsPub.Security_Log(msg5, 1, false, msg4)) | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  |                     objJsonResult.Message = "无保存权限"; | 
 |  |  |                     objJsonResult.data = null; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 //反序列化 | 
 |  |  |                 msg1 = "[" + msg1.ToString() + "]"; | 
 |  |  |                 msg2 = "[" + msg2.ToString() + "]"; | 
 |  |  |                 DAL.ClsGy_Group_Ctl oDept = new DAL.ClsGy_Group_Ctl(); | 
 |  |  |                 List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg1); | 
 |  |  |                 List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg2); | 
 |  |  |                 long HItemID = list[0].HItemID; | 
 |  |  |                 string HNumber = list[0].HNumber; | 
 |  |  |                 string HName = list[0].HName; | 
 |  |  | 
 |  |  |                 string msg1 = _value.ToString(); | 
 |  |  |                 string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); | 
 |  |  |                 string msg2 = sArray[0].ToString(); | 
 |  |  |                 //string msg3 = sArray[1].ToString(); | 
 |  |  |                 string user = sArray[1].ToString();//用户名 | 
 |  |  |                 //string msg4 = sArray[2].ToString(); | 
 |  |  |                 //string msg5 = sArray[3].ToString(); | 
 |  |  |  | 
 |  |  |                 //判断是否有编辑权限 | 
 |  |  |                 if (!DBUtility.ClsPub.Security_Log("Gy_Group_Edit", 1, false, user)) | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  |                     objJsonResult.Message = "无编辑权限!"; | 
 |  |  |                     objJsonResult.data = null; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 //反序列化 | 
 |  |  |                 msg2 = "[" + msg2.ToString() + "]"; | 
 |  |  |                 List<Gy_Group> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Group>>(msg2); | 
 |  |  | 
 |  |  |                 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; | 
 |  |  |                 //var HProcID = ""; | 
 |  |  |  | 
 |  |  |                 ////判断权限 | 
 |  |  |                 //if (!ClsPub.Security_Log(msg5, 1, true, msg4)) | 
 |  |  |                 //判断权限 | 
 |  |  |                 //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) | 
 |  |  |                 //{ | 
 |  |  |                 //    objJsonResult.code = "0"; | 
 |  |  |                 //    objJsonResult.count = 0; | 
 |  |  |                 //    objJsonResult.Message = "没有找到该功能模块!"; | 
 |  |  |                 //    objJsonResult.Message = "无保存权限"; | 
 |  |  |                 //    objJsonResult.data = null; | 
 |  |  |                 //    return objJsonResult; | 
 |  |  |                 //} | 
 |  |  | 
 |  |  |                     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(); | 
 |  |  | 
 |  |  |         //        var HProcID = list[0].HProcID; | 
 |  |  |  | 
 |  |  |         //        //判断权限 | 
 |  |  |         //        //if (!ClsPub.Security_Log(msg5, 1, true, msg4)) | 
 |  |  |         //        //if (!ClsPub.Security_Log(msg5, 1, false, msg4)) | 
 |  |  |         //        //{ | 
 |  |  |         //        //    objJsonResult.code = "0"; | 
 |  |  |         //        //    objJsonResult.count = 0; | 
 |  |  | 
 |  |  |         /// 班组删除功能 | 
 |  |  |         /// </summary> | 
 |  |  |         /// <returns></returns> | 
 |  |  |         [Route("DeltetGy_Group")] | 
 |  |  |         [Route("Gy_Group/DeltetGy_Group")] | 
 |  |  |         [HttpGet] | 
 |  |  |         public object DeltetGy_Group(string HItemID) | 
 |  |  |         public object DeltetGy_Group(string HItemID,string user) | 
 |  |  |         { | 
 |  |  |             DataSet ds; | 
 |  |  |             DataSet ds1; | 
 |  |  |             //string ModRightNameCheck = "Sc_ProcessReport_check"; | 
 |  |  |             string ModRightNameCheck = "Gy_Group_Delete"; | 
 |  |  |             try | 
 |  |  |             { | 
 |  |  |                 //删除权限 | 
 |  |  |                 //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) | 
 |  |  |                 //{ | 
 |  |  |                 //    objJsonResult.code = "0"; | 
 |  |  |                 //    objJsonResult.count = 0; | 
 |  |  |                 //    objJsonResult.Message = "审核失败!无权限!"; | 
 |  |  |                 //    objJsonResult.data = null; | 
 |  |  |                 //    return objJsonResult; | 
 |  |  |                 //} | 
 |  |  |                 if (!DBUtility.ClsPub.Security_Log("Gy_Group_Delete", 1, false, user)) | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; | 
 |  |  |                     objJsonResult.Message = "无删除权限!"; | 
 |  |  |                     objJsonResult.data = null; | 
 |  |  |                     return objJsonResult; | 
 |  |  |                 } | 
 |  |  |  | 
 |  |  |                 SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); | 
 |  |  |                 if (string.IsNullOrWhiteSpace(HItemID)) | 
 |  |  | 
 |  |  |             DAL.ClsGy_Group_View oDeptHlp = new DAL.ClsGy_Group_View(); | 
 |  |  |             try | 
 |  |  |             { | 
 |  |  |                 if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true, User)) | 
 |  |  |                 if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, User)) | 
 |  |  |                 { | 
 |  |  |                     objJsonResult.code = "0"; | 
 |  |  |                     objJsonResult.count = 0; |