private void CreateReportReview()
{
hdfViewReport["view"] = 2;
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 = "";
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
#region khổ 80
oCusExport80 = new oReportBanHang80();
oCusExport80.TenChiNhanh = ".........................";
oCusExport80.DienThoai = ".........................";
oCusExport80.DiaChiChiNhanh = "(xem trước)";
oCusExport80.ThuNgan = Formats.NameUser();
oCusExport80.KhachHang = KH.HoTen;
oCusExport80.NgayBan = Formats.ConvertToVNDateString(DateTime.Now.ToString());
oCusExport80.MaPhieu = "275595";
oCusExport80.listProduct = new List <oChiTietBanHang80>();
#endregion
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);
#region khổ 80
oChiTietBanHang80 pro = new oChiTietBanHang80();
pro.TenHangHoa = Hang.TenHangHoa;
pro.SoLuong = Convert.ToInt32(Hang.SoLuong);
pro.DonGia = Convert.ToDouble(Hang.GiaBan);
pro.ThanhTien = Convert.ToDouble(Hang.ThanhTien);
oCusExport80.listProduct.Add(pro);
#endregion
}
oCusExport.TongTien = TongTien;
oCusExport80.TongTien = TongTien;
oCusExport80.GiamGia = Convert.ToDouble(spGiamGia.Number);
oCusExport80.KhachCanTra = Convert.ToDouble(spThanhToan.Number);
cbpInfoImport.JSProperties["cp_rpView"] = true;
}
protected void cbpViewReport_Callback(object sender, CallbackEventArgsBase e)
{
int IDPhieuGiaoHang = int.Parse(e.Parameter);
var PhieuGiaoHang = DBDataProvider.GetPhieuGiaoHang(IDPhieuGiaoHang);
//if (hdfViewReport["view"].ToString() != "3")
//{
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>();
#region khổ 80
oCusExport80 = new oReportBanHang80();
oCusExport80.TenChiNhanh = PhieuGiaoHang.chChiNhanh.TenChiNhanh;
oCusExport80.DienThoai = PhieuGiaoHang.chChiNhanh.DienThoai;
oCusExport80.DiaChiChiNhanh = PhieuGiaoHang.chChiNhanh.DiaChi;
oCusExport80.ThuNgan = PhieuGiaoHang.nvNhanVien.HoTen;
oCusExport80.KhachHang = PhieuGiaoHang.khKhachHang.HoTen;
oCusExport80.NgayBan = Formats.ConvertToVNDateString(PhieuGiaoHang.NgayGiao.ToString());
oCusExport80.TongTien = Convert.ToDouble(PhieuGiaoHang.TongTien);
oCusExport80.GiamGia = Convert.ToDouble(PhieuGiaoHang.GiamGia);
oCusExport80.MaPhieu = PhieuGiaoHang.MaPhieu;
oCusExport80.KhachCanTra = Convert.ToDouble((PhieuGiaoHang.TongTien - PhieuGiaoHang.GiamGia));
oCusExport80.listProduct = new List <oChiTietBanHang80>();
#endregion
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);
#region khổ 80
oChiTietBanHang80 pro = new oChiTietBanHang80();
pro.TenHangHoa = Hang.hhHangHoa.TenHangHoa;
pro.SoLuong = Convert.ToInt32(Hang.SoLuong);
pro.DonGia = Convert.ToDouble(Hang.GiaBan);
pro.ThanhTien = Convert.ToDouble(Hang.ThanhTien);
oCusExport80.listProduct.Add(pro);
#endregion
}
//}
//else
//{
// khổ 80
//}
}
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;
#region khổ 80
oCusExport80 = new oReportBanHang80();
oCusExport80.TenChiNhanh = PhieuGiaoHang.chChiNhanh.TenChiNhanh;
oCusExport80.DienThoai = PhieuGiaoHang.chChiNhanh.DienThoai;
oCusExport80.DiaChiChiNhanh = PhieuGiaoHang.chChiNhanh.DiaChi;
oCusExport80.ThuNgan = PhieuGiaoHang.nvNhanVien.HoTen;
oCusExport80.KhachHang = PhieuGiaoHang.khKhachHang.HoTen;
oCusExport80.NgayBan = Formats.ConvertToVNDateString(PhieuGiaoHang.NgayGiao.ToString());
oCusExport80.TongTien = Convert.ToDouble(PhieuGiaoHang.TongTien);
oCusExport80.GiamGia = Convert.ToDouble(PhieuGiaoHang.GiamGia);
oCusExport80.MaPhieu = PhieuGiaoHang.MaPhieu;
oCusExport80.KhachCanTra = Convert.ToDouble((PhieuGiaoHang.TongTien - PhieuGiaoHang.GiamGia));
oCusExport80.listProduct = new List <oChiTietBanHang80>();
#endregion
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);
#region khổ 80
oChiTietBanHang80 pro = new oChiTietBanHang80();
pro.TenHangHoa = Hang.hhHangHoa.TenHangHoa;
pro.SoLuong = Convert.ToInt32(Hang.SoLuong);
pro.DonGia = Convert.ToDouble(Hang.GiaBan);
pro.ThanhTien = Convert.ToDouble(Hang.ThanhTien);
oCusExport80.listProduct.Add(pro);
#endregion
}
cbpInfoImport.JSProperties["cp_rpView"] = true;
}
