using System.Data;
|
using System.Dynamic;
|
using System.Security.Cryptography;
|
using System.Text;
|
|
namespace NewPdaSqlServer.util;
|
|
public static class UtilityHelper
|
{
|
/// <summary>
|
/// 32位MD5加密
|
/// </summary>
|
/// <param name="password"></param>
|
/// <returns></returns>
|
public static string MD5Encrypt32(string password)
|
{
|
var cl = password;
|
var pwd = "";
|
var md5 = MD5.Create();
|
var s = md5.ComputeHash(Encoding.UTF8.GetBytes(cl));
|
for (var i = 0; i < s.Length; i++) pwd = pwd + s[i].ToString("X");
|
return pwd;
|
}
|
|
/// <summary>
|
/// table转DynamicList
|
/// </summary>
|
/// <param name="table"></param>
|
/// <returns></returns>
|
public static List<dynamic> TableToDynamicList(this DataTable table)
|
{
|
var list = new List<dynamic>();
|
// 遍历DataTable中的每一行
|
foreach (DataRow row in table.Rows)
|
{
|
dynamic item = new ExpandoObject();
|
// 遍历每一列，并添加到dynamic对象中
|
foreach (DataColumn column in table.Columns)
|
((IDictionary<string, object>)item)[column.ColumnName] =
|
row[column];
|
list.Add(item);
|
}
|
|
return list;
|
}
|
|
/// <summary>
|
/// row转DynamicList
|
/// </summary>
|
/// <param name="row"></param>
|
/// <returns></returns>
|
public static dynamic RowToDynamic(this DataRow row)
|
{
|
dynamic expando = new ExpandoObject();
|
if (row != null)
|
foreach (DataColumn column in row.Table.Columns)
|
{
|
var value = row[column];
|
// 如果值为DBNull.Value，则转换为null
|
if (value == DBNull.Value) value = null;
|
((IDictionary<string, object>)expando)[column.ColumnName] =
|
value;
|
}
|
|
return expando;
|
}
|
|
public static int GetBit(string v)
|
{
|
if (v.ToUpper() == "TRUE")
|
return 1;
|
if (v.ToUpper() == "1")
|
return 1;
|
return 0;
|
}
|
|
public static int? ToInt(string strV)
|
{
|
if (string.IsNullOrEmpty(strV))
|
return null;
|
return int.Parse(strV);
|
}
|
|
/// <summary>
|
/// </summary>
|
/// <param name="_userGuid">操作用户</param>
|
/// <param name="_abtGuid">关联主键，有时候会为null</param>
|
/// <param name="_tableName">表名，表描述</param>
|
/// <param name="_logTxt">行为</param>
|
/// <returns></returns>
|
public static StringBuilder BuildLog(string _userGuid, string _abtGuid,
|
string _table, string _logTxt)
|
{
|
var sb = new StringBuilder();
|
sb.Append(" exec prc_log_create '" + _userGuid + "','" + _abtGuid +
|
"','" + _table + "','" + _logTxt + "' ");
|
return sb;
|
}
|
|
|
/// <summary>
|
/// 如果guid为 Empty或者null 返回false
|
/// </summary>
|
/// <param name="guid"></param>
|
/// <returns></returns>
|
public static bool CheckGuid(Guid? guid)
|
{
|
if (guid == Guid.Empty)
|
return false;
|
return guid != null;
|
}
|
|
/// <summary>
|
/// 判断是不是guid
|
/// </summary>
|
/// <param name="guid"></param>
|
/// <returns></returns>
|
public static bool CheckGuid(string? guid)
|
{
|
if (string.IsNullOrEmpty(guid))
|
return false;
|
return guid != null;
|
}
|
}
|
