void getCnnStr()
{
#if DEBUG
m_db = ConfigMng.CfgRead("zDb") as string;
#else
m_db = ConfigMng.FindTmpl("PTXX_NB.accdb");
#endif
if (m_db != null)
{
var cnnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<zDb>;";
m_cnnStr = cnnStr.Replace("<zDb>", m_db);
}
else
{
OpenDbDlg();
#if DEBUG
ConfigMng.CfgWrite("zDb", m_db);
#endif
}
}
private void button1_Click(object sender, EventArgs e)
{
Dictionary <string, MyUser> userD;
var content = new lOleDbContentProvider();
ConfigMng.CfgRead("zDb");
var zDb = ConfigMng.CfgRead("zDb") as string;
var cnnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<zDb>;";
content.initCnn(cnnStr.Replace("<zDb>", zDb));
var userLst = content.GetAllUsers();
userD = new Dictionary <string, MyUser>();
foreach (MyUser tuser in userLst)
{
userD.Add(tuser.zFb, tuser);
}
var arr = optTxt.Lines;
int s = 0;
for (int i = 0; i < arr.Length; i++)
{
string line = arr[i];
switch (s)
{
case 0:
if (userD.ContainsKey(line))
{
s = 1;
}
else
{
s = -1;
}
break;
}
}
}
