public override void Get(int Aid, ref int Arows)
{
string sql;
int rows;
DltV workDS;
// get the first suiteable title and return it
workDS = new DltV();
sql = String.Format("Select * from tdbadmin.tdbv_dlt where dlt_id = {0} and s_id = {1}", Aid, tdb.User.Ulangid);
FillDs(workDS, sql, new string[] { "tdbv_dlt" });
Arows = workDS.tdbv_dlt.Rows.Count;
DltV.tdbv_dltRow Rwork = workDS.tdbv_dlt[0];
// set variables now
id = Rwork.DLT_ID;
code = Rwork.CODE;
bez = Rwork.BEZ;
bez_id = Rwork.BEZ_ID;
parentid = Rwork.H_DLT_ID;
host = Rwork.HOSTID;
kat_id = Rwork.CAT_ID;
kat = Rwork.CAT;
typ_id = Rwork.TYPID;
suptyp = Rwork.TYP;
capacity = Rwork.NUMPLACE;
level = Rwork.LEVELPLACE;
staid = Rwork.STAID;
text_id = Rwork.TEXTID;
if (text_id > 0)
{
rows = GetText();
}
else
{
text = "";
}
}
public void InsUpd(bool Ainsert, string Abez, string Atext, string Acode,
int Aparentid, bool Ahost, int Acat, int Asupt, int Asta, int Alev, int Acapa)
{
int rowsaffected;
string sql;
// set Country to this new one
bez = Abez;
text = Atext;
code = Acode;
if (Ahost == false)
{
DltV workDS = new DltV();
sql = String.Format("Select * from tdbadmin.tdbv_dlt where dlt_id = {0} and s_id = {1}", Aparentid, tdb.User.Ulangid);
FillDs(workDS, sql, new string[] { "tdbv_dlt" });
DltV.tdbv_dltRow Rwork = workDS.tdbv_dlt[0];
parentid = Aparentid;
host = Rwork.HOSTID;
}
kat_id = Acat;
typ_id = Asupt;
capacity = Acapa;
level = Alev;
staid = Asta;
// Begin Trx
BeginTrx();
if (Ainsert)
{
// first get a new unique ID for bez and then sai
id = NewId("dienst_traeger", "DLT_ID");
if (Ahost == true)
{
parentid = -1;
host = id;
}
rowsaffected = InsBez();
rowsaffected = InsText();
// insert
sql = String.Format("insert into tdbadmin.dienst_traeger values({0}, '{1}', {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}, {11})",
id, code, bez_id, kat_id, parentid, dlt_grp_id, host, typ_id, text_id, level, staid, capacity);
rowsaffected = DBcmd(sql);
}
else
{
if (Ahost == true)
{
parentid = -1;
host = id;
}
rowsaffected = UpdBez();
rowsaffected = UpdText();
// update sai
sql = String.Format("update tdbadmin.dienst_traeger set h_dlt_id = {0}, host_id = {1}, kat_id = {2}, typ_id = {3}, sta_id ={4}, stufe = {5}, anz = {6}, dlt_grp_id = {7}, code = '{8}', textid = {9} where dlt_id = {10}",
parentid, host, kat_id, typ_id, staid, level, capacity, dlt_grp_id, code, text_id, id);
rowsaffected = DBcmd(sql);
}
// commit
Commit();
}
