private void prepareLine(string line)
{
line = line.Trim();
if (line == "")
{
return;
}
// парсинг одной строки справочника
string[] s;
if (line.Contains(':'))
{
s = line.Split(':');
// есть соответствие, разберем
Gorod.Add(s[0].Trim());
BaseRaw.Add(s[1].Trim()); // список вариантов через запятую
cities[s[0].Trim()] = new List <string>(s[1].Split(','));
}
else
{
// соответствия нет, поэтому просто берем название города
Gorod.Add(line);
BaseRaw.Add(line);
List <string> dd = new List <string>();
dd.Add(line);
cities[line] = dd;
}
}
public string GetGorodSubLinq()
{
string Sub;
string GorodCommandText = "select [sub_inner_tid] from [gorod].[dbo].payment where tid = {0}";
using (Gorod db = new Gorod(Settings.GorodConnectionString))
{
IEnumerable <string> Payments = db.ExecuteQuery <string>(GorodCommandText, Tid);
Sub = Payments.First <string>();
}
return(Sub);
}
/// <summary>
/// Получает статус платежа из ГОРОДа, используя Linq
/// </summary>
/// <returns></returns>
public byte GetGorodStateLinq()
{
byte GorodState;
string GorodCommandText = "select [state] from [gorod].[dbo].payment where tid = {0}";
using (Gorod db = new Gorod(Settings.GorodConnectionString))
{
IEnumerable <Payment> Payments = db.ExecuteQuery <Payment>(GorodCommandText, Tid);
GorodState = Payments.First <Payment>().State;
}
return(GorodState);
}
/// <summary>
/// Добыча номера карты плательщика
/// </summary>
/// <returns></returns>
int GetPayerAccount()
{
try
{
// RootLog($"{Tid} [DLIM] {"SELECT [Card_number] FROM Gorod.dbo].payment where tid ="} {Tid}");
int?Card = null;
using (Gorod db = new Gorod(Settings.GorodConnectionString))
{
IEnumerable <int?> Payments = db.ExecuteQuery <int?>("select [Card_number] from [gorod].[dbo].payment where tid = {0}", Tid);
Card = Payments.First <int?>();
}
return(Card >= 900000 && Card <= 999999 ? Card.Value : 0);
/*
* string Account = GetGorodSubLinq();
*
* RootLog("{0} [DLIM] Найден sub_inner_tid '{1}'", Tid, Account);
*
* if (!string.IsNullOrEmpty(Account) && Account.Length >= 6 && Account.Substring(0, 6).ToLower() == "card-9")
* {
* Account = Account.Substring(5, Account.IndexOf('-', 5) - 4);
* RootLog("{0} [DLIM] Найден account '{1}'", Tid, Account);
* return int.Parse(Account.Replace("-", ""));
* }
* else
* return 0;
*/
}
catch (Exception ex)
{
RootLog($"{Tid} [DLIM - stop] {ex}");
return(0);
}
}
