public override void Get(int Aid, ref int Arows) { string sql; int rows; // get the first suiteable title and return it SoV workDS = new SoV(); sql = String.Format("Select * from tdbadmin.tdbv_so where so_id = {0} and s_id = {1}", Aid, tdb.User.Ulangid); FillDs(workDS, sql, new string[] { "tdbv_so" }); Arows = workDS.tdbv_so.Rows.Count; SoV.tdbv_soRow Rwork = workDS.tdbv_so[0]; // set variables now id = Rwork.SO_ID; // no code seasonid = Rwork.SEASONID; season = Rwork.SEASON; startdate = Rwork.STARTDAT; enddate = Rwork.STOPDAT; code = Rwork.CODE; 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 SoV workDS = new SoV(); sql = String.Format("Select * from tdbadmin.tdbv_so where so_id = {0} and s_id = {1}", Aid, tdb.User.Ulangid); FillDS(workDS, sql, new string[] { "tdbv_so" }); Arows = workDS.tdbv_so.Rows.Count; SoV.tdbv_soRow Rwork = workDS.tdbv_so[0]; // set variables now id = Rwork.SO_ID; // no code seasonid = Rwork.SEASONID; season = Rwork.SEASON; startdate = Rwork.STARTDAT; enddate = Rwork.STOPDAT; code = Rwork.CODE; bez = Rwork.BEZ; bez_id = Rwork.BEZ_ID; text_id = Rwork.TEXTID; if (text_id > 0) rows = GetText(); else text = ""; }