private List <KeyValuePair <string, string> > built() // 输出 地址 时间
{
List <KeyValuePair <string, string> > list = new List <KeyValuePair <string, string> >();
LingTaskQueuer ling = lingTaskQueue.getLingTaskQueuer();
for (int i = 0, j = ling.Size(); i < j; i++)
{
KeyValuePair <DateTime, string> at = ling.At(i);
MysqlContentTool.Ins.ConnStr = "server=127.0.0.1;port=3306;user=root;password=1111111111a; database=uisrnns;";
string sql = @"select Location from cnt_bell where RouterID=(select RouterID from cnt_router where IP=@ip)";
List <MySqlParameter> Paramter = new List <MySqlParameter>();
Paramter.Add(new MySqlParameter("@ip", at.Value));
DataSet dt = MysqlContentTool.Ins.ExecuteDataSet(sql, Paramter.ToArray());
string msg = (dt.Tables[0].Rows[0])[dt.Tables[0].Columns[0]].ToString();
list.Add(new KeyValuePair <string, string>(msg, at.Key.ToString()));
}
return(list);
}
private void skinButton2_Click(object sender, EventArgs e)
{
if (redel == true)
{
LingTaskQueuer ling = lingTaskQueue.getLingTaskQueuer();
///
if (tp.Count == 0)
{
ling.delindex(int.Parse(skinTextBox1.Text) - 1);
}
else
{
string s1 = skinDataGridView1.Rows[int.Parse(skinTextBox1.Text) - 1].Cells[0].Value.ToString();
string s2 = skinDataGridView1.Rows[int.Parse(skinTextBox1.Text) - 1].Cells[1].Value.ToString();
List <KeyValuePair <string, string> > b = built();
int index = b.IndexOf(new KeyValuePair <string, string>(s1, s2));
ling.delindex(index);
}
lingTaskQueue.setLingTaskQueuer(ling);
}
else
{
lingTaskQueue.stop();
lingTaskQueue.getLingTaskQueuer().delall();
List <KeyValuePair <DateTime, string> > queues = new List <KeyValuePair <DateTime, string> >();
for (int i = 0, j = controlDataGridView.getRownum(); i < j; ++i)
{
queues.Add(new KeyValuePair <DateTime, string>(Convert.ToDateTime(this.skinDataGridView1.Rows[i].Cells[1].Value.ToString()), this.skinDataGridView1.Rows[i].Cells[2].Value.ToString()));
}
lingTaskQueue.setLingQueuer(queues);
lingTaskQueue.start();
}
skinButton1_Click(sender, e);
}
public void setLingTaskQueuer(LingTaskQueuer lingTaskQueuer)
{
this.ling = lingTaskQueuer;
}
