开发软件以查找员工进行实地考察和支付旅行费用时的距离. [英] Develope software to find distance during site visit of its employee and paid travelling expences..

问题描述

亲爱的团队，
我想开发一种软​​件来计算员工在实地考察期间的行进距离，并根据它来支付旅行费用.根据员工的指定，每公里支付的费用也遵循食品费用.三组员工类别，一组以75卢比为食物每顿午餐或晚餐，第二次为100卢比，第三次为125卢比.每公里分为两类，一类为自行车，第二类为汽车.
我想在-
中开发软件 Visual C#中的源代码，
基于前置窗口，
MS访问中的数据库.
如何设计项目，我创建多少张表，源代码以计算员工的行进距离和带薪旅行费用.

Dear team,
I want to develope software to calculate distance travelled by employees during site visit and paid travelling expences according to its.Paid per kilometer according employee designation , this criteria follow on food expences also.Employee categories in three group, one group take 75 Rupees for food per lunch or diner,second on 100 Rs and third one 125 rs.Per kilometer paid in two categories one for bike and second for car.
I want to develope software in-
Source code in visual c#,
Fronted window based,
Database in MS access.
How to design project,How many table i create,source code to calculate distance travelled by employee and paid travelling expences.

推荐答案

首先查看数据-您需要三种类型的员工，每种都有自己的食品费用费率(在我看来是至关重要的……)，以及两种类型的车辆，每种都有自己的每公里费率.您可以将这些简单的选择编码到列表框中，但是由于费率可能会发生变化，因此，如果您为每个表创建一个小表并在数据输入表单中使用链接到每个表的查找，那么结果会更快乐.

您还将需要一个旅行表，其中可能包含旅行者的姓名，员工类型，车辆类型，里程表的起始读数和里程表的终止读数.如果您有很多旅客，请考虑将此表放在一个单独的表中，以便您可以使用列表框查找姓名(以及可能的员工类别和车辆类型).

使用Access使用这些表创建数据库，然后在Visual Studio中创建Windows窗体应用程序.在数据源"菜单上，单击添加数据源"，然后将向导指向Access数据库，以添加与数据库的连接，并将所有表和字段导入项目中.

有了这些之后，您就可以开始编码了.当您在代码示例方面又取得了一些进展后，我们可以提供更具体的指导.

顺便说一句，如果这是一个可以帮助您学习C#的项目，那将是一个很好的项目-足以完成一些教学工作，但又足够简单，不会令人沮丧.但是，如果您只需要花点时间完成工作，就可以轻松地单独使用Access来完成所需的所有工作，从而节省大量工作.它不是一个好的数据库系统，但是对于这种简单的东西来说已经足够了.

Start by looking at the data - you need three types of employee, each with its own food expense rate (criminal to my mind...), and two types of vehicle, each with its own per-kilometer rate. You could code these simple choices into listboxes, but since the rates may change you''ll be happier with the result if you create a small table for each and use a lookup linked to each table in your data entry form.

You''ll also need a table for trips, probably containing the traveler''s name, employee type, vehicle type, starting odometer reading, and ending odometer reading. If you have a lot of travelers, consider making this a separate table so that you can look up the name (and possibly the employee class and vehicle type) using a listbox.

Create your database with these tables using Access, then create a Windows Forms application in Visual Studio. On the Data Sources menu, Add a Datasource and point the wizard to your Access database to add a connection to the database and import all the tables and fields to your project.

With these in place, you''re ready to start coding. When you''ve made some progress post again with code samples and we can offer more specific guidance.

By the way, if this is a project to help you learn C#, it''s a good one - hard enough to do some teaching, but simple enough not to be frustrating. But if you just need to bang something out for work that just gets the job done, you can easily do all that you require using Access alone and save yourself a lot of work. It''s not a great database system, but for something this simple it''s more than adequate.

这篇关于开发软件以查找员工进行实地考察和支付旅行费用时的距离.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！