/// <summary>
/// 将DataTable转换位List(object)列表
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public static List <object> TableToObj(DataTable table)
{
try
{
List <object> list = new List <object>();
foreach (DataRow row in table.Rows)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
for (int i = 0; i < table.Columns.Count; i++)
{
string name = table.Columns[i].ColumnName;
object value = row.ItemArray[i];
if (typeof(DateTime) == value.GetType() && value != null)
{
value = DateTime.Parse(row.ItemArray[i].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
}
dict.Add(name, value);
}
list.Add(dict);
}
return(list);
}
catch (Exception ex)
{
CLog.WriteErrLog(ex.Message);
return(null);
}
}
/// <summary>
/// 提示音
/// </summary>
/// <param name="flag">0:错误,1:扫描正确,2:OK</param>
/// <returns></returns>
public static bool SoundTip(int flag)
{
Sound sp = null;
try
{
string filePath = "";
uint[] blight = new uint[2];
switch (flag)
{
case 0:
filePath = BaseVariable.ErrorSound;
break;
case 1:
filePath = BaseVariable.ScanSound;
break;
case 2:
filePath = BaseVariable.OkSound;
break;
}
//using (SoundPlayer sp = new SoundPlayer(filePath))
//{
// sp.Play();
//}
sp = new Sound(filePath);
sp.Play();
return(true);
}
catch (Exception ex)
{
CLog.WriteErrLog(ex.Message);
return(false);
}
finally
{
sp = null;
}
}
/// <summary>
/// 根据时间按写日志
/// </summary>
/// <param name="span"></param>
/// <param name="msg"></param>
public static void WirteTimeSpanLog(TimeSpan span, LogType type)
{
try
{
if (span.TotalSeconds > 1)
{
string msg = "";
switch (type)
{
case LogType.SP: //合件
msg = "扫描合件";
break;
case LogType.SC: //子件
msg = "扫描子件";
break;
case LogType.Y1: //验证合件
msg = "验证合件";
break;
case LogType.Y2: //验证子件
msg = "验证子件";
break;
case LogType.V0: //声音Error
msg = "错误提示音";
break;
case LogType.V1: //扫描OK
msg = "扫描提示音";
break;
case LogType.V2: //声音OK
msg = "正确提示音";
break;
case LogType.RD: //插入到数据库
msg = "更新到数据库";
break;
case LogType.DBOPEN: //数据库连接OPEN
msg = "数据库连接OPEN";
break;
case LogType.DBEXECUTE: //执行SQL语句
msg = "执行SQL语句";
break;
case LogType.REQUEST: //执行SQL语句
msg = "Request请求";
break;
}
CLog.WriteStationLog("scan", msg + ":" + span);
}
}
catch (Exception ex)
{
CLog.WriteErrLog("[FrmScan.WirteTimeSpanLog]" + ex.Message);
}
}