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