使用C#2008&创建发票MS Access [英] Creating an invoice using C# 2008 & MS Access

问题描述

我已经创建了一个库存控制&本地鞋子展示厅的销售系统. 一个客户可以同时购买一双或多双鞋子. 每次购买都必须有一张收据作为发票发给客户.
同时，数据将保存在MS Access数据库表中.我对MS Access数据库中的保存数据没有任何疑问.
但是我有一个问题，我该如何使用Crystal Report 为每个单独的客户打印发票 ?

实际上，我担心的是如何能够提取单个客户拥有的数据记录?最近购买过这双鞋的客户?

I have created an inventory control & sales system for a local shoe showroom. One customer can buy one or more shoes at the same time. Each purchase must have a receipt to be issued as an invoice to the customer.
At the same time the data will be saved in an MS Access database table. I have no any doubts about the saving data within MS Access database.
But I have a question that how can I be able to print such an invoice to each individual customer using Crystal Report?

Actually I am concerning about that how am I able to extract the data records that owns to a single customer? The most recent customer that has purchased the shoes?

推荐答案

听起来您正在苦苦挣扎的是如何知道要为谁打印发票.您将数据放入Access数据库中，然后需要打印发票，但是不确定要打印哪个发票.我的建议是在每个发票条目上放置一个指示符值(Access中的true/false字段将起作用)，以指示该条目是否已被打印.然后，您只需打印所有尚未打印的内容，然后将已打印的内容标记为已打印.最终结果是您不必弄清楚或猜测哪个客户需要打印发票.您只需打印未打印的内容即可.

What it sounds like you are struggling with is how to know who to print the invoice out for. You put the data into the Access database and then you need to print an invoice but you aren''t sure which invoice to print. My recommendation would be to put an indicator value (a true/false field in Access will work) on each invoice entry that indicates if the entry has been printed. Then, you simply print all the ones that haven''t been printed and then mark those that were printed as printed. The end result is that you don''t have to figure out or guess which customer needs to have an invoice printed. You just print the unprinted ones.

这篇关于使用C#2008&创建发票MS Access的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！