/// <summary>
///
/// </summary>
/// <param name="tenNguyenLieu">tên nguyên liệu </param>
/// <param name="maNhaCungCap">mã nhà cung cấp</param>
/// <returns></returns>
public static DataTable TiemKiemNguyenLieu(string tenNguyenLieu, string maNhaCungCap, bool isXemToiThieu, int pageNumber, int pageSize,
List <string> exceptList = null)
{
DataTable table = NguyenLieuDAO.XemNguyenLieu(tenNguyenLieu, maNhaCungCap, isXemToiThieu, pageNumber, pageSize);
if (exceptList != null)
{
foreach (string item in exceptList)
{
if (item != null)
{
try
{
table = table.Select("manl <> '" + item + "'").CopyToDataTable();
}
catch (Exception ex)
{
Utility.Log(ex);
table.Clear();
}
}
}
}
return(table);
}
public static string LayMaNLLonNhat()
{
string maNLMax = NguyenLieuDAO.LayMaNLLonNhat();
if (maNLMax != null)
{
int chuyenSo = int.Parse(maNLMax.Replace("NL", ""));
return("NL" + (chuyenSo + 1).ToString("000"));
}
return("NL001");
}
public static bool KhoiPhucPhieuNhap(int maPhieuNhap, List <CTPhieuNhapDTO> lsCTPhieuNhap)
{
if (PhieuNhapDAO.KhoiPhucPhieuNhap(maPhieuNhap))
{
foreach (CTPhieuNhapDTO ctpn in lsCTPhieuNhap)
{
if (!NguyenLieuDAO.TangSoLuongTonKho(ctpn))
{
return(false);
}
}
}
return(true);
}
public static List <NguyenLieu> TimKiemDanhSachNguyenLieu(string tenNguyenLieu, string maNhaCungCap, bool isXemToiThieu, int pageNumber, int pageSize)
{
DataTable table = NguyenLieuDAO.XemNguyenLieu(tenNguyenLieu, maNhaCungCap, isXemToiThieu, pageNumber, pageSize);
List <NguyenLieu> list = table.AsEnumerable().ToList().ConvertAll(x =>
new NguyenLieu()
{
Ma = x[0].ToString(),
Ten = x[1].ToString(),
NhaCungCap = x[2].ToString(),
Dongia = uint.Parse(x[4].ToString()),
DonViTinh = x[3].ToString(),
SoLuongTon = int.Parse(x[5].ToString()),
SoLuongToiThieu = int.Parse(x[6].ToString()),
});
return(list);
}
public static bool LuuPhieuNhap(PhieuNhapDTO phieuNhap, List <CTPhieuNhapDTO> lsCTPhieuNhap)
{
if (!PhieuNhapDAO.LuuPhieuNhap(phieuNhap))
{
return(false);
}
foreach (CTPhieuNhapDTO ctpn in lsCTPhieuNhap)
{
if (!CTPhieuNhapDAO.LuuCTPhieuNhap(ctpn))
{
return(false);
}
if (!NguyenLieuDAO.TangSoLuongTonKho(ctpn))
{
return(false);
}
}
return(true);
}
// Cập nhật số lượng tồn kho khi nhập hóa đơn
public static bool CapNhatSoLuongTonKhoTang(int maHD, string maNL, int sltk)
{
return(NguyenLieuDAO.CapNhatSoLuongTonKhoTang(maHD, maNL, sltk));
}
// Lấy đơn vị tính load từ cboMaNL bên frmHDNhap/Xuat
public static string LayDonViTinhTuMaNL(string maNL)
{
return(NguyenLieuDAO.LayDonViTinhTuMaNL(maNL));
}
public static DataTable LoadDSNguyenLieuKhongConSuDung()
{
return(NguyenLieuDAO.LayDSNguyenLieuKhongConSuDung());
}
public static bool XoaNguyenLieu(string maNL)
{
return(NguyenLieuDAO.XoaNguyenLieu(maNL));
}
public static int DemPhieuNhapNguyenLieu(int loai)
{
return(NguyenLieuDAO.DemPhieuNhapNguyenLieu(loai));
}
public static List <PhieuNhapHang> XemPhieuNhapHang(int loai, int pageNumber, int pageSize)
{
return(NguyenLieuDAO.XemPhieuNhapHang(loai, pageNumber, pageSize));
}
public static bool NhapHangNguyeLieu(string soPhieuNhap, List <string> listMa, List <string> listSoLuong, uint thanhTien)
{
return(NguyenLieuDAO.NhapHang(soPhieuNhap, listMa, listSoLuong, thanhTien));
}
public static PhieuNhapHang LapPhieuNhap(string nhaCungCap, string maNhanVien)
{
return(NguyenLieuDAO.LapPhieuNhap(nhaCungCap, maNhanVien));
}
public static bool CapNhatNguyenLieu(NguyenLieu nguyenLieu)
{
return(NguyenLieuDAO.CapNhatNguyenLieu(nguyenLieu));
}
/// <summary>
///
/// </summary>
/// <param name="nguyenLieu"></param>
/// <returns></returns>
public static bool ThemNguyenLieu(NguyenLieu nguyenLieu)
{
return(NguyenLieuDAO.NhapNguyenLieu(nguyenLieu));
}
public static bool ThemNguyenLieu(NguyenLieuDTO nl)
{
return(NguyenLieuDAO.ThemNguyenLieu(nl));
}
public static bool CapNhatNguyenLieu(NguyenLieuDTO nl)
{
return(NguyenLieuDAO.CapNhatNguyenLieu(nl));
}
public static int LayMaNguyenLieuMoiNhat()
{
return(NguyenLieuDAO.LayMaNguyenLieuMoiNhat());
}
public static DataTable TimKiemTheoTenNguyenLieu(string tenNL)
{
return(NguyenLieuDAO.TimKiemTheoTenNguyenLieu(tenNL));
}
public static List <NguyenLieuDTO> LayDanhSachNguyenLieu(string timKiem = "", bool trangThai = true)
{
return(NguyenLieuDAO.LayDanhSachNguyenLieu(timKiem, trangThai));
}
public static bool KhoiPhucTrangThaiNguyenLieu(NguyenLieuDTO nl)
{
return(NguyenLieuDAO.KhoiPhucTrangThaiNguyenLieu(nl));
}
public static List <NguyenLieuDTO> LayDanhSachTatCaNguyenLieu()
{
return(NguyenLieuDAO.LayDanhSachTatCaNguyenLieu());
}
// Lấy đơn giá load từ cboMaNL bên frmHDNhap
public static int LayDonGiaTuMaNL(string maNL)
{
return(NguyenLieuDAO.LayDonGiaTuMaNL(maNL));
}
public static bool XoaNguyenLieu(int maNguyenLieu)
{
return(NguyenLieuDAO.XoaNguyenLieu(maNguyenLieu));
}
// Lấy số lượng tồn kho nguyên liệu
public static int LaySoLuongTKNL(string maNL)
{
return(NguyenLieuDAO.LaySoLuongTKNL(maNL));
}
public static bool SuaNguyenLieu(NguyenLieuDTO nguyenLieu)
{
return(NguyenLieuDAO.SuaNguyenLieu(nguyenLieu));
}
public static DataTable LayDSMaNL()
{
return(NguyenLieuDAO.LayDSMaNL());
}
public static bool KhoiPhucNguyenLieu(int maNguyenLieu)
{
return(NguyenLieuDAO.KhoiPhucNguyenLieu(maNguyenLieu));
}
public static DataTable LoadDSNguyenLieu()
{
return(NguyenLieuDAO.LayDSNguyenLieu());
}
public static List <PhieuNhapHangDataSource> XemChiTietPhieuNhapNguyenlieu(string soPhieuDat)
{
return(NguyenLieuDAO.XemChiTietPhieuNhapNguyenlieu(soPhieuDat));
}
