- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
abstract class Data
{
public string QueryText { get; protected set; }
public BindingSource SelectResult { get; private set; }
public object[] SelectedRow { get; protected set; }
/// <summary>
/// Добавляет новую запись в таблицу
/// </summary>
protected virtual void InsertRecord()
{
if (IsConnected())
{
SqlDataAdapter DA = new SqlDataAdapter();
DA.InsertCommand = new SqlCommand(QueryText, DB.Connection);
DA.InsertCommand.ExecuteNonQuery();
}
}
protected virtual void UpdateRecord()
{
if (IsConnected())
{
SqlDataAdapter DA = new SqlDataAdapter();
DA.UpdateCommand = new SqlCommand(QueryText, DB.Connection);
DA.UpdateCommand.ExecuteNonQuery();
}
}
protected virtual void DeleteRecord()
{
if (IsConnected())
{
SqlDataAdapter DA = new SqlDataAdapter();
DA.DeleteCommand = new SqlCommand(QueryText, DB.Connection);
DA.DeleteCommand.ExecuteNonQuery();
}
}
/// <summary>
/// Выбирает данные и записывает результат в переменную SelectResult
/// </summary>
protected virtual void Select()
{
DataSet DS = new DataSet();
DS.Tables.Add("Tbl");
SqlDataAdapter ADP = new SqlDataAdapter();
if (IsConnected())
{
ADP.SelectCommand = new SqlCommand(QueryText, DB.Connection);
ADP.Fill(DS.Tables["Tbl"]);
SelectResult = new BindingSource();
string s = DS.Tables[0].TableName;
SelectResult.DataMember = s;
SelectResult.DataSource = DS;
}
}
/// <summary>
/// Выбирает данные и записывает результат в Object массив SelectedRow
/// </summary>
public virtual void SelectRow()
{
DataSet DS = new DataSet();
DS.Tables.Add("Tbl");
SqlDataAdapter ADP = new SqlDataAdapter();
if (IsConnected())
{
ADP.SelectCommand = new SqlCommand(QueryText, DB.Connection);
ADP.Fill(DS.Tables["Tbl"]);
}
SelectedRow = DS.Tables[0].Rows[0].ItemArray;
}
private bool IsConnected()
{
if(DB.Connection.State == System.Data.ConnectionState.Open)
{
return true;
}
else
{
return false;
}
}
Follow us!