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