private void QueryOperateData() { var queryStr = ""; var startTime = this.dateTimePickerStartTime.Text; var endTime = this.datePickerEndTime.Text; if (this.tb_queryCondition.Text.Trim() != "") { queryStr = $"where OperateUser like '%{this.tb_queryCondition.Text.Trim()}%' and OperateDate >= '{startTime}' and OperateDate <= '{endTime}'"; } else { queryStr = $"where OperateDate >= '{startTime}' and OperateDate <= '{endTime}'"; } var dt = operationRecordManager.GetDataSetByWhere(queryStr).Tables[0]; RadGridViewProperties.ClearGridView(this.radGridView1, null); foreach (DataRow dr in dt.Rows) { this.radGridView1.Rows.AddNew(); var rowCount = this.radGridView1.RowCount; this.radGridView1.Rows[rowCount - 1].Cells[0].Value = rowCount; this.radGridView1.Rows[rowCount - 1].Cells[1].Value = dr["OperateUser"].ToString(); this.radGridView1.Rows[rowCount - 1].Cells[2].Value = dr["OperateContent"].ToString(); this.radGridView1.Rows[rowCount - 1].Cells[3].Value = dr["OperateDate"].ToString(); } }
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); }