// 从数据库中获取所有的MAC，并将MAC在ListView中显示
private void refreshListView()
{
// 清空ListView
macLV.Items.Clear();
MACSQLite.queryMacs("macs");
List <DBIdMAC> macsDB = MACSQLite.macsDB;
// 添加表格内容
int count = MACSQLite.queryCount("macs");
for (int i = 0; i < count; i++)
{
ListViewItem item = new ListViewItem();
item.SubItems.Clear();
item.SubItems[0].Text = macsDB[i].getId().ToString();
item.SubItems.Add(macsDB[i].getMac());
macLV.Items.Add(item);
}
// 选中listview第一行，这里会造成自动调用listview的SelectedIndexChanged事件函数；
// 于是设置当前MAC、QRCode这事情都在macLV_SelectedIndexChanged处理了。
// initCurrentMACLable()也就没啥用了。
if (macLV.Items.Count > 0)
{
macLV.Items[0].Selected = true;
macLV.Select();
}
// initCurrentMACLable();
}
private void addMACClick(object sender, EventArgs e)
{
// 校验MAC地址
string s = @"^([0-9a-fA-F]{2})(([/\s:-][0-9a-fA-F]{2}){5})$";
Regex r = new Regex(s, RegexOptions.IgnoreCase);
Match mB = r.Match(macB.Text.Trim());
Match mE = r.Match(macE.Text.Trim());
if (!mB.Success || !mE.Success)
{
MessageBox.Show("Please Check Your MAC Address.");
return;
}
MACSQLite.generateMacs(macB.Text, macE.Text);
// MACSQLite.printMacs();
MACSQLite.createTable("macs");
MACSQLite.addMacs("macs");
// MACSQLite.insertMac("macs", "00:11:22:33:44:55");
// MACSQLite.queryMac("macs");
// MACSQLite.deleteMac("macs", "00:11:22:33:44:55");
// MACSQLite.updateMac("macs", 18, "11:22:33:44:55:66");
refreshListView();
}
private void deleteAllMac_Click(object sender, EventArgs e)
{
if (MACSQLite.queryCount("macs") > 0)
{
// 删除所：有MAC，并刷新listview
MACSQLite.deleteAllMac("macs");
refreshListView();
}
else
{
currentMAC.Text = "00:00:00:00:00:00";
}
}
// 从数据库中获取第一行中的MAC
private void initCurrentMACLable()
{
// 这里可以从DB中获取第一行，也可通过直接获取ListView中的第一行来表示.
String mac = MACSQLite.fetchHeadMac("macs");
if (mac != null && mac.Length != 0)
{
currentMAC.Text = mac;
}
else
{
currentMAC.Text = "00:00:00:00:00:00";
}
}
private void deleteDB(object sender, EventArgs e)
{
Console.WriteLine(currentMAC.Text);
if (MACSQLite.queryCount("macs") > 0)
{
// 删除MAC，并刷新listview
MACSQLite.deleteMac("macs", currentMAC.Text);
refreshListView();
}
else
{
currentMAC.Text = "00:00:00:00:00:00";
}
}
// 初始化ListView
private void initMACListView()
{
macLV.GridLines = true; // 表格是否显示网格线
macLV.FullRowSelect = true; // 是否选中整行
macLV.View = View.Details; // 设置显示方式
macLV.Scrollable = true; // 是否自动显示滚动条
macLV.MultiSelect = false; // 是否可以选择多行
// 添加表头（列）
macLV.Columns.Add("ID", -2, HorizontalAlignment.Center);
macLV.Columns.Add("MAC", -2, HorizontalAlignment.Center);
MACSQLite.createTable("macs");
refreshListView();
}
private void adbCmdClick(object sender, EventArgs e)
{
EepromDataBinFile();
if (!ADBCmd.detectDevice())
{
return;
}
ADBCmd.push("eeprom.bin", "/data/local", adbcmdShow);
ADBCmd.execute("mount -o remount /dev/block/mtdblock2 /system", adbcmdShow);
ADBCmd.execute("dd if=/data/local/eeprom.bin of=/sys/bus/i2c/devices/3-0050/eeprom", adbcmdShow);
// 确认数据是否正确写入到EEPROM中
ADBCmd.execute("dd if=/sys/bus/i2c/devices/3-0050/eeprom of=/data/local/eeprom_bak.bin", adbcmdShow);
ADBCmd.pull("/data/local/eeprom_bak.bin", ".", adbcmdShow);
if (Eeprom.readDataWithCompare("eeprom_bak.bin"))
// if (Eeprom.readDataWithCompare("eeprom.bin"))
{
MessageBox.Show("Success.");
Eeprom.parseFileData();
BurningStatue.BackColor = Color.Green;
// 删除操作成功的MAC
MACSQLite.deleteMac("macs", currentMAC.Text);
refreshListView();
}
else
{
MessageBox.Show("False.");
BurningStatue.BackColor = Color.Red;
}
}
private async void httpAccess()
{
dealProgressValue(0);
showMessageInfo("Start Http Request... \n");
try
{
var handler = new HttpClientHandler()
{
AutomaticDecompression = DecompressionMethods.None
};
using (var client = new HttpClient(handler))
{
dealProgressValue(10);
showMessageInfo("Send Data To Http Server... \n");
var httpResponseMessage = await client.GetAsync("http://" + IPAddress.Text + ":" + IPPort.Text + "/common/eeprom.php?version=3&mac=" + currentMAC.Text.Replace(":", ""));
if (httpResponseMessage.StatusCode == HttpStatusCode.OK)
{
var ret_json = await httpResponseMessage.Content.ReadAsStringAsync();
showMessageInfo("Recv Json Data From Http Server... \n");
showMessageInfo(ret_json + "\n");
dealProgressValue(50);
MethodInvoker action = delegate {
dynamic json = JValue.Parse(ret_json) as dynamic;
if (json["status"].ToString() == "ok")
{
Console.WriteLine(currentMAC.Text);
if (MACSQLite.queryCount("macs") > 0)
{
// 删除MAC，并刷新listview
MACSQLite.deleteMac("macs", currentMAC.Text);
refreshListView();
}
else
{
currentMAC.Text = "00:00:00:00:00:00";
}
showMessageInfo("Has Delete MAC Database.\r\n");
HttpWrite.BackColor = Color.Green;
dealProgressValue(90);
}
else
{
showMessageInfo("Delete MAC Error.\r\n");
HttpWrite.BackColor = Color.Red;
dealProgressValue(0);
}
dealProgressValue(100);
HttpWrite.Enabled = true;
};
ShowMessage.BeginInvoke(action);
}
}
}
catch (Exception ex)
{
showMessageInfo(ex.ToString());
MethodInvoker action = delegate {
HttpWrite.BackColor = Color.Red;
HttpWrite.Enabled = true;
};
ShowMessage.BeginInvoke(action);
dealProgressValue(0);
}
}
