private void LoadListRequest()
{
try
{
if (!System.IO.File.Exists(LogFile))
{
return;
}
ListRequest.Clear();
lib.Class.TextFile tf = new lib.Class.TextFile();
tf.Open(lib.Class.enmOpenMode.Reading, LogFile);
string line = "";
while ((line = tf.ReadLine()) != null)
{
SendRequest s = new SendRequest();
s.Link = line;
SendRequestHeader sh = new SendRequestHeader();
sh.key = tf.ReadLine();
sh.value = tf.ReadLine();
s.Header = new List <SendRequestHeader>();
s.Header.Add(sh);
s.PostData = tf.ReadLine();
s.ContentType = tf.ReadLine();
ListRequest.Add(s);
}
tf.Close();
UpdateCombo();
}
catch { }
}
private void SaveListRequest()
{
if (System.IO.File.Exists(LogFile))
{
System.IO.File.Delete(LogFile);
}
lib.Class.TextFile tf = new lib.Class.TextFile();
tf.Open(lib.Class.enmOpenMode.Writing, LogFile);
foreach (var item in ListRequest)
{
tf.WriteLine(item.Link.Replace(Environment.NewLine, ""));
tf.WriteLine(item.getHeaderKey(0).Replace(Environment.NewLine, ""));
tf.WriteLine(item.getHeaderValue(0).Replace(Environment.NewLine, ""));
tf.WriteLine(item.PostData.Replace(Environment.NewLine, ""));
tf.WriteLine(item.ContentType);
}
tf.Close();
}
public void Execute()
{
lib.Class.TextFile tf = new lib.Class.TextFile();
tf.Open(lib.Class.enmOpenMode.Reading, FileName);
string[] lines = tf.GetLines();
tf.Close();
#region Gera a lista de comandos
List <ItemUpdate> itms = new List <ItemUpdate>();
for (int i = 0; i < lines.Length; i++)
{
try
{
if (string.IsNullOrEmpty(lines[i]))
{
continue;
}
string line = lines[i];
if (DbBase is lib.Entity.MySQL)
{
line = lines[i].ToUpper();
}
if (line.IndexOf("/*[UPDATE]") != -1)
{
int idx_ini = line.IndexOf("/*[UPDATE]") + 10;
int idx_end = line.IndexOf("*/");
itms.Add(new ItemUpdate(cnv.ToInt(line.Substring(idx_ini, idx_end - idx_ini))));
}
else
{
itms[itms.Count - 1].Script += line;
}
}
catch { continue; }
}
#endregion
#region Executa atualização de Scripts
int UpdateNumber = GetDbUpdateNumber();
for (int i = 0; i < itms.Count; i++)
{
if (itms[i].Number > UpdateNumber)
{
try
{
string[] cmds = itms[i].GetCommands();
for (int c = 0; c < cmds.Length; c++)
{
if (string.IsNullOrEmpty(cmds[c]))
{
continue;
}
DbBase.DbExecute(cmds[c]);
}
}
catch (Exception ex)
{
string mensagem = ex.Message;
mensagem = mensagem + "";
}
DbBase.DbExecute("UPDATE TB_UPDATE SET UPDATE_NUMBER = " + itms[i].Number);
}
}
#endregion
}
