public static void NhapKho(KaraokeEntities kara, BOChiTietNhapKho chitiet, BONhapKho nhapKho) { LICHSUTONKHO lichSuDauKy = (from a in kara.LICHSUTONKHOes where a.MonID == chitiet.MenuKichThuocMon.MenuKichThuocMon.MonID && a.KhoID == nhapKho.NhapKho.KhoID orderby a.ID descending select a).FirstOrDefault(); LICHSUTONKHO lichSu = new LICHSUTONKHO(); if (lichSuDauKy == null) { lichSu.DauKySoLuong = 0; lichSu.DauKyDonGia = 0; } else { lichSu.DauKySoLuong = lichSuDauKy.CuoiKySoLuong; lichSu.DauKyDonGia = lichSuDauKy.CuoiKyDonGia; } int soluong = chitiet.ChiTietNhapKho.SoLuongNhap * chitiet.MenuKichThuocMon.MenuKichThuocMon.KichThuocLoaiBan; lichSu.NhapSoLuong = soluong; lichSu.NhapDonGia = chitiet.ChiTietNhapKho.GiaNhap / chitiet.MenuKichThuocMon.MenuKichThuocMon.KichThuocLoaiBan; lichSu.CuoiKySoLuong = lichSu.DauKySoLuong + lichSu.NhapSoLuong; lichSu.CuoiKyDonGia = lichSu.CuoiKyDonGia; lichSu.NgayGhiNhan = DateTime.Now; lichSu.MonID = chitiet.MenuKichThuocMon.MenuKichThuocMon.MonID; lichSu.KhoID = nhapKho.NhapKho.KhoID; lichSu.LoaiPhatSinhID = 1; kara.LICHSUTONKHOes.AddObject(lichSu); }
public static void BanHang(KaraokeEntities kara, BOBanHang banhang) { foreach (var chitiet in banhang._ListChiTietBanHang) { int soluong = chitiet.ChiTietBanHang.SoLuongBan * chitiet.ChiTietBanHang.KichThuocLoaiBan; LICHSUTONKHO lichSuDauKy = (from a in kara.LICHSUTONKHOes where a.MonID == chitiet.MenuKichThuocMon.MonID orderby a.ID descending select a).FirstOrDefault(); LICHSUTONKHO lichSu = new LICHSUTONKHO(); if (lichSuDauKy == null) { lichSu.DauKySoLuong = 0; lichSu.DauKyDonGia = 0; } else { lichSu.DauKySoLuong = lichSuDauKy.CuoiKySoLuong; lichSu.DauKyDonGia = lichSuDauKy.CuoiKyDonGia; } lichSu.XuatSoLuong = soluong; lichSu.XuatDonGia = chitiet.ChiTietBanHang.GiaBan; lichSu.CuoiKySoLuong = lichSu.DauKySoLuong - lichSu.XuatSoLuong; lichSu.CuoiKyDonGia = lichSu.CuoiKyDonGia; lichSu.NgayGhiNhan = DateTime.Now; lichSu.MonID = chitiet.MenuKichThuocMon.MonID; lichSu.KhoID = banhang.KhoID; lichSu.LoaiPhatSinhID = 5; kara.LICHSUTONKHOes.AddObject(lichSu); } }
public static void ChuyenKho(KaraokeEntities kara, BOChuyenKho chuyenKho) { var ktm = (from a in kara.MENUKICHTHUOCMONs where a.MonID == chuyenKho.TonKho.MonID orderby a.KichThuocLoaiBan ascending select a).FirstOrDefault(); if (ktm != null) { int soluong = chuyenKho.SoLuong; //if (ktm.KichThuocLoaiBan>0) //{ // soluong = soluong / ktm.KichThuocLoaiBan; //} //kho di LICHSUTONKHO lichSuDauKyDi = (from a in kara.LICHSUTONKHOes where a.MonID == ktm.MonID && a.KhoID == chuyenKho.TonKho.KhoID orderby a.ID descending select a).FirstOrDefault(); LICHSUTONKHO lichSuDi = new LICHSUTONKHO(); if (lichSuDauKyDi == null) { lichSuDi.DauKySoLuong = 0; lichSuDi.DauKyDonGia = 0; } else { lichSuDi.DauKySoLuong = lichSuDauKyDi.CuoiKySoLuong; lichSuDi.DauKyDonGia = lichSuDauKyDi.CuoiKyDonGia; } lichSuDi.XuatSoLuong = soluong; lichSuDi.XuatDonGia = chuyenKho.TonKho.GiaNhap; lichSuDi.CuoiKySoLuong = lichSuDi.DauKySoLuong - lichSuDi.XuatSoLuong; lichSuDi.CuoiKyDonGia = lichSuDi.CuoiKyDonGia; lichSuDi.NgayGhiNhan = DateTime.Now; lichSuDi.MonID = ktm.MonID; lichSuDi.KhoID = chuyenKho.TonKho.KhoID; lichSuDi.LoaiPhatSinhID = 2; kara.LICHSUTONKHOes.AddObject(lichSuDi); //kho den LICHSUTONKHO lichSuDauKyDen = (from a in kara.LICHSUTONKHOes where a.MonID == ktm.MonID && a.KhoID == chuyenKho.KhoDenID orderby a.ID descending select a).FirstOrDefault(); LICHSUTONKHO lichSuDen = new LICHSUTONKHO(); if (lichSuDauKyDen == null) { lichSuDen.DauKySoLuong = 0; lichSuDen.DauKyDonGia = 0; } else { lichSuDen.DauKySoLuong = lichSuDauKyDen.CuoiKySoLuong; lichSuDen.DauKyDonGia = lichSuDauKyDen.CuoiKyDonGia; } lichSuDen.NhapSoLuong = soluong; lichSuDen.XuatDonGia = chuyenKho.TonKho.GiaNhap; lichSuDen.CuoiKySoLuong = lichSuDen.DauKySoLuong + lichSuDen.NhapSoLuong; lichSuDen.CuoiKyDonGia = lichSuDen.CuoiKyDonGia; lichSuDen.NgayGhiNhan = DateTime.Now; lichSuDen.MonID = ktm.MonID; lichSuDen.KhoID = chuyenKho.KhoDenID; lichSuDen.LoaiPhatSinhID = 2; kara.LICHSUTONKHOes.AddObject(lichSuDen); } }