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(); }