public override void CreateRecord(FieldTable tableField)
{
#region Добавление новой записи
string sql_str = string.Empty;
#region Формирую SQL запрос
if (!string.IsNullOrEmpty(tableField.name))
{
sql_str = @"Insert into contacts_book.contact_fio (name,surname, middle_name, birthday, comments)
values('" + tableField.name + "', " +
"'" + tableField.surname + "', " +
"'" + tableField.middle_name + "', " +
"STR_TO_DATE('" + tableField.birthday + "', '%d.%m.%Y'), " +
"'" + tableField.comments + "'); ";
}
else if (!string.IsNullOrEmpty(tableField.contact_definition))
{
sql_str = @"insert into contacts_book.contact_type(contact_definition) values('" + tableField.contact_definition + "');";
}
else
{
sql_str = @"insert into contacts_book.contact_list(fio_id, type_id, value_)
values(" + tableField.fio_id + ", " + tableField.type_id + ", '" + tableField.value_ + "');";
}
#endregion
ExecutionSqlQuery(sql_str);
#endregion
}
public override void UpdateRecord(FieldTable tableField)
{
#region Меняю записи
string sql_str = string.Empty;
#region Формирую SQL запрос
if (tableField.id_list != 0)
{
sql_str = @"update contacts_book.contact_list set value_ ='" + tableField.value_ + "' " +
"where id_list = " + tableField.id_list + " and fio_id = " + tableField.fio_id + " ";
}
else
{
sql_str = @"update contacts_book.contact_fio
set
name = '" + tableField.name + "', " +
" surname = '" + tableField.surname + "', " +
" middle_name = '" + tableField.middle_name + "', " +
" birthday = STR_TO_DATE('" + tableField.birthday + "','%d.%m.%Y'), " +
" comments = '" + tableField.comments + "'" +
" where id_fio = " + tableField.fio_id + "";
}
#endregion
ExecutionSqlQuery(sql_str);
#endregion
}
public override DataTable SelectRecord(FieldTable tableField, string getViewTable)
{
#region Вывожу результирующую таблицы
string sql_str = string.Empty;
DataTable dt = new DataTable();
switch (getViewTable)
{
case "Type":
sql_str = "select * from contacts_book.contact_type order by idcontact_type";
break;
case "Fio":
sql_str = "select * from contacts_book.contact_fio where id_fio = " + tableField.fio_id + "";
break;
case "List":
sql_str = "select * from contacts_book.contact_list where fio_id = " + tableField.fio_id + "";
break;
}
MySqlDataAdapter dataAdapter;
try
{
string connectionString = ConnStr;
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
dataAdapter = new MySqlDataAdapter(sql_str, connection);
connection.Open();
dataAdapter.Fill(dt);
}
}
catch (Exception ex)
{
CreateStringErr(ex.Message);
}
return(dt);
#endregion
}
public override void DeleteRecord(FieldTable tableField)
{
#region Удаление записи
string sql_str = string.Empty;
#region Формирую SQL запрос
if (tableField.id_list != 0)
{
sql_str = @"delete from contacts_book.contact_list where id_list = " + tableField.id_list + " and fio_id = " + tableField.fio_id + " ";
}
else
{
sql_str = @"delete from contacts_book.contact_fio where id_fio = " + tableField.fio_id + "";
}
#endregion
ExecutionSqlQuery(sql_str);
#endregion
}
public abstract /*List<FieldTable>*/ DataTable SelectRecord(FieldTable tableField, string getViewTable);
public abstract void UpdateRecord(FieldTable tableField);
public abstract void DeleteRecord(FieldTable tableField);