// Xóa Nguyên liệu
public void xoaNguyenLieu(string maNL)
{
QL_NguyenLieu xoaNL = ff.QL_NguyenLieus.Where(n => n.MaNL == maNL).FirstOrDefault();
if (xoaNL != null)
{
ff.QL_NguyenLieus.DeleteOnSubmit(xoaNL);
ff.SubmitChanges();
}
}
private bool ktSLNL(QL_SanPham sp)
{
foreach (QL_NguyenLieu_SanPham item in qlsp.QL_NguyenLieu_SanPhams.Where(t => t.MaSP == sp.MaSP))
{
QL_NguyenLieu nl = qlsp.QL_NguyenLieus.SingleOrDefault(t => t.MaNL == item.MaNL);
if (nl.SoLuong == 0)
{
return(false);
}
}
return(true);
}
// Thêm Nguyên liệu
public void themNguyenLieu(string maNL, string tenNL, string donVi, int soLuong, DateTime hanSD, string maLoaiNL)
{
QL_NguyenLieu nl = new QL_NguyenLieu();
nl.MaNL = maNL;
nl.TenNL = tenNL;
nl.DVT = donVi;
nl.SoLuong = soLuong;
nl.ThoiHan = hanSD;
nl.MaLoaiNL = maLoaiNL;
ff.QL_NguyenLieus.InsertOnSubmit(nl);
ff.SubmitChanges();
}
// Sửa nguyên liệu
public void suaNguyenLieu(string maNL, string tenNL, string donVi, int soLuong, DateTime hanSD, string maLoaiNL)
{
QL_NguyenLieu suaNL = ff.QL_NguyenLieus.Where(n => n.MaNL == maNL).FirstOrDefault();
if (suaNL != null)
{
suaNL.TenNL = tenNL;
suaNL.DVT = donVi;
suaNL.SoLuong = soLuong;
suaNL.ThoiHan = hanSD;
suaNL.MaLoaiNL = maLoaiNL;
ff.SubmitChanges();
}
}
private void btnThemNL_Click(object sender, EventArgs e)
{
if (gvNguyenLieu.SelectedRows == null)
{
MessageBox.Show("Chưa chọn nguyện liệu");
}
foreach (DataGridViewRow item in gvNguyenLieu.SelectedRows)
{
QL_NguyenLieu nl = lstNL.Single(t => t.MaNL == item.Cells["MaNL"].Value.ToString());
lstNLHienTai.Add(nl);
gvNL_SP.DataSource = loadNL_SP();
gvNguyenLieu.DataSource = lstNL_KoThuocSP();
}
}
public List <QL_NguyenLieu> lstNLCuaSP()
{
List <QL_NguyenLieu> lst = new List <QL_NguyenLieu>();
gvNL_SP.AllowUserToAddRows = false;
if (gvNL_SP.Rows.Count == 0)
{
gvNL_SP.AllowUserToAddRows = true;
return(lst);
}
foreach (DataGridViewRow item in gvNL_SP.Rows)
{
QL_NguyenLieu nl = lstNL.Single(t => t.MaNL == item.Cells["MaNL"].Value.ToString());
lst.Add(nl);
}
return(lst);
}
public void xuatKho(DateTime from, DateTime to)
{
// so luong sp
int slsp = 0;
// so luong nguyen lieu de lam ra sp
int slnl = 0;
List <QL_HoaDon_BanHang> lstHD = layDSHDTheoNgay(from, to);
foreach (QL_HoaDon_BanHang sp in lstHD)
{
if (sp.TinhTrang == true)
{
continue;
}
else
{
// lay tung san pham cua hoa don
foreach (QL_ChiTietHoaDon chitietHD in qlhd.QL_ChiTietHoaDons.Where(t => t.MaHD == sp.MaHD))
{
slsp = (int)chitietHD.Soluong;
// lay tung nguyen lieu cua san pham do
foreach (QL_NguyenLieu_SanPham nlsp in qlhd.QL_NguyenLieu_SanPhams.Where(t => t.MaSP == chitietHD.MaSP))
{
slnl = (int)nlsp.SoLuong;
QL_NguyenLieu nl = qlhd.QL_NguyenLieus.SingleOrDefault(t => t.MaNL == nlsp.MaNL);
nl.SoLuong -= slnl * slsp;
if (nl.SoLuong <= 0)
{
nl.SoLuong = 0;
}
}
}
sp.TinhTrang = true;
}
qlhd.SubmitChanges();
}
}