public Entities.BCHDBanBuon[] Select(Entities.BCHDBanBuon bchdbl)
{
//Insert Category into ArrayList
ArrayList arr = new ArrayList();
Entities.ChiTietHDBanHang chitiet = new Entities.ChiTietHDBanHang();
chitiet.MaHDBanHang = bchdbl.MaHDBanHang;
Entities.ChiTietHDBanHang[] chitiethdbanhang = new BizLogic.ChiTietHDBanHang().Select(chitiet);
foreach (Entities.ChiTietHDBanHang ite in chitiethdbanhang)
{
Entities.BCHDBanBuon bcdttg1 = new Entities.BCHDBanBuon();
bcdttg1.MaHDBanHang = ite.MaHDBanHang;
bcdttg1.TenHangHoa = ite.TenHangHoa;
bcdttg1.SoLuong = ite.SoLuong;
bcdttg1.GiaBanBuon = int.Parse(ite.DonGia);
bcdttg1.ChietKhau = ite.PhanTramChietKhau.ToString();
bcdttg1.Thue = ite.Thue;
bcdttg1.TongTienThanhToan = bcdttg1.SoLuong * bcdttg1.GiaBanBuon;
arr.Add(bcdttg1);
}
int n = arr.Count;
if (n == 0) return null;
Entities.BCHDBanBuon[] arrC = new Entities.BCHDBanBuon[n];
for (int i = 0; i < n; i++)
{
arrC[i] = (Entities.BCHDBanBuon)arr[i];
}
return arrC;
}
public Entities.BCHDBanBuon[] Select(Entities.BCHDBanBuon bchdbl)
{
//Insert Category into ArrayList
ArrayList arr = new ArrayList();
Entities.ChiTietHDBanHang chitiet = new Entities.ChiTietHDBanHang();
chitiet.MaHDBanHang = bchdbl.MaHDBanHang;
Entities.ChiTietHDBanHang[] chitiethdbanhang = new BizLogic.ChiTietHDBanHang().Select(chitiet);
foreach (Entities.ChiTietHDBanHang ite in chitiethdbanhang)
{
Entities.BCHDBanBuon bcdttg1 = new Entities.BCHDBanBuon();
bcdttg1.MaHDBanHang = ite.MaHDBanHang;
bcdttg1.TenHangHoa = ite.TenHangHoa;
bcdttg1.SoLuong = ite.SoLuong;
bcdttg1.GiaBanBuon = int.Parse(ite.DonGia);
bcdttg1.ChietKhau = ite.PhanTramChietKhau.ToString();
bcdttg1.Thue = ite.Thue;
bcdttg1.TongTienThanhToan = bcdttg1.SoLuong * bcdttg1.GiaBanBuon;
arr.Add(bcdttg1);
}
int n = arr.Count;
if (n == 0)
{
return(null);
}
Entities.BCHDBanBuon[] arrC = new Entities.BCHDBanBuon[n];
for (int i = 0; i < n; i++)
{
arrC[i] = (Entities.BCHDBanBuon)arr[i];
}
return(arrC);
}
public frmBaoCaorpt(string hanhDong, string maHDBanHang, double chietKhau, string khachTra, string soDU, string thanhTien, string GTGT, string tenNhanVien, string HanhDong, string datetime, string giatrithe, string giaTriTheGT, string path, string chietKhauTongHD, string diaChiNguoiNhan, string tenNguoiNhan, string ghiChu)
{
try
{
InitializeComponent();
CongTy();
switch (hanhDong)
{
case "HDBanLe":
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.BCHDBanLe ctxh = new Entities.BCHDBanLe("Select", maHDBanHang);
Entities.BCHDBanLe[] pt1 = new Entities.BCHDBanLe[1];
clientstrem = cl.SerializeObj(this.client1, "BCHDBanHang", ctxh);
pt1 = (Entities.BCHDBanLe[])cl.DeserializeHepper1(clientstrem, pt1);
if (pt1 == null)
{
MessageBox.Show("Không có dữ liệu", "Hệ thống cảnh báo");
return;
}
bool tv = giatrithe.Equals("0");
bool tgt = giaTriTheGT.Equals("0");
bool ck = chietKhau.ToString().Equals("0");
bool ck2 = chietKhauTongHD.Equals("0");
bool vat = GTGT.Equals("0");
// hien thi khong co gi ca
if (tv && tgt && ck && ck2 && vat)
{
GUI.Report.rptHDBanLe2 report = new GUI.Report.rptHDBanLe2();
report.SetDataSource(pt1);
report.SetParameterValue("HeaderName", CT.TenCongTy);
report.SetParameterValue("DiaChi", CT.DiaChi);
report.SetParameterValue("DienThoai", "ĐT: " + CT.SoDienThoai);
report.SetParameterValue("Date", datetime);
report.SetParameterValue("ChietKhau", new Common.Utilities().FormatMoney(Convert.ToDouble(chietKhau)));
report.SetParameterValue("Footer", "Cám Ơn Quý Khách Và Hẹn Gặp Lại");
report.SetParameterValue("GTGT", Convert.ToDouble(GTGT));
report.SetParameterValue("TenNhanVien", Common.Utilities.User.TenNhanVien);
report.SetParameterValue("VietBangChu", new ChuyenDoi().Convert(String.Format("{0:0}", Convert.ToDouble(thanhTien)).ToString().Trim(), ',', "phẩy").Replace(",", "") + " đồng");
report.SetParameterValue("giatrithe", new Common.Utilities().FormatMoney(double.Parse(giatrithe)));
report.SetParameterValue("GiaTriTheGT", new Common.Utilities().FormatMoney(double.Parse(giaTriTheGT)));
report.SetParameterValue("ChietKhauTongHD", new Common.Utilities().FormatMoney(Convert.ToDouble(chietKhauTongHD)));
report.SetParameterValue("TienTra", new Common.Utilities().FormatMoney(double.Parse(thanhTien)));
report.SetParameterValue("KhachTra", new Common.Utilities().FormatMoney(double.Parse(khachTra)));
report.SetParameterValue("SoDu", new Common.Utilities().FormatMoney(double.Parse(soDU)));
if (HanhDong == "in")
{
Print(report);
}
else
{
crvReport.ReportSource = report;
crvReport.Show();
}
}
// Hien thi day du
else
{
GUI.Report.rptHDBanLe report = new GUI.Report.rptHDBanLe();
report.SetDataSource(pt1);
report.SetParameterValue("HeaderName", CT.TenCongTy);
report.SetParameterValue("DiaChi", CT.DiaChi);
report.SetParameterValue("DienThoai", "ĐT: " + CT.SoDienThoai);
report.SetParameterValue("Date", datetime);
report.SetParameterValue("ChietKhau", new Common.Utilities().FormatMoney(Convert.ToDouble(chietKhau)));
report.SetParameterValue("Footer", "Cám Ơn Quý Khách Và Hẹn Gặp Lại");
report.SetParameterValue("GTGT", Convert.ToDouble(GTGT));
report.SetParameterValue("TenNhanVien", Common.Utilities.User.TenNhanVien);
report.SetParameterValue("VietBangChu", new ChuyenDoi().Convert(String.Format("{0:0}", Convert.ToDouble(thanhTien)).ToString().Trim(), ',', "phẩy").Replace(",", "") + " đồng");
report.SetParameterValue("giatrithe", new Common.Utilities().FormatMoney(double.Parse(giatrithe)));
report.SetParameterValue("GiaTriTheGT", new Common.Utilities().FormatMoney(double.Parse(giaTriTheGT)));
report.SetParameterValue("ChietKhauTongHD", new Common.Utilities().FormatMoney(Convert.ToDouble(chietKhauTongHD)));
report.SetParameterValue("TienTra", new Common.Utilities().FormatMoney(double.Parse(thanhTien)));
report.SetParameterValue("KhachTra", new Common.Utilities().FormatMoney(double.Parse(khachTra)));
report.SetParameterValue("SoDu", new Common.Utilities().FormatMoney(double.Parse(soDU)));
if (HanhDong == "in")
{
Print(report);
}
else
{
crvReport.ReportSource = report;
crvReport.Show();
}
}
break;
}
case "HDBanBuon":
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.BCHDBanBuon ctxh = new Entities.BCHDBanBuon("Select", maHDBanHang);
Entities.BCHDBanBuon[] pt1 = new Entities.BCHDBanBuon[1];
clientstrem = cl.SerializeObj(this.client1, "BCHDBanBuon", ctxh);
pt1 = (Entities.BCHDBanBuon[])cl.DeserializeHepper1(clientstrem, pt1);
if (pt1 == null)
{
MessageBox.Show("Không có dữ liệu", "Hệ thống cảnh báo");
return;
}
bool vat = GTGT.Equals("0");
// Khi khong co Thue VAT
if (vat)
{
foreach (Entities.BCHDBanBuon item in pt1)
{
item.NgayBan = DateTime.Parse(new Common.Utilities().MyDateConversion(datetime));
}
GUI.Report.rptBCHDBanBuon2 report = new GUI.Report.rptBCHDBanBuon2();
report.SetDataSource(pt1);
report.SetParameterValue("TenCongTy", CT.TenCongTy);
report.SetParameterValue("DiaChiCongTy", CT.DiaChi);
report.SetParameterValue("Web", CT.Website);
report.SetParameterValue("FaxCongTy", CT.Fax);
report.SetParameterValue("Email", CT.Email);
report.SetParameterValue("DienThoai", CT.SoDienThoai);
report.SetParameterValue("ChietKhau", chietKhau);
report.SetParameterValue("GTGT", new Common.Utilities().FormatMoney(Convert.ToDouble(GTGT)));
report.SetParameterValue("TenBaoCao", "Phiếu Xuất Kho");
report.SetParameterValue("NgayTao", datetime);
report.SetParameterValue("ThanhTien", new Common.Utilities().FormatMoney(Convert.ToDouble(thanhTien)));
report.SetParameterValue("ChietKhauTongHD", new Common.Utilities().FormatMoney(Convert.ToDouble(chietKhauTongHD)));
report.SetParameterValue("VietBangChu", new ChuyenDoi().Convert(String.Format("{0:0}", Convert.ToDouble(thanhTien)).ToString().Trim(), ',', "phẩy").Replace(",", "") + " đồng");
report.SetParameterValue("DiaChiNguoiNhan", diaChiNguoiNhan);
report.SetParameterValue("TenNguoiNhan", tenNguoiNhan);
report.SetParameterValue("GhiChu", ghiChu);
report.SetParameterValue("TenNhanVien", Common.Utilities.User.TenNhanVien);
if (HanhDong == "in")
{
Print(report);
}
else if (HanhDong == "Word")
{
new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.WordForWindows);
}
else if (HanhDong == "PDF")
{
new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.PortableDocFormat);
}
else if (HanhDong == "Excel")
{
new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.Excel);
}
else
{
crvReport.ReportSource = report;
crvReport.Show();
}
}
// Co Thue VAT
else
{
foreach (Entities.BCHDBanBuon item in pt1)
{
item.NgayBan = DateTime.Parse(new Common.Utilities().MyDateConversion(datetime));
}
GUI.Report.rptBCHDBanBuon report = new GUI.Report.rptBCHDBanBuon();
report.SetDataSource(pt1);
report.SetParameterValue("TenCongTy", CT.TenCongTy);
report.SetParameterValue("DiaChiCongTy", CT.DiaChi);
report.SetParameterValue("Web", CT.Website);
report.SetParameterValue("FaxCongTy", CT.Fax);
report.SetParameterValue("Email", CT.Email);
report.SetParameterValue("DienThoai", CT.SoDienThoai);
report.SetParameterValue("ChietKhau", chietKhau);
report.SetParameterValue("GTGT", new Common.Utilities().FormatMoney(Convert.ToDouble(GTGT)));
report.SetParameterValue("TenBaoCao", "Phiếu Xuất Kho");
report.SetParameterValue("NgayTao", datetime);
report.SetParameterValue("ThanhTien", new Common.Utilities().FormatMoney(Convert.ToDouble(thanhTien)));
report.SetParameterValue("ChietKhauTongHD", new Common.Utilities().FormatMoney(Convert.ToDouble(chietKhauTongHD)));
report.SetParameterValue("VietBangChu", new ChuyenDoi().Convert(String.Format("{0:0}", Convert.ToDouble(thanhTien)).ToString().Trim(), ',', "phẩy").Replace(",", "") + " đồng");
report.SetParameterValue("DiaChiNguoiNhan", diaChiNguoiNhan);
report.SetParameterValue("TenNguoiNhan", tenNguoiNhan);
report.SetParameterValue("GhiChu", ghiChu);
report.SetParameterValue("TenNhanVien", Common.Utilities.User.TenNhanVien);
if (HanhDong == "in")
{
Print(report);
}
else if (HanhDong == "Word")
{
new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.WordForWindows);
}
else if (HanhDong == "PDF")
{
new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.PortableDocFormat);
}
else if (HanhDong == "Excel")
{
new GUI.Report.ExportCrystalReport().Export(report, path, Report.ExportCrystalReport.TypeBC.Excel);
}
else
{
crvReport.ReportSource = report;
crvReport.Show();
}
}
break;
}
}
}
catch { }
}
