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