Beispiel #1
0
        public Pliromi get_Last_Pliromi()
        {
            Dal           myDal     = new Dal();
            Pliromi       myPliromi = new Pliromi();
            DataTable     dt        = new DataTable();
            SqlDataReader dr        = myDal.getLastPliromi();

            if (dr.HasRows)
            {
                dt.Load(dr);
            }
            foreach (DataRow row in dt.Rows)
            {
                myPliromi.Pliromi_opid = Convert.ToInt32(row["op_id"].ToString());
                myPliromi.PliromiId    = Convert.ToInt32(row["p_id"].ToString());
                myPliromi.PayDay       = Convert.ToDateTime(row["p_date"].ToString());
                myPliromi.p_opasm      = Convert.ToInt32(row["op_asm"].ToString());
                myPliromi.bathmos      = row["r_perigrafi"].ToString();
                myPliromi.onoma        = row["op_onoma"].ToString();
                myPliromi.eponymo      = row["op_eponymo"].ToString();
                myPliromi.loxos        = row["op_loxos"].ToString();
                myPliromi.katName      = row["kat_name"].ToString();
                myPliromi.katalogisteo = Convert.ToDecimal(row["kat_katalogisteo"].ToString());
                myPliromi.kratiseis    = Convert.ToDecimal(row["kat_kratiseis"].ToString());
                myPliromi.pliroteo     = Convert.ToDecimal(row["kat_pliroteo"].ToString());
                myPliromi.mPerigrafi   = row["m_perigrafi"].ToString();
                float temp = Convert.ToSingle(row["p_posoPliromis"].ToString());
                myPliromi.Poso = Convert.ToDecimal(temp);
            }
            return(myPliromi);
        }