public override bool UpdateDatabaseSequence(IDbConnection connection, IDbTransaction trans, ExBackgroundWorker worker)
{
synch_worker = worker;
String sql = SanitaUtility.GetResourceFileStreamText("update_sequence");
if (!String.IsNullOrEmpty(sql))
{
DataTable mDataTable = myBaseDao.DoGetDataTable(connection, trans, sql);
if (mDataTable != null)
{
//Synch database
if (synch_worker != null)
{
synch_worker.ReportProgress(0, mDataTable.Rows.Count);
}
int index_sql = 0;
foreach (DataRow row in mDataTable.Rows)
{
if (row["sql_column"] != null)
{
String sql_update = row["sql_column"].ToString();
myBaseDao.DoUpdate(connection, trans, sql_update);
}
index_sql++;
synch_worker.ReportProgress(index_sql, mDataTable.Rows.Count);
}
}
}
return(true);
}
/// <summary>
/// Create a TextFilter that finds the given string using the given comparison
/// </summary>
/// <param name="olv"></param>
/// <param name="text"></param>
/// <param name="comparison"></param>
public TextMatchFilter(ObjectListView olv, string text, StringComparison comparison)
{
this.ListView = olv;
//++Added by KhoiVV
isUseNoneVietNamese = olv.isUseNoneVietNamese;
//if (olv.isUseNoneVietNamese)
//{
// this.ContainsStrings = new string[] { SanitaUtility.RemoveSign4VN(text) };
//}
//else
//{
// this.ContainsStrings = new string[] { text };
//}
if (olv.isUseNoneVietNamese)
{
this.ContainsStrings = SanitaUtility.RemoveSign4VN(text).Split(';');
}
else
{
this.ContainsStrings = text.Split(';');
}
//--Added by KhoiVV
this.StringComparison = comparison;
}
public static string Escape(byte[] s)
{
if (GetDatabaseType() == DATABASE_TYPE.POSTGRESQL)
{
return(SanitaUtility.ConvertBinary2HexString_POSTGRES(s));
}
else if (GetDatabaseType() == DATABASE_TYPE.MSSQL)
{
return(SanitaUtility.ConvertBinary2HexString_MYSQL(s));
}
else if (GetDatabaseType() == DATABASE_TYPE.SQLITE)
{
return(SanitaUtility.ConvertBinary2HexString_SQLITE(s));
}
return("");
}
/// <summary>
/// Do the actual work of filtering
/// </summary>
/// <param name="modelObject"></param>
/// <returns></returns>
public override bool Filter(object modelObject)
{
if (this.ListView == null || !this.HasComponents)
{
return(true);
}
//++Update by KhoiVV
foreach (TextMatchingStrategy filter in this.MatchingStrategies)
{
bool ret = false;
foreach (OLVColumn column in this.IterateColumns())
{
if (column.IsVisible && column.Searchable)
{
string cellText = column.GetStringValue(modelObject);
if (isUseNoneVietNamese)
{
cellText = SanitaUtility.RemoveSign4VN(cellText);
}
if (String.IsNullOrEmpty(filter.Text) || filter.MatchesText(cellText))
{
ret = true;
}
}
}
if (ret == false)
{
return(false);
}
}
return(true);
//--Update by KhoiVV
}
public static String RemoveVietNamSign(this String data_control)
{
return(SanitaUtility.RemoveSign4VN(data_control));
}
public override CompareResult Compare(string fragmentText)
{
if (Parent.SearchTinhHuyenXa)
{
if (fragmentText.Length == 2 || fragmentText.Length == 3)
{
if (lowercaseKey.ToUpper().StartsWith(fragmentText + "KX", StringComparison.InvariantCultureIgnoreCase))
{
return(CompareResult.VisibleAndSelected);
}
}
else
{
if (lowercaseKey.ToUpper().StartsWith(fragmentText, StringComparison.InvariantCultureIgnoreCase))
{
return(CompareResult.VisibleAndSelected);
}
}
}
else
{
if (ignoreCase)
{
#if true
//if (!String.IsNullOrEmpty(fragmentText.Trim()))
//{
// String[] list_data = fragmentText.TrimSpace().Trim().Split(' ');
// foreach (String data in list_data)
// {
// if (!String.IsNullOrEmpty(data))
// {
// if (!SanitaUtility.RemoveSign4VN(lowercaseText).Contains(SanitaUtility.RemoveSign4VN(data.ToLower())))
// {
// return CompareResult.Hidden;
// }
// }
// }
// return CompareResult.Visible;
//}
if (lowercaseText.ToLower() == fragmentText.ToLower())
{
return(CompareResult.VisibleAndSelected);
}
if (lowercaseText != null && SanitaUtility.RemoveSign4VN(lowercaseText).Contains(SanitaUtility.RemoveSign4VN(fragmentText.ToLower())))
{
return(CompareResult.Visible);
}
if (lowercaseKey != null && lowercaseKey.Contains(fragmentText.ToLower()))
{
return(CompareResult.Visible);
}
if (lowercaseData != null && lowercaseData.Contains(fragmentText.ToLower()))
{
return(CompareResult.Visible);
}
#else
if (lowercaseText.Contains(fragmentText.ToLower()))
{
return(CompareResult.Visible);
}
#endif
}
else
{
if (!String.IsNullOrEmpty(Text) && Text.Contains(fragmentText))
{
return(CompareResult.Visible);
}
if (!String.IsNullOrEmpty(Key) && Key.Contains(fragmentText))
{
return(CompareResult.Visible);
}
if (!String.IsNullOrEmpty(Data) && Data.Contains(fragmentText))
{
return(CompareResult.Visible);
}
}
}
return(CompareResult.Hidden);
}
