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);
}
