protected void cbpViewReport_Callback(object sender, CallbackEventArgsBase e) { int IDPhieuTraHang = int.Parse(e.Parameter); var PhieuTraHang = DBDataProvider.GetPhieuTraHang_DaiLy(IDPhieuTraHang); oReturnNodeReport = new oReportGiaoHang(); oReturnNodeReport.MaKhachHang = PhieuTraHang.khKhachHang.MaKhachHang; oReturnNodeReport.TenKhachHang = PhieuTraHang.khKhachHang.HoTen; oReturnNodeReport.DienThoai = PhieuTraHang.khKhachHang.DienThoai; oReturnNodeReport.DiaChiGiaoHang = PhieuTraHang.khKhachHang.DiaChi; oReturnNodeReport.TenNhanVien = PhieuTraHang.nvNhanVien.HoTen; oReturnNodeReport.GhiChuGiaoHang = PhieuTraHang.GhiChu; oReturnNodeReport.NgayGiao = Formats.ConvertToVNDateString(PhieuTraHang.NgayTra.ToString()); oReturnNodeReport.NgayTao = Formats.ConvertToVNDateString(PhieuTraHang.NgayNhap.ToString()); oReturnNodeReport.TongTien = Convert.ToDouble(PhieuTraHang.TongTienHang); oReturnNodeReport.TieuDePhieu = "PHIẾU TRẢ HÀNG " + PhieuTraHang.STTDonHang; oReturnNodeReport.listProduct = new List <oProduct>(); List <kPhieuTraHangChiTiet> ListHang = DBDataProvider.ListChiTietTraHang_DaiLy(IDPhieuTraHang); int i = 1; foreach (var Hang in ListHang) { oProduct prod = new oProduct(); prod.STT = i++; prod.MaHang = Hang.hhHangHoa.MaHang; prod.TenHang = Hang.hhHangHoa.TenHangHoa; prod.TenDonViTinh = Hang.hhHangHoa.hhDonViTinh.TenDonViTinh; prod.SoLuong = Convert.ToInt32(Hang.SoLuong); prod.DonGia = Convert.ToDouble(Hang.TienTra); prod.ThanhTien = Convert.ToDouble(Hang.ThanhTien); oReturnNodeReport.listProduct.Add(prod); } }
protected void cbpViewReport_Callback(object sender, CallbackEventArgsBase e) { int IDPhieuGiaoHang = int.Parse(e.Parameter); var PhieuGiaoHang = DBDataProvider.GetPhieuGiaoHang(IDPhieuGiaoHang); oCusExport = new oReportGiaoHang(); oCusExport.MaKhachHang = PhieuGiaoHang.khKhachHang.MaKhachHang; oCusExport.TenKhachHang = PhieuGiaoHang.khKhachHang.HoTen; oCusExport.DienThoai = PhieuGiaoHang.DienThoai; oCusExport.DiaChiGiaoHang = PhieuGiaoHang.DiaChiGiaoHang; oCusExport.TenNhanVien = PhieuGiaoHang.nvNhanVien.HoTen; oCusExport.GhiChuGiaoHang = PhieuGiaoHang.GhiChuGiaoHang; oCusExport.NgayGiao = Formats.ConvertToVNDateString(PhieuGiaoHang.NgayGiao.ToString()); oCusExport.NgayTao = Formats.ConvertToVNDateString(PhieuGiaoHang.NgayTao.ToString()); oCusExport.TongSoLuong = Convert.ToInt32(PhieuGiaoHang.TongSoLuong); oCusExport.TongTien = Convert.ToDouble(PhieuGiaoHang.TongTien); oCusExport.ThanhToan = Convert.ToDouble(PhieuGiaoHang.ThanhToan); oCusExport.CongNoHienTai = Convert.ToDouble(PhieuGiaoHang.CongNoHienTai); oCusExport.SoHoaDon = PhieuGiaoHang.SoHoaDon; oCusExport.GiamGia = Convert.ToDouble(PhieuGiaoHang.GiamGia); oCusExport.SoDonHangTrongNam = PhieuGiaoHang.SoDonHangTrongNam.ToString(); oCusExport.TieuDePhieu = "PHIẾU BÁN HÀNG " + PhieuGiaoHang.STTDonHang; string TrangThai = ""; switch (PhieuGiaoHang.TrangThai) { case 0: TrangThai = "(Đã đặt)"; break; case 1: TrangThai = "(Kiêm phiếu xuất kho)"; break; case 3: TrangThai = "(Kiêm phiếu xuất kho)"; break; default: TrangThai = "(Đã hủy)"; break; } oCusExport.TrangThaiPhieu = TrangThai; oCusExport.listProduct = new List <oProduct>(); List <ghPhieuGiaoHangChiTiet> ListHang = DBDataProvider.ListChiTietGiaoHang(IDPhieuGiaoHang); int i = 1; foreach (var Hang in ListHang) { oProduct prod = new oProduct(); prod.STT = i++; prod.MaHang = Hang.hhHangHoa.MaHang; prod.TenHang = Hang.hhHangHoa.TenHangHoa; prod.TenDonViTinh = Hang.hhHangHoa.hhDonViTinh.TenDonViTinh; prod.SoLuong = Convert.ToInt32(Hang.SoLuong); prod.DonGia = Convert.ToDouble(Hang.GiaBan); prod.ThanhTien = Convert.ToDouble(Hang.ThanhTien); oCusExport.listProduct.Add(prod); } }
private void CreateReportReview() { hdfViewReport["view"] = 1; oCusExport = new oReportGiaoHang(); var KH = DBDataProvider.DB.khKhachHangs.Where(x => x.IDKhachHang == Convert.ToInt32(ccbNhaCungCap.Value.ToString())).FirstOrDefault(); oCusExport.MaKhachHang = KH.MaKhachHang; oCusExport.TenKhachHang = KH.HoTen; oCusExport.DienThoai = KH.DienThoai; oCusExport.DiaChiGiaoHang = KH.DiaChi; oCusExport.TenNhanVien = Formats.NameUser(); oCusExport.GhiChuGiaoHang = memoGhiChu.Text; oCusExport.NgayGiao = Formats.ConvertToVNDateString(dateNgayNhap.Text); oCusExport.NgayTao = Formats.ConvertToVNDateString(DateTime.Now.ToString()); oCusExport.GiamGia = Convert.ToDouble(spGiamGia.Number); oCusExport.CongNoHienTai = Convert.ToDouble(KH.CongNo); oCusExport.SoDonHangTrongNam = "....."; oCusExport.TieuDePhieu = "PHIẾU BÁN HÀNG "; oCusExport.TrangThaiPhieu = "(Xem trước)"; oCusExport.listProduct = new List <oProduct>(); oCusExport.ThanhToan = Convert.ToDouble(spKhachHangThoan.Number);// khách thanh toán int i = 1; double TongTien = 0; foreach (var Hang in listReceiptProducts) { TongTien += Hang.ThanhTien; oProduct prod = new oProduct(); prod.STT = i++; prod.MaHang = Hang.MaHang; prod.TenHang = Hang.TenHangHoa; prod.TenDonViTinh = Hang.TenDonViTinh; prod.SoLuong = Convert.ToInt32(Hang.SoLuong); prod.DonGia = Convert.ToDouble(Hang.GiaBan); prod.ThanhTien = Convert.ToDouble(Hang.ThanhTien); oCusExport.listProduct.Add(prod); } oCusExport.TongTien = TongTien; cbpInfoImport.JSProperties["cp_rpView"] = true; }
private void CreateReportReview_Save(int IDPhieu) { hdfViewReport["view"] = 1; var PhieuGiaoHang = DBDataProvider.GetPhieuGiaoHang(IDPhieu); oCusExport = new oReportGiaoHang(); oCusExport.MaKhachHang = PhieuGiaoHang.khKhachHang.MaKhachHang; oCusExport.TenKhachHang = PhieuGiaoHang.khKhachHang.HoTen; oCusExport.DienThoai = PhieuGiaoHang.DienThoai; oCusExport.DiaChiGiaoHang = PhieuGiaoHang.DiaChiGiaoHang; oCusExport.TenNhanVien = PhieuGiaoHang.nvNhanVien.HoTen; oCusExport.GhiChuGiaoHang = PhieuGiaoHang.GhiChuGiaoHang; oCusExport.NgayGiao = Formats.ConvertToVNDateString(PhieuGiaoHang.NgayGiao.ToString()); oCusExport.NgayTao = Formats.ConvertToVNDateString(PhieuGiaoHang.NgayTao.ToString()); oCusExport.TongSoLuong = Convert.ToInt32(PhieuGiaoHang.TongSoLuong); oCusExport.TongTien = Convert.ToDouble(PhieuGiaoHang.TongTien); oCusExport.ThanhToan = Convert.ToDouble(PhieuGiaoHang.ThanhToan); oCusExport.CongNoHienTai = Convert.ToDouble(PhieuGiaoHang.CongNoHienTai); oCusExport.SoHoaDon = PhieuGiaoHang.SoHoaDon; oCusExport.GiamGia = Convert.ToDouble(PhieuGiaoHang.GiamGia); oCusExport.SoDonHangTrongNam = PhieuGiaoHang.SoDonHangTrongNam.ToString(); oCusExport.TieuDePhieu = "PHIẾU BÁN HÀNG " + PhieuGiaoHang.STTDonHang; string TrangThai = ""; switch (PhieuGiaoHang.TrangThai) { case 0: TrangThai = "(Đã đặt)"; break; case 1: TrangThai = "(Kiêm phiếu xuất kho)"; break; case 3: TrangThai = "(Kiêm phiếu xuất kho)"; break; default: TrangThai = "(Đã hủy)"; break; } oCusExport.TrangThaiPhieu = TrangThai; oCusExport.listProduct = new List <oProduct>(); List <ghPhieuGiaoHangChiTiet> ListHang = DBDataProvider.ListChiTietGiaoHang(IDPhieu); int i = 1; foreach (var Hang in ListHang) { oProduct prod = new oProduct(); prod.STT = i++; prod.MaHang = Hang.hhHangHoa.MaHang; prod.TenHang = Hang.hhHangHoa.TenHangHoa; prod.TenDonViTinh = Hang.hhHangHoa.hhDonViTinh.TenDonViTinh; prod.SoLuong = Convert.ToInt32(Hang.SoLuong); prod.DonGia = Convert.ToDouble(Hang.GiaBan); prod.ThanhTien = Convert.ToDouble(Hang.ThanhTien); oCusExport.listProduct.Add(prod); } cbpInfoImport.JSProperties["cp_rpView"] = true; }