Exemple #1
0
        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 = "";
            }
        }
Exemple #2
0
        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 = "";
        }