public MaSanPham LayMaSanPham(String idMaSanPham)
{
MaSanPhanFactory f = new MaSanPhanFactory();
DataTable tbl = f.LayMaSanPham(idMaSanPham);
MaSanPham sp = null;
SanPhamController ctrlSanPham = new SanPhamController();
if (tbl.Rows.Count > 0)
{
sp = new MaSanPham();
sp.Id = Convert.ToString(tbl.Rows[0]["ID"]);
sp.SoLuong = Convert.ToInt32(tbl.Rows[0]["SO_LUONG"]);
sp.GiaNhap = Convert.ToInt64(tbl.Rows[0]["DON_GIA_NHAP"]);
sp.NgayNhap = Convert.ToDateTime(tbl.Rows[0]["NGAY_NHAP"]);
sp.NgaySanXuat = Convert.ToDateTime(tbl.Rows[0]["NGAY_SAN_XUAT"]);
sp.NgayHetHan = Convert.ToDateTime(tbl.Rows[0]["NGAY_HET_HAN"]);
sp.SanPham = ctrlSanPham.LaySanPham(tbl.Rows[0]["ID_SAN_PHAM"].ToString());
}
return(sp);
}
public IList <MaSanPham> ChiTietPhieuNhap(String id)
{
SanPhamController ctrlSanPham = new SanPhamController();
IList <MaSanPham> ds = new List <MaSanPham>();
DataTable tbl = factory.DanhsachChiTiet(id);
foreach (DataRow row in tbl.Rows)
{
MaSanPham sp = new MaSanPham();
sp = new MaSanPham();
sp.Id = Convert.ToString(row["ID"]);
sp.SoLuong = Convert.ToInt32(row["SO_LUONG"]);
sp.GiaNhap = Convert.ToInt64(row["DON_GIA_NHAP"]);
sp.ThanhTien = sp.SoLuong * sp.GiaNhap;
sp.NgayNhap = Convert.ToDateTime(row["NGAY_NHAP"]);
sp.NgaySanXuat = Convert.ToDateTime(row["NGAY_SAN_XUAT"]);
sp.NgayHetHan = Convert.ToDateTime(row["NGAY_HET_HAN"]);
sp.SanPham = ctrlSanPham.LaySanPham(row["ID_SAN_PHAM"].ToString());
ds.Add(sp);
}
return(ds);
}
public static IList <MaSanPham> LayMaSanPhamHetHan(DateTime dt)
{
IList <MaSanPham> ds = new List <MaSanPham>();
MaSanPhanFactory f = new MaSanPhanFactory();
DataTable tbl = f.DanhsachMaSanPhamHetHan(dt);
MaSanPham sp = null;
SanPhamController ctrlSanPham = new SanPhamController();
foreach (DataRow row in tbl.Rows)
{
sp = new MaSanPham();
sp.Id = Convert.ToString(row["ID"]);
sp.SoLuong = Convert.ToInt32(row["SO_LUONG"]);
sp.GiaNhap = Convert.ToInt64(row["DON_GIA_NHAP"]);
sp.NgayNhap = Convert.ToDateTime(row["NGAY_NHAP"]);
sp.NgaySanXuat = Convert.ToDateTime(row["NGAY_SAN_XUAT"]);
sp.NgayHetHan = Convert.ToDateTime(row["NGAY_HET_HAN"]);
sp.SanPham = ctrlSanPham.LaySanPham(row["ID_SAN_PHAM"].ToString());
ds.Add(sp);
}
return(ds);
}