Ejemplo n.º 1
0
        public List <HoaDonHienThi> loadHoaDon()
        {
            List <HoaDonHienThi> list = new List <HoaDonHienThi>();
            DataTable            dt   = HoaDonController.Instance.getAllHoaDonHienThi();

            foreach (DataRow item in dt.Rows)
            {
                String id           = item["id"].ToString();
                String id_khachhang = item["hoten"].ToString();
                String id_ban       = item["ten_ban"].ToString();
                String ngayhd       = item["ngayhd"].ToString();
                String sotien       = item["sotien"].ToString();
                String trangthai;
                if ((int)item["trangthai"] == 1)
                {
                    trangthai = "Chưa thanh toán";
                }
                else
                {
                    trangthai = "Đã thanh toán";
                }
                HoaDonHienThi dh = new HoaDonHienThi(id, id_ban, id_khachhang, ngayhd, sotien, trangthai);
                list.Add(dh);
            }

            return(list);
        }
Ejemplo n.º 2
0
        public List <HoaDonHienThi> GetTable_HD()
        {
            List <HoaDonHienThi> listHD = new List <HoaDonHienThi>();
            string sql = "select MaHD,TenNV,TenKH,NgayMua from HOA_DON inner join NHAN_VIEN on HOA_DON.MaNV=NHAN_VIEN.MaNV inner join KHACH_HANG on HOA_DON.MaKH=KHACH_HANG.MaKH";

            XuLy.conn = new SqlConnection(XuLy.strConnection);
            XuLy.conn.Open();
            XuLy.cmd = new SqlCommand(sql, XuLy.conn);
            SqlDataReader dr = XuLy.cmd.ExecuteReader();

            while (dr.Read())
            {
                HoaDonHienThi hd = new HoaDonHienThi(
                    dr["MaHD"].ToString(),
                    dr["TenNV"].ToString(),
                    dr["TenKH"].ToString(),
                    DateTime.Parse(dr["NgayMua"].ToString()));
                listHD.Add(hd);
            }
            dr.Close();
            XuLy.conn.Close();
            return(listHD);
        }