/// <summary> /// Lưu thông tin giá đặc biệt /// </summary> /// <param name="KhachHangID"></param> /// <param name="isPhanTram"></param> /// <param name="SH"></param> /// <param name="KD"></param> /// <param name="HC"></param> /// <param name="CC"></param> /// <param name="SX"></param> /// <param name="month"></param> /// <param name="year"></param> public void saveGiaDacBiet(int KhachHangID, double SH, double KD, double HC, double CC, double SX, double SH1, double SH2, double SH3, double SH4, int month, int year) { HoaDonHaDongEntities db = new HoaDonHaDongEntities(); //xóa record ứng với áp giá tổng hợp của khách hàng đó db.Apgiatonghops.RemoveRange(db.Apgiatonghops.Where(p => p.KhachhangID == KhachHangID && p.ThangTongHop == month && p.NamTongHop == year)); if (KD != -1) { Apgiatonghop apTongHopKD = new Apgiatonghop(); apTongHopKD.KhachhangID = KhachHangID; apTongHopKD.IsDelete = false; apTongHopKD.IDLoaiApGia = KhachHang.KINHDOANHDICHVU; //KD apTongHopKD.SanLuong = KD; apTongHopKD.NamTongHop = year; apTongHopKD.ThangTongHop = month; db.Apgiatonghops.Add(apTongHopKD); } if (HC != -1) { Apgiatonghop apTongHopHC = new Apgiatonghop(); apTongHopHC.KhachhangID = KhachHangID; apTongHopHC.IsDelete = false; apTongHopHC.IDLoaiApGia = KhachHang.COQUANHANHCHINH; //HC apTongHopHC.SanLuong = HC; apTongHopHC.NamTongHop = year; apTongHopHC.ThangTongHop = month; db.Apgiatonghops.Add(apTongHopHC); } if (CC != -1) { Apgiatonghop apTongHopCC = new Apgiatonghop(); apTongHopCC.KhachhangID = KhachHangID; apTongHopCC.IsDelete = false; apTongHopCC.IDLoaiApGia = KhachHang.DONVISUNGHIEP; //CC apTongHopCC.SanLuong = CC; apTongHopCC.NamTongHop = year; apTongHopCC.ThangTongHop = month; db.Apgiatonghops.Add(apTongHopCC); } if (SX != -1) { Apgiatonghop apTongHopSX = new Apgiatonghop(); apTongHopSX.KhachhangID = KhachHangID; apTongHopSX.IsDelete = false; apTongHopSX.IDLoaiApGia = KhachHang.SANXUAT; //SX apTongHopSX.SanLuong = SX; apTongHopSX.NamTongHop = year; apTongHopSX.ThangTongHop = month; db.Apgiatonghops.Add(apTongHopSX); } if (SH != -1) { Apgiatonghop apTongHop = new Apgiatonghop(); apTongHop.KhachhangID = KhachHangID; apTongHop.IsDelete = false; apTongHop.IDLoaiApGia = KhachHang.SINHHOAT; //SH apTongHop.SanLuong = SH; apTongHop.NamTongHop = year; apTongHop.ThangTongHop = month; db.Apgiatonghops.Add(apTongHop); } if (SH1 != -1) { Apgiatonghop apTongHop = new Apgiatonghop(); apTongHop.KhachhangID = KhachHangID; apTongHop.IsDelete = false; apTongHop.IDLoaiApGia = KhachHang.SH1; //SH apTongHop.SanLuong = SH1; apTongHop.NamTongHop = year; apTongHop.ThangTongHop = month; db.Apgiatonghops.Add(apTongHop); } if (SH2 != -1) { Apgiatonghop apTongHop = new Apgiatonghop(); apTongHop.KhachhangID = KhachHangID; apTongHop.IsDelete = false; apTongHop.IDLoaiApGia = KhachHang.SH2; //SH apTongHop.SanLuong = SH2; apTongHop.NamTongHop = year; apTongHop.ThangTongHop = month; db.Apgiatonghops.Add(apTongHop); } if (SH3 != -1) { Apgiatonghop apTongHop = new Apgiatonghop(); apTongHop.KhachhangID = KhachHangID; apTongHop.IsDelete = false; apTongHop.IDLoaiApGia = KhachHang.SH3; //SH apTongHop.SanLuong = SH3; apTongHop.NamTongHop = year; apTongHop.ThangTongHop = month; db.Apgiatonghops.Add(apTongHop); } if (SH4 != -1) { Apgiatonghop apTongHop = new Apgiatonghop(); apTongHop.KhachhangID = KhachHangID; apTongHop.IsDelete = false; apTongHop.IDLoaiApGia = KhachHang.SH4; //SH apTongHop.SanLuong = SH4; apTongHop.NamTongHop = year; apTongHop.ThangTongHop = month; db.Apgiatonghops.Add(apTongHop); } db.SaveChanges(); }
/// <summary> /// Lưu chỉ số tổng hợp cho khách hàng /// </summary> /// <param name="KhachHangID"></param> /// <param name="isPhanTram"></param> /// <param name="SH"></param> /// <param name="KD"></param> /// <param name="SX"></param> public void saveGiaTongHop(int KhachHangID, byte isPhanTram, double SH, double KD, double HC, double CC, double SX, int month, short year) { HoaDonHaDongEntities _db = new HoaDonHaDongEntities(); _db.Apgiatonghops.RemoveRange(_db.Apgiatonghops.Where(p => p.KhachhangID == KhachHangID).ToList()); if (KD != -1) { Apgiatonghop apTongHopKD = new Apgiatonghop(); apTongHopKD.KhachhangID = KhachHangID; apTongHopKD.IsDelete = false; apTongHopKD.CachTinh = isPhanTram; apTongHopKD.IDLoaiApGia = KhachHang.KINHDOANHDICHVU; //KD apTongHopKD.SanLuong = KD; apTongHopKD.NamTongHop = year; apTongHopKD.ThangTongHop = month; _db.Apgiatonghops.Add(apTongHopKD); _db.SaveChanges(); } if (HC != -1) { Apgiatonghop apTongHopHC = new Apgiatonghop(); apTongHopHC.KhachhangID = KhachHangID; apTongHopHC.IsDelete = false; apTongHopHC.CachTinh = isPhanTram; apTongHopHC.IDLoaiApGia = KhachHang.COQUANHANHCHINH; //HC apTongHopHC.SanLuong = HC; apTongHopHC.NamTongHop = year; apTongHopHC.ThangTongHop = month; _db.Apgiatonghops.Add(apTongHopHC); _db.SaveChanges(); } if (CC != -1) { Apgiatonghop apTongHopCC = new Apgiatonghop(); apTongHopCC.KhachhangID = KhachHangID; apTongHopCC.IsDelete = false; apTongHopCC.CachTinh = isPhanTram; apTongHopCC.IDLoaiApGia = KhachHang.DONVISUNGHIEP; //CC apTongHopCC.SanLuong = CC; apTongHopCC.NamTongHop = year; apTongHopCC.ThangTongHop = month; _db.Apgiatonghops.Add(apTongHopCC); _db.SaveChanges(); } if (SX != -1) { Apgiatonghop apTongHopSX = new Apgiatonghop(); apTongHopSX.KhachhangID = KhachHangID; apTongHopSX.IsDelete = false; apTongHopSX.CachTinh = isPhanTram; apTongHopSX.IDLoaiApGia = KhachHang.SANXUAT; //SX apTongHopSX.SanLuong = SX; apTongHopSX.NamTongHop = year; apTongHopSX.ThangTongHop = month; _db.Apgiatonghops.Add(apTongHopSX); _db.SaveChanges(); } if (SH != -1) { Apgiatonghop apTongHop = new Apgiatonghop(); apTongHop.KhachhangID = KhachHangID; apTongHop.IsDelete = false; apTongHop.CachTinh = isPhanTram; apTongHop.IDLoaiApGia = KhachHang.SINHHOAT; //SH apTongHop.SanLuong = SH; apTongHop.NamTongHop = year; apTongHop.ThangTongHop = month; _db.Apgiatonghops.Add(apTongHop); _db.SaveChanges(); } }