/// <summary>
/// List转DataTable
/// </summary>
/// <param name="list">列表</param>
/// <returns></returns>
public static DataTable ToDataTable(System.Collections.IList list)
{
DataTable dataTable = new DataTable();
if (list.Count > 0)
{
System.Reflection.PropertyInfo[] properties = list[0].GetType().GetProperties();
System.Reflection.PropertyInfo[] array = properties;
for (int i = 0; i < array.Length; i++)
{
System.Reflection.PropertyInfo propertyInfo = array[i];
if (!DxPublic.IsNullableType(propertyInfo.PropertyType))
{
dataTable.Columns.Add(propertyInfo.Name, propertyInfo.PropertyType);
}
}
for (int j = 0; j < list.Count; j++)
{
System.Collections.ArrayList arrayList = new System.Collections.ArrayList();
System.Reflection.PropertyInfo[] array2 = properties;
for (int k = 0; k < array2.Length; k++)
{
System.Reflection.PropertyInfo propertyInfo2 = array2[k];
if (!DxPublic.IsNullableType(propertyInfo2.PropertyType))
{
object value = propertyInfo2.GetValue(list[j], null);
arrayList.Add(value);
}
}
object[] values = arrayList.ToArray();
dataTable.LoadDataRow(values, true);
}
}
return(dataTable);
}
/// <summary>
/// 检件文件夹是否存在，不存在则创建
/// </summary>
/// <param name="FileName">文件名</param>
public static void CheckFolderExistsViaFileName(string FileName)
{
System.IO.FileInfo fileInfo = new System.IO.FileInfo(FileName);
if (fileInfo != null)
{
DxPublic.CheckFolderExists(fileInfo.DirectoryName);
}
}
/// <summary>
/// OBJECT类型转时间格式
/// </summary>
/// <param name="obj">obj对象</param>
/// <returns></returns>
public static DateTime GetObjDateTime(object obj)
{
if (DxPublic.IsObjNull(obj))
{
return(new System.DateTime(2020, 1, 1));
}
return(System.Convert.ToDateTime(obj));
}
/// <summary>
/// Obj转成GUID
/// </summary>
/// <param name="obj">对象</param>
/// <returns></returns>
public static System.Guid GetObjGUID(object obj)
{
string objectString = DxPublic.GetObjString(obj);
System.Guid result;
if (!System.Guid.TryParse(objectString, out result))
{
result = System.Guid.Parse("00000000-0000-0000-0000-000000000000");
}
return(result);
}
/// <summary>
/// 根据用户ID获取用户权限列表
/// </summary>
/// <param name="guidUserId">用户ID</param>
/// <returns>用户列表</returns>
public IList <Models.ACL_Role_Function> GetUserFunctionList(Guid sysetemId, Guid userId, Guid departmentId)
{
string sqlText = string.Format(@"select DISTINCT a.RoleId,a.FunctionId,a.OpCode,b.FuncName
from ACL_Role_Function as a inner join ACL_Function as b on a.FunctionId=b.Id
inner join ACL_Role as c on a.RoleId=c.Id
where b.SystemId='{0}' and RoleId in ( select distinct RoleId from ACL_Role_User where UserId='{1}'
union select RoleId from ACL_Role_Department where DepartmentId='{2}')", sysetemId, userId, departmentId);
DataTable dt = Global._SqlDb.ExecuteDataTable(sqlText);
return(DxPublic.DataTableToList <Models.ACL_Role_Function>(dt));
}
/// <summary>
/// 异常信息提示
/// </summary>
/// <param name="ex">异常</param>
/// <param name="Caption">提示框名称</param>
public static void ShowExceptionFormat(Exception ex, string Caption = "系统提示")
{
string content = string.Format("Message:{0} {1} Source:{2} {1} StackTrace:{3}", new object[]
{
ex.Message,
System.Environment.NewLine,
ex.Source,
ex.StackTrace
});
DxPublic.ShowMessage(MessageBoxIcon.Hand, content, Caption);
}
/// <summary>
/// 获取登录信息
/// </summary>
/// <returns name="LoginInfo">登录信息</returns>
public static vwModels.LoginInfo GetLoginInfo()
{
var loginInfo = new vwModels.LoginInfo();
loginInfo.LoginName = GetValue("LoginName");
loginInfo.IsRberPwd = Convert.ToBoolean(GetValue("IsRberPwd", "false"));
if (loginInfo.IsRberPwd)
{
loginInfo.LoginPwd = DxPublic.DecryptString(GetValue("LoginPwd"));
}
return(loginInfo);
}
/// <summary>
/// 设置登录信息
/// </summary>
/// <param name="loginInfo">登录信息</param>
/// <returns></returns>
public static bool SetLoginInfo(vwModels.LoginInfo loginInfo)
{
loginInfo.LoginPwd = DxPublic.EncryptString(loginInfo.LoginPwd);
if (!loginInfo.IsRberPwd)
{
loginInfo.LoginPwd = "";
}
if (SetValue("LoginName", loginInfo.LoginName) &&
SetValue("LoginPwd", loginInfo.LoginPwd) &&
SetValue("IsRberPwd", loginInfo.IsRberPwd.ToString()))
{
return(true);
}
return(false);
}
/// <summary>
/// 启动更新程序
/// </summary>
public static void StartUpdate()
{
try
{
Process[] processesByName = Process.GetProcessesByName(Global._AppProName);
Process[] array = processesByName;
for (int i = 0; i < array.Length; i++)
{
Process process = array[i];
process.Kill();
}
Process.Start(Global._AppUpdateName);
}
catch (Exception ex)
{
DxPublic.ShowException(ex);
}
}
/// <summary>
/// 程序是否有更新
/// </summary>
/// <returns></returns>
public static bool IsNeedUpdate()
{
bool result = false;
try
{
string FileName = Global._AppUpdateList;
AutoUpXmlHelper xdoc = new AutoUpXmlHelper(FileName);
string version = xdoc.GetNodeValue("AutoUpdate/Application/Version");
result = Global._AppRight.IsUpdateVersion(Global._Session._SystemId, version);
}
catch (Exception ex)
{
DxPublic.ShowException(ex);
result = false;
}
return(result);
}
/// <summary>
/// 获取连接字符串
/// </summary>
/// <param name="key">连接字符串键</param>
/// <returns></returns>
public static string GetConnectionString(string name)
{
try
{
var value = ConfigurationManager.ConnectionStrings[name].ConnectionString;
if (string.IsNullOrEmpty(value))
{
throw new Exception($"读取配置文件的连接字符串出错！");
}
else
{
return(DxPublic.DecryptString(value));
}
}
catch
{
return("");
}
}
/// <summary>
/// 读取文件文本信息
/// </summary>
/// <param name="FileName">文件名</param>
/// <returns></returns>
public static string ReadTextFile(string FileName)
{
if (!DxPublic.GetFileExists(FileName))
{
throw new System.Exception("文件不存在！!");
}
System.IO.StreamReader streamReader = null;
string result;
try
{
streamReader = new System.IO.StreamReader(FileName, System.Text.Encoding.UTF8);
result = streamReader.ReadToEnd();
}
finally
{
if (streamReader != null)
{
streamReader.Close();
streamReader.Dispose();
}
}
return(result);
}
/// <summary>
/// 获取连接字符串，存在则修改，不存在则添加
/// </summary>
/// <param name="key">连接字符串键</param>
/// <param name="connString">连接字符串</param>
/// <returns></returns>
public static bool SetConnectionString(string name, string connString, string providerName = "System.Data.SqlClient")
{
try
{
var configFile = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
var settings = configFile.ConnectionStrings.ConnectionStrings;
connString = DxPublic.EncryptString(connString);
if (settings[name] == null)
{
settings.Add(new ConnectionStringSettings(name, connString, providerName));
}
else
{
settings[name].ConnectionString = connString;
}
configFile.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection(configFile.AppSettings.SectionInformation.Name);
return(true);
}
catch (Exception ex)
{
throw new Exception($"定入配置文件出错：{ex.Message}");
}
}
/// <summary>
/// 获取打开的XLS文件名称
/// </summary>
/// <param name="DefaultFileName">默认文件名</param>
/// <returns></returns>
public static string GetOpenXlsFileName(string DefaultFileName)
{
return(DxPublic.GetOpenFileName("EXCEL File(*.xls)|*.xls", DefaultFileName));
}
/// <summary>
/// Obj转成大定的String类型
/// </summary>
/// <param name="obj">对象</param>
/// <returns></returns>
public static string GetObjStrUpperTrim(object obj)
{
return(DxPublic.GetObjString(obj).Trim().ToUpper());
}
/// <summary>
/// 获取系统ID
/// </summary>
/// <returns></returns>
public static Guid GetSystemId()
{
return(DxPublic.GetObjGUID(AppSetingHelper.GetValue("SystemId")));
}