public List <CDbParameter> convert2DbParameterList() { //,,, List <CDbParameter> recordParameters = new List <CDbParameter>(); CDbParameter idParameter = new CDbParameter() { ParameterName = ID, ParameterValue = Id }; recordParameters.Add(idParameter); /* * " VALUES(@ID,@NAME,@HAS_CAMER,@RTSP_ADDRESS,"+ * "@LAST_MODIFY_TIME,@DEVICE_TYPE,@DEVICE_STATE,@LONGITUDE,@LATITUDE,@ALTITUDE,@ORGANIZATION_CODE,@LAST_LOCATE_TIME,"+ * "@LONGITUDE_DIRECTION,@LATITUDE_DIRECTION,@AVERAGE_SPEED,@IS_DELETED,@DESCRIPTION)"; * */ CDbParameter nameParameter = new CDbParameter() { ParameterName = NAME, ParameterValue = Name }; recordParameters.Add(nameParameter); CDbParameter hasCameraParameter = new CDbParameter() { ParameterName = HAS_CAMER, ParameterValue = Convert.ToInt16(HasCamer) }; recordParameters.Add(hasCameraParameter); CDbParameter rtspAddressParameter = new CDbParameter() { ParameterName = RTSP_ADDRESS, ParameterValue = RtspAddress }; recordParameters.Add(rtspAddressParameter); CDbParameter lastModifyTimeParameter = new CDbParameter() { ParameterName = LAST_MODIFY_TIME, ParameterValue = CPublic.getDateTimeString(LastModifyTime) }; recordParameters.Add(lastModifyTimeParameter); CDbParameter deviceTypeParameter = new CDbParameter() { ParameterName = DEVICE_TYPE, ParameterValue = (int)DeviceType }; recordParameters.Add(deviceTypeParameter); CDbParameter deviceStateParameter = new CDbParameter() { ParameterName = DEVICE_STATE, ParameterValue = DeviceState }; recordParameters.Add(deviceStateParameter); CDbParameter longitudeParameter = new CDbParameter() { ParameterName = LONGITUDE, ParameterValue = Longitude }; recordParameters.Add(longitudeParameter); CDbParameter latitudeParameter = new CDbParameter() { ParameterName = LATITUDE, ParameterValue = Latitude }; recordParameters.Add(latitudeParameter); CDbParameter altitudeParameter = new CDbParameter() { ParameterName = ALTITUDE, ParameterValue = Altitude }; recordParameters.Add(altitudeParameter); CDbParameter organizationCodeParameter = new CDbParameter() { ParameterName = ORGANIZATION_CODE, ParameterValue = OrganizationCode }; recordParameters.Add(organizationCodeParameter); CDbParameter lastLocateTimeParameter = new CDbParameter() { ParameterName = LAST_LOCATE_TIME, ParameterValue = LastLocateTime }; recordParameters.Add(lastLocateTimeParameter); CDbParameter longitudeDirectionParameter = new CDbParameter() { ParameterName = LONGITUDE_DIRECTION, ParameterValue = LongitudeDirection }; recordParameters.Add(longitudeDirectionParameter); CDbParameter latitudeDirectionParameter = new CDbParameter() { ParameterName = LATITUDE_DIRECTION, ParameterValue = LatitudeDirection }; recordParameters.Add(latitudeDirectionParameter); CDbParameter averageSpeedParameter = new CDbParameter() { ParameterName = AVERAGE_SPEED, ParameterValue = AverageSpeed }; recordParameters.Add(averageSpeedParameter); CDbParameter isDeletedParameter = new CDbParameter() { ParameterName = IS_DELETED, ParameterValue = Convert.ToInt16(IsDeleted) }; recordParameters.Add(isDeletedParameter); CDbParameter descriptionParameter = new CDbParameter() { ParameterName = DESCRIPTION, ParameterValue = Description }; recordParameters.Add(descriptionParameter); return(recordParameters); }
static int Main(string[] args) { string message = string.Empty; _SystemConfig = new CSystemConfig(); if (_SystemConfig.getErrorCode() != 0) { return(1); } E_ERROR_CODE errorCode = loadConfigData(); if (errorCode != E_ERROR_CODE.OK) { return((int)errorCode); } _DbConnection = new CDbConnection(_DbConnectStr, _SystemLog); if (!_DbConnection.testConnect()) { _SystemLog.disposeLogWriter(); return((int)E_ERROR_CODE.ERROR_CONNECT_DB_FAILED); } initLocalVaribles(); while (true) { _BeiDouDeviceManager.processBeiDevice(); message = string.Format("Run cycle <{0}>, Next run time <{1}>....", _RequestCycle, CPublic.getDateTimeString(DateTime.Now.AddSeconds(_RequestCycle))); _SystemLog.writeLog(LOG_LEVEL.WARNING, message); Thread.Sleep(TimeSpan.FromSeconds(_RequestCycle)); } }