コード例 #1
0
ファイル: DataProvider.cs プロジェクト: hoangnghia/DoAnWeb2
        public static int CapNhatChiTietDonHang(SanPhamGioHang nd)
        {
            string query = String.Format("UPDATE ChiTietDonHang SET SoLuong = " + nd.SoLuong + ", DonGia = " + nd.Gia + ", ThanhTien = " + nd.ThanhTien + " WHERE ID = " + nd.ID + "");

            try
            {
                conn.Open();
                command.CommandText = query;
                return command.ExecuteNonQuery();

            }
            catch (Exception ex)
            {

            }
            finally
            {
                conn.Close();
            }
            return 0;
        }
コード例 #2
0
ファイル: DataProvider.cs プロジェクト: hoangnghia/DoAnWeb2
        public static List<SanPhamGioHang> LayDanhSachChiTietDonHangTheoMaHoaDon(int maHoaDon)
        {
            DonHang dh = LoadDonHangTheoMaHoaDon(maHoaDon);
            if (dh == null)
            {
                return new List<SanPhamGioHang>();
            }
            List<SanPhamGioHang> list = new List<SanPhamGioHang>();
            string query = String.Format("SELECT CTDH.MaDH, CTDH.ID ,SP.TenSP, CTDH.SoLuong, SP.GiaMoi, CTDH.ThanhTien, DH.TinhTrang, SP.HinhSP, SP.MaSP FROM ChiTietDonHang as CTDH, SanPham as SP, DonHang as DH Where CTDH.MaSP = SP.MaSP and DH.ID = CTDH.MaDH and DH.ID = " + maHoaDon + " and CTDH.Status = 1");
            string ErrMsg = string.Empty;
            try
            {
                conn.Open();
                command.CommandText = query;
                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    Int32 madonhang = reader.GetInt32(0);
                    Int32 machitietdonhang = reader.GetInt32(1);
                    String tensanpham = reader.GetString(2);
                    Int32 soluong = reader.GetInt32(3);
                    Int64 GiaSanPham = reader.GetInt64(4);
                    Int64 thanhTien = reader.GetInt64(5);
                    String tinhtrang = reader.GetString(6);
                    String hinhsp = reader.GetString(7);
                    String masanpham = reader.GetString(8);

                    SanPhamGioHang sp = new SanPhamGioHang(madonhang, machitietdonhang, tensanpham, soluong, GiaSanPham, thanhTien, tinhtrang, hinhsp, masanpham);
                    sp.TinhTrang = dh.TinhTrang;
                    list.Add(sp);
                }
            }
            catch (Exception ex)
            {
                ErrMsg = ex.Message;
            }
            finally
            {
                conn.Close();
            }

            return list;
        }