public bool AddManualControlBoardInfo(Model.ManualControlBoard manualControlBoard) { int intEffectiveRows = 0; try { //StringBuilder sbSQL = new StringBuilder("REPLACE INTO ManualControlBoard(ID,Code, BoardNo ,SubBoardNo ,KeyNo , DeviceCode , SDPKey ,controllerID) "); //sbSQL.Append("VALUES("); //sbSQL.Append(manualControlBoard.ID + ","); //sbSQL.Append(manualControlBoard.Code + ",'"); //sbSQL.Append(manualControlBoard.BoardNo + "','"); //sbSQL.Append(manualControlBoard.SubBoardNo + "','"); //sbSQL.Append(manualControlBoard.KeyNo + "','"); //sbSQL.Append(manualControlBoard.DeviceCode + "','"); //sbSQL.Append(manualControlBoard.SDPKey + "','"); //sbSQL.Append(manualControlBoard.ControllerID + "');"); //intEffectiveRows = _databaseService.ExecuteBySql(sbSQL); intEffectiveRows = _dbFileVersionService.AddManualControlBoardInfo(manualControlBoard); } catch { intEffectiveRows = 0; } if (intEffectiveRows > 0) { return(true); } else { return(false); } }