public List <TK_HDNhap_NSXDTO> LAYDSHDNhapTheoMaHD(string mahd) { List <TK_HDNhap_NSXDTO> ls = new List <TK_HDNhap_NSXDTO>(); string struyvan = "Select * From dbo.HienThiDSHoaDonNhap WHERE MaHDNhap = '" + mahd + "' "; SqlConnection con = DataProvider.TaoKetNoi(); SqlDataReader sr = DataProvider.TruyVanDuLieu(struyvan, con); while (sr.Read()) { TK_HDNhap_NSXDTO dto = new TK_HDNhap_NSXDTO(); dto.MaHDNhap = sr["MaHDNhap"].ToString(); dto.NgayNhapHang = DateTime.Parse(sr["NgayNhapHang"].ToString()); dto.TongTien = double.Parse(sr["TongTien"].ToString()); dto.NVLap = sr["NVLap"].ToString(); dto.HoTenNSX = sr["TenNSX"].ToString(); dto.HoTenNV = sr["HoTenNV"].ToString(); dto.TinhTrang = int.Parse(sr["TinhTrang"].ToString()); ls.Add(dto); } con.Close(); sr.Close(); return(ls); }
public List <TK_HDNhap_NSXDTO> LayDanhSachHDNHuy(DateTime TimeTu, DateTime TimeDen) { List <TK_HDNhap_NSXDTO> ls = new List <TK_HDNhap_NSXDTO>(); string struyvan = "Select * From dbo.HienThiDSHoaDonNhap Where TinhTrang =0 AND NgayNhapHang Between '" + TimeTu + "' AND '" + TimeDen + "' "; SqlConnection con = DataProvider.TaoKetNoi(); SqlDataReader sr = DataProvider.TruyVanDuLieu(struyvan, con); while (sr.Read()) { TK_HDNhap_NSXDTO dto = new TK_HDNhap_NSXDTO(); dto.MaHDNhap = sr["MaHDNhap"].ToString(); dto.HoTenNSX = sr["TenNSX"].ToString(); dto.HoTenNV = sr["HoTenNV"].ToString(); dto.NgayNhapHang = DateTime.Parse(sr["NgayNhapHang"].ToString()); dto.TongTien = double.Parse(sr["TongTien"].ToString()); dto.NVLap = sr["NVLap"].ToString(); dto.TinhTrang = int.Parse(sr["TinhTrang"].ToString()); ls.Add(dto); } con.Close(); sr.Close(); return(ls); }