public static long InsertDevFaultRecordPID() { long id = -1; DeviceFaultRecordManager objManager = new DeviceFaultRecordManager(); 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); }
private void QueryFaultInfo() { DeviceFaultRecordManager equipmentFaultRecordManager = new DeviceFaultRecordManager(); var dt = equipmentFaultRecordManager.GetAllDataSet().Tables[0]; if (dt.Rows.Count < 1) { return; } foreach (DataRow dr in dt.Rows) { var faultDate = dr["DeviceFaultDate"].ToString(); var faultContent = dr["DeviceFaultContent"].ToString(); if (IsExistFaultRecord(faultDate, faultContent)) { continue; } this.radGridView1.Rows.AddNew(); var rCount = this.radGridView1.RowCount; this.radGridView1.Rows[rCount - 1].Cells[0].Value = rCount; this.radGridView1.Rows[rCount - 1].Cells[1].Value = faultDate; this.radGridView1.Rows[rCount - 1].Cells[2].Value = faultContent; } }