/// <summary> /// Получить контрагента с незащищенными данными по ID /// </summary> /// <param name="id">ID</param> public static Counterparty GetCounterpartyByID(int id) { Counterparty counterparty = new Counterparty(); if (counterparty.GetPublicDataByID(id)) { return(counterparty); } else { return(null); } }
/// <summary> /// Получить список контрагентов /// </summary> /// <param name="provider_value">значение поля IS_PROVIDER</param> /// <returns></returns> private static List <Counterparty> GetContragentList(int provider_value) { List <Counterparty> Counterparties = new List <Counterparty>(); try { using (MySqlConnection connection = new MySqlConnection(Criptex.UnCript(ProgramSettings.ConnectionString))) { connection.Open(); string sql = "SELECT * FROM `COUNTERPARTY` WHERE `COUNTERPARTY`.`IS_PROVIDER` = \'" + provider_value + "\' AND `COUNTERPARTY`.`IS_ANNULATED` = \'0\'"; using (MySqlCommand command = new MySqlCommand(sql, connection)) { using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Counterparty item = new Counterparty(); item.ID = Conversion.ToInt(reader["ID"].ToString()); item.Code = reader["CODE"].ToString(); item.Surname = reader["SURNAME"].ToString(); item.Name = reader["NAME"].ToString(); item.Patronymic = reader["PATRONYMIC"].ToString(); item.Nomination = reader["NOMINATION"].ToString(); item.Adress = Conversion.ToUncriptString(reader["ADRESS"].ToString()); item.Phone = Conversion.ToUncriptString(reader["PHONE"].ToString()); item.IsProvider = Conversion.ToBool(reader["IS_PROVIDER"].ToString()); Counterparties.Add(item); } } } connection.Close(); } } catch (Exception ex) { Dialog.ErrorMessage(null, "Ошибка получения данных о контрагенте", ex.Message); } return(Counterparties); }