public static void HandlerData()
{
if (typeList == null)
{
try
{
using (var cdb = new DbContext <IllegalType>(strConnV4))
{
typeList = cdb.Set <IllegalType>().ToList();
cdb.Dispose();
}
_logger.InfoFormat(string.Format("加载V4平台的违法类型成功!"));
}
catch (Exception e)
{
_faillogger.Error(string.Format("加载V4平台的违法类型异常:{0}!", e.Message));
}
}
#region
if (lastTime == null)
{
lastTime = Start;
}
if (EndTime == null)
{
EndTime = DateTime.Now;
}
if (lastTime >= EndTime)
{
_logger.InfoFormat(string.Format("数据转换导出完成，起始时间{0},最后一次执行时间{1}", Start.ToString(), lastTime.ToString()));
return;
}
List <IllegalVehicle> realList = null;
DateTime time = ((DateTime)lastTime).AddMinutes(count);
try
{
_logger.InfoFormat("开始查询V2数据!");
DateTime newtime = time.AddMinutes(-count);
_logger.InfoFormat(string.Format("查询V2数据，开始时间{0},结束时间{1}", newtime.ToString(), time.ToString()));
lastTime = time;
//var where = new Dictionary<string, object>();
//where.Add("Timestamp", new DateTime?[] { });
//where.Add("Status", 6);
//realList = _objectAccess.Select<IllegalVehicle>(where).ToList();
using (var cdb = new DbContext <IllegalVehicle>(strConnV2))
{
realList = cdb.Set <IllegalVehicle>().Where(p => p.Status == 6 && p.Timestamp >= newtime && p.Timestamp < time).ToList();
cdb.Dispose();
}
}
catch (Exception e)
{
_faillogger.Error(string.Format("处理违法异常,开始时间{0},结束时间{1}!", time.ToString(), time.AddMinutes(count).ToString()));
_faillogger.Error("查询数据异常，异常原因!" + e.Message);
}
if (realList != null && realList.Count > 0)
{
_logger.InfoFormat(string.Format("获取到V2违法数据,开始时间{0},结束时间{1},总共{2}条！", time.ToString(), time.AddMinutes(count).ToString(), realList.Count));
try
{
using (var cdb = new DbContext <IllegalVehicleReal>(strConnV4))
{
//进行过违法数据转换，入库
foreach (var item in realList)
{
IllegalVehicleReal real = new IllegalVehicleReal()
{
#region
ProcessId = "",//item.Processid.ToString("N"),
SpottingId = item.Crossingid,
SpottingName = item.Crossingname,
DirectionId = item.Directionid,
DirectionName = item.Directionname,
LaneNo = item.Laneid,
OccurTime = item.Timestamp,
RunSpeed = item.Runspeed,
PlateNo = item.Plateno,
PlateColor = item.Platecolorid,
PlateType = item.Platetype,
VehicleBrand = item.Vehiclebrand,
VehicleColor = item.Vehiclecolor,
PanoramaimageUrl1 = item.Panoramaimageurl,
PanoramaimageUrl2 = "",
PanoramaimageUrl3 = "",
PanoramaimageUrl4 = "",
FeatureimageUrl = item.Featureimageurl,
IllegalTypeNo = GetIllegalCode(item.Legalizeillegaltypeno, item.Illegaltypeid),
//IllegalTypeNo=item.IllegalTypeId,
Inputer = "",
InputTime = null,
AreaCode = item.Areacode,
//存在问题
DepartmentId = item.Departmentid.ToString(),
CreatedTime = item.Createdtime,
CheckTime = item.Checktime,
Checker = item.Checker,
Scraper = item.Scraper,
ScrapTime = item.Scraptime,
ScrapreasonNo = item.Scrapreason.ToString(),
Status = "1004",
InquiryFlag = item.Inquiryflag,
IsUnrecognizedPlateNo = item.Isunrecognizedplateno,
SerialId = item.Serialid,
EffectiveDate = item.Effectivedate,
EngineCode = item.Enginecode,
IdentificationName = item.Identificationname,
IdentificationNo = item.Identificationno,
OwnerMobileNumber = item.Ownermobilenumber,
OwnerName = item.Ownername,
BusLoad = item.Busload.ToString(),
VehicleBrandAlias = item.Vehiclebrandalias,
VehicleIdentificationNo = item.Vehicleidentificationno,
VehicleStatus = item.Vehiclestatus,
LicenceIssuingAuthority = item.Licenceissuingauthority,
VehicleBrandInTraffics = item.Vehiclebrandintraffics,
VehicleColorInTraffics = item.Vehiclecolorintraffics,
VehicleModel = item.Vehiclemodel,
HomeAddress = item.Homeaddress,
HomeArea = item.Homearea,
PhoneNumber = item.Phonenumber,
VehicleType = item.Vehicletype,
UseProperty = item.Useproperty,
ForeIgnvoucherNo = "",
UploadPerson = item.Uploadperson,
UpdateTime = item.Updatetime,
UploadStatus = item.Uploadstatus,
Remark = item.Remark,
PenaltyAmount = item.Penaltyamount,
DeductionScore = item.Deductionscore,
PenaltyAmountFlag = item.Penaltyamountflag,
//ProcessingDepartment=item.ProcessingDepartment,
LegalizeIllegalTypeNo = item.Legalizeillegaltypeno,
UploadNo = item.Uploadno,
CheckCode = item.Checkcode,
RepeatCheck = Convert.ToBoolean(item.Repeatcheck) ? 1 : 0,
PlatenoLocation = item.Platenolocation,
DistingUishable = 1,
UploadTime = item.Updatetime,
AssetsNo = item.Assetsid,
AssetsName = item.Assetsname,
PoliceChecker = "",
PoliceCheckTime = null,
UploadFailCount = item.Uploadfailcount,
PunishFlag = null,
VideoUrl = "",
IsVideo = null,
CollectMode = "",
VehicleLength = null,
ExportedFlag = null,
ExportedTime = null,
IsCommon = Convert.ToBoolean(item.Repeatcheck)? 0 :1,
RuleId = "",
IsSediment = 0,
ConvertedTime = null,
ConvertedIllegalTypeNo = "",
LimitedSpeed = null,
ScrapType = ""
#endregion
};
cdb.Set <IllegalVehicleReal>().Add(real);
}
cdb.SaveChanges();
cdb.Dispose();
_faillogger.Error(string.Format("处理违法转换到V4版本库成功{2}条,开始时间{0},结束时间{1}!", time.ToString(), time.AddMinutes(count).ToString(), realList.Count));
}
}
catch (Exception e)
{
_faillogger.Error(string.Format("处理违法转换到V4版本库异常,开始时间{0},结束时间{1}!", time.ToString(), time.AddMinutes(count).ToString()));
}
}
else
{
_logger.InfoFormat(string.Format("未获取到V2违法数据,开始时间{0},结束时间{1}！", time.ToString(), time.AddMinutes(count).ToString()));
}
#endregion
}
public static void HandlerData()
{
//_objectAccess = _serviceProviderFactory.Default.Resolve("OracleDbContext") as IObjectAccess;
if (typeList == null)
{
try
{
using (var cdb = new DbContext<IllegalType>(strConnV4))
{
typeList = cdb.Set<IllegalType>().ToList();
cdb.Dispose();
}
_logger.InfoFormat(string.Format("加载V4平台的违法类型成功!"));
}
catch (Exception e)
{
_faillogger.Error(string.Format("加载V4平台的违法类型异常:{0}!", e.Message));
}
}
#region
if (lastTime == null)
{
lastTime = Start;
}
if (EndTime == null)
{
EndTime = DateTime.Now;
}
if (lastTime >= EndTime)
{
_logger.InfoFormat(string.Format("数据转换导出完成，起始时间{0},最后一次执行时间{1}", Start.ToString(), lastTime.ToString()));
return;
}
List<IllegalVehicle> realList = null;
DataTable table = new DataTable();
DateTime time = ((DateTime)lastTime).AddMinutes(count);
DateTime newtime = time.AddMinutes(-count);
string newsql = string.Empty;
try
{
_logger.InfoFormat("开始查询V2数据!");
_logger.InfoFormat(string.Format("查询V2数据，开始时间{0},结束时间{1}", newtime.ToString(), time.ToString()));
lastTime = time;
var where = new Dictionary<string, object>();
where.Add("Timestamp", new DateTime?[] { });
where.Add("Status", 6);
//realList = _objectAccess.Select<IllegalVehicle>(where).ToList();
using (OracleConnection conn = new OracleConnection(strConnV2))
{
if (string.IsNullOrEmpty(Sql))
{
//newsql = "select * from punish_illegalvehicle where \"Status\" = 60 and \"Timestamp\" > = to_date({0},'yyyy/MM/dd HH24:mi:ss') and \"Timestamp\" < to_date({1},'yyyy/MM/dd HH24:mi:ss')";
newsql = "select * from punish_illegalvehicle where \"Status\" = 60 and \"Timestamp\" > = to_date(:starttime,'yyyy/MM/dd HH24:mi:ss') and \"Timestamp\" < to_date(:endtime,'yyyy/MM/dd HH24:mi:ss')";
//newsql = "select * from punish_illegalvehicle";
}
else
{
newsql = Sql;
}
OracleDataAdapter oda = new OracleDataAdapter(newsql, conn);
//newsql = string.Format(newsql, newtime.ToString("yyyy-MM-dd HH:mm:ss"),EndTime.ToString("yyyy-MM-dd HH:mm:ss"));
oda.SelectCommand.Parameters.Add(new OracleParameter(":starttime", newtime.ToString()));
oda.SelectCommand.Parameters.Add(new OracleParameter(":endtime", time.ToString()));
oda.Fill(table);
}
//using (var cdb = new DbContext<IllegalVehicle>(strConnV2))
//{
// realList = cdb.Set<IllegalVehicle>().Where(p => p.Status == 6 && p.Timestamp >= newtime && p.Timestamp < time).ToList();
// cdb.Dispose();
//}
}
catch (Exception e)
{
_faillogger.Error(string.Format("处理违法异常,开始时间{0},结束时间{1}!", newtime.ToString(), time.ToString()));
_faillogger.Error("查询数据异常，异常原因!" + e.ToString() + ",异常sql:" + newsql);
}
if (table != null && table.Rows.Count > 0)
{
_logger.InfoFormat(string.Format("获取到V2违法数据,开始时间{0},结束时间{1},总共{2}条！", newtime.ToString(), time.ToString(), table.Rows.Count));
try
{
DataTable valueSet = new DataTable();
using (OracleConnection conn = new OracleConnection(strConnV4))
{
OracleDataAdapter oda = new OracleDataAdapter("select * from PUNISH_ILLEGALVEHICLE_REAL where 1=0", conn);
oda.Fill(valueSet);
}
#region table的操作方式
//进行过违法数据转换，入库
//foreach (DataRow item in table.Rows)
//{
// #region
// DataRow rovaw = valueSet.NewRow();
// rovaw["PROCESSID"] = Guid.NewGuid().ToString("N");
// rovaw["SPOTTINGID"] = item["CrossingId"].ToString();
// rovaw["SPOTTINGNAME"] = item["CrossingName"].ToString();
// rovaw["DIRECTIONID"] = item["DirectionId"].ToString();
// rovaw["DIRECTIONNAME"] = item["DirectionName"].ToString();
// rovaw["LANENO"] = item["LaneId"].ToString();
// rovaw["OCCURTIME"] = string.IsNullOrEmpty(item["Timestamp"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(item["Timestamp"].ToString());
// rovaw["RUNSPEED"] = Convert.ToInt32(item["RunSpeed"].ToString());
// rovaw["PLATENO"] = item["PlateNo"].ToString();
// rovaw["PLATECOLOR"] = GetPlateColor(item["PlateColorId"].ToString());
// rovaw["PLATETYPE"] = item["PlateType"].ToString();
// rovaw["VEHICLEBRAND"] = item["VehicleBrand"].ToString();
// rovaw["VEHICLECOLOR"] = item["VehicleColor"].ToString();
// rovaw["PANORAMAIMAGEURL1"] = item["PanoramaImageUrl"].ToString();
// rovaw["PANORAMAIMAGEURL2"] = "";
// rovaw["PANORAMAIMAGEURL3"] = "";
// rovaw["PANORAMAIMAGEURL4"] = "";
// rovaw["FEATUREIMAGEURL"] = item["FeatureImageUrl"].ToString();
// rovaw["ILLEGALTYPENO"] = GetIllegalCode(item["LegalizeIllegalTypeNo"].ToString(), item["IllegalTypeId"].ToString());
// //IllegalTypeNo=item["IllegalTypeId"].ToString(),
// rovaw["Inputer"] = "";
// rovaw["InputTime"] = null;
// rovaw["AreaCode"] = item["AreaCode"].ToString();
// //存在问题
// rovaw["DepartmentId"] = GetDepartment(item["DepartmentId"].ToString());
// rovaw["CreatedTime"] = string.IsNullOrEmpty(item["CreatedTime"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(item["CreatedTime"].ToString());
// rovaw["CheckTime"] = string.IsNullOrEmpty(item["CheckTime"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(item["CheckTime"].ToString());
// rovaw["Checker"] = item["Checker"].ToString();
// rovaw["Scraper"] = item["Scraper"].ToString();
// rovaw["ScrapTime"] = string.IsNullOrEmpty(item["ScrapTime"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(item["ScrapTime"].ToString());
// rovaw["ScrapreasonNo"] = item["ScrapReason"].ToString();
// rovaw["Status"] = "1004";
// rovaw["InquiryFlag"] = Convert.ToInt32(item["InquiryFlag"].ToString());
// rovaw["IsUnrecognizedPlateNo"] = Convert.ToInt32(item["IsUnrecognizedPlateNo"].ToString());
// rovaw["SerialId"] = item["SerialId"].ToString();
// rovaw["EffectiveDate"] = string.IsNullOrEmpty(item["EffectiveDate"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(item["EffectiveDate"].ToString());
// rovaw["EngineCode"] = item["EngineCode"].ToString();
// rovaw["IdentificationName"] = item["IdentificationName"].ToString();
// rovaw["IdentificationNo"] = item["IdentificationNo"].ToString();
// rovaw["OwnerMobileNumber"] = item["OwnerMobileNumber"].ToString();
// rovaw["OwnerName"] = item["OwnerName"].ToString();
// rovaw["BusLoad"] = item["Busload"].ToString();
// rovaw["VehicleBrandAlias"] = item["VehicleBrandAlias"].ToString();
// rovaw["VehicleIdentificationNo"] = item["VehicleIdentificationNo"].ToString();
// rovaw["VehicleStatus"] = item["VehicleStatus"].ToString();
// rovaw["LicenceIssuingAuthority"] = item["LicenceIssuingAuthority"].ToString();
// rovaw["VehicleBrandInTraffics"] = item["VehicleBrandInTraffics"].ToString();
// rovaw["VehicleColorInTraffics"] = item["VehicleColorInTraffics"].ToString();
// rovaw["VehicleModel"] = item["VehicleModel"].ToString();
// rovaw["HomeAddress"] = item["HomeAddress"].ToString();
// rovaw["HomeArea"] = item["HomeArea"].ToString();
// rovaw["PhoneNumber"] = item["PhoneNumber"].ToString();
// rovaw["VehicleType"] = item["VehicleType"].ToString();
// rovaw["UseProperty"] = item["UseProperty"].ToString();
// rovaw["ForeIgnvoucherNo"] = "";
// rovaw["UploadPerson"] = item["UploadPerson"].ToString();
// rovaw["UpdateTime"] = string.IsNullOrEmpty(item["UpdateTime"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(item["UpdateTime"].ToString());
// rovaw["UploadStatus"] = item["UploadStatus"].ToString();
// rovaw["Remark"] = "V2平台数据导入，" + item["Remark"].ToString();
// rovaw["PenaltyAmount"] = Convert.ToInt32(item["PenaltyAmount"].ToString());
// rovaw["DeductionScore"] = Convert.ToInt32(item["DeductionScore"].ToString());
// rovaw["PenaltyAmountFlag"] = Convert.ToInt32(item["PenaltyAmountFlag"].ToString());
// rovaw["ProcessingDepartment"] = GetDepartment(item["ProcessingDepartment"].ToString());
// rovaw["LegalizeIllegalTypeNo"] = item["LegalizeIllegalTypeNo"].ToString();
// rovaw["UploadNo"] = item["UploadNo"].ToString();
// rovaw["CheckCode"] = item["CheckCode"].ToString();
// rovaw["RepeatCheck"] = Convert.ToInt32(item["RepeatCheck"].ToString());
// rovaw["PlatenoLocation"] = item["PlateNoLocation"].ToString();
// rovaw["DistingUishable"] = 1;
// rovaw["UploadTime"] = string.IsNullOrEmpty(item["UpdateTime"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(item["UpdateTime"].ToString());
// rovaw["AssetsNo"] = item["AssetsId"].ToString();
// rovaw["AssetsName"] = item["AssetsName"].ToString();
// rovaw["PoliceChecker"] = "";
// rovaw["PoliceCheckTime"] = null;
// rovaw["UploadFailCount"] = Convert.ToInt32(item["UploadFailCount"].ToString());
// rovaw["PunishFlag"] = null;
// rovaw["VideoUrl"] = "";
// rovaw["IsVideo"] = null;
// rovaw["CollectMode"] = "";
// rovaw["VehicleLength"] = null;
// rovaw["ExportedFlag"] = null;
// rovaw["ExportedTime"] = null;
// rovaw["IsCommon"] = Convert.ToInt32(item["RepeatCheck"].ToString()) == 0 ? 1 : 0;
// rovaw["RuleId"] = "";
// rovaw["IsSediment"] = 0;
// rovaw["vertedTime"] = null;
// rovaw["vertedIllegalTypeNo"] = "";
// rovaw["itedSpeed"] = null;
// rovaw["apType"] = "";
// #endregion
//}
#endregion
#region EF的操作方式
using (var cdb = new DbContext<IllegalVehicleReal>(strConnV4))
{
//进行过违法数据转换，入库
foreach (DataRow item in table.Rows)
{
//ASCIIEncoding condding = new ASCIIEncoding();
//string guid = System.Text.Encoding.Default.GetString((byte[])item["ProcessId"]);
IllegalVehicleReal real = new IllegalVehicleReal()
{
#region
ProcessId = Guid.NewGuid().ToString("N"),
SpottingId = item["CrossingId"].ToString().Trim().Trim(),
SpottingName = item["CrossingName"].ToString().Trim(),
DirectionId = item["DirectionId"].ToString().Trim(),
DirectionName = item["DirectionName"].ToString().Trim(),
LaneNo = item["LaneId"].ToString().Trim(),
OccurTime = string.IsNullOrEmpty(item["Timestamp"].ToString().Trim()) ? DateTime.MinValue : Convert.ToDateTime(item["Timestamp"].ToString().Trim()),
RunSpeed = Convert.ToInt32(item["RunSpeed"].ToString().Trim()),
PlateNo = item["PlateNo"].ToString().Trim(),
PlateColor = DataFormat("PlateColor", item["PlateColorId"].ToString().Trim()),
PlateType = DataFormat("PlateType", item["PlateTypeId"].ToString().Trim()),
VehicleBrand = item["VehicleBrand"].ToString().Trim(),
VehicleColor = item["VehicleColor"].ToString().Trim(),
PanoramaimageUrl1 = item["PanoramaImageUrl"].ToString().Trim(),
PanoramaimageUrl2 = "",
PanoramaimageUrl3 = "",
PanoramaimageUrl4 = "",
FeatureimageUrl = item["FeatureImageUrl"].ToString().Trim(),
IllegalTypeNo = GetIllegalCode(item["LegalizeIllegalTypeNo"].ToString().Trim(), item["IllegalTypeId"].ToString().Trim()),
//IllegalTypeNo=item["IllegalTypeId"].ToString().Trim(),
Inputer = item["PoliceChecker"].ToString().Trim(),
InputTime = string.IsNullOrEmpty(item["PoliceCheckTime"].ToString().Trim()) ? DateTime.MinValue : Convert.ToDateTime(item["PoliceCheckTime"].ToString().Trim()),
CheckTime = string.IsNullOrEmpty(item["CheckTime"].ToString().Trim()) ? DateTime.MinValue : Convert.ToDateTime(item["CheckTime"].ToString().Trim()),
Checker = item["Checker"].ToString().Trim(),
Scraper = item["Scraper"].ToString().Trim(),
ScrapTime = string.IsNullOrEmpty(item["ScrapTime"].ToString().Trim()) ? DateTime.MinValue : Convert.ToDateTime(item["ScrapTime"].ToString().Trim()),
ScrapreasonNo = item["ScrapReason"].ToString().Trim(),
UploadPerson = item["UploadPerson"].ToString().Trim(),
UpdateTime = string.IsNullOrEmpty(item["UpdateTime"].ToString().Trim()) ? DateTime.MinValue : Convert.ToDateTime(item["UpdateTime"].ToString().Trim()),
AreaCode = item["AreaCode"].ToString().Trim(),
DepartmentId = DataFormat("DepartmentId", item["DepartmentId"].ToString().Trim()),
CreatedTime = string.IsNullOrEmpty(item["CreatedTime"].ToString().Trim()) ? DateTime.MinValue : Convert.ToDateTime(item["CreatedTime"].ToString().Trim()),
Status = "1004",
InquiryFlag = Convert.ToInt32(item["InquiryFlag"].ToString().Trim()),
IsUnrecognizedPlateNo = Convert.ToInt32(item["IsUnrecognizedPlateNo"].ToString().Trim()),
SerialId = item["SerialId"].ToString().Trim(),
EffectiveDate = string.IsNullOrEmpty(item["EffectiveDate"].ToString().Trim()) ? DateTime.MinValue : Convert.ToDateTime(item["EffectiveDate"].ToString().Trim()),
EngineCode = item["EngineCode"].ToString().Trim(),
IdentificationName = item["IdentificationName"].ToString().Trim(),
IdentificationNo = item["IdentificationNo"].ToString().Trim(),
OwnerMobileNumber = item["OwnerMobileNumber"].ToString().Trim(),
OwnerName = item["OwnerName"].ToString().Trim(),
BusLoad = item["Busload"].ToString().Trim(),
VehicleBrandAlias = item["VehicleBrandAlias"].ToString().Trim(),
VehicleIdentificationNo = item["VehicleIdentificationNo"].ToString().Trim(),
VehicleStatus = item["VehicleStatus"].ToString().Trim(),
LicenceIssuingAuthority = item["LicenceIssuingAuthority"].ToString().Trim(),
VehicleBrandInTraffics = item["VehicleBrandInTraffics"].ToString().Trim(),
VehicleColorInTraffics = item["VehicleColorInTraffics"].ToString().Trim(),
VehicleModel = item["VehicleModel"].ToString().Trim(),
HomeAddress = item["HomeAddress"].ToString().Trim(),
HomeArea = item["HomeArea"].ToString().Trim(),
PhoneNumber = item["PhoneNumber"].ToString().Trim(),
VehicleType = item["VehicleType"].ToString().Trim(),
UseProperty = item["UseProperty"].ToString().Trim(),
ForeIgnvoucherNo = "",
UploadStatus = item["UploadStatus"].ToString().Trim(),
Remark = "V2平台数据导入，" + item["Remark"].ToString().Trim() + "导入时间：" + DateTime.Now.ToString().Trim(),
PenaltyAmount = Convert.ToInt32(item["PenaltyAmount"].ToString().Trim()),
DeductionScore = Convert.ToInt32(item["DeductionScore"].ToString().Trim()),
PenaltyAmountFlag = Convert.ToInt32(item["PenaltyAmountFlag"].ToString().Trim()),
ProcessingDepartment = DataFormat("DepartmentId", item["ProcessingDepartment"].ToString().Trim()),
LegalizeIllegalTypeNo = item["LegalizeIllegalTypeNo"].ToString().Trim(),
UploadNo = item["UploadNo"].ToString().Trim(),
CheckCode = item["CheckCode"].ToString().Trim(),
RepeatCheck = Convert.ToInt32(item["RepeatCheck"].ToString().Trim()),
PlatenoLocation = item["PlateNoLocation"].ToString().Trim(),
DistingUishable = 1,
UploadTime = string.IsNullOrEmpty(item["UpdateTime"].ToString().Trim()) ? DateTime.MinValue : Convert.ToDateTime(item["UpdateTime"].ToString().Trim()),
AssetsNo = item["AssetsId"].ToString().Trim(),
AssetsName = item["AssetsName"].ToString().Trim(),
PoliceChecker = "",
PoliceCheckTime = null,
UploadFailCount = Convert.ToInt32(item["UploadFailCount"].ToString().Trim()),
PunishFlag = null,
VideoUrl = "",
IsVideo = null,
CollectMode = "",
VehicleLength = null,
ExportedFlag = null,
ExportedTime = null,
IsCommon = Convert.ToInt32(item["RepeatCheck"].ToString().Trim()) == 0 ? 1 : 0,
RuleId = "",
IsSediment = 0,
ConvertedTime = null,
ConvertedIllegalTypeNo = "",
LimitedSpeed = null,
ScrapType = ""
#endregion
};
cdb.Set<IllegalVehicleReal>().Add(real);
}
cdb.SaveChanges();
cdb.Dispose();
_logger.InfoFormat(string.Format("处理违法转换到V4版本库成功{2}条,开始时间{0},结束时间{1}!", newtime.ToString(), time.ToString(), table.Rows.Count));
}
#endregion
}
catch (Exception e)
{
_faillogger.Error(string.Format("处理违法转换到V4版本库异常,开始时间{0},结束时间{1}!,异常原因{2}", newtime.ToString(), time.ToString(), e.ToString()));
}
}
else
{
_logger.InfoFormat(string.Format("未获取到V2违法数据,开始时间{0},结束时间{1}！", newtime.ToString(), time.ToString()));
}
#endregion
}
