/// <summary> /// 保存日记 /// </summary> /// <param name="message">RFID</param> /// <param name="mod_id">操作名称</param> /// <param name="types">0:入库、1:出库、2:上架、3:基本信息)</param> /// <param name="result">0/1</param> public static void saveLog(string mod_id, string message, short types, short result) { try { //init mysql db using (var db = new MysqlDbContext()) { var tmpLog = new t_syslogrecd(); var guid = Guid.NewGuid(); var rand = new Random(); tmpLog.log_id = DateTime.Now.ToString("yyyyMMddHHmmss") + "R" + rand.Next(100000).ToString(); tmpLog.operatorid = "SocketRFID"; tmpLog.message = message;// "RFID采集"; tmpLog.type = types; tmpLog.result = result; tmpLog.mod_id = mod_id;//"StocketRFID"; tmpLog.adduser = _serverIP; tmpLog.addtime = DateTime.Now; tmpLog.org_no = "SocketRFID"; db.t_syslogrecd.Add(tmpLog); db.SaveChanges(); logger.DebugFormat("*******SAVE LOG******"); } } catch (Exception ex) { logger.Error(ex.Message); } }
public static void testDB() { try { using (var db = new MysqlDbContext()) { //var tmpNewt_checkresult = new t_checkresult(); //var tmpNewt_checkdetailresult = new t_checkdetailresult(); //var tmpGuidId = Guid.NewGuid().ToString(); //#region 主表 //tmpNewt_checkresult.check_id = tmpGuidId; //tmpNewt_checkresult.check_date = DateTime.Now; //tmpNewt_checkresult.bespeak_no = "RFID"; //tmpNewt_checkresult.bespeak_date = "8:00:00"; //tmpNewt_checkresult.user_no = "点检"; //tmpNewt_checkresult.user_nm = "点检"; //tmpNewt_checkresult.status = 1; //tmpNewt_checkresult.remark = "点检"; //tmpNewt_checkresult.addtime = DateTime.Now; //tmpNewt_checkresult.adduser = "******"; //tmpNewt_checkresult.updtime = DateTime.Now; //tmpNewt_checkresult.upduser = "******"; //db.t_checkresult.Add(tmpNewt_checkresult); //var saveflag2 = db.SaveChanges(); //#endregion var tmpLog = new t_syslogrecd(); //tmpLog.log_id = new Random(10000).Next(1000000); tmpLog.operatorid = "SocketRFID"; tmpLog.message = "RFID采集"; tmpLog.type = 1; tmpLog.result = 1; tmpLog.mod_id = "StocketRFID"; tmpLog.adduser = "******"; tmpLog.addtime = DateTime.Now; tmpLog.org_no = "dd"; db.t_syslogrecd.Add(tmpLog); var saveflag2 = db.SaveChanges(); } } catch (Exception ex) { throw ex; } }