private E_ERROR_CODE insertDeviceToDb() { string message = string.Empty; List <List <CDbParameter> > recordTable = new List <List <CDbParameter> >(); foreach (CBeiDouDevice beiDevice in _InsertDeviceArray) { List <CDbParameter> recordParameter = beiDevice.convert2DbParameterList(); if (recordParameter != null) { recordTable.Add(recordParameter); } else { message = string.Format("Conver device<{0}> to db parameter list faild.", beiDevice.Id); _SystemLog.writeLog(LOG_LEVEL.ERR, message); } } int addDeviceCount = 0; bool dbConnectionsaveRecords = _DbConnection.saveRecords(CBeiDouDevice.INSERT_RECORD_SQL, recordTable, CBeiDouDevice.getFieldNameList(), out addDeviceCount); message = string.Format("Add <{0}> devices to db.", addDeviceCount); _SystemLog.writeLog(LOG_LEVEL.INFO, message); return(dbConnectionsaveRecords ? E_ERROR_CODE.OK : E_ERROR_CODE.ERROR); }
public bool save2Db() { int addRecordCount = 0; List <List <CDbParameter> > recordTable = new List <List <CDbParameter> >(); List <CDbParameter> recordParameter = convert2DbParameterList(); if (recordParameter != null) { recordTable.Add(recordParameter); } else { message = string.Format("Conver device<{0}> to db parameter list faild.", Id); _SystemLog.writeLog(LOG_LEVEL.ERR, message); return(false); } return(_DbConnection.saveRecords(INSERT_RECORD_SQL, recordTable, getFieldNameList(), out addRecordCount)); }