Exemplo n.º 1
0
        /// <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);
            }
        }
Exemplo n.º 2
0
        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;
            }
        }