public IList <SysMenuOptRightModel> GetRightByMenuIdAndRoleId(string moduleId, string roleId) { DataTable dt = _rightRep.GetRightByMenuIdAndRoleId(moduleId, roleId); IList <SysMenuOptRightModel> list = ConverHelper.ToList <SysMenuOptRightModel>(dt); return(list); }
/// <summary> /// 获取用户权限 /// </summary> /// <param name="userId"></param> /// <param name="url"></param> /// <returns></returns> public IList <permModel> GetPermission(string userId, string url) { DataTable dt = _rightRep.GetPermission(userId, url); IList <permModel> list = ConverHelper.ToList <permModel>(dt); return(list); }
public IList <SysExceptionModel> GetList(GridPager pager, string userName, string sDate, string eDate) { DataTable dt = _exceptionRep.GetList(pager, userName, sDate, eDate); IList <SysExceptionModel> list = ConverHelper.ToList <SysExceptionModel>(dt); return(list); }
public IList <SysRoleModel> GetList(GridPager pager, string roleName, string desc) { DataTable dt = _roleRep.GetList(pager, roleName, desc); IList <SysRoleModel> list = ConverHelper.ToList <SysRoleModel>(dt); return(list); }
/// <summary> /// 数据类型转换PLC-->WCS /// </summary> /// <param name="type"></param> /// <param name="data"></param> /// <returns></returns> private BllResult <String> TransforAddressDataToWCSData(PLCDataType type, object data) { string str; try { switch (type) { case PLCDataType.BYTE: int i = Convert.ToInt32(data); str = i.ToString(); break; case PLCDataType.BOOL: case PLCDataType.DWORD: case PLCDataType.WORD: case PLCDataType.INT: case PLCDataType.DINT: str = data.ToString(); break; case PLCDataType.CHAR: str = ConverHelper.ASCIIToString((short[])data).Trim().Replace("$03", "").Replace("\u0003", "").Replace("\0", ""); break; default: str = data.ToString(); break; } return(BllResultFactory <string> .Sucess(str, "成功")); } catch (Exception ex) { return(BllResultFactory <string> .Error(null, "PLC到WCS数据转换出现异常,值:" + data + " 目标类型:" + type + " 异常:" + ex.ToString())); } }
/// <summary> /// 获取部门列表 /// </summary> /// <param name="parent_code"></param> /// <returns></returns> public IList <SysDeptModel> GetList(string parent_code) { DataTable dt = _deptRep.GetList(parent_code); IList <SysDeptModel> list = ConverHelper.ToList <SysDeptModel>(dt); return(list); }
public IList <SysUserModel> GetByDeptCode(GridPager pager, string dept_code) { DataTable dt = _userRep.GetByDeptCode(pager, dept_code); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); return(list); }
/// <summary> /// 获取移动端用户菜单列表 WebApi用 /// </summary> /// <returns></returns> public JsonMessage GetMobileMenuList(string user_id) { JsonMessage jsonMsg = new JsonMessage(); int result = 1; List <MenuTreeModel> toSource = new List <MenuTreeModel>(); try { DataTable dt = _homeRep.GetMobileMenuByUserId(user_id); //获取当前用户所有权限 List <MenuTreeModel> list_fo = ConverHelper.ToList <MenuTreeModel>(dt).ToList(); //转换成List形式 toSource = new List <MenuTreeModel>(); var list = list_fo.FindAll(p => p.parent_id == "1"); //获取根节点数据 if (list.Count > 0) { foreach (var item in list) { GetMenuTreeJson(item, item.id, list_fo); //调用递归 toSource.Add(item); //添加到集合中 } } jsonMsg = ServiceResult.Message(1, "菜单获取成功", toSource); } catch (Exception ex) { jsonMsg = ServiceResult.Message(0, "系统异常,菜单列表加载失败", toSource); WriteSystemException(ex, this.GetType(), OPT_MODEL, "左侧菜单列表加载失败,请刷新尝试"); } return(jsonMsg); }
public IList <SysMenuModel> GetMenuByUserId(string userId, string parentId) { DataTable dt = _homeRep.GetMenuByUserId(userId, parentId); IList <SysMenuModel> list = ConverHelper.ToList <SysMenuModel>(dt); return(list); }
public SysRoleModel GetById(string roleId) { DataTable dt = _roleRep.GetById(roleId); IList <SysRoleModel> list = ConverHelper.ToList <SysRoleModel>(dt); return(list[0]); }
public IList <SysRoleModel> GetRoleYesUser(string userId) { DataTable dt = _roleRep.GetRoleYesUser(userId); IList <SysRoleModel> list = ConverHelper.ToList <SysRoleModel>(dt); return(list); }
/// <summary> /// 获取用户列表 /// </summary> /// <param name="pager"></param> /// <param name="userId"></param> /// <param name="userName"></param> /// <param name="roleId"></param> /// <returns></returns> public IList <SysUserModel> GetList(GridPager pager, string userId, string userName, string roleId) { DataTable dt = _userRep.GetList(pager, userId, userName, roleId); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); return(list); }
public IList <SysUserModel> GetUserYesRole(GridPager pager, string roleId, string user) { DataTable dt = _userRep.GetUserYesRole(pager, roleId, user); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); return(list); }
/// <summary> /// 获取操作码列表 /// </summary> /// <param name="menuId"></param> /// <returns></returns> public IList <SysMenuOptModel> GetOpListByMenuId(string menuId) { DataTable dt = _menuOpApp.GetOptListByMenuId(menuId); IList <SysMenuOptModel> list = ConverHelper.ToList <SysMenuOptModel>(dt); return(list); }
/// <summary> /// 获取当前用户信息 /// </summary> /// <returns></returns> public JsonMessage GetUser() { JsonMessage jsonMsg = new JsonMessage(); try { DataTable dt = _userRep.GetById(UserID); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); if (list.Count > 0) { jsonMsg = ServiceResult.Message(1, "获取成功", list[0]); } else { jsonMsg = ServiceResult.Message(0, "获取失败,用户不存在,请确认", list[0]); } } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); } return(jsonMsg); }
/// <summary> /// 根据角色获取菜单列表 /// </summary> /// <param name="roleId"></param> /// <param name="parentId"></param> /// <returns></returns> public IList <SysMenuModel> GetListByRoleId(string roleId, string parentId) { DataTable dt = _menuRep.GetListByRoleId(roleId, parentId); IList <SysMenuModel> list = ConverHelper.ToList <SysMenuModel>(dt); return(list); }
/// <summary> /// 获取菜单列表 /// </summary> /// <param name="parentId"></param> /// <returns></returns> public IList <SysMenuModel> GetParentList(string parentId) { DataTable dt = _menuRep.GetParentList(parentId); IList <SysMenuModel> list = ConverHelper.ToList <SysMenuModel>(dt); return(list); }
/// <summary> /// 列印用户二维码标签 /// </summary> /// <param name="user_code">用户账号</param> /// <param name="is_qr">是否QR(true 是二维码,false是一维码)</param> /// <returns></returns> public JsonMessage PrinterUserQR(string user_code, bool is_qr) { string tmpUser = user_code.Replace(",", "','"); DataTable dt = _userRep.GetUserByIds(tmpUser); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); string nowDate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); string img = "<img style='width: 342px;' src='/route/common/BarQRImg/GetBarCodeImg?text="; string tbl = ""; tbl = "<table style='width:18cm' border='1' cellspacing='10'><tr height='120px'>"; if (is_qr == true) { img = "<img style='width: 100px;' src='/route/common/BarQRImg/GetQrCodeImg?size=3&text="; } for (int i = 0; i < list.Count; i++) { if (i % 3 == 0 && i != 0) { if (is_qr == true) { if (i % 18 == 0) { tbl += "</tr><tr height='140px' style='page-break-before:always;' >"; } else { tbl += "</tr><tr height='140px' >"; } } else { if (i % 30 == 0) { tbl += "</tr><tr height='140px' style='page-break-before:always;' >"; } else { tbl += "</tr><tr height='140px' >"; } } } tbl += "<td style='text-align: center; width: 5.5cm; font-size: 16px;'>" + list[i].USER_CODE + "<br/>" + list[i].USER_NAME + "<br/>"; tbl += img + list[i].QR_CODE + "' /> " + "<br/>" + nowDate + "</td>"; if (i == list.Count - 1 && i % 3 != 0) { tbl += "</tr>"; } } tbl += "</table>"; JsonMessage jsonMsg = ServiceResult.Message(1, "", tbl); return(jsonMsg); }
public SysLogModel GetById(string id) { DataTable dt = _logRep.GetById(id); IList <SysLogModel> list = ConverHelper.ToList <SysLogModel>(dt); if (list.Count > 0) { return(list[0]); } return(null); }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="userId">用户ID</param> /// <returns></returns> public SysUserModel GetById(string userId) { DataTable dt = _userRep.GetById(userId); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); if (list.Count > 0) { return(list[0]); } return(null); }
/// <summary> /// 获取菜单明细 /// </summary> /// <param name="menuId"></param> /// <returns></returns> public SysMenuModel GetById(string menuId) { DataTable dt = _menuRep.GetById(menuId); IList <SysMenuModel> list = ConverHelper.ToList <SysMenuModel>(dt); if (list.Count > 0) { return(list[0]); } return(null); }
/// <summary> /// 获取用户信息(or) /// </summary> /// <param name="user_code">工号</param> /// <param name="user_name">姓名</param> /// <returns></returns> public SysUserModel GetUserByIdOrName(string user_code, string user_name) { DataTable dt = _userRep.GetUserByIdOrName(user_code, user_name); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); if (list.Count > 0) { return(list[0]); } return(new SysUserModel()); }
/// <summary> /// 获取app最新版本号 /// </summary> /// <returns></returns> public AppVersionModel GetNewAppVersion() { DataTable dt = _appRep.GetNewAppVersion(); if (ValidateHelper.IsDataTableNotData(dt)) { return(new AppVersionModel()); } IList <AppVersionModel> list = ConverHelper.ToList <AppVersionModel>(dt); return(list[0]); }
public IList <SysLogModel> GetList(GridPager pager, string msg, string res, string type, string module, string userName, string sDate, string eDate) { SysLogModel model = new SysLogModel(); model.LOG_MSG = msg; model.LOG_RESULT = res; model.LOG_TYPE = type; model.LOG_MODULE = module; DataTable dt = _logRep.GetList(pager, model, userName, sDate, eDate); IList <SysLogModel> list = ConverHelper.ToList <SysLogModel>(dt); return(list); }
public IList <SysRoleModel> GetListDistinctName() { DataTable dt = _roleRep.GetListDistinctName(); IList <SysRoleModel> list = ConverHelper.ToList <SysRoleModel>(dt); if (list.Count > 0) { SysRoleModel model = new SysRoleModel(); model.ROLE_ID = ""; model.ROLE_NAME = "--ALL--"; list.Insert(0, model); } return(list); }
public IList <SysLogModel> GetLogType(string field) { DataTable dt = _logRep.GetLogType(field); IList <SysLogModel> list = ConverHelper.ToList <SysLogModel>(dt); if (list.Count > 0) { SysLogModel model = new SysLogModel(); model.LOG_ID = ""; model.LOG_TYPE = "--ALL--"; list.Insert(0, model); } return(list); }
public override void ExecuteResult(ControllerContext context) { if (context == null) { throw new ArgumentNullException("context"); } if (JsonRequestBehavior == JsonRequestBehavior.DenyGet && String.Equals(context.HttpContext.Request.HttpMethod, "GET", StringComparison.OrdinalIgnoreCase)) { throw new InvalidOperationException(error); } HttpResponseBase response = context.HttpContext.Response; if (!ValidateHelper.IsNullOrEmpty(ContentType)) { response.ContentType = ContentType; } else { response.ContentType = "application/json"; } if (ContentEncoding != null) { response.ContentEncoding = ContentEncoding; } if (Data != null) { string jsonstring = ConverHelper.ToJson(Data); //JavaScriptSerializer serializer = new JavaScriptSerializer(); //string jsonstring = serializer.Serialize(Data); ////string p = @"\\/Date\((\d+)\+\d+\)\\/"; //string p = @"\\/Date\(\d+\)\\/"; //MatchEvaluator matchEvaluator = new MatchEvaluator(ConvertJsonDateToDateString); //Regex reg = new Regex(p); //jsonstring = reg.Replace(jsonstring, matchEvaluator); response.Write(jsonstring); } }
/// <summary> /// 数据类型转换WCS-->PLC /// </summary> /// <param name="type"></param> /// <param name="v"></param> /// <returns></returns> private BllResult TansforWCSDataToAddressData(PLCDataType type, string data) { try { object obj = null; switch (type) { case PLCDataType.BYTE: obj = Convert.ToInt32(data); break; case PLCDataType.BOOL: obj = Convert.ToBoolean(data); break; case PLCDataType.DWORD: obj = Convert.ToUInt32(data); break; case PLCDataType.WORD: obj = Convert.ToUInt16(data); break; case PLCDataType.INT: obj = Convert.ToInt16(data); break; case PLCDataType.DINT: obj = Convert.ToInt32(data); break; case PLCDataType.CHAR: obj = ConverHelper.StringToASCII(data); break; default: obj = data; break; } return(BllResultFactory.Sucess(obj, "成功")); } catch (Exception ex) { return(BllResultFactory.Error(null, "WCS到PLC数据转换出现异常,值:" + data + " 目标类型:" + type + " 异常:" + ex.ToString())); } }
/// <summary> /// 数据转换,byte[]到string /// </summary> /// <param name="dataType"></param> /// <param name="buffer"></param> /// <returns></returns> public static BllResult <string> TransferBufferToString(HslSiemensDataEntity data) { try { switch (data.DataType) { case PLCDataType.BYTE: //字节转成int处理 return(BllResultFactory <string> .Sucess(reverseBytesTransform.TransByte(data.Buffer, 0).ToString(), null)); case PLCDataType.BOOL: //对于bool类型,我们需要判断此字节中的指定位是否为0 return(BllResultFactory <string> .Sucess(ConverHelper.GetBit(data.Buffer[0], data.BitOffset) == 1?true.ToString() : false.ToString(), null)); case PLCDataType.DWORD: return(BllResultFactory <string> .Sucess(reverseBytesTransform.TransUInt32(data.Buffer, 0).ToString(), null)); case PLCDataType.WORD: return(BllResultFactory <string> .Sucess(reverseBytesTransform.TransUInt16(data.Buffer, 0).ToString(), null)); case PLCDataType.INT: return(BllResultFactory <string> .Sucess(reverseBytesTransform.TransInt16(data.Buffer, 0).ToString(), null)); case PLCDataType.DINT: return(BllResultFactory <string> .Sucess(reverseBytesTransform.TransInt32(data.Buffer, 0).ToString(), null)); case PLCDataType.CHAR: return(BllResultFactory <string> .Sucess(reverseBytesTransform.TransString(data.Buffer, 0, data.Buffer.Length, Encoding.ASCII).Replace("\u0003", "").Trim(), null)); default: return(BllResultFactory <string> .Error("未识别")); } } catch (Exception ex) { return(BllResultFactory <string> .Error($"转换出错:{ex.Message}")); } }
/// <summary> /// 获取菜单列表 /// </summary> /// <returns></returns> public JsonMessage GetMenuList() { JsonMessage jsonMsg = new JsonMessage(); int result = 1; List <MenuTreeModel> toSource = new List <MenuTreeModel>(); //List<MenuTreeModel> toSource = (List<MenuTreeModel>)CacheHelper.GetCache("MenuTreeJson");//获取缓存中的数据 //if (toSource == null) //{ try { DataTable dt = _homeRep.GetMenuByPersonId(UserID); //获取当前用户所有权限 List <MenuTreeModel> list_fo = ConverHelper.ToList <MenuTreeModel>(dt).ToList(); //转换成List形式 toSource = new List <MenuTreeModel>(); var list = list_fo.FindAll(p => p.parent_id == "0"); //获取根节点数据 if (list.Count > 0) { foreach (var item in list) { GetMenuTreeJson(item, item.id, list_fo); //调用递归 toSource.Add(item); //添加到集合中 } } jsonMsg = ServiceResult.Message(1, "菜单获取成功", toSource); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, "系统异常,菜单列表加载失败", toSource); WriteSystemException(ex, this.GetType(), OPT_MODEL, "左侧菜单列表加载失败,请刷新尝试"); } return(jsonMsg); }