private void button4_Click(object sender, EventArgs e)
{
listView1.Columns.Clear();
listView1.Items.Clear();
listView1.View = View.Details;
listView1.FullRowSelect = true;
listView1.MultiSelect = true;
foreach (string s in qsofields)
{
if (s.Length > 0)
{
listView1.Columns.Add(s);
}
}
HRDInterface.callsign = textBox2.Text;
HRDInterface.u = textBox3.Text;
HRDInterface.p = textBox4.Text;
HRDInterface.s = textBox5.Text;
System.Collections.ArrayList q = HRDInterface.test();
for (int x = 0; x < q.Count; x++)
{
try
{
QSOData d = (QSOData)q[x];
ListViewItem li = new ListViewItem();
li.Text = d.callsign;
li.SubItems.Add(d.name);
li.SubItems.Add(d.date);
li.SubItems.Add(d.date);
li.SubItems.Add(d.sent);
li.SubItems.Add(d.rcvd);
li.SubItems.Add(d.mode);
li.SubItems.Add(d.qth);
li.SubItems.Add(d.band);
li.SubItems.Add(d.freq);
li.SubItems.Add(""); //skcc
li.SubItems.Add(""); //TXPWR
li.SubItems.Add(d.comment); //TXPWR
if (d.QSL_SENT.Equals("Y"))
{
li.BackColor = Color.OrangeRed;
}
listView1.Items.Add(li);
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
}
}
}
public static System.Collections.ArrayList test()
{
System.Collections.ArrayList qsos = new System.Collections.ArrayList();
try
{
connstring = connstring.Replace("%U%", u);
connstring = connstring.Replace("%P%", p);
connstring = connstring.Replace("%S%", s);
conn = new MySqlConnection(connstring);
//conn.ConnectionTimeout = 360;
conn.Open();
string query = sql_getbycall;
if (callsign.Trim().Length > 0)
{
query = query + " where COL_CALL = '" + callsign + "'";
}
else
{
//query = query + " LIMIT 5000";
}
MySqlDataAdapter da = new MySqlDataAdapter(query, conn);
DataSet ds = new DataSet();
da.Fill(ds, "HRD");
DataTable dt = ds.Tables["HRD"];
foreach (DataRow row in dt.Rows)
{
QSOData q = new QSOData();
q.callsign = row["COL_CALL"].ToString();
q.freq = row["COL_FREQ"].ToString();
q.mode = row["COL_MODE"].ToString();
q.rcvd = row["COL_RST_RCVD"].ToString();
q.sent = row["COL_RST_SENT"].ToString();
q.comment = row["COL_COMMENT"].ToString();
q.date = row["COL_TIME_ON"].ToString();
q.QSL_SENT = row["COL_QSL_SENT"].ToString();
q.name = row["COL_NAME"].ToString();
q.qth = row["COL_QTH"].ToString();
q.power = row["COL_TX_PWR"].ToString();
q.band = row["COL_BAND"].ToString();
//foreach (DataColumn col in dt.Columns)
//{
// Console.Write(row[col] + "\t");
//}
qsos.Add(q);
//Console.Write("\n");
}
}
catch (Exception e)
{
Console.WriteLine("Error: {0}", e.ToString());
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(qsos);
}
