private void btnRefresh_Click(object sender, EventArgs e)
{
if (ControlService.SignCombo.Current.Controller.Connection.State != System.Communication.ConnectionState.Opened)
{
MsgBox.Error(Resources.Resource.GetString(Resources.Resource.Strings.SendSendToSignLoginFirst));
return;
}
Cursor = Cursors.WaitCursor;
LogViewGet log = new LogViewGet();
log.Mode = 0;
log.Type = 0;
string sql = " 1=1";
if (!string.IsNullOrEmpty(cmbVersion.Text))
{
sql = sql + " and Version = " + cmbVersion.Text;
}
if (!string.IsNullOrEmpty(txtLevel.Text))
{
sql += " and Level like '%" + txtLevel.Text + "%'";
}
if (table.Rows.Count > 0)
{
//table = convert2Table<LogInfo>(list);
DataTable t = new DataTable("table");
DataRow[] rows = table.Select(sql);
t.Columns.Add("Version");
t.Columns.Add("Date");
t.Columns.Add("Level");
t.Columns.Add("Content");
for (int i = 0; i < rows.Length; i++)
{
t.Rows.Add(rows[i].ItemArray);
}
//DataView view = table.Select(sql).
this.gridControl1.DataSource = t;// table.Select(sql);
return;
}
log.DateTime = "20090810090112";
log.SQL = "";
//Send set dimming command
sign.Controller.SendAsync(
Commands.GetLog,
p =>
{
Cursor = Cursors.Default;
if (p.IsSuccessed)
{
JsonSerializer serializer = new JsonSerializer();
list = serializer.ConvertToType <List <LogInfo> >(p.Packet.Content);
//= p.Packet.Content.GetProperty<List<LogInfo>>("List");
if (list != null && list.Count > 0)
{
table = convert2Table <LogInfo>(list);
DataTable t = new DataTable();
DataRow[] rows = table.Select(sql);
t.Columns.Add("Version");
t.Columns.Add("Date");
t.Columns.Add("Level");
t.Columns.Add("Content");
for (int i = 0; i < rows.Length; i++)
{
t.Rows.Add(rows[i].ItemArray);
}
//DataView view = table.Select(sql).
this.gridControl1.DataSource = t; // table.Select(sql);
}
//int totalSize = p.Packet.Content.GetProperty<int>("TotalSize");
}
else
{
MsgBox.Error(Resources.Resource.GetString(Resources.Resource.Strings.SetDimmingFailed)); //"Dimming was not changed.Please try again.");
}
},
log);
}
public override void Perform()
{
if (sign.Controller.Connection.State != System.Communication.ConnectionState.Opened)
{
return;
}
LogViewGet logview = new LogViewGet();
logview.Mode = 0;
logview.Type = 0;
DataTable tempTable = LogService.GetLogs("select date from log order by date desc");
bool isDownLoad = false;
logview.DateTime = "10020101120000";
if (tempTable.Rows.Count > 0)
{
logview.DateTime = tempTable.Rows[0][0].ToString();
}
else
{
isDownLoad = true;
logview.Mode = 2;
}
logview.SQL = "";
isDownLoad = true;
sign.Controller.SendAsync(
Commands.GetLog,
p =>
{
//Cursor = Cursors.Default;
if (p.IsSuccessed)
{
string toFilePath = Constance.AppPath + "UFEQueryResult.gz"; // Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\ProWrite\\Library\\";
if (!isDownLoad)
{
if (p.Packet.Download.ToString() == "0")
{
JsonSerializer serializer = new JsonSerializer();
list = serializer.ConvertToType <List <LogInfo> >(p.Packet.Content);
if (list != null && list.Count > 0)
{
DataTable table = convert2Table <LogInfo>(list);
LogService.SaveLogs(table);
}
}
else
{
string fromFilePath = "/mnt/sdcard/.ufe/data/logs/UFEQueryResult.gz";
sign.Controller.Connection.FtpManager.DownLoad(fromFilePath, toFilePath);
FileRar.UnCompressRAR("UFEQueryResult.gz");
LogService.ImportTempData();
}
}
else
{
string fromFilePath = "/mnt/sdcard/.ufe/data/logs/sqlite.gz";
toFilePath = Constance.AppPath + "sqlite.gz";
sign.Controller.Connection.FtpManager.DownLoad(fromFilePath, toFilePath);
FileRar.UnCompressRAR("sqlite.gz");
LogService.ImportTempData();
}
}
else
{
}
},
logview);
}
