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