using MES.Service.DB;
|
using MES.Service.Dto.service;
|
using MES.Service.Dto.webApi;
|
using MES.Service.Modes;
|
using MES.Service.util;
|
using Microsoft.Data.SqlClient;
|
using SqlSugar;
|
using System.Data;
|
using System.Dynamic;
|
|
namespace MES.Service.service
|
{
|
public class SysUserService : Repository<SysUser>
|
{
|
|
public List<UserPermission> QueryPurview(string userNo)
|
{
|
// 获取用户权限列表
|
List<string> purviewData = this.DoPurview(userNo);
|
List<UserPermission> resultList = new List<UserPermission>();
|
|
if (purviewData.Count > 0)
|
{
|
string purviewString = purviewData[0];
|
string[] splitResult = purviewString.Split(new string[] { "[" }, StringSplitOptions.None);
|
|
if (splitResult.Length > 2)
|
{
|
for (int i = 2; i < splitResult.Length; i++)
|
{
|
string trimmedStr = splitResult[i].Trim(); // 去掉空格
|
string[] itemArray = trimmedStr.Split(new char[] { '#' });
|
|
UserPermission permission = new UserPermission
|
{
|
Name = itemArray[0],
|
Category = "全部应用",
|
IconType = itemArray[1],
|
Path = "input" ,
|
Color = itemArray[2]
|
};
|
|
resultList.Add(permission);
|
}
|
}
|
}
|
|
// 添加退出选项
|
/* resultList.Add(new UserPermission
|
{
|
Name = "退出",
|
Category = "全部应用",
|
IconType = "close",
|
Path = "/logout",
|
Color = "red"
|
});*/
|
|
return resultList;
|
}
|
|
|
private List<string> DoPurview(string userNo)
|
{
|
List<string> resultList = new List<string>();
|
|
try
|
{
|
// 定义输入参数
|
var inputParam1 = new SugarParameter("c_User_No", userNo.ToUpper());
|
var inputParam2 = new SugarParameter("c_MachType", "AN");
|
|
// 定义输出参数
|
var outParam = new SugarParameter("c_Result", null, true);
|
|
// 使用SqlSugar执行存储过程
|
Db.Ado.ExecuteCommand("BEGIN Prc_rf_j2_user_login(:c_User_No, :c_MachType, :c_Result); END;",
|
inputParam1, inputParam2, outParam);
|
|
// 获取输出参数的值
|
string result = outParam.Value == DBNull.Value ? string.Empty : (string)outParam.Value;
|
|
// 添加到结果列表
|
if (!string.IsNullOrEmpty(result))
|
{
|
resultList.Add(result);
|
}
|
}
|
catch (Exception ex)
|
{
|
// 记录异常
|
Console.WriteLine($"获取用户权限失败: {ex.Message}");
|
// 可以选择抛出异常或返回空列表
|
}
|
|
return resultList;
|
}
|
|
|
/// <summary>
|
/// 获取功能界面设置
|
/// </summary>
|
/// <param name="functionName">功能名称</param>
|
|
|
/// <summary>
|
/// 获取功能界面设置
|
/// </summary>
|
/// <param name="functionName">功能名称</param>
|
/// <returns>功能界面设置信息</returns>
|
public ResponseResult GetRfSetup(string functionName)
|
{
|
try
|
{
|
List<string> setupData = DoRfSetup(functionName);
|
|
if (setupData.Count > 0 && !string.IsNullOrEmpty(setupData[0]))
|
{
|
dynamic resultInfos = new ExpandoObject();
|
resultInfos.setupData = setupData[0];
|
|
return new ResponseResult
|
{
|
status = 0,
|
message = "查询功能界面成功！",
|
data = resultInfos
|
};
|
}
|
else
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "未找到功能界面设置！"
|
};
|
}
|
}
|
catch (Exception ex)
|
{
|
Console.WriteLine(ex.ToString());
|
return new ResponseResult
|
{
|
status = 1,
|
message = "查询功能界面失败！"
|
};
|
}
|
}
|
|
|
/// <summary>
|
/// 获取功能界面设置数据
|
/// </summary>
|
/// <param name="functionName">功能名称</param>
|
/// <returns>功能界面设置数据列表</returns>
|
private List<string> DoRfSetup(string functionName)
|
{
|
List<string> resultList = new List<string>();
|
|
try
|
{
|
// 定义输入参数
|
var inputParam1 = new SugarParameter("functionName", functionName);
|
var inputParam2 = new SugarParameter("deviceType", "AN");
|
|
// 定义输出参数
|
var outParam = new SugarParameter("result", null, true);
|
|
// 使用SqlSugar执行存储过程
|
Db.Ado.ExecuteCommand("BEGIN Prc_rf_setup(:functionName, :deviceType, :result); END;",
|
inputParam1, inputParam2, outParam);
|
|
// 获取输出参数的值
|
string result = outParam.Value == DBNull.Value ? string.Empty : (string)outParam.Value;
|
|
// 添加到结果列表
|
if (!string.IsNullOrEmpty(result))
|
{
|
resultList.Add(result);
|
}
|
}
|
catch (Exception ex)
|
{
|
// 记录异常
|
Console.WriteLine($"获取功能界面设置失败: {ex.Message}");
|
// 可以选择抛出异常或返回空列表
|
}
|
|
return resultList;
|
}
|
|
|
|
public ResponseResult GetExcProc(string functionName, string fileName, string pmachtype, string fileValue, string outFiles)
|
{
|
try
|
{
|
List<string> resultList = DoExcProc(functionName, fileName, pmachtype, fileValue);
|
Console.WriteLine(string.Join(", ", resultList));
|
|
if (resultList.Count > 0)
|
{
|
string s = resultList[0];
|
string[] strs = s.Split('[');
|
|
if (strs.Length < 1)
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = "返回值的格式不正确!" + string.Join(", ", resultList)
|
};
|
}
|
|
// 判断取值是否成功
|
string str = strs[0];
|
if (str.Equals("002"))
|
{
|
return new ResponseResult
|
{
|
status = 1,
|
message = strs[1]
|
};
|
}
|
else
|
{
|
if (string.IsNullOrEmpty(outFiles))
|
{
|
if (strs.Length < 2)
|
{
|
return new ResponseResult
|
{
|
status = 0,
|
data = ""
|
};
|
}
|
return new ResponseResult
|
{
|
status = 0,
|
data = strs[1]
|
};
|
}
|
else
|
{
|
List<string[]> at = new List<string[]>();
|
// [001[4500108372,80000123,100,物料80000123今日已收货 100]
|
string[] files = outFiles.Split(',');
|
string[] res = strs[1].Split(new char[] { ',' }, StringSplitOptions.None);
|
|
for (int i = 0; i < files.Length; i++)
|
{
|
string[] temp = new string[2];
|
temp[0] = files[i];
|
temp[1] = res[i];
|
at.Add(temp);
|
}
|
|
return new ResponseResult
|
{
|
status = 0,
|
data = at
|
};
|
}
|
}
|
}
|
|
return new ResponseResult
|
{
|
status = 0,
|
data = resultList
|
};
|
}
|
catch (Exception ex)
|
{
|
Console.WriteLine(ex.ToString());
|
return new ResponseResult
|
{
|
status = 1,
|
message = "执行存储过程失败：" + ex.Message
|
};
|
}
|
}
|
|
|
/// <summary>
|
/// 执行存储过程
|
/// </summary>
|
/// <param name="functionName">功能名称</param>
|
/// <param name="fileName">字段名</param>
|
/// <param name="pmachtype">设备类型</param>
|
/// <param name="fileValue">参数值</param>
|
/// <returns>存储过程执行结果</returns>
|
private List<string> DoExcProc(string functionName, string fileName, string pmachtype, string fileValue)
|
{
|
List<string> resultList = new List<string>();
|
|
try
|
{
|
// 定义输入参数
|
var inputParam1 = new SugarParameter("functionName", functionName);
|
var inputParam2 = new SugarParameter("fileName", fileName?.Trim());
|
var inputParam3 = new SugarParameter("pmachtype", "AN"); // 设备类型 wince5,wmb5,wmb6
|
var inputParam4 = new SugarParameter("fileValue", fileValue); // 参数值[第一位是用户]
|
|
// 定义输出参数
|
var outParam = new SugarParameter("result", null, true);
|
|
// 使用SqlSugar执行存储过程
|
Db.Ado.ExecuteCommand("BEGIN Prc_rf_setup_ExcProc(:functionName, :fileName, :pmachtype, :fileValue, :result); END;",
|
inputParam1, inputParam2, inputParam3, inputParam4, outParam);
|
|
// 获取输出参数的值
|
string result = outParam.Value == DBNull.Value ? string.Empty : (string)outParam.Value;
|
|
// 添加到结果列表
|
if (!string.IsNullOrEmpty(result))
|
{
|
resultList.Add(result);
|
}
|
}
|
catch (Exception ex)
|
{
|
// 记录异常
|
Console.WriteLine($"执行存储过程失败: {ex.Message}");
|
// 可以选择抛出异常或返回空列表
|
}
|
|
return resultList;
|
}
|
|
}
|
}
|
