public static void ReadTestType(ComboBox cmb)
{
//cmb.Items.Clear();
BLL.Standard bllS = new HR_Test.BLL.Standard();
DataSet ds = bllS.GetAllListDistinctTestType();
cmb.DataSource = ds.Tables[0];
cmb.DisplayMember = "testType";
cmb.ValueMember = "testType";
}
//读取指定日期的所有试验
public static List <TreeNode> ReadSample(DateTime dtp)
{
//从 standard 数据库中读取，此处如果有重复的表则要不重复读取
BLL.Standard bllS = new HR_Test.BLL.Standard();
DataSet ds = bllS.GetAllListDistinctResultTableName(); //bllS.GetAllList();
int count = ds.Tables[0].Rows.Count;
List <TreeNode> ltn = new List <TreeNode>();
if (ds != null)
{
ltn.Clear();
for (int i = 0; i < count; i++)
{
string resultTbName = ds.Tables[0].Rows[i]["resultTableName"].ToString();
switch (resultTbName)
{
case "tb_TestSample":
ltn.AddRange(ReadGBT228Samples(dtp));
break;
case "tb_Compress":
ltn.AddRange(ReadGBT7314Samples(dtp));
break;
case "tb_Bend":
ltn.AddRange(ReadYBT5349Samples(dtp));
break;
case "tb_GBT282892012_Tensile":
ltn.AddRange(ReadGBT28289TensileSamples(dtp));
break;
case "tb_GBT282892012_Shear":
ltn.AddRange(ReadGBT28289ShearSamples(dtp));
break;
case "tb_GBT282892012_Twist":
ltn.AddRange(ReadGBT28289TwistSamples(dtp));
break;
case "tb_GBT236152009_TensileHeng":
ltn.AddRange(ReadGBT23615HengSamples(dtp));
break;
case "tb_GBT236152009_TensileZong":
ltn.AddRange(ReadGBT23615ZongSamples(dtp));
break;
case "tb_GBT3354_Samples":
ltn.AddRange(ReadGBT3354Samples(dtp));
break;
default:
break;
}
}
}
if (ltn != null)
{
return(ltn);
//foreach (TreeNode t in ltn)
//{
// tv.Nodes.Add(t);
//}
}
else
{
return(null);
}
//if (tv.Nodes.Count == 0)
// tv.Nodes.Add("无");
//tv.ExpandAll();
}
