private string CreateWherePart(BCHControls.UCAddToListBox atl, string field) { string wherePart = string.Empty; if (atl.SelectedCount < 1) { return(wherePart); } List <string> list = atl.GetSelectedItems(); if (atl.SelectedCount == 1 && list[0] == "None") { return(wherePart); } wherePart = MP3DBManager.BuildSearchWhereClausePart(field, list, true, rbAnd.Checked, cbxUseLike.Checked); return(wherePart); }
private string CreateWherePart(BCHControls.UCFromTo atl, string field) { string wherePart = string.Empty; List <string> list = atl.GetStrList(BCHControls.UCFromToEnum.To); if (!list.Any()) { return(wherePart); } List <string> listFixed = new List <string>(); //make sure to escape sinqle quotes for query foreach (var item in list) { listFixed.Add(item.Replace("'", "''")); } wherePart = MP3DBManager.BuildSearchWhereClausePart(field, listFixed, true, rbAnd.Checked, cbxUseLike.Checked); return(wherePart); }