foreach (EventAlarm ea in eventList)
{ if (ea.EventStatus == 2)
{ Console.WriteLine("添加");
StringBuilder sbSql = new StringBuilder();
sbSql.Append("INSERT INTO trafficevent VALUES (default,");
sbSql.Append(ea.DetId);
sbSql.Append(",");
sbSql.Append(ea.ZoneId);
sbSql.Append(",");
sbSql.Append(ea.EventType);
sbSql.Append(",'");
sbSql.Append(ea.Timestamp);
sbSql.Append("',");
sbSql.Append(ea.ELevel);
sbSql.Append(",'");
sbSql.Append(ea.ImageName);
sbSql.Append("','");
sbSql.Append(ea.VideoName);
sbSql.Append("','");
sbSql.Append(ea.EActive.ToString());
sbSql.Append("',");
sbSql.Append(ea.EventStatus);
sbSql.Append(")");
Console.WriteLine("sbSql" + sbSql);
bool tf = save(sbSql.ToString()); //保存成功才删除
if (tf == true)
{
eventList.Remove(ea);
}
}
}for (int i = 0; i < eventList.Count;i++)
{
EventAlarm ea = eventList[i]; if (ea.EventStatus == 2)
{ Console.WriteLine("添加");
StringBuilder sbSql = new StringBuilder();
sbSql.Append("INSERT INTO trafficevent VALUES (default,");
sbSql.Append(ea.DetId);
sbSql.Append(",");
sbSql.Append(ea.ZoneId);
sbSql.Append(",");
sbSql.Append(ea.EventType);
sbSql.Append(",'");
sbSql.Append(ea.Timestamp);
sbSql.Append("',");
sbSql.Append(ea.ELevel);
sbSql.Append(",'");
sbSql.Append(ea.ImageName);
sbSql.Append("','");
sbSql.Append(ea.VideoName);
sbSql.Append("','");
sbSql.Append(ea.EActive.ToString());
sbSql.Append("',");
sbSql.Append(ea.EventStatus);
sbSql.Append(")");
Console.WriteLine("sbSql" + sbSql);
bool tf = save(sbSql.ToString()); //保存成功才删除
if (tf == true)
{
//eventList.Remove(ea);
eventList.RemoveAt(i);
}
}
}
大家看到了2段代码似乎一样,但是呢运行之后有一个会报错就是第一段代码:
System.InvalidOperationException中第一次偶然出现的“mscorlib.dll”类型的异常这个异常但是呢第二个不会有这个异常我不明白那里不对....
{ if (ea.EventStatus == 2)
{ Console.WriteLine("添加");
StringBuilder sbSql = new StringBuilder();
sbSql.Append("INSERT INTO trafficevent VALUES (default,");
sbSql.Append(ea.DetId);
sbSql.Append(",");
sbSql.Append(ea.ZoneId);
sbSql.Append(",");
sbSql.Append(ea.EventType);
sbSql.Append(",'");
sbSql.Append(ea.Timestamp);
sbSql.Append("',");
sbSql.Append(ea.ELevel);
sbSql.Append(",'");
sbSql.Append(ea.ImageName);
sbSql.Append("','");
sbSql.Append(ea.VideoName);
sbSql.Append("','");
sbSql.Append(ea.EActive.ToString());
sbSql.Append("',");
sbSql.Append(ea.EventStatus);
sbSql.Append(")");
Console.WriteLine("sbSql" + sbSql);
bool tf = save(sbSql.ToString()); //保存成功才删除
if (tf == true)
{
eventList.Remove(ea);
}
}
}for (int i = 0; i < eventList.Count;i++)
{
EventAlarm ea = eventList[i]; if (ea.EventStatus == 2)
{ Console.WriteLine("添加");
StringBuilder sbSql = new StringBuilder();
sbSql.Append("INSERT INTO trafficevent VALUES (default,");
sbSql.Append(ea.DetId);
sbSql.Append(",");
sbSql.Append(ea.ZoneId);
sbSql.Append(",");
sbSql.Append(ea.EventType);
sbSql.Append(",'");
sbSql.Append(ea.Timestamp);
sbSql.Append("',");
sbSql.Append(ea.ELevel);
sbSql.Append(",'");
sbSql.Append(ea.ImageName);
sbSql.Append("','");
sbSql.Append(ea.VideoName);
sbSql.Append("','");
sbSql.Append(ea.EActive.ToString());
sbSql.Append("',");
sbSql.Append(ea.EventStatus);
sbSql.Append(")");
Console.WriteLine("sbSql" + sbSql);
bool tf = save(sbSql.ToString()); //保存成功才删除
if (tf == true)
{
//eventList.Remove(ea);
eventList.RemoveAt(i);
}
}
}
大家看到了2段代码似乎一样,但是呢运行之后有一个会报错就是第一段代码:
System.InvalidOperationException中第一次偶然出现的“mscorlib.dll”类型的异常这个异常但是呢第二个不会有这个异常我不明白那里不对....
解决方案 »
- C# 如何删除计算机内指定证书
- 串口调试助手接收数据时为什么可以自动识别数据是16位或是32位的?
- class或者struct中存取数据的问题?
- ISO-2022-JP编码问题求解~~急啊
- 怎样使Sqlconnection的连接具有通用性?
- 解析xml字符串问题,请帮忙,谢谢!
- 写文件的问题!
- C#。winform 窗体跳转,数据传输,涉及父窗体,子窗体
- WPF,TextBlock的这种写法是什么属性支持的?
- 急,在线等待,,,实现局域网内两台机器的目录文件同步,为什么我做了一个WIN服务安装的时候出错,大家帮我看看???(吐血分,分不够
- winform中新窗口打开 旧的窗口不能点选 如何实现
- 利用飞信真能做到不用netframework吗?
可以先记录下来,最后一次性删除
listStr.Remove(list[0]);
listStr.RemoveAt(1);
foreach是只读的访问,被foreach循环访问的集合是不允许修改的。
哦这样啊学习了我在这个循环之上还有一个循环这个循环做了修改,这个没有问题啊?你说的只读? foreach (EventAlarm ea in eventList)
{
string imgFile = "";
if (ea.Timestamp == WATTS1.Timestamp.ToString() && ea.DetId == WATTS1.DetectorId && ea.ZoneId == WATTS1.eDetectorZone)
{
WATTS1.ImageFile(ref imgFile); if (imgFile.Substring(0, 2) == "WI")
{
ea.VideoName = imgFile;
ea.EventStatus = 2;
}
else if (imgFile.Substring(0, 2) == "PW")
{
ea.ImageName = imgFile;
ea.EventStatus = 1;
}
}
}