/// <summary>
/// 整合报告数据
/// </summary>
/// <param name="testCode">二维码</param>
/// <returns>报告数据</returns>
private static DataSet GetReportDataSet(string testCode)
{
DataSet resData = new DataSet();
//DataTable dt = new DataTable(); //新建对象
//dt.Columns.Add("姓名", typeof(string)); //新建第一列
//dt.Columns.Add("年龄", typeof(int)); //新建第二列
//dt.Rows.Add("张三",23); //新建第一行，并赋值
//dt.Rows.Add("李四",25); //新建第二行，并赋值
//resData.Tables.Add(dt);
MYDataBaseHelper mydataHeper = new MYDataBaseHelper();
string sql = $"select * from parameter_information where TestCode= '{testCode}'";
DataTable param1 = mydataHeper.GetDataTable(sql, "参数信息");
if (param1.Rows.Count == 0)
{
throw new Exception($"参数信息表中不存在二维码为:{testCode}的数据！");
}
resData.Tables.Add(param1);
sql = $"select waves from testresult where testid= '{testCode}' and function='20'";
DataTable param23 = mydataHeper.GetDataTable(sql, "温湿度");
DataColumn cl = new DataColumn("温度");
param23.Columns.Add(cl);
cl = new DataColumn("湿度");
param23.Columns.Add(cl);
cl = new DataColumn("油温");
param23.Columns.Add(cl);
foreach (DataRow dr in param23.Rows)
{
string cmd = dr["waves"].ToString();
if (cmd != null && cmd != "")
{
Infomation.JobInformation info = Infomation.JobInformation.FromString(cmd);
dr["温度"] = info.temperature;
dr["湿度"] = info.humidity;
dr["油温"] = info.oilTemperature;
}
}
resData.Tables.Add(param23);
sql = $"select * from sample_information where TestCode= '{testCode}'";
DataTable param2 = mydataHeper.GetDataTable(sql, "试品信息");
resData.Tables.Add(param2);
sql = $"select * from conclusion where TestCode= '{testCode}'";
DataTable param3 = mydataHeper.GetDataTable(sql, "试验结论");
resData.Tables.Add(param3);
sql = $"select * from casingtest_commonbody where TestCode= '{testCode}'";
DataTable param4 = mydataHeper.GetDataTable(sql, "套管试验");
resData.Tables.Add(param4);
sql = $"select * from casingtest_commonbodyresults where TestCode= '{testCode}'";
DataTable param5 = mydataHeper.GetDataTable(sql, "套管试验结果");
resData.Tables.Add(param5);
sql = $"select * from dcresistor_highpressure where TestCode= '{testCode}'";
DataTable param6 = mydataHeper.GetDataTable(sql, "直流电阻高压");
resData.Tables.Add(param6);
sql = $"select * from dcresistor_highpressureresults where TestCode= '{testCode}'";
DataTable param7 = mydataHeper.GetDataTable(sql, "直流电阻高压结果");
resData.Tables.Add(param7);
sql = $"select * from dcresistor_lowpressure where TestCode= '{testCode}'";
DataTable param8 = mydataHeper.GetDataTable(sql, "直流电阻低压");
resData.Tables.Add(param8);
sql = $"select * from dcresistor_lowpressureresults where TestCode= '{testCode}'";
DataTable param9 = mydataHeper.GetDataTable(sql, "直流电阻低压结果");
resData.Tables.Add(param9);
sql = $"select * from dcresistor_mediumvoltage where TestCode= '{testCode}'";
DataTable param10 = mydataHeper.GetDataTable(sql, "直流电阻中压");
resData.Tables.Add(param10);
sql = $"select * from dcresistor_mediumvoltageresults where TestCode= '{testCode}'";
DataTable param11 = mydataHeper.GetDataTable(sql, "直流电阻中压结果");
resData.Tables.Add(param11);
sql = $"select * from dielectriclossandcapacitance_threewinding where TestCode= '{testCode}'";
DataTable param12 = mydataHeper.GetDataTable(sql, "介质损耗和电容三绕组");
resData.Tables.Add(param12);
sql = $"select * from dielectriclossandcapacitance_threewindingresults where TestCode= '{testCode}'";
DataTable param13 = mydataHeper.GetDataTable(sql, "介质损耗和电容三绕组结果");
resData.Tables.Add(param13);
sql = $"select * from insulationresistance_threewinding where TestCode= '{testCode}'";
DataTable param14 = mydataHeper.GetDataTable(sql, "绕组绝缘电阻三绕组");
resData.Tables.Add(param14);
sql = $"select * from insulationresistance_threewindingresults where TestCode= '{testCode}'";
DataTable param15 = mydataHeper.GetDataTable(sql, "绕组绝缘电阻三绕组结果");
resData.Tables.Add(param15);
sql = $"select * from tapchangertest where TestCode= '{testCode}'";
DataTable param16 = mydataHeper.GetDataTable(sql, "分接开关试验");
resData.Tables.Add(param16);
sql = $"select * from tapchangertestresults where TestCode= '{testCode}'";
DataTable param17 = mydataHeper.GetDataTable(sql, "分接开关试验结果");
resData.Tables.Add(param17);
sql = $"select * from windingcoreinsulationresistance where TestCode= '{testCode}'";
DataTable param18 = mydataHeper.GetDataTable(sql, "绕组铁芯绝缘电阻");
resData.Tables.Add(param18);
sql = $"select * from windingcoreinsulationresistanceresults where TestCode= '{testCode}'";
DataTable param19 = mydataHeper.GetDataTable(sql, "绕组铁芯绝缘电阻结果");
resData.Tables.Add(param19);
sql = $"select waves,instnum,instname,othertestconclusion from testresult where testid= '{testCode}' and function='12'";
DataTable param20 = mydataHeper.GetDataTable(sql, "泄露电流试验");
DataColumn cll = new DataColumn("H_L10kV");
param20.Columns.Add(cll);
cll = new DataColumn("L_H10kV");
param20.Columns.Add(cll);
cll = new DataColumn("HL10kV");
param20.Columns.Add(cll);
cll = new DataColumn("H_L20kV");
param20.Columns.Add(cll);
cll = new DataColumn("L_H20kV");
param20.Columns.Add(cll);
cll = new DataColumn("HL20kV");
param20.Columns.Add(cll);
cll = new DataColumn("H_L40kV");
param20.Columns.Add(cll);
cll = new DataColumn("L_H40kV");
param20.Columns.Add(cll);
cll = new DataColumn("HL40kV");
param20.Columns.Add(cll);
foreach (DataRow dr in param20.Rows)
{
string cmd = dr["waves"].ToString();
if (cmd != null && cmd != "")
{
LeakCurJson leak = JsonConvert.DeserializeObject <LeakCurJson>(cmd);
dr["H_L10kV"] = leak.H_L10kV;
dr["L_H10kV"] = leak.L_H10kV;
dr["HL10kV"] = leak.HL10kV;
dr["H_L20kV"] = leak.H_L20kV;
dr["L_H20kV"] = leak.L_H20kV;
dr["HL20kV"] = leak.HL20kV;
dr["H_L40kV"] = leak.H_L40kV;
dr["L_H40kV"] = leak.L_H40kV;
dr["HL40kV"] = leak.HL40kV;
}
}
resData.Tables.Add(param20);
sql = $"select * from testresult where testid= '{testCode}' and function='11'";
DataTable param21 = mydataHeper.GetDataTable(sql, "铁芯试验");
resData.Tables.Add(param21);
sql = $"select * from testresult where testid= '{testCode}' and function='13'";
DataTable param22 = mydataHeper.GetDataTable(sql, "短路阻抗试验");
resData.Tables.Add(param22);
//param20 = mydataHeper.GetDataTable(sql, "泄漏电流_铁芯_短路阻抗试验");
return(resData);
}
/// <summary>
/// 整合报告数据
/// </summary>
/// <param name="testCode">二维码</param>
/// <returns>报告数据</returns>
private static DataSet GetReportDataSet(string testCode)
{
DataSet resData = new DataSet();
//DataTable dt = new DataTable(); //新建对象
//dt.Columns.Add("姓名", typeof(string)); //新建第一列
//dt.Columns.Add("年龄", typeof(int)); //新建第二列
//dt.Rows.Add("张三",23); //新建第一行，并赋值
//dt.Rows.Add("李四",25); //新建第二行，并赋值
//resData.Tables.Add(dt);
MYDataBaseHelper mydataHeper = new MYDataBaseHelper();
string sql = $"select * from parameter_information where TestCode= '{testCode}'";
DataTable param1 = mydataHeper.GetDataTable(sql, "参数信息");
if (param1.Rows.Count == 0)
{
throw new Exception($"参数信息表中不存在二维码为:{testCode}的数据！");
}
resData.Tables.Add(param1);
sql = $"select * from sample_information where TestCode= '{testCode}'";
DataTable param2 = mydataHeper.GetDataTable(sql, "试品信息");
resData.Tables.Add(param2);
sql = $"select * from conclusion where TestCode= '{testCode}'";
DataTable param3 = mydataHeper.GetDataTable(sql, "试验结论");
resData.Tables.Add(param3);
sql = $"select * from casingtest_commonbody where TestCode= '{testCode}'";
DataTable param4 = mydataHeper.GetDataTable(sql, "套管试验");
resData.Tables.Add(param4);
sql = $"select * from casingtest_commonbodyresults where TestCode= '{testCode}'";
DataTable param5 = mydataHeper.GetDataTable(sql, "套管试验结果");
resData.Tables.Add(param5);
sql = $"select * from dcresistor_highpressure where TestCode= '{testCode}'";
DataTable param6 = mydataHeper.GetDataTable(sql, "直流电阻高压");
resData.Tables.Add(param6);
sql = $"select * from dcresistor_highpressureresults where TestCode= '{testCode}'";
DataTable param7 = mydataHeper.GetDataTable(sql, "直流电阻高压结果");
resData.Tables.Add(param7);
sql = $"select * from dcresistor_lowpressure where TestCode= '{testCode}'";
DataTable param8 = mydataHeper.GetDataTable(sql, "直流电阻低压");
resData.Tables.Add(param8);
sql = $"select * from dcresistor_lowpressureresults where TestCode= '{testCode}'";
DataTable param9 = mydataHeper.GetDataTable(sql, "直流电阻低压结果");
resData.Tables.Add(param9);
sql = $"select * from dcresistor_mediumvoltage where TestCode= '{testCode}'";
DataTable param10 = mydataHeper.GetDataTable(sql, "直流电阻中压");
resData.Tables.Add(param10);
sql = $"select * from dcresistor_mediumvoltageresults where TestCode= '{testCode}'";
DataTable param11 = mydataHeper.GetDataTable(sql, "直流电阻中压结果");
resData.Tables.Add(param11);
sql = $"select * from dielectriclossandcapacitance_threewinding where TestCode= '{testCode}'";
DataTable param12 = mydataHeper.GetDataTable(sql, "介质损耗和电容三绕组");
resData.Tables.Add(param12);
sql = $"select * from dielectriclossandcapacitance_threewindingresults where TestCode= '{testCode}'";
DataTable param13 = mydataHeper.GetDataTable(sql, "介质损耗和电容三绕组结果");
resData.Tables.Add(param13);
sql = $"select * from insulationresistance_threewinding where TestCode= '{testCode}'";
DataTable param14 = mydataHeper.GetDataTable(sql, "绕组绝缘电阻三绕组");
resData.Tables.Add(param14);
sql = $"select * from insulationresistance_threewindingresults where TestCode= '{testCode}'";
DataTable param15 = mydataHeper.GetDataTable(sql, "绕组绝缘电阻三绕组结果");
resData.Tables.Add(param15);
sql = $"select * from tapchangertest where TestCode= '{testCode}'";
DataTable param16 = mydataHeper.GetDataTable(sql, "分接开关试验");
resData.Tables.Add(param16);
sql = $"select * from tapchangertestresults where TestCode= '{testCode}'";
DataTable param17 = mydataHeper.GetDataTable(sql, "分接开关试验结果");
resData.Tables.Add(param17);
sql = $"select * from windingcoreinsulationresistance where TestCode= '{testCode}'";
DataTable param18 = mydataHeper.GetDataTable(sql, "绕组铁芯绝缘电阻");
resData.Tables.Add(param18);
sql = $"select * from windingcoreinsulationresistanceresults where TestCode= '{testCode}'";
DataTable param19 = mydataHeper.GetDataTable(sql, "绕组铁芯绝缘电阻结果");
resData.Tables.Add(param19);
return(resData);
}
