- 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
string res = "";
try
{
if (org_id == NewId.ToString())
{
string query = "delete from ARMVZ_CONFIG where org_id = " + org_id;
OdbcCommand cmd = new OdbcCommand(query, getConnect());
cmd.ExecuteNonQuery();
cmd.CommandText = "delete from organisations where id = " + org_id;
cmd.ExecuteNonQuery();
cmd.CommandText = "delete from services where orgid = " + org_id;
cmd.ExecuteNonQuery();
NewId = 0;
res = "";
}
else
{
try
{
string query = "select * from tmp_organisations where id = " + org_id;
OdbcCommand cmd = new OdbcCommand(query, getConnect());
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
if (dt.Rows.Count > 0)
{
query = "update organisations set ";
foreach (DataColumn col in dt.Columns)
{
if (col.ColumnName != "id")
{
query = query + col.ColumnName +
" = (select " + col.ColumnName +
@" from tmp_organisations where tmp_organisations.id = " + org_id + " ),";
}
}
query = query.Remove(query.Length - 1);
query = query + " where id = " + org_id;
cmd.CommandText = query;
dt.Dispose();
cmd.ExecuteNonQuery();
}
}
catch
{
//
}
try
{
string query = "select * from tmp_armvz_config where org_id = " + org_id;
OdbcCommand cmd = new OdbcCommand(query, getConnect());
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
if (dt.Rows.Count > 0)
{
query = "update armvz_config set ";
foreach (DataColumn col in dt.Columns)
{
if (col.ColumnName != "org_id")
{
query = query + col.ColumnName +
" = (select " + col.ColumnName +
@" from tmp_armvz_config where tmp_armvz_config.org_id = " + org_id + " ),";
}
}
query = query.Remove(query.Length - 1);
query = query + " where org_id = " + org_id;
cmd.CommandText = query;
dt.Dispose();
cmd.ExecuteNonQuery();
}
}
catch
{
//
}
метод называется "rollback_transaction". весь метод просто не влез