public static string HEXStrNearTodayDecryptStringTripleDES(string strToDecrypt)
{
if (strToDecrypt == string.Empty)
{
return(string.Empty);
}
return(NearTodayDecryptStringTripleDES(TEXStrUtl.DecodeHexStrToStr(strToDecrypt)));
}
public static string HEXStrNearTodayEncryptStringTripleDES(string strToEncrypt)
{
if (strToEncrypt == string.Empty)
{
return(string.Empty);
}
return(TEXStrUtl.EncodeToHexStr(NearTodayEncryptStringTripleDES(strToEncrypt)));
}
//private System.Data.SqlClient.SqlCommand SQLCmd_SelectURLsToWordProc;
//private System.Data.SqlClient.SqlCommand SQLCmd_GetURLData;
private void WordProcSingleURL(int intURLID)
{
using (SqlCommand sqcm_UrlHasProcessedWords = SQLConSW.CreateCommand())
{
//sqcm_UrlHasProcessedWords.Transaction = myWordInsTransaction;
sqcm_UrlHasProcessedWords.CommandText = "exec dbo.sp_SW_UrlHasProcessedWords " + intURLID.ToString();
sqcm_UrlHasProcessedWords.ExecuteNonQuery();
}
string strURLData = string.Empty;
//const string CLocalTransName = "Trans_WordProcSingleURL";
SqlDataAdapter daGETUrlData = new SqlDataAdapter("EXEC dbo.sp_SW_GetURLData " + intURLID.ToString(), SQLConSW.ConnectionString);
DataSet dsGetURLData = new DataSet();
daGETUrlData.Fill(dsGetURLData);
strURLData = dsGetURLData.Tables[0].Rows[0][0].ToString().Trim();
strURLData = TEXStrUtl.StripTagsFromHTML(strURLData).Trim();
if (strURLData == string.Empty)
{
return;
}
if (TimeAllowsToReport())
{
Report(string.Format("Δεδομένα του URL [{0}:\r\n [{1}]", intURLID, strURLData));
}
SqlCommand sqcm_ConnectWord = SQLConSW.CreateCommand();
sqcm_ConnectWord.CommandType = CommandType.StoredProcedure;
sqcm_ConnectWord.CommandText = "dbo.sp_SW_ConnectWord";
System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(sqcm_ConnectWord);
//using (SqlTransaction myWordInsTransaction = SQLConSW.BeginTransaction(IsolationLevel.ReadCommitted,CLocalTransName ))
//{
try
{
DataSet dsSplitString = TTextProcess.SplitString(strURLData, TTextProcess.enmsf_StrFilter.sf_CapitalizeSmart | TTextProcess.enmsf_StrFilter.sf_DenyStopWords, TSWDB_Decl.CMAX_WORD_LENGTH);
EXException.CheckEXError(dsSplitString != null, "EX-{A3270330-505B-4eb5-98E2-313AA1879AE6}");
EXException.CheckEXError(dsSplitString.Tables[0].Rows.Count > 0, "Δεν βρέθηκαν λέξεις. EX-{E06D3CB0-B22F-49e2-87E9-D373704AB80A}");
using (SqlCommand sqcm_UnconnectURLFromUrlLinkWord = SQLConSW.CreateCommand())
{
//sqcm_UnconnectURLFromUrlLinkWord.Transaction = myWordInsTransaction;
sqcm_UnconnectURLFromUrlLinkWord.CommandText = "exec dbo.sp_SW_UnconnectURLFromUrlLinkWord " + intURLID.ToString();
sqcm_UnconnectURLFromUrlLinkWord.ExecuteNonQuery();
}
//sqcm_ConnectWord.Transaction = myWordInsTransaction;
System.Collections.IEnumerator enumerator = dsSplitString.Tables[0].Rows.GetEnumerator();
while (enumerator.MoveNext())
{
if (CancelProcess)
{
throw new EXUserBreak();
}
sqcm_ConnectWord.Parameters["@intURLID"].Value = intURLID;
sqcm_ConnectWord.Parameters["@strWord"].Value = ((enumerator.Current) as DataRow)[TTextProcess.CTPSplitField_Word].ToString();
sqcm_ConnectWord.Parameters["@intAppearCount"].Value = Convert.ToInt32(((enumerator.Current) as DataRow)[TTextProcess.CTPSplitField_CountWord]);
if (TimeAllowsToReport())
{
Report(string.Format("Σύνδεση του URL:[{0}] με την λέξη:[{1}] και με συχνότητα εμφάνισης:[{2}].", intURLID,
((enumerator.Current) as DataRow)[TTextProcess.CTPSplitField_Word].ToString(),
Convert.ToInt32(((enumerator.Current) as DataRow)[TTextProcess.CTPSplitField_CountWord])
));
}
sqcm_ConnectWord.ExecuteNonQuery();
}
//myWordInsTransaction.Commit();
}
catch (Exception exc)
{
//myWordInsTransaction.Rollback(CLocalTransName);
EXException.ThrowEXException("Πρόβλημα κατά την αποκωδικοπόιηση του URL: " + intURLID.ToString(), exc);
}
//}
}
public static string HEXStrDecryptHexStringTripleDES(string strToDecrypt, string theKey)
{
return(DecryptStringTripleDES(TEXStrUtl.DecodeHexStrToStr(strToDecrypt), theKey));
}
public static string HEXStrEncryptStringTripleDES(string strToEncrypt, string theKey)
{
return(TEXStrUtl.EncodeToHexStr(EncryptStringTripleDES(strToEncrypt, theKey)));
}
public TStopWords()
{
slStopWordsEnglish = TEXStrUtl.InsertFromStrArray(CARSTR_STOPWORDS_ENGLISH, false);
slStopWordsGreek = TEXStrUtl.InsertFromStrArray(CARSTR_STOPWORDS_GREEK, false);
}
