个人开源小项目 — 车辆费用统计程序（C# Winform）

花费了2天半写完了一个统计程序，自认非常的失败，现在写完了

就在这里写一下文章，开放全部源代码，欢迎大家来交流

car

car2

项目由于是用VS08进行编写，所以解决方案为VS9的，我手动更改了一下sln和csproj文件的版本号

不知道是否可行，这个生成没什么经验，请大家赐教

项目文件只提供VS08和VS05版本

——————-项目说明————————-

软件是老爸要求我来做的，当时想进行快速开发的，刚开始使用VC++进行托管开发

后来转到C#用Winform进行开发

程序基于Visual Studio 2008与.NET Framework 2.0进行开发

程序使用了DataGridView进行数据显示修改等功能

——————-软件说明————————-

本软件为方便有车一族能更好的对车辆使用费用进行统计

软件可对车辆花费的路费与油费进行录入和统计,并存放到数据库中

您可以在总览标签当中对数据进行修改与删除

本软件为本人第一个Winform程序，可能会有bug或者不方便之处

我会不断更新软件和优化，希望您能喜欢

软件采用C#编写，需要.net Framework 2.0的支持，数据库采用Access数据库

—————–缺少功能列表———————–

数据库检测：如果数据库不存在则抛出错误

目标思路：检测如果数据库不存在则创建数据库文件

数据库完善：添加停车费用或者其他费用，添加备注功能

添加加油量记录（考虑是否增加）

添加过路费,加油费,洗车费,维修费,保险费

统计功能增加：增加油费与路费的比例计算

增加计算每公里油费计算

去除本次统计功能（去除数据表），更改总统计代码（考虑）

或者调整本次统计的实现代码，实现更改数据表中其中一项更新后本次统计中的数据也随之更新

功能完善：对日期进行校验，如果添加日期大于今天的日期则不给添加

对输入框输入的小数进行限制，限制为最多2位小数

数据库备份功能：增加数据库备份功能，避免数据丢失

界面优化：修改添加数据的界面，使之更人性化，功能更多

数据表提供分组列表以及日期顺序的显示方式

——————-更新记录————————-

2009.6.19

Version 0.86

调整窗口位置

2009.6.18

Version 0.85

添加路费单独统计与油费单独统计功能

调整窗口大小

2009.6.18

Version 0.80

基本可用成品编写完毕

修正一些bug与修改提示

2009.6.16

Version 0.10

开始构建并编写代码

——————-程序下载————————

车辆费用统计程序 (310)

——————-项目文件————————

车辆费用统计程序-项目源码 (362)

您可能会对以下文章感兴趣:

Loading…

开源项目 CSharp, Winform, 开源, 项目

六月 19th, 2009 By 小鬼我来说两句

首页 > 开源项目 > 个人开源小项目 — 车辆费用统计程序（C# Winform）

« 暂停更新几天 — 为升级做准备该死的插件！！ »

评论 (77) Trackback 我来说两句

锐志博客

十一月 27th, 2009 at 22:37 | #61

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

呵呵我来啦！！
锐志博客在他的blog中写下的美文 >> ๑۩۞۩๑ 经典SQL语句大全(二)๑۩۞۩๑

[回复]
小鬼回复:
十二月 28th, 2009 at 22:39
@锐志博客, 呵呵，欢迎欢迎

[回复]
Gonten

十一月 29th, 2009 at 20:27 | #62

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

很不错，，c#很强大，但我个人老不喜欢，要安装.net框架
Gonten在他的blog中写下的美文 >> ๑۩۞۩๑ QQ牧场里动物做爱的那些事儿【图】๑۩۞۩๑

[回复]
小鬼回复:
十二月 28th, 2009 at 22:40
@Gonten, 现在不用担心这个了吧，系统都自带了

[回复]
搂着鱼睡的猫

十二月 2nd, 2009 at 06:22 | #63

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

博主很有才
搂着鱼睡的猫在他的blog中写下的美文 >> ๑۩۞۩๑ 在楼顶照了几张失败的照片๑۩۞۩๑

[回复]
开心凡人

十二月 20th, 2009 at 03:44 | #64

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

周末到这里借人气暖和下,实在是太冷了呵呵

[回复]
小鬼回复:
十二月 28th, 2009 at 22:39
@开心凡人, 呵呵，暖气费拿来

[回复]
程控交换机

十二月 22nd, 2009 at 22:13 | #65

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

你们家是开加油站的啊？

[回复]
小鬼回复:
十二月 28th, 2009 at 22:39
@程控交换机, 不好意思，我家不开加油站

[回复]
非博

十二月 30th, 2009 at 21:19 | #66

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

这个好像很不错！
非博在他的blog中写下的美文 >> ๑۩۞۩๑ 回忆永远是美好的！๑۩۞۩๑

[回复]
老七

十二月 31st, 2009 at 19:53 | #67

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

哎呀我还是无视代码吧。。。元旦快乐第一次来。~~
老七在他的blog中写下的美文 >> ๑۩۞۩๑ 老七博客谷歌PR升到3了。๑۩۞۩๑

[回复]
小鬼回复:
一月 1st, 2010 at 00:42
@老七, 元旦快乐~~~

[回复]
风舞清扬

一月 8th, 2010 at 04:00 | #68

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

呵呵，2005的我用用哈，不错
风舞清扬在他的blog中写下的美文 >> ๑۩۞۩๑ Firfox的一些使用小技巧๑۩۞۩๑

[回复]
小鬼回复:
一月 9th, 2010 at 13:15
@风舞清扬, 喜欢就好

[回复]
壹小时

一月 8th, 2010 at 22:11 | #69

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

c#ide这个工具太强大了
壹小时在他的blog中写下的美文 >> ๑۩۞۩๑ 微软bing算法太垃圾๑۩۞۩๑

[回复]
小鬼回复:
一月 9th, 2010 at 13:15
@壹小时, 呵呵，还是不错的

[回复]
老七

一月 9th, 2010 at 02:24 | #70

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

博主好厉害。。膜拜
老七在他的blog中写下的美文 >> ๑۩۞۩๑ QQ拼音开始支持加速QQ等级๑۩۞۩๑

[回复]
小鬼回复:
一月 9th, 2010 at 13:15
@老七, 过奖过奖，小打小闹~

[回复]
邓玮

一月 10th, 2010 at 12:00 | #71

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

我记得我以前也写了很多这样的东西，可到现在啥都不会了。。希望博主。。

[回复]
小鬼回复:
一月 10th, 2010 at 13:43
@邓玮, 呵呵，会继续加油额

[回复]
土狼妹妹

一月 12th, 2010 at 10:28 | #72

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

需要认证学习

[回复]
浅笑

二月 6th, 2010 at 16:11 | #73

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

呵呵，不错啊

[回复]
浪漫小屋

二月 9th, 2010 at 22:04 | #74

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

厉害,帮顶

[回复]
生活

二月 20th, 2010 at 23:17 | #75

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

博主真强大，赞一个。

[回复]
51biger

三月 11th, 2010 at 00:48 | #76

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

主是界面不够美观

[回复]
jaycn

三月 11th, 2010 at 01:32 | #77

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' ' at line 3]
SELECT comment_author,comment_author_email,comment_author_url,count( comment_author_email ) AS cmtcount FROM WHERE comment_approved =1 AND comment_author_email !='qzliuyuzou@gmail.com' AND comment_type = '' AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<30 GROUP BY comment_author_email ORDER BY cmtcount DESC LIMIT 0 ,1500

回复引用

非常不错。。。。。。

[回复]

评论分页.

« 上一页 1 2 3 4

可以使用的Html标签: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">

Trackbacks (1 ) 详情 Trackback

╬小鬼地带╬

个人开源小项目 — 车辆费用统计程序（C# Winform）

您可能会对以下文章感兴趣:

小站动态

Translation

最新评论

分类目录

友情链接

收藏链接

最近文章

功能