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