private static DataTable QueryTestHisDetail(string testSerial)
{
#region init table
DataTable dataSource = new DataTable();
dataSource.Columns.Add("序号");
dataSource.Columns.Add("起点接口");
dataSource.Columns.Add("起点接点");
dataSource.Columns.Add("终点接口");
dataSource.Columns.Add("终点接点");
dataSource.Columns.Add("导通电阻(Ω)");
dataSource.Columns.Add("导通测试结果");
dataSource.Columns.Add("短路测试(Ω)");
dataSource.Columns.Add("短路测试结果");
dataSource.Columns.Add("绝缘电阻(MΩ)");
dataSource.Columns.Add("绝缘测试结果");
//dataSource.Columns.Add("耐压电流(Ω)");
//dataSource.Columns.Add("耐压测试结果");
#endregion
THistoryDataDetailManager detailManage = new THistoryDataDetailManager();
var data = detailManage.GetDataSetByWhere($"where TestSerialNumber = '{testSerial}'").Tables[0];
if (data.Rows.Count <= 0)
{
return(dataSource);
}
int iRow = 1;
foreach (DataRow dataRow in data.Rows)
{
DataRow dr = dataSource.NewRow();
dr["序号"] = iRow;
dr["起点接口"] = dataRow["StartInterface"].ToString();
dr["起点接点"] = dataRow["StartContactPoint"].ToString();
dr["终点接口"] = dataRow["EndInterface"].ToString();
dr["终点接点"] = dataRow["EndContactPoint"].ToString();
dr["导通电阻(Ω)"] = dataRow["ConductValue"].ToString();
dr["导通测试结果"] = dataRow["ConductTestResult"].ToString();
dr["短路测试(Ω)"] = dataRow["ShortCircuitValue"].ToString();
dr["短路测试结果"] = dataRow["ShortCircuitTestResult"].ToString();
double insulateVal;
if (double.TryParse(dataRow["InsulateValue"].ToString(), out insulateVal))
{
dr["绝缘电阻(MΩ)"] = (insulateVal / 1000000).ToString("f1");
}
else
{
dr["绝缘电阻(MΩ)"] = "--";
}
dr["绝缘测试结果"] = dataRow["InsulateTestResult"].ToString();
dataSource.Rows.Add(dr);
iRow++;
}
return(dataSource);
}
private void RadTestDataDetail_Load(object sender, EventArgs e)
{
historyDataInfoManager = new THistoryDataBasicManager();
historyDataDetailManager = new THistoryDataDetailManager();
RadGridViewProperties.SetRadGridViewProperty(this.radGridView1, false, true, this.radGridView1.ColumnCount);
QueryHistoryBasicInfo(false);
this.menu_close.Click += Menu_close_Click;
this.menu_exportExcel.Click += Menu_exportExcel_Click;
this.menu_printReport.Click += Menu_printReport_Click;
this.menu_toReport.Click += Menu_toReport_Click;
}
public static long InsertHistoryDetailPID()
{
int id = -1;
THistoryDataDetailManager objManager = new THistoryDataDetailManager();
var dt = objManager.GetDataSetByWhere("order by ID DESC limit 1").Tables[0];
if (dt.Rows.Count < 1)
{
return(0);
}
if (int.TryParse(dt.Rows[0]["ID"].ToString(), out id))
{
return(id + 1);
}
else
{
LogHelper.Log.Error("Option His Detail PID FAILT..." + id);
}
return(id);
}
private void RadTestDataBasicInfo_Load(object sender, EventArgs e)
{
historyDataInfoManager = new THistoryDataBasicManager();
historyDataDetailManager = new THistoryDataDetailManager();
this.dateTimePicker_start.Text = DateTime.Now.ToString("yyyy-MM-dd");
this.dateTimePicker_end.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
RadGridViewProperties.SetRadGridViewProperty(this.radGridView1, false, true, this.radGridView1.ColumnCount);
QueryHistoryBasicInfo();
InitFuncState();
this.dateTimePicker_start.ValueChanged += DateTimePicker_start_ValueChanged;
this.dateTimePicker_end.ValueChanged += DateTimePicker_end_ValueChanged;
this.tb_queryFilter.TextChanged += Tb_queryFilter_TextChanged;
this.menu_close.Click += Menu_close_Click;
this.menu_detail.Click += Menu_detail_Click;
this.menu_likeQuery.Click += Menu_likeQuery_Click;
this.menu_export.Click += Menu_export_Click;
this.menu_deleteData.Click += Menu_deleteData_Click;
this.radGridView1.CellDoubleClick += RadGridView1_CellDoubleClick;
}