コード例 #1
0
ファイル: SanPhamDAO.cs プロジェクト: red335/BaiTapLon
        public List <SanPham> layDS()
        {
            List <SanPham> sanPhams  = new List <SanPham>();
            DataTable      dataTable = DocCSDL("select * from SANPHAM ");

            if (dataTable == null || dataTable.Rows.Count == 0)
            {
                return(null);
            }
            foreach (DataRow row in dataTable.Rows)
            {
                SanPham sanPham = null;
                int     ma      = Convert.ToInt32(row[0]);
                string  ten     = row[1].ToString();
                int     tonKho  = Convert.ToInt32(row[2]);
                int     gia     = Convert.ToInt32(row[3]);

                int    giaBan  = Convert.ToInt32(row[4]);
                string loai    = row[5].ToString();
                string hinhAnh = row[6].ToString();
                string chitiet = row[7].ToString();

                Rate rate = new RateDAO().getRate(ma.ToString());

                HangSX hangSX = new HangSXDAO().getElement(row[8].ToString());
                sanPham             = new SanPham(ma, ten, tonKho, gia, giaBan, loai, hinhAnh, chitiet);
                sanPham.HangSanXuat = hangSX;
                sanPham.Rating      = rate;
                sanPhams.Add(sanPham);
            }

            return(sanPhams);
        }
コード例 #2
0
ファイル: SanPhamDAO.cs プロジェクト: red335/BaiTapLon
        public SanPham getElement(string id)
        {
            string    query   = "select * from SANPHAM  where MASP  = " + id;
            DataTable data    = DocCSDL(query);
            SanPham   sanPham = null;

            if (data != null || data.Rows.Count != 0)
            {
                int    ma      = Convert.ToInt32(data.Rows[0][0]);
                string ten     = data.Rows[0][1].ToString();
                int    tonKho  = Convert.ToInt32(data.Rows[0][2]);
                int    gia     = Convert.ToInt32(data.Rows[0][3]);
                int    giaBan  = Convert.ToInt32(data.Rows[0][4]);
                string loai    = data.Rows[0][5].ToString();
                string hinhAnh = data.Rows[0][6].ToString();
                string chitiet = data.Rows[0][7].ToString();

                Rate rate = new RateDAO().getRate(ma.ToString());

                HangSX hangSX = new HangSXDAO().getElement(data.Rows[0][8].ToString());
                sanPham             = new SanPham(ma, ten, tonKho, gia, giaBan, loai, hinhAnh, chitiet);
                sanPham.HangSanXuat = hangSX;
                sanPham.Rating      = rate;
            }
            return(sanPham);
        }