private void SetDataSource()
{
Sheet.Rows.Count = 0;
var result = CaiJiHelperClient.GetTestOverTimeByDataID(DataID);
if (result == null || result.Rows.Count == 0)
{
return;
}
Sheet.Rows.Count = result.Rows.Count;
for (var i = 0; i < result.Rows.Count; i++)
{
var row = result.Rows[i];
Sheet.Cells[i, 0].Value = row["标段名称"];
Sheet.Cells[i, 1].Value = row["单位名称"];
Sheet.Cells[i, 2].Value = row["试验室名称"];
Sheet.Cells[i, 3].Value = row["模板名称"];
Sheet.Cells[i, 4].Value = row["WTBH"];
Sheet.Cells[i, 6].Value = (row["实际试验日期"] == DBNull.Value || row["实际试验日期"] == null) ? "" : ((DateTime)(row["实际试验日期"])).ToString("yyyy-MM-dd");
Sheet.Cells[i, 7].Value = (row["龄期到期日期"] == DBNull.Value || row["龄期到期日期"] == null) ? "" : ((DateTime)(row["龄期到期日期"])).ToString("yyyy-MM-dd");
var builder = new StringBuilder();
var data = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JZTestCell> >(row["TestData"].ToString());
var value = string.Format("[{0}] ", row["SerialNumber"]);
foreach (var d in data)
{
switch (d.Name)
{
case JZTestEnum.DHBJ:
value += "断后标距：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.LDZDL:
value += "拉断最大力：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.PHHZ:
value += "破坏荷载：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.QFL:
value += "屈服力：" + (d.Value ?? "").ToString() + ";";
break;
default:
break;
}
}
if (!string.IsNullOrEmpty(value))
{
builder.Append(value + " ");
}
Sheet.Cells[i, 5].Value = builder.ToString();
Sheet.Rows[i].Tag = new Guid(row["ID"].ToString());
}
ShowLabel(new Guid(result.Rows[0]["ID"].ToString()));
}
private void SetDataSource()
{
Sheet.Rows.Count = 0;
var result = CaiJiHelperClient.GetTestOverTimeByDataID(DataID);
Sheet.Rows.Count = result.Rows.Count;
#region
for (var i = 0; i < result.Rows.Count; i++)
{
var row = result.Rows[i];
Sheet.Cells[i, 0].Value = row["标段名称"];
Sheet.Cells[i, 1].Value = row["单位名称"];
Sheet.Cells[i, 2].Value = row["试验室名称"];
Sheet.Cells[i, 3].Value = row["模板名称"];
Sheet.Cells[i, 4].Value = row["WTBH"];
Sheet.Cells[i, 6].Value = (row["实际试验日期"] == DBNull.Value || row["实际试验日期"] == null) ? "" : ((DateTime)(row["实际试验日期"])).ToString("yyyy-MM-dd");
Sheet.Cells[i, 7].Value = (row["龄期到期日期"] == DBNull.Value || row["龄期到期日期"] == null) ? "" : ((DateTime)(row["龄期到期日期"])).ToString("yyyy-MM-dd");
var builder = new StringBuilder();
var data = Newtonsoft.Json.JsonConvert.DeserializeObject <List <JZTestCell> >(row["TestData"].ToString());
var value = string.Format("[{0}] ", row["SerialNumber"]);
foreach (var d in data)
{
switch (d.Name)
{
case JZTestEnum.DHBJ:
value += "断后标距：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.LDZDL:
value += "拉断最大力：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.PHHZ:
value += "破坏荷载：" + (d.Value ?? "").ToString() + ";";
break;
case JZTestEnum.QFL:
value += "屈服力：" + (d.Value ?? "").ToString() + ";";
break;
default:
break;
}
}
if (!string.IsNullOrEmpty(value))
{
builder.Append(value + " ");
}
Sheet.Cells[i, 5].Value = builder.ToString();
Sheet.Rows[i].Tag = row["ID"];
}
#endregion
if (result.Rows.Count > 0)
{
ShowLabel(new Guid(result.Rows[0]["ID"].ToString()));
//DataTable dt = CaiJiHelperClient.GetTestOverTimeByID(new Guid(result.Rows[0]["ID"].ToString()));
//if (dt != null && dt.Rows.Count > 0)
//{
// tb_reason.Text = (dt.Rows[0]["SGComment"] ?? "").ToString();
// int Status = int.Parse(dt.Rows[0]["Status"].ToString());
// if (Status == 0)
// {
// tb_reason.Enabled = true;
// bt_save.Enabled = true;
// }
// else
// {
// tb_reason.Enabled = false;
// bt_save.Enabled = false;
// }
//}
}
}
