Exemplos de MMG_PIAPS.classes PassSlip.SELECT_BY_EMPID em C# (CSharp)

Exemplo n.º 1

        }//end load ins listview

        public void LoadMyPassSlips(ListView lv)
        {
            PassSlip  s  = new PassSlip();
            DataTable dt = new DataTable();

            s.empid = empid;

            dt = s.SELECT_BY_EMPID();

            if (dt != null)
            {
                int ctr = 1;
                foreach (DataRow r in dt.Rows)
                {
                    ListViewItem li = new ListViewItem();
                    li.Text = ctr.ToString();
//                    li.SubItems.Add(r["fullname"].ToString());
                    li.SubItems.Add(r["passtype"].ToString());
                    li.SubItems.Add(r["destination"].ToString());
                    li.SubItems.Add(r["purpose"].ToString());
                    li.SubItems.Add(r["datetime_in"].ToString());
                    li.SubItems.Add(r["datetime_out"].ToString());
                    li.SubItems.Add(r["allowance"].ToString());
                    li.SubItems.Add(r["status_"].ToString());

                    lv.Items.Add(li);

                    ctr++;
                }
            }
        }//end load ins listview

Exemplo n.º 2

Arquivo: PassSlip.cs Projeto: zerojec/MMG-PIAPS

        public void LoadMyPassSlips(ListView lv)
        {
            PassSlip s = new PassSlip();
            DataTable dt = new DataTable();

            s.empid = empid;

            dt = s.SELECT_BY_EMPID();

            if (dt != null)
            {
                int ctr = 1;
                foreach (DataRow r in dt.Rows)
                {
                    ListViewItem li = new ListViewItem();
                    li.Text = ctr.ToString();
            //                    li.SubItems.Add(r["fullname"].ToString());
                    li.SubItems.Add(r["passtype"].ToString());
                    li.SubItems.Add(r["destination"].ToString());
                    li.SubItems.Add(r["purpose"].ToString());
                    li.SubItems.Add(r["datetime_in"].ToString());
                    li.SubItems.Add(r["datetime_out"].ToString());
                    li.SubItems.Add(r["allowance"].ToString());
                    li.SubItems.Add(r["status_"].ToString());

                    lv.Items.Add(li);

                    ctr++;
                }
            }
        }