private void SearchUnusedTestData(string strWTBH)
{
DataTable Data = CaiJiHelperClient.GetUnusedTestData(strWTBH);
if (Data != null)
{
FpSpread_Info.Columns[0].Width = 80;
FpSpread_Info.Columns[1].Width = 80;
FpSpread_Info.Columns[2].Width = 120;
FpSpread_Info.Columns[3].Width = 100;
FpSpread_Info.Columns[4].Width = 100;
FpSpread_Info.Columns[5].Width = 40;
FpSpread_Info.Columns[6].Width = 80;
FpSpread_Info.Columns[7].Width = 400;
FpSpread_Info.Columns[8].Width = 100;
FpSpread_Info.Columns[9].Width = 100;
FpSpread_Info.Columns[10].Width = 100;
FpSpread_Info.Columns[11].Width = 120;
FpSpread_Info.Rows.Count = Data.Rows.Count;
int i, j;
string strModuleIDs = string.Empty;
foreach (DataRow Row in Data.Rows)
{
strModuleIDs += "'" + Row["ModuleID"].ToString() + "',";
}
if (strModuleIDs.Length > 0)
{
strModuleIDs = strModuleIDs.Substring(0, strModuleIDs.Length - 1);
}
DataTable dtSheet = ModuleHelperClient.GetSheetIDAndName(strModuleIDs);
foreach (System.Data.DataColumn Column in Data.Columns)
{
i = Data.Columns.IndexOf(Column);
FpSpread_Info.Columns[i].VerticalAlignment = CellVerticalAlignment.Center;
FpSpread_Info.Columns[i].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
if (i == 7)//解析试验结果
{
string strTestData = Row[Column.ColumnName].ToString();
StringBuilder strTestDataName = new StringBuilder();
try
{
List <JZTestCell> lstJZTC = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JZTestCell> >(strTestData);
string strSheetName = string.Empty;
bool bHaveSheet = false;;
foreach (JZTestCell tcItem in lstJZTC)
{
if (bHaveSheet == false)
{
bHaveSheet = true;
strSheetName = GetSheetName(dtSheet, tcItem.SheetID.ToString());
if (string.IsNullOrEmpty(strSheetName))
{
strTestDataName.Append(tcItem.SheetID + "|");
}
else
{
strTestDataName.Append(strSheetName + "|");
}
}
switch (tcItem.Name)
{
case JZTestEnum.DHBJ:
strTestDataName.Append("断后标距:" + tcItem.Value);
break;
case JZTestEnum.LDZDL:
strTestDataName.Append("拉断最大力:" + tcItem.Value);
break;
case JZTestEnum.PHHZ:
strTestDataName.Append("破坏荷载:" + tcItem.Value);
break;
case JZTestEnum.QFL:
strTestDataName.Append("屈服力:" + tcItem.Value);
break;
default:
break;
}
strTestDataName.Append(";");
}
}
catch (Exception ex)
{
//logger.Error(string.Format("解析Json出错,TestData:{0},Exception:{1}", strTestData, ex.Message));
strTestDataName.Append(strTestData);
//continue;
}
FpSpread_Info.Cells[j, i].Value = strTestDataName.ToString();
}
else
{
FpSpread_Info.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
FpSpread_Info.Cells[j, i].Value = Row[Column.ColumnName].ToString();
}
FpSpread_Info.Rows[j].Tag = Row["ID"];
}
}
}
}
