| | |
| | | } |
| | | } |
| | | |
| | | #region 获取职员列表 (添加车间筛选) |
| | | [Route("Web/GetEmployeeList_Json")] |
| | | [HttpGet] |
| | | public object GetEmployeeList_Json3(string Employee, Int64 HGroupID, Int64 HDeptID = -1) |
| | | { |
| | | // 给部门(车间)ID设置默认值,当没有传入值或者值为0的时候,走旧有的函数,否则走新的逻辑 |
| | | if(HDeptID == -1 || HDeptID == 0) |
| | | { |
| | | return GetEmployeeList_Json2(Employee, HGroupID); |
| | | }else |
| | | { |
| | | sWhere = $" Where HStopFlag=0 and HEndFlag=1 and HDeptID=${HDeptID}"; |
| | | |
| | | if(Employee != "") |
| | | { |
| | | sWhere += " and ( HNumber like '%" + Employee + "%' or HName like '%" + Employee + "%' )"; |
| | | } |
| | | if(HGroupID != 0) |
| | | { |
| | | sWhere += " and HGroupID=" + HGroupID.ToString(); |
| | | } |
| | | |
| | | try |
| | | { |
| | | string sql = $"Select * from h_v_IF_Emp {sWhere} Order by HNumber"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_Emp"); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + DBUtility.ClsPub.sErrInfo; |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | else |
| | | { |
| | | objjson.code = "0"; |
| | | objjson.count = 1; |
| | | objjson.Message = "获取成功!"; |
| | | objjson.data = ds.Tables[0]; |
| | | return objjson; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | |
| | | objjson.code = "0"; |
| | | objjson.count = 0; |
| | | objjson.Message = "获取失败" + ex.ToString(); |
| | | objjson.data = null; |
| | | return objjson; |
| | | } |
| | | |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | /// <summary> |
| | | /// 获取职员列表 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("Web/GetEmployeeList_Json")] |
| | | [HttpGet] |
| | | // [Route("Web/GetEmployeeList_Json")] |
| | | // [HttpGet] |
| | | public object GetEmployeeList_Json2(string Employee, Int64 HGroupID) |
| | | { |
| | | sWhere = " Where HStopFlag=0 and HEndFlag=1"; |
| | |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region APP 根据模块获取该模块下需要显示消息标识的子模块 |
| | | [Route("Web/getMessageIdentified")] |
| | | [HttpGet] |
| | | public object getMessageIdentified(string user, string moduleName) |
| | | { |
| | | return null; |
| | | } |
| | | #endregion |
| | | } |
| | | } |