赵汝健卓越班C#+SQLServer网络系统项目设计基础.docx
《赵汝健卓越班C#+SQLServer网络系统项目设计基础.docx》由会员分享,可在线阅读,更多相关《赵汝健卓越班C#+SQLServer网络系统项目设计基础.docx(16页珍藏版)》请在冰点文库上搜索。
赵汝健卓越班C#+SQLServer网络系统项目设计基础
广东信息科技职业培训学院
软件工程与外包服务学院
企业项目实训书
课程名称:
C#+SQLServer网络系统项目设计基础(C/S)
项目题目:
列车车次基本信息维护系统
年级:
2015
专业:
计算机网络与软件工程
班级:
卓越班
学生:
赵汝健
指导教师:
李三思
主管院领导:
提交时间:
2016年1月28日
广东信息科技职业培训学院编制
备注:
该文档作为学生档案存档,作为实习、就业和上级主管部门检查的重要文件。
1、项目概要
本系统用于列车车次信息维护;功能有(车次信息查询、新增、修改、删除)。
(1)
2、数据库设计
列车车次关系图
2.1数据表
表名
类型
列车_车次
基础表
列车_车次途径站
列车sys_省份
业务表
列车sys_站点
列车sys_类型
2.2业务表及其字段
表1:
列名
数据类型
主键/外键
列车车次ID
Int
主键
列车类型ID
外键
列车车次MC
Nchar
运行时长
里程数
int
站点ID始发
站点ID终点
表2:
途径站ID
车次ID
站点ID
途径站点序号
运行天数
到站时间
离站时间
运行里程
硬座票价
软座票价
硬卧票价
软卧票价
高级软卧
表3:
列车类型
字母简称
动车否
Bit
表4:
省份ID
省份MC
省份PY
省份简称
表5:
站点MC
拼音简称
2.3数据库截图
票价代码:
#region生成票价
privatevoidbtnShengChengPiaoJia_Click(objectsender,EventArgse)
{
cboChuFaZhan.Enabled=false;
cboMuDiZHan.Enabled=false;
for(inti=0;i{dgvTuJingZhan.Rows[i].Cells["站序"].Value=i+1;}int里程=0;for(inti=0;i{里程+=Convert.ToInt32(dgvTuJingZhan.Rows[i+1].Cells["里程"].Value)-Convert.ToInt32(dgvTuJingZhan.Rows[i].Cells["里程"].Value);}txtLiCheng.Text=里程.ToString().Trim();dgvCheZhanPiaoJia.Rows.Clear();if(dgvSheZhiCheXiang.Rows.Count>=2){int里程差;string席位类型;string列车类型=cboCheCiLeiXing.SelectedValue.ToString().Trim();intCount=0;inti=dgvTuJingZhan.Rows.Count-1;for(intCheXiang=0;CheXiang{intbZhanShu=1;for(intChuFaZhanA=0;ChuFaZhanA{i--;for(intChuFaZhanB=0;ChuFaZhanB{dgvCheZhanPiaoJia.Rows.Add();dgvCheZhanPiaoJia.Rows[Count].Cells["出发站ID"].Value=dgvTuJingZhan.Rows[ChuFaZhanA].Cells["车次途径站ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["目的站ID"].Value=dgvTuJingZhan.Rows[ChuFaZhanB+bZhanShu].Cells["车次途径站ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["席位类型ID_1"].Value=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位类型ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["席位类型_1"].Value=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["出发站"].Value=dgvTuJingZhan.Rows[ChuFaZhanA].Cells["站点"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["目的站"].Value=dgvTuJingZhan.Rows[ChuFaZhanB+bN].Cells["站点"].Value;里程差=(Convert.ToInt32(dgvTuJingZhan.Rows[ChuFaZhanB+bZhanShu].Cells["里程"].Value)-Convert.ToInt32(dgvTuJingZhan.Rows[ChuFaZhanA].Cells["里程"].Value));席位类型=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位"].Value.ToString().Trim();if(里程差<=200){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.05861*10);}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((10%里程差)*(0.05861*10));}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.07033*10);}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.10257*10);}}if(里程差>200&&里程差<=500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.052749*30)+11.722;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((30%(里程差-200))*(0.052749*30)+11.722);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.063297*30)+14.066;}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.092313*30)+20.514;}if(里程差>500&&里程差<=1000){}if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.046888*50)+27.5467;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((50%(里程差-500))*(0.046888*50)+27.5467);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.056264*50)+33.0551;//61.1871}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.082056*50)+48.2079;//89.2359}}if(里程差>1000&&里程差<=1500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.041027*50)+50.9907;//71.5042}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((50%(里程差-1000))*(0.041027*50)+50.9907);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.049231*50)+61.1871;//85.8026}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.071799*50)+89.2359;//125.1354}}if(里程差>1500&&里程差<=2500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.035166*100)+71.5042;//106.6702}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((100%(里程差-1500))*(0.035166*100)+71.5042);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.042198*100)+85.8026;//128.0006}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.061542*100)+125.1354;//186.6774}}if(里程差>2500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.029305+106.6702;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((里程差-2500)*0.029305+106.6702);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.035165+128.0006;}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.051285+186.6774;}}Count++;}bZhanShu++;}i=dgvTuJingZhan.Rows.Count-1;}}}#endregion4、技术总结第一次数据库设计、分表、界面设计都摸不清方向,没有多少思路;但是做第二遍的时候就会感觉到思路清晰了许多,有了自己的方向。在写代码时自己有一定的思路,但是就是不能实现出来;就上XX解决问题,多试几次就行了。刚开始自己做系统会遇到很多问题,面对问题,我们要把握好自己的心态就能解决问题,平常时多注意一些细节问题,细节决定成败嘛!凡事都有第一次,但一回生两回熟,一次不行就两次,两次不行就三次
dgvTuJingZhan.Rows[i].Cells["站序"].Value=i+1;
}
int里程=0;
for(inti=0;i{里程+=Convert.ToInt32(dgvTuJingZhan.Rows[i+1].Cells["里程"].Value)-Convert.ToInt32(dgvTuJingZhan.Rows[i].Cells["里程"].Value);}txtLiCheng.Text=里程.ToString().Trim();dgvCheZhanPiaoJia.Rows.Clear();if(dgvSheZhiCheXiang.Rows.Count>=2){int里程差;string席位类型;string列车类型=cboCheCiLeiXing.SelectedValue.ToString().Trim();intCount=0;inti=dgvTuJingZhan.Rows.Count-1;for(intCheXiang=0;CheXiang{intbZhanShu=1;for(intChuFaZhanA=0;ChuFaZhanA{i--;for(intChuFaZhanB=0;ChuFaZhanB{dgvCheZhanPiaoJia.Rows.Add();dgvCheZhanPiaoJia.Rows[Count].Cells["出发站ID"].Value=dgvTuJingZhan.Rows[ChuFaZhanA].Cells["车次途径站ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["目的站ID"].Value=dgvTuJingZhan.Rows[ChuFaZhanB+bZhanShu].Cells["车次途径站ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["席位类型ID_1"].Value=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位类型ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["席位类型_1"].Value=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["出发站"].Value=dgvTuJingZhan.Rows[ChuFaZhanA].Cells["站点"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["目的站"].Value=dgvTuJingZhan.Rows[ChuFaZhanB+bN].Cells["站点"].Value;里程差=(Convert.ToInt32(dgvTuJingZhan.Rows[ChuFaZhanB+bZhanShu].Cells["里程"].Value)-Convert.ToInt32(dgvTuJingZhan.Rows[ChuFaZhanA].Cells["里程"].Value));席位类型=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位"].Value.ToString().Trim();if(里程差<=200){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.05861*10);}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((10%里程差)*(0.05861*10));}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.07033*10);}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.10257*10);}}if(里程差>200&&里程差<=500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.052749*30)+11.722;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((30%(里程差-200))*(0.052749*30)+11.722);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.063297*30)+14.066;}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.092313*30)+20.514;}if(里程差>500&&里程差<=1000){}if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.046888*50)+27.5467;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((50%(里程差-500))*(0.046888*50)+27.5467);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.056264*50)+33.0551;//61.1871}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.082056*50)+48.2079;//89.2359}}if(里程差>1000&&里程差<=1500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.041027*50)+50.9907;//71.5042}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((50%(里程差-1000))*(0.041027*50)+50.9907);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.049231*50)+61.1871;//85.8026}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.071799*50)+89.2359;//125.1354}}if(里程差>1500&&里程差<=2500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.035166*100)+71.5042;//106.6702}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((100%(里程差-1500))*(0.035166*100)+71.5042);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.042198*100)+85.8026;//128.0006}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.061542*100)+125.1354;//186.6774}}if(里程差>2500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.029305+106.6702;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((里程差-2500)*0.029305+106.6702);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.035165+128.0006;}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.051285+186.6774;}}Count++;}bZhanShu++;}i=dgvTuJingZhan.Rows.Count-1;}}}#endregion4、技术总结第一次数据库设计、分表、界面设计都摸不清方向,没有多少思路;但是做第二遍的时候就会感觉到思路清晰了许多,有了自己的方向。在写代码时自己有一定的思路,但是就是不能实现出来;就上XX解决问题,多试几次就行了。刚开始自己做系统会遇到很多问题,面对问题,我们要把握好自己的心态就能解决问题,平常时多注意一些细节问题,细节决定成败嘛!凡事都有第一次,但一回生两回熟,一次不行就两次,两次不行就三次
里程+=Convert.ToInt32(dgvTuJingZhan.Rows[i+1].Cells["里程"].Value)-Convert.ToInt32(dgvTuJingZhan.Rows[i].Cells["里程"].Value);
txtLiCheng.Text=里程.ToString().Trim();
dgvCheZhanPiaoJia.Rows.Clear();
if(dgvSheZhiCheXiang.Rows.Count>=2)
int里程差;
string席位类型;
string列车类型=cboCheCiLeiXing.SelectedValue.ToString().Trim();
intCount=0;
inti=dgvTuJingZhan.Rows.Count-1;
for(intCheXiang=0;CheXiang{intbZhanShu=1;for(intChuFaZhanA=0;ChuFaZhanA{i--;for(intChuFaZhanB=0;ChuFaZhanB{dgvCheZhanPiaoJia.Rows.Add();dgvCheZhanPiaoJia.Rows[Count].Cells["出发站ID"].Value=dgvTuJingZhan.Rows[ChuFaZhanA].Cells["车次途径站ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["目的站ID"].Value=dgvTuJingZhan.Rows[ChuFaZhanB+bZhanShu].Cells["车次途径站ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["席位类型ID_1"].Value=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位类型ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["席位类型_1"].Value=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["出发站"].Value=dgvTuJingZhan.Rows[ChuFaZhanA].Cells["站点"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["目的站"].Value=dgvTuJingZhan.Rows[ChuFaZhanB+bN].Cells["站点"].Value;里程差=(Convert.ToInt32(dgvTuJingZhan.Rows[ChuFaZhanB+bZhanShu].Cells["里程"].Value)-Convert.ToInt32(dgvTuJingZhan.Rows[ChuFaZhanA].Cells["里程"].Value));席位类型=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位"].Value.ToString().Trim();if(里程差<=200){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.05861*10);}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((10%里程差)*(0.05861*10));}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.07033*10);}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.10257*10);}}if(里程差>200&&里程差<=500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.052749*30)+11.722;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((30%(里程差-200))*(0.052749*30)+11.722);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.063297*30)+14.066;}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.092313*30)+20.514;}if(里程差>500&&里程差<=1000){}if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.046888*50)+27.5467;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((50%(里程差-500))*(0.046888*50)+27.5467);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.056264*50)+33.0551;//61.1871}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.082056*50)+48.2079;//89.2359}}if(里程差>1000&&里程差<=1500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.041027*50)+50.9907;//71.5042}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((50%(里程差-1000))*(0.041027*50)+50.9907);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.049231*50)+61.1871;//85.8026}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.071799*50)+89.2359;//125.1354}}if(里程差>1500&&里程差<=2500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.035166*100)+71.5042;//106.6702}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((100%(里程差-1500))*(0.035166*100)+71.5042);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.042198*100)+85.8026;//128.0006}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.061542*100)+125.1354;//186.6774}}if(里程差>2500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.029305+106.6702;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((里程差-2500)*0.029305+106.6702);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.035165+128.0006;}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.051285+186.6774;}}Count++;}bZhanShu++;}i=dgvTuJingZhan.Rows.Count-1;}}}#endregion4、技术总结第一次数据库设计、分表、界面设计都摸不清方向,没有多少思路;但是做第二遍的时候就会感觉到思路清晰了许多,有了自己的方向。在写代码时自己有一定的思路,但是就是不能实现出来;就上XX解决问题,多试几次就行了。刚开始自己做系统会遇到很多问题,面对问题,我们要把握好自己的心态就能解决问题,平常时多注意一些细节问题,细节决定成败嘛!凡事都有第一次,但一回生两回熟,一次不行就两次,两次不行就三次
intbZhanShu=1;
for(intChuFaZhanA=0;ChuFaZhanA{i--;for(intChuFaZhanB=0;ChuFaZhanB{dgvCheZhanPiaoJia.Rows.Add();dgvCheZhanPiaoJia.Rows[Count].Cells["出发站ID"].Value=dgvTuJingZhan.Rows[ChuFaZhanA].Cells["车次途径站ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["目的站ID"].Value=dgvTuJingZhan.Rows[ChuFaZhanB+bZhanShu].Cells["车次途径站ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["席位类型ID_1"].Value=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位类型ID"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["席位类型_1"].Value=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["出发站"].Value=dgvTuJingZhan.Rows[ChuFaZhanA].Cells["站点"].Value;dgvCheZhanPiaoJia.Rows[Count].Cells["目的站"].Value=dgvTuJingZhan.Rows[ChuFaZhanB+bN].Cells["站点"].Value;里程差=(Convert.ToInt32(dgvTuJingZhan.Rows[ChuFaZhanB+bZhanShu].Cells["里程"].Value)-Convert.ToInt32(dgvTuJingZhan.Rows[ChuFaZhanA].Cells["里程"].Value));席位类型=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位"].Value.ToString().Trim();if(里程差<=200){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.05861*10);}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((10%里程差)*(0.05861*10));}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.07033*10);}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.10257*10);}}if(里程差>200&&里程差<=500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.052749*30)+11.722;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((30%(里程差-200))*(0.052749*30)+11.722);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.063297*30)+14.066;}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.092313*30)+20.514;}if(里程差>500&&里程差<=1000){}if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.046888*50)+27.5467;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((50%(里程差-500))*(0.046888*50)+27.5467);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.056264*50)+33.0551;//61.1871}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.082056*50)+48.2079;//89.2359}}if(里程差>1000&&里程差<=1500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.041027*50)+50.9907;//71.5042}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((50%(里程差-1000))*(0.041027*50)+50.9907);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.049231*50)+61.1871;//85.8026}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.071799*50)+89.2359;//125.1354}}if(里程差>1500&&里程差<=2500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.035166*100)+71.5042;//106.6702}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((100%(里程差-1500))*(0.035166*100)+71.5042);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.042198*100)+85.8026;//128.0006}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.061542*100)+125.1354;//186.6774}}if(里程差>2500){if(席位类型=="硬座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.029305+106.6702;}if(席位类型=="软座"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((里程差-2500)*0.029305+106.6702);}if(席位类型=="硬卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.035165+128.0006;}if(席位类型=="软卧"){dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.051285+186.6774;}}Count++;}bZhanShu++;}i=dgvTuJingZhan.Rows.Count-1;}}}#endregion4、技术总结第一次数据库设计、分表、界面设计都摸不清方向,没有多少思路;但是做第二遍的时候就会感觉到思路清晰了许多,有了自己的方向。在写代码时自己有一定的思路,但是就是不能实现出来;就上XX解决问题,多试几次就行了。刚开始自己做系统会遇到很多问题,面对问题,我们要把握好自己的心态就能解决问题,平常时多注意一些细节问题,细节决定成败嘛!凡事都有第一次,但一回生两回熟,一次不行就两次,两次不行就三次
i--;
for(intChuFaZhanB=0;ChuFaZhanB
dgvCheZhanPiaoJia.Rows.Add();
dgvCheZhanPiaoJia.Rows[Count].Cells["出发站ID"].Value=dgvTuJingZhan.Rows[ChuFaZhanA].Cells["车次途径站ID"].Value;
dgvCheZhanPiaoJia.Rows[Count].Cells["目的站ID"].Value=dgvTuJingZhan.Rows[ChuFaZhanB+bZhanShu].Cells["车次途径站ID"].Value;
dgvCheZhanPiaoJia.Rows[Count].Cells["席位类型ID_1"].Value=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位类型ID"].Value;
dgvCheZhanPiaoJia.Rows[Count].Cells["席位类型_1"].Value=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位"].Value;
dgvCheZhanPiaoJia.Rows[Count].Cells["出发站"].Value=dgvTuJingZhan.Rows[ChuFaZhanA].Cells["站点"].Value;
dgvCheZhanPiaoJia.Rows[Count].Cells["目的站"].Value=dgvTuJingZhan.Rows[ChuFaZhanB+bN].Cells["站点"].Value;
里程差=(Convert.ToInt32(dgvTuJingZhan.Rows[ChuFaZhanB+bZhanShu].Cells["里程"].Value)-Convert.ToInt32(dgvTuJingZhan.Rows[ChuFaZhanA].Cells["里程"].Value));
席位类型=dgvSheZhiCheXiang.Rows[CheXiang].Cells["默认席位"].Value.ToString().Trim();
if(里程差<=200)
if(席位类型=="硬座")
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.05861*10);
if(席位类型=="软座")
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((10%里程差)*(0.05861*10));
if(席位类型=="硬卧")
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.07033*10);
if(席位类型=="软卧")
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(10%里程差)*(0.10257*10);
if(里程差>200&&里程差<=500)
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.052749*30)+11.722;
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((30%(里程差-200))*(0.052749*30)+11.722);
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.063297*30)+14.066;
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(30%(里程差-200))*(0.092313*30)+20.514;
if(里程差>500&&里程差<=1000)
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.046888*50)+27.5467;
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((50%(里程差-500))*(0.046888*50)+27.5467);
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.056264*50)+33.0551;//61.1871
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-500))*(0.082056*50)+48.2079;//89.2359
if(里程差>1000&&里程差<=1500)
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.041027*50)+50.9907;//71.5042
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((50%(里程差-1000))*(0.041027*50)+50.9907);
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.049231*50)+61.1871;//85.8026
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(50%(里程差-1000))*(0.071799*50)+89.2359;//125.1354
if(里程差>1500&&里程差<=2500)
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.035166*100)+71.5042;//106.6702
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((100%(里程差-1500))*(0.035166*100)+71.5042);
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.042198*100)+85.8026;//128.0006
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(100%(里程差-1500))*(0.061542*100)+125.1354;//186.6774
if(里程差>2500)
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.029305+106.6702;
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=2*((里程差-2500)*0.029305+106.6702);
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.035165+128.0006;
dgvCheZhanPiaoJia.Rows[Count].Cells["票价"].Value=(里程差-2500)*0.051285+186.6774;
Count++;
bZhanShu++;
i=dgvTuJingZhan.Rows.Count-1;
#endregion
4、技术总结
第一次数据库设计、分表、界面设计都摸不清方向,没有多少思路;但是做第二遍的时候就会感觉到思路清晰了许多,有了自己的方向。
在写代码时自己有一定的思路,但是就是不能实现出来;就上XX解决问题,多试几次就行了。
刚开始自己做系统会遇到很多问题,面对问题,我们要把握好自己的心态就能解决问题,平常时多注意一些细节问题,细节决定成败嘛!
凡事都有第一次,但一回生两回熟,一次不行就两次,两次不行就三次
copyright@ 2008-2023 冰点文库 网站版权所有
经营许可证编号:鄂ICP备19020893号-2