摘要:
1、有两段实现类的属性变量赋值的代码
2、需要比对对变量的赋值是否相同和考虑是否合并这两段代码
3、因为代码行数比较多,肉眼检查效率不高
4、因此采用脚本工具去实现
比对工具链接:
字符串逐行移除指定字符前或后的字符
http://www.lookdaima.com/page/docItemDetail.html?id=2e29f413-0831-4b94-9b0b-b452fbe15c3c
字符串逐行比较:数据表名比对
http://www.lookdaima.com/page/docItemDetail.html?id=9603309f-f742-4cc7-8899-cdc59911f6f1
相关截图:
代码样例
this.FID = Convert.ToInt32(dr["FID"].ToString());
this.AARRP = dr["AARRP"].ToString();
this.AARRTM = dr["AARRTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["AARRTM"].ToString());
this.AFLTNO = dr["AFLTNO"].ToString();
this.AFSTATUS = dr["AFSTATUS"].ToString();
this.AID = dr["AID"].ToString() == "" ? null : (int?)Convert.ToInt32(dr["AID"].ToString());
this.AIRCORP = dr["AIRCORP"].ToString();
this.APASS1 = dr["APASS1"].ToString();
this.APASS2 = dr["APASS2"].ToString();
this.APASSENGERSNUM = dr["APASSENGERSNUM"].ToString();
this.ARARRTM = dr["ARARRTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["ARARRTM"].ToString());
this.ARRVIP = dr["ARRVIP"].ToString();
this.ARTKFTM = dr["ARTKFTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["ARTKFTM"].ToString());
this.ATKFP = dr["ATKFP"].ToString();
this.ATKFTM = dr["ATKFTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["ATKFTM"].ToString());
this.DARRP = dr["DARRP"].ToString();
this.DARRTM = dr["DARRTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["DARRTM"].ToString());
this.DEPVIP = dr["DEPVIP"].ToString();
this.DFLTNO = dr["DFLTNO"].ToString();
this.DFSTATUS = dr["DFSTATUS"].ToString();
this.DID = dr["DID"].ToString() == "" ? null : (int?)Convert.ToInt32(dr["DID"].ToString());
this.DPASS1 = dr["DPASS1"].ToString();
this.DPASS2 = dr["DPASS2"].ToString();
this.DPASSENGERSNUM = dr["DPASSENGERSNUM"].ToString();
this.DRARRTM = dr["DRARRTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["DRARRTM"].ToString());
this.DRTKFTM = dr["DRTKFTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["DRTKFTM"].ToString());
this.DTKFP = dr["DTKFP"].ToString();
this.DTKFTM = dr["DTKFTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["DTKFTM"].ToString());
this.AFLIGHTATTR = dr["AFLIGHTATTR"].ToString();//进港飞行属性
this.DFLIGHTATTR = dr["DFLIGHTATTR"].ToString();//出港飞行属性
this.FLTTYPE = dr["FLTTYPE"].ToString();
this.GATE = dr["GATE"].ToString();
this.GUIDEDOOR = dr["GUIDEDOOR"].ToString();
this.OUTIN = dr["OUTIN"].ToString();
this.PARRTM = dr["PARRTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["PARRTM"].ToString());
this.PLANDATE = dr["PLANDATE"].ToString();
this.PLANEMDL = dr["PLANEMDL"].ToString();
this.PLANENO = dr["PLANENO"].ToString();
this.PORTNO = dr["PORTNO"].ToString();
this.PTKFTM = dr["PTKFTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["PTKFTM"].ToString());
this.SEATS = dr["SEATS"].ToString();
this.SUBCLASSID = dr["SUBCLASSID"].ToString();
this.SVCCLASSID = dr["SVCCLASSID"].ToString();
this.TRANSBELT = dr["TRANSBELT"].ToString();
this.A_SAME_FLTNO = dr["A_SAME_FLTNO"].ToString();
this.D_SAME_FLTNO = dr["D_SAME_FLTNO"].ToString();
this.NOTE = dr["NOTE"].ToString();
复制
this.FID = Convert.ToInt32(dr["FID"].ToString());
this.AARRP = dr["AARRP"].ToString();
this.AARRTM = dr["AARRTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["AARRTM"].ToString());
this.AFLTNO = dr["AFLTNO"].ToString();
this.AFSTATUS = dr["AFSTATUS"].ToString();
this.AID = dr["AID"].ToString() == "" ? null : (int?)Convert.ToInt32(dr["AID"].ToString());
this.AIRCORP = dr["AIRCORP"].ToString();
this.APASS1 = dr["APASS1"].ToString();
this.APASS2 = dr["APASS2"].ToString();
this.APASSENGERSNUM = dr["APASSENGERSNUM"].ToString();
this.ARARRTM = dr["ARARRTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["ARARRTM"].ToString());
this.ARRVIP = dr["ARRVIP"].ToString();
this.ARTKFTM = dr["ARTKFTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["ARTKFTM"].ToString());
this.ATKFP = dr["ATKFP"].ToString();
this.ATKFTM = dr["ATKFTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["ATKFTM"].ToString());
this.DARRTM = dr["DARRTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["DARRTM"].ToString());
this.DEPVIP = dr["DEPVIP"].ToString();
this.DFLTNO = dr["DFLTNO"].ToString();
this.DFSTATUS = dr["DFSTATUS"].ToString();
this.FSTATUS = dr["FSTATUS"].ToString();
this.DID = dr["DID"].ToString() == "" ? null : (int?)Convert.ToInt32(dr["DID"].ToString());
this.DPASS1 = dr["DPASS1"].ToString();
this.DPASS2 = dr["DPASS2"].ToString();
this.DPASSENGERSNUM = dr["DPASSENGERSNUM"].ToString();
this.DRARRTM = dr["DRARRTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["DRARRTM"].ToString());
this.DRTKFTM = dr["DRTKFTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["DRTKFTM"].ToString());
this.DTKFP = dr["DTKFP"].ToString();
this.DARRP = dr["DARRP"].ToString();//出港目的地(对方机场到达地)
this.DTKFTM = dr["DTKFTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["DTKFTM"].ToString());
this.FLIGHTATTR = dr["FLIGHTATTR"].ToString();
this.AFLIGHTATTR = dr["AFLIGHTATTR"].ToString();//进港飞行属性
this.DFLIGHTATTR = dr["DFLIGHTATTR"].ToString();//出港飞行属性
this.FLTTYPE = dr["FLTTYPE"].ToString();
this.GATE = dr["GATE"].ToString();
this.GUIDEDOOR = dr["GUIDEDOOR"].ToString();
this.OUTIN = dr["OUTIN"].ToString();
this.PARRTM = dr["PARRTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["PARRTM"].ToString());
this.PLANDATE = dr["PLANDATE"].ToString();
this.PLANEMDL = dr["PLANEMDL"].ToString();
this.PLANENO = dr["PLANENO"].ToString();
this.PORTNO = dr["PORTNO"].ToString();
this.PTKFTM = dr["PTKFTM"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["PTKFTM"].ToString());
this.SEATS = dr["SEATS"].ToString();
this.SUBCLASSID = dr["SUBCLASSID"].ToString();
this.SVCCLASSID = dr["SVCCLASSID"].ToString();
this.TRANSBELT = dr["TRANSBELT"].ToString();
this.A_SAME_FLTNO = dr["A_SAME_FLTNO"].ToString();
this.D_SAME_FLTNO = dr["D_SAME_FLTNO"].ToString();
this.NOTE = dr["NOTE"].ToString();
this.PreNote = dr["PRENOTE"].ToString();
this.IsImportant = dr["ISIMPORTANT"].ToString();
this.SvcOrganID = dr["SVCORGANID"].ToString();
this.FLTNO = this.AIRCORP + this.AFLTNO;
this.BOARDINGTIME = dr["BOARDINGTIME"].ToString() == "" ? null : (DateTime?)Convert.ToDateTime(dr["BOARDINGTIME"].ToString());
复制
文章转载自看代码,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。
评论
相关阅读
数据库国产化替代深化:DBA的机遇与挑战
代晓磊
1258次阅读
2025-04-27 16:53:22
2025年4月国产数据库中标情况一览:4个千万元级项目,GaussDB与OceanBase大放异彩!
通讯员
731次阅读
2025-04-30 15:24:06
国产数据库需要扩大场景覆盖面才能在竞争中更有优势
白鳝的洞穴
598次阅读
2025-04-14 09:40:20
【活动】分享你的压箱底干货文档,三篇解锁进阶奖励!
墨天轮编辑部
510次阅读
2025-04-17 17:02:24
一页概览:Oracle GoldenGate
甲骨文云技术
478次阅读
2025-04-30 12:17:56
GoldenDB数据库v7.2焕新发布,助力全行业数据库平滑替代
GoldenDB分布式数据库
471次阅读
2025-04-30 12:17:50
优炫数据库成功入围新疆维吾尔自治区行政事业单位数据库2025年框架协议采购!
优炫软件
362次阅读
2025-04-18 10:01:22
给准备学习国产数据库的朋友几点建议
白鳝的洞穴
300次阅读
2025-05-07 10:06:14
XCOPS广州站:从开源自研之争到AI驱动的下一代数据库架构探索
韩锋频道
283次阅读
2025-04-29 10:35:54
国产数据库图谱又上新|82篇精选内容全览达梦数据库
墨天轮编辑部
275次阅读
2025-04-23 12:04:21