private void ReplaceDBAgrupado(string tabelaAlterar, string campoAlterar, string schema = "neo")
{
try
{
YS.Dados.PostgreSQL.Data data = new YS.Dados.PostgreSQL.Data();
data.Sql = $@"SELECT MAX({campoAlterar}) AS {campoAlterar}
FROM {schema}.{tabelaAlterar}
WHERE {campoAlterar} IS NOT NULL
AND {campoAlterar} NOT LIKE '%[$%'
GROUP BY {campoAlterar}";
DataTable dt = data.GetDataTable();
foreach (DataRow dr in dt.Rows)
{
var textoOriginal = dr[campoAlterar].ToString();
var Chave = $"[${Normalize(textoOriginal)}$]";
if (Chave == "[$$]")
{
continue;
}
try
{
data.Sql = @"INSERT INTO yoursales.globalizacao (
glob_cultura,
glob_texto,
glob_chave
) VALUES (
@glob_cultura,
@glob_texto,
@glob_chave)";
data.AddParameter("@glob_cultura", Culture);
data.AddParameter("@glob_texto", textoOriginal);
data.AddParameter("@glob_chave", Chave);
data.ExecuteQuery();
}
catch { }
data.Sql = $@"UPDATE {schema}.{tabelaAlterar}
SET {campoAlterar}=@chave
WHERE {campoAlterar}=@id
AND {campoAlterar} NOT LIKE '%[$%'";
data.AddParameter("@chave", Chave);
data.AddParameter("@id", dr[campoAlterar]);
data.ExecuteQuery();
}
}
catch (Exception er)
{
Response.Write(er);
Response.Write("error");
}
}
private void EncontraArquivos(FileSystemInfo[] f)
{
if (f != null)
{
foreach (FileSystemInfo obj in f)
{
if (obj is DirectoryInfo)
{
DirectoryInfo dinfo = (DirectoryInfo)obj;
EncontraArquivos(dinfo.GetFileSystemInfos());
}
else if (obj is FileInfo)
{
try
{
Thread.Sleep(10);
string[] lines = System.IO.File.ReadAllLines(obj.FullName);
int nlinha = 0;
foreach (var line in lines)
{
nlinha++;
string patternForce = "<ccc>.*?<ccc>";
Regex regexForce = new Regex(patternForce, RegexOptions.None);
MatchCollection matches = regexForce.Matches(line);
foreach (Match match in matches)
{
if (match.Value.Contains("[$"))
{
continue;
}
if (match.Value.Length == 0)
{
continue;
}
string texto = match.Value.Replace("<ccc>", "");
texto = texto.Replace("<ccc>", "");
if (texto.Length == 0)
{
continue;
}
var Chave = $"[${Normalize(texto)}$]";
try
{
var linhas = File.ReadAllLines(obj.FullName);
linhas[nlinha - 1] = linhas[nlinha - 1].Replace(match.Value, Chave);
Response.Write(texto + " <br>");
File.WriteAllLines(obj.FullName, linhas, UnicodeEncoding.GetEncoding(65001));
YS.Dados.PostgreSQL.Data data = new YS.Dados.PostgreSQL.Data();
data.Sql = @"INSERT INTO yoursales.globalizacao (
glob_cultura,
glob_texto,
glob_chave
) VALUES (
@glob_cultura,
@glob_texto,
@glob_chave)";
data.AddParameter("@glob_cultura", Culture);
data.AddParameter("@glob_texto", texto);
data.AddParameter("@glob_chave", Chave);
data.ExecuteQuery();
Response.Write("Success <br>");
}
catch (Exception er)
{
Response.Write("Error <br>");
}
}
}
}
catch (Exception er)
{
}
}
}
}
}