html.action sqldatetime 溢出,System.Data.SqlTypes.SqlTypeException:SqlDateTime溢出

这段代码展示了如何通过遍历多个事件列表,根据日期精确匹配并插入到'CycleTbl'中,处理了485、412、500和502事件的数据。遇到错误时,会显示错误消息。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

try

{

DateTime date = DateTime.MinValue;

date = AllEventsSortedList[0].dateTime;

foreach (Event m485 in _485List)

{

CycleTbl nCycle = new CycleTbl();

nCycle._485_DateTime = m485.dateTime;

nCycle.OrderNumber = m485.OrderNumber;

nCycle.Source = m485.Source;

nCycle.Dest = m485.Destination;

foreach (Event m412 in _412List)

{

if ((m485.dateTime.Year == m412.dateTime.Year) && (m485.dateTime.Month == m412.dateTime.Month) && (m485.dateTime.Day == m412.dateTime.Day))

nCycle._412_DateTime = (DateTime)m412.dateTime;

}

foreach (Event m500 in _500List)

{

if ((m485.dateTime.Year == m500.dateTime.Year) && (m485.dateTime.Month == m500.dateTime.Month) && (m485.dateTime.Day == m500.dateTime.Day))

nCycle._500_DateTime = (DateTime)m500.dateTime;

}

foreach (Event m502 in _502list)

{

if ((m485.dateTime.Year == m502.dateTime.Year) && (m485.dateTime.Month == m502.dateTime.Month) && (m485.dateTime.Day == m502.dateTime.Day))

{

nCycle._502_DateTime = m502.dateTime;

nCycle.LGVNumber = (int)m502.LGVNumber;

}

}

nCycle._502_DateTime = (DateTime)date;

LgvDB.CycleTbls.InsertOnSubmit(nCycle);

LgvDB.SubmitChanges();

}

}

catch (Exception ex)

{

MessageBox.Show("Error in building the table." + Environment.NewLine + ex.Message);

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值