在C#项目中创建一个结构体,并将其作为value,依次放入一个哈希表中。具体内容如下:
struct Eff
{
public double fact;
public double plan;
public string machinetype;
};
sql1 = "select ce_users.machinetype,machineorder,expectedeff from ce_users inner join ex_eff on ce_users.machinetype=ex_eff.machinetype order by ce_users.machinetype asc";
comm1 = new MySqlDataAdapter(sql1, conn);
DataTable h1 = new DataTable();
comm1.Fill(h1);//h中存放sql1查询得到的数据表
Hashtable ht2 = new Hashtable();
foreach (DataRow rr in h1.Rows)//加强的for循环
{
string s1 = rr["machinetype"].ToString();
string s4 = rr["machineorder"].ToString();
string expectedeff = rr["expectedeff"].ToString();
if (ht2.ContainsKey(s4)) continue;
else
{
Eff eff;
eff.fact = 0;
eff.plan = double.Parse(expectedeff);
eff.machinetype = s1;
ht2.Add(s4, eff);
}
}
续上,哈希通过遍历value找到key,内容如下:
struct Eff
{
public double fact;
public double plan;
public string machinetype;
};
Eff value;
double expectedeff = 0;
foreach (string keys in ht2.Keys)
{
value = (Eff)ht2[keys];
if (value.machinetype.Equals(row["机器"].ToString())) { expectedeff = value.plan; break; }
}
double eff;
if (expectedeff == 0) eff = 0.6;
else eff = expectedeff;