本文整理汇总了C#中System.Data.Common.DbCommand.Cancel方法的典型用法代码示例。如果您正苦于以下问题:C# DbCommand.Cancel方法的具体用法?C# DbCommand.Cancel怎么用?C# DbCommand.Cancel使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbCommand
的用法示例。
在下文中一共展示了DbCommand.Cancel方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: timer1_Tick
//.........这里部分代码省略.........
{
dates = readReader.GetDateTime(0).ToString("yyyy/MM/dd HH:mm:ss.fff");
rec.Datetime = readReader.GetDateTime(0).AddMinutes(zone).ToString("yyyy/MM/dd HH:mm:ss.fff");
}
catch
{
L.Log(LogType.FILE, LogLevel.ERROR, "Convertion failure in DateTime : " + readReader.GetValue(0).ToString());
}
rec.CustomStr2 = readReader.GetString(1).ToString();
rec.Description = readReader.GetString(2).ToString();
rec.EventType = readReader.GetValue(3).ToString();
rec.EventCategory = readReader.GetString(4).ToString();
try
{
rec.CustomInt1 = Convert.ToInt32(readReader.GetValue(5).ToString());
}
catch (Exception e1) { L.Log(LogType.FILE, LogLevel.DEBUG, e1.Message); }
try
{
rec.CustomInt2 = Convert.ToInt32(readReader.GetValue(6).ToString());
}
catch (Exception e2) { L.Log(LogType.FILE, LogLevel.DEBUG, e2.Message); }
rec.EventId = Convert.ToInt64(readReader.GetValue(7).ToString());
rec.CustomStr4 = readReader.GetString(8).ToString();
rec.CustomStr3 = readReader.GetString(9).ToString();
rec.CustomStr1 = readReader.GetString(10).ToString();
if (readReader.GetValue(11).ToString().Length > 899 && readReader.GetValue(11).ToString().Length < 1800)
{
rec.CustomStr5 = readReader.GetString(11).ToString().Substring(0, 899);
rec.CustomStr7 = readReader.GetString(11).ToString().Substring(900, 1799);
}
else if (readReader.GetValue(11).ToString().Length < 899 )
rec.CustomStr5 = readReader.GetString(11).ToString();
rec.CustomStr6 = readReader.GetString(12).ToString();
rec.CustomStr8 = readReader.GetString(13).ToString();
rec.CustomStr9 = readReader.GetString(14).ToString();
rec.CustomStr10 = readReader.GetString(15).ToString();
}
catch (Exception bd)
{
L.Log(LogType.FILE, LogLevel.ERROR, "Bad data recieved" + bd.ToString());
continue;
}
//eyer tarih bir onceki tarih ile ayni ise repeat numberi artir
dates = dates.Substring(0, 19);
L.Log(LogType.FILE, LogLevel.DEBUG, "Lastrecord : " + dates );
repeat_recordnum = 0;
L.Log(LogType.FILE, LogLevel.DEBUG, "Start sending Data");
if (usingRegistery)
{
s.SetData(rec); //datayi gonder
}
else
{
s.SetData(Dal,Virtualhost,rec); //datayi gonder
}
L.Log(LogType.FILE, LogLevel.DEBUG, "Finish Sending Data");
//bakilan en son record
lastRecordDate = dates + "%" + repeat_recordnum.ToString();
L.Log(LogType.FILE, LogLevel.DEBUG, "Record Number is " + lastRecordDate);
//2007/12/18 14:54:15.000
dates = rec.Datetime.Substring(0, 19);
i++;
if (i > max_record_send)
{
L.Log(LogType.FILE, LogLevel.INFORM, "Reached MAX RECORD SEND number");
//son bakilan recordu registerye kaydet
cmd.Cancel();
dates = rec.Datetime.Substring(0, 19);
Set_Registry(lastRecordDate, rec.Datetime.Substring(0, 19));
// lastRecordDate += "%" + repeat_recordnum.ToString();
return;
}
}//end of if
else
{
repeat -= 1;
}
}
#endregion
////son bakilan recordu registerye kaydet
//lastRecordDate += "%" + repeat_recordnum.ToString();
L.Log(LogType.FILE, LogLevel.DEBUG, "Set last date to registery");
//Set_Registry(lastRecordDate,rec.Datetime);
conn.Close();
readReader.Close();
}
catch (Exception er)
{
L.LogTimed(LogType.FILE, LogLevel.ERROR, er.ToString());
L.Log(LogType.FILE, LogLevel.ERROR, "Line could not parsed : " + readReader.GetValue(0) + " " + readReader.GetValue(1) + " " + readReader.GetValue(2));
}
finally
{
timer1.Enabled = true;
L.Log(LogType.FILE, LogLevel.INFORM, "Service Stopped");
s.Dispose();
}
}