private static Set.OrdSysName GetOrdSysNameFromFilepath(string folder, string fileName)
{
Set.OrdSysName osn = Set.OrdSysName.Null;
foreach (var os in Set.OrdSysList)
{
if (folder.ToUpper() == os.WatchedFolder.ToUpper())
{
osn = os.Name;
break;
}
}
return(osn);
}
public static Locations GetLocByKeyWord(Set.OrdSysName ordSysName, string text)
{
var ind = (int)ordSysName - 1; //
foreach (PickupKeyword kw in Set.OrdSysList[ind].PuKeyWordList)
{
if (text.ToUpper().Contains(kw.Keyword.ToUpper()))
{
foreach (Locations loc in Set.LocList)
{
if (loc.Id == kw.LocId)
{
return(loc);
}
}
}
}
return(null);
}
public static List <PickupKeyword> GetKeywordListFromServerByOrdSys(Set.OrdSysName ordSysName)
{
string sql = "select * FROM pickupkeywords WHERE puk_OrdSysName = '" + ordSysName.ToString() + "'";
List <PickupKeyword> list = new List <PickupKeyword>();
using (var conn = new MySqlConnection(Set.ConnString))
using (var cmd = new MySqlCommand(sql, conn))
{
conn.Open();
using (MySqlDataReader rd = cmd.ExecuteReader())
{
while (rd.Read())
{
var puk = new PickupKeyword();
puk.Id = Convert.ToUInt32(rd[0]);
puk.Keyword = Convert.ToString(rd[1]);
puk.LocId = Convert.ToUInt32(rd[2]);
list.Add(puk);
}
}
}
return(list);
}
