public override void Get(int Aid, ref int Arows)
{
string sql;
int rows;
// get the first suiteable title and return it
OffV workDS = new OffV();
sql = String.Format("Select * from tdbadmin.tdbv_o where o_id = {0} and s_id = {1}", Aid, tdb.User.Ulangid);
FillDS(workDS, sql, new string[] { "tdbv_o" });
Arows = workDS.tdbv_o.Rows.Count;
OffV.tdbv_oRow Rwork = workDS.tdbv_o[0];
// set variables now
id = Rwork.O_ID;
// no code
code = Rwork.CODE;
fromcity = Rwork.FROMCITYID;
tocity = Rwork.TOCITYID;
order = Rwork.ORD;
duration = Rwork.DURATION;
offtype = Rwork.OTID;
location = Rwork.LOCATION;
supid = Rwork.SUPID;
actid = Rwork.ACTID;
parentid = Rwork.HOSTO_ID;
bez = Rwork.BEZ;
bez_id = Rwork.BEZ_ID;
text_id = Rwork.TEXTID;
if (text_id > 0)
{
rows = GetText();
}
else
{
text = "";
}
}
public override void Get(int Aid, ref int Arows)
{
string sql;
int rows;
// get the first suiteable title and return it
OffV workDS = new OffV();
sql = String.Format("Select * from tdbadmin.tdbv_o where o_id = {0} and s_id = {1}", Aid, tdb.User.Ulangid);
FillDS(workDS, sql, new string[] { "tdbv_o" });
Arows = workDS.tdbv_o.Rows.Count;
OffV.tdbv_oRow Rwork = workDS.tdbv_o[0];
// set variables now
id = Rwork.O_ID;
// no code
code = Rwork.CODE;
fromcity = Rwork.FROMCITYID;
tocity = Rwork.TOCITYID;
order = Rwork.ORD;
duration = Rwork.DURATION;
offtype = Rwork.OTID;
location = Rwork.LOCATION;
supid = Rwork.SUPID;
actid = Rwork.ACTID;
parentid = Rwork.HOSTO_ID;
bez = Rwork.BEZ;
bez_id = Rwork.BEZ_ID;
text_id = Rwork.TEXTID;
if (text_id > 0)
rows = GetText();
else
text = "";
}
