0 System.Data.DataSet /* Local Connection */ 4d8d8497-a769-4a36-85a1-28ae8a31eaf9 DataSet1 /* Local Query */ order_day System.String order_id System.String customer_name System.String product_name System.String product_price System.String product_quantity System.String recyele_quantity System.String collect_money System.String collect_OK System.String subtotal System.String total System.String product_index System.String morningorafternoon System.String customer_id System.String floor System.String floor_quantity System.String untaxed_amount System.String tax_amount System.String DataSet1 C:\Users\gj94e\Desktop\超好企業系統\超好企業系統\DataSet1.xsd DataTable5 DataSet1 /* Local Query */ floor System.String morningorafternoon System.String product_quantity System.String DataSet1 C:\Users\gj94e\Desktop\超好企業系統\超好企業系統\DataSet1.xsd DataTable7 0.53894cm 3.22761cm 1.31863cm 0.90925cm 0.90925cm 1.37537cm 0.97467cm 1.25904cm 1.34154cm 1.23586cm 1.24764cm 0.54708cm true true 序 Textbox41 0.5pt Middle 2pt 2pt 2pt 2pt true true 商品名稱 Textbox3 0.5pt Middle 2pt 2pt 2pt 2pt true true 單價 Textbox5 0.5pt Middle 2pt 2pt 2pt 2pt true true 送瓶 Textbox7 0.5pt Middle 2pt 2pt 2pt 2pt true true 收空 Textbox16 0.5pt Middle 2pt 2pt 2pt 2pt true true 扣單別 Textbox35 0.5pt Middle 2pt 2pt 2pt 2pt true true 收款 Textbox37 0.5pt Middle 2pt 2pt 2pt 2pt true true 應收 Textbox20 0.5pt Middle 2pt 2pt 2pt 2pt true true 實收 Textbox39 0.5pt Middle 2pt 2pt 2pt 2pt true true 稅前 Textbox4 0.5pt Middle 2pt 2pt 2pt 2pt true true 稅額 Textbox8 0.5pt Middle 2pt 2pt 2pt 2pt 0.67056cm true true =Fields!product_index.Value product_index 0.5pt Middle 2pt 2pt 2pt 2pt true =Fields!product_name.Value product_name 0.5pt Middle 2pt 2pt 2pt 2pt true true =Fields!product_price.Value product_price 0.5pt Middle 2pt 2pt 2pt 2pt true true =Fields!product_quantity.Value product_quantity 0.5pt Middle 2pt 2pt 2pt 2pt true true =IIf(Fields!product_index.Value > 1, "0", Fields!recyele_quantity.Value) recyele_quantity 0.5pt Middle 2pt 2pt 2pt 2pt true true =Fields!collect_money.Value collect_money 0.5pt Middle 2pt 2pt 2pt 2pt true true =Fields!collect_OK.Value collect_OK 0.5pt Middle 2pt 2pt 2pt 2pt true true =Fields!subtotal.Value subtotal 0.5pt Middle 2pt 2pt 2pt 2pt true true =Fields!total.Value total 0.5pt Middle 2pt 2pt 2pt 2pt true true =Fields!untaxed_amount.Value untaxed_amount 0.5pt Middle 2pt 2pt 2pt 2pt true true =Fields!tax_amount.Value tax_amount 0.5pt Middle 2pt 2pt 2pt 2pt 0.65291cm true true =Switch(Fields!morningorafternoon.Value = "上午", "上午收瓶："+Parameters!recyele_quantity_morning.Value, Fields!morningorafternoon.Value = "下午", "下午收瓶："+Parameters!recyele_quantity_afternoon.Value) Textbox119 0.5pt Middle 2pt 2pt 2pt 2pt 2 true true =Switch(Fields!morningorafternoon.Value = "上午", "上午紙箱："+Parameters!unback_product_quantity_morning.Value, Fields!morningorafternoon.Value = "下午", "下午紙箱："+Parameters!unback_product_quantity_afternoon.Value) Textbox2 0.5pt Middle 2pt 2pt 2pt 2pt 4 true true =Fields!morningorafternoon.Value + "現金：" + CStr(SUM(IIf(Fields!collect_money.Value <> "支票", CInt(Fields!total.Value), 0))) Textbox14 0.5pt Middle 2pt 2pt 2pt 2pt 5 0.67056cm true true Textbox15 0.5pt Middle 2pt 2pt 2pt 2pt 2 true true Textbox18 0.5pt Middle 2pt 2pt 2pt 2pt 4 true true =Fields!morningorafternoon.Value + "支票：" + CStr(SUM(IIf(Fields!collect_money.Value = "支票", CInt(Fields!total.Value), 0))) Textbox24 0.5pt Middle 2pt 2pt 2pt 2pt 5 0.6441cm true true ="總收瓶：" + Parameters!recyele_quantity_total.Value Textbox105 0.5pt Middle 2pt 2pt 2pt 2pt 2 true true ="紙箱數量：" + Parameters!unback_product_quantity_total.Value Textbox127 0.5pt Middle 2pt 2pt 2pt 2pt 4 true true ="總現金金額：" + Parameters!total_money.Value Textbox19 0.5pt Middle 2pt 2pt 2pt 2pt 5 0.63528cm true true Textbox38 0.5pt Middle 2pt 2pt 2pt 2pt 2 true true Textbox42 0.5pt Middle 2pt 2pt 2pt 2pt 4 true true ="總支票金額：" + Parameters!total_cheque.Value Textbox46 0.5pt Middle 2pt 2pt 2pt 2pt 5 2.60163cm true true 客戶編號 Textbox99 0.5pt Middle 2pt 2pt 2pt 2pt 2.21455cm true true 客戶名稱 Textbox101 0.5pt Middle 2pt 2pt 2pt 2pt true After true =Fields!morningorafternoon.Value Between =Fields!order_day.Value =Fields!customer_id.Value =Fields!order_id.Value 2.60163cm true true =Fields!customer_id.Value customer_id 0.5pt Middle 2pt 2pt 2pt 2pt =Fields!customer_name.Value =Fields!customer_name.Value 2.21455cm true =Fields!customer_name.Value customer_name1 0.5pt Middle 2pt 2pt 2pt 2pt 4.81618cm true true =Switch(Fields!morningorafternoon.Value = "上午", "上午送瓶："+Parameters!product_quantity_morning.Value, Fields!morningorafternoon.Value = "下午", "下午送瓶："+Parameters!product_quantity_afternoon.Value) Textbox123 0.5pt Middle 2pt 2pt 2pt 2pt Before 4.81618cm true true Textbox11 0.5pt Middle 2pt 2pt 2pt 2pt Before 4.81618cm true true ="總送瓶：" + Parameters!product_quantity_total.Value Textbox103 0.5pt Middle 2pt 2pt 2pt 2pt Before 4.81618cm true true Textbox34 0.5pt Middle 2pt 2pt 2pt 2pt Before DataSet1 3.82049cm 19.15398cm Center 1.8398cm 1.8398cm 2.1573cm 0.66146cm true true 樓層 Textbox1 0.5pt Middle 2pt 2pt 2pt 2pt true true 數量 Textbox6 0.5pt Middle 2pt 2pt 2pt 2pt true true 上午／下午 Textbox10 0.5pt Middle 2pt 2pt 2pt 2pt 0.74965cm true true =Fields!floor.Value floor 0.5pt Middle 2pt 2pt 2pt 2pt true true =Fields!product_quantity.Value product_quantity1 0.5pt Middle 2pt 2pt 2pt 2pt true true =Fields!morningorafternoon.Value morningorafternoon 0.5pt Middle 2pt 2pt 2pt 2pt After DataSet2 4.37314cm 1.41111cm 5.8369cm 1 5.78425cm Textbox13 0.51552cm 0.4343cm 1.26146cm 8.75963cm 2pt 2pt 2pt 2pt true true 製表日期： =Parameters!report_day.Value 2pt 2pt 2pt 2pt true true 司機： =Parameters!driver_name.Value 2pt 2pt 2pt 2pt 2.3cm 0.10172cm 0cm 18.34854cm 3 true true 銷單日期： =Parameters!order_day.Value 2pt 2pt 2pt 2pt 29.7cm 21cm 0.9cm 0.9cm 0cm 0cm 0.13cm