Exemplo n.º 1
0
        public invoice search()
        {
            string        q   = "select * from table_invoice where in_id=" + in_id;
            SqlCommand    cmd = new SqlCommand(q, connection.get());
            SqlDataReader sdr = cmd.ExecuteReader();
            invoice       i   = new invoice();

            while (sdr.Read())
            {
                i.in_id       = (int)sdr[0];
                i.in_date     = (string)sdr[1];
                i.in_fk_us_id = (int)sdr[2];
            }
            sdr.Close();
            return(i);
        }
Exemplo n.º 2
0
        public List <invoice> showall()
        {
            string         q   = "select * from table_invoice";
            SqlCommand     cmd = new SqlCommand(q, connection.get());
            SqlDataReader  sdr = cmd.ExecuteReader();
            List <invoice> lst = new List <invoice>();

            while (sdr.Read())
            {
                invoice i = new invoice();
                i.in_id       = (int)sdr[0];
                i.in_date     = (string)sdr[1];
                i.in_fk_us_id = (int)sdr[2];
                lst.Add(i);
            }
            sdr.Close();
            return(lst);
        }