public static void UpdateOperateRecord(string content)
        {
            TOperateRecordManager recordManager = new TOperateRecordManager();
            TOperateRecord        operateRecord = new TOperateRecord();

            operateRecord.ID             = TablePrimaryKey.InsertOperateRecordPID();
            operateRecord.OperateContent = content;
            operateRecord.OperateUser    = LocalLogin.currentUserName;
            operateRecord.OperateDate    = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            recordManager.Insert(operateRecord);
        }
        public static long InsertOperateRecordPID()
        {
            long id = -1;
            TOperateRecordManager objManager = new TOperateRecordManager();
            var dt = objManager.GetDataSetByWhere("order by ID DESC limit 1").Tables[0];

            if (dt.Rows.Count < 1)
            {
                return(0);
            }
            if (long.TryParse(dt.Rows[0]["ID"].ToString(), out id))
            {
                return(id + 1);
            }
            return(id);
        }
Пример #3
0
        public OperatorLog()
        {
            InitializeComponent();
            this.StartPosition = FormStartPosition.CenterParent;

            this.dateTimePickerStartTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd");
            this.datePickerEndTime.Text       = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            RadGridViewProperties.SetRadGridViewProperty(this.radGridView1, false, false, 4);
            operationRecordManager = new TOperateRecordManager();
            InitFuncState();
            QueryOperateData();

            this.tool_likeQuery.Click                 += Tool_likeQuery_Click;
            this.tool_export.Click                    += Tool_export_Click;
            this.tool_deleteSignalData.Click          += Tool_deleteSignalData_Click;
            this.tool_deleteAllData.Click             += Tool_deleteAllData_Click;
            this.tb_queryCondition.TextChanged        += Tb_queryCondition_TextChanged;
            this.dateTimePickerStartTime.ValueChanged += DateTimePickerStartTime_ValueChanged;
            this.datePickerEndTime.ValueChanged       += DatePickerEndTime_ValueChanged;
        }