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);
}
