public override void Get(int Aid, ref int Arows)
{
string sql;
int rows;
CustV workDS;
// get the first suiteable title and return it
workDS = new CustV();
sql = String.Format("Select * from tdbadmin.tdbv_cust where pers_id = {0}", Aid);
FillDs(workDS, sql, new string[] { "tdbv_cust" });
Arows = workDS.tdbv_cust.Rows.Count;
CustV.tdbv_custRow Rwork = workDS.tdbv_cust[0];
// set variables now
id = Rwork.PERS_ID;
code = Rwork.NAME;
curid = Rwork.CURID;
langid = Rwork.S_ID;
staid = Rwork.STA_ID;
tel = Rwork.TEL;
handy = Rwork.HANDY;
fax = Rwork.FAX;
tlx = Rwork.TLX;
email = Rwork.EMAIL;
web = Rwork.WEB;
account = Rwork.ACCOUNT;
manager = Rwork.MANAGER;
attr1 = Rwork.ATTR1;
attr2 = Rwork.ATTR2;
custtypid = Rwork.CUSTTYPEID;
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;
CustV workDS;
// get the first suiteable title and return it
workDS = new CustV();
sql = String.Format("Select * from tdbadmin.tdbv_cust where pers_id = {0}", Aid);
FillDS(workDS, sql, new string[] { "tdbv_cust" });
Arows = workDS.tdbv_cust.Rows.Count;
CustV.tdbv_custRow Rwork = workDS.tdbv_cust[0];
// set variables now
id = Rwork.PERS_ID;
code = Rwork.NAME;
curid = Rwork.CURID;
langid = Rwork.S_ID;
staid = Rwork.STA_ID;
tel = Rwork.TEL;
handy = Rwork.HANDY;
fax = Rwork.FAX;
tlx = Rwork.TLX;
email = Rwork.EMAIL;
web = Rwork.WEB;
account = Rwork.ACCOUNT;
manager = Rwork.MANAGER;
attr1 = Rwork.ATTR1;
attr2 = Rwork.ATTR2;
custtypid = Rwork.CUSTTYPEID;
text_id = Rwork.TEXTID;
if (text_id > 0)
rows = GetText();
else
text = "";
}