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